 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003528 post PendingInvicesDO 2 QSM-071003351 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003351 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='52184bdc-ab90-4c42-92d0-99045038b6c5' LIMIT 1 Date : 2024-10-31T10:01:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T10:01:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003529 post PendingInvicesDO 2 QSM-071003352 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003352 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='256b2883-461c-4e7f-bf75-89ec9b74e96f' LIMIT 1 Date : 2024-10-31T10:47:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T10:47:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003530 post PendingInvicesDO 2 QSM-071003350 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003350 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003350' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003350' OR OrderId='QSM-071003350' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-10-31T10:53:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003531 post PendingInvicesDO 2 QSM-071003284 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003284 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003284' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003284' OR OrderId='QSM-071003284' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-10-31T10:53:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003532 post PendingInvicesDO 2 QSM-071003117 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003117' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003117' OR OrderId='QSM-071003117' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-10-31T11:22:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003533 post PendingInvicesDO 2 QSM-071003305 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003305 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003305' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003305' OR OrderId='QSM-071003305' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-10-31T11:36:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003534 post PendingInvicesDO 2 QSM-071003353 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003353 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3a28dcd4-7984-44dc-b9d0-e6df04ca1e3a' LIMIT 1 Date : 2024-10-31T11:56:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T11:56:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003535 post PendingInvicesDO 2 QSM-071003265 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003265' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003265' OR OrderId='QSM-071003265' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-10-31T12:58:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003536 post PendingInvicesDO 2 QSM-071003354 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003354 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='43dbba97-fe78-448e-a5fa-106bd4c129f4' LIMIT 1 Date : 2024-10-31T12:59:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T12:59:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003537 post PendingInvicesDO 2 QSM-071003355 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003355 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5d648208-b2a8-44f5-83e0-7cae5c007a85' LIMIT 1 Date : 2024-11-02T10:06:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T10:06:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003538 post PendingInvicesDO 2 QSM-071003356 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003356 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b1d06df8-25a4-4e20-9217-5ba95f6ac941' LIMIT 1 Date : 2024-11-02T10:28:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T10:28:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003539 post PendingInvicesDO 2 QSM-071003357 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003357 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1ba921f4-4962-409c-bf8a-47021ed7f640' LIMIT 1 Date : 2024-11-02T10:55:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T10:55:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003540 post PendingInvicesDO 2 QSM-071003358 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003358 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2dbf00da-1972-4b6a-81d4-5f5731bcd929' LIMIT 1 Date : 2024-11-02T11:02:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T11:02:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003541 post PendingInvicesDO 2 QSM-071003359 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003359 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9ae87f6b-6921-485c-8a3f-1dd40f235fba' LIMIT 1 Date : 2024-11-02T11:10:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T11:10:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003542 post PendingInvicesDO 2 QSM-071003360 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003360 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9b93e5f7-1b1c-471c-9392-e67975085e52' LIMIT 1 Date : 2024-11-02T11:20:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T11:20:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003543 post PendingInvicesDO 2 QSM-071003361 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003361 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7684c0f0-4f3a-4294-826a-a9ecb88fb370' LIMIT 1 Date : 2024-11-02T11:43:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T11:43:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003544 post PendingInvicesDO 2 QSM-071003362 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003362 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7b2d9692-8c2f-4c17-bb86-64e91be42d69' LIMIT 1 Date : 2024-11-03T09:24:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T09:24:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003545 post PendingInvicesDO 2 QSM-071003363 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003363 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0ab34256-2d23-49d1-9591-827b8e830d67' LIMIT 1 Date : 2024-11-03T09:40:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T09:40:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003546 post PendingInvicesDO 2 QSM-071003364 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003364 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='84c2ec90-b9f1-4afa-a503-aaddab2a5d60' LIMIT 1 Date : 2024-11-03T09:53:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T09:53:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003547 post PendingInvicesDO 2 QSM-071003365 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003365 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9466591a-21e4-48a8-80fe-00ce8b6c0916' LIMIT 1 Date : 2024-11-03T10:10:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T10:10:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003548 post PendingInvicesDO 2 QSM-071003366 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003366 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4bebc2fb-1d48-4a6d-9593-2f2260a0c053' LIMIT 1 Date : 2024-11-03T10:28:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T10:28:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003549 post PendingInvicesDO 2 QSM-071003367 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003367 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='00eb8ed3-2122-497a-86ff-538539072499' LIMIT 1 Date : 2024-11-03T10:46:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T10:46:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003550 post PendingInvicesDO 2 QSM-071003368 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003368 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d572fc31-7efa-4d64-854e-650f833700a6' LIMIT 1 Date : 2024-11-03T11:06:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T11:06:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003551 post PendingInvicesDO 2 QSM-071003369 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003369 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9f82fa58-bbb0-49da-894d-5d9cc8c952f9' LIMIT 1 Date : 2024-11-03T11:17:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T11:17:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003552 post PendingInvicesDO 2 QSM-071003370 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003370 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='21b5a9fc-51c4-42a0-b5c5-bc5f70882eb7' LIMIT 1 Date : 2024-11-03T12:49:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T12:49:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003553 post PendingInvicesDO 2 QSM-071003371 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003371 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ee270e0f-b250-4173-8af7-ba1bab56ea94' LIMIT 1 Date : 2024-11-04T09:43:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T09:43:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003554 post PendingInvicesDO 2 QSM-071003372 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003372 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dd59d508-e3ab-404a-bcc2-3a67b63500d8' LIMIT 1 Date : 2024-11-04T10:05:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T10:05:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003555 post PendingInvicesDO 2 QSM-071003373 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003373' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003373' OR OrderId='QSM-071003373' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-04T10:36:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003556 post PendingInvicesDO 2 QSM-071003374 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003374 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='32c811c0-e7a4-479d-8ccc-3c9b8213085d' LIMIT 1 Date : 2024-11-04T11:04:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T11:04:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003557 post PendingInvicesDO 2 QSM-071003375 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003375 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='65059cb5-e465-4865-94d1-8280558d3f86' LIMIT 1 Date : 2024-11-04T11:25:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T11:25:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003558 post PendingInvicesDO 2 QSM-071003376 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003376 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='83baa5e5-7cd5-4847-91b6-44c38631d97e' LIMIT 1 Date : 2024-11-04T11:44:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T11:44:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003559 post PendingInvicesDO 2 QSM-071003377 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003377 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7f7a4730-1edd-431a-931b-e19e5d692b82' LIMIT 1 Date : 2024-11-04T11:55:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T11:55:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003560 post PendingInvicesDO 2 QSM-071003379 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003379 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f69ad9aa-a03d-4d34-8550-7bacda1f8a32' LIMIT 1 Date : 2024-11-05T09:43:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T09:43:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003561 post PendingInvicesDO 2 QSM-071003380 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003380 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3f1bb313-4c26-4abd-b7d0-62aa593da961' LIMIT 1 Date : 2024-11-05T10:19:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T10:19:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003562 post PendingInvicesDO 2 QSM-071003381 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003381 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6707096c-2163-4849-b0ea-be181b0b7c10' LIMIT 1 Date : 2024-11-05T10:38:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T10:38:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003563 post PendingInvicesDO 2 QSM-071003382 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003382 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ef2d9b2d-6ef6-4178-975b-83a853e8a920' LIMIT 1 Date : 2024-11-05T10:58:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T10:58:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003564 post PendingInvicesDO 2 QSM-071003383 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003383 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='768c9dac-c978-403c-9b0e-5ea49a8da534' LIMIT 1 Date : 2024-11-05T11:24:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T11:24:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003565 post PendingInvicesDO 2 QSM-071003385 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003385 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9cc44e2e-4213-44e6-b1b0-6d6cc52b2cdb' LIMIT 1 Date : 2024-11-05T13:02:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T13:02:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003566 post PendingInvicesDO 2 QSM-071003386 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003386 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eb2645b6-f84a-4ccc-97c1-b8f05187bc2b' LIMIT 1 Date : 2024-11-06T10:01:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-06T10:01:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003567 post PendingInvicesDO 2 QSM-071003387 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003387 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='71d4fbad-8cd6-4989-adae-1d80ac824573' LIMIT 1 Date : 2024-11-06T12:20:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-06T12:20:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003568 post PendingInvicesDO 2 QSM-071003388 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003388 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='39ef9c34-c3a8-49c8-8b88-70f64f4c36e1' LIMIT 1 Date : 2024-11-06T12:30:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-06T12:30:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003569 post PendingInvicesDO 2 QSM-071003389 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003389 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9bb711c1-785b-490a-9f8e-e3413a601a35' LIMIT 1 Date : 2024-11-06T12:51:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-06T12:51:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003570 post PendingInvicesDO 2 QSM-071003391 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003391 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e23e6913-7345-4f55-8cab-d2a94f01871a' LIMIT 1 Date : 2024-11-06T13:26:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-06T13:26:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003571 post PendingInvicesDO 2 QSM-071003390 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003390 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003390' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003390' OR OrderId='QSM-071003390' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-06T15:47:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003572 post PendingInvicesDO 2 QSM-071003392 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003392 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='935e634f-71f1-4979-9995-bb71dbd2fddb' LIMIT 1 Date : 2024-11-07T10:17:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T10:17:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003573 post PendingInvicesDO 2 QSM-071003393 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003393 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5f3f8e1b-aa24-4e59-9ccd-d6c8946cc969' LIMIT 1 Date : 2024-11-07T11:02:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T11:02:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003574 post PendingInvicesDO 2 QSM-071003394 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003394 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d3d6593b-9a03-47a7-8825-cda6378b7273' LIMIT 1 Date : 2024-11-07T11:25:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T11:25:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003575 post PendingInvicesDO 2 QSM-071003378 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003378 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003378' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003378' OR OrderId='QSM-071003378' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-07T15:31:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003576 post PendingInvicesDO 2 QSM-071003395 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003395 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='296871b2-fd69-463c-98d0-a799c2dbbfa3' LIMIT 1 Date : 2024-11-09T10:41:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T10:41:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003577 post PendingInvicesDO 2 QSM-071003396 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003396 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='77b0169f-d0c1-4cde-80fe-fd78dfd5023b' LIMIT 1 Date : 2024-11-09T11:08:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T11:08:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003578 post PendingInvicesDO 2 QSM-071003397 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003397 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='41ecc677-40b1-4cc1-94eb-e2139214c914' LIMIT 1 Date : 2024-11-09T11:30:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T11:30:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003579 post PendingInvicesDO 2 QSM-071003398 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003398 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d36c0664-fac2-4e16-9972-7d7b8fdafc10' LIMIT 1 Date : 2024-11-09T11:44:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T11:44:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003580 post PendingInvicesDO 2 QSM-071003399 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003399 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bbf477c5-77de-4913-9ced-307b3fe9d6cd' LIMIT 1 Date : 2024-11-09T12:33:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T12:33:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003581 post PendingInvicesDO 2 QSM-071003400 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003400 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='338d7103-a2f4-4565-9eb0-a1854befe262' LIMIT 1 Date : 2024-11-09T13:12:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T13:12:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003582 post PendingInvicesDO 2 QSM-071003401 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003401 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8ea37763-6909-4503-a2fa-ee7a28b8b120' LIMIT 1 Date : 2024-11-10T09:51:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T09:51:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003583 post PendingInvicesDO 2 QSM-071003402 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003402 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='efef9028-b9b0-44f2-b8fd-5ac21df67a23' LIMIT 1 Date : 2024-11-10T10:06:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T10:06:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003584 post PendingInvicesDO 2 QSM-071003403 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003403 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='238eff2c-9c58-4207-b9f1-664840c17d74' LIMIT 1 Date : 2024-11-10T10:21:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T10:21:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003585 post PendingInvicesDO 2 QSM-071003404 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003404 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='44fd707e-d48b-42e3-9730-89d94f10fafb' LIMIT 1 Date : 2024-11-10T10:44:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T10:44:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003586 post PendingInvicesDO 2 QSM-071003405 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003405 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4b6e60ed-54f7-42e9-9f03-0f0c7a4061c8' LIMIT 1 Date : 2024-11-10T11:39:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T11:39:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003587 post PendingInvicesDO 2 QSM-071003406 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003406 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8b0d55e0-423d-44c0-b639-d655a753d55e' LIMIT 1 Date : 2024-11-10T12:08:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T12:08:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003588 post PendingInvicesDO 2 QSM-071003407 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003407 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d709c2db-178a-4b23-970c-6687ead898e3' LIMIT 1 Date : 2024-11-10T13:24:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T13:24:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003589 post PendingInvicesDO 2 QSM-071003408 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003408 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='47a79092-842b-43cf-a532-7ada3e324489' LIMIT 1 Date : 2024-11-11T09:48:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T09:48:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003590 post PendingInvicesDO 2 QSM-071003409 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003409 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='84321942-b6c2-4a4e-b5ff-8c4796238464' LIMIT 1 Date : 2024-11-11T10:11:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T10:11:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003591 post PendingInvicesDO 2 QSM-071003410 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003410 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='552f0902-b2a1-46eb-b6ce-492ae7a6aa90' LIMIT 1 Date : 2024-11-11T10:52:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T10:52:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003592 post PendingInvicesDO 2 QSM-071003411 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003411 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='84f78ad2-c1d7-49d5-809b-ad22fb95f9fe' LIMIT 1 Date : 2024-11-11T11:08:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T11:08:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003593 post PendingInvicesDO 2 QSM-071003412 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003412 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0df8f4bc-4870-43a3-8ff0-e8c4d2899774' LIMIT 1 Date : 2024-11-11T11:37:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T11:37:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003594 post PendingInvicesDO 2 QSM-071003413 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003413 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='28d39a50-b371-4bc0-9066-fc8dc3e9459a' LIMIT 1 Date : 2024-11-11T12:28:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T12:28:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003595 post PendingInvicesDO 2 QSM-071003414 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003414 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e5fe41e4-87c1-4192-ae81-57e4fd524a0b' LIMIT 1 Date : 2024-11-11T12:35:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T12:35:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003596 post PendingInvicesDO 2 QSM-071003415 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003415 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ad2fb397-74be-4c09-bbfb-37d95ae5f581' LIMIT 1 Date : 2024-11-12T10:45:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T10:45:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003597 post PendingInvicesDO 2 QSM-071003416 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003416 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1d8820ed-61ef-4077-8b7e-b7045e1a72fe' LIMIT 1 Date : 2024-11-12T11:13:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T11:13:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003598 post PendingInvicesDO 2 QSM-071003417 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003417 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ce492d3a-81d9-4614-b9b8-b658c227ed1f' LIMIT 1 Date : 2024-11-12T11:31:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T11:31:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003599 post PendingInvicesDO 2 QSM-071003418 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003418 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='10da7fa3-e7b5-471d-93c3-6711e1d488ed' LIMIT 1 Date : 2024-11-12T12:28:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T12:28:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003600 post PendingInvicesDO 2 QSM-071003384 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003384 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003384' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003384' OR OrderId='QSM-071003384' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-12T12:29:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003601 post PendingInvicesDO 2 QSM-071003419 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003419 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='39fd683b-3f35-4f94-9e85-5d8d7586d82e' LIMIT 1 Date : 2024-11-12T13:01:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T13:01:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003602 post PendingInvicesDO 2 QSM-071003421 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003421 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b5c09167-c5c9-413c-a9f8-eb956c48f095' LIMIT 1 Date : 2024-11-13T10:59:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T10:59:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003603 post PendingInvicesDO 2 QSM-071003422 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003422 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5b45cc4f-1c92-4bf1-b30f-e254c43ae9c1' LIMIT 1 Date : 2024-11-13T11:15:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T11:15:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003604 post PendingInvicesDO 2 QSM-071003423 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003423 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='66d00a03-6de7-4956-80d3-18c87a71158a' LIMIT 1 Date : 2024-11-13T11:21:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T11:21:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003605 post PendingInvicesDO 2 QSM-071003424 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003424 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d2a7f7e-b890-4675-af31-1c1c22ff6a08' LIMIT 1 Date : 2024-11-13T11:37:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T11:37:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003606 post PendingInvicesDO 2 QSM-071003425 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003425 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9bbe6c06-00c8-42e4-95bb-53d34bc1e17d' LIMIT 1 Date : 2024-11-13T12:33:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T12:33:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003607 post PendingInvicesDO 2 QSM-071003420 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003420 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003420' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003420' OR OrderId='QSM-071003420' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-14T15:07:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003608 post PendingInvicesDO 2 QSM-071003373 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003373' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003373' OR OrderId='QSM-071003373' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-18T16:48:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003609 post PendingInvicesDO 2 QSM-071003426 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003426 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='897300d2-f2c3-46f6-8423-48171a6d3f04' LIMIT 1 Date : 2025-03-05T10:35:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T10:35:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003610 post PendingInvicesDO 2 QSM-071003427 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003427 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='897300d2-f2c3-46f6-8423-48171a6d3f04' LIMIT 1 Date : 2025-03-05T10:43:04 QSM-071003426  performInsertPayment totalCNVal 0.0 duplicate happened  performInsertPayment duplicate 2025-03-05T10:43:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003610 post PendingInvicesDO 2 QSM-071003427 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003427 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a63d346c-92d0-47c7-a75d-b7a83c7abfd0' LIMIT 1 Date : 2025-03-05T11:11:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T11:11:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003611 post PendingInvicesDO 2 QSM-071003428 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003428 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='263f05ab-00f8-4474-8050-39cd2db5dcdd' LIMIT 1 Date : 2025-03-05T12:48:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T12:48:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003612 post PendingInvicesDO 2 QSM-071003429 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003429 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0e7f8ae4-325a-4598-839e-c28aefa04479' LIMIT 1 Date : 2025-03-06T12:25:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T12:25:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003613 post PendingInvicesDO 2 QSM-071003430 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003430 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='573e46bc-19b9-482a-8d9b-4923ab40843d' LIMIT 1 Date : 2025-03-06T12:43:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T12:43:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003614 post PendingInvicesDO 2 QSM-071003432 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003432 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4784d51d-5a36-44bf-b2c2-24c93fc21a64' LIMIT 1 Date : 2025-03-06T14:09:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T14:09:17 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 QSM-074003615 post PendingInvicesDO 2 QSM-071003433 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003433 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='595ea4f7-ec03-4afc-a6ff-ad4a35268a31' LIMIT 1 Date : 2025-03-06T15:15:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T15:15:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003616 post PendingInvicesDO 2 QSM-071003434 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003434 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='abd49d83-752b-4e80-8482-8f84e92b1bfc' LIMIT 1 Date : 2025-03-06T15:26:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T15:26:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003617 post PendingInvicesDO 2 QSM-071003435 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003435 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0c798ee9-9e15-4f04-9c52-0f1086b67032' LIMIT 1 Date : 2025-03-06T17:22:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T17:22:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003618 post PendingInvicesDO 2 QSM-071003436 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003436 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='52eb0f6a-b347-43a7-9f19-a1842228cb88' LIMIT 1 Date : 2025-03-08T10:15:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T10:15:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003619 post PendingInvicesDO 2 QSM-071003437 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003437' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003437' OR OrderId='QSM-071003437' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-08T10:52:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003620 post PendingInvicesDO 2 QSM-071003438 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003438' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003438' OR OrderId='QSM-071003438' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-08T11:23:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003621 post PendingInvicesDO 2 QSM-071003439 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003439 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a716d691-168b-4980-b391-73baab8b8d05' LIMIT 1 Date : 2025-03-08T11:28:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T11:28:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003622 post PendingInvicesDO 2 QSM-071003440 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003440 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6f437060-d4ff-41e0-a4f7-80a59ed6c9a1' LIMIT 1 Date : 2025-03-08T12:11:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T12:11:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003623 post PendingInvicesDO 2 QSM-071003441 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003441 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d5a1dc63-750d-450d-b594-c8f26019c66c' LIMIT 1 Date : 2025-03-08T12:12:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T12:12:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003624 post PendingInvicesDO 2 QSM-071003442 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003442 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-071003442' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-071003442' OR OrderId='QSM-071003442' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-08T13:14:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003625 post PendingInvicesDO 2 QSM-071003443 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003443 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2b8e2d00-4ded-426f-8d82-bd758ff9a4ea' LIMIT 1 Date : 2025-03-08T13:26:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T13:26:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003626 post PendingInvicesDO 2 QSM-071003444 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003444 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='76e12321-8d73-4c3a-ab31-d9d32e959464' LIMIT 1 Date : 2025-03-08T13:44:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T13:44:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003627 post PendingInvicesDO 2 QSM-071003445 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003445 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='02a970e9-ea37-4069-a2f2-4fbf824e0d01' LIMIT 1 Date : 2025-03-08T14:18:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T14:18:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003628 post PendingInvicesDO 2 QSM-071003446 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003446 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='82f794eb-3c9c-4e3d-affa-fd9795af849e' LIMIT 1 Date : 2025-03-08T14:45:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T14:45:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003629 post PendingInvicesDO 2 QSM-071003447 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003447 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='68eb7ab8-5052-48d9-bba3-c511eef83916' LIMIT 1 Date : 2025-03-08T15:22:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T15:22:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-074003630 post PendingInvicesDO 2 QSM-071003448 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-071003448 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c13a5751-4b14-475f-b8f7-5b9e18bb75d2' LIMIT 1 Date : 2025-03-08T15:34:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T15:34:29 payment end 
