Config Settings retrieved Retrieving Email Settings biskra@skyfile.com Reading Outlook Inbox Email Reading Started Email from biskra@skyfile.com Count of Email : 138 collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp collectionItem newEmail Email found Email Moved in Jot_Temp Email Reading Started Email from biskra@skyfile.com Count of Email : 136 collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp Email Reading Started Email from biskra@skyfile.com Count of Email : 135 collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp Imported Started files found MARI-BISK-O20213638.RAR Imported Started for MARI-BISK-O20213638.RAR Reading Packet Data Reading file content TBL_LIB_PURC_ITEMS found in packet Getting tables data type TBL_LIB_PURC_ITEMS Packet Where Condition where 1=1 and Item_Intern_Ref='2021101818512649301' Record Inserting INTO TBL_LIB_PURC_ITEMS insert into TBL_LIB_PURC_ITEMS([Item_Intern_Ref],[Vessel_ID],[Catalogue_ID],[Subcatalogue_ID],[Item_Category],[Drawing_Number],[Part_Number],[Item_Description],[Item_Details],[Packing_ID],[Inventory_Min],[Inventory_Max],[Item_Critical_flag],[Item_addr_Deck],[Item_addr_Store],[Item_addr_Rack],[Item_Image],[Item_specs_Image],[Created_By],[Date_Created],[Modified_By],[Date_Modified],[Deleted_By],[Date_Deleted],[Active_Status],[Is_Approved],[Pending_with],[Approved_By],[Date_Approved],[Approved_Remark]) values('2021101818512649301',0,3011,3026,null,'0','0','Life Boat Battery Charger; ; Maker - JHCD; ; CD - 4212 - 2, IP 56; ; Main Voltage: – 42V AC; ; Charge Voltage: – 2 x 12V DC; ; Charge Current : - 2 x 3A DC; ; WUXI JIANGHAI MARINE ELECTRIC; ; APPARATUS WORKS','Life Boat Battery Charger; ; Maker - JHCD; ; CD - 4212 - 2, IP 56; ; Main Voltage: – 42V AC; ; Charge Voltage: – 2 x 12V DC; ; Charge Current : - 2 x 3A DC; ; WUXI JIANGHAI MARINE ELECTRIC; ; APPARATUS WORKS',61,null,null,null,null,null,null,null,null,105977,'2021-10-18 18:51',null,null,null,null,1,0,null,null,null,null) Reading file content TBL_LIB_PURC_ITEMS found in packet Getting tables data type TBL_LIB_PURC_ITEMS Packet Where Condition where 1=1 and Item_Intern_Ref='2021101819041959001' Record Inserting INTO TBL_LIB_PURC_ITEMS insert into TBL_LIB_PURC_ITEMS([Item_Intern_Ref],[Vessel_ID],[Catalogue_ID],[Subcatalogue_ID],[Item_Category],[Drawing_Number],[Part_Number],[Item_Description],[Item_Details],[Packing_ID],[Inventory_Min],[Inventory_Max],[Item_Critical_flag],[Item_addr_Deck],[Item_addr_Store],[Item_addr_Rack],[Item_Image],[Item_specs_Image],[Created_By],[Date_Created],[Modified_By],[Date_Modified],[Deleted_By],[Date_Deleted],[Active_Status],[Is_Approved],[Pending_with],[Approved_By],[Date_Approved],[Approved_Remark]) values('2021101819041959001',0,644,2841,null,'0','ZB1-500','Transformer (in Protected Case); ; Model – ZB1 - 500; ; Prim. – 100V, Sec. – 42V, 50/60 Hz, IP - 56','Transformer (in Protected Case); ; Model – ZB1 - 500; ; Prim. – 100V, Sec. – 42V, 50/60 Hz, IP - 56',61,null,null,null,null,null,null,null,null,105977,'2021-10-18 19:04',null,null,null,null,1,0,null,null,null,null) Reading file content SQL_UPDATE found in packet UPDATE JOT_Sync_Packet_Status SET EXECUTE_STATUS=1, EXECUTE_DATE='2021-10-18 08:21:47 PM' where PACKET_NAME='BISK-MARI-V20211815.RAR' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_294_9FF09D26-9758-4A76-88A3-2026AE296CD8' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_294_9FF09D26-9758-4A76-88A3-2026AE296CD8',[VESSEL_ID]=294,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='NAD_1_294_D635037C-57F6-4F77-A468-6B78827467F3.docx',[Content_Type]='application/vnd.openxmlformats-officedocument.wordprocessingml.document',[File_Size]='48354',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 12:49 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_294_9FF09D26-9758-4A76-88A3-2026AE296CD8' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_294_BA23FA23-4AD0-4EE8-8F4E-1BC6B6AD3025' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_294_BA23FA23-4AD0-4EE8-8F4E-1BC6B6AD3025',[VESSEL_ID]=294,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='NAD_1_294_51923A8B-9DD2-4D4D-A0EA-887585BEAA4E.xlsx',[Content_Type]='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',[File_Size]='32039',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 12:49 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_294_BA23FA23-4AD0-4EE8-8F4E-1BC6B6AD3025' Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7091 Record Inserting INTO TBL_LIB_PURC_SUPPLIER_MAIN insert into TBL_LIB_PURC_SUPPLIER_MAIN([SUPPLIER_ID],[SUPPLIER_NAME],[SUPPLIER_TYPE],[SUPPLIER_ADDRESS1],[SUPPLIER_ADDRESS2],[SUPPLIER_CITY],[SUPPLIER_ZIP],[SUPPLIER_COUNTRY],[CURRENCY_USED],[REGISTRATION_NUM],[DATE_REGISTERED],[EVAL_FREQUENCY],[CREDIT_TERMS],[GST_VAT_REGISTRATION_NUM],[PASSWORD_USED],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[USER_ID],[ISO_Accreditations],[PREFERRED_RFQ_FORMAT],[SUPPLIER_CODE],[Website]) values(7091,'MRC',103,'South Korea',null,7687,null,112,148,'7072','2021-01-01 00:00',12,30,null,'Wj7VoVOy/+7ytLNAvim/Yw==',6,'2021-10-18 20:57',null,null,null,null,1,113429,null,1,null,null) Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2965 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_STATUS insert into TBL_DTL_PURC_SUPPLIER_STATUS([ID],[SUPPLIER_ID],[PROPOSED_STATUS],[PROPOSED_BY],[PROPOSED_ACTION_DAYS],[DATE_PROPOSED],[PROPOSER_REMARKS],[APPROVED_STATUS],[APPROVED_BY],[APPROVED_ACTION_DAYS],[DATE_APPROVED],[APPROVER_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[PIC]) values(2965,7091,113,6,156,'2021-10-18 20:57',null,null,null,null,null,null,6,'2021-10-18 20:57',null,null,null,null,1,null) Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7091 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7091,[SUPPLIER_NAME]='MRC',[SUPPLIER_TYPE]=103,[SUPPLIER_ADDRESS1]='South Korea',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=7687,[SUPPLIER_ZIP]=null,[SUPPLIER_COUNTRY]=112,[CURRENCY_USED]=148,[REGISTRATION_NUM]='7072',[DATE_REGISTERED]='2021-01-01 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 20:57 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113429,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=1,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7091 Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2965 Record already exist in TBL_DTL_PURC_SUPPLIER_STATUS update TBL_DTL_PURC_SUPPLIER_STATUS set [ID]=2965,[SUPPLIER_ID]=7091,[PROPOSED_STATUS]=113,[PROPOSED_BY]=6,[PROPOSED_ACTION_DAYS]=156,[DATE_PROPOSED]='2021-10-18 20:57 ',[PROPOSER_REMARKS]=null,[APPROVED_STATUS]=114,[APPROVED_BY]=6,[APPROVED_ACTION_DAYS]=533,[DATE_APPROVED]='2021-10-18 20:57 ',[APPROVER_REMARKS]='Approved for 25 years',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 20:57 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[PIC]=null where 1=1 and ID=2965 Reading file content found in packet Update_PacketStatus Packet Deleted System.String[] C:\JotApps\Sync\Imports\MARI-BISK-O20213639.RAR BatchScript C:\JotApps\Sync\Imports\MARI-BISK-O20213640.RAR BatchScript C:\JotApps\Sync\Imports\MARI-BISK-O20213641.RAR BatchScript files found MARI-BISK-O20213639.RAR Imported Started for MARI-BISK-O20213639.RAR Reading Packet Data Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7091 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7091,[SUPPLIER_NAME]='MRC',[SUPPLIER_TYPE]=103,[SUPPLIER_ADDRESS1]='South Korea',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=7687,[SUPPLIER_ZIP]=null,[SUPPLIER_COUNTRY]=112,[CURRENCY_USED]=148,[REGISTRATION_NUM]='7072',[DATE_REGISTERED]='2021-01-01 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 20:57 ',[MODIFIED_BY]=6,[DATE_MODIFIED]='2021-10-18 21:18 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113429,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=1,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7091 Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7091 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7091,[SUPPLIER_NAME]='MRC',[SUPPLIER_TYPE]=103,[SUPPLIER_ADDRESS1]='South Korea',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=7687,[SUPPLIER_ZIP]=null,[SUPPLIER_COUNTRY]=112,[CURRENCY_USED]=148,[REGISTRATION_NUM]='7072',[DATE_REGISTERED]='2021-01-01 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 20:57 ',[MODIFIED_BY]=6,[DATE_MODIFIED]='2021-10-18 21:18 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113429,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=1,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7091 Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2965 Record already exist in TBL_DTL_PURC_SUPPLIER_STATUS update TBL_DTL_PURC_SUPPLIER_STATUS set [ID]=2965,[SUPPLIER_ID]=7091,[PROPOSED_STATUS]=113,[PROPOSED_BY]=6,[PROPOSED_ACTION_DAYS]=156,[DATE_PROPOSED]='2021-10-18 20:57 ',[PROPOSER_REMARKS]=null,[APPROVED_STATUS]=114,[APPROVED_BY]=6,[APPROVED_ACTION_DAYS]=533,[DATE_APPROVED]='2021-10-18 21:19 ',[APPROVER_REMARKS]='Approved for 25 years',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 20:57 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[PIC]=null where 1=1 and ID=2965 Reading file content TBL_DTL_PURC_SUPPLIER_CONTACTS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_CONTACTS Packet Where Condition where 1=1 and ID=6854 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_CONTACTS insert into TBL_DTL_PURC_SUPPLIER_CONTACTS([ID],[SUPPLIER_ID],[CONTACT_DEPARTMENT],[CONTACT_NAME],[CONTACT_ADDRESS1],[CONTACT_ADDRESS2],[CONTACT_CITY],[CONTACT_ZIP],[CONTACT_COUNTRY],[CONTACT_MOBILE],[CONTACT_PHONE1],[CONTACT_EMAIL_INDIVIDUAL],[CONTACT_EMAIL_DEPT],[CONTACT_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[RFQ_EMAIL],[INVOICE_EMAIL]) values(6854,7091,null,'MRC','South Korea',null,7687,null,112,'+82-514147891','+82-','sales@mrckorea.com','sales@mrckorea.com',null,6,'2021-10-18 21:11',6,'2021-10-18 21:12',null,null,1,'sales@mrckorea.com','sales@mrckorea.com') Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7092 Record Inserting INTO TBL_LIB_PURC_SUPPLIER_MAIN insert into TBL_LIB_PURC_SUPPLIER_MAIN([SUPPLIER_ID],[SUPPLIER_NAME],[SUPPLIER_TYPE],[SUPPLIER_ADDRESS1],[SUPPLIER_ADDRESS2],[SUPPLIER_CITY],[SUPPLIER_ZIP],[SUPPLIER_COUNTRY],[CURRENCY_USED],[REGISTRATION_NUM],[DATE_REGISTERED],[EVAL_FREQUENCY],[CREDIT_TERMS],[GST_VAT_REGISTRATION_NUM],[PASSWORD_USED],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[USER_ID],[ISO_Accreditations],[PREFERRED_RFQ_FORMAT],[SUPPLIER_CODE],[Website]) values(7092,'Wynn',103,'UK',null,11298,null,253,148,'7072','2021-01-01 00:00',12,30,null,'Wj7VoVOy/+7ytLNAvim/Yw==',6,'2021-10-18 21:36',null,null,null,null,1,113430,null,1,null,null) Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2966 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_STATUS insert into TBL_DTL_PURC_SUPPLIER_STATUS([ID],[SUPPLIER_ID],[PROPOSED_STATUS],[PROPOSED_BY],[PROPOSED_ACTION_DAYS],[DATE_PROPOSED],[PROPOSER_REMARKS],[APPROVED_STATUS],[APPROVED_BY],[APPROVED_ACTION_DAYS],[DATE_APPROVED],[APPROVER_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[PIC]) values(2966,7092,113,6,156,'2021-10-18 21:36',null,null,null,null,null,null,6,'2021-10-18 21:36',null,null,null,null,1,null) Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7092 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7092,[SUPPLIER_NAME]='Wynn',[SUPPLIER_TYPE]=103,[SUPPLIER_ADDRESS1]='UK',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=11298,[SUPPLIER_ZIP]=null,[SUPPLIER_COUNTRY]=253,[CURRENCY_USED]=148,[REGISTRATION_NUM]='7072',[DATE_REGISTERED]='2021-01-01 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 21:36 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113430,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=1,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7092 Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2966 Record already exist in TBL_DTL_PURC_SUPPLIER_STATUS update TBL_DTL_PURC_SUPPLIER_STATUS set [ID]=2966,[SUPPLIER_ID]=7092,[PROPOSED_STATUS]=113,[PROPOSED_BY]=6,[PROPOSED_ACTION_DAYS]=156,[DATE_PROPOSED]='2021-10-18 21:36 ',[PROPOSER_REMARKS]=null,[APPROVED_STATUS]=114,[APPROVED_BY]=6,[APPROVED_ACTION_DAYS]=533,[DATE_APPROVED]='2021-10-18 21:37 ',[APPROVER_REMARKS]='Approved for 25 years',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 21:36 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[PIC]=null where 1=1 and ID=2966 Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7092 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7092,[SUPPLIER_NAME]='Wynn',[SUPPLIER_TYPE]=103,[SUPPLIER_ADDRESS1]='UK',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=11298,[SUPPLIER_ZIP]=null,[SUPPLIER_COUNTRY]=253,[CURRENCY_USED]=148,[REGISTRATION_NUM]='7072',[DATE_REGISTERED]='2021-01-01 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 21:36 ',[MODIFIED_BY]=6,[DATE_MODIFIED]='2021-10-18 21:37 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113430,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=1,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7092 Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7092 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7092,[SUPPLIER_NAME]='Wynn',[SUPPLIER_TYPE]=103,[SUPPLIER_ADDRESS1]='UK',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=11298,[SUPPLIER_ZIP]=null,[SUPPLIER_COUNTRY]=253,[CURRENCY_USED]=148,[REGISTRATION_NUM]='7072',[DATE_REGISTERED]='2021-01-01 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 21:36 ',[MODIFIED_BY]=6,[DATE_MODIFIED]='2021-10-18 21:37 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113430,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=1,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7092 Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2966 Record already exist in TBL_DTL_PURC_SUPPLIER_STATUS update TBL_DTL_PURC_SUPPLIER_STATUS set [ID]=2966,[SUPPLIER_ID]=7092,[PROPOSED_STATUS]=113,[PROPOSED_BY]=6,[PROPOSED_ACTION_DAYS]=156,[DATE_PROPOSED]='2021-10-18 21:36 ',[PROPOSER_REMARKS]=null,[APPROVED_STATUS]=114,[APPROVED_BY]=6,[APPROVED_ACTION_DAYS]=533,[DATE_APPROVED]='2021-10-18 21:37 ',[APPROVER_REMARKS]='Approved for 25 years',[CREATED_BY]=6,[DATE_CREATED]='2021-10-18 21:36 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[PIC]=null where 1=1 and ID=2966 Reading file content TBL_DTL_PURC_SUPPLIER_CONTACTS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_CONTACTS Packet Where Condition where 1=1 and ID=6855 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_CONTACTS insert into TBL_DTL_PURC_SUPPLIER_CONTACTS([ID],[SUPPLIER_ID],[CONTACT_DEPARTMENT],[CONTACT_NAME],[CONTACT_ADDRESS1],[CONTACT_ADDRESS2],[CONTACT_CITY],[CONTACT_ZIP],[CONTACT_COUNTRY],[CONTACT_MOBILE],[CONTACT_PHONE1],[CONTACT_EMAIL_INDIVIDUAL],[CONTACT_EMAIL_DEPT],[CONTACT_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[RFQ_EMAIL],[INVOICE_EMAIL]) values(6855,7092,null,'Wynn','UK',null,11298,null,253,'+44-','+44-','purchasing@maritectankers.com','purchasing@maritectankers.com',null,6,'2021-10-18 21:37',null,null,null,null,1,'purchasing@maritectankers.com','purchasing@maritectankers.com') Reading file content found in packet Update_PacketStatus Packet Deleted System.String[] C:\JotApps\Sync\Imports\MARI-BISK-O20213640.RAR BatchScript C:\JotApps\Sync\Imports\MARI-BISK-O20213641.RAR BatchScript files found MARI-BISK-O20213640.RAR Imported Started for MARI-BISK-O20213640.RAR Reading Packet Data Reading file content TBL_LIB_PURC_VESSEL_LOCATION found in packet Getting tables data type TBL_LIB_PURC_VESSEL_LOCATION Packet Where Condition where 1=1 and ID=707 Record Inserting INTO TBL_LIB_PURC_VESSEL_LOCATION insert into TBL_LIB_PURC_VESSEL_LOCATION([ID],[PARENT_ID],[LOCATION_NAME],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[SFI_ID]) values(707,null,'Sanitary System',106264,'2021-10-19 12:47',null,null,null,null,1,null) Reading file content found in packet Update_PacketStatus Packet Deleted System.String[] C:\JotApps\Sync\Imports\MARI-BISK-O20213641.RAR BatchScript files found MARI-BISK-O20213641.RAR Imported Started for MARI-BISK-O20213641.RAR Reading Packet Data Reading file content TBL_LIB_PURC_VESSEL_LOCATION found in packet Getting tables data type TBL_LIB_PURC_VESSEL_LOCATION Packet Where Condition where 1=1 and ID=708 Record Inserting INTO TBL_LIB_PURC_VESSEL_LOCATION insert into TBL_LIB_PURC_VESSEL_LOCATION([ID],[PARENT_ID],[LOCATION_NAME],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[SFI_ID]) values(708,null,'Ballast Water Treatment plant',106264,'2021-10-19 14:28',null,null,null,null,1,null) Reading file content found in packet Update_PacketStatus Packet Deleted System.String[] Export Started - reading configuration setting Reading Company and Vessel Data Reading synch table data Preparing Packet Name on Vessel name Preparing Packet Data Packet Data ready Content writing to file befor missing file check record size56022 befor sync_file check record size56022 File found to Sent REP_1_294_D2B06BC1-0AEA-478B-A13E-A711CD6A5EBE.pdf File found to Sent QMS_86a55bf2-47f4-45ac-839f-727aeff6e279.docx Error while Adding Binary data to packet Could not find file '\\BIS-JOT\Joterp$\Uploads\QMS\QMS_86a55bf2-47f4-45ac-839f-727aeff6e279.docx'. Email Sending Started - Send PacketBy Email - Send auto email - Sending Via Outlook Send Using Account biskra@skyfile.com Config Settings retrieved Retrieving Email Settings biskra@skyfile.com Reading Outlook Inbox Email Reading Started Email from biskra@skyfile.com Count of Email : 136 collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp Email Reading Started Email from biskra@skyfile.com Count of Email : 135 collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp Imported Started files found MARI-BISK-O20213642.RAR Imported Started for MARI-BISK-O20213642.RAR Reading Packet Data Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7094 Record Inserting INTO TBL_LIB_PURC_SUPPLIER_MAIN insert into TBL_LIB_PURC_SUPPLIER_MAIN([SUPPLIER_ID],[SUPPLIER_NAME],[SUPPLIER_TYPE],[SUPPLIER_ADDRESS1],[SUPPLIER_ADDRESS2],[SUPPLIER_CITY],[SUPPLIER_ZIP],[SUPPLIER_COUNTRY],[CURRENCY_USED],[REGISTRATION_NUM],[DATE_REGISTERED],[EVAL_FREQUENCY],[CREDIT_TERMS],[GST_VAT_REGISTRATION_NUM],[PASSWORD_USED],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[USER_ID],[ISO_Accreditations],[PREFERRED_RFQ_FORMAT],[SUPPLIER_CODE],[Website]) values(7094,'ETS SEALAND SUPPORT',102,'AKWA 55, DOUALA, LITORAL, 7472',null,2646,'7472',38,148,'RC/DLA/2015/A/278','2015-01-21 00:00',12,30,null,'Wj7VoVOy/+7ytLNAvim/Yw==',105977,'2021-10-19 16:43',null,null,null,null,1,113433,null,1,null,null) Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2967 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_STATUS insert into TBL_DTL_PURC_SUPPLIER_STATUS([ID],[SUPPLIER_ID],[PROPOSED_STATUS],[PROPOSED_BY],[PROPOSED_ACTION_DAYS],[DATE_PROPOSED],[PROPOSER_REMARKS],[APPROVED_STATUS],[APPROVED_BY],[APPROVED_ACTION_DAYS],[DATE_APPROVED],[APPROVER_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[PIC]) values(2967,7094,113,105977,156,'2021-10-19 16:43',null,null,null,null,null,null,105977,'2021-10-19 16:43',null,null,null,null,1,null) Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7094 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7094,[SUPPLIER_NAME]='ETS SEALAND SUPPORT',[SUPPLIER_TYPE]=102,[SUPPLIER_ADDRESS1]='AKWA 55, DOUALA, LITORAL, 7472',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=2646,[SUPPLIER_ZIP]='7472',[SUPPLIER_COUNTRY]=38,[CURRENCY_USED]=148,[REGISTRATION_NUM]='RC/DLA/2015/A/278',[DATE_REGISTERED]='2015-01-21 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=105977,[DATE_CREATED]='2021-10-19 16:43 ',[MODIFIED_BY]=105977,[DATE_MODIFIED]='2021-10-19 17:06 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113433,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=2,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7094 Reading file content SQL_UPDATE found in packet UPDATE JOT_Sync_Packet_Status SET EXECUTE_STATUS=1, EXECUTE_DATE='2021-10-19 05:24:19 PM' where PACKET_NAME='BISK-MARI-V20211816.RAR' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_294_6609B48F-E5B7-465F-AB71-4BFE658CA3F6' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_294_6609B48F-E5B7-465F-AB71-4BFE658CA3F6',[VESSEL_ID]=294,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='REP_1_294_D2B06BC1-0AEA-478B-A13E-A711CD6A5EBE.pdf',[Content_Type]='application/pdf',[File_Size]='358117',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-19 09:28 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_294_6609B48F-E5B7-465F-AB71-4BFE658CA3F6' Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7094 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7094,[SUPPLIER_NAME]='ETS SEALAND SUPPORT',[SUPPLIER_TYPE]=102,[SUPPLIER_ADDRESS1]='AKWA 55, DOUALA, LITORAL, 7472',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=2646,[SUPPLIER_ZIP]='7472',[SUPPLIER_COUNTRY]=38,[CURRENCY_USED]=148,[REGISTRATION_NUM]='RC/DLA/2015/A/278',[DATE_REGISTERED]='2015-01-21 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=105977,[DATE_CREATED]='2021-10-19 16:43 ',[MODIFIED_BY]=105977,[DATE_MODIFIED]='2021-10-19 17:25 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113433,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=2,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7094 Reading file content found in packet Update_PacketStatus Packet Deleted System.String[] C:\JotApps\Sync\Imports\MARI-BISK-O20213643.RAR BatchScript files found MARI-BISK-O20213643.RAR Imported Started for MARI-BISK-O20213643.RAR Reading Packet Data Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_ACC_PB_ALLOTMENTS]( [ID] [int] NOT NULL, [Vessel_ID] [int] NOT NULL, [Crew_ID] [int] NOT NULL, [Voyage_ID] [int] NOT NULL, [PortageBill_Date] [datetime] NOT NULL, [Bank_Acc_ID] [nvarchar](45) NOT NULL, [Currency_ID] [int] NULL, [Allotment_Amount] [decimal](18, 2) NULL, [Balance] [decimal](18, 2) NULL, [Allotment_Remarks] [varchar](max) NULL, [Allotment_Sent_Status] [int] NULL, [Is_Special_Allotment] [int] NULL, [Mode] [varchar](max) NULL, [Payment_Remarks] [varchar](max) NULL, [Flag_Status] [int] NULL, [Sign_Off] [int] NULL, [Approved_By] [int] NULL, [Date_Approved] [datetime] NULL, [Created_By] [int] NOT NULL, [Date_Created] [datetime] NOT NULL, [Modified_By] [int] NULL, [Date_Modified] [datetime] NULL, [Deleted_By] [int] NULL, [Date_Deleted] [datetime] NULL, [Active_Status] [int] NOT NULL, [REF_NUMBER] [nvarchar](max) NULL, [Is_Finalized] [int] NULL, [Bank_UID] [nvarchar](45) NOT NULL CONSTRAINT [DF__TBL_DTL_A__Bank___3B2EEBF9] DEFAULT ((0)), CONSTRAINT [PK_TBL_DTL_ACC_PB_ALLOTMENTS] PRIMARY KEY CLUSTERED ( [ID] ASC, [Vessel_ID] ASC, [PortageBill_Date] ASC )) There is already an object named 'TBL_DTL_ACC_PB_ALLOTMENTS' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_ALERT_FORMS]( [ID] [int] NOT NULL, [POLICY_ID] [int] NOT NULL, [CATEGORY_ID] [int] NULL, [FORM_ID] [int] NULL, [FORM_CODE] [varchar](20) NULL, [FORM_NAME] [varchar](50) NOT NULL, [FORM_File_NAME] [varchar](210) NOT NULL, [FORM_PATH] [varchar](1000) NULL, [CREATED_BY] [int] NOT NULL, [DATE_CREATED] [datetime] NOT NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NOT NULL, CONSTRAINT [PK_TBL_DTL_ALERT_FORMS] PRIMARY KEY CLUSTERED ( [ID] ASC )) There is already an object named 'TBL_DTL_ALERT_FORMS' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CADET_ASSIGNED_TRAINEE]( [ID] [int] NOT NULL, [TRAINING_ID] [int] NOT NULL, [CREW_ID] [int] NULL, [IS_ASSINED] [int] NULL, [CREATED_BY] [varchar](100) NOT NULL, [DATE_CREATED] [datetime] NOT NULL, [MODIFIED_BY] [varchar](100) NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [varchar](100) NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NOT NULL, [VESSEL_ID] [int] NULL, CONSTRAINT [PK_TBL_DTL_CADET_ASSIGNED_TRAINEE] PRIMARY KEY CLUSTERED ( [ID] ASC )) There is already an object named 'TBL_DTL_CADET_ASSIGNED_TRAINEE' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CADET_LOG_ATTACHMENTS]( [ID] [int] NOT NULL, [ANSWER_DETAIL_ID] [int] NOT NULL, [ATTACHMENT_NAME] [varchar](max) NOT NULL, [FILE_NAME] [varchar](max) NOT NULL, [CREATED_BY] [int] NOT NULL, [DATE_CREATED] [datetime] NOT NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NOT NULL, [ANS_UID] [nvarchar](50) NULL, [IsSUPERVISOR_Att] [int] NULL ) There is already an object named 'TBL_DTL_CADET_LOG_ATTACHMENTS' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CADET_TRAINING]( [ID] [int] NOT NULL, [TRAINING_NAME] [varchar](250) NULL, [VESSEL_ID] [int] NULL, [TRAINING_START_DATE] [datetime] NULL, [TRAINING_END_DATE] [datetime] NULL, [IMEI_NO] [varchar](255) NULL, [TRAINING_STATUS] [int] NULL, [CREATED_BY] [varchar](100) NOT NULL, [DATE_CREATED] [datetime] NOT NULL, [MODIFIED_BY] [varchar](100) NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [varchar](100) NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NOT NULL, [LOG_TYPE] [int] NULL, CONSTRAINT [PK_TBL_DTL_CADET_TRAINING] PRIMARY KEY CLUSTERED ( [ID] ASC )) There is already an object named 'TBL_DTL_CADET_TRAINING' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CALENDAR_FEATURES]( [ID] [int] NULL, [FEATURE_ID] [int] NULL, [USER_ID] [int] NULL, [CREATED_BY] [int] NULL, [DATE_CREATED] [datetime] NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NULL ) There is already an object named 'TBL_DTL_CALENDAR_FEATURES' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CALENDAR_VESSELS]( [ID] [int] NULL, [VESSEL_ID] [int] NULL, [USER_ID] [int] NULL, [CREATED_BY] [int] NULL, [DATE_CREATED] [datetime] NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NULL ) There is already an object named 'TBL_DTL_CALENDAR_VESSELS' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CREW_EVALUATION_ATTACHMENT]( [ID] [int] NOT NULL CONSTRAINT [DF_TBL_DTL_CREW_EVALUATION_ATTACHMENT_ID] DEFAULT ((0)), [EVALUATION_DTL_ID] [int] NULL, [CREW_ID] [int] NULL, [QUESTION_ID] [int] NULL, [ATTACHEMENT_NAME] [varchar](max) NULL, [ATTACHMENT_FILE] [varchar](max) NULL, [CREATED_BY] [int] NULL, [DATE_CREATED] [datetime] NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [nchar](10) NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NULL, [ID_Vessel] [int] NOT NULL CONSTRAINT [DF__TBL_DTL_C__ID_Ve__407CE5A4] DEFAULT ((0)), [Evaluation_DTL_ID_Vessel] [int] NOT NULL CONSTRAINT [DF__TBL_DTL_C__Evalu__417109DD] DEFAULT ((0)), CONSTRAINT [PK_TBL_DTL_CREW_EVALUATION_ATTACHMENT] PRIMARY KEY CLUSTERED ( [ID] ASC, [ID_Vessel] ASC )) There is already an object named 'TBL_DTL_CREW_EVALUATION_ATTACHMENT' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CRW_ATTACHMENT]( [ID] [int] NOT NULL, [MAIL_ID] [int] NOT NULL, [ATTACHMENT] [varchar](255) NULL, [ATTACHMENT_PATH] [varchar](2000) NULL, [LINK] [int] NULL, [CREATED_BY] [int] NULL, [DATE_CREATED] [datetime] NULL CONSTRAINT [DF_TBL_DTL_CRW_ATTACHMENT_Date_Created] DEFAULT (getdate()), [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NOT NULL CONSTRAINT [DF_TBL_DTL_CRW_ATTACHMENT_Active_Status] DEFAULT ((1)), CONSTRAINT [PK_TBL_DTL_CRW_ATTACHMENT] PRIMARY KEY CLUSTERED ( [ID] ASC )) There is already an object named 'TBL_DTL_CRW_ATTACHMENT' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CRW_BANK_ACCT_DETAILS]( [ID] [int] NOT NULL, [CREW_ID] [int] NOT NULL, [BANK_NAME] [varchar](250) NULL, [BANK_ADDRESS] [varchar](1000) NULL, [BANK_CODE] [varchar](250) NULL, [BRANCH_CODE] [varchar](250) NULL, [BANK_SWIFT_CODE] [varchar](250) NULL, [BANK_IBAN_CODE] [varchar](20) NULL, [BENEFICIARY_NAME] [varchar](100) NULL, [ACCOUNT_NUM] [varchar](50) NOT NULL, [ACCOUNT_CURRENCY_ID] [int] NULL, [IS_DEFAULT] [int] NOT NULL, [IS_VERIFIED] [int] NULL, [VERIFIED_BY] [int] NULL, [CREATED_BY] [int] NOT NULL, [DATE_CREATED] [datetime] NOT NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NOT NULL, [IFSC_CODE] [varchar](100) NULL, [ADDITIONAL_INFO] [varchar](max) NULL, [OFC_ID] [int] NOT NULL CONSTRAINT [TBL_DTL_CRW_BANK_ACCT_DETAILS_OFC_ID] DEFAULT ((0)), [U_ID] [nvarchar](45) NOT NULL CONSTRAINT [DF__TBL_DTL_CR__U_ID__0BFEFBC4] DEFAULT ((0)), [File_Name] [varchar](250) NULL, [Attachment_Unique_Name] [varchar](250) NULL, CONSTRAINT [PK_TBL_DTL_CRW_BANK_ACCT_DETAILS] PRIMARY KEY CLUSTERED ( [U_ID] ASC )) There is already an object named 'TBL_DTL_CRW_BANK_ACCT_DETAILS' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CRW_EDUCATION_DETAILS]( [ID] [int] NOT NULL, [Crew_ID] [int] NOT NULL, [Institute_name] [varchar](400) NULL, [Course_Name] [varchar](400) NULL, [Marks_Percent] [varchar](50) NULL, [Year_Completed] [varchar](4) NULL, [Grade] [varchar](50) NULL, [Attachment_Name] [varchar](max) NULL, [Attachment_File_Name] [varchar](max) NULL, [Attachment_File_Size] [decimal](18, 2) NULL, [CREATED_BY] [int] NULL, [DATE_CREATED] [datetime] NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NULL, [Country_ID] [int] NULL, [City_Name] [varchar](255) NULL, [From_Date] [datetime] NULL, [To_Date] [datetime] NULL, CONSTRAINT [PK_TBL_DTL_CRW_EDUCATION_DETAILS] PRIMARY KEY CLUSTERED ( [ID] ASC )) There is already an object named 'TBL_DTL_CRW_EDUCATION_DETAILS' in the database.SQL_UPDATE Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CRW_INTERVIEW_DETAILS]( [ID] [int] NOT NULL, [Crew_ID] [int] NOT NULL, [Interview_ID] [int] NOT NULL, [Question_ID] [int] NULL, [Grade_ID] [int] NULL, [Answer_Grade] [int] NULL, [Interviewer_Comments] [varchar](4000) NULL, [NA_Flag] [int] NULL CONSTRAINT [DF_TBL_DTL_CRW_INTERVIEW_DETAILS_NotApplocable] DEFAULT ((0)), [CREATED_BY] [int] NULL, [DATE_CREATED] [datetime] NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NULL CONSTRAINT [DF_TBL_DTL_CRW_INTERVIEW_DETAILS_Active_Status] DEFAULT ((1)), [Subjective_Answer] [varchar](4000) NULL, CONSTRAINT [PK_TBL_DTL_CRW_INTERVIEW_DETAILS] PRIMARY KEY CLUSTERED ( [ID] ASC )) There is already an object named 'TBL_DTL_CRW_INTERVIEW_DETAILS' in the database.SQL_UPDATE Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7094 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7094,[SUPPLIER_NAME]='ETS SEALAND SUPPORT',[SUPPLIER_TYPE]=102,[SUPPLIER_ADDRESS1]='AKWA 55, DOUALA, LITORAL, 7472',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=2646,[SUPPLIER_ZIP]='7472',[SUPPLIER_COUNTRY]=38,[CURRENCY_USED]=148,[REGISTRATION_NUM]='RC/DLA/2015/A/278',[DATE_REGISTERED]='2015-01-21 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=105977,[DATE_CREATED]='2021-10-19 16:43 ',[MODIFIED_BY]=109279,[DATE_MODIFIED]='2021-10-19 18:12 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113433,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=2,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7094 Reading file content TBL_LIB_PURC_SUPPLIER_MAIN found in packet Getting tables data type TBL_LIB_PURC_SUPPLIER_MAIN Packet Where Condition where 1=1 and SUPPLIER_ID=7094 Record already exist in TBL_LIB_PURC_SUPPLIER_MAIN update TBL_LIB_PURC_SUPPLIER_MAIN set [SUPPLIER_ID]=7094,[SUPPLIER_NAME]='ETS SEALAND SUPPORT',[SUPPLIER_TYPE]=102,[SUPPLIER_ADDRESS1]='AKWA 55, DOUALA, LITORAL, 7472',[SUPPLIER_ADDRESS2]=null,[SUPPLIER_CITY]=2646,[SUPPLIER_ZIP]='7472',[SUPPLIER_COUNTRY]=38,[CURRENCY_USED]=148,[REGISTRATION_NUM]='RC/DLA/2015/A/278',[DATE_REGISTERED]='2015-01-21 00:00 ',[EVAL_FREQUENCY]=12,[CREDIT_TERMS]=30,[GST_VAT_REGISTRATION_NUM]=null,[PASSWORD_USED]='Wj7VoVOy/+7ytLNAvim/Yw==',[CREATED_BY]=105977,[DATE_CREATED]='2021-10-19 16:43 ',[MODIFIED_BY]=109279,[DATE_MODIFIED]='2021-10-19 18:12 ',[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1,[USER_ID]=113433,[ISO_Accreditations]=null,[PREFERRED_RFQ_FORMAT]=2,[SUPPLIER_CODE]=null,[Website]=null where 1=1 and SUPPLIER_ID=7094 Reading file content TBL_DTL_PURC_SUPPLIER_STATUS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_STATUS Packet Where Condition where 1=1 and ID=2968 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_STATUS insert into TBL_DTL_PURC_SUPPLIER_STATUS([ID],[SUPPLIER_ID],[PROPOSED_STATUS],[PROPOSED_BY],[PROPOSED_ACTION_DAYS],[DATE_PROPOSED],[PROPOSER_REMARKS],[APPROVED_STATUS],[APPROVED_BY],[APPROVED_ACTION_DAYS],[DATE_APPROVED],[APPROVER_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[PIC]) values(2968,7094,204,105977,160,'2021-10-19 17:26','PLS APPROVE TO PROCESS ORDER',114,109279,160,'2021-10-19 18:12','ok',105977,'2021-10-19 17:26',null,null,null,null,1,109279) Reading file content TBL_DTL_PURC_SUPPLIER_CONTACTS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_CONTACTS Packet Where Condition where 1=1 and ID=6857 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_CONTACTS insert into TBL_DTL_PURC_SUPPLIER_CONTACTS([ID],[SUPPLIER_ID],[CONTACT_DEPARTMENT],[CONTACT_NAME],[CONTACT_ADDRESS1],[CONTACT_ADDRESS2],[CONTACT_CITY],[CONTACT_ZIP],[CONTACT_COUNTRY],[CONTACT_MOBILE],[CONTACT_PHONE1],[CONTACT_EMAIL_INDIVIDUAL],[CONTACT_EMAIL_DEPT],[CONTACT_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS],[RFQ_EMAIL],[INVOICE_EMAIL]) values(6857,7094,'SALES & PURCHASING','CORRENTIN EBENGKE','AKWA 55, DOUALA, LITORAL, 7472',null,2646,'7472',38,'+237-676371655','+237-677196003','management@sealandsupport.com','management@sealandsupport.com',null,105977,'2021-10-19 16:45',null,null,null,null,1,'management@sealandsupport.com','management@sealandsupport.com') Reading file content TBL_DTL_PURC_SUPPLIER_BANK_DETAILS found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_BANK_DETAILS Packet Where Condition where 1=1 and ID=1403 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_BANK_DETAILS insert into TBL_DTL_PURC_SUPPLIER_BANK_DETAILS([ID],[SUPPLIER_ID],[BANK_NAME],[BANK_FULL_ADDRESS],[BENEFICIARY_NAME],[BENEFICIARY_ACCOUNT],[ACCOUNT_CURRENCY],[BANK_CODE],[BRANCH_CODE],[SWIFT_CODE],[IBAN_CODE],[IFSC_CODE],[INTERMEDIARY_BANK_DETAILS],[PAYMENT_NOTIFICATION_CONTACT],[SUPPLIER_LETTER_NAME],[SUPPLIER_LETTER_FILENAME],[CREATED_BY],[DATE_CREATED],[VERIFIED_BY],[DATE_VERIFIED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS]) values(1403,7094,'UNITED BANK FOR AFRICA CAMEROON PLC','IMMEUBLE NOUTCHINGUIN AVENUE DE LA LIBERTE, 1245 DOUALA, CAMEROON.','ETS SEALAND SUPPORT','08016000352',148,null,null,'UNAFCMCX','CM2110033052080801600035243',null,null,'237-677196003','BANK ACCOUNT ATTESTATION.pdf','f5f4b824-3a36-4be6-921f-e8d6dae12349.pdf',105977,'2021-10-19 16:51',105977,'2021-10-19 16:51',105977,'2021-10-19 16:51',null,null,1) Reading file content TBL_DTL_PURC_SUPPLIER_EVAL_MAIN found in packet Getting tables data type TBL_DTL_PURC_SUPPLIER_EVAL_MAIN Packet Where Condition where 1=1 and EVALUATION_ID=2856 Record Inserting INTO TBL_DTL_PURC_SUPPLIER_EVAL_MAIN insert into TBL_DTL_PURC_SUPPLIER_EVAL_MAIN([EVALUATION_ID],[EVAL_DATE],[SUPPLIER_ID],[MARKS_MAX],[MARKS_SCORED],[PERCENTAGE_SCORED],[EVALUATION_REMARKS],[CREATED_BY],[DATE_CREATED],[MODIFIED_BY],[DATE_MODIFIED],[DELETED_BY],[DATE_DELETED],[ACTIVE_STATUS]) values(2856,'2021-10-19 00:00',7094,600,0,0,'NONE',105977,'2021-10-19 16:53',null,null,null,null,1) Reading file content found in packet