Site: discus.solutions

https://discus.solutions/

Discus Business Solutions a ISO 9001 : 2015 certified company is dedicated to providing best in class IT Consulting & Software Solutions to Enterprise

year 2002/2023

Direct Download
qmsdb.sql - 2 GB
inquiryqlt_23062023.sql - 1.3 GB
inquiry_fb.sql - 825 MB


[code]
115238  Admin  {}      {"id": 35216, "ip": "180.211.112.10", "cos": "Win32", "name": "Admin admin[10001]", "siteId": 1, "userId": 4, "cdevice": "desktop", "cbrowser": "Chrome 60.0.3112.90", "loginTime": "11 Aug 2017"}  Logout  User "Admin admin[10001]" Logged out from the system.  4      Admin admin[10001]      4      1  1502445351840
115239  Admin  {}      {"id": 35217, "ip": "202.131.100.202", "cos": "Linux x86_64", "name": "Admin admin[10001]", "siteId": 1, "userId": 4, "cdevice": "desktop", "cbrowser": "Chrome 57.0.2987.133", "loginTime": "11 Aug 2017"}  Logout  User "Admin admin[10001]" Logged out from the system.  4      Admin admin[10001]      4  11502445366425
115240  Admin  {}      {"id": 35218, "ip": "202.131.100.202", "cos": "Linux x86_64", "name": "Admin admin[10001]", "siteId": 1, "userId": 4, "cdevice": "desktop", "cbrowser": "Chrome 58.0.3029.81", "userType": 1, "username": "10001", "loginTime": "11 Aug 2017", "clientCode": "aia-applications"}    Login  User "10001" Logged in the system.  4      10001  4      1      1502445378706
144932  Logistics      {}      {"id": 1858, "name": "PORTSMOUTH, VA"}  add_location    Logistics Location named "PORTSMOUTH, VA" created      1858    \N      4  11520487209184
115241  Admin  {}      {"id": 35219, "ip": "202.131.100.202", "cos": "Linux x86_64", "name": "Admin admin[10001]", "siteId": 1, "userId": 4, "cdevice": "desktop", "cbrowser": "Chrome 57.0.2987.133", "userType": 1, "username": "10001", "loginTime": "11 Aug 2017", "clientCode": "aia-applications"}    Login  User "10001" Logged in the system.  4      10001  4      1      1502445380165
115242  Admin  {}      {"id": 35220, "ip": "202.131.100.202", "cos": "Linux x86_64", "name": "Admin admin[10001]", "siteId": 1, "userId": 4, "cdevice": "desktop", "cbrowser": "Chrome 58.0.3029.81", "userType": 1, "username": "10001", "loginTime": "11 Aug 2017", "clientCode": "aia-applications"}    Login  User "10001" Logged in the system.  4      10001  4      1      1502445384065
115243  Logistics      {}      {"id": 3822, "formData": "{\\n \\"custom_invoice_no\\":\\"100020716\\",\\n \\"custom_invoice_date\\":\\"20170721\\",\\n \\"port_of_discharge\\":\\"LOME\\",\\n \\"packing\\":\\"24.00\\",\\n \\"packings_type\\":\\"MS BOX\\",\\n \\"gross_wt\\":\\"24324.10\\",\\n \\"sold_to_part\\":\\"0000111266\\",\\n \\"ship_to_party\\":\\"0000110266\\",\\n \\"plant\\":\\"1017\\",\\n \\"oa_no\\":\\"0200153971\\",\\n \\"billing_document_no\\":\\"\\",\\n \\"city_Country\\":\\"Togo\\",\\n \\"buyer\\":\\"0000111089\\",\\n \\"vega_po_no\\":\\"6200014964\\",\\n \\"vega_ref_no\\":\\"TOG100170501\\",\\n \\"company_code\\":\\"1000\\",\\n \\"sold_to_party_name\\":\\"VEGA INDUSTRIES (MIDDLE EAST) FZC\\",\\n \\"ship_to_party_name\\":\\"CIMENTS DU TOGO S.A.\\",\\n \\"buyer_name\\":\\"SCANCEMINTERNATIONALANS-NORWAY\\"}", "referenceNo": "100020716", "referenceDate": 1500595200000, "formDataWithJsonParse": {"buyer": "0000111089", "oa_no": "0200153971", "plant": "1017", "packing": "24.00", "gross_wt": "24324.10", "buyer_name": "SCANCEMINTERNATIONALANS-NORWAY", "vega_po_no": "6200014964", "vega_ref_no": "TOG100170501", "city_Country": "Togo", "company_code": "1000", "sold_to_part": "0000111266", "packings_type": "MS BOX", "ship_to_party": "0000110266", "custom_invoice_no": "100020716", "port_of_discharge": "LOME", "ship_to_party_name": "CIMENTS DU TOGO S.A.", "sold_to_party_name": "VEGA INDUSTRIES (MIDDLE EAST) FZC", "billing_document_no": "", "custom_invoice_date": "20170721"}}  add_proces      Add process "100020716" Added  3822    \N      4      1      1502445601722
115244  Logistics      {}      {"id": 3823, "formData": "{\\n \\"custom_invoice_no\\":\\"100020717\\",\\n \\"custom_invoice_date\\":\\"20170721\\",\\n \\"port_of_discharge\\":\\"GUAYAQUIL\\",\\n \\"packing\\":\\"12.00\\",\\n \\"packings_type\\":\\"[08 M.S. BOX + 04 W.BOX]\\",\\n \\"gross_wt\\":\\"10863.70\\",\\n \\"sold_to_part\\":\\"0000111266\\",\\n \\"ship_to_party\\":\\"0000111988\\",\\n \\"plant\\":\\"1017\\",\\n \\"oa_no\\":\\"0200152771\\",\\n \\"billing_document_no\\":\\"\\",\\n \\"city_Country\\":\\"Ecuador\\",\\n \\"buyer\\":\\"\\",\\n \\"vega_po_no\\":\\"6200014885\\",\\n \\"vega_ref_no\\":\\"VG-12/2017\\",\\n \\"company_code\\":\\"1000\\",\\n \\"sold_to_party_name\\":\\"VEGA INDUSTRIES (MIDDLE EAST) FZC\\",\\n \\"ship_to_party_name\\":\\"HORMICRETO CIA .LTDA\\",\\n \\"buyer_name\\":\\"\\"}", "referenceNo": "100020717", "referenceDate": 1500595200000, "formDataWithJsonParse": {"buyer": "", "oa_no": "0200152771", "plant": "1017", "packing": "12.00", "gross_wt": "10863.70", "buyer_name": "", "vega_po_no": "6200014885", "vega_ref_no": "VG-12/2017", "city_Country": "Ecuador", "company_code": "1000", "sold_to_part": "0000111266", "packings_type": "[08 M.S. BOX + 04 W.BOX]", "ship_to_party": "0000111988", "custom_invoice_no": "100020717", "port_of_discharge": "GUAYAQUIL", "ship_to_party_name": "HORMICRETO CIA .LTDA", "sold_to_party_name": "VEGA INDUSTRIES (MIDDLE EAST) FZC", "billing_document_no": "", "custom_invoice_date": "20170721"}}      add_proces  Add process "100020717" Added    3823    \N      4      1      1502445601780
118463  Vendor Performance Rating      {}      {"id": 11419, "code": "0000202660", "name": "", "email": ""}    add_vendor      Add Vendor "" Added    11419  \N  -4      1      1515572939256115245  Logistics      {}      {"id": 3824, "formData": "{\\n \\"custom_invoice_no\\":\\"100020718\\",\\n \\"custom_invoice_date\\":\\"20170721\\",\\n \\"port_of_discharge\\":\\"OAKLAND\\",\\n \\"packing\\":\\"30.00\\",\\n \\"packings_type\\":\\"MS PALLET\\",\\n \\"gross_wt\\":\\"35850.00\\",\\n \\"sold_to_part\\":\\"0000111266\\",\\n \\"ship_to_party\\":\\"0000113600\\",\\n \\"plant\\":\\"1017\\",\\n \\"oa_no\\":\\"0200154659\\",\\n \\"billing_document_no\\":\\"\\",\\n \\"city_Country\\":\\"USA\\",\\n \\"buyer\\":\\"0000113518\\",\\n \\"vega_po_no\\":\\"6200015412\\",\\n \\"vega_ref_no\\":\\"3001391054\\",\\n \\"company_code\\":\\"1000\\",\\n \\"sold_to_party_name\\":\\"VEGA INDUSTRIES (MIDDLE EAST) FZC\\",\\n \\"ship_to_party_name\\":\\"J.F. MORAN - WILMINGTON\\",\\n \\"buyer_name\\":\\"NEWMONTMININGCO.-CRIPPLECREEK\\"}", "referenceNo": "100020718", "referenceDate": 1500595200000, "formDataWithJsonParse": {"buyer": "0000113518", "oa_no": "0200154659", "plant": "1017", "packing": "30.00", "gross_wt": "35850.00", "buyer_name": "NEWMONTMININGCO.-CRIPPLECREEK", "vega_po_no": "6200015412", "vega_ref_no": "3001391054", "city_Country": "USA", "company_code": "1000", "sold_to_part": "0000111266", "packings_type": "MS PALLET", "ship_to_party": "0000113600", "custom_invoice_no": "100020718", "port_of_discharge": "OAKLAND", "ship_to_party_name": "J.F. MORAN - WILMINGTON", "sold_to_party_name": "VEGA INDUSTRIES (MIDDLE EAST) FZC", "billing_document_no": "", "custom_invoice_date": "20170721"}} add_proces      Add process "100020718" Added  3824    \N      4      1      1502445601814
115246  Logistics      {}      {"id": 3825, "formData": "{\\n \\"custom_invoice_no\\":\\"100020719\\",\\n \\"custom_invoice_date\\":\\"20170721\\",\\n \\"port_of_discharge\\":\\"DAR ES SALAAM\\",\\n \\"packing\\":\\"50.00\\",\\n \\"packings_type\\":\\"DRUM\\",\\n \\"gross_wt\\":\\"51800.00\\",\\n \\"sold_to_part\\":\\"0000111266\\",\\n \\"ship_to_party\\":\\"0000112897\\",\\n \\"plant\\":\\"1007\\",\\n \\"oa_no\\":\\"0200154484\\",\\n \\"billing_document_no\\":\\"\\",\\n \\"city_Country\\":\\"Tanzania\\",\\n \\"buyer\\":\\"\\",\\n \\"vega_po_no\\":\\"6200014884\\",\\n \\"vega_ref_no\\":\\"9912\\",\\n \\"company_code\\":\\"1000\\",\\n \\"sold_to_party_name\\":\\"VEGA INDUSTRIES (MIDDLE EAST) FZC\\",\\n \\"ship_to_party_name\\":\\"SHANTA MINING COMPANY LIMITED - DAR ES SALAAM\\",\\n \\"buyer_name\\":\\"\\"}", "referenceNo": "100020719", "referenceDate": 1500595200000, "formDataWithJsonParse": {"buyer": "", "oa_no": "0200154484", "plant": "1007", "packing": "50.00", "gross_wt": "51800.00", "buyer_name": "", "vega_po_no": "6200014884", "vega_ref_no": "9912", "city_Country": "Tanzania", "company_code": "1000", "sold_to_part": "0000111266", "packings_type": "DRUM", "ship_to_party": "0000112897", "custom_invoice_no": "100020719", "port_of_discharge": "DAR ES SALAAM", "ship_to_party_name": "SHANTA MINING COMPANY LIMITED - DAR ES SALAAM", "sold_to_party_name": "VEGA INDUSTRIES (MIDDLE EAST) FZC", "billing_document_no": "", "custom_invoice_date": "20170721"}}      add_proces  Add process "100020719" Added  3825    \N      4      1      1502445601843
[code]

Thanks

I'm in awe of the creativity and attention to detail here.