18/12/2014 16:32:54: Execution started. 18/12/2014 16:32:54: QlikView Version:11.00.11414.0 18/12/2014 16:32:54: CPU Target x64 18/12/2014 16:32:54: Operating System Windows 7 Professional Service Pack 1 (64 bit edition) 18/12/2014 16:32:54: Wow64 mode Not using Wow64 18/12/2014 16:32:54: MDAC Version 6.1.7601.17514 18/12/2014 16:32:54: MDAC Full Install Version 6.1.7601.17514 18/12/2014 16:32:54: PreferredCompression 2 18/12/2014 16:32:54: EnableParallelReload 1 18/12/2014 16:32:54: ParallelizeQvdLoads 1 18/12/2014 16:32:54: AutoSaveAfterReload 0 18/12/2014 16:32:54: BackupBeforeReload 0 18/12/2014 16:32:54: EnableFlushLog 0 18/12/2014 16:32:54: SaveInfoWhenSavingFile 0 18/12/2014 16:32:54: UserLogfileCharset 0 18/12/2014 16:32:54: OdbcLoginTimeout -1 18/12/2014 16:32:54: OdbcConnectionTimeout -1 18/12/2014 16:32:54: ScriptWantsDbWrite false 18/12/2014 16:32:54: ScriptWantsExe false 18/12/2014 16:32:54: LogFile CodePage Used: 1252 18/12/2014 16:32:54: 0002 SET ThousandSep=',' 18/12/2014 16:32:54: 0003 SET DecimalSep='.' 18/12/2014 16:32:54: 0004 SET MoneyThousandSep=',' 18/12/2014 16:32:54: 0005 SET MoneyDecimalSep='.' 18/12/2014 16:32:54: 0006 SET MoneyFormat='£#,##0.00;-£#,##0.00' 18/12/2014 16:32:54: 0007 SET TimeFormat='hh:mm:ss' 18/12/2014 16:32:54: 0008 SET DateFormat='DD/MM/YYYY' 18/12/2014 16:32:54: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]' 18/12/2014 16:32:54: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec' 18/12/2014 16:32:54: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun' 18/12/2014 16:32:54: 0013 Let vFileDate = Date(Today(),'DD_MM_YYYY') 18/12/2014 16:32:54: 0016 [Doc ID Desc]: 18/12/2014 16:32:54: 0017 18/12/2014 16:32:54: 0018 LOAD [DOC Desc], 18/12/2014 16:32:54: 0019 [DOC ID], 18/12/2014 16:32:54: 0020 Group, 18/12/2014 16:32:54: 0021 Hierarchy 18/12/2014 16:32:54: 0022 FROM 18/12/2014 16:32:54: 0023 [S:\ICS Credit Control Shared\MANAGEMENT INFORMATION\PUBLISH\KH\Invoices & Credits\Data Files\DOC ID's.csv] 18/12/2014 16:32:54: 0024 (txt, codepage is 1252, embedded labels, delimiter is ',', msq) 18/12/2014 16:32:54: 4 fields found: DOC Desc, DOC ID, Group, Hierarchy, 74 lines fetched 18/12/2014 16:32:54: 1023 Daybooks: 18/12/2014 16:32:54: 1024 18/12/2014 16:32:54: 1025 18/12/2014 16:32:54: 1026 18/12/2014 16:32:54: 1027 LOAD Company, 18/12/2014 16:32:54: 1028 Ledger, 18/12/2014 16:32:54: 1029 AC1, 18/12/2014 16:32:54: 1030 Region, 18/12/2014 16:32:54: 1031 AC2, 18/12/2014 16:32:54: 1032 Controller, 18/12/2014 16:32:54: 1033 AC3, 18/12/2014 16:32:54: 1034 [SC/NAM], 18/12/2014 16:32:54: 1035 AC4, 18/12/2014 16:32:54: 1036 [Grp A/C / Cycle], 18/12/2014 16:32:54: 1037 [Legacy Account], 18/12/2014 16:32:54: 1038 Customer, 18/12/2014 16:32:54: 1039 Name, 18/12/2014 16:32:54: 1040 Status, 18/12/2014 16:32:54: 1041 [Credit Control Status], 18/12/2014 16:32:54: 1042 [Doc Type], 18/12/2014 16:32:54: 1043 [DOC ID], 18/12/2014 16:32:54: 1044 [Doc Number], 18/12/2014 16:32:54: 1045 Reference, 18/12/2014 16:32:54: 1046 [Document Date], 18/12/2014 16:32:54: 1047 [Due Date], 18/12/2014 16:32:54: 1048 [Update Date], 18/12/2014 16:32:54: 1049 Value, 18/12/2014 16:32:54: 1050 [VAT Code], 18/12/2014 16:32:54: 1051 VAT, 18/12/2014 16:32:54: 1052 Goods, 18/12/2014 16:32:54: 1053 [Month End], 18/12/2014 16:32:54: 1054 Tier 18/12/2014 16:32:54: 1055 FROM 18/12/2014 16:32:54: 1056 [S:\ICS Credit Control Shared\MANAGEMENT INFORMATION\PUBLISH\KH\Invoices & Credits\Daybooks_ME1401_to_ME1411.qvd] 18/12/2014 16:32:54: 1057 (qvd) 18/12/2014 16:32:55: 28 fields found: Company, Ledger, AC1, Region, AC2, Controller, AC3, SC/NAM, AC4, Grp A/C / Cycle, Legacy Account, Customer, Name, Status, Credit Control Status, Doc Type, DOC ID, Doc Number, Reference, Document Date, Due Date, Update Date, Value, VAT Code, VAT, Goods, Month End, Tier, 1,458,819 lines fetched 18/12/2014 16:33:05: 1061 LOAD Company, 18/12/2014 16:33:05: 1062 Ledger, 18/12/2014 16:33:05: 1063 AC1, 18/12/2014 16:33:05: 1064 [Area Code] as Region, 18/12/2014 16:33:05: 1065 AC2, 18/12/2014 16:33:05: 1066 Controller, 18/12/2014 16:33:05: 1067 AC3, 18/12/2014 16:33:05: 1068 [Service Centre] as [SC/NAM], 18/12/2014 16:33:05: 1069 AC4, 18/12/2014 16:33:05: 1070 [Credit Cycle] as [Grp A/C / Cycle], 18/12/2014 16:33:05: 1071 [Legacy Account], 18/12/2014 16:33:05: 1072 Customer, 18/12/2014 16:33:05: 1073 Name, 18/12/2014 16:33:05: 1074 Status, 18/12/2014 16:33:05: 1075 [Credit Control Status], 18/12/2014 16:33:05: 1076 [Doc Type], 18/12/2014 16:33:05: 1077 [Doc ID] as [DOC ID], 18/12/2014 16:33:05: 1078 [Doc Number], 18/12/2014 16:33:05: 1079 Reference, 18/12/2014 16:33:05: 1080 [Document Date], 18/12/2014 16:33:05: 1081 [Due Date], 18/12/2014 16:33:05: 1082 [Update Date], 18/12/2014 16:33:05: 1083 Value, 18/12/2014 16:33:05: 1084 [VAT Code], 18/12/2014 16:33:05: 1085 VAT, 18/12/2014 16:33:05: 1086 Goods, 18/12/2014 16:33:05: 1087 Date(Today()) as [Month End], 18/12/2014 16:33:05: 1088 left(AC2,2) as Tier 18/12/2014 16:33:05: 1089 FROM 18/12/2014 16:33:05: 1090 [Z:\oalive60\Repository\29\MI_029_DBPD_CPD_298*.csv] 18/12/2014 16:33:05: 1091 (txt, utf8, embedded labels, delimiter is ',', msq, header is 3 lines) 18/12/2014 16:33:05: 1092 18/12/2014 16:33:05: 1093 where floor(FileTime())=today() 18/12/2014 16:33:05: 28 fields found: Company, Ledger, AC1, Region, AC2, Controller, AC3, SC/NAM, AC4, Grp A/C / Cycle, Legacy Account, Customer, Name, Status, Credit Control Status, Doc Type, DOC ID, Doc Number, Reference, Document Date, Due Date, Update Date, Value, VAT Code, VAT, Goods, Month End, Tier, 1,458,819 lines fetched 18/12/2014 16:33:05: 1061 LOAD Company, 18/12/2014 16:33:05: 1062 Ledger, 18/12/2014 16:33:05: 1063 AC1, 18/12/2014 16:33:05: 1064 [Area Code] as Region, 18/12/2014 16:33:05: 1065 AC2, 18/12/2014 16:33:05: 1066 Controller, 18/12/2014 16:33:05: 1067 AC3, 18/12/2014 16:33:05: 1068 [Service Centre] as [SC/NAM], 18/12/2014 16:33:05: 1069 AC4, 18/12/2014 16:33:05: 1070 [Credit Cycle] as [Grp A/C / Cycle], 18/12/2014 16:33:05: 1071 [Legacy Account], 18/12/2014 16:33:05: 1072 Customer, 18/12/2014 16:33:05: 1073 Name, 18/12/2014 16:33:05: 1074 Status, 18/12/2014 16:33:05: 1075 [Credit Control Status], 18/12/2014 16:33:05: 1076 [Doc Type], 18/12/2014 16:33:05: 1077 [Doc ID] as [DOC ID], 18/12/2014 16:33:05: 1078 [Doc Number], 18/12/2014 16:33:05: 1079 Reference, 18/12/2014 16:33:05: 1080 [Document Date], 18/12/2014 16:33:05: 1081 [Due Date], 18/12/2014 16:33:05: 1082 [Update Date], 18/12/2014 16:33:05: 1083 Value, 18/12/2014 16:33:05: 1084 [VAT Code], 18/12/2014 16:33:05: 1085 VAT, 18/12/2014 16:33:05: 1086 Goods, 18/12/2014 16:33:05: 1087 Date(Today()) as [Month End], 18/12/2014 16:33:05: 1088 left(AC2,2) as Tier 18/12/2014 16:33:05: 1089 FROM 18/12/2014 16:33:05: 1090 [Z:\oalive60\Repository\29\MI_029_DBPD_CPD_298*.csv] 18/12/2014 16:33:05: 1091 (txt, utf8, embedded labels, delimiter is ',', msq, header is 3 lines) 18/12/2014 16:33:05: 1092 18/12/2014 16:33:05: 1093 where floor(FileTime())=today() 18/12/2014 16:33:06: 28 fields found: Company, Ledger, AC1, Region, AC2, Controller, AC3, SC/NAM, AC4, Grp A/C / Cycle, Legacy Account, Customer, Name, Status, Credit Control Status, Doc Type, DOC ID, Doc Number, Reference, Document Date, Due Date, Update Date, Value, VAT Code, VAT, Goods, Month End, Tier, 1,458,819 lines fetched 18/12/2014 16:33:06: 1061 LOAD Company, 18/12/2014 16:33:06: 1062 Ledger, 18/12/2014 16:33:06: 1063 AC1, 18/12/2014 16:33:06: 1064 [Area Code] as Region, 18/12/2014 16:33:06: 1065 AC2, 18/12/2014 16:33:06: 1066 Controller, 18/12/2014 16:33:06: 1067 AC3, 18/12/2014 16:33:06: 1068 [Service Centre] as [SC/NAM], 18/12/2014 16:33:06: 1069 AC4, 18/12/2014 16:33:06: 1070 [Credit Cycle] as [Grp A/C / Cycle], 18/12/2014 16:33:06: 1071 [Legacy Account], 18/12/2014 16:33:06: 1072 Customer, 18/12/2014 16:33:06: 1073 Name, 18/12/2014 16:33:06: 1074 Status, 18/12/2014 16:33:06: 1075 [Credit Control Status], 18/12/2014 16:33:06: 1076 [Doc Type], 18/12/2014 16:33:06: 1077 [Doc ID] as [DOC ID], 18/12/2014 16:33:06: 1078 [Doc Number], 18/12/2014 16:33:06: 1079 Reference, 18/12/2014 16:33:06: 1080 [Document Date], 18/12/2014 16:33:06: 1081 [Due Date], 18/12/2014 16:33:06: 1082 [Update Date], 18/12/2014 16:33:06: 1083 Value, 18/12/2014 16:33:06: 1084 [VAT Code], 18/12/2014 16:33:06: 1085 VAT, 18/12/2014 16:33:06: 1086 Goods, 18/12/2014 16:33:06: 1087 Date(Today()) as [Month End], 18/12/2014 16:33:06: 1088 left(AC2,2) as Tier 18/12/2014 16:33:06: 1089 FROM 18/12/2014 16:33:06: 1090 [Z:\oalive60\Repository\29\MI_029_DBPD_CPD_298*.csv] 18/12/2014 16:33:06: 1091 (txt, utf8, embedded labels, delimiter is ',', msq, header is 3 lines) 18/12/2014 16:33:06: 1092 18/12/2014 16:33:06: 1093 where floor(FileTime())=today() 18/12/2014 16:33:06: 28 fields found: Company, Ledger, AC1, Region, AC2, Controller, AC3, SC/NAM, AC4, Grp A/C / Cycle, Legacy Account, Customer, Name, Status, Credit Control Status, Doc Type, DOC ID, Doc Number, Reference, Document Date, Due Date, Update Date, Value, VAT Code, VAT, Goods, Month End, Tier, 1,466,133 lines fetched 18/12/2014 16:33:07: 1097 LOAD Company & upper(left([Legacy Account],1)) as Company, 18/12/2014 16:33:07: 1098 Ledger, 18/12/2014 16:33:07: 1099 AC1, 18/12/2014 16:33:07: 1100 Region, 18/12/2014 16:33:07: 1101 AC2, 18/12/2014 16:33:07: 1102 Controller, 18/12/2014 16:33:07: 1103 AC3, 18/12/2014 16:33:07: 1104 [SC/NAM], 18/12/2014 16:33:07: 1105 AC4, 18/12/2014 16:33:07: 1106 [Grp A/C / Cycle], 18/12/2014 16:33:07: 1107 [Legacy Account], 18/12/2014 16:33:07: 1108 Customer, 18/12/2014 16:33:07: 1109 Name, 18/12/2014 16:33:07: 1110 Status, 18/12/2014 16:33:07: 1111 [Credit Control Status], 18/12/2014 16:33:07: 1112 [Doc Type], 18/12/2014 16:33:07: 1113 [Doc ID] as [DOC ID], 18/12/2014 16:33:07: 1114 [Doc Number], 18/12/2014 16:33:07: 1115 Reference, 18/12/2014 16:33:07: 1116 [Document Date], 18/12/2014 16:33:07: 1117 [Due Date], 18/12/2014 16:33:07: 1118 [Update Date], 18/12/2014 16:33:07: 1119 Value, 18/12/2014 16:33:07: 1120 [VAT Code], 18/12/2014 16:33:07: 1121 VAT, 18/12/2014 16:33:07: 1122 Goods, 18/12/2014 16:33:07: 1123 Date(Today()) as [Month End], 18/12/2014 16:33:07: 1124 left(AC2,2) as Tier 18/12/2014 16:33:07: 1125 FROM 18/12/2014 16:33:07: 1126 [Z:\oalive60\Repository\100\MI_100_DBPD_CPD_298*.csv] 18/12/2014 16:33:07: 1127 (txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 3 lines) 18/12/2014 16:33:07: 1128 18/12/2014 16:33:07: 1129 where floor(FileTime())=today() 18/12/2014 16:33:07: 28 fields found: Company, Ledger, AC1, Region, AC2, Controller, AC3, SC/NAM, AC4, Grp A/C / Cycle, Legacy Account, Customer, Name, Status, Credit Control Status, Doc Type, DOC ID, Doc Number, Reference, Document Date, Due Date, Update Date, Value, VAT Code, VAT, Goods, Month End, Tier, 1,466,133 lines fetched 18/12/2014 16:33:15: 1097 LOAD Company & upper(left([Legacy Account],1)) as Company, 18/12/2014 16:33:15: 1098 Ledger, 18/12/2014 16:33:15: 1099 AC1, 18/12/2014 16:33:15: 1100 Region, 18/12/2014 16:33:15: 1101 AC2, 18/12/2014 16:33:15: 1102 Controller, 18/12/2014 16:33:15: 1103 AC3, 18/12/2014 16:33:15: 1104 [SC/NAM], 18/12/2014 16:33:15: 1105 AC4, 18/12/2014 16:33:15: 1106 [Grp A/C / Cycle], 18/12/2014 16:33:15: 1107 [Legacy Account], 18/12/2014 16:33:15: 1108 Customer, 18/12/2014 16:33:15: 1109 Name, 18/12/2014 16:33:15: 1110 Status, 18/12/2014 16:33:15: 1111 [Credit Control Status], 18/12/2014 16:33:15: 1112 [Doc Type], 18/12/2014 16:33:15: 1113 [Doc ID] as [DOC ID], 18/12/2014 16:33:15: 1114 [Doc Number], 18/12/2014 16:33:15: 1115 Reference, 18/12/2014 16:33:15: 1116 [Document Date], 18/12/2014 16:33:15: 1117 [Due Date], 18/12/2014 16:33:15: 1118 [Update Date], 18/12/2014 16:33:15: 1119 Value, 18/12/2014 16:33:15: 1120 [VAT Code], 18/12/2014 16:33:15: 1121 VAT, 18/12/2014 16:33:15: 1122 Goods, 18/12/2014 16:33:15: 1123 Date(Today()) as [Month End], 18/12/2014 16:33:15: 1124 left(AC2,2) as Tier 18/12/2014 16:33:15: 1125 FROM 18/12/2014 16:33:15: 1126 [Z:\oalive60\Repository\100\MI_100_DBPD_CPD_298*.csv] 18/12/2014 16:33:15: 1127 (txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 3 lines) 18/12/2014 16:33:15: 1128 18/12/2014 16:33:15: 1129 where floor(FileTime())=today() 18/12/2014 16:33:15: 28 fields found: Company, Ledger, AC1, Region, AC2, Controller, AC3, SC/NAM, AC4, Grp A/C / Cycle, Legacy Account, Customer, Name, Status, Credit Control Status, Doc Type, DOC ID, Doc Number, Reference, Document Date, Due Date, Update Date, Value, VAT Code, VAT, Goods, Month End, Tier, 1,466,133 lines fetched 18/12/2014 16:33:23: 1097 LOAD Company & upper(left([Legacy Account],1)) as Company, 18/12/2014 16:33:23: 1098 Ledger, 18/12/2014 16:33:23: 1099 AC1, 18/12/2014 16:33:23: 1100 Region, 18/12/2014 16:33:23: 1101 AC2, 18/12/2014 16:33:23: 1102 Controller, 18/12/2014 16:33:23: 1103 AC3, 18/12/2014 16:33:23: 1104 [SC/NAM], 18/12/2014 16:33:23: 1105 AC4, 18/12/2014 16:33:23: 1106 [Grp A/C / Cycle], 18/12/2014 16:33:23: 1107 [Legacy Account], 18/12/2014 16:33:23: 1108 Customer, 18/12/2014 16:33:23: 1109 Name, 18/12/2014 16:33:23: 1110 Status, 18/12/2014 16:33:23: 1111 [Credit Control Status], 18/12/2014 16:33:23: 1112 [Doc Type], 18/12/2014 16:33:23: 1113 [Doc ID] as [DOC ID], 18/12/2014 16:33:23: 1114 [Doc Number], 18/12/2014 16:33:23: 1115 Reference, 18/12/2014 16:33:23: 1116 [Document Date], 18/12/2014 16:33:23: 1117 [Due Date], 18/12/2014 16:33:23: 1118 [Update Date], 18/12/2014 16:33:23: 1119 Value, 18/12/2014 16:33:23: 1120 [VAT Code], 18/12/2014 16:33:23: 1121 VAT, 18/12/2014 16:33:23: 1122 Goods, 18/12/2014 16:33:23: 1123 Date(Today()) as [Month End], 18/12/2014 16:33:23: 1124 left(AC2,2) as Tier 18/12/2014 16:33:23: 1125 FROM 18/12/2014 16:33:23: 1126 [Z:\oalive60\Repository\100\MI_100_DBPD_CPD_298*.csv] 18/12/2014 16:33:23: 1127 (txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 3 lines) 18/12/2014 16:33:23: 1128 18/12/2014 16:33:23: 1129 where floor(FileTime())=today() 18/12/2014 16:33:23: 28 fields found: Company, Ledger, AC1, Region, AC2, Controller, AC3, SC/NAM, AC4, Grp A/C / Cycle, Legacy Account, Customer, Name, Status, Credit Control Status, Doc Type, DOC ID, Doc Number, Reference, Document Date, Due Date, Update Date, Value, VAT Code, VAT, Goods, Month End, Tier, 1,549,368 lines fetched 18/12/2014 16:33:33: 1132 store Daybooks into Daybooks_ME1401_to_18_12_2014.qvd (QVD) 18/12/2014 16:33:44: Execution finished.