 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000581 post PendingInvicesDO 2 RUH-411000833 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000833 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eb51a735-0f12-4366-9d6d-efd9db858563' LIMIT 1 Date : 2025-03-02T10:29:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-02T10:29:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000582 post PendingInvicesDO 2 RUH-411000840 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000840 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='63f5452e-143e-4d10-8422-7ed2f3df988f' LIMIT 1 Date : 2025-03-04T11:59:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T11:59:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000583 post PendingInvicesDO 2 RUH-411000841 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000841 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a0c8318a-18f7-44d7-a361-5b26e9d4d84c' LIMIT 1 Date : 2025-03-04T13:13:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T13:13:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000584 post PendingInvicesDO 2 RUH-411000843 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000843 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='785639cd-c489-4fe6-9de6-69eaaaeaa1f0' LIMIT 1 Date : 2025-03-05T10:41:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T10:41:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000585 post PendingInvicesDO 2 RUH-411000845 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000845 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d74df115-a558-4c0e-853c-ec4833507e12' LIMIT 1 Date : 2025-03-05T12:27:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T12:27:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000586 post PendingInvicesDO 2 RUH-411000846 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000846 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bd201303-d2a9-4072-a48f-baa5ebdab8ae' LIMIT 1 Date : 2025-03-05T12:52:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T12:52:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000587 post PendingInvicesDO 2 RUH-411000848 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000848 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3adcee9d-1898-4209-89a1-d8a5a264a533' LIMIT 1 Date : 2025-03-06T11:25:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T11:25:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000588 post PendingInvicesDO 2 RUH-411000849 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000849 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='abe2ca32-e533-4141-bb88-891cd4981adf' LIMIT 1 Date : 2025-03-06T13:09:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T13:09:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000589 post PendingInvicesDO 2 RUH-411000850 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000850 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='27e5bb34-9f32-48ef-bce0-68268bc6a4d1' LIMIT 1 Date : 2025-03-06T14:19:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T14:19:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000590 post PendingInvicesDO 2 RUH-411000851 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000851 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2413f29a-05ce-4b0f-b267-c0aa9ec80e55' LIMIT 1 Date : 2025-03-06T14:44:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T14:44:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000591 post PendingInvicesDO 2 RUH-411000852 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000852 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7b886a67-a947-4f28-9530-62bae755eb7e' LIMIT 1 Date : 2025-03-06T15:12:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T15:12:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000592 post PendingInvicesDO 2 RUH-411000853 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000853 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='18eb424c-962e-4617-81fb-b1365c2898ed' LIMIT 1 Date : 2025-03-06T15:22:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T15:22:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000593 post PendingInvicesDO 2 RUH-411000854 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000854 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='35fd83b7-8a88-4216-b443-c097c30790b0' LIMIT 1 Date : 2025-03-06T16:47:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-06T16:47:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000594 post PendingInvicesDO 2 RUH-411000856 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000856 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='732faa23-716d-4952-a2e6-0eaf2eabe89e' LIMIT 1 Date : 2025-03-08T10:03:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T10:03:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000595 post PendingInvicesDO 2 RUH-411000858 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000858 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f328e999-41de-4a13-82b6-05a58e6eeef5' LIMIT 1 Date : 2025-03-08T12:43:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T12:43:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000596 post PendingInvicesDO 2 RUH-411000862 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000862 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='68168537-005f-4680-904f-961737afc5cd' LIMIT 1 Date : 2025-03-09T13:46:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-09T13:46:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000597 post PendingInvicesDO 2 RUH-411000863 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000863 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='66bd1f9c-58c2-4cc7-8d20-0f3fa1bd685a' LIMIT 1 Date : 2025-03-09T14:22:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-09T14:22:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000598 post PendingInvicesDO 2 RUH-411000864 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000864 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e80197e1-3bca-4e39-b3ff-8f4bcc2e774c' LIMIT 1 Date : 2025-03-09T14:46:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-09T14:46:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000599 post PendingInvicesDO 2 RUH-411000865 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000865 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f49eaeef-277e-47a5-a213-3ed3c54b2331' LIMIT 1 Date : 2025-03-09T15:12:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-09T15:12:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000600 post PendingInvicesDO 2 RUH-411000870 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000870 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7b37cf4a-73cf-42d2-ab18-95edc3135a4e' LIMIT 1 Date : 2025-03-10T12:51:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-10T12:51:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000601 post PendingInvicesDO 2 RUH-411000871 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000871 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='78872aeb-dab5-47e4-b18f-a3ceeb2c86f8' LIMIT 1 Date : 2025-03-10T13:44:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-10T13:44:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000602 post PendingInvicesDO 2 RUH-411000872 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000872 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1063b7dc-5dd8-4d84-85b5-9534c9c74cfd' LIMIT 1 Date : 2025-03-10T14:20:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-10T14:20:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000603 post PendingInvicesDO 2 RUH-411000876 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000876 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='82b43d03-a6de-4f27-868b-1dc6eedcad64' LIMIT 1 Date : 2025-03-11T11:59:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T11:59:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000604 post PendingInvicesDO 2 RUH-411000877 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000877 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d2d859b3-1ac9-4f09-9e49-a39651af3584' LIMIT 1 Date : 2025-03-11T12:19:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T12:19:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000605 post PendingInvicesDO 2 RUH-411000878 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000878 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='de807a0f-5533-410f-bee9-c7bee584e0eb' LIMIT 1 Date : 2025-03-12T09:45:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T09:45:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000606 post PendingInvicesDO 2 RUH-411000842 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000842 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 = 'RUH-411000842' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='RUH-411000842' OR OrderId='RUH-411000842' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-12T10:12:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000607 post PendingInvicesDO 2 RUH-411000879 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000879 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c3f07a6e-1f48-45a4-93be-43a3f1e0d008' LIMIT 1 Date : 2025-03-12T10:42:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T10:42:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000608 post PendingInvicesDO 2 RUH-411000880 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000880 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fae04941-0d6e-401e-9769-6faa639508db' LIMIT 1 Date : 2025-03-12T10:54:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T10:54:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000609 post PendingInvicesDO 2 RUH-411000881 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000881 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='738b61b0-2927-40b2-91f6-0d1f26307c75' LIMIT 1 Date : 2025-03-12T11:11:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T11:11:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000610 post PendingInvicesDO 2 RUH-411000883 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000883 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9523e920-dfef-4846-85c1-3977fa2ccc33' LIMIT 1 Date : 2025-03-12T13:19:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T13:19:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000611 post PendingInvicesDO 2 RUH-411000884 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000884 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='57483eef-9485-4cdc-8203-b5f47eb368fe' LIMIT 1 Date : 2025-03-12T14:14:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T14:14:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000613 post PendingInvicesDO 2 RUH-411000887 post PendingInvicesDO 2 RUH-411000886 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 RUH-414000612 post PendingInvicesDO 2 RUH-411000887 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : RUH-411000886 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000887 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fce44bfc-2d82-4ca8-b68f-146232c20ba4' LIMIT 1 Date : 2025-03-13T10:07:00  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e817df54-5fe5-46cf-a4c2-3d1b4863caca' LIMIT 1 Date : 2025-03-13T10:07:00  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fce44bfc-2d82-4ca8-b68f-146232c20ba4' LIMIT 1 Date : 2025-03-13T10:07:00  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e817df54-5fe5-46cf-a4c2-3d1b4863caca' LIMIT 1 Date : 2025-03-13T10:07:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-03-13T10:07:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000614 post PendingInvicesDO 2 RUH-411000889 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000889 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='57c43228-8617-4ac9-8631-dbda6ee20c20' LIMIT 1 Date : 2025-03-13T11:48:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-13T11:48:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000615 post PendingInvicesDO 2 RUH-411000890 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000890 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9dfbc901-d5f4-4b01-bbac-d16bd3986265' LIMIT 1 Date : 2025-03-13T13:00:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-13T13:00:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000616 post PendingInvicesDO 2 RUH-411000892 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000892 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ec8f079b-6e3e-4980-a8f9-76c95e090793' LIMIT 1 Date : 2025-03-13T14:20:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-13T14:20:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000617 post PendingInvicesDO 2 RUH-411000893 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000893 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6175829a-4d43-4218-88fc-519044e4283b' LIMIT 1 Date : 2025-03-13T16:00:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-13T16:00:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000618 post PendingInvicesDO 2 RUH-411000829 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000829 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 = 'RUH-411000829' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='RUH-411000829' OR OrderId='RUH-411000829' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-13T16:31:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000619 post PendingInvicesDO 2 RUH-411000896 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000896 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 = 'RUH-411000896' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='RUH-411000896' OR OrderId='RUH-411000896' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-15T19:13:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000620 post PendingInvicesDO 2 RUH-411000818 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000818 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 = 'RUH-411000818' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='RUH-411000818' OR OrderId='RUH-411000818' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-16T12:41:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000621 post PendingInvicesDO 2 RUH-411000901 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000901 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b327e5fa-33bc-4076-858b-269999086d76' LIMIT 1 Date : 2025-03-16T14:16:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T14:16:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000622 post PendingInvicesDO 2 RUH-411000902 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000902 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e3ce007c-85b5-48ca-92b1-419187f05486' LIMIT 1 Date : 2025-03-16T14:42:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T14:42:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000623 post PendingInvicesDO 2 RUH-411000903 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000903 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4fda21ed-4dcb-4a80-afb3-ece276471c01' LIMIT 1 Date : 2025-03-16T15:03:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T15:03:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000625 post PendingInvicesDO 2 RUH-411000905 post PendingInvicesDO 2 RUH-411000904 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 RUH-414000624 post PendingInvicesDO 2 RUH-411000905 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : RUH-411000904 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000905 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='de86fff1-efeb-4f1f-8ee0-f23d81edcf92' LIMIT 1 Date : 2025-03-16T15:30:13  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='47228316-3652-4a2f-8540-1ae696516955' LIMIT 1 Date : 2025-03-16T15:30:13  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='de86fff1-efeb-4f1f-8ee0-f23d81edcf92' LIMIT 1 Date : 2025-03-16T15:30:13  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='47228316-3652-4a2f-8540-1ae696516955' LIMIT 1 Date : 2025-03-16T15:30:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-03-16T15:30:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000626 post PendingInvicesDO 2 RUH-411000906 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000906 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='129b42f5-4c92-4f46-add7-cc50432f1781' LIMIT 1 Date : 2025-03-16T16:46:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T16:46:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000627 post PendingInvicesDO 2 RUH-411000907 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000907 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='03813b6f-0beb-46b1-b8d2-ff364bb0dc20' LIMIT 1 Date : 2025-03-16T16:58:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T16:58:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000628 post PendingInvicesDO 2 RUH-411000909 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000909 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c8a00b0d-acbf-490e-8943-c837b8cdb75c' LIMIT 1 Date : 2025-03-16T18:26:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T18:26:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000629 post PendingInvicesDO 2 RUH-411000910 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000910 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2db69e77-f9d3-44a3-b4e0-80e96af04bec' LIMIT 1 Date : 2025-03-16T18:56:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T18:56:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 RUH-414000630 post PendingInvicesDO 2 RUH-411000911 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : RUH-411000911 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9acb76e9-530b-44ae-b9e6-f588f650d882' LIMIT 1 Date : 2025-03-16T20:05:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-16T20:05:31 payment end 
