 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002271 post PendingInvicesDO 2 TAB-111001940 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001940 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='81cc6f3d-9114-4180-8560-8d4eaa21841d' LIMIT 1 Date : 2025-04-13T12:05:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T12:05:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002272 post PendingInvicesDO 2 TAB-111001941 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001941 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='38383735-b3f0-44cd-9581-c93dbf2b1412' LIMIT 1 Date : 2025-04-13T14:27:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T14:27:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002273 post PendingInvicesDO 2 TAB-111001942 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001942 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4c00e8bc-2ec6-4837-8ebd-e97ebe87718c' LIMIT 1 Date : 2025-04-13T15:05:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T15:05:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002274 post PendingInvicesDO 2 TAB-111001943 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001943 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='79a6c4d7-aecf-4e8e-b8ad-587257de1c91' LIMIT 1 Date : 2025-04-13T15:30:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T15:30:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002275 post PendingInvicesDO 2 TAB-111001944 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001944 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='61529ada-df38-49dc-aa32-8721363586d8' LIMIT 1 Date : 2025-04-13T15:57:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T15:57:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002276 post PendingInvicesDO 2 TAB-111001945 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001945 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a4f1a900-1b39-442e-8af9-2bd16d67861a' LIMIT 1 Date : 2025-04-13T16:51:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T16:51:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002277 post PendingInvicesDO 2 TAB-111001946 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001946 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='58a8dec9-c5a1-4123-aa4e-ec832c13fb41' LIMIT 1 Date : 2025-04-13T17:20:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T17:20:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002278 post PendingInvicesDO 2 TAB-111001947 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001947 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fd101ed5-1638-4d31-b5eb-e567ad81b7ca' LIMIT 1 Date : 2025-04-13T17:53:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T17:53:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002279 post PendingInvicesDO 2 TAB-111001948 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001948 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cc644cdd-96b7-464c-9d73-5ca4c6bbb19c' LIMIT 1 Date : 2025-04-13T18:20:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T18:20:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002280 post PendingInvicesDO 2 TAB-111001950 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001950 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='73fabbd6-8b98-4684-a637-642905f6664e' LIMIT 1 Date : 2025-04-13T18:58:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T18:58:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002281 post PendingInvicesDO 2 TAB-111001951 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001951 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2a988fba-b524-4eeb-8532-bbfa07b75f6d' LIMIT 1 Date : 2025-04-13T19:37:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-13T19:37:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002282 post PendingInvicesDO 2 TAB-111001953 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001953 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6f251be3-ff83-4c65-910b-5eb844b87098' LIMIT 1 Date : 2025-04-14T08:28:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T08:28:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002283 post PendingInvicesDO 2 TAB-111001954 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001954 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f1081352-4087-4af9-b5b2-db235906b1a0' LIMIT 1 Date : 2025-04-14T08:47:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T08:47:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002284 post PendingInvicesDO 2 TAB-111001955 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001955 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='483defe6-af96-4792-913a-51eb51427816' LIMIT 1 Date : 2025-04-14T09:12:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T09:12:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002285 post PendingInvicesDO 2 TAB-111001956 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001956 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2bce50e4-08fc-48e8-a9e2-1f844981cc96' LIMIT 1 Date : 2025-04-14T09:44:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T09:44:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002286 post PendingInvicesDO 2 TAB-111001957 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001957 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 = 'TAB-111001957' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001957' OR OrderId='TAB-111001957' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-14T10:26:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002287 post PendingInvicesDO 2 TAB-111001958 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001958 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='16988741-c922-42bf-85fa-b5c56c5ef355' LIMIT 1 Date : 2025-04-14T10:37:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T10:37:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002288 post PendingInvicesDO 2 TAB-111001961 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001961 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='505aa5f1-5b36-4c90-8240-6bb995e7bc64' LIMIT 1 Date : 2025-04-14T12:14:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T12:14:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002289 post PendingInvicesDO 2 TAB-111001962 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001962 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 = 'TAB-111001962' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001962' OR OrderId='TAB-111001962' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-14T12:46:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002290 post PendingInvicesDO 2 TAB-111001964 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001964 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='11a63655-64bf-4ac3-b93b-010088f4fc35' LIMIT 1 Date : 2025-04-14T13:47:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T13:47:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002291 post PendingInvicesDO 2 TAB-111001965 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001965 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1cb83c83-b9d7-4b44-8c30-d03e4f450bee' LIMIT 1 Date : 2025-04-14T14:02:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T14:02:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002292 post PendingInvicesDO 2 TAB-111001966 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001966 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 = 'TAB-111001966' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001966' OR OrderId='TAB-111001966' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-14T14:34:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002293 post PendingInvicesDO 2 TAB-111001967 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001967 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2d75ea6e-aae6-44c3-b43d-ba6b7ee19fcb' LIMIT 1 Date : 2025-04-14T14:46:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T14:46:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002294 post PendingInvicesDO 2 TAB-111001969 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001969' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001969' OR OrderId='TAB-111001969' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-14T18:22:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002295 post PendingInvicesDO 2 TAB-111001949 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001949' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001949' OR OrderId='TAB-111001949' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-14T18:34:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002296 post PendingInvicesDO 2 TAB-111001971 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001971 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 = 'TAB-111001971' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001971' OR OrderId='TAB-111001971' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-14T20:07:33 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 TAB-114002297 post PendingInvicesDO 2 TAB-111001972 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001972 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='073346e7-28d1-4fcc-9a95-095b389164e1' LIMIT 1 Date : 2025-04-14T23:56:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-14T23:56:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002298 post PendingInvicesDO 2 TAB-111001973 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001973 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 = 'TAB-111001973' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001973' OR OrderId='TAB-111001973' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T09:17:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002299 post PendingInvicesDO 2 TAB-111001974 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001974 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 = 'TAB-111001974' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001974' OR OrderId='TAB-111001974' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T10:09:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002300 post PendingInvicesDO 2 TAB-111001975 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001975 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 = 'TAB-111001975' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001975' OR OrderId='TAB-111001975' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T10:25:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002301 post PendingInvicesDO 2 TAB-111001976 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001976 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 = 'TAB-111001976' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001976' OR OrderId='TAB-111001976' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T10:46:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002302 post PendingInvicesDO 2 TAB-111001977 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001977 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 = 'TAB-111001977' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001977' OR OrderId='TAB-111001977' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T10:58:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002303 post PendingInvicesDO 2 TAB-111001978 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001978 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 = 'TAB-111001978' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001978' OR OrderId='TAB-111001978' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T11:25:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002304 post PendingInvicesDO 2 TAB-111001979 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001979' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001979' OR OrderId='TAB-111001979' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T12:37:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002305 post PendingInvicesDO 2 TAB-111001980 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001980 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 = 'TAB-111001980' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001980' OR OrderId='TAB-111001980' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T13:51:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002306 post PendingInvicesDO 2 TAB-111001981 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001981 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 = 'TAB-111001981' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001981' OR OrderId='TAB-111001981' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T14:30:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002307 post PendingInvicesDO 2 TAB-111001982 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001982 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 = 'TAB-111001982' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001982' OR OrderId='TAB-111001982' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T15:30:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002308 post PendingInvicesDO 2 TAB-111001984 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001984 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 = 'TAB-111001984' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001984' OR OrderId='TAB-111001984' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T17:11:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002309 post PendingInvicesDO 2 TAB-111001969 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001969' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001969' OR OrderId='TAB-111001969' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T18:00:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002310 post PendingInvicesDO 2 TAB-111001952 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001952 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 = 'TAB-111001952' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001952' OR OrderId='TAB-111001952' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T18:10:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002311 post PendingInvicesDO 2 TAB-111001959 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001959 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 = 'TAB-111001959' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001959' OR OrderId='TAB-111001959' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-15T18:51:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002312 post PendingInvicesDO 2 TAB-111001985 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001985 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8814a7de-ea3b-4aab-8409-c7bb8b5e2e41' LIMIT 1 Date : 2025-04-15T19:10:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-15T19:10:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002313 post PendingInvicesDO 2 TAB-111001987 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001987' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001987' OR OrderId='TAB-111001987' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T10:25:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002314 post PendingInvicesDO 2 TAB-111001988 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001988 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 = 'TAB-111001988' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001988' OR OrderId='TAB-111001988' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T11:44:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002315 post PendingInvicesDO 2 TAB-111001990 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001990 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 = 'TAB-111001990' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001990' OR OrderId='TAB-111001990' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T12:29:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002316 post PendingInvicesDO 2 TAB-111001991 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001991 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 = 'TAB-111001991' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001991' OR OrderId='TAB-111001991' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T13:40:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002317 post PendingInvicesDO 2 TAB-111001992 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001992 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 = 'TAB-111001992' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001992' OR OrderId='TAB-111001992' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T14:15:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002318 post PendingInvicesDO 2 TAB-111001993 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001993 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c5ac4ca4-c664-45e9-8b01-5f8cb0d1b7fb' LIMIT 1 Date : 2025-04-16T14:44:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-16T14:44:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002319 post PendingInvicesDO 2 TAB-111001994 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001994 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a2c5c804-a77d-407e-ab73-c1d1650e67f1' LIMIT 1 Date : 2025-04-16T15:02:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-16T15:02:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002320 post PendingInvicesDO 2 TAB-111001995 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001995 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 = 'TAB-111001995' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001995' OR OrderId='TAB-111001995' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T15:46:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002321 post PendingInvicesDO 2 TAB-111001996 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001996 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ecc42350-8ce5-4b3f-9c74-83a08388d3e8' LIMIT 1 Date : 2025-04-16T17:07:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-16T17:07:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002322 post PendingInvicesDO 2 TAB-111001949 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001949' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001949' OR OrderId='TAB-111001949' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T17:40:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002323 post PendingInvicesDO 2 TAB-111001997 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001997 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='12a938f6-7624-4482-b6c7-e0eabba0edd6' LIMIT 1 Date : 2025-04-16T18:11:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-16T18:11:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002324 post PendingInvicesDO 2 TAB-111001968 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001968 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 = 'TAB-111001968' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001968' OR OrderId='TAB-111001968' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T18:38:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002325 post PendingInvicesDO 2 TAB-111001989 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001989 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 = 'TAB-111001989' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001989' OR OrderId='TAB-111001989' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-16T18:39:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002326 post PendingInvicesDO 2 TAB-111001998 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001998 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4577ba8-bfb8-4efd-8494-9289230beec5' LIMIT 1 Date : 2025-04-17T08:36:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-17T08:36:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002327 post PendingInvicesDO 2 TAB-111001999 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001999 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ffd49b9b-2af5-41b7-af85-ff498dcd9eab' LIMIT 1 Date : 2025-04-17T09:22:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-17T09:22:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002328 post PendingInvicesDO 2 TAB-111002000 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002000 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 = 'TAB-111002000' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002000' OR OrderId='TAB-111002000' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T09:43:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002329 post PendingInvicesDO 2 TAB-111002001 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002001 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 = 'TAB-111002001' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002001' OR OrderId='TAB-111002001' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T11:14:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002330 post PendingInvicesDO 2 TAB-111002002 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002002 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 = 'TAB-111002002' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002002' OR OrderId='TAB-111002002' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T12:10:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002331 post PendingInvicesDO 2 TAB-111002004 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002004 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 = 'TAB-111002004' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002004' OR OrderId='TAB-111002004' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T13:26:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002332 post PendingInvicesDO 2 TAB-111002005 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002005 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 = 'TAB-111002005' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002005' OR OrderId='TAB-111002005' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T13:50:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002333 post PendingInvicesDO 2 TAB-111002006 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002006' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002006' OR OrderId='TAB-111002006' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T14:48:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002334 post PendingInvicesDO 2 TAB-111002007 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002007 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 = 'TAB-111002007' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002007' OR OrderId='TAB-111002007' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T15:06:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002335 post PendingInvicesDO 2 TAB-111002008 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002008 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 = 'TAB-111002008' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002008' OR OrderId='TAB-111002008' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T15:27:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002336 post PendingInvicesDO 2 TAB-111002009 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002009 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 = 'TAB-111002009' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002009' OR OrderId='TAB-111002009' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T15:35:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002337 post PendingInvicesDO 2 TAB-111002011 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002011 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 = 'TAB-111002011' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002011' OR OrderId='TAB-111002011' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T16:48:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002338 post PendingInvicesDO 2 TAB-111002012 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002012 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 = 'TAB-111002012' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002012' OR OrderId='TAB-111002012' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T17:28:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002339 post PendingInvicesDO 2 TAB-111002013 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002013' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002013' OR OrderId='TAB-111002013' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T18:21:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002340 post PendingInvicesDO 2 TAB-111001970 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001970 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 = 'TAB-111001970' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001970' OR OrderId='TAB-111001970' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T18:36:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002341 post PendingInvicesDO 2 TAB-111002014 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002014 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 = 'TAB-111002014' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002014' OR OrderId='TAB-111002014' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T18:49:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002342 post PendingInvicesDO 2 TAB-111002015 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002015 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d24d19db-86ce-424f-8ff5-19c9099e1a05' LIMIT 1 Date : 2025-04-17T19:04:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-17T19:04:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002343 post PendingInvicesDO 2 TAB-111002017 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002017 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 = 'TAB-111002017' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002017' OR OrderId='TAB-111002017' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-17T20:37:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002344 post PendingInvicesDO 2 TAB-111002018 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002018 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 = 'TAB-111002018' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002018' OR OrderId='TAB-111002018' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T08:44:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002345 post PendingInvicesDO 2 TAB-111002019 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002019 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 = 'TAB-111002019' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002019' OR OrderId='TAB-111002019' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T09:13:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002346 post PendingInvicesDO 2 TAB-111002020 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002020 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 = 'TAB-111002020' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002020' OR OrderId='TAB-111002020' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T10:03:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002347 post PendingInvicesDO 2 TAB-111002010 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002010 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 = 'TAB-111002010' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002010' OR OrderId='TAB-111002010' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T10:09:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002348 post PendingInvicesDO 2 TAB-111002006 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002006' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002006' OR OrderId='TAB-111002006' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T10:30:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002349 post PendingInvicesDO 2 TAB-111002003 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002003' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002003' OR OrderId='TAB-111002003' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T10:48:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002350 post PendingInvicesDO 2 TAB-111002021 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002021 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 = 'TAB-111002021' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002021' OR OrderId='TAB-111002021' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T11:48:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002351 post PendingInvicesDO 2 TAB-111002022 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002022 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 = 'TAB-111002022' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002022' OR OrderId='TAB-111002022' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T12:39:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002352 post PendingInvicesDO 2 TAB-111002025 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002025 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 = 'TAB-111002025' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002025' OR OrderId='TAB-111002025' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T14:08:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002353 post PendingInvicesDO 2 TAB-111002027 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002027 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 = 'TAB-111002027' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002027' OR OrderId='TAB-111002027' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T14:40:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002354 post PendingInvicesDO 2 TAB-111002028 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002028 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 = 'TAB-111002028' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002028' OR OrderId='TAB-111002028' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T14:41:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002355 post PendingInvicesDO 2 TAB-111001983 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001983' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001983' OR OrderId='TAB-111001983' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T15:35:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002356 post PendingInvicesDO 2 TAB-111002029 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002029 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 = 'TAB-111002029' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002029' OR OrderId='TAB-111002029' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T16:14:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002357 post PendingInvicesDO 2 TAB-111001960 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111001960 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 = 'TAB-111001960' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001960' OR OrderId='TAB-111001960' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T16:48:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002358 post PendingInvicesDO 2 TAB-111002031 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002031 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 = 'TAB-111002031' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002031' OR OrderId='TAB-111002031' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-19T18:40:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002359 post PendingInvicesDO 2 TAB-111002034 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002034 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 = 'TAB-111002034' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002034' OR OrderId='TAB-111002034' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T09:52:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002360 post PendingInvicesDO 2 TAB-111002036 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002036 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ffbb5868-1dff-457f-85e6-805a994586d8' LIMIT 1 Date : 2025-04-20T10:52:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-20T10:52:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002361 post PendingInvicesDO 2 TAB-111002038 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002038 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 = 'TAB-111002038' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002038' OR OrderId='TAB-111002038' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T11:34:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002362 post PendingInvicesDO 2 TAB-111002039 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002039 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 = 'TAB-111002039' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002039' OR OrderId='TAB-111002039' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T12:05:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002363 post PendingInvicesDO 2 TAB-111002041 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002041 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 = 'TAB-111002041' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002041' OR OrderId='TAB-111002041' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T12:39:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002364 post PendingInvicesDO 2 TAB-111002042 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002042 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 = 'TAB-111002042' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002042' OR OrderId='TAB-111002042' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T13:44:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002365 post PendingInvicesDO 2 TAB-111002043 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002043 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4e3567e7-742c-48fd-9954-22c249d81818' LIMIT 1 Date : 2025-04-20T13:56:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-20T13:57:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002366 post PendingInvicesDO 2 TAB-111002044 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002044 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 = 'TAB-111002044' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002044' OR OrderId='TAB-111002044' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T14:22:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002367 post PendingInvicesDO 2 TAB-111002045 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002045 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 = 'TAB-111002045' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002045' OR OrderId='TAB-111002045' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T14:32:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002368 post PendingInvicesDO 2 TAB-111002046 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002046 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 = 'TAB-111002046' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002046' OR OrderId='TAB-111002046' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T15:03:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002369 post PendingInvicesDO 2 TAB-111002047 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002047 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 = 'TAB-111002047' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002047' OR OrderId='TAB-111002047' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T15:53:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002370 post PendingInvicesDO 2 TAB-111002048 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002048 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e2885842-87ed-43c6-9a27-53e92dc64a78' LIMIT 1 Date : 2025-04-20T16:51:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-20T16:51:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002371 post PendingInvicesDO 2 TAB-111002049 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002049 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 = 'TAB-111002049' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002049' OR OrderId='TAB-111002049' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T17:27:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002372 post PendingInvicesDO 2 TAB-111002037 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002037' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002037' OR OrderId='TAB-111002037' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T17:55:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002373 post PendingInvicesDO 2 TAB-111002050 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002050 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 = 'TAB-111002050' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002050' OR OrderId='TAB-111002050' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-20T18:45:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002374 post PendingInvicesDO 2 TAB-111002052 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002052 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 = 'TAB-111002052' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002052' OR OrderId='TAB-111002052' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T08:48:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002375 post PendingInvicesDO 2 TAB-111002053 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002053 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 = 'TAB-111002053' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002053' OR OrderId='TAB-111002053' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T09:10:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002376 post PendingInvicesDO 2 TAB-111002054 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002054 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 = 'TAB-111002054' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002054' OR OrderId='TAB-111002054' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T09:34:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002377 post PendingInvicesDO 2 TAB-111002055 post PendingInvicesDO 2 TAB-111002056 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002055 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : true trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002056 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 = 'TAB-111002055' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002055' OR OrderId='TAB-111002055' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002056' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002056' OR OrderId='TAB-111002056' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T10:28:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002378 post PendingInvicesDO 2 TAB-111002057 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002057 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 = 'TAB-111002057' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002057' OR OrderId='TAB-111002057' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T10:47:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002379 post PendingInvicesDO 2 TAB-111002058 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002058 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 = 'TAB-111002058' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002058' OR OrderId='TAB-111002058' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T11:01:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002380 post PendingInvicesDO 2 TAB-111002059 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002059 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 = 'TAB-111002059' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002059' OR OrderId='TAB-111002059' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T12:21:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002381 post PendingInvicesDO 2 TAB-111002060 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002060 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='92e3893f-5d93-4d75-a28b-af5d44666133' LIMIT 1 Date : 2025-04-21T12:34:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-21T12:34:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002382 post PendingInvicesDO 2 TAB-111002061 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002061 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 = 'TAB-111002061' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002061' OR OrderId='TAB-111002061' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T13:30:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002383 post PendingInvicesDO 2 TAB-111002062 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002062' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002062' OR OrderId='TAB-111002062' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T13:51:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002384 post PendingInvicesDO 2 TAB-111002063 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002063 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 = 'TAB-111002063' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002063' OR OrderId='TAB-111002063' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T14:34:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002385 post PendingInvicesDO 2 TAB-111002064 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002064 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 = 'TAB-111002064' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002064' OR OrderId='TAB-111002064' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T14:50:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002386 post PendingInvicesDO 2 TAB-111001963 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111001963' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111001963' OR OrderId='TAB-111001963' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T14:57:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002387 post PendingInvicesDO 2 TAB-111002065 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002065 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 = 'TAB-111002065' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002065' OR OrderId='TAB-111002065' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T15:15:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002388 post PendingInvicesDO 2 TAB-111002066 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002066 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 = 'TAB-111002066' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002066' OR OrderId='TAB-111002066' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T15:38:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002389 post PendingInvicesDO 2 TAB-111002067 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002067 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 = 'TAB-111002067' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002067' OR OrderId='TAB-111002067' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T16:04:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002390 post PendingInvicesDO 2 TAB-111002068 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002068 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='514b34eb-b2b4-4787-b22c-564f0cf13761' LIMIT 1 Date : 2025-04-21T16:04:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-21T16:04:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002391 post PendingInvicesDO 2 TAB-111002069 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002069' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002069' OR OrderId='TAB-111002069' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T16:50:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002392 post PendingInvicesDO 2 TAB-111002070 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002070 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f496dd70-7001-4c2a-ad10-b7df05aaf391' LIMIT 1 Date : 2025-04-21T17:38:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-21T17:38:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002393 post PendingInvicesDO 2 TAB-111002071 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002071 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 = 'TAB-111002071' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002071' OR OrderId='TAB-111002071' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T18:10:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002394 post PendingInvicesDO 2 TAB-111002072 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002072 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 = 'TAB-111002072' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002072' OR OrderId='TAB-111002072' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T19:00:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002395 post PendingInvicesDO 2 TAB-111002032 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002032 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 = 'TAB-111002032' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002032' OR OrderId='TAB-111002032' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-21T21:56:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002396 post PendingInvicesDO 2 TAB-111002073 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002073 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='67934e5b-65f0-4b99-8d52-d026e2fff922' LIMIT 1 Date : 2025-04-21T22:21:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-21T22:21:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002397 post PendingInvicesDO 2 TAB-111002074 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002074 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 = 'TAB-111002074' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002074' OR OrderId='TAB-111002074' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T09:22:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002398 post PendingInvicesDO 2 TAB-111002076 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002076 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 = 'TAB-111002076' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002076' OR OrderId='TAB-111002076' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T10:07:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002399 post PendingInvicesDO 2 TAB-111002077 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002077 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 = 'TAB-111002077' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002077' OR OrderId='TAB-111002077' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T10:43:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002400 post PendingInvicesDO 2 TAB-111002078 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002078 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 = 'TAB-111002078' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002078' OR OrderId='TAB-111002078' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T11:11:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002401 post PendingInvicesDO 2 TAB-111002079 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002079 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 = 'TAB-111002079' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002079' OR OrderId='TAB-111002079' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T11:38:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002402 post PendingInvicesDO 2 TAB-111002080 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002080 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4e28182-4c0d-45be-a20e-20bb8b545c73' LIMIT 1 Date : 2025-04-22T11:52:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-04-22T11:52:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002403 post PendingInvicesDO 2 TAB-111002081 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002081 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 = 'TAB-111002081' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002081' OR OrderId='TAB-111002081' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T12:44:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002404 post PendingInvicesDO 2 TAB-111002082 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002082 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 = 'TAB-111002082' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002082' OR OrderId='TAB-111002082' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T13:30:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002405 post PendingInvicesDO 2 TAB-111002084 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : TAB-111002084 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 = 'TAB-111002084' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002084' OR OrderId='TAB-111002084' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T16:27:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002406 post PendingInvicesDO 2 TAB-111002013 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002013' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002013' OR OrderId='TAB-111002013' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T16:56:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002407 post PendingInvicesDO 2 TAB-111002087 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002087' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002087' OR OrderId='TAB-111002087' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T18:10:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 TAB-114002408 post PendingInvicesDO 2 TAB-111002088 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'TAB-111002088' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='TAB-111002088' OR OrderId='TAB-111002088' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-04-22T18:29:24 payment end 
