6/9/2022 2:30:04 AM : Start Process : checkAllTablesExists() ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 2:30:05 AM : StartProcess ### 6/9/2022 2:30:05 AM 6/9/2022 2:30:05 AM : 11 ### 6/9/2022 2:30:05 AM 6/9/2022 2:30:05 AM : 22 ### 6/9/2022 2:30:05 AM 6/9/2022 2:30:05 AM : 33 ### 6/9/2022 2:30:05 AM 6/9/2022 2:30:05 AM : Application Started ### 6/9/2022 2:30:05 AM 6/9/2022 2:30:05 AM : Start Process : checkAllTablesExists() ### 6/9/2022 2:30:05 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 6/9/2022 2:30:05 AM 6/9/2022 2:30:05 AM : MainForm_Load ### AlertSystem ON 6/9/2022 2:30:05 AM : No. of Files to import (RECEIVEFINAL): ### 1 6/9/2022 2:30:06 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 2:30:06 AM : PostData() --->> ### 6/9/2022 2:30:06 AM 6/9/2022 2:30:06 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 6/9/2022 2:30:06 AM 6/9/2022 2:30:06 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '09/Jun/2022' ### 6/9/2022 2:30:06 AM 6/9/2022 2:30:07 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '09/Jun/2022' ### 6/9/2022 2:30:07 AM 6/9/2022 2:30:07 AM : ### 6/9/2022 2:30:07 AM : UNLINKEDSALES Record Count Before --->> 0 ### 6/9/2022 2:30:07 AM 6/9/2022 2:30:07 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 6/9/2022 2:30:07 AM 6/9/2022 2:30:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '09/Jun/2022' ### 6/9/2022 2:30:14 AM 6/9/2022 2:30:14 AM : UNLINKEDSALES Record Count After --->> 0 ### 6/9/2022 2:30:14 AM 6/9/2022 2:30:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 6/9/2022 2:30:14 AM 6/9/2022 2:30:14 AM : ### 6/9/2022 2:30:14 AM : Posting Supplierlink Query for Purchases --->> ### 6/9/2022 2:30:14 AM 6/9/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '09/Jun/2022' ### 6/9/2022 2:30:20 AM 6/9/2022 2:30:27 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '09/Jun/2022' ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '09/Jun/2022' ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Posting ClosingStock Successful --->> ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 6/9/2022 2:30:27 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 2:30:28 AM : Error in file ### TEMPLATE1 (1) at Line 124 6/9/2022 2:30:28 AM : Template Import Complete ### 6/9/2022 2:30:28 AM 6/9/2022 2:30:30 AM : Completed Updating Has Transaction Flag ### 6/9/2022 2:30:30 AM 6/9/2022 2:30:30 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 6/9/2022 2:30:30 AM 6/9/2022 2:30:30 AM : Zylem Access Unblocked ### 6/9/2022 2:30:30 AM 6/9/2022 2:30:31 AM : Application Ended ### 6/9/2022 2:30:31 AM 6/9/2022 7:17:35 AM : Start Process : checkAllTablesExists() ### Start 6/9/2022 7:17:35 AM : Import Start Time (NEW) For Ajanta Trading(1960388) ### 6/9/2022 7:17:35 AM 6/9/2022 7:17:36 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 7:17:36 AM : For Distributor 000000000000359 Insert Count::6 ### Delete Count::4 6/9/2022 7:17:36 AM : Import AD File --->> AD_359_20220609_508f57940f9e8f8f073f840f45dd6be8.TXT ### 6/9/2022 7:17:36 AM 6/9/2022 7:17:36 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 7:17:36 AM : For Distributor 000000000000359 Insert Count::19 ### Delete Count::18 6/9/2022 7:17:36 AM : Import PR File --->> PR_359_20220609_364bf387d2ed1d565d4bcae4b07a9513.TXT ### 6/9/2022 7:17:36 AM 6/9/2022 7:17:36 AM : Import Masters Completed Ajanta Trading(1960388) ### 6/9/2022 7:17:36 AM 6/9/2022 7:17:36 AM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 6/9/2022 7:17:36 AM : splitFileDaywiseNewNaming ### called 6/9/2022 7:17:36 AM : splitFileDaywiseNewNaming ### called 6/9/2022 7:17:36 AM : command:: ### Delete Unlinked DN 6/9/2022 7:17:36 AM : command:: ### Delete Unlinked DN 6/9/2022 7:17:36 AM : command:: ### Delete SPLITFILEINFO DN 6/9/2022 7:17:36 AM : Import DN File --->> DN_359_20211101_a26322ac88676a2908c07fc835704de6.TXT ### 6/9/2022 7:17:36 AM 6/9/2022 7:17:36 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::4 6/9/2022 7:17:36 AM : Import DN File --->> DN_359_20211110_02e99a02294008adaf9356258ae730e3.TXT ### 6/9/2022 7:17:36 AM 6/9/2022 7:17:36 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::7 6/9/2022 7:17:36 AM : Import DN File --->> DN_359_20211127_6487e3c298937315a2712961f7e0651f.TXT ### 6/9/2022 7:17:36 AM 6/9/2022 7:17:36 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::8 6/9/2022 7:17:36 AM : command:: flagImportPosting = ### True 6/9/2022 7:17:36 AM : command:: minDate = ### 11/1/2021 12:00:00 AM 6/9/2022 7:17:36 AM : splitFileDaywiseNewNaming ### called 6/9/2022 7:17:36 AM : command:: ### Delete Unlinked IN 6/9/2022 7:17:36 AM : command:: ### Delete Unlinked IN 6/9/2022 7:17:36 AM : command:: ### Delete SPLITFILEINFO IN 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211101_0a72267b4213bb3111116aaf11ffbf83.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::12 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211103_540131095826ff778304e81184be51c6.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::15 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211111_57879bb55d2e73c40b8050fd0907321c.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::1 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211112_eb54cb3257ce1a4b24bdd486ba6ca044.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::14 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211113_073ce5cd29d29e44a7361399493082dd.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::3 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211115_9ec4c41899239ab94c5e22398f35c43a.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::12 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211116_d85b7b8386792236882b159407a68033.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::22 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211117_9396d593842f0c799bc737e344786106.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::13 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211119_883ab6e33bf9c02325aebc2e134ce84f.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::3 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211122_a02050e0c80d8f3c9df038c3ea60d3b5.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::23 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211124_2fb6c390f929a8a89967da60242574b8.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::1 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211125_755bc7c3b662106dc17e34d91b35301e.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::1 6/9/2022 7:17:37 AM : Import IN File --->> IN_359_20211130_2222313b532667c015de9ab17fe564d1.TXT ### 6/9/2022 7:17:37 AM 6/9/2022 7:17:37 AM : NO Previous File For Distributor 000000000000359 ### Insert Count::40 6/9/2022 7:17:37 AM : command:: flagImportPosting = ### True 6/9/2022 7:17:37 AM : command:: minDate = ### 11/1/2021 12:00:00 AM 6/9/2022 7:17:41 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 6/9/2022 7:17:41 AM 6/9/2022 7:17:42 AM : CustomerLink Diff Successful --->> ### 6/9/2022 7:17:42 AM 6/9/2022 7:17:43 AM : ItemLink Diff Successful --->> ### 6/9/2022 7:17:43 AM 6/9/2022 7:17:43 AM : Supplierlink Query Successful --->> ### 6/9/2022 7:17:43 AM 6/9/2022 7:17:43 AM : Posting Purchases 'true' Successful --->> ### 6/9/2022 7:17:43 AM 6/9/2022 7:17:44 AM : Posting OtherTransaction 'true' Successful --->> ### 6/9/2022 7:17:44 AM 6/9/2022 7:17:48 AM : Posting Sales 'true' Successful --->> ### 6/9/2022 7:17:48 AM 6/9/2022 7:17:51 AM : Completed Updating Has Transaction Flag ### 6/9/2022 7:17:51 AM 6/9/2022 7:17:51 AM : command :: PostDataDeleteInsert ### Done 6/9/2022 7:17:51 AM : command :: set DiffCutOffDate ### Done 6/9/2022 7:17:51 AM : End Process : ImportSplittedFilesOldDeleteInsert() ### 6/9/2022 7:17:51 AM : Import End Time (NEW) Ajanta Trading(1960388) ### 6/9/2022 7:17:51 AM 6/9/2022 7:17:51 AM : -------------Import One Distributor End Time----------- ### 6/9/2022 7:17:51 AM 6/9/2022 7:30:02 AM : Start Process : checkAllTablesExists() ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 7:30:03 AM : StartProcess ### 6/9/2022 7:30:03 AM 6/9/2022 7:30:03 AM : 11 ### 6/9/2022 7:30:03 AM 6/9/2022 7:30:03 AM : 22 ### 6/9/2022 7:30:03 AM 6/9/2022 7:30:03 AM : 33 ### 6/9/2022 7:30:03 AM 6/9/2022 7:30:03 AM : Application Started ### 6/9/2022 7:30:03 AM 6/9/2022 7:30:03 AM : Start Process : checkAllTablesExists() ### 6/9/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 6/9/2022 7:30:03 AM 6/9/2022 7:30:03 AM : MainForm_Load ### AlertSystem ON 6/9/2022 7:30:04 AM : No. of Files to import (RECEIVEFINAL): ### 1558 6/9/2022 7:30:04 AM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 7:30:04 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0 6/9/2022 7:30:04 AM : Import AD File --->> AD_1026_20220609_8642d62a1339e890774c33aca64fb3a9.TXT ### 6/9/2022 7:30:04 AM 6/9/2022 7:30:04 AM : For Distributor 000000000001321 Insert Count::4 ### Delete Count::3 6/9/2022 7:30:04 AM : Import AD File --->> AD_1321_20220609_de641580f16336dd5a2384d0ffc225fc.TXT ### 6/9/2022 7:30:04 AM 6/9/2022 7:30:04 AM : For Distributor 000000000000353 Insert Count::6 ### Delete Count::0 6/9/2022 7:30:04 AM : Import AD File --->> AD_353_20220609_3d1d82362853ccfed0013b6a401e472d.TXT ### 6/9/2022 7:30:04 AM 6/9/2022 7:30:05 AM : For Distributor 000000000000366 Insert Count::3 ### Delete Count::0 6/9/2022 7:30:05 AM : Import AD File --->> AD_366_20220609_971d578551d8263f7fdfb3eda665b854.TXT ### 6/9/2022 7:30:05 AM 6/9/2022 7:30:05 AM : For Distributor 000000000000424 Insert Count::4 ### Delete Count::0 6/9/2022 7:30:05 AM : Import AD File --->> AD_424_20220609_13bd73fc14265d665c24ae705dc617ea.TXT ### 6/9/2022 7:30:05 AM 6/9/2022 7:30:05 AM : For Distributor 000000000000809 Insert Count::4 ### Delete Count::0 6/9/2022 7:30:05 AM : Import AD File --->> AD_809_20220609_2df76812de99063632daf6047d52d6b6.TXT ### 6/9/2022 7:30:05 AM 6/9/2022 7:30:06 AM : For Distributor 000000000000810 Insert Count::3 ### Delete Count::0 6/9/2022 7:30:06 AM : Import AD File --->> AD_810_20220609_e615ae3f41f0224940ab4e6b350cf155.TXT ### 6/9/2022 7:30:06 AM 6/9/2022 7:30:06 AM : For Distributor 000000000000817 Insert Count::1 ### Delete Count::0 6/9/2022 7:30:06 AM : Import AD File --->> AD_817_20220609_48138eeff6a2bdd7dd08f86f34ba8828.TXT ### 6/9/2022 7:30:06 AM 6/9/2022 7:30:45 AM : For Distributor 000000000000817 Insert Count::1 ### Delete Count::1 6/9/2022 7:30:45 AM : Import DN File --->> DN_817_20220525_422051aa58a4fa1d77f7b116050f46e1.TXT ### 6/9/2022 7:30:45 AM 6/9/2022 7:30:45 AM : For Distributor 000000000000817 Insert Count::1 ### Delete Count::1 6/9/2022 7:30:45 AM : Import DN File --->> DN_817_20220527_2ebdb2d1b20287b319eb26466a8cf249.TXT ### 6/9/2022 7:30:45 AM 6/9/2022 7:30:54 AM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0 6/9/2022 7:30:54 AM : Import IN File --->> IN_1026_20220608_9304babf2a83d98740a20977b0dabce3.TXT ### 6/9/2022 7:30:54 AM 6/9/2022 7:31:01 AM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1 6/9/2022 7:31:01 AM : Import IN File --->> IN_1321_20220506_9613eb25835ed465debf370a7188b25b.TXT ### 6/9/2022 7:31:01 AM 6/9/2022 7:31:02 AM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1 6/9/2022 7:31:02 AM : Import IN File --->> IN_1321_20220523_940ff66ace0e6e2bdbb0afd5525e2a24.TXT ### 6/9/2022 7:31:02 AM 6/9/2022 7:31:02 AM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1 6/9/2022 7:31:02 AM : Import IN File --->> IN_1321_20220527_a908e32cf8fb6cfed6bcc6918ff19071.TXT ### 6/9/2022 7:31:02 AM 6/9/2022 7:31:04 AM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0 6/9/2022 7:31:04 AM : Import IN File --->> IN_1321_20220608_9061e98332e5f7215f97ea6d07415a6b.TXT ### 6/9/2022 7:31:04 AM 6/9/2022 7:31:08 AM : For Distributor 000000000000353 Insert Count::5 ### Delete Count::0 6/9/2022 7:31:08 AM : Import IN File --->> IN_353_20220606_5f12d87fedf4c6461ae8913a02a732cd.TXT ### 6/9/2022 7:31:08 AM 6/9/2022 7:31:09 AM : For Distributor 000000000000353 Insert Count::2 ### Delete Count::0 6/9/2022 7:31:09 AM : Import IN File --->> IN_353_20220607_d2b3d2905d34ed49d96c9c4ee5b28881.TXT ### 6/9/2022 7:31:09 AM 6/9/2022 7:31:09 AM : For Distributor 000000000000353 Insert Count::4 ### Delete Count::0 6/9/2022 7:31:09 AM : Import IN File --->> IN_353_20220608_b89034f4695941d4d4d9aec34ddbba11.TXT ### 6/9/2022 7:31:09 AM 6/9/2022 7:31:13 AM : For Distributor 000000000000366 Insert Count::57 ### Delete Count::0 6/9/2022 7:31:13 AM : Import IN File --->> IN_366_20220608_b3c7050e50763e544384173a82572a7d.TXT ### 6/9/2022 7:31:13 AM 6/9/2022 7:31:15 AM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::0 6/9/2022 7:31:15 AM : Import IN File --->> IN_369_20220608_74257f9c04224dd0b7f2cce1c3594354.TXT ### 6/9/2022 7:31:15 AM 6/9/2022 7:31:20 AM : For Distributor 000000000000424 Insert Count::8 ### Delete Count::0 6/9/2022 7:31:20 AM : Import IN File --->> IN_424_20220608_69d50957025ef8f3d6bc90fc341e36ae.TXT ### 6/9/2022 7:31:20 AM 6/9/2022 7:31:20 AM : Import IN File --->> IN_424_20220609_09d1ecdc368f4d8388d0f17c891fad3c.TXT ### 6/9/2022 7:31:20 AM 6/9/2022 7:31:20 AM : NO Previous File For Distributor 000000000000424 ### Insert Count::3 6/9/2022 7:31:22 AM : For Distributor 000000000000665 Insert Count::23 ### Delete Count::0 6/9/2022 7:31:22 AM : Import IN File --->> IN_665_20220608_cfaf51600c8ac699827e75daf2588cce.TXT ### 6/9/2022 7:31:22 AM 6/9/2022 7:31:25 AM : For Distributor 000000000000809 Insert Count::19 ### Delete Count::0 6/9/2022 7:31:25 AM : Import IN File --->> IN_809_20220606_05487e710635fc2b006598bd96ccc657.TXT ### 6/9/2022 7:31:25 AM 6/9/2022 7:31:25 AM : For Distributor 000000000000809 Insert Count::11 ### Delete Count::0 6/9/2022 7:31:25 AM : Import IN File --->> IN_809_20220607_9397d0545f617015cd9c4ef39f163f90.TXT ### 6/9/2022 7:31:25 AM 6/9/2022 7:31:25 AM : For Distributor 000000000000809 Insert Count::20 ### Delete Count::0 6/9/2022 7:31:25 AM : Import IN File --->> IN_809_20220608_7657ed2c5bbe9c365a35771903e78334.TXT ### 6/9/2022 7:31:25 AM 6/9/2022 7:31:25 AM : Import IN File --->> IN_810_20220608_53cc5ba8e3660c088cdfdce5d7f2e694.TXT ### 6/9/2022 7:31:25 AM 6/9/2022 7:31:25 AM : NO Previous File For Distributor 000000000000810 ### Insert Count::6 6/9/2022 7:31:27 AM : For Distributor 000000000000814 Insert Count::9 ### Delete Count::0 6/9/2022 7:31:27 AM : Import IN File --->> IN_814_20220503_286769b2fbe236f9df679abe2ae040ff.TXT ### 6/9/2022 7:31:27 AM 6/9/2022 7:31:31 AM : For Distributor 000000000000817 Insert Count::1 ### Delete Count::1 6/9/2022 7:31:31 AM : Import IN File --->> IN_817_20220516_e4350164765474ab511c2e429a060441.TXT ### 6/9/2022 7:31:31 AM 6/9/2022 7:31:32 AM : Import IN File --->> IN_817_20220607_f4477c2d5e4e3cc2a624f9fa2260b9b6.TXT ### 6/9/2022 7:31:32 AM 6/9/2022 7:31:32 AM : NO Previous File For Distributor 000000000000817 ### Insert Count::1 6/9/2022 7:31:32 AM : For Distributor 000000000000892 Insert Count::4 ### Delete Count::4 6/9/2022 7:31:32 AM : Import IN File --->> IN_892_20220401_bf3fa9927fa21d10403950af480230eb.TXT ### 6/9/2022 7:31:32 AM 6/9/2022 7:31:33 AM : For Distributor 000000000000892 Insert Count::14 ### Delete Count::14 6/9/2022 7:31:33 AM : Import IN File --->> IN_892_20220404_3abeb607cbd396dd426f704556a927fb.TXT ### 6/9/2022 7:31:33 AM 6/9/2022 7:31:33 AM : For Distributor 000000000000892 Insert Count::9 ### Delete Count::9 6/9/2022 7:31:33 AM : Import IN File --->> IN_892_20220405_3f2e4e701b40d40f127653cdd2162614.TXT ### 6/9/2022 7:31:33 AM 6/9/2022 7:31:33 AM : For Distributor 000000000000892 Insert Count::7 ### Delete Count::7 6/9/2022 7:31:33 AM : Import IN File --->> IN_892_20220406_d9fbe046a906466c94a4c33cc66bc083.TXT ### 6/9/2022 7:31:33 AM 6/9/2022 7:31:33 AM : For Distributor 000000000000892 Insert Count::26 ### Delete Count::26 6/9/2022 7:31:33 AM : Import IN File --->> IN_892_20220407_e988bd5da41ae2ca586e4ef2c112be02.TXT ### 6/9/2022 7:31:33 AM 6/9/2022 7:31:33 AM : For Distributor 000000000000892 Insert Count::13 ### Delete Count::13 6/9/2022 7:31:33 AM : Import IN File --->> IN_892_20220408_bbccac716118e8b683430d8e716de01a.TXT ### 6/9/2022 7:31:33 AM 6/9/2022 7:31:33 AM : For Distributor 000000000000892 Insert Count::7 ### Delete Count::7 6/9/2022 7:31:33 AM : Import IN File --->> IN_892_20220409_4f164ffe0a4af7efc6ce477ff4164cae.TXT ### 6/9/2022 7:31:33 AM 6/9/2022 7:31:34 AM : For Distributor 000000000000892 Insert Count::6 ### Delete Count::6 6/9/2022 7:31:34 AM : Import IN File --->> IN_892_20220411_4d98f84146e7305aec4e846530dc4963.TXT ### 6/9/2022 7:31:34 AM 6/9/2022 7:31:34 AM : For Distributor 000000000000892 Insert Count::1 ### Delete Count::1 6/9/2022 7:31:34 AM : Import IN File --->> IN_892_20220412_03e079b9064cbdd9b7e99b30622dbff1.TXT ### 6/9/2022 7:31:34 AM 6/9/2022 7:31:34 AM : For Distributor 000000000000892 Insert Count::3 ### Delete Count::3 6/9/2022 7:31:34 AM : Import IN File --->> IN_892_20220413_e926f3f2cdb023ad4d33ec372a862bec.TXT ### 6/9/2022 7:31:34 AM 6/9/2022 7:31:34 AM : For Distributor 000000000000892 Insert Count::9 ### Delete Count::9 6/9/2022 7:31:34 AM : Import IN File --->> IN_892_20220414_905d748e01288b63ec62117e9cef735e.TXT ### 6/9/2022 7:31:34 AM 6/9/2022 7:31:34 AM : For Distributor 000000000000892 Insert Count::7 ### Delete Count::7 6/9/2022 7:31:34 AM : Import IN File --->> IN_892_20220415_720a698f4c149406db1cf1101832a1c5.TXT ### 6/9/2022 7:31:34 AM 6/9/2022 7:31:34 AM : For Distributor 000000000000892 Insert Count::8 ### Delete Count::8 6/9/2022 7:31:34 AM : Import IN File --->> IN_892_20220416_b217b97dbc31bf38ba30bf16bd63c4d3.TXT ### 6/9/2022 7:31:34 AM 6/9/2022 7:31:35 AM : For Distributor 000000000000892 Insert Count::8 ### Delete Count::8 6/9/2022 7:31:35 AM : Import IN File --->> IN_892_20220418_dadfca4404cc1ab1daddb725b3c0626b.TXT ### 6/9/2022 7:31:35 AM 6/9/2022 7:31:35 AM : For Distributor 000000000000892 Insert Count::7 ### Delete Count::7 6/9/2022 7:31:35 AM : Import IN File --->> IN_892_20220419_0fc16d6982a49db6e8d8f1452c5b9ab6.TXT ### 6/9/2022 7:31:35 AM 6/9/2022 7:31:35 AM : For Distributor 000000000000892 Insert Count::23 ### Delete Count::23 6/9/2022 7:31:35 AM : Import IN File --->> IN_892_20220420_b845dbaf198b0c5c5c2747cca76af04e.TXT ### 6/9/2022 7:31:35 AM 6/9/2022 7:31:35 AM : For Distributor 000000000000892 Insert Count::6 ### Delete Count::6 6/9/2022 7:31:35 AM : Import IN File --->> IN_892_20220421_f7b76d0ffb017f4980a0bdc0e752dc9b.TXT ### 6/9/2022 7:31:35 AM 6/9/2022 7:31:35 AM : For Distributor 000000000000892 Insert Count::3 ### Delete Count::3 6/9/2022 7:31:35 AM : Import IN File --->> IN_892_20220422_916464638f67fef8067127c582906efe.TXT ### 6/9/2022 7:31:35 AM 6/9/2022 7:31:35 AM : For Distributor 000000000000892 Insert Count::7 ### Delete Count::7 6/9/2022 7:31:35 AM : Import IN File --->> IN_892_20220423_f511d62aa3c12095c954c22c57cb9ef6.TXT ### 6/9/2022 7:31:35 AM 6/9/2022 7:31:36 AM : For Distributor 000000000000892 Insert Count::18 ### Delete Count::18 6/9/2022 7:31:36 AM : Import IN File --->> IN_892_20220425_28dcc9343606f93c7d2f536008d2edf9.TXT ### 6/9/2022 7:31:36 AM 6/9/2022 7:31:36 AM : For Distributor 000000000000892 Insert Count::8 ### Delete Count::8 6/9/2022 7:31:36 AM : Import IN File --->> IN_892_20220426_c4dceba0ccd8af52c73b60645d7f43dc.TXT ### 6/9/2022 7:31:36 AM 6/9/2022 7:31:36 AM : For Distributor 000000000000892 Insert Count::7 ### Delete Count::7 6/9/2022 7:31:36 AM : Import IN File --->> IN_892_20220427_5fbb4fc710bba94547b2d87ab6ef0c1e.TXT ### 6/9/2022 7:31:36 AM 6/9/2022 7:31:36 AM : For Distributor 000000000000892 Insert Count::11 ### Delete Count::11 6/9/2022 7:31:36 AM : Import IN File --->> IN_892_20220428_da37056ebe197a9b2a54db557ce27d0a.TXT ### 6/9/2022 7:31:36 AM 6/9/2022 7:31:36 AM : For Distributor 000000000000892 Insert Count::5 ### Delete Count::5 6/9/2022 7:31:36 AM : Import IN File --->> IN_892_20220429_21dd0d7b949589170dd7a1c73f11b31c.TXT ### 6/9/2022 7:31:36 AM 6/9/2022 7:31:36 AM : For Distributor 000000000000892 Insert Count::4 ### Delete Count::4 6/9/2022 7:31:36 AM : Import IN File --->> IN_892_20220430_d76ecec7dbfbdc83f712e0c790527199.TXT ### 6/9/2022 7:31:36 AM 6/9/2022 7:31:37 AM : For Distributor 000000000000892 Insert Count::28 ### Delete Count::28 6/9/2022 7:31:37 AM : Import IN File --->> IN_892_20220502_632077aac2c0b69abdd7481ef01d342e.TXT ### 6/9/2022 7:31:37 AM 6/9/2022 7:31:37 AM : For Distributor 000000000000892 Insert Count::13 ### Delete Count::13 6/9/2022 7:31:37 AM : Import IN File --->> IN_892_20220503_2e8b9ed8048c105abd5ef0ed5c92b48b.TXT ### 6/9/2022 7:31:37 AM 6/9/2022 7:31:37 AM : For Distributor 000000000000892 Insert Count::12 ### Delete Count::12 6/9/2022 7:31:37 AM : Import IN File --->> IN_892_20220504_6573c27edc398f33a201c89fc14262b6.TXT ### 6/9/2022 7:31:37 AM 6/9/2022 7:31:37 AM : For Distributor 000000000000892 Insert Count::16 ### Delete Count::16 6/9/2022 7:31:37 AM : Import IN File --->> IN_892_20220505_8b17ecf35423544e2c8ea763365ed14b.TXT ### 6/9/2022 7:31:37 AM 6/9/2022 7:31:38 AM : For Distributor 000000000000892 Insert Count::9 ### Delete Count::9 6/9/2022 7:31:38 AM : Import IN File --->> IN_892_20220506_8eaf9ae9d2171ae2f3f272912d09867b.TXT ### 6/9/2022 7:31:38 AM 6/9/2022 7:31:38 AM : For Distributor 000000000000892 Insert Count::9 ### Delete Count::9 6/9/2022 7:31:38 AM : Import IN File --->> IN_892_20220507_f5216bf748e118c8b9f5e2cf341a8fec.TXT ### 6/9/2022 7:31:38 AM 6/9/2022 7:31:38 AM : For Distributor 000000000000892 Insert Count::11 ### Delete Count::11 6/9/2022 7:31:38 AM : Import IN File --->> IN_892_20220509_e654911848c14355ef0edce1ccb18a1d.TXT ### 6/9/2022 7:31:38 AM 6/9/2022 7:31:47 AM : For Distributor 000000000000817 Insert Count::3 ### Delete Count::3 6/9/2022 7:31:47 AM : Import PR File --->> PR_817_20220609_a8bd1742a939e769c37ee7a56589c550.TXT ### 6/9/2022 7:31:47 AM 6/9/2022 7:31:47 AM : PostData() --->> ### 6/9/2022 7:31:47 AM 6/9/2022 7:31:54 AM : SP_CreateUnkCustomerUnkItem Successful --->> ### 6/9/2022 7:31:54 AM 6/9/2022 7:31:58 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '09/Jun/2022' ### 6/9/2022 7:31:58 AM 6/9/2022 7:31:58 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '09/Jun/2022' ### 6/9/2022 7:31:58 AM 6/9/2022 7:31:58 AM : ### 6/9/2022 7:31:58 AM : UNLINKEDSALES Record Count Before --->> 494 ### 6/9/2022 7:31:58 AM 6/9/2022 7:31:58 AM : UNLINKEDSALES_DEL Record Count Before --->> 323 ### 6/9/2022 7:31:58 AM 6/9/2022 9:51:23 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '09/Jun/2022' ### 6/9/2022 9:51:23 AM 6/9/2022 9:51:23 AM : UNLINKEDSALES Record Count After --->> 0 ### 6/9/2022 9:51:23 AM 6/9/2022 9:51:23 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 6/9/2022 9:51:23 AM 6/9/2022 9:51:23 AM : ### 6/9/2022 9:51:23 AM : Posting Supplierlink Query for Purchases --->> ### 6/9/2022 9:51:23 AM 6/9/2022 9:51:30 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '09/Jun/2022' ### 6/9/2022 9:51:30 AM 6/9/2022 9:51:36 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '09/Jun/2022' ### 6/9/2022 9:51:36 AM 6/9/2022 9:51:36 AM : Posting Supplierlink Query for CompanyPurchases --->> ### 6/9/2022 9:51:36 AM 6/9/2022 9:51:36 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '09/Jun/2022' ### 6/9/2022 9:51:36 AM 6/9/2022 9:51:36 AM : Posting ClosingStock Successful --->> ### 6/9/2022 9:51:36 AM 6/9/2022 9:51:37 AM : FileWiseHashCode Updated for FlagImport=true records --->> ### 6/9/2022 9:51:37 AM 6/9/2022 9:51:37 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 6/9/2022 9:51:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 6/9/2022 9:51:37 AM 6/9/2022 9:51:37 AM : Count:: ### TEMPLATE1:74 6/9/2022 9:51:41 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:51:41 AM 6/9/2022 9:51:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 6/9/2022 9:51:41 AM 6/9/2022 9:51:41 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 6/9/2022 9:51:41 AM 6/9/2022 9:51:41 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 6/9/2022 9:51:41 AM 6/9/2022 9:51:41 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 6/9/2022 9:51:41 AM 6/9/2022 9:51:41 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 6/9/2022 9:51:41 AM 6/9/2022 9:51:41 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:41 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.TXT ### 6/9/2022 9:51:41 AM 6/9/2022 9:51:41 AM : Count:: ### TEMPLATE1:155 6/9/2022 9:51:51 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:51:51 AM 6/9/2022 9:51:51 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3513087_TEMPLATE1.TXT ### 6/9/2022 9:51:51 AM 6/9/2022 9:51:51 AM : Count:: ### TEMPLATE1:49 6/9/2022 9:51:58 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Count:: ### TEMPLATE1:35 6/9/2022 9:51:58 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:51:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 6/9/2022 9:51:58 AM 6/9/2022 9:51:58 AM : Count:: ### TEMPLATE1:15 6/9/2022 9:52:00 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:52:00 AM 6/9/2022 9:52:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 6/9/2022 9:52:00 AM 6/9/2022 9:52:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 6/9/2022 9:52:00 AM 6/9/2022 9:52:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 6/9/2022 9:52:00 AM 6/9/2022 9:52:00 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 6/9/2022 9:52:00 AM 6/9/2022 9:52:00 AM : Count:: ### TEMPLATE1:10 6/9/2022 9:52:00 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:52:00 AM 6/9/2022 9:52:00 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060448_TEMPLATE1.TXT ### 6/9/2022 9:52:00 AM 6/9/2022 9:52:00 AM : Count:: ### TEMPLATE1:10 6/9/2022 9:52:01 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:52:01 AM 6/9/2022 9:52:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 6/9/2022 9:52:01 AM 6/9/2022 9:52:01 AM : Count:: ### TEMPLATE1:110 6/9/2022 9:52:17 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:52:17 AM 6/9/2022 9:52:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 6/9/2022 9:52:17 AM 6/9/2022 9:52:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 6/9/2022 9:52:17 AM 6/9/2022 9:52:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 6/9/2022 9:52:17 AM 6/9/2022 9:52:17 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:17 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062891_TEMPLATE1.TXT ### 6/9/2022 9:52:17 AM 6/9/2022 9:52:17 AM : Count:: ### TEMPLATE1:32 6/9/2022 9:52:19 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:52:19 AM 6/9/2022 9:52:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 6/9/2022 9:52:19 AM 6/9/2022 9:52:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 6/9/2022 9:52:19 AM 6/9/2022 9:52:19 AM : Count:: ### TEMPLATE1:80 6/9/2022 9:52:30 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:52:30 AM 6/9/2022 9:52:30 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 6/9/2022 9:52:30 AM 6/9/2022 9:52:30 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 9:52:30 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.TXT ### 6/9/2022 9:52:30 AM 6/9/2022 9:52:30 AM : Count:: ### TEMPLATE1:1 6/9/2022 9:52:30 AM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 9:52:30 AM 6/9/2022 9:52:30 AM : Error in file ### TEMPLATE1 (1) at Line 1 6/9/2022 9:52:30 AM : Template Import Complete ### 6/9/2022 9:52:30 AM 6/9/2022 9:52:32 AM : Completed Updating Has Transaction Flag ### 6/9/2022 9:52:32 AM 6/9/2022 9:52:32 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 6/9/2022 9:52:32 AM 6/9/2022 9:52:32 AM : Zylem Access Unblocked ### 6/9/2022 9:52:32 AM 6/9/2022 9:52:32 AM : Application Ended ### 6/9/2022 9:52:32 AM 6/9/2022 12:47:04 PM : Start Process : checkAllTablesExists() ### Start 6/9/2022 12:47:05 PM : Import Start Time (NEW) For Green Care Agencies(9064815) ### 6/9/2022 12:47:05 PM 6/9/2022 12:47:05 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 12:47:05 PM : For Distributor 000000000000009 Insert Count::73 ### Delete Count::111 6/9/2022 12:47:05 PM : Import AD File --->> AD_9_20220609_a1b67d6ff1dc36dc505bdca97ed07f3a.TXT ### 6/9/2022 12:47:05 PM 6/9/2022 12:47:05 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 12:47:05 PM : For Distributor 000000000000009 Insert Count::2 ### Delete Count::2 6/9/2022 12:47:05 PM : Import PR File --->> PR_9_20220609_18e9b0aeab0b6e04f2377463f2af7eec.TXT ### 6/9/2022 12:47:05 PM 6/9/2022 12:47:06 PM : Import Masters Completed Green Care Agencies(9064815) ### 6/9/2022 12:47:06 PM 6/9/2022 12:47:06 PM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 6/9/2022 12:47:06 PM : splitFileDaywiseNewNaming ### called 6/9/2022 12:47:06 PM : splitFileDaywiseNewNaming ### called 6/9/2022 12:47:06 PM : splitFileDaywiseNewNaming ### FileRangeMonthYear = '4-2020' and FileDataMonthYear= '6-2020' of MinDate mismatched 6/9/2022 12:47:06 PM : command:: ### Delete Unlinked DN 6/9/2022 12:47:06 PM : command:: ### Delete Unlinked DN 6/9/2022 12:47:06 PM : command:: ### Delete SPLITFILEINFO DN 6/9/2022 12:47:06 PM : Import DN File --->> DN_9_20200625_0b4ed48b91a0724aa03d13bdb6d0d6da.TXT ### 6/9/2022 12:47:06 PM 6/9/2022 12:47:06 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:06 PM : Import DN File --->> DN_9_20200703_a59162769316f76ded89408fe722b3dd.TXT ### 6/9/2022 12:47:06 PM 6/9/2022 12:47:06 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:06 PM : Import DN File --->> DN_9_20200709_bbefbe7b21d50e9889a2dc77333c32ea.TXT ### 6/9/2022 12:47:06 PM 6/9/2022 12:47:06 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:06 PM : Import DN File --->> DN_9_20200804_ce37b4d0e7cb43b89a2e0a3094e7a28a.TXT ### 6/9/2022 12:47:06 PM 6/9/2022 12:47:06 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:07 PM : Import DN File --->> DN_9_20200820_51d4cfe5d1e26a9fde391a7f7749cc5d.TXT ### 6/9/2022 12:47:07 PM 6/9/2022 12:47:07 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:07 PM : Import DN File --->> DN_9_20200901_3012d756d2c3787c98648cb21b1b97b9.TXT ### 6/9/2022 12:47:07 PM 6/9/2022 12:47:07 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:07 PM : Import DN File --->> DN_9_20200923_c2ae3953d5fa48e7a94e53b4f316293e.TXT ### 6/9/2022 12:47:07 PM 6/9/2022 12:47:07 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:07 PM : Import DN File --->> DN_9_20201015_e43c4c4b156cbbfdaa501d588f6643b2.TXT ### 6/9/2022 12:47:07 PM 6/9/2022 12:47:07 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:07 PM : Import DN File --->> DN_9_20201023_0e21b47a957da6bf0b04b2ea07002953.TXT ### 6/9/2022 12:47:07 PM 6/9/2022 12:47:07 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:07 PM : Import DN File --->> DN_9_20201126_b982cea0ca65a169bdb503c52a332e84.TXT ### 6/9/2022 12:47:07 PM 6/9/2022 12:47:07 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:08 PM : Import DN File --->> DN_9_20201219_72a25bb78561fc83d0854c82b35738ca.TXT ### 6/9/2022 12:47:08 PM 6/9/2022 12:47:08 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:08 PM : Import DN File --->> DN_9_20210101_128c2bd318882f94d148ac9364191921.TXT ### 6/9/2022 12:47:08 PM 6/9/2022 12:47:08 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:08 PM : Import DN File --->> DN_9_20210205_4ea38c53762212bb40c5dabc8b6593c3.TXT ### 6/9/2022 12:47:08 PM 6/9/2022 12:47:08 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:08 PM : Import DN File --->> DN_9_20210219_62a3b47e1d47a8d9d7dfc88ceccc28fc.TXT ### 6/9/2022 12:47:08 PM 6/9/2022 12:47:08 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:08 PM : command:: flagImportPosting = ### True 6/9/2022 12:47:08 PM : command:: minDate = ### 6/25/2020 12:00:00 AM 6/9/2022 12:47:08 PM : splitFileDaywiseNewNaming ### called 6/9/2022 12:47:09 PM : command:: ### Delete Unlinked IN 6/9/2022 12:47:09 PM : command:: ### Delete Unlinked IN 6/9/2022 12:47:09 PM : command:: ### Delete SPLITFILEINFO IN 6/9/2022 12:47:09 PM : Import IN File --->> IN_9_20200430_06705a01846a81fc72d0346442f25d5c.TXT ### 6/9/2022 12:47:09 PM 6/9/2022 12:47:09 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200615_0a0c6eba68dc77199eeb252647035bb2.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200704_663916fff540f34a9118f34982bc5ba3.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200710_deebc20ef2e3edd374ede1630c5b0a61.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200717_77e5d8c61284660f7354341a3f91b434.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200721_27b98ef0c43781c8db0794388ee2560f.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200728_a4b2d245fbe26e6470356b37fb4a444d.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200729_3f9dca474b545c514305b27664f75cbf.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200804_588b8d97c7f0168146689277f1f6a82d.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200815_4ff656d62e2460ef7b0ec2cd07f3fdaf.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200827_e8100e1a6f9bd3da09a9d5fc3aff3612.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200829_c55f5e62e621a1cb75568767e10f324b.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200901_7c2eef1c5ff3ef035f2b232ab8301488.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200903_3f867b15948cc3714ad03dbdbc0df3ca.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200904_5d7647960832fb24beacfc8c666118bf.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200905_9248cfba746378041c506fac965e8896.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200907_8f1051a6ed883d6e3c8815dfdf31582c.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200908_a780a5710c3409080659a13fc1abbb14.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:10 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:10 PM : Import IN File --->> IN_9_20200909_fd024efaab7a47052f25b131bce5d6a0.TXT ### 6/9/2022 12:47:10 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200910_6fcd2a12712750b062e344cf4320b023.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200911_45c394de84de53268c5c99a1b9d68f76.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200912_d94f9fc1a9d075948633cf9df7a0bee4.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200914_1e5c44544bb31019f8a2074e2ed461b5.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200916_7574369f0de021c1c96b775fa8042bc7.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200917_901d2de72c3c853697cb3880b5086427.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200918_824aa8fd065f27756b1da0da5cdf6281.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200919_40a7d34bbf940425fabb29d88fc5f1fd.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200921_68c7d7f5909b4cf217ca2d62b234b0bf.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200922_7b7867da0ffa41cd07c741a68dc4b2f7.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200923_dd245f1ecfb70f9bf7946f0f13997c21.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200924_ba7c140e51aef384396bb83a239fc521.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200925_14c8458ed02b02b6aa02f743abd574b3.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200928_7424748bafe537883b9a3948f3a13290.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200929_1b7e057e207215cc2cd00f9f981b4c19.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20200930_bafff20128eb4597a3bdf446c141aa88.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201001_2f7169ab8cea853f17686e2f811188a6.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201002_b0f7cf5cede83b2efcf281cfd4b65936.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201003_6598e7f356c7ce38dc40fc6573819b38.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201005_dfbe1bbbbed7ce4e5f8829c468dedc3b.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201006_526ef89464bf61aea9498f00986d4666.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201007_d79fc0bf697737776b31542cb8825123.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201009_c0ff561383c562a9e36ac0001fe3e432.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201010_3d984a039ad5c59e857b6a2a69c8ef98.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::12 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201012_090626725d3864b5b4b6306522c0e039.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201013_6d9dbe441b022532b26de024dd7c22e8.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201014_160bc9b552ba2e582dfdf2494a60634f.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201015_7a3314b6426b923a59617ac793c070fd.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201016_4363eddf7d6bab105923847f37fa47c7.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201017_2f8e6130acbccd72a1c749daa3c9b8b3.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::12 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201019_3a07b65069c69bfe66f44a567b3952b3.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201020_da280990c6cde426855509863301ad11.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201021_514c7a349ae52eb499907e8fe0ba9c3b.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201022_3e2dd684cbce2a9f2028861248ee8f73.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201023_6697a905424a9756d8212139754449cb.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201024_70e5eb28d57d91af71b320eb75cf837d.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201026_c181a620b21e7b3b61a5e851e52982e3.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201027_f17749272842b3bcab4e02a0a3458bb6.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201028_cf634c71c2f43ecf46e6e804a79472ac.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201029_3aa470b2dce969f71f25a4133b747551.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201030_e6751ad10df6a27e438342194cb12a5f.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201031_e58e8d65783b21f960a8a22793fa269d.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201102_5f954b81efa4afafbe42477251cef5af.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201103_118040bfde80a2901346dd3c3dd18723.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201104_109172be37fb28c35a7a7592f0449529.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201105_9f139041041ecac90d4aeac6f92580db.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201106_9fa3e1fb3929917bb0c45dfc623c07ff.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201107_a8b4a7888774cde2511ca28999f1a866.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201109_8b13baff83c94c7c79952b989e23d1fb.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201110_791e77af5f7816b55147a901abd0d649.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:11 PM : Import IN File --->> IN_9_20201111_1a9ceea91beafac3614ed0abd56a2696.TXT ### 6/9/2022 12:47:11 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201112_cead89c9af33fb412f96a163b412ed94.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201113_79559c8836cbd08317af35c91c626651.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201114_65c273ecb67f7ff89a0eaebf21efce46.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201119_3b3f5490633213eccffbcbbd13849b75.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201120_eaeea7fc569dfcae055ff06c5e428064.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201121_728f2fa1b69c43b3609fde5218312d25.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201123_ee0a5fbbb1fc3381e38b461e2860350c.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201124_d237e646ff02a65ddf353df1c5f8f31b.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201126_5f333ef5d853e014645c5d4c37b3baed.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201128_b31182e1296c562628165bbd259a268b.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201130_0019eea6656bcc8fabecde83d8806327.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201201_a0dd3ab99a175a0947fb71fc7923563e.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201202_b5ab2760d65ef8226bc2a3669c651123.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201203_05d2de996269dfa09621ee32966e82e9.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201205_7d28e2014a25e64d103a88b050a74f67.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201207_a7dda65a0cf01c002fa24576cce4c5af.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201208_f2af94a25fee6e8c84d4e9a1bf73e6c4.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201210_d438f5bc65aad243662764ce24272197.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201211_b373adaf9a446b661376ac95e766dfcd.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201212_65ff540eedabbda061501f7aff134b0f.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201214_d9a34a0ed60dce57980ea16fc063cf41.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201215_fa337c58f9c1f6b7ec03b4ebb1793aa0.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201216_27403fe9e6a93601f6d274650baaf7a5.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201217_41c444180b9dbff997f9c5d271eb4eb5.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201218_3c62eb21ed981651c31ae5c39fff3e62.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201219_f6fa5e53dea7632694f3c0bb899b5645.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201221_f71043ea3e962f227c9623b338194ec0.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201222_d57b7c8aee7ca1a409bbbcf315674744.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201223_9406d88e66f411371798d272c5274020.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201224_e8954e155cb5a549ae05e87cf419fcd3.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201225_a858c8be791df73bb4ed8c6a423d8236.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201226_a2fc67d18c4b3d3605326217d5d9f929.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201228_53a8af1ee9e3d86ea6534863af55d3f9.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201229_eb76c5f9f8ce79c482fa3a562a5e19b0.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201230_87d078ad08a76518a1670d4157995ccc.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20201231_8660eb0a3d6834b22a8554870d0a0646.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210101_1adfda84b27a012a6f5b6d7393bdd327.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210102_a890ee690edadfaf81913a52ed2d6b8e.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::15 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210104_84f6868575fdb72a617057c23dbbc0a5.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210107_44a6629a45b584d69887e0aebf1bb685.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210108_5f9bc86efc713092b2a498ebeb4675f8.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210109_8b48f3fe6b0f51fdc9e42baa0efb86af.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210111_22d237b4db6cb6755dbfc2a6a179a7b3.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210112_ac6e4b664b3dce059cf1ce6ace155856.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210113_e39bca9f571e5a8c9e3387d5158833be.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210115_d9b1a677f3d5a5746ebc75731e1d1059.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210116_5b0c6024587bcb8522f98def83f51dd5.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210118_13f1e9dea2c9695e925473e05759284b.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:12 PM : Import IN File --->> IN_9_20210119_c4762da8a283d7d9809f65cacf3d634e.TXT ### 6/9/2022 12:47:12 PM 6/9/2022 12:47:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210120_f6b54c001a750dbcebf4167bfba4d35b.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210121_aab374a7274187461622fc9a44522bfa.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210122_0a845693f1d83fadf63eff3fc1fb4138.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210123_52e4586faa8d7b24257419465f808b3d.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210125_e90e3a47add95d639f13fadfd3153cd6.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210126_1b2a2d9bd0741ccc292705dbd548c699.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210127_60249a0d568d8d9f5180934d18f8532d.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210128_fa66ec502bb430b338b7ee87d1395436.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210129_8e0f8d0d129f4aae72fe52b606ed1e2f.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210130_de0aef1ee5bd1b508ead05b9bc320f6b.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210201_2db3a2fc67096314caa5f80d8dfbb373.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210202_e4657424f080f8ab590cb81dd5788849.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210203_16e718e173503ceb474d196e50d490b1.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210204_a23e05c38d9d4c78060c75144ec133d1.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210205_e53f6a90fe0e91f8f9d375d9797e1a42.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210206_3b325fe6ffc5cec9018b7418a3be2486.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210208_5b8ea13918228acfae76b244a6365e6f.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210209_07f5226aa6eff72673c0c9078dab5cf0.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210210_8d7abb2726f3a91f30e290d9b3c0ec9c.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210211_f03802baa810115502c4eb35acd32ab8.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210212_5f093308127b099d576d1340e7e81a6a.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210213_ad29746da9f8bdce4691169d56e0767b.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210215_33943e9f0a24071313cfcb5d52ff315b.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210216_508e5637b118aa898911baba63fa0549.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210217_0b8cdfb796ab21b98e5c5b54d4d6bdaf.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210218_05cf4ae853e197d32c4bbf3c6794375d.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210219_92d8aeb8b3f370994830f88ae8d9e15b.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210220_c3dacce6ee8c43068eb86975bb094d39.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210222_2369a54bb4168a7d3d49ef33717101b4.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210223_d2d368229b7557088f38ee87c827854d.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::14 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210224_80200648cd6e33e28423ddf9dcb7337d.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210226_5e1edb58946e3810f7069a4e4e38e07a.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210227_1d6a27a830a3235fb93cc3699ec992a7.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210301_81a36ffefadaf40139cfdeaa481a178f.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210302_370d98fa1602696cb5380f2d1294c316.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210304_93a399105a062f533d8193b011bb6343.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210305_960b3a5bd928e6c1912a56c09bb7bc51.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210307_47e63891b1ac3706885a264cf9bd0bb4.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210308_d3d7cc2185b022db6b888145ad25b7a6.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210309_3aea2888cd42b7ac3c3896ecb1f523d7.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210310_19cac0a722b496a195797c3dea227b78.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210312_65b954e90ab8b38cda2d011c004b1977.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210313_4204a120e3f10ab6d69350384d1fbc11.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210315_a48de49356501b96ab39b9442d87fdb5.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::12 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210316_ea0efebfdc4202330763c7e4dea308f1.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210317_c667452cafc595ac3a74ead265aed7f5.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:13 PM : Import IN File --->> IN_9_20210318_fd7b64f46bbf1e1b655a7e7e7123ba25.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210320_17195e4b4eb381e234b27b0482a5b3f0.TXT ### 6/9/2022 12:47:13 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210322_2378ef97b4994ce7d2f881ec0f420e01.TXT ### 6/9/2022 12:47:14 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210323_4114f23f04dddaa88823bccdfccf5ee8.TXT ### 6/9/2022 12:47:14 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210325_f15ebf0b048e1503961d01b5135bdb47.TXT ### 6/9/2022 12:47:14 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210326_78d22e08da458e7e89875b7a815d4a8c.TXT ### 6/9/2022 12:47:14 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210327_763fbc59c9c35cf8ce57bde2772927b7.TXT ### 6/9/2022 12:47:14 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210330_0cf0fd109065665d2518bba1b8866a9e.TXT ### 6/9/2022 12:47:14 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:14 PM : Import IN File --->> IN_9_20210331_3092fe6186f702b89473b4cb1758ab2b.TXT ### 6/9/2022 12:47:14 PM 6/9/2022 12:47:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 12:47:14 PM : command:: flagImportPosting = ### True 6/9/2022 12:47:14 PM : command:: minDate = ### 4/1/2020 12:00:00 AM 6/9/2022 12:47:15 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 6/9/2022 12:47:15 PM 6/9/2022 12:47:17 PM : CustomerLink Diff Successful --->> ### 6/9/2022 12:47:17 PM 6/9/2022 12:47:17 PM : ItemLink Diff Successful --->> ### 6/9/2022 12:47:17 PM 6/9/2022 12:47:17 PM : Supplierlink Query Successful --->> ### 6/9/2022 12:47:17 PM 6/9/2022 12:47:18 PM : Posting Purchases 'true' Successful --->> ### 6/9/2022 12:47:18 PM 6/9/2022 12:47:18 PM : Posting OtherTransaction 'true' Successful --->> ### 6/9/2022 12:47:18 PM 6/9/2022 12:47:28 PM : Posting Sales 'true' Successful --->> ### 6/9/2022 12:47:28 PM 6/9/2022 12:47:32 PM : Completed Updating Has Transaction Flag ### 6/9/2022 12:47:32 PM 6/9/2022 12:47:32 PM : command :: PostDataDeleteInsert ### Done 6/9/2022 12:47:32 PM : command :: set DiffCutOffDate ### Done 6/9/2022 12:47:32 PM : End Process : ImportSplittedFilesOldDeleteInsert() ### 6/9/2022 12:47:32 PM : Import End Time (NEW) Green Care Agencies(9064815) ### 6/9/2022 12:47:32 PM 6/9/2022 12:47:32 PM : -------------Import One Distributor End Time----------- ### 6/9/2022 12:47:32 PM 6/9/2022 2:30:03 PM : Start Process : checkAllTablesExists() ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 2:30:04 PM : StartProcess ### 6/9/2022 2:30:04 PM 6/9/2022 2:30:04 PM : 11 ### 6/9/2022 2:30:04 PM 6/9/2022 2:30:04 PM : 22 ### 6/9/2022 2:30:04 PM 6/9/2022 2:30:04 PM : 33 ### 6/9/2022 2:30:04 PM 6/9/2022 2:30:04 PM : Application Started ### 6/9/2022 2:30:04 PM 6/9/2022 2:30:04 PM : Start Process : checkAllTablesExists() ### 6/9/2022 2:30:04 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 6/9/2022 2:30:04 PM 6/9/2022 2:30:04 PM : MainForm_Load ### AlertSystem ON 6/9/2022 2:30:04 PM : No. of Files to import (RECEIVEFINAL): ### 1641 6/9/2022 2:30:04 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 2:30:05 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:05 PM : Import AD File --->> AD_1025_20220609_c64dc5ba7c8058ff0b30c8628b4b7e56.TXT ### 6/9/2022 2:30:05 PM 6/9/2022 2:30:05 PM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:05 PM : Import AD File --->> AD_1324_20220609_c01e4d07d35ec48a0e4ed67525a9f434.TXT ### 6/9/2022 2:30:05 PM 6/9/2022 2:30:06 PM : For Distributor 000000000001325 Insert Count::3 ### Delete Count::6 6/9/2022 2:30:06 PM : Import AD File --->> AD_1325_20220609_e97949ef1ee4ac247f1ba5d81897567b.TXT ### 6/9/2022 2:30:06 PM 6/9/2022 2:30:06 PM : For Distributor 000000000001328 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:06 PM : Import AD File --->> AD_1328_20220609_6234a87329bf0b5d4803a993bd8631ba.TXT ### 6/9/2022 2:30:06 PM 6/9/2022 2:30:06 PM : For Distributor 000000000000351 Insert Count::14 ### Delete Count::0 6/9/2022 2:30:06 PM : Import AD File --->> AD_351_20220609_7d93e8452ccf8a12e4cdc6f199818c5f.TXT ### 6/9/2022 2:30:06 PM 6/9/2022 2:30:06 PM : For Distributor 000000000000360 Insert Count::2 ### Delete Count::0 6/9/2022 2:30:06 PM : Import AD File --->> AD_360_20220609_b96e42fdaecb4a7631651c7285094eb3.TXT ### 6/9/2022 2:30:06 PM 6/9/2022 2:30:07 PM : For Distributor 000000000000371 Insert Count::5 ### Delete Count::0 6/9/2022 2:30:07 PM : Import AD File --->> AD_371_20220609_c4b88d2121b4f7bbc707cf6f1c4a9de1.TXT ### 6/9/2022 2:30:07 PM 6/9/2022 2:30:07 PM : For Distributor 000000000000373 Insert Count::2 ### Delete Count::0 6/9/2022 2:30:07 PM : Import AD File --->> AD_373_20220609_88638bd338b9700799663dbf2fd9c9a1.TXT ### 6/9/2022 2:30:07 PM 6/9/2022 2:30:07 PM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:07 PM : Import AD File --->> AD_424_20220609_12965c9cf333c243292227164eaa5781.TXT ### 6/9/2022 2:30:07 PM 6/9/2022 2:30:07 PM : For Distributor 000000000000492 Insert Count::5 ### Delete Count::0 6/9/2022 2:30:07 PM : Import AD File --->> AD_492_20220609_667ce7e0b15a6b625f3f44d1dc57e5be.TXT ### 6/9/2022 2:30:07 PM 6/9/2022 2:30:08 PM : For Distributor 000000000000009 Insert Count::60 ### Delete Count::22 6/9/2022 2:30:08 PM : Import AD File --->> AD_9_20220609_574995b35655fa9bd8c662e04fd12daa.TXT ### 6/9/2022 2:30:08 PM 6/9/2022 2:30:16 PM : For Distributor 000000000001328 Insert Count::7 ### Delete Count::0 6/9/2022 2:30:16 PM : Import DN File --->> DN_1328_20220603_1e03df1adc5d452c6268886b98ebaa02.TXT ### 6/9/2022 2:30:16 PM 6/9/2022 2:30:17 PM : For Distributor 000000000000351 Insert Count::14 ### Delete Count::14 6/9/2022 2:30:17 PM : Import DN File --->> DN_351_20220503_f804e4de2f11f02ded9aa9451809d00c.TXT ### 6/9/2022 2:30:17 PM 6/9/2022 2:30:17 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::1 6/9/2022 2:30:17 PM : Import DN File --->> DN_351_20220505_6550e3518d64c8caa755cb6fae30490c.TXT ### 6/9/2022 2:30:17 PM 6/9/2022 2:30:17 PM : For Distributor 000000000000351 Insert Count::5 ### Delete Count::5 6/9/2022 2:30:17 PM : Import DN File --->> DN_351_20220507_5e44729a89db02a1f82dd530a0513d4e.TXT ### 6/9/2022 2:30:17 PM 6/9/2022 2:30:18 PM : For Distributor 000000000000351 Insert Count::2 ### Delete Count::0 6/9/2022 2:30:18 PM : Import DN File --->> DN_351_20220509_6def257cf9e8dbfb4c926fb46cbfb8e3.TXT ### 6/9/2022 2:30:18 PM 6/9/2022 2:30:18 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:18 PM : Import DN File --->> DN_351_20220512_45329ea3c1baa380745fb2d1699c62b6.TXT ### 6/9/2022 2:30:18 PM 6/9/2022 2:30:19 PM : For Distributor 000000000000351 Insert Count::4 ### Delete Count::0 6/9/2022 2:30:19 PM : Import DN File --->> DN_351_20220517_17e9d8adecdf4c19bf16ba17200b8588.TXT ### 6/9/2022 2:30:19 PM 6/9/2022 2:30:19 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:19 PM : Import DN File --->> DN_351_20220518_b3b7652212261b07658380016915b195.TXT ### 6/9/2022 2:30:19 PM 6/9/2022 2:30:19 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:19 PM : Import DN File --->> DN_351_20220520_0aa1eb196673415a4169104d48164eea.TXT ### 6/9/2022 2:30:19 PM 6/9/2022 2:30:19 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:19 PM : Import DN File --->> DN_351_20220523_ac7b3895adfe0fedec41e456df922af3.TXT ### 6/9/2022 2:30:19 PM 6/9/2022 2:30:20 PM : For Distributor 000000000000351 Insert Count::4 ### Delete Count::0 6/9/2022 2:30:20 PM : Import DN File --->> DN_351_20220524_ea201a36bf222aba8711530f46aa9a4e.TXT ### 6/9/2022 2:30:20 PM 6/9/2022 2:30:20 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:20 PM : Import DN File --->> DN_351_20220602_9e513cab22f72bc778eeac1c479b9f81.TXT ### 6/9/2022 2:30:20 PM 6/9/2022 2:30:40 PM : For Distributor 000000000000371 Insert Count::19 ### Delete Count::0 6/9/2022 2:30:40 PM : Import DN File --->> DN_371_20220608_e7f62e1409732cb5eb5b024603fc784b.TXT ### 6/9/2022 2:30:40 PM 6/9/2022 2:30:51 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0 6/9/2022 2:30:51 PM : Import IN File --->> IN_1025_20220604_50ab7e43167f486636e60efec9ba6be5.TXT ### 6/9/2022 2:30:51 PM 6/9/2022 2:30:56 PM : For Distributor 000000000001026 Insert Count::2 ### Delete Count::0 6/9/2022 2:30:56 PM : Import IN File --->> IN_1026_20220609_a5d9831f6cd3cf0c852cba267b67cc3f.TXT ### 6/9/2022 2:30:56 PM 6/9/2022 2:31:00 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1 6/9/2022 2:31:00 PM : Import IN File --->> IN_1321_20220602_882a1f9dd52e7cd880b3dfa2a00f463b.TXT ### 6/9/2022 2:31:00 PM 6/9/2022 2:31:00 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:00 PM : Import IN File --->> IN_1321_20220609_18e84b586eb889adbbfde18940d24078.TXT ### 6/9/2022 2:31:00 PM 6/9/2022 2:31:03 PM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:03 PM : Import IN File --->> IN_1324_20220608_268597682cc328459d2cd82716029d00.TXT ### 6/9/2022 2:31:03 PM 6/9/2022 2:31:03 PM : Import IN File --->> IN_1324_20220609_403103087a50258b9c030f7bd29af250.TXT ### 6/9/2022 2:31:03 PM 6/9/2022 2:31:03 PM : NO Previous File For Distributor 000000000001324 ### Insert Count::1 6/9/2022 2:31:04 PM : Import IN File --->> IN_1325_20220526_e687891b12a45c04c94b21ce8fec29b5.TXT ### 6/9/2022 2:31:04 PM 6/9/2022 2:31:04 PM : NO Previous File For Distributor 000000000001325 ### Insert Count::2 6/9/2022 2:31:04 PM : Import IN File --->> IN_1325_20220528_e89303409269d728093af24ed96063d7.TXT ### 6/9/2022 2:31:04 PM 6/9/2022 2:31:04 PM : NO Previous File For Distributor 000000000001325 ### Insert Count::1 6/9/2022 2:31:04 PM : Import IN File --->> IN_1325_20220531_6e8f5f9d6ee09e48270ffdf2625cc2f1.TXT ### 6/9/2022 2:31:04 PM 6/9/2022 2:31:04 PM : NO Previous File For Distributor 000000000001325 ### Insert Count::1 6/9/2022 2:31:08 PM : Import IN File --->> IN_1328_20220607_fa94883e907a5c2dce9cec96f08129cf.TXT ### 6/9/2022 2:31:08 PM 6/9/2022 2:31:08 PM : NO Previous File For Distributor 000000000001328 ### Insert Count::1 6/9/2022 2:31:09 PM : For Distributor 000000000000351 Insert Count::6 ### Delete Count::4 6/9/2022 2:31:09 PM : Import IN File --->> IN_351_20220502_e59e75356c7cd1e8806e92d552edf45a.TXT ### 6/9/2022 2:31:09 PM 6/9/2022 2:31:09 PM : For Distributor 000000000000351 Insert Count::8 ### Delete Count::8 6/9/2022 2:31:09 PM : Import IN File --->> IN_351_20220504_6f6afeb6bbb01fff129518232197c625.TXT ### 6/9/2022 2:31:09 PM 6/9/2022 2:31:09 PM : For Distributor 000000000000351 Insert Count::7 ### Delete Count::8 6/9/2022 2:31:09 PM : Import IN File --->> IN_351_20220506_487eb516bbce7ba1b4b170f0144e40ed.TXT ### 6/9/2022 2:31:09 PM 6/9/2022 2:31:09 PM : For Distributor 000000000000351 Insert Count::4 ### Delete Count::3 6/9/2022 2:31:09 PM : Import IN File --->> IN_351_20220507_e2d765e070ce5913da83a4e35d3886db.TXT ### 6/9/2022 2:31:09 PM 6/9/2022 2:31:10 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:10 PM : Import IN File --->> IN_351_20220509_6eba1a0f5b2d0784b6060745e61c2a31.TXT ### 6/9/2022 2:31:10 PM 6/9/2022 2:31:10 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:10 PM : Import IN File --->> IN_351_20220510_48762374ebd97ee6ff74d974e2d564cd.TXT ### 6/9/2022 2:31:10 PM 6/9/2022 2:31:10 PM : For Distributor 000000000000351 Insert Count::4 ### Delete Count::0 6/9/2022 2:31:10 PM : Import IN File --->> IN_351_20220511_d2fbd4c48454525e14203e672ccd6e9f.TXT ### 6/9/2022 2:31:10 PM 6/9/2022 2:31:10 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:10 PM : Import IN File --->> IN_351_20220512_bc698f1f820bf9c490752e7fb4287fd7.TXT ### 6/9/2022 2:31:10 PM 6/9/2022 2:31:10 PM : For Distributor 000000000000351 Insert Count::6 ### Delete Count::0 6/9/2022 2:31:10 PM : Import IN File --->> IN_351_20220513_fd387c3abe4525d2a3651752b49d8ad2.TXT ### 6/9/2022 2:31:10 PM 6/9/2022 2:31:10 PM : For Distributor 000000000000351 Insert Count::2 ### Delete Count::0 6/9/2022 2:31:10 PM : Import IN File --->> IN_351_20220514_9753f8ccac5f5dafd4c5368a3256c481.TXT ### 6/9/2022 2:31:10 PM 6/9/2022 2:31:11 PM : For Distributor 000000000000351 Insert Count::2 ### Delete Count::0 6/9/2022 2:31:11 PM : Import IN File --->> IN_351_20220516_713c0b0f842389448548c678021d22de.TXT ### 6/9/2022 2:31:11 PM 6/9/2022 2:31:11 PM : For Distributor 000000000000351 Insert Count::3 ### Delete Count::0 6/9/2022 2:31:11 PM : Import IN File --->> IN_351_20220517_1eee47be5d0b4a765a5986852300512f.TXT ### 6/9/2022 2:31:11 PM 6/9/2022 2:31:11 PM : For Distributor 000000000000351 Insert Count::3 ### Delete Count::0 6/9/2022 2:31:11 PM : Import IN File --->> IN_351_20220518_7edce2d5963040cd3eec381959815f75.TXT ### 6/9/2022 2:31:11 PM 6/9/2022 2:31:11 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:11 PM : Import IN File --->> IN_351_20220519_f3a9df2cfffd44dadb155b6bc22ff378.TXT ### 6/9/2022 2:31:11 PM 6/9/2022 2:31:11 PM : For Distributor 000000000000351 Insert Count::11 ### Delete Count::0 6/9/2022 2:31:11 PM : Import IN File --->> IN_351_20220520_e76d7a46332816c3d2cdf6cb441a81dd.TXT ### 6/9/2022 2:31:11 PM 6/9/2022 2:31:11 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:11 PM : Import IN File --->> IN_351_20220523_607b78e6faf4ea73c7060b4d61fb295f.TXT ### 6/9/2022 2:31:11 PM 6/9/2022 2:31:12 PM : For Distributor 000000000000351 Insert Count::6 ### Delete Count::0 6/9/2022 2:31:12 PM : Import IN File --->> IN_351_20220524_9b53a7cb0507c07a58fac1795b2580c7.TXT ### 6/9/2022 2:31:12 PM 6/9/2022 2:31:12 PM : For Distributor 000000000000351 Insert Count::6 ### Delete Count::0 6/9/2022 2:31:12 PM : Import IN File --->> IN_351_20220525_f8d79ad1b36d445e1fa7dea5922b5f30.TXT ### 6/9/2022 2:31:12 PM 6/9/2022 2:31:12 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:12 PM : Import IN File --->> IN_351_20220526_2552eeb3e241a4f59eae1ffcb99dd481.TXT ### 6/9/2022 2:31:12 PM 6/9/2022 2:31:12 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:12 PM : Import IN File --->> IN_351_20220530_3bb7bd982bd32f9641430080d94c0d00.TXT ### 6/9/2022 2:31:12 PM 6/9/2022 2:31:13 PM : For Distributor 000000000000351 Insert Count::2 ### Delete Count::0 6/9/2022 2:31:13 PM : Import IN File --->> IN_351_20220602_502e6fdb8ddf86248566952813aa05eb.TXT ### 6/9/2022 2:31:13 PM 6/9/2022 2:31:13 PM : For Distributor 000000000000351 Insert Count::3 ### Delete Count::0 6/9/2022 2:31:13 PM : Import IN File --->> IN_351_20220606_3d94cdabdade856ec4cc63a8548cf52c.TXT ### 6/9/2022 2:31:13 PM 6/9/2022 2:31:13 PM : For Distributor 000000000000351 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:13 PM : Import IN File --->> IN_351_20220608_a0eeff0015bfef2bdcc164824740c4a3.TXT ### 6/9/2022 2:31:13 PM 6/9/2022 2:31:25 PM : For Distributor 000000000000360 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:25 PM : Import IN File --->> IN_360_20220531_d0d58061a133384168a8fe2bb6e2d0f7.TXT ### 6/9/2022 2:31:25 PM 6/9/2022 2:31:26 PM : For Distributor 000000000000360 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:26 PM : Import IN File --->> IN_360_20220604_ba33941793247137d70776bb0de13731.TXT ### 6/9/2022 2:31:26 PM 6/9/2022 2:31:26 PM : For Distributor 000000000000360 Insert Count::3 ### Delete Count::0 6/9/2022 2:31:26 PM : Import IN File --->> IN_360_20220608_e7c305decd016b8975c62ec1f4a293bd.TXT ### 6/9/2022 2:31:26 PM 6/9/2022 2:31:26 PM : Import IN File --->> IN_360_20220609_57604b22214dd6992ac64f60e1b6f6cb.TXT ### 6/9/2022 2:31:26 PM 6/9/2022 2:31:26 PM : NO Previous File For Distributor 000000000000360 ### Insert Count::4 6/9/2022 2:31:33 PM : For Distributor 000000000000371 Insert Count::10 ### Delete Count::0 6/9/2022 2:31:33 PM : Import IN File --->> IN_371_20220608_301d1171728a758d423512615c5a14a8.TXT ### 6/9/2022 2:31:33 PM 6/9/2022 2:31:33 PM : Import IN File --->> IN_371_20220609_73af660b786c9e55a3aca4e7cda55c6f.TXT ### 6/9/2022 2:31:33 PM 6/9/2022 2:31:33 PM : NO Previous File For Distributor 000000000000371 ### Insert Count::37 6/9/2022 2:31:37 PM : For Distributor 000000000000373 Insert Count::1 ### Delete Count::0 6/9/2022 2:31:37 PM : Import IN File --->> IN_373_20220608_9a533c9379214d71bb26a003a7be9c71.TXT ### 6/9/2022 2:31:37 PM 6/9/2022 2:31:37 PM : Import IN File --->> IN_373_20220609_1f8a3b5daea6c8d5043c0218ac1a772d.TXT ### 6/9/2022 2:31:37 PM 6/9/2022 2:31:37 PM : NO Previous File For Distributor 000000000000373 ### Insert Count::6 6/9/2022 2:31:41 PM : For Distributor 000000000000424 Insert Count::8 ### Delete Count::0 6/9/2022 2:31:41 PM : Import IN File --->> IN_424_20220609_6d2e23dfc9cbadef8863bac0b2824ec0.TXT ### 6/9/2022 2:31:41 PM 6/9/2022 2:31:44 PM : For Distributor 000000000000492 Insert Count::5 ### Delete Count::0 6/9/2022 2:31:44 PM : Import IN File --->> IN_492_20220606_b9876249219af7812ddf28cd67a5d519.TXT ### 6/9/2022 2:31:44 PM 6/9/2022 2:31:44 PM : For Distributor 000000000000492 Insert Count::4 ### Delete Count::0 6/9/2022 2:31:44 PM : Import IN File --->> IN_492_20220607_bcb0eedabb7fe066c019d8bc1004b827.TXT ### 6/9/2022 2:31:44 PM 6/9/2022 2:31:44 PM : Import IN File --->> IN_492_20220608_100d6b816c5aadc07b2b3c8ac09027fe.TXT ### 6/9/2022 2:31:44 PM 6/9/2022 2:31:44 PM : NO Previous File For Distributor 000000000000492 ### Insert Count::6 6/9/2022 2:31:44 PM : Import IN File --->> IN_492_20220609_78de83853cab326fc25cd987f7f46c53.TXT ### 6/9/2022 2:31:44 PM 6/9/2022 2:31:44 PM : NO Previous File For Distributor 000000000000492 ### Insert Count::1 6/9/2022 2:31:46 PM : Import IN File --->> IN_820_20220609_f07f45170d912a6f63a3fc66cd4b8c7e.TXT ### 6/9/2022 2:31:46 PM 6/9/2022 2:31:46 PM : NO Previous File For Distributor 000000000000820 ### Insert Count::4 6/9/2022 2:31:51 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0 6/9/2022 2:31:51 PM : Import OT File --->> OT_820_20220608_b091d995894cff581fe16eda49752ee3.TXT ### 6/9/2022 2:31:51 PM 6/9/2022 2:31:51 PM : For Distributor 000000000001325 Insert Count::0 ### Delete Count::2 6/9/2022 2:31:51 PM : Import PR File --->> PR_1325_20220609_d8f4c9d1d84f539dc87b333e7f4f9e57.TXT ### 6/9/2022 2:31:51 PM 6/9/2022 2:31:52 PM : For Distributor 000000000000009 Insert Count::3 ### Delete Count::1 6/9/2022 2:31:52 PM : Import PR File --->> PR_9_20220609_bfcea3873cddcfef3141f22acdcfa708.TXT ### 6/9/2022 2:31:52 PM 6/9/2022 2:31:52 PM : PostData() --->> ### 6/9/2022 2:31:52 PM 6/9/2022 2:31:55 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 6/9/2022 2:31:55 PM 6/9/2022 2:32:00 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '09/Jun/2022' ### 6/9/2022 2:32:00 PM 6/9/2022 2:32:00 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '09/Jun/2022' ### 6/9/2022 2:32:00 PM 6/9/2022 2:32:00 PM : ### 6/9/2022 2:32:00 PM : UNLINKEDSALES Record Count Before --->> 184 ### 6/9/2022 2:32:00 PM 6/9/2022 2:32:00 PM : UNLINKEDSALES_DEL Record Count Before --->> 24 ### 6/9/2022 2:32:00 PM 6/9/2022 2:57:30 PM : Start Process : checkAllTablesExists() ### Start 6/9/2022 2:57:30 PM : Import Start Time (NEW) For Green Care Agencies(9064815) ### 6/9/2022 2:57:30 PM 6/9/2022 2:57:30 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 2:57:30 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 2:57:30 PM : Import Masters Completed Green Care Agencies(9064815) ### 6/9/2022 2:57:30 PM 6/9/2022 2:57:30 PM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 6/9/2022 2:57:30 PM : splitFileDaywiseNewNaming ### called 6/9/2022 2:57:30 PM : splitFileDaywiseNewNaming ### called 6/9/2022 2:57:31 PM : command:: ### Delete Unlinked DN 6/9/2022 2:57:31 PM : command:: ### Delete Unlinked DN 6/9/2022 2:57:31 PM : command:: ### Delete SPLITFILEINFO DN 6/9/2022 2:57:31 PM : Import DN File --->> DN_9_20210407_a678bd4b2e6a1a4cf266604036c83f87.TXT ### 6/9/2022 2:57:31 PM 6/9/2022 2:57:31 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 2:57:31 PM : Import DN File --->> DN_9_20210521_4f04a7e2406b6744ebb98c09b4ec1c30.TXT ### 6/9/2022 2:57:31 PM 6/9/2022 2:57:31 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 2:57:31 PM : Import DN File --->> DN_9_20210527_d6d161b703ae598039056d2a57c1f21f.TXT ### 6/9/2022 2:57:31 PM 6/9/2022 2:57:31 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210619_d2c386da2434f2facdb5c08c908e92c9.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210622_7de3dd434671a6c78031eca8d4243688.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210709_044621f9942dfbf0eafe10e9dabe6097.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210716_5b1aab4fe6405a5b10b517c136b5579b.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210717_fa555a6721914d02a6a7283e6b278818.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210720_a4f602f8a894ffc189947c819de5910e.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210721_5c65e9e7bf3366582c4d8b082622344e.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210728_98862b85bfe23fd574f626095e12e6a0.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210801_16254a4e777333cb6ceb54830dd6c5ab.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:32 PM : Import DN File --->> DN_9_20210809_785e521616c6e00b28ef79768215c4b5.TXT ### 6/9/2022 2:57:32 PM 6/9/2022 2:57:32 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 2:57:33 PM : Import DN File --->> DN_9_20210901_4201970d406414969e6aa745fc3fac5b.TXT ### 6/9/2022 2:57:33 PM 6/9/2022 2:57:33 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 2:57:33 PM : Import DN File --->> DN_9_20210920_79e5f00d5b3e7c45b25cf4b7e6d7f018.TXT ### 6/9/2022 2:57:33 PM 6/9/2022 2:57:33 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 2:57:33 PM : Import DN File --->> DN_9_20210921_5eda3151b72a31ea2c8d4fece6f3b91e.TXT ### 6/9/2022 2:57:33 PM 6/9/2022 2:57:33 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 2:57:33 PM : Import DN File --->> DN_9_20210927_431166c93a3bfaa793168fd33e4e0e99.TXT ### 6/9/2022 2:57:33 PM 6/9/2022 2:57:33 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 2:57:33 PM : Import DN File --->> DN_9_20211022_3a93d1cfe54a74d06ccdc1481fd6cef3.TXT ### 6/9/2022 2:57:33 PM 6/9/2022 2:57:33 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 2:57:34 PM : Import DN File --->> DN_9_20211123_2834e2eb2d8647905a2f4af20d24c7ec.TXT ### 6/9/2022 2:57:34 PM 6/9/2022 2:57:34 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 2:57:34 PM : Import DN File --->> DN_9_20211227_110a699c268631647668907a8dbc0af9.TXT ### 6/9/2022 2:57:34 PM 6/9/2022 2:57:34 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 2:57:34 PM : Import DN File --->> DN_9_20220105_32f46d29afc9d4a8b165c057434c904f.TXT ### 6/9/2022 2:57:34 PM 6/9/2022 2:57:34 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 2:57:35 PM : Import DN File --->> DN_9_20220217_37867fec889a632fd7af758261e90d64.TXT ### 6/9/2022 2:57:35 PM 6/9/2022 2:57:35 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 2:57:35 PM : Import DN File --->> DN_9_20220218_004ef5b76f92f79fc9d4029c2edae3e2.TXT ### 6/9/2022 2:57:35 PM 6/9/2022 2:57:35 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 2:57:35 PM : Import DN File --->> DN_9_20220319_279fbb1d0eb503382a1e1a9830fbb966.TXT ### 6/9/2022 2:57:35 PM 6/9/2022 2:57:35 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 2:57:35 PM : command:: flagImportPosting = ### True 6/9/2022 2:57:35 PM : command:: minDate = ### 4/1/2021 12:00:00 AM 6/9/2022 2:57:35 PM : splitFileDaywiseNewNaming ### called 6/9/2022 2:57:36 PM : command:: ### Delete Unlinked IN 6/9/2022 3:03:10 PM : command:: ### Delete Unlinked IN 6/9/2022 3:03:10 PM : command:: ### Delete SPLITFILEINFO IN 6/9/2022 3:03:10 PM : Import IN File --->> IN_9_20210401_ea6926c5e94a2571325557ae42106ed4.TXT ### 6/9/2022 3:03:10 PM 6/9/2022 3:03:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:11 PM : Import IN File --->> IN_9_20210402_c01edd397caa50398b647f020b80baf5.TXT ### 6/9/2022 3:03:11 PM 6/9/2022 3:03:11 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:12 PM : Import IN File --->> IN_9_20210403_7a848487e757fdcd9df894fc3d9c9165.TXT ### 6/9/2022 3:03:12 PM 6/9/2022 3:03:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:12 PM : Import IN File --->> IN_9_20210405_b529bd674ce5d73c2f1491ada82cc86f.TXT ### 6/9/2022 3:03:12 PM 6/9/2022 3:03:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:12 PM : Import IN File --->> IN_9_20210406_5e5af2dc476411e59c4b07d22bc9b544.TXT ### 6/9/2022 3:03:12 PM 6/9/2022 3:03:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:12 PM : Import IN File --->> IN_9_20210407_782df693d39c89885471c8f0ea992ad3.TXT ### 6/9/2022 3:03:12 PM 6/9/2022 3:03:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:12 PM : Import IN File --->> IN_9_20210408_d5ce8d960741d9726f21ca616fbfd21d.TXT ### 6/9/2022 3:03:12 PM 6/9/2022 3:03:12 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:13 PM : Import IN File --->> IN_9_20210410_af66d5a8ba9442de4c0ca673cb25a65b.TXT ### 6/9/2022 3:03:13 PM 6/9/2022 3:03:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:13 PM : Import IN File --->> IN_9_20210412_1e3ed6cf3d4086966a6f427085a4c411.TXT ### 6/9/2022 3:03:13 PM 6/9/2022 3:03:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:13 PM : Import IN File --->> IN_9_20210413_b63773786fb8ba1fdaed91b9a05f65c5.TXT ### 6/9/2022 3:03:13 PM 6/9/2022 3:03:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:13 PM : Import IN File --->> IN_9_20210414_86e96741c82c28b9037cc5c2047ffbde.TXT ### 6/9/2022 3:03:13 PM 6/9/2022 3:03:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:13 PM : Import IN File --->> IN_9_20210415_1ec6edb655910a121e068cee560e9e33.TXT ### 6/9/2022 3:03:13 PM 6/9/2022 3:03:13 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210416_0c5b4c3e759b39bf3ee5820376590b63.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210417_374f2af33a5b0f1454156faa66e61ad6.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210419_b372be86020c1bd446304a62c3ff6456.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210420_210bf65febc7bafe2417ebdd24654931.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210421_887a2ecbc2d44bbf6819059d2e67a790.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:14 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '09/Jun/2022' ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : UNLINKEDSALES Record Count After --->> 59 ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210422_28162e6d84ed02415e588d4c36cf441a.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : ### 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210423_d5f55c7f57479ca6ca0f9d93830085a1.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : Posting Supplierlink Query for Purchases --->> ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210424_7af6a094514f056dc2c36a68940efe99.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210426_ffb9f9077781884b02c78587a8eab25f.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210427_0233bb7a0024da7645701935ac4f148e.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210429_34c8c554af17d46d3599f5f3ecf44ef9.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210430_f485f86c336e8b6419fa70fee8820f2b.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210501_fd63d198ffda62c58de1afc85ba2c834.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210503_13b21e9c80a2707b17e2c35375eea0ae.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210504_5b219915496266d6093a1c4d6f8b0eed.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210505_c1b20d45a09bc8d363da70bb3bd3c227.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210506_0dfae279b969fc6b72335b2dc88d0006.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210507_ceee9afb53eaac0fa0134b4b7c7ee51e.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210508_ecd14eb95c9bee012d2bbed8c0d49aaa.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210510_04e711fd1f64aab48deecd349e4d8a66.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210511_3d7ea31afb91e45f327ab84e6a8df11f.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210512_492c133254a5344568158fb5ecacab97.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210513_481a01d3229287c58f5755f057232dc5.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210514_756d8fb29b73dbd0e89720dea3938163.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210515_e50bfb878e69da860e1fe0ad86c85fa8.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210517_667610be7a60a02b787da318e5233cb2.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210518_68a269334285ed993a0c3b671e3ec494.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210519_a0b8cf76d9c4e799f7ed464f14144911.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210520_6832890cdb75944757ad3dc0d7ffae48.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210521_eb4cde23f7ac9ad18ab841cd7f524115.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210522_5f6c50503d173d217ce235ce40d61d14.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210524_3b325bd09bb5217a22a4e23b1a2c3c8b.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210525_5f6c26b342610e515a229434299fcbb0.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210526_300afe755950372bec3fc2ee68b89aa9.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210527_2dd59807859b7b444dcf9521ebc220d6.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210528_0e6446bcd019f8b7f2f28a8ff1b9c265.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:14 PM : Import IN File --->> IN_9_20210529_f09ec7531b6a7573080ee5631cb2cd33.TXT ### 6/9/2022 3:03:14 PM 6/9/2022 3:03:14 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210531_02543ff65fedec199f628cb091f2895c.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210601_e33b96c4bd6c23ef05d5fbbe2ca00963.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210602_7fa1ed611e86c2dcd55e993dc65ae2e8.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210603_7aaa87b121dac75f197765971a43cde5.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210604_4206220a597c5e2a11200c31631d2a09.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210605_595089cd62bae7ba1fdced392ca0fa65.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210607_5ba97d118f28cb75eeb0c374bdb69355.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210608_aae707c78b7322061bac4e87ab4d3e92.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210609_777e0ad7c6263cc5ba0a1b742c50e9af.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210610_edd8f13bac2aaecf1a953ddcdb6e0ceb.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::15 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210611_f9f029dfe6915783006c1aff9d0df95b.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210612_e56ecf92eee71c6d045c8e19f7d34927.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210614_66ae5b1d25b68f64156552883ff79da6.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210615_b87595149d6e6ae974b27616b43f532c.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210617_7070e96f385ade1e178a33453158caa8.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210618_b73f6537514ffef6a69292ab942d21bc.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210619_dffcb6855b93803abd89b18b37b5422c.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210621_d2e7063ac368741b4868621b3a7bf577.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210622_a5314e23c135bef7c055e013f8187383.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210623_6d6a372c0eeb6fcd8e2af8d021326cdd.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::12 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210624_70e0703379b1e275a7322b7dbbde9d8e.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210625_2593f204397b0cd989c34d7bc0700b77.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:15 PM : Import IN File --->> IN_9_20210626_30d5a5010e154ab392fecebb35fb60b3.TXT ### 6/9/2022 3:03:15 PM 6/9/2022 3:03:15 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210628_cd257ac0ea3156327c9cdf50ef4e8a66.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210629_db9ade45162acc9b5bd276205017cb7f.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210630_0140fb9dd84fd6d2f78d718910aac236.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210701_a255192ac4e5d735f036b68bc59b90ce.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210702_2e1778a12a69d070f958eb07801d4037.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210703_384cc3a3adeb15c99ead20f3456ab467.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210705_889098d98be9756687b7fb26130602ff.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210706_c051edf6ae657564f4f1252251af3234.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210707_049811a44a345c1c50b1b3a923a31693.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210708_671ae0faf40376be9c78ddfe8159b7b1.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::15 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210709_23bb39a4e1603c68c75487cd4e4f1c20.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210710_4e3ee33583a48ef374ca90aa809786ad.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210713_db9a759fc3fef7149e42fb8521600b1b.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210714_d7fb912a348766aeba68efa05a0bfad9.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210715_e02b9205eaeb5981cd8d361d58a29080.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210716_d1b80856ee19c4459a895045b549b39c.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210717_399df07e2eea7db0840c74a17927914c.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210719_14fb108f431b840d0f50e48656eb8584.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210720_bd2fe5d307b427b036f2166739dd896a.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210722_cf9ca0dea0a6f0082578fa767683060e.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210723_43e45afbec1f37f7f412e48689f1cd37.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210724_b2540a4f57f2580a8c4b1c82a096b407.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210726_532e4c6c39f1caeedd2bcfc22340121a.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210727_ca2c70dc8bbb66eb9f6fcc78b4465b69.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210728_d79ebca1db4dc80659171692323e6f31.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::13 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210729_28bf8b97d7383b8f706874dd8050f80b.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210730_147dcc7873737f52e1861c3447f9744d.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210731_97f09ee3b4239353146a70bbdf80453d.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210802_9be84927ecbacbe2f3451634ae6f7692.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210803_9e9a0cfb39f5d3624352db248d4b7fc9.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210805_9a89739898a7a97b3a2a270499b9b3e3.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210806_eaf9dad36646467cc551729dcd2949ff.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210807_4ff31d02047309c5b46d46ea2216893f.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210809_ba3e798fd0638560f994b633326eb686.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210810_b03f59686ef023fe2a72e88ed656c862.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210811_0c47aede3696eaf63c2f9cea46bd9d0f.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:16 PM : Import IN File --->> IN_9_20210812_77bffa817ca95946cb304a2ac61a6c03.TXT ### 6/9/2022 3:03:16 PM 6/9/2022 3:03:16 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210813_b00c4c3c06227fabc8287b53556e4a62.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210814_c4f48ff2c6c2aac08ed3f1b14ae75cfc.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210816_24599e62b0f4ff10bbecf4aefd89a427.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210817_5f4a1fef9d1237d894c2e1079bd128ce.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210818_8dd92613286b1915f82c1c0a83d88387.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210819_726efeca28f96cc8c032bc7000ce149b.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210820_d38722bfdfff9339da27e278a1f8d4bf.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210821_b5e5dacd572f7669980da25304a8da40.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210823_11e234d5c6aec684a90ee638c7e7a27c.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210824_597fb50e4bfe4ac2537adf2dd5a2c6d9.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210825_9dc67ac26df4e534abda29c5722e2ac7.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210826_23e558c994fac48b43f89c40a944ed20.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210827_edf056317b4997bef3fbbc32f4d0682f.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210828_fb8e605cde41e4bf2d6e3034839eb5d0.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210830_dad98f6a99d222980d8a699b4d38c5da.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210831_d2c11f816a0911551c471d4db9ffdff1.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210901_a161cfb052796605a41d7dc53b4b66cb.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210902_3dcbb906f46ba3b761e055a8b19a11f3.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210903_939fb4b572e6597c6c2344dbc4a42211.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210904_a415fbeb10c3b2a512307c4ea08cc77d.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::13 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210906_3fb1640337fa5a18e4bd769d1ecf3385.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210908_b5aaed6e332fdc6c5e714b829dd82874.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210909_212d52aaf3513b36137667bdda9441ce.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210910_a703973147bd337d467a4ce6498db03c.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210911_c38931c924e6315116b0a482537da8cc.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:17 PM : Import IN File --->> IN_9_20210913_df04b25d6af6cdf29ebdf3287439a573.TXT ### 6/9/2022 3:03:17 PM 6/9/2022 3:03:17 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210916_f3307e053d1d4ac1833df1a02f401e1a.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210917_58a45972058cc6a9de45b5c210b208fd.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210918_eec44d834fece6c04cb55037c083958d.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210920_00c2ffae694e97d52811b7c13d160b9a.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::16 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210922_992d86c9e487244092e968b3ac875d9a.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210923_1c1e248fbb2703722daddc5f8d8cdb5e.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::14 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210924_28025f188b3c382cac782ce38f2da1df.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210925_a6798c4ea5404854a48785c89696bec5.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210927_83ca7e71e4084a1d2ceee59061d3f95d.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210929_610899056274e682f7c5abd08c136c32.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20210930_193e6003b57fe9ec09b7b06d7b022387.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211001_aa42b8cfc7b5ab37c543560004b6919a.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211002_7ed268e9076b5181d53644c3f87e25ae.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211004_34f25ca17bf7cd894e5b605885739007.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211005_cfbdea1117f2be6c7dc6d830fa6adebb.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211006_114d905fd87dcdc5d34e7ba9f79c454f.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211007_4ec47b159a2fff07fcb7fce67d97dcaa.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211008_cedb70c3fdfe2e5215459b2228c4c8f5.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211009_395e651fd30c9e65833047d9e064345e.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211011_354601354918674b442b7bbe773dc044.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211012_3d97dccf55aa79ecdaa1f872871ded5a.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::15 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211013_6256e69ddd36cc71cf104f2bddb2c1a1.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211015_2cb6cbcad48cfbc03ae22c8bd904f4b2.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211016_464726383ae246fc3b424ff90d475b28.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211018_b65a26dc03bc91332c9d1530f34d8522.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211019_f5acfdadb5fd3c8922a11718fd6861f6.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211020_063b946bf17276e09d1ed3226c8d17db.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211021_a47be7fef12e76b2299868bb0328bbd8.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::12 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211022_79094e15d9c7df2a7795e47d73f1aa2d.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211023_670ae5368cfcd1d0932abe073618c9f9.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211025_8115a22307503ec3aed1e595215ce6ab.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211026_2fda507c6f098df534e94f87e7a57d8b.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211027_b3cabf1ea96c70594358df6b87a50b28.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211028_9761f576ca03c1741205525591777825.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211029_7a9e13aa1938daee6fe34b20082d0aa3.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:18 PM : Import IN File --->> IN_9_20211030_0f04c71892df98606e8b72da652003c5.TXT ### 6/9/2022 3:03:18 PM 6/9/2022 3:03:18 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211031_1e08d64184165f686c593a5f4a345666.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211101_1352cf16f1ac7d524f4034368dee2f5b.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211102_1f5591d60622681929ca17a976c2f552.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211103_3b25422cc6dcb268e350d0f8656cb492.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211104_e118dfa92e617d00c29f7e1e495b3c0c.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211109_bcdfbc0ba2d62501c17f60f336689c2b.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211110_ad591c9f1f12afbb04e1e6a774d07178.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211111_092355c78500a9512d7a382001ea4234.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211112_db3a7a33537ccee348f7ef337a5f3e13.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211113_55793085860742a59e6313d2baa34eb5.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211115_fa3047d1de8ad4bd0e98fd1a005499a1.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211116_a1d55ad939647354fd4142a99cb2bc41.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211117_2f2d44009dcf24db13335baaca0651a1.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211118_144ad2e42ba1778ec2b2d4b17ff324c4.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211119_8cf2b0f5a0d2f4c0ac2eaf31e3c9446d.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211122_5f8bf03d7374f70703f30629c26289c5.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211124_bcf1fb4d6fb9ca1fd8f06498a715ae09.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211125_18721f40111f3ae74f746bdf39f72621.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::16 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211126_6f899589d2e72f6f0b4dab50f0c4c4c4.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211127_f03b2ea8c6daa5e05a02466a4136a2a9.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211129_acc7bed0357545c72e77a9d6584b41bb.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211130_86ea8571eb99ac174496a7fde6f25e5f.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211201_f0b9c8d1e4712ecb9847d75d14e5bbaa.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::13 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211202_7cb978a5a5553f04b3b6f48ef15dbffe.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211203_b1de95a77a96a0f32d48326e4cec73e1.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211204_5a0e41dee9b37417293beb4b304048ae.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211206_73626fecc3d9811ea24a4312f4f3d541.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211207_989636f80f11f2f831452fe7697419f6.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211208_746f91efce2483949ca55bbf7b0db923.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211209_f8241a57ad2269e8469880171a4c3e93.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211210_0fbf2bb0b8e143c1ca3af840bef8be81.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211211_3ab7b56de931799c8ec77adfbcab1547.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211213_76a25f57ad031e5428883f3e55f1df82.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211214_b73f9ba08f08a05880bef9c2f861f3fd.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211215_af1413ce691a6583e83503d7ac34aa97.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211216_8fd5df50e2f19cf2ad6f442e151e76dc.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211217_807460330b0f69561653a08d7a7f6c6d.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211218_00aef0495151d321a38a0a7ca3f33e01.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211220_e701d961e101c48c26e549f84a7edeca.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211221_79a04965a6db148e7be5b6f7818d69e7.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211222_6e69e70d28367d4d732d09692d9f4316.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211223_4046cb46c36c20e9732ccfe085dbcb8a.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211224_03df324274766611ea878ccf07eff751.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211225_5efd711da49876efbe4668d7e5d997ee.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211227_f66774ce28640a9d1c187bcb3cbdd112.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211228_602306b221587ed5b44881a2fb60ad26.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:19 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:19 PM : Import IN File --->> IN_9_20211229_890d1f255c071122daa5f4dd15f1dc98.TXT ### 6/9/2022 3:03:19 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20211230_a6c45bce3b9ed5357b6976abd46b802f.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20211231_bfe95e85c628a2f93a29b3a737f60268.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220101_c62f9202967b73c48943ac1f1f34a69c.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220103_bfd6e5b22a8505dbbf15824a5c608654.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220104_b9f9ac255ca8baae43b7abdf69f6226e.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220105_b7c8c810a6ab5f00106a0b324474de16.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220106_713f346d12dbe96efd05f57561e99922.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220107_05c0bb9b6e0e9b0c09c62247443fd72b.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220108_561434b2eb4951a74aaeabde5e7f1a34.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220110_499612a4ff1f8ba93cba6f243acee27f.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220111_9dbb3eebce559737cfe5a9aea4fd5d65.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220112_382b5f4aab38161a09a078d86293cb57.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220113_8fe7c868255536169970e451cb646fb6.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220115_d15e60892aa8a80b1038e02b41385f68.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220117_8552dde1370ce12216ccfec8a40a2ee9.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220119_b9eee02c1d8cee3d44ef75f2626f2d1d.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220121_d1ac703c46b96654f0b062df0f9e36de.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220124_5c8da39cb9ccfd7ecd437e570b979cf0.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220125_a7fd8496fad53d0199c3322d9f12c88b.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220126_267da17c97ce354c511979ad2a5f4700.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220127_a7c9c7648cd1dfc866b37ba316c07e89.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220128_313d46894a36bf8c94b7f4eafeff882a.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220129_ef1c72c2ed6c669837d7a565dc4133de.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220131_28472ae63220d6b13f667be24954b19a.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220201_cfb3160680d88a91f788b129f84ac830.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::14 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220202_c8d8a1bffadbd56db3b6475e328061a5.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220203_2636de6eb3a1e0965c31eec53f6f3697.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220204_50b704e48b9a60feb25088a70036ceca.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220205_9fce3ea93bd32c9a99027c3fac75a12f.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220207_ce1060aa0571f6c2c248f6b81e74e78c.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220208_f93f753a10c61b16a5481a4168d30bd6.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220209_97f0c6532e518a6e0d7191b42c788e79.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220210_fb002962a4efc5734666c0d76d1635b2.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220211_8cd101330479e8d00116899a301b86ac.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220212_d9b91148cb06844fb4ec9c03803a1259.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220214_917c2054db9f0469adced171190aa0f6.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:20 PM : Import IN File --->> IN_9_20220215_3cda36f8966821a9ed3d25cad253b37b.TXT ### 6/9/2022 3:03:20 PM 6/9/2022 3:03:20 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:21 PM : Import IN File --->> IN_9_20220216_f060287d2bf3a1500bc9f65084ca74f1.TXT ### 6/9/2022 3:03:21 PM 6/9/2022 3:03:21 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:21 PM : Import IN File --->> IN_9_20220217_6a1d56004dcdeadc9a704af4c24b43b1.TXT ### 6/9/2022 3:03:21 PM 6/9/2022 3:03:21 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:21 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '09/Jun/2022' ### 6/9/2022 3:03:21 PM 6/9/2022 3:03:21 PM : Import IN File --->> IN_9_20220218_2105980b36311933541b4a97f4192121.TXT ### 6/9/2022 3:03:21 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220219_d0b31f2ff706d23130161c5dcccffae5.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220221_f19fe358a99dd5c247561772963624b5.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220222_0f3ce932057c4331a80ddce2d52fa483.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220223_02584ec90ce6881985699e7510f0f4e2.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220224_6cce86f3f6d69c4ed87216b29a30ea8a.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220225_7ee6ddc2b271c744b3070913be3fbe2a.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::9 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220226_de5eb2bb5e7041eb06f78be386f48dcb.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220228_ce1015dd781fa94dc2a2c59a3d58cb6d.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220301_e8af799fccb928f29ba09a2228560c94.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220302_72770a561bcb1db423c110f4a83da316.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220303_071765090cd7d8e326676e7eb747c7b4.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220304_89ec92c8f9c408b815612e1cf779f197.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220305_c01d9d6e1abd4daa725172f612f994f4.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::18 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220307_9a298944b72de1aa646b5e9692cdd8d1.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220308_42bae30b11daf71680c2fc458428e5f8.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220309_02cc8bc0000268c619a8d86d4a1685c0.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220310_da1197c21af45b80379a158de7a9bb3a.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220311_1613b8b983a0ce6789f512d9df9eeaf7.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220312_e29c6d36040f675885432f24cc20c493.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220314_914d8790a8df1af35e93ee0fb1a4f6e6.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220315_d356b274bdc784600499a17d23342cde.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::16 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220316_e315a5a34094f026af1fbecd888111fe.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220317_f90866bfe158b91212e540ff2d57ab54.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220321_941c626bbaa47a02a345dfacc46dea93.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220322_a8d7f4ab91d13eaa128ea734a8029b8e.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220323_4ce8e145976e0de934c19f3deca78c24.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220324_02bd66ee3e52bb423886d11368bf7616.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::1 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220325_134dd693515f6b73674b678b59ad1ae8.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220326_f262a68e5c76f74f6f5c45545d416ede.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220328_4bdc4dc8ab295796c44ab638ae01e71c.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220329_54233025d7534631deaf1b2893edd391.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:22 PM : Import IN File --->> IN_9_20220331_8c4eb45ed0b2e8358a49d7c69beeb6d6.TXT ### 6/9/2022 3:03:22 PM 6/9/2022 3:03:22 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:03:22 PM : command:: flagImportPosting = ### True 6/9/2022 3:03:22 PM : command:: minDate = ### 4/1/2021 12:00:00 AM 6/9/2022 3:03:27 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 6/9/2022 3:03:27 PM 6/9/2022 3:03:27 PM : CustomerLink Diff Successful --->> ### 6/9/2022 3:03:27 PM 6/9/2022 3:03:28 PM : ItemLink Diff Successful --->> ### 6/9/2022 3:03:28 PM 6/9/2022 3:03:28 PM : Supplierlink Query Successful --->> ### 6/9/2022 3:03:28 PM 6/9/2022 3:03:28 PM : Posting Purchases 'true' Successful --->> ### 6/9/2022 3:03:28 PM 6/9/2022 3:03:29 PM : Posting OtherTransaction 'true' Successful --->> ### 6/9/2022 3:03:29 PM 6/9/2022 3:03:29 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '09/Jun/2022' ### 6/9/2022 3:03:29 PM 6/9/2022 3:03:29 PM : Posting Supplierlink Query for CompanyPurchases --->> ### 6/9/2022 3:03:29 PM 6/9/2022 3:03:29 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '09/Jun/2022' ### 6/9/2022 3:03:29 PM 6/9/2022 3:03:30 PM : Posting ClosingStock Successful --->> ### 6/9/2022 3:03:30 PM 6/9/2022 3:03:30 PM : FileWiseHashCode Updated for FlagImport=true records --->> ### 6/9/2022 3:03:30 PM 6/9/2022 3:03:30 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\ 6/9/2022 3:03:30 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1025789_TEMPLATE1.TXT ### 6/9/2022 3:03:30 PM 6/9/2022 3:03:30 PM : Count:: ### TEMPLATE1:157 6/9/2022 3:03:35 PM : Posting Sales 'true' Successful --->> ### 6/9/2022 3:03:35 PM 6/9/2022 3:03:38 PM : Completed Updating Has Transaction Flag ### 6/9/2022 3:03:38 PM 6/9/2022 3:03:38 PM : command :: PostDataDeleteInsert ### Done 6/9/2022 3:03:38 PM : command :: set DiffCutOffDate ### Done 6/9/2022 3:03:38 PM : End Process : ImportSplittedFilesOldDeleteInsert() ### 6/9/2022 3:03:38 PM : Import End Time (NEW) Green Care Agencies(9064815) ### 6/9/2022 3:03:38 PM 6/9/2022 3:03:38 PM : -------------Import One Distributor End Time----------- ### 6/9/2022 3:03:38 PM 6/9/2022 3:03:54 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:03:54 PM 6/9/2022 3:03:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 6/9/2022 3:03:54 PM 6/9/2022 3:03:54 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:03:54 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1986218_TEMPLATE1.TXT ### 6/9/2022 3:03:54 PM 6/9/2022 3:03:54 PM : Count:: ### TEMPLATE1:240 6/9/2022 3:04:09 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:09 PM 6/9/2022 3:04:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1990080_TEMPLATE1.TXT ### 6/9/2022 3:04:09 PM 6/9/2022 3:04:09 PM : Count:: ### TEMPLATE1:16 6/9/2022 3:04:10 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:10 PM 6/9/2022 3:04:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 6/9/2022 3:04:10 PM 6/9/2022 3:04:10 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 6/9/2022 3:04:10 PM 6/9/2022 3:04:10 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 6/9/2022 3:04:10 PM 6/9/2022 3:04:10 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 6/9/2022 3:04:10 PM 6/9/2022 3:04:10 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:10 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 6/9/2022 3:04:10 PM 6/9/2022 3:04:10 PM : Count:: ### TEMPLATE1:65 6/9/2022 3:04:14 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Count:: ### TEMPLATE1:35 6/9/2022 3:04:14 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:14 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3831146_TEMPLATE1.TXT ### 6/9/2022 3:04:14 PM 6/9/2022 3:04:14 PM : Count:: ### TEMPLATE1:20 6/9/2022 3:04:15 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:15 PM 6/9/2022 3:04:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 6/9/2022 3:04:15 PM 6/9/2022 3:04:15 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:15 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 6/9/2022 3:04:15 PM 6/9/2022 3:04:15 PM : Count:: ### TEMPLATE1:15 6/9/2022 3:04:16 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:16 PM 6/9/2022 3:04:16 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3989239_TEMPLATE1.TXT ### 6/9/2022 3:04:16 PM 6/9/2022 3:04:16 PM : Count:: ### TEMPLATE1:196 6/9/2022 3:04:41 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:41 PM 6/9/2022 3:04:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 6/9/2022 3:04:41 PM 6/9/2022 3:04:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 6/9/2022 3:04:41 PM 6/9/2022 3:04:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 6/9/2022 3:04:41 PM 6/9/2022 3:04:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060542_TEMPLATE1.TXT ### 6/9/2022 3:04:41 PM 6/9/2022 3:04:41 PM : Count:: ### TEMPLATE1:49 6/9/2022 3:04:42 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:42 PM 6/9/2022 3:04:42 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 6/9/2022 3:04:42 PM 6/9/2022 3:04:42 PM : Count:: ### TEMPLATE1:111 6/9/2022 3:04:57 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:04:57 PM 6/9/2022 3:04:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 6/9/2022 3:04:57 PM 6/9/2022 3:04:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:04:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061358_TEMPLATE1.TXT ### 6/9/2022 3:04:57 PM 6/9/2022 3:04:57 PM : Count:: ### TEMPLATE1:86 6/9/2022 3:05:09 PM : SP_DistributorTemplatePosting Successful --->> ### 6/9/2022 3:05:09 PM 6/9/2022 3:05:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 6/9/2022 3:05:09 PM 6/9/2022 3:05:09 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:05:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 6/9/2022 3:05:09 PM 6/9/2022 3:05:09 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:05:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 6/9/2022 3:05:09 PM 6/9/2022 3:05:09 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:05:09 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 6/9/2022 3:05:09 PM 6/9/2022 3:05:09 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4. 6/9/2022 3:05:09 PM : Error in file ### TEMPLATE1 (1) at Line 124 6/9/2022 3:05:09 PM : Template Import Complete ### 6/9/2022 3:05:09 PM 6/9/2022 3:05:11 PM : Completed Updating Has Transaction Flag ### 6/9/2022 3:05:11 PM 6/9/2022 3:05:11 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 6/9/2022 3:05:11 PM 6/9/2022 3:05:11 PM : Zylem Access Unblocked ### 6/9/2022 3:05:11 PM 6/9/2022 3:05:12 PM : Application Ended ### 6/9/2022 3:05:12 PM 6/9/2022 3:16:38 PM : Start Process : checkAllTablesExists() ### Start 6/9/2022 3:16:38 PM : Import Start Time (NEW) For Green Care Agencies(9064815) ### 6/9/2022 3:16:38 PM 6/9/2022 3:16:38 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 3:16:38 PM : For Distributor 000000000000009 Insert Count::57 ### Delete Count::111 6/9/2022 3:16:38 PM : Import AD File --->> AD_9_20220609_196e5bdb9a46491025fd3bd8c549c22b.TXT ### 6/9/2022 3:16:38 PM 6/9/2022 3:16:38 PM : ImportINFile ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500 6/9/2022 3:16:39 PM : For Distributor 000000000000009 Insert Count::1 ### Delete Count::0 6/9/2022 3:16:39 PM : Import PR File --->> PR_9_20220609_ef254210961f89ef780d66f78786c30c.TXT ### 6/9/2022 3:16:39 PM 6/9/2022 3:16:39 PM : Import Masters Completed Green Care Agencies(9064815) ### 6/9/2022 3:16:39 PM 6/9/2022 3:16:39 PM : Start Process : ImportSplittedFilesOldDeleteInsert() ### called 6/9/2022 3:16:39 PM : splitFileDaywiseNewNaming ### called 6/9/2022 3:16:39 PM : splitFileDaywiseNewNaming ### called 6/9/2022 3:16:39 PM : command:: ### Delete Unlinked DN 6/9/2022 3:16:39 PM : command:: ### Delete Unlinked DN 6/9/2022 3:16:39 PM : command:: ### Delete SPLITFILEINFO DN 6/9/2022 3:16:39 PM : Import DN File --->> DN_9_20220421_7f40fcea4e112877d40233ec5606f19c.TXT ### 6/9/2022 3:16:39 PM 6/9/2022 3:16:39 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:16:39 PM : command:: flagImportPosting = ### True 6/9/2022 3:16:39 PM : command:: minDate = ### 4/1/2022 12:00:00 AM 6/9/2022 3:16:39 PM : splitFileDaywiseNewNaming ### called 6/9/2022 3:16:39 PM : command:: ### Delete Unlinked IN 6/9/2022 3:16:39 PM : command:: ### Delete Unlinked IN 6/9/2022 3:16:40 PM : command:: ### Delete SPLITFILEINFO IN 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220401_9b8ae583655c89de55f99a3466859f62.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220402_867e655469060a1cbb1fe6b7a74a8c4f.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::16 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220404_f650c9382c20d264416f6d979eaefaa0.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220405_c147ac28a69210a93d27ec1f1dcbb1c7.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220406_0b52a8de15e7bf802b058d8be57128b0.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220407_aa7785cc210873200834c35e834e6032.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220408_40836dc930f0636940b2bc2af0af7305.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220409_c35c4ede7dc10b609df55dbff0eaede6.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220411_1b9f1aa5ddaa47b3dad008dd09b53428.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220412_13aa5595af711af8c9c6f94bdf0ed837.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220413_6bdab27e93b39f6f9bb512125b3a6487.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220414_a7530786e9aa7f527a3e956d6659a841.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220415_08dc5ef57f49ccef65d13eb6488fff97.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220416_77bf90651034bca1ffed8499e621824e.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220418_75e1329fd2238e290c7454e7ea61ccc8.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220419_198b8e56b4d86ccfc7b04d36b92989ba.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220420_5ca847402c0cab1e900705346c495b08.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220421_cbaca1df24404f534a942640f5baf7a0.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220422_daf7e09a280e88c2ce94a4fcc75896f0.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::12 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220423_a66217446430be7aadbfedc6b5268455.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220425_4b4ff8f9d31bbe542423f48b58587cbe.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220426_b752b2564b94ed8074d4a2b2fe49016b.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220427_6a8a8e4e6eeed14557ca11e64101a0fb.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220428_b890cee3c49e4a25ad2b1dacf7e0018e.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220429_57e52f47b5d1c504b84fed0c9d0cdce8.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220430_4708d920035e5ac42bcea1a1edf06d37.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220502_5991a0b2fc73c52b95a66aacae800945.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::17 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220503_2e3766bf713164b3aa942246649102a6.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220504_fe5f61b480f4ec0249f8e51c730a05fa.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220505_5416deb7277e5ce8184bb1c0b43f85a2.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::11 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220506_4978a6ed086707fc57599e132b22cf53.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220507_45c19cc14c5725540da5160a5a0b31e5.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220509_31734f8685b4440c3bc6ffd5b805bac9.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220510_637395670d892519f8ea41697f007d80.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220511_d5324c802a099cfc2999a15a29ed2a41.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220512_5142ed482b7eb4ab87eb6adb0213cf37.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220513_df1e8247ce38c95117caf654c4c071ee.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::8 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220514_f8174f3bcd9a0b371f4dc43f3158c7a5.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220516_e5fd3ab37a8128a90b256abbe117a0bb.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220517_e0b6c438d0111de8f6c94b64fb565ec1.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220518_281f1e37f0b1e64eebea3e256ad7afe4.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220519_26c4f97a1a4ad8440040d671dcb4b3a1.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220520_7d9ea610c56262f52c0a5dfb4d403aeb.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::5 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220521_4c45f110cca87c6d44507362c882bf10.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220523_3fdcd30e63aa43023f124d1c34d2d8fd.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::3 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220524_4281e71332fae488e626be28f9786f3b.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::16 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220526_89687b1952a08030b3fc7c44a0774a22.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::7 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220527_34196895ce1cb6b6bae2decb91e43ae7.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::2 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220528_4a83c4a2e0018ba8452856386506e67e.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::4 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220530_7ad1764587fa2ede073a7dbf2782873b.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::6 6/9/2022 3:16:40 PM : Import IN File --->> IN_9_20220531_887d3f3ca981f454e57d7029051a41e7.TXT ### 6/9/2022 3:16:40 PM 6/9/2022 3:16:40 PM : NO Previous File For Distributor 000000000000009 ### Insert Count::10 6/9/2022 3:16:41 PM : command:: flagImportPosting = ### True 6/9/2022 3:16:41 PM : command:: minDate = ### 4/1/2022 12:00:00 AM 6/9/2022 3:16:42 PM : SP_CreateUnkCustomerUnkItem Successful --->> ### 6/9/2022 3:16:42 PM 6/9/2022 3:16:43 PM : CustomerLink Diff Successful --->> ### 6/9/2022 3:16:43 PM 6/9/2022 3:16:44 PM : ItemLink Diff Successful --->> ### 6/9/2022 3:16:44 PM 6/9/2022 3:16:44 PM : Supplierlink Query Successful --->> ### 6/9/2022 3:16:44 PM 6/9/2022 3:16:44 PM : Posting Purchases 'true' Successful --->> ### 6/9/2022 3:16:44 PM 6/9/2022 3:16:45 PM : Posting OtherTransaction 'true' Successful --->> ### 6/9/2022 3:16:45 PM 6/9/2022 3:16:49 PM : Posting Sales 'true' Successful --->> ### 6/9/2022 3:16:49 PM 6/9/2022 3:16:52 PM : Completed Updating Has Transaction Flag ### 6/9/2022 3:16:52 PM 6/9/2022 3:16:52 PM : command :: PostDataDeleteInsert ### Done 6/9/2022 3:16:52 PM : command :: set DiffCutOffDate ### Done 6/9/2022 3:16:52 PM : End Process : ImportSplittedFilesOldDeleteInsert() ### 6/9/2022 3:16:52 PM : Import End Time (NEW) Green Care Agencies(9064815) ### 6/9/2022 3:16:52 PM 6/9/2022 3:16:52 PM : -------------Import One Distributor End Time----------- ### 6/9/2022 3:16:52 PM