 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001759 post PendingInvicesDO 2 BSH-061001768 post PendingInvicesDO 2 BSH-061001767 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001758 post PendingInvicesDO 2 BSH-061001768 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001767 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001768 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f854f846-bf61-4a57-a31f-b57dfd5a0a97' LIMIT 1 Date : 2025-10-13T18:39:35  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2ff423c5-e62e-4409-aaab-86f78c7882b7' LIMIT 1 Date : 2025-10-13T18:39:35  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f854f846-bf61-4a57-a31f-b57dfd5a0a97' LIMIT 1 Date : 2025-10-13T18:39:35  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2ff423c5-e62e-4409-aaab-86f78c7882b7' LIMIT 1 Date : 2025-10-13T18:39:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-13T18:39:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001761 post PendingInvicesDO 2 BSH-061001770 post PendingInvicesDO 2 BSH-061001769 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001760 post PendingInvicesDO 2 BSH-061001770 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001769 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001770 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d6f7c9e-a0f1-40ae-97ee-9bae244e0f1d' LIMIT 1 Date : 2025-10-14T11:15:49  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9309ef51-4ed6-4eaa-bbe5-afbaf885b51a' LIMIT 1 Date : 2025-10-14T11:15:49  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d6f7c9e-a0f1-40ae-97ee-9bae244e0f1d' LIMIT 1 Date : 2025-10-14T11:15:49  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9309ef51-4ed6-4eaa-bbe5-afbaf885b51a' LIMIT 1 Date : 2025-10-14T11:15:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-14T11:15:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001762 post PendingInvicesDO 2 BSH-061001771 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001771 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='12ab115a-e142-4e60-b19e-73fce926a1f8' LIMIT 1 Date : 2025-10-14T11:57:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T11:57:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001763 post PendingInvicesDO 2 BSH-061001772 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001772 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='aa74ba0a-85fd-4977-b254-124b906d83da' LIMIT 1 Date : 2025-10-14T12:26:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T12:26:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001764 post PendingInvicesDO 2 BSH-061001773 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001773 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ace89b23-67d1-4abe-a5b8-52b89cf5cb14' LIMIT 1 Date : 2025-10-14T12:40:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T12:40:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001765 post PendingInvicesDO 2 BSH-061001774 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001774 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6bf7f2f0-d16d-4e8a-9869-3f14ecae3be9' LIMIT 1 Date : 2025-10-14T13:07:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T13:07:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001766 post PendingInvicesDO 2 BSH-061001775 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001775 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8f449f6d-4149-4e71-8f22-1945c70d1a68' LIMIT 1 Date : 2025-10-14T13:33:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T13:33:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001767 post PendingInvicesDO 2 BSH-061001776 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001776 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8d10d3d5-2acb-4d9f-9188-bdb8caee93e3' LIMIT 1 Date : 2025-10-14T13:53:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T13:53:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001768 post PendingInvicesDO 2 BSH-061001777 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001777 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='73b57e22-4209-49a8-a5c9-7b7f135fe487' LIMIT 1 Date : 2025-10-14T14:17:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T14:17:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001769 post PendingInvicesDO 2 BSH-061001778 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001778 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eec1265f-a29e-4f0a-a2e8-c5076fa9c09c' LIMIT 1 Date : 2025-10-14T14:52:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T14:52:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001771 post PendingInvicesDO 2 BSH-061001783 post PendingInvicesDO 2 BSH-061001782 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001770 post PendingInvicesDO 2 BSH-061001783 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001782 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001783 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='07383dd6-ee75-44a7-8f73-7b807574e026' LIMIT 1 Date : 2025-10-14T20:51:52  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='31e974cd-1525-471f-b6b9-40e7838f0de9' LIMIT 1 Date : 2025-10-14T20:51:52  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='07383dd6-ee75-44a7-8f73-7b807574e026' LIMIT 1 Date : 2025-10-14T20:51:52  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='31e974cd-1525-471f-b6b9-40e7838f0de9' LIMIT 1 Date : 2025-10-14T20:51:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-14T20:51:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001772 post PendingInvicesDO 2 BSH-061001642 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001642 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 = 'BSH-061001642' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001642' OR OrderId='BSH-061001642' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T09:15:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001773 post PendingInvicesDO 2 BSH-061001647 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001647 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 = 'BSH-061001647' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001647' OR OrderId='BSH-061001647' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T09:15:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001774 post PendingInvicesDO 2 BSH-061001784 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001784 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='00b30d9a-c734-42e5-9cb2-332861d57a4f' LIMIT 1 Date : 2025-10-15T13:20:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T13:20:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001775 post PendingInvicesDO 2 BSH-061001785 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001785 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e79ca506-a41c-482b-9a87-376c5062bdf3' LIMIT 1 Date : 2025-10-15T13:41:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T13:41:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001776 post PendingInvicesDO 2 BSH-061001788 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001788 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8cac5b21-18bf-4da6-8a8e-e88af20d4bcd' LIMIT 1 Date : 2025-10-15T15:43:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T15:43:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001777 post PendingInvicesDO 2 BSH-061001789 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001789 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3fdcd7a7-eeeb-421b-8b41-f408fae25f57' LIMIT 1 Date : 2025-10-15T16:16:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T16:16:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001778 post PendingInvicesDO 2 BSH-061001790 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001790 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b9eb6294-ce96-4ec7-b506-b6d5797a65ac' LIMIT 1 Date : 2025-10-15T16:35:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T16:35:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001779 post PendingInvicesDO 2 BSH-061001791 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001791 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b16121c6-5d45-474c-b762-a6fd03ba410e' LIMIT 1 Date : 2025-10-15T17:09:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T17:09:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001780 post PendingInvicesDO 2 BSH-061001792 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001792 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ffb24c79-8053-464d-b523-5482ba0867c2' LIMIT 1 Date : 2025-10-15T18:34:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T18:34:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001781 post PendingInvicesDO 2 BSH-061001793 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001793 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cb05e0a2-37bd-4791-b650-8cd986cf6044' LIMIT 1 Date : 2025-10-15T19:03:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T19:03:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001782 post PendingInvicesDO 2 BSH-061001794 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001794 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c6326d99-441a-4f85-9573-8ef134a4c6f0' LIMIT 1 Date : 2025-10-15T20:04:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T20:04:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001783 post PendingInvicesDO 2 BSH-061001795 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001795 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d855a723-b46d-4dcd-944f-d8c41215ca7f' LIMIT 1 Date : 2025-10-15T20:30:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T20:30:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001784 post PendingInvicesDO 2 BSH-061001780 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001780 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 = 'BSH-061001780' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001780' OR OrderId='BSH-061001780' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T20:52:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001785 post PendingInvicesDO 2 BSH-061001796 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001796 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bd4407f9-4704-4047-a2dd-b99765898d13' LIMIT 1 Date : 2025-10-15T20:54:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T20:54:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001786 post PendingInvicesDO 2 BSH-061001667 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001667 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 = 'BSH-061001667' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001667' OR OrderId='BSH-061001667' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T23:58:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001787 post PendingInvicesDO 2 BSH-061001687 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001687 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 = 'BSH-061001687' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001687' OR OrderId='BSH-061001687' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T10:08:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001788 post PendingInvicesDO 2 BSH-061001713 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001713 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 = 'BSH-061001713' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001713' OR OrderId='BSH-061001713' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T11:46:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001789 post PendingInvicesDO 2 BSH-061001801 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001801 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b1ceb46e-a95f-47bd-84ef-ba09da9b9f08' LIMIT 1 Date : 2025-10-16T13:02:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T13:02:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001790 post PendingInvicesDO 2 BSH-061001718 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001718 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 = 'BSH-061001718' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001718' OR OrderId='BSH-061001718' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T13:37:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001791 post PendingInvicesDO 2 BSH-061001803 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001803 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='75224583-57a1-43a6-b2c1-3b37a75dcb50' LIMIT 1 Date : 2025-10-16T16:03:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:03:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001792 post PendingInvicesDO 2 BSH-061001804 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001804 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='107e5a8b-281e-4d8e-a8be-382b70154f03' LIMIT 1 Date : 2025-10-16T16:13:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:13:23 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 BSH-064001793 post PendingInvicesDO 2 BSH-061001805 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001805 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5c5b801d-24a4-4628-9f51-63a1c1830ac7' LIMIT 1 Date : 2025-10-16T16:35:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:35:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001794 post PendingInvicesDO 2 BSH-061001806 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001806 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0502d307-cce8-4928-b89d-0612e7af66b9' LIMIT 1 Date : 2025-10-16T16:58:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:58:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001795 post PendingInvicesDO 2 BSH-061001740 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001740 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 = 'BSH-061001740' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001740' OR OrderId='BSH-061001740' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T17:24:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001796 post PendingInvicesDO 2 BSH-061001808 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001808 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f958d27d-64a4-4d75-8713-5a8b5e7739b0' LIMIT 1 Date : 2025-10-16T18:11:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T18:11:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001797 post PendingInvicesDO 2 BSH-061001809 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001809 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6cc8401c-a961-4282-a726-d25b0f99e962' LIMIT 1 Date : 2025-10-16T19:04:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T19:04:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001798 post PendingInvicesDO 2 BSH-061001810 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001810 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8e60296c-d5a0-4a39-9fc5-85def17cc0cf' LIMIT 1 Date : 2025-10-16T19:58:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T19:58:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001799 post PendingInvicesDO 2 BSH-061001811 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001811 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d10e282f-be3d-43c6-b2a3-97a3044265c2' LIMIT 1 Date : 2025-10-16T20:54:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T20:54:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001800 post PendingInvicesDO 2 BSH-061001812 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001812 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d18676bd-f973-4d55-a5f0-7dd873279486' LIMIT 1 Date : 2025-10-18T10:02:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T10:02:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001801 post PendingInvicesDO 2 BSH-061001813 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001813 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c752cbec-5438-47f5-8d0b-ddaccb4d9418' LIMIT 1 Date : 2025-10-18T10:35:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T10:35:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001802 post PendingInvicesDO 2 BSH-061001814 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001814 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='45c6f683-de65-4b3a-a7b9-3e3e57ad9be4' LIMIT 1 Date : 2025-10-18T10:51:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T10:51:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001803 post PendingInvicesDO 2 BSH-061001815 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001815 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e440c7bf-8ccb-4085-8c3f-ed27c440e15c' LIMIT 1 Date : 2025-10-18T11:05:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T11:05:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001804 post PendingInvicesDO 2 BSH-061001816 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001816 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8aec90a4-a42f-465e-b885-57cbf183c8b6' LIMIT 1 Date : 2025-10-18T11:27:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T11:27:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001805 post PendingInvicesDO 2 BSH-061001817 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001817 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4eeacecc-2878-4e73-b873-4ed3e1d79db8' LIMIT 1 Date : 2025-10-18T11:45:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T11:45:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001806 post PendingInvicesDO 2 BSH-061001818 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001818 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a5634a8d-8d8e-459a-ba33-0c07f6ab80d6' LIMIT 1 Date : 2025-10-18T12:25:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T12:25:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001807 post PendingInvicesDO 2 BSH-061001819 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001819 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='84d9719a-8a9b-4b7b-84be-0465261a5aca' LIMIT 1 Date : 2025-10-18T12:45:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T12:45:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001808 post PendingInvicesDO 2 BSH-061001820 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001820 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='978660db-a59a-4da8-98f1-f5a40aa74843' LIMIT 1 Date : 2025-10-18T13:01:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T13:01:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001809 post PendingInvicesDO 2 BSH-061001695 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001695 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 = 'BSH-061001695' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001695' OR OrderId='BSH-061001695' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-18T13:29:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001810 post PendingInvicesDO 2 BSH-061001823 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001823 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='982d300a-9031-432f-a2a0-9bd6955ea0d9' LIMIT 1 Date : 2025-10-18T14:50:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T14:50:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001811 post PendingInvicesDO 2 BSH-061001824 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001824 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='389855d6-fe97-485d-b596-5e5db00ab3ea' LIMIT 1 Date : 2025-10-18T15:12:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T15:12:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001812 post PendingInvicesDO 2 BSH-061001825 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001825 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a1dadf4b-eecd-48b4-b599-a53570285d9c' LIMIT 1 Date : 2025-10-18T17:08:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T17:08:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001813 post PendingInvicesDO 2 BSH-061001826 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001826 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4f000698-6fe3-4ef9-9ec1-e3e8fd30ca1e' LIMIT 1 Date : 2025-10-18T17:47:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T17:47:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001815 post PendingInvicesDO 2 BSH-061001828 post PendingInvicesDO 2 BSH-061001827 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001814 post PendingInvicesDO 2 BSH-061001828 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001827 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001828 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='44bcec4a-8c05-4fe3-9a09-23dab868e293' LIMIT 1 Date : 2025-10-18T18:17:12  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ee15125c-8ed3-44ba-8abe-9d889f9ab158' LIMIT 1 Date : 2025-10-18T18:17:12  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='44bcec4a-8c05-4fe3-9a09-23dab868e293' LIMIT 1 Date : 2025-10-18T18:17:12  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ee15125c-8ed3-44ba-8abe-9d889f9ab158' LIMIT 1 Date : 2025-10-18T18:17:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-18T18:17:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001816 post PendingInvicesDO 2 BSH-061001829 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001829 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='14d3b719-d72d-40c4-8b8c-1bdfc32c070d' LIMIT 1 Date : 2025-10-18T18:35:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T18:35:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001817 post PendingInvicesDO 2 BSH-061001830 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001830 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6bd1976d-29fb-40cc-b221-8017a0794353' LIMIT 1 Date : 2025-10-19T13:05:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T13:05:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001818 post PendingInvicesDO 2 BSH-061001832 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001832 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3c27f1ac-f3a0-45bc-8940-3c2a6507f0c1' LIMIT 1 Date : 2025-10-19T13:55:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T13:55:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001819 post PendingInvicesDO 2 BSH-061001833 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001833 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='09f15cf2-dbbd-4c7a-b174-cb739f1d070d' LIMIT 1 Date : 2025-10-19T14:32:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T14:32:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001820 post PendingInvicesDO 2 BSH-061001834 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001834 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6071b8e0-9859-40c4-91be-5a92cffb70f2' LIMIT 1 Date : 2025-10-19T15:08:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T15:08:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001821 post PendingInvicesDO 2 BSH-061001835 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001835 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='957d88a8-5137-4ffe-bb54-91e9ddc386a0' LIMIT 1 Date : 2025-10-19T16:17:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T16:17:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001822 post PendingInvicesDO 2 BSH-061001836 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001836 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ac2bdce0-d68f-4e51-b288-3b176ae02d55' LIMIT 1 Date : 2025-10-19T17:05:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T17:05:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001823 post PendingInvicesDO 2 BSH-061001837 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001837 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fd9d6a91-3a61-4ce7-9009-9de7a936a909' LIMIT 1 Date : 2025-10-19T17:45:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T17:45:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001824 post PendingInvicesDO 2 BSH-061001838 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001838 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2d41d427-bf27-4224-afbb-e5aa7dde55fd' LIMIT 1 Date : 2025-10-19T18:50:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T18:50:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001825 post PendingInvicesDO 2 BSH-061001839 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001839 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e14188ae-a0a2-41dd-9689-41a6e49d27c2' LIMIT 1 Date : 2025-10-20T09:47:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T09:47:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001826 post PendingInvicesDO 2 BSH-061001840 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001840 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3abd84c1-aa40-4a0e-bb28-4a0531fc62fc' LIMIT 1 Date : 2025-10-20T10:05:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T10:05:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001827 post PendingInvicesDO 2 BSH-061001841 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001841 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9bfaa199-26ef-4e3c-84e8-b3147104a557' LIMIT 1 Date : 2025-10-20T10:44:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T10:44:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001828 post PendingInvicesDO 2 BSH-061001842 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001842 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='40ed4848-84dc-457b-afb5-45a750511dca' LIMIT 1 Date : 2025-10-20T11:14:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T11:14:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001829 post PendingInvicesDO 2 BSH-061001843 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001843 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1f688abb-d1aa-4c20-984d-035cd7bbbeed' LIMIT 1 Date : 2025-10-20T11:30:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T11:30:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001831 post PendingInvicesDO 2 BSH-061001845 post PendingInvicesDO 2 BSH-061001844 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001830 post PendingInvicesDO 2 BSH-061001845 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001844 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001845 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4320b72-b634-4bae-a71b-c053b57cbc5d' LIMIT 1 Date : 2025-10-20T11:36:09  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4725bb9a-5143-458a-b155-a9af4d835f08' LIMIT 1 Date : 2025-10-20T11:36:09  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4320b72-b634-4bae-a71b-c053b57cbc5d' LIMIT 1 Date : 2025-10-20T11:36:09  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4725bb9a-5143-458a-b155-a9af4d835f08' LIMIT 1 Date : 2025-10-20T11:36:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-20T11:36:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001832 post PendingInvicesDO 2 BSH-061001846 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001846 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7e9ef98d-ba20-488a-be1b-93c2640be727' LIMIT 1 Date : 2025-10-20T11:50:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T11:50:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001833 post PendingInvicesDO 2 BSH-061001849 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001849 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cd1aa757-d47a-419a-97ce-852b15438d04' LIMIT 1 Date : 2025-10-21T11:02:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T11:02:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001834 post PendingInvicesDO 2 BSH-061001850 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001850 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9ff9f983-ae2c-4bb8-b897-4af447aa9ae2' LIMIT 1 Date : 2025-10-21T12:05:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T12:05:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001835 post PendingInvicesDO 2 BSH-061001851 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001851 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='344b4c0a-01d7-4777-953f-73d28756f612' LIMIT 1 Date : 2025-10-21T12:48:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T12:48:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001836 post PendingInvicesDO 2 BSH-061001852 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001852 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='49cc5178-4412-4ee0-96f4-0bdad6174ce3' LIMIT 1 Date : 2025-10-21T13:20:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T13:20:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001837 post PendingInvicesDO 2 BSH-061001853 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001853 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bb12c495-d495-4b6d-beb0-2696c380230f' LIMIT 1 Date : 2025-10-21T14:13:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T14:13:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001838 post PendingInvicesDO 2 BSH-061001854 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001854 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='76f7367d-b766-4f91-bf87-fb638985d322' LIMIT 1 Date : 2025-10-21T14:40:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T14:40:26 payment end 
