 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009175 post PendingInvicesDO 2 NIM-031009305 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009305 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7f9596e5-1688-4aec-8018-5cddd470534f' LIMIT 1 Date : 2025-08-03T06:47:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T06:47:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009176 post PendingInvicesDO 2 NIM-031009306 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009306 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='18bd8313-2de9-4ce9-924b-26ec6f2eda90' LIMIT 1 Date : 2025-08-03T07:18:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T07:18:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009177 post PendingInvicesDO 2 NIM-031009307 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009307 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e16d73dd-aa67-4611-b380-de339a3c7305' LIMIT 1 Date : 2025-08-03T07:46:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T07:46:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009178 post PendingInvicesDO 2 NIM-031009308 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009308 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f30ede13-4e92-4e37-adfd-be70fe273929' LIMIT 1 Date : 2025-08-03T08:12:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T08:12:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009179 post PendingInvicesDO 2 NIM-031009309 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009309 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='596c727c-0b0c-4980-95d8-f6f5e502e0e8' LIMIT 1 Date : 2025-08-03T08:21:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T08:21:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009180 post PendingInvicesDO 2 NIM-031009310 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009310 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8a0de01b-a7b6-4959-b427-b4390a804ae1' LIMIT 1 Date : 2025-08-03T08:26:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T08:26:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009181 post PendingInvicesDO 2 NIM-031009311 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009311 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b5664de0-6973-47a5-93ac-24fbb5c0b331' LIMIT 1 Date : 2025-08-03T08:38:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T08:38:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009182 post PendingInvicesDO 2 NIM-031009312 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009312 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d7cc7cc7-90a7-414a-8774-791f21efe281' LIMIT 1 Date : 2025-08-03T08:52:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T08:52:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009183 post PendingInvicesDO 2 NIM-031009313 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009313 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c5cd708b-94b7-47cd-81ca-503bd2c1da0d' LIMIT 1 Date : 2025-08-03T09:10:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T09:10:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009184 post PendingInvicesDO 2 NIM-031009314 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009314 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b9b698c8-8029-4419-9be6-6a35c6f86c85' LIMIT 1 Date : 2025-08-03T09:25:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T09:25:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009185 post PendingInvicesDO 2 NIM-031009315 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009315 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cf53b527-13c5-400a-bf70-d361f5f65d16' LIMIT 1 Date : 2025-08-03T09:30:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T09:30:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009186 post PendingInvicesDO 2 NIM-031009316 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009316 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2941cbc3-692b-4c24-8993-700c1834a32a' LIMIT 1 Date : 2025-08-03T09:50:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T09:50:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009187 post PendingInvicesDO 2 NIM-031009317 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009317 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='268c8d03-8d12-4b26-8bbf-edbde9f77446' LIMIT 1 Date : 2025-08-03T10:10:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T10:10:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009188 post PendingInvicesDO 2 NIM-031009319 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009319 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='60aee0e1-7c8f-4a18-a981-8560c5990278' LIMIT 1 Date : 2025-08-03T11:05:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T11:05:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009189 post PendingInvicesDO 2 NIM-031009320 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009320 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8d7968c2-e8c2-4ca6-8822-df8b49d95995' LIMIT 1 Date : 2025-08-03T11:25:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T11:25:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009190 post PendingInvicesDO 2 NIM-031009321 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009321 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3b97d7f2-7b1c-41ce-b67b-aa561907be87' LIMIT 1 Date : 2025-08-03T11:49:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T11:49:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009191 post PendingInvicesDO 2 NIM-031009322 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009322 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='95c027ae-0b79-461f-bc80-06b90641f2bc' LIMIT 1 Date : 2025-08-03T12:33:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T12:33:25 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 NIM-034009192 post PendingInvicesDO 2 NIM-031009323 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009323 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4ee1a47e-ef1e-405f-a31b-812aa1f7df6e' LIMIT 1 Date : 2025-08-03T13:01:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T13:01:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009193 post PendingInvicesDO 2 NIM-031009324 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009324 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3d1bc2db-31b3-4e79-ad25-0675590837a4' LIMIT 1 Date : 2025-08-03T13:49:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T13:49:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009194 post PendingInvicesDO 2 NIM-031009325 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009325 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='269de918-47f1-4c50-87f5-c455413b0729' LIMIT 1 Date : 2025-08-03T14:04:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T14:04:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009195 post PendingInvicesDO 2 NIM-031009326 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009326 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d0b7b629-bc34-4bb4-a7ea-201952779d61' LIMIT 1 Date : 2025-08-03T14:26:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-03T14:26:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009196 post PendingInvicesDO 2 NIM-031009260 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009260 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 = 'NIM-031009260' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009260' OR OrderId='NIM-031009260' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-03T14:53:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009197 post PendingInvicesDO 2 NIM-031009327 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009327 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='14d30170-ea1e-45be-8181-a90af3c16ee0' LIMIT 1 Date : 2025-08-04T07:00:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T07:00:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009198 post PendingInvicesDO 2 NIM-031009328 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009328 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='efb7b520-0c29-4812-b698-ec676e936128' LIMIT 1 Date : 2025-08-04T07:32:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T07:32:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009199 post PendingInvicesDO 2 NIM-031009329 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009329 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ccfd9475-9604-46d9-8e1e-399cd5232676' LIMIT 1 Date : 2025-08-04T07:38:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T07:38:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009200 post PendingInvicesDO 2 NIM-031009330 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009330 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b07ec7df-3e43-4660-98ba-02bc4fc8285f' LIMIT 1 Date : 2025-08-04T08:01:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T08:01:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009201 post PendingInvicesDO 2 NIM-031009332 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009332 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6c18ba5d-111d-4dff-9aae-5cb156ee5eca' LIMIT 1 Date : 2025-08-04T08:37:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T08:37:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009202 post PendingInvicesDO 2 NIM-031009334 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009334 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6cf3a7d2-6bf4-462e-8874-1a14b0326d45' LIMIT 1 Date : 2025-08-04T09:20:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T09:20:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009203 post PendingInvicesDO 2 NIM-031009335 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009335 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3930b6cd-4dd7-4d86-9a12-a539e1808e3d' LIMIT 1 Date : 2025-08-04T09:34:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T09:34:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009204 post PendingInvicesDO 2 NIM-031009336 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009336 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='99a48f6d-5a66-4054-ab2c-104527dfb688' LIMIT 1 Date : 2025-08-04T10:11:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T10:11:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009205 post PendingInvicesDO 2 NIM-031009337 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009337 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b92473d7-5576-4af2-a3b0-70fe93d0b2a1' LIMIT 1 Date : 2025-08-04T10:19:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T10:19:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009206 post PendingInvicesDO 2 NIM-031009339 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009339 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='19977c56-9901-488b-872c-0272e8fc1978' LIMIT 1 Date : 2025-08-04T11:32:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T11:32:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009207 post PendingInvicesDO 2 NIM-031009343 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009343 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='20d8e1f3-ace1-40f0-99df-b13d77a841bf' LIMIT 1 Date : 2025-08-04T13:09:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T13:09:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009208 post PendingInvicesDO 2 NIM-031009344 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009344 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b79bd32a-6d39-4d07-a3c2-5c97b5816503' LIMIT 1 Date : 2025-08-04T13:14:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T13:14:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009209 post PendingInvicesDO 2 NIM-031009345 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009345 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4c05bc11-6377-4e76-ad10-08860fcf664e' LIMIT 1 Date : 2025-08-04T13:21:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T13:21:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009210 post PendingInvicesDO 2 NIM-031009347 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009347 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7ce42893-16ff-49b2-a1da-d5f86928aacf' LIMIT 1 Date : 2025-08-04T13:58:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T13:58:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009211 post PendingInvicesDO 2 NIM-031009348 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009348 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1ac93b3e-512b-4227-9a12-b34ef7e56670' LIMIT 1 Date : 2025-08-04T14:04:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-04T14:04:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009212 post PendingInvicesDO 2 NIM-031009349 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009349 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b1d6afb1-263f-4925-b035-585229496995' LIMIT 1 Date : 2025-08-05T07:12:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T07:12:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009213 post PendingInvicesDO 2 NIM-031009350 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009350 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c44e16f8-a48f-4204-8d39-8d1128387159' LIMIT 1 Date : 2025-08-05T07:37:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T07:37:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009214 post PendingInvicesDO 2 NIM-031009351 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009351 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f195fac3-ce6c-4020-bde5-dc325eea9335' LIMIT 1 Date : 2025-08-05T08:15:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T08:15:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009215 post PendingInvicesDO 2 NIM-031009333 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'NIM-031009333' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009333' OR OrderId='NIM-031009333' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-05T08:30:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009216 post PendingInvicesDO 2 NIM-031009352 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009352 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5d4c2076-0603-43b1-bedb-be31b9ca76db' LIMIT 1 Date : 2025-08-05T08:36:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T08:36:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009217 post PendingInvicesDO 2 NIM-031009353 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009353 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e131e4d5-5fb8-44b0-88d8-1b4726b3426f' LIMIT 1 Date : 2025-08-05T09:05:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T09:05:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009218 post PendingInvicesDO 2 NIM-031009354 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009354 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1c11ab5c-007c-40a3-b463-affd33f098f7' LIMIT 1 Date : 2025-08-05T09:25:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T09:25:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009219 post PendingInvicesDO 2 NIM-031009355 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009355 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f9f94b35-40b6-49da-96c5-4cf44c46f3a5' LIMIT 1 Date : 2025-08-05T09:34:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T09:34:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009220 post PendingInvicesDO 2 NIM-031009356 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009356 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b33e3e7b-c546-4e2b-ae59-76bfeec4f1db' LIMIT 1 Date : 2025-08-05T09:59:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T09:59:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009221 post PendingInvicesDO 2 NIM-031009357 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009357 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='da43e995-0d20-47cf-971f-23b7db90b153' LIMIT 1 Date : 2025-08-05T10:16:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T10:16:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009222 post PendingInvicesDO 2 NIM-031009358 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009358 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f65b23d2-337e-4ac9-8aed-1ad586ca2374' LIMIT 1 Date : 2025-08-05T10:33:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T10:33:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009223 post PendingInvicesDO 2 NIM-031009359 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009359 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a8b42413-045f-49df-90c5-f7ccecb21153' LIMIT 1 Date : 2025-08-05T10:49:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T10:49:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009224 post PendingInvicesDO 2 NIM-031009360 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009360 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='78f028bd-2b73-4a63-a180-ddb638072d8e' LIMIT 1 Date : 2025-08-05T11:13:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T11:13:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009225 post PendingInvicesDO 2 NIM-031009361 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009361 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ec407539-5d26-4909-b186-9d61e319cb7d' LIMIT 1 Date : 2025-08-05T11:32:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T11:32:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009226 post PendingInvicesDO 2 NIM-031009362 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009362 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='53e89618-41fe-40f3-a910-737eb5d67314' LIMIT 1 Date : 2025-08-05T11:45:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T11:45:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009227 post PendingInvicesDO 2 NIM-031009363 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009363 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='61c65ff3-914f-48e8-b274-c29ede68d45e' LIMIT 1 Date : 2025-08-05T11:49:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T11:49:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009228 post PendingInvicesDO 2 NIM-031009364 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009364 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8aa26c98-9981-42ea-8a0e-d26b7d0eb3cf' LIMIT 1 Date : 2025-08-05T11:56:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T11:56:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009229 post PendingInvicesDO 2 NIM-031009365 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009365 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5803f8b2-ac22-4474-8f1e-f6f971cc923b' LIMIT 1 Date : 2025-08-05T12:31:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T12:31:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009230 post PendingInvicesDO 2 NIM-031009366 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009366 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ef03f00e-a6dd-4a5b-85e0-73ae729911f3' LIMIT 1 Date : 2025-08-05T12:50:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T12:50:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009231 post PendingInvicesDO 2 NIM-031009367 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009367 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1fd85a15-3370-401c-8648-3a12f5e2b5ba' LIMIT 1 Date : 2025-08-05T13:08:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T13:08:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009232 post PendingInvicesDO 2 NIM-031009368 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009368 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e4b23dc3-9a6b-41dd-b4ce-ffb828a9288d' LIMIT 1 Date : 2025-08-05T13:33:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T13:33:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009233 post PendingInvicesDO 2 NIM-031009369 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009369 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7d4f1a81-d0fa-42f7-88a3-30afc78f64cf' LIMIT 1 Date : 2025-08-05T13:46:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T13:46:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009234 post PendingInvicesDO 2 NIM-031009370 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009370 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='70fa7d08-8142-4474-b1ca-b4d64788ce25' LIMIT 1 Date : 2025-08-05T14:02:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T14:02:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009235 post PendingInvicesDO 2 NIM-031009371 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009371 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b336a6a4-33c0-4331-9084-23d4c54460ad' LIMIT 1 Date : 2025-08-05T14:25:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T14:25:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009236 post PendingInvicesDO 2 NIM-031009372 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009372 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e866dfea-3af3-475c-a802-cbdf1ea698b8' LIMIT 1 Date : 2025-08-05T15:08:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T15:08:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009237 post PendingInvicesDO 2 NIM-031009373 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009373 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='99196a11-9cad-46de-85a7-519ef08da76e' LIMIT 1 Date : 2025-08-05T15:22:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-05T15:22:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009238 post PendingInvicesDO 2 NIM-031009374 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009374 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e8e4830b-f732-4b1f-8436-c747dbad335d' LIMIT 1 Date : 2025-08-06T07:05:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T07:05:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009239 post PendingInvicesDO 2 NIM-031009375 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009375 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='84832bf6-abae-4a56-8d9a-2afab86c2a76' LIMIT 1 Date : 2025-08-06T07:35:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T07:35:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009240 post PendingInvicesDO 2 NIM-031009376 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009376 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e4a86615-76b6-4559-a199-6900f3cf9a70' LIMIT 1 Date : 2025-08-06T08:07:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T08:07:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009241 post PendingInvicesDO 2 NIM-031009377 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009377 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d314884a-eb71-45fa-9b20-9f59e5485155' LIMIT 1 Date : 2025-08-06T08:24:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T08:24:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009242 post PendingInvicesDO 2 NIM-031009378 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009378 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='70096e55-d0b0-4aed-8dab-2aeb616f3e17' LIMIT 1 Date : 2025-08-06T08:45:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T08:45:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009243 post PendingInvicesDO 2 NIM-031009379 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009379 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='660695f3-886f-4d04-8ec5-dc424aa4b68b' LIMIT 1 Date : 2025-08-06T09:13:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T09:13:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009244 post PendingInvicesDO 2 NIM-031009380 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009380 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3c5b0134-f60e-4bb3-bca7-28ede493d9ea' LIMIT 1 Date : 2025-08-06T09:24:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T09:24:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009245 post PendingInvicesDO 2 NIM-031009381 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009381 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f43368e7-a883-4c58-9782-b52913c5ee16' LIMIT 1 Date : 2025-08-06T09:36:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T09:36:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009246 post PendingInvicesDO 2 NIM-031009383 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009383 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='af35c623-8c76-4f59-b768-ab6a37f5b542' LIMIT 1 Date : 2025-08-06T10:15:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T10:15:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009247 post PendingInvicesDO 2 NIM-031009384 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009384 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9f3c8535-641b-4028-9c96-42332375bf52' LIMIT 1 Date : 2025-08-06T10:37:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T10:37:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009248 post PendingInvicesDO 2 NIM-031009386 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009386 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7285b27f-1a6a-4ac2-ac40-e31621fac11d' LIMIT 1 Date : 2025-08-06T11:24:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T11:24:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009249 post PendingInvicesDO 2 NIM-031009387 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009387 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f325fe76-5171-4918-839f-75e9f2bbc3dc' LIMIT 1 Date : 2025-08-06T12:00:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T12:00:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009250 post PendingInvicesDO 2 NIM-031009388 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009388 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='514f2d80-c2a8-45da-a970-54c95f22160d' LIMIT 1 Date : 2025-08-06T12:11:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T12:11:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009251 post PendingInvicesDO 2 NIM-031009389 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009389 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5048df50-e522-4e2b-ae27-1e76cc5735b4' LIMIT 1 Date : 2025-08-06T12:37:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T12:37:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009252 post PendingInvicesDO 2 NIM-031009390 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009390 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e1c3253a-09d4-446b-aa84-3a7393428f18' LIMIT 1 Date : 2025-08-06T13:05:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T13:05:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009253 post PendingInvicesDO 2 NIM-031009391 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009391 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a287d587-1255-47c1-a2a5-f210d753d6eb' LIMIT 1 Date : 2025-08-06T13:26:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T13:26:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009254 post PendingInvicesDO 2 NIM-031009392 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009392 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1e8ea480-2a7a-41b3-b4f0-5d0560bdab1e' LIMIT 1 Date : 2025-08-06T13:59:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T13:59:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009255 post PendingInvicesDO 2 NIM-031009393 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009393 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='86eb5c0b-7414-4f65-88ca-bab666824ffb' LIMIT 1 Date : 2025-08-06T14:50:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T14:50:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009256 post PendingInvicesDO 2 NIM-031009394 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009394 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8b9e0612-f1fc-4d2a-85b3-f262e4dba98d' LIMIT 1 Date : 2025-08-06T14:53:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T14:53:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009257 post PendingInvicesDO 2 NIM-031009395 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009395 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='38eb541d-685f-4182-8331-c8aec47a2681' LIMIT 1 Date : 2025-08-06T14:57:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T14:57:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009258 post PendingInvicesDO 2 NIM-031009396 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009396 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='67b83b9c-43b6-4a35-9ace-9b5b23b2b42a' LIMIT 1 Date : 2025-08-06T15:01:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T15:01:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009259 post PendingInvicesDO 2 NIM-031009397 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009397 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9df98f9e-ece4-429a-aa03-79778133305f' LIMIT 1 Date : 2025-08-06T15:08:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T15:08:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009260 post PendingInvicesDO 2 NIM-031009398 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009398 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='55c3cc2c-3a04-4892-90df-22bea93c1f44' LIMIT 1 Date : 2025-08-06T15:13:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T15:13:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009261 post PendingInvicesDO 2 NIM-031009399 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009399 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8e322d81-ebc2-466b-9741-e752a8f2689e' LIMIT 1 Date : 2025-08-06T15:19:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T15:19:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009262 post PendingInvicesDO 2 NIM-031009400 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009400 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='aae6a976-cd31-454f-9591-308c477a9614' LIMIT 1 Date : 2025-08-06T15:22:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T15:22:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009263 post PendingInvicesDO 2 NIM-031009401 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009401 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b42d52b2-de56-4244-ad98-d1d0ce4543dd' LIMIT 1 Date : 2025-08-06T15:26:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-06T15:26:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009264 post PendingInvicesDO 2 NIM-031009346 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009346 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 = 'NIM-031009346' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009346' OR OrderId='NIM-031009346' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-06T16:11:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009266 post PendingInvicesDO 2 NIM-031009403 post PendingInvicesDO 2 NIM-031009402 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 NIM-034009265 post PendingInvicesDO 2 NIM-031009403 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : NIM-031009402 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009403 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e3fa995d-2cce-4616-b020-0b3d87258d05' LIMIT 1 Date : 2025-08-06T16:13:03  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='394e94b0-46e2-4195-b183-7730415d62ee' LIMIT 1 Date : 2025-08-06T16:13:03  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e3fa995d-2cce-4616-b020-0b3d87258d05' LIMIT 1 Date : 2025-08-06T16:13:03  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='394e94b0-46e2-4195-b183-7730415d62ee' LIMIT 1 Date : 2025-08-06T16:13:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-08-06T16:13:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009267 post PendingInvicesDO 2 NIM-031009404 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009404 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f73e526a-76e9-4a19-bca4-00d7382ccb63' LIMIT 1 Date : 2025-08-07T06:23:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T06:23:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009268 post PendingInvicesDO 2 NIM-031009405 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009405 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cfdcfcbf-9746-4b26-91a3-de66ff760aaa' LIMIT 1 Date : 2025-08-07T07:26:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T07:26:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009269 post PendingInvicesDO 2 NIM-031009406 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009406 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7d6c726d-8bc3-45cb-84b9-f62e7095ccad' LIMIT 1 Date : 2025-08-07T07:42:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T07:42:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009270 post PendingInvicesDO 2 NIM-031009407 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'NIM-031009407' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009407' OR OrderId='NIM-031009407' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-07T08:03:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009271 post PendingInvicesDO 2 NIM-031009408 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009408 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='92bbf011-3b8e-4d3e-8512-dbb567a9c59e' LIMIT 1 Date : 2025-08-07T08:17:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T08:17:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009272 post PendingInvicesDO 2 NIM-031009410 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009410 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a5e6bc7c-7b3e-486c-af88-3618bcf10537' LIMIT 1 Date : 2025-08-07T09:02:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T09:02:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009273 post PendingInvicesDO 2 NIM-031009411 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009411 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0eb60528-0196-4741-9cd7-c7771c632b59' LIMIT 1 Date : 2025-08-07T09:20:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T09:20:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009274 post PendingInvicesDO 2 NIM-031009412 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009412 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2b81d053-be16-4b2d-9760-89608fc76661' LIMIT 1 Date : 2025-08-07T09:43:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T09:43:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009275 post PendingInvicesDO 2 NIM-031009413 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009413 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6dc03dd4-c823-47bb-9222-55edd59f6c8f' LIMIT 1 Date : 2025-08-07T10:06:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T10:06:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009276 post PendingInvicesDO 2 NIM-031009414 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009414 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7791f0c7-2d3d-4b9a-a3f7-5de8098f80be' LIMIT 1 Date : 2025-08-07T10:19:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T10:19:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009277 post PendingInvicesDO 2 NIM-031009415 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009415 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d89a5bc3-217b-4cbd-8da8-95545bc73d12' LIMIT 1 Date : 2025-08-07T10:32:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T10:32:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009278 post PendingInvicesDO 2 NIM-031009416 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009416 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dd875e08-05c8-455d-9af0-6d35126c2adf' LIMIT 1 Date : 2025-08-07T10:36:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T10:36:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009279 post PendingInvicesDO 2 NIM-031009417 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009417 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9c1f5634-39b4-4f5c-8135-3bf57f040ee4' LIMIT 1 Date : 2025-08-07T10:50:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T10:50:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009280 post PendingInvicesDO 2 NIM-031009418 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009418 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bfec43f7-e347-4f6e-b833-105be3d60337' LIMIT 1 Date : 2025-08-07T11:14:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T11:14:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009281 post PendingInvicesDO 2 NIM-031009419 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009419 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ef4b4fd6-a657-41b3-86f0-16c4a0d9f021' LIMIT 1 Date : 2025-08-07T11:35:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T11:35:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009282 post PendingInvicesDO 2 NIM-031009420 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009420 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='686ac41a-282c-4e53-afc9-05ba818c33e2' LIMIT 1 Date : 2025-08-07T11:51:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T11:51:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009283 post PendingInvicesDO 2 NIM-031009421 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009421 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='39dbbb33-9ecd-431a-b699-d035c5a05d8d' LIMIT 1 Date : 2025-08-07T12:18:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T12:18:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009284 post PendingInvicesDO 2 NIM-031009152 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009152 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 = 'NIM-031009152' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009152' OR OrderId='NIM-031009152' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-07T12:33:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009285 post PendingInvicesDO 2 NIM-031009423 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009423 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e40100ba-c700-42ed-a079-cc507b3da67e' LIMIT 1 Date : 2025-08-07T12:57:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T12:57:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009286 post PendingInvicesDO 2 NIM-031009424 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009424 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='18952b89-3a2a-4105-9a82-f7cd8be02d6f' LIMIT 1 Date : 2025-08-07T13:43:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T13:43:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009287 post PendingInvicesDO 2 NIM-031009425 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009425 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c4c0f6da-fa5e-4284-aba8-30f838e70399' LIMIT 1 Date : 2025-08-07T14:21:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-07T14:21:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009288 post PendingInvicesDO 2 NIM-031009331 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009331 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 = 'NIM-031009331' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009331' OR OrderId='NIM-031009331' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-07T14:41:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009289 post PendingInvicesDO 2 NIM-031009382 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009382 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 = 'NIM-031009382' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009382' OR OrderId='NIM-031009382' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-07T14:44:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009290 post PendingInvicesDO 2 NIM-031009333 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'NIM-031009333' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009333' OR OrderId='NIM-031009333' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-07T15:31:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009291 post PendingInvicesDO 2 NIM-031009426 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009426 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2b264d4a-02a3-4561-a254-d438e1dc89d6' LIMIT 1 Date : 2025-08-09T06:41:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T06:41:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009292 post PendingInvicesDO 2 NIM-031009428 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009428 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='354cc769-b748-4c20-a2b6-35648adc4b71' LIMIT 1 Date : 2025-08-09T07:50:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T07:50:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009293 post PendingInvicesDO 2 NIM-031009429 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009429 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e4965702-100a-4dcb-8209-1663b38c8312' LIMIT 1 Date : 2025-08-09T08:12:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T08:12:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009294 post PendingInvicesDO 2 NIM-031009430 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009430 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e771285a-a3f3-4bd8-ae4d-d44c2d545f82' LIMIT 1 Date : 2025-08-09T08:17:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T08:17:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009295 post PendingInvicesDO 2 NIM-031009431 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009431 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='76fc8b8e-d4cb-491c-a1c1-fc62219c7a7f' LIMIT 1 Date : 2025-08-09T08:25:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T08:25:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009296 post PendingInvicesDO 2 NIM-031009432 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009432 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8a90ab15-da8d-4c5e-ac10-37e564a7e4a7' LIMIT 1 Date : 2025-08-09T08:44:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T08:44:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009297 post PendingInvicesDO 2 NIM-031009433 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009433 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7b28eb9b-0f04-40b1-b04c-befc4edb1f59' LIMIT 1 Date : 2025-08-09T09:00:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T09:00:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009298 post PendingInvicesDO 2 NIM-031009434 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009434 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a4b8e88d-72dc-4d1a-ab62-15048036de01' LIMIT 1 Date : 2025-08-09T09:20:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T09:20:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009299 post PendingInvicesDO 2 NIM-031009435 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009435 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='42fccb2c-66b0-4e48-9382-ab2bbb0807e2' LIMIT 1 Date : 2025-08-09T09:31:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T09:31:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009300 post PendingInvicesDO 2 NIM-031009436 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009436 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='82c121c2-5cdf-4a3f-9411-77d3dd8bfece' LIMIT 1 Date : 2025-08-09T09:42:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T09:42:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009301 post PendingInvicesDO 2 NIM-031009437 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009437 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9f1f49c3-3ac3-49e6-a882-f7381fa2020b' LIMIT 1 Date : 2025-08-09T09:57:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T09:57:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009302 post PendingInvicesDO 2 NIM-031009438 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009438 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='31751c3a-7d29-4f23-8938-bf3048fe0cca' LIMIT 1 Date : 2025-08-09T10:30:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T10:30:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009303 post PendingInvicesDO 2 NIM-031009439 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009439 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c4df9020-2b8f-494c-9dff-2308014974a6' LIMIT 1 Date : 2025-08-09T10:51:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T10:51:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009304 post PendingInvicesDO 2 NIM-031009440 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009440 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='74b0f42d-6645-49b9-8157-111171bff572' LIMIT 1 Date : 2025-08-09T11:07:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T11:07:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009305 post PendingInvicesDO 2 NIM-031009441 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009441 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9e6f0804-becf-42ef-b5ee-4852320b6d9f' LIMIT 1 Date : 2025-08-09T11:21:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T11:21:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009306 post PendingInvicesDO 2 NIM-031009442 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009442 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='224d62f6-7881-4460-bb6e-1bd3a56ca828' LIMIT 1 Date : 2025-08-09T11:52:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T11:52:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009307 post PendingInvicesDO 2 NIM-031009443 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009443 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ccf0c2ba-b76a-4dfe-a79f-1c1e7102bdf2' LIMIT 1 Date : 2025-08-09T12:01:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T12:01:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009308 post PendingInvicesDO 2 NIM-031009444 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009444 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='191364fb-0693-43d7-bf9a-16658a1581e2' LIMIT 1 Date : 2025-08-09T12:06:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T12:06:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009309 post PendingInvicesDO 2 NIM-031009445 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009445 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6d9c6a47-ed0d-461e-9c53-fc1760da21ee' LIMIT 1 Date : 2025-08-09T12:21:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T12:21:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009310 post PendingInvicesDO 2 NIM-031009446 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009446 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='10db2985-cf30-4604-a74d-f5b094cb55a5' LIMIT 1 Date : 2025-08-09T12:42:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T12:42:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009311 post PendingInvicesDO 2 NIM-031009447 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009447 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7ca7471a-816a-4b7d-977c-97c10d7328f0' LIMIT 1 Date : 2025-08-09T12:58:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T12:58:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009312 post PendingInvicesDO 2 NIM-031009448 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009448 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='95ea24e6-c8c9-4b9a-a1e1-660926d1c32e' LIMIT 1 Date : 2025-08-09T13:08:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T13:08:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009313 post PendingInvicesDO 2 NIM-031009449 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009449 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='097a9ae6-d24a-4f6f-b9d8-5c5c3c3e3f08' LIMIT 1 Date : 2025-08-09T13:19:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T13:19:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009314 post PendingInvicesDO 2 NIM-031009450 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009450 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='06b97ea1-d497-476e-96c6-1d355f37bfc8' LIMIT 1 Date : 2025-08-09T13:27:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T13:27:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009315 post PendingInvicesDO 2 NIM-031009451 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009451 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='18e904ab-8882-4304-ba05-e8f224995051' LIMIT 1 Date : 2025-08-09T13:35:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T13:35:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009316 post PendingInvicesDO 2 NIM-031009452 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009452 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='30eab93d-b563-440d-9ae2-c9a4208446d2' LIMIT 1 Date : 2025-08-09T13:53:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T13:53:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009317 post PendingInvicesDO 2 NIM-031009453 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009453 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d0231c2-4e9e-4af1-8e01-3457586e11e5' LIMIT 1 Date : 2025-08-09T14:52:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T14:52:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009318 post PendingInvicesDO 2 NIM-031009454 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009454 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='276b0438-8542-4137-b522-6eee608c5430' LIMIT 1 Date : 2025-08-09T15:11:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-09T15:11:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009319 post PendingInvicesDO 2 NIM-031009455 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009455 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ca886eda-de7c-41e4-a8ee-d15332cdf0f6' LIMIT 1 Date : 2025-08-10T06:39:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T06:39:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009320 post PendingInvicesDO 2 NIM-031009456 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009456 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9d457eeb-a160-40c9-8a06-747708f33f45' LIMIT 1 Date : 2025-08-10T07:07:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T07:07:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009321 post PendingInvicesDO 2 NIM-031009457 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009457 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5ab4be5b-78e4-4e76-99c3-8762a4a4b305' LIMIT 1 Date : 2025-08-10T07:31:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T07:31:34 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 NIM-034009322 post PendingInvicesDO 2 NIM-031009458 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009458 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='403bf4a4-417a-421f-9149-8efda4432416' LIMIT 1 Date : 2025-08-10T07:59:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T07:59:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009323 post PendingInvicesDO 2 NIM-031009459 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009459 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ab72188a-725d-4e57-b2c2-4020ebeb446e' LIMIT 1 Date : 2025-08-10T08:25:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T08:25:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009324 post PendingInvicesDO 2 NIM-031009460 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009460 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c9930803-aad9-4c95-81a7-80d8c6877066' LIMIT 1 Date : 2025-08-10T08:40:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T08:40:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009325 post PendingInvicesDO 2 NIM-031009461 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009461 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0ade0555-8f06-4706-91d0-693f27e715ed' LIMIT 1 Date : 2025-08-10T08:56:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T08:56:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009326 post PendingInvicesDO 2 NIM-031009462 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009462 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4a694b71-65e4-4343-9b39-7f6a85c1f78b' LIMIT 1 Date : 2025-08-10T09:16:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T09:16:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009327 post PendingInvicesDO 2 NIM-031009463 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009463 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3dd6c498-94fd-4005-bbd6-1cab7429ebbd' LIMIT 1 Date : 2025-08-10T09:36:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T09:36:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009328 post PendingInvicesDO 2 NIM-031009464 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009464 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0bef0b64-e550-4991-8919-ec474d83e9f7' LIMIT 1 Date : 2025-08-10T10:04:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T10:04:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009329 post PendingInvicesDO 2 NIM-031009465 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009465 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5c32c877-6f0a-49b7-8b0f-92f1d74bc7a7' LIMIT 1 Date : 2025-08-10T10:17:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T10:17:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009330 post PendingInvicesDO 2 NIM-031009466 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009466 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1a43f23c-e64b-4a4d-a8ea-878587ccfd92' LIMIT 1 Date : 2025-08-10T11:06:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T11:06:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009331 post PendingInvicesDO 2 NIM-031009467 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009467 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1665e083-62d2-4479-a190-07b49a89a675' LIMIT 1 Date : 2025-08-10T11:34:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T11:34:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009332 post PendingInvicesDO 2 NIM-031009407 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'NIM-031009407' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009407' OR OrderId='NIM-031009407' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-10T12:12:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009333 post PendingInvicesDO 2 NIM-031009409 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009409 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 = 'NIM-031009409' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009409' OR OrderId='NIM-031009409' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-10T12:12:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009334 post PendingInvicesDO 2 NIM-031009468 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009468 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f6316578-9b95-46ae-8641-5e63278141c7' LIMIT 1 Date : 2025-08-10T13:08:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T13:08:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009335 post PendingInvicesDO 2 NIM-031009470 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009470 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7b0c8aec-7fa9-488b-a15e-906cd544a3c6' LIMIT 1 Date : 2025-08-10T14:24:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T14:24:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009336 post PendingInvicesDO 2 NIM-031009471 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009471 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1679aaf1-8d53-4e4b-80d9-a7bbf908c277' LIMIT 1 Date : 2025-08-10T14:38:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T14:38:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009337 post PendingInvicesDO 2 NIM-031009472 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009472 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6372fea5-a773-4620-b981-8f596330d31b' LIMIT 1 Date : 2025-08-10T14:50:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T14:50:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009338 post PendingInvicesDO 2 NIM-031009473 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009473 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='13a83f06-6441-4368-bc9c-92bed0bc3984' LIMIT 1 Date : 2025-08-10T15:02:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-10T15:02:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009339 post PendingInvicesDO 2 NIM-031009475 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009475 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e69602d3-8c26-4bba-b296-b6f673e730e8' LIMIT 1 Date : 2025-08-11T07:49:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T07:49:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009340 post PendingInvicesDO 2 NIM-031009476 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009476 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e832530b-d1bc-4836-8f0d-d55e36c1f5c6' LIMIT 1 Date : 2025-08-11T07:56:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T07:56:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009341 post PendingInvicesDO 2 NIM-031009477 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009477 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f92a026f-b477-4a35-aa8a-3333f7e89842' LIMIT 1 Date : 2025-08-11T08:03:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T08:03:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009342 post PendingInvicesDO 2 NIM-031009478 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009478 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='512a6a6c-7311-4495-b8e2-a3e1e1325ac1' LIMIT 1 Date : 2025-08-11T08:11:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T08:11:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009343 post PendingInvicesDO 2 NIM-031009480 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009480 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f989520a-3a42-4ded-9f00-0a63bade4603' LIMIT 1 Date : 2025-08-11T08:57:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T08:57:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009344 post PendingInvicesDO 2 NIM-031009481 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009481 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ac11ed4f-7604-45d4-9d95-0b6f5897b8b5' LIMIT 1 Date : 2025-08-11T09:33:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T09:33:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009345 post PendingInvicesDO 2 NIM-031009482 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009482 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4dfe08a3-e41c-4879-be88-cff86a756dd8' LIMIT 1 Date : 2025-08-11T09:43:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T09:43:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009346 post PendingInvicesDO 2 NIM-031009485 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009485 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ed12418e-cd17-4bed-b667-bf0946437584' LIMIT 1 Date : 2025-08-11T12:10:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T12:10:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009347 post PendingInvicesDO 2 NIM-031009486 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009486 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e369254d-adba-48f2-86a2-5ac506029071' LIMIT 1 Date : 2025-08-11T13:15:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T13:15:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009348 post PendingInvicesDO 2 NIM-031009488 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009488 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='70577cc4-401c-4b1e-a974-c828262c44fa' LIMIT 1 Date : 2025-08-11T13:50:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T13:50:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009349 post PendingInvicesDO 2 NIM-031009489 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009489 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5f2d6125-a0b0-4fbb-86b0-ce409c113205' LIMIT 1 Date : 2025-08-11T13:57:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T13:57:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009350 post PendingInvicesDO 2 NIM-031009490 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009490 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cd427751-4e53-4651-9639-88027a70ff99' LIMIT 1 Date : 2025-08-11T14:19:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T14:19:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009351 post PendingInvicesDO 2 NIM-031009491 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009491 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b14289db-9438-4abf-98e2-310ec139430c' LIMIT 1 Date : 2025-08-11T14:39:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T14:39:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009352 post PendingInvicesDO 2 NIM-031009492 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009492 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a4c4ac6b-1dc0-4cb7-b9db-f6c22d213522' LIMIT 1 Date : 2025-08-11T14:53:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T14:53:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009353 post PendingInvicesDO 2 NIM-031009494 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009494 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a0e28a6d-449a-4087-9612-dfc74b8282af' LIMIT 1 Date : 2025-08-11T15:37:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-11T15:37:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009355 post PendingInvicesDO 2 NIM-031009497 post PendingInvicesDO 2 NIM-031009496 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 NIM-034009354 post PendingInvicesDO 2 NIM-031009497 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : NIM-031009496 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009497 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3df581d6-0c41-4584-8e08-f316f445a2e7' LIMIT 1 Date : 2025-08-12T07:12:25  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c72450b4-5932-4776-9446-b1c6ecccc01b' LIMIT 1 Date : 2025-08-12T07:12:25  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3df581d6-0c41-4584-8e08-f316f445a2e7' LIMIT 1 Date : 2025-08-12T07:12:25  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c72450b4-5932-4776-9446-b1c6ecccc01b' LIMIT 1 Date : 2025-08-12T07:12:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-08-12T07:12:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009356 post PendingInvicesDO 2 NIM-031009498 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009498 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d589108e-a159-4124-98ce-cfca5d927c2a' LIMIT 1 Date : 2025-08-12T07:26:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T07:26:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009357 post PendingInvicesDO 2 NIM-031009499 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009499 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='27b38460-bdeb-486b-9073-4d2c711fca0f' LIMIT 1 Date : 2025-08-12T08:02:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T08:02:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009358 post PendingInvicesDO 2 NIM-031009500 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009500 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dddc6a38-9391-4157-9edd-94595b24d0e2' LIMIT 1 Date : 2025-08-12T08:23:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T08:23:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009359 post PendingInvicesDO 2 NIM-031009501 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009501 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6a9ffdff-8543-4021-be38-dcc4f0c7517c' LIMIT 1 Date : 2025-08-12T08:44:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T08:44:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009360 post PendingInvicesDO 2 NIM-031009502 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009502 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f1ac96f0-8a9b-48ae-98d2-df8cdec863d5' LIMIT 1 Date : 2025-08-12T09:04:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T09:04:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009361 post PendingInvicesDO 2 NIM-031009503 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009503 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b0368cbb-9c99-4889-815c-267b2f31698b' LIMIT 1 Date : 2025-08-12T09:16:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T09:16:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009362 post PendingInvicesDO 2 NIM-031009504 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009504 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e95c2953-a7d2-47be-9bff-040cbc711c80' LIMIT 1 Date : 2025-08-12T09:29:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T09:29:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009363 post PendingInvicesDO 2 NIM-031009505 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009505 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8fc9e856-1381-4240-bb47-2896c8ab457a' LIMIT 1 Date : 2025-08-12T09:50:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T09:50:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009364 post PendingInvicesDO 2 NIM-031009506 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009506 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a429a091-c803-468b-beec-4961649553c5' LIMIT 1 Date : 2025-08-12T10:07:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T10:07:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009365 post PendingInvicesDO 2 NIM-031009507 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009507 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1205784f-3076-4759-a3eb-fb970fd402d0' LIMIT 1 Date : 2025-08-12T10:21:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T10:21:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009366 post PendingInvicesDO 2 NIM-031009508 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009508 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6e978637-f587-4c95-9f35-f37365b8793c' LIMIT 1 Date : 2025-08-12T10:41:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T10:41:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009367 post PendingInvicesDO 2 NIM-031009509 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009509 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eec55f42-43d5-466e-9c93-d5f2e4f4c62e' LIMIT 1 Date : 2025-08-12T10:49:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T10:49:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009368 post PendingInvicesDO 2 NIM-031009510 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009510 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e56dcc98-b3d6-4bbf-acc8-2530822b51c7' LIMIT 1 Date : 2025-08-12T11:13:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T11:13:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009369 post PendingInvicesDO 2 NIM-031009511 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009511 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='17014d36-f6ed-4eff-8a20-f53e5a91c5ea' LIMIT 1 Date : 2025-08-12T11:25:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T11:25:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009370 post PendingInvicesDO 2 NIM-031009512 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009512 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0cc948fd-74b8-4285-a740-6cb3c0b8689b' LIMIT 1 Date : 2025-08-12T11:49:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T11:49:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009371 post PendingInvicesDO 2 NIM-031009513 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009513 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eb35515a-1065-4744-afb9-5dc7aa7a53c3' LIMIT 1 Date : 2025-08-12T12:49:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T12:49:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009372 post PendingInvicesDO 2 NIM-031009514 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009514 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0a73adfa-454e-414f-a326-0d52a750e897' LIMIT 1 Date : 2025-08-12T13:06:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T13:06:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009373 post PendingInvicesDO 2 NIM-031009515 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009515 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='75c11932-ad35-47d7-a983-830315f473be' LIMIT 1 Date : 2025-08-12T13:39:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T13:39:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009374 post PendingInvicesDO 2 NIM-031009516 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009516 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cc43aa39-9302-43a4-bb81-3a6e819d4b7c' LIMIT 1 Date : 2025-08-12T13:52:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T13:52:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009375 post PendingInvicesDO 2 NIM-031009517 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009517 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c47088fd-277d-4644-9e15-246efc44ca0b' LIMIT 1 Date : 2025-08-12T14:06:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T14:06:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009376 post PendingInvicesDO 2 NIM-031009518 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009518 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b52a9b3f-146b-4cb6-8a02-c184b00338c0' LIMIT 1 Date : 2025-08-12T14:22:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-08-12T14:22:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009378 post PendingInvicesDO 2 NIM-031009520 post PendingInvicesDO 2 NIM-031009519 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 NIM-034009377 post PendingInvicesDO 2 NIM-031009520 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : NIM-031009519 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009520 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f380e049-986f-4eda-b3c4-aebbdb721b28' LIMIT 1 Date : 2025-08-12T14:40:32  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a9b43dbf-05bc-4884-920a-3e5918777050' LIMIT 1 Date : 2025-08-12T14:40:32  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f380e049-986f-4eda-b3c4-aebbdb721b28' LIMIT 1 Date : 2025-08-12T14:40:32  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a9b43dbf-05bc-4884-920a-3e5918777050' LIMIT 1 Date : 2025-08-12T14:40:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-08-12T14:40:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009379 post PendingInvicesDO 2 NIM-031009484 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009484 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 = 'NIM-031009484' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009484' OR OrderId='NIM-031009484' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-12T15:27:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009380 post PendingInvicesDO 2 NIM-031009318 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009318 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 = 'NIM-031009318' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009318' OR OrderId='NIM-031009318' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-12T15:28:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009381 post PendingInvicesDO 2 NIM-031009422 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009422 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 = 'NIM-031009422' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009422' OR OrderId='NIM-031009422' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-12T15:28:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 NIM-034009382 post PendingInvicesDO 2 NIM-031009479 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : NIM-031009479 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 = 'NIM-031009479' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='NIM-031009479' OR OrderId='NIM-031009479' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-08-12T16:51:44 payment end 
