 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000790 post PendingInvicesDO 2 KHM-131000805 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000805 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f603d3ac-e61d-4fca-91b6-c72eecf4e311' LIMIT 1 Date : 2025-02-06T13:23:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-06T13:23:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000791 post PendingInvicesDO 2 KHM-131000806 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000806 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d6660d3c-d191-4f3a-8cc3-d9c76a95c6eb' LIMIT 1 Date : 2025-02-06T16:24:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-06T16:24:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000792 post PendingInvicesDO 2 KHM-131000807 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000807 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b169505c-9f52-42f9-9435-69d4035fc981' LIMIT 1 Date : 2025-02-06T16:53:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-06T16:53:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000793 post PendingInvicesDO 2 KHM-131000808 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000808 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c5d37d76-5405-4640-9d80-91e4cf1c0f5b' LIMIT 1 Date : 2025-02-08T10:13:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T10:13:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000794 post PendingInvicesDO 2 KHM-131000809 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000809 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9a9f09db-3998-4197-a762-c56fe7a7bd8a' LIMIT 1 Date : 2025-02-08T10:19:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T10:19:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000795 post PendingInvicesDO 2 KHM-131000810 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000810 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c66892bf-0276-4d09-ab0a-f4e6ca56c376' LIMIT 1 Date : 2025-02-08T10:36:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T10:36:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000796 post PendingInvicesDO 2 KHM-131000811 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000811 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8bde7efc-4fa9-424d-bf8a-48fa46619eb6' LIMIT 1 Date : 2025-02-08T10:52:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T10:52:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000797 post PendingInvicesDO 2 KHM-131000812 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000812 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='695666d0-5aa3-4010-9528-9003b4d341a2' LIMIT 1 Date : 2025-02-08T11:26:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T11:26:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000798 post PendingInvicesDO 2 KHM-131000813 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000813 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8b56308d-f115-4bce-b229-19674884a68f' LIMIT 1 Date : 2025-02-08T11:53:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T11:53:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000799 post PendingInvicesDO 2 KHM-131000814 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000814 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='86c48c10-033c-4a79-9b10-2fe73be2174b' LIMIT 1 Date : 2025-02-08T13:18:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T13:18:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000800 post PendingInvicesDO 2 KHM-131000815 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000815 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ec646f32-1ec7-484a-9ec4-4565a6f60248' LIMIT 1 Date : 2025-02-08T13:54:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T13:54:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000801 post PendingInvicesDO 2 KHM-131000816 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000816 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f2569f41-59dc-41a2-a68a-cec79b4dcdec' LIMIT 1 Date : 2025-02-08T17:51:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-08T17:51:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000802 post PendingInvicesDO 2 KHM-131000817 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000817 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0651a825-c13d-4e82-bfc5-84a932662433' LIMIT 1 Date : 2025-02-09T11:02:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T11:02:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000803 post PendingInvicesDO 2 KHM-131000818 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000818 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='29f5cffb-b39f-4e3d-ab01-734bb737fc89' LIMIT 1 Date : 2025-02-09T12:03:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T12:03:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000804 post PendingInvicesDO 2 KHM-131000819 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000819 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='03b0426a-5e05-4e79-8bf7-2233d57620c3' LIMIT 1 Date : 2025-02-09T12:29:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T12:29:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000805 post PendingInvicesDO 2 KHM-131000820 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000820 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='06613d6c-f7b5-4ede-9ed5-ca3c23dce267' LIMIT 1 Date : 2025-02-09T13:27:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T13:27:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000806 post PendingInvicesDO 2 KHM-131000821 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000821 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d14b939e-32c9-41d2-acd5-3005aee5bd05' LIMIT 1 Date : 2025-02-09T13:44:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T13:44:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000807 post PendingInvicesDO 2 KHM-131000822 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000822 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4058b0fd-f6e3-4172-8319-eaccc6789e34' LIMIT 1 Date : 2025-02-09T13:57:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T13:57:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000808 post PendingInvicesDO 2 KHM-131000823 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000823 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ba37e7bb-3b0d-405a-ba93-7f9e789d7ab3' LIMIT 1 Date : 2025-02-09T14:44:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T14:44:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000809 post PendingInvicesDO 2 KHM-131000824 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000824 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='50ccec79-ccf9-41d3-baf8-f472362093bd' LIMIT 1 Date : 2025-02-09T15:59:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T15:59:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000810 post PendingInvicesDO 2 KHM-131000825 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000825 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d5300921-9abf-4ae0-9aa5-da3ca52caf83' LIMIT 1 Date : 2025-02-09T18:57:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T18:57:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000811 post PendingInvicesDO 2 KHM-131000826 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000826 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='100fc7a8-e3ab-4cf5-86a0-896f98122d57' LIMIT 1 Date : 2025-02-09T19:04:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-09T19:04:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000812 post PendingInvicesDO 2 KHM-131000827 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000827 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='20cb162b-91a7-4214-83d6-b2cc2ee0ccc4' LIMIT 1 Date : 2025-02-10T10:04:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-10T10:04:42 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 KHM-134000813 post PendingInvicesDO 2 KHM-131000828 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000828 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='71042dd1-6e25-457d-942b-6bde244dfb7e' LIMIT 1 Date : 2025-02-10T10:19:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-10T10:19:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000814 post PendingInvicesDO 2 KHM-131000830 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000830 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f74ba09c-1437-4dc7-8060-4e6042109955' LIMIT 1 Date : 2025-02-10T11:20:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-10T11:20:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000815 post PendingInvicesDO 2 KHM-131000831 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000831 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='82ac7768-daef-413e-b12f-aeea7ae6f4ce' LIMIT 1 Date : 2025-02-10T11:37:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-10T11:37:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000816 post PendingInvicesDO 2 KHM-131000832 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000832 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4c740f45-813a-4572-8602-70561a9f625b' LIMIT 1 Date : 2025-02-10T11:56:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-10T11:56:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000817 post PendingInvicesDO 2 KHM-131000833 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000833 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4960bfcd-677f-4b84-8fa7-bfe2e8cd1c5c' LIMIT 1 Date : 2025-02-10T12:27:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-10T12:27:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000818 post PendingInvicesDO 2 KHM-131000835 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000835 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6833b6b1-bbfa-46cb-85da-0bfff54a83ef' LIMIT 1 Date : 2025-02-11T10:43:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-11T10:43:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000819 post PendingInvicesDO 2 KHM-131000836 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000836 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='76f80ed7-d1b9-471d-9703-079c4ceb534a' LIMIT 1 Date : 2025-02-11T11:12:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-11T11:12:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000820 post PendingInvicesDO 2 KHM-131000837 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000837 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1b5c01a9-e760-4368-af89-76fb1fd7b322' LIMIT 1 Date : 2025-02-11T11:40:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-11T11:40:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000821 post PendingInvicesDO 2 KHM-131000838 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000838 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9d3be3fa-a807-4dab-86c8-0e98b571df77' LIMIT 1 Date : 2025-02-11T12:03:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-11T12:03:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000822 post PendingInvicesDO 2 KHM-131000839 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000839 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a4dcca17-5767-41a9-beba-835b3643c54b' LIMIT 1 Date : 2025-02-11T12:47:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-11T12:47:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000824 post PendingInvicesDO 2 KHM-131000841 post PendingInvicesDO 2 KHM-131000840 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000823 post PendingInvicesDO 2 KHM-131000841 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000840 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000841 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='95c186f1-cb3f-4230-b376-be10ef90ab93' LIMIT 1 Date : 2025-02-11T13:29:23  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3a9bb1e0-96b2-492d-a6ae-f027046295d7' LIMIT 1 Date : 2025-02-11T13:29:23  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='95c186f1-cb3f-4230-b376-be10ef90ab93' LIMIT 1 Date : 2025-02-11T13:29:23  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3a9bb1e0-96b2-492d-a6ae-f027046295d7' LIMIT 1 Date : 2025-02-11T13:29:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-02-11T13:29:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000826 post PendingInvicesDO 2 KHM-131000843 post PendingInvicesDO 2 KHM-131000842 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000825 post PendingInvicesDO 2 KHM-131000843 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000842 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000843 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1b690392-eec2-44e3-b148-1c2481d2bcfd' LIMIT 1 Date : 2025-02-11T13:58:20  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f31a5a13-ece0-4da1-b42f-830a2eadc721' LIMIT 1 Date : 2025-02-11T13:58:20  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1b690392-eec2-44e3-b148-1c2481d2bcfd' LIMIT 1 Date : 2025-02-11T13:58:20  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f31a5a13-ece0-4da1-b42f-830a2eadc721' LIMIT 1 Date : 2025-02-11T13:58:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-02-11T13:58:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000827 post PendingInvicesDO 2 KHM-131000844 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000844 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6777d87f-c6a5-4cff-9f8f-317e4902fab8' LIMIT 1 Date : 2025-02-11T15:12:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-11T15:12:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000828 post PendingInvicesDO 2 KHM-131000845 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000845 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e14dafeb-e934-4441-9db2-515331b597ec' LIMIT 1 Date : 2025-02-12T11:24:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-12T11:24:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000829 post PendingInvicesDO 2 KHM-131000846 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000846 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='faef9497-33b1-4535-9058-fa4b7086d753' LIMIT 1 Date : 2025-02-12T11:47:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-12T11:47:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000830 post PendingInvicesDO 2 KHM-131000848 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000848 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='22422d11-6645-450b-a284-7bfc1aacd522' LIMIT 1 Date : 2025-02-12T12:58:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-12T12:58:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000832 post PendingInvicesDO 2 KHM-131000850 post PendingInvicesDO 2 KHM-131000849 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000831 post PendingInvicesDO 2 KHM-131000850 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000849 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000850 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='181f220f-41f7-40f6-939e-b56f9a5e53e9' LIMIT 1 Date : 2025-02-12T13:26:53  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a252a055-91ba-4614-93c3-6a2f022d452c' LIMIT 1 Date : 2025-02-12T13:26:53  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='181f220f-41f7-40f6-939e-b56f9a5e53e9' LIMIT 1 Date : 2025-02-12T13:26:53  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a252a055-91ba-4614-93c3-6a2f022d452c' LIMIT 1 Date : 2025-02-12T13:26:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-02-12T13:26:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000833 post PendingInvicesDO 2 KHM-131000851 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000851 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='20b8486e-4cc8-4f3c-aaf8-377dd758f572' LIMIT 1 Date : 2025-02-12T13:57:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-12T13:57:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000834 post PendingInvicesDO 2 KHM-131000852 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000852 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9e2b5bef-14a3-43df-a053-a6dc60da2d9b' LIMIT 1 Date : 2025-02-12T14:40:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-12T14:40:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000835 post PendingInvicesDO 2 KHM-131000746 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000746 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 = 'KHM-131000746' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000746' OR OrderId='KHM-131000746' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-02-13T11:41:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000836 post PendingInvicesDO 2 KHM-131000854 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000854 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fdfcf28c-339a-480e-a106-55b81e51ed15' LIMIT 1 Date : 2025-02-13T13:21:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-13T13:21:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000837 post PendingInvicesDO 2 KHM-131000858 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000858 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f5a8a256-ad98-4a21-bfe8-bb048e319f55' LIMIT 1 Date : 2025-02-15T14:00:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-15T14:00:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000838 post PendingInvicesDO 2 KHM-131000761 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000761 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 = 'KHM-131000761' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000761' OR OrderId='KHM-131000761' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-02-15T17:13:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000839 post PendingInvicesDO 2 KHM-131000860 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000860 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5432776e-0e08-46e4-8bf0-04d672d7fa36' LIMIT 1 Date : 2025-02-15T17:31:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-15T17:31:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000840 post PendingInvicesDO 2 KHM-131000861 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000861 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='07b151cb-de74-4475-8d50-7d88823f3512' LIMIT 1 Date : 2025-02-15T18:38:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-15T18:38:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000841 post PendingInvicesDO 2 KHM-131000862 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000862 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='49b35720-3beb-48a6-bdc4-2a33607cda71' LIMIT 1 Date : 2025-02-16T12:18:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T12:18:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000842 post PendingInvicesDO 2 KHM-131000863 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000863 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='20ff647b-06c7-4718-83fc-1a95c5c7717e' LIMIT 1 Date : 2025-02-16T12:36:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T12:36:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000843 post PendingInvicesDO 2 KHM-131000864 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000864 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b576a63c-a88d-4c9d-9cf3-1111f244b8c1' LIMIT 1 Date : 2025-02-16T12:46:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T12:46:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000844 post PendingInvicesDO 2 KHM-131000865 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000865 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d6e71bb8-797a-4140-8fe3-84f5ac151fcc' LIMIT 1 Date : 2025-02-16T13:05:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T13:05:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000845 post PendingInvicesDO 2 KHM-131000866 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000866 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eae57f32-dbc2-4dda-a2ae-5ec688369992' LIMIT 1 Date : 2025-02-16T13:20:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T13:20:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000846 post PendingInvicesDO 2 KHM-131000867 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000867 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='12b6d1a2-909c-4026-922f-28f18af4201e' LIMIT 1 Date : 2025-02-16T13:32:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T13:32:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000847 post PendingInvicesDO 2 KHM-131000747 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000747 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 = 'KHM-131000747' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000747' OR OrderId='KHM-131000747' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-02-16T13:57:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000848 post PendingInvicesDO 2 KHM-131000869 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000869 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f2616119-9c88-4902-b6ac-2c9f1c2660e4' LIMIT 1 Date : 2025-02-16T14:43:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T14:43:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000849 post PendingInvicesDO 2 KHM-131000870 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000870 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d3413c2f-f48c-450d-9798-59aabb6b6d77' LIMIT 1 Date : 2025-02-16T15:35:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-16T15:35:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000850 post PendingInvicesDO 2 KHM-131000871 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000871 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='42d4fb33-e94b-470f-965a-037d95fef16c' LIMIT 1 Date : 2025-02-17T09:25:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-17T09:25:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000851 post PendingInvicesDO 2 KHM-131000872 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000872 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='57ae7f4b-1893-48bf-80e9-c6bce7fd71b5' LIMIT 1 Date : 2025-02-17T10:16:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-17T10:16:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000852 post PendingInvicesDO 2 KHM-131000873 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000873 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='10c99c35-1892-4e8c-94e4-f88beb2704b9' LIMIT 1 Date : 2025-02-18T12:43:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-18T12:43:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000853 post PendingInvicesDO 2 KHM-131000874 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000874 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='42442418-b5cb-4e4d-9723-99d1e73a1db4' LIMIT 1 Date : 2025-02-18T16:28:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-18T16:28:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000854 post PendingInvicesDO 2 KHM-131000875 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000875 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c79c4996-96ce-459e-bf17-1a705f0a20f4' LIMIT 1 Date : 2025-02-18T16:46:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-18T16:46:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000855 post PendingInvicesDO 2 KHM-131000876 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000876 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bf26efba-69ed-449b-88d3-db2ddab1296d' LIMIT 1 Date : 2025-02-18T17:04:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-18T17:04:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000857 post PendingInvicesDO 2 KHM-131000878 post PendingInvicesDO 2 KHM-131000877 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000856 post PendingInvicesDO 2 KHM-131000878 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000877 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000878 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3cf41aef-c0af-4de6-8931-9202f2598165' LIMIT 1 Date : 2025-02-19T11:42:45  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a171d7e4-fbf4-40fd-9f9b-2a6687ae1175' LIMIT 1 Date : 2025-02-19T11:42:45  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3cf41aef-c0af-4de6-8931-9202f2598165' LIMIT 1 Date : 2025-02-19T11:42:45  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a171d7e4-fbf4-40fd-9f9b-2a6687ae1175' LIMIT 1 Date : 2025-02-19T11:42:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-02-19T11:42:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000858 post PendingInvicesDO 2 KHM-131000879 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000879 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1560e7f8-11b7-41ef-a740-4a1ee6f9cedc' LIMIT 1 Date : 2025-02-19T12:16:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-19T12:16:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000859 post PendingInvicesDO 2 KHM-131000880 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000880 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='71059f49-0628-46e0-81f7-7cde32aa03bb' LIMIT 1 Date : 2025-02-19T13:10:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-19T13:10:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000860 post PendingInvicesDO 2 KHM-131000881 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000881 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3204e24d-3ef8-4829-8dc2-68fcabd2331b' LIMIT 1 Date : 2025-02-19T13:39:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-19T13:39:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000861 post PendingInvicesDO 2 KHM-131000882 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000882 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d6bb68c7-dff2-4e2c-817a-b3454dcbc75f' LIMIT 1 Date : 2025-02-19T14:37:40   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-19T14:37:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000862 post PendingInvicesDO 2 KHM-131000883 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000883 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d892805a-1ab9-44cf-8bf7-ce4cb56635fd' LIMIT 1 Date : 2025-02-19T16:31:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-19T16:31:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000863 post PendingInvicesDO 2 KHM-131000884 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000884 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='abfcf601-07d9-4a9b-b1bd-8678ad3e5bc9' LIMIT 1 Date : 2025-02-19T17:38:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-19T17:38:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000864 post PendingInvicesDO 2 KHM-131000829 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000829 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 = 'KHM-131000829' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000829' OR OrderId='KHM-131000829' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-02-20T11:27:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000865 post PendingInvicesDO 2 KHM-131000885 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000885 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cad3219e-e744-4ef8-aec3-cd258b8df53d' LIMIT 1 Date : 2025-02-22T09:14:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T09:14:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000866 post PendingInvicesDO 2 KHM-131000886 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000886 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ad3a4500-1c32-4065-88d5-afc714863927' LIMIT 1 Date : 2025-02-22T09:38:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T09:38:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000867 post PendingInvicesDO 2 KHM-131000887 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000887 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6a17ed1e-baf8-4ae8-a58e-0ab9929b7142' LIMIT 1 Date : 2025-02-22T10:00:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T10:00:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000868 post PendingInvicesDO 2 KHM-131000888 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000888 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b64e89ee-82d8-4a8d-8940-98b738409e13' LIMIT 1 Date : 2025-02-22T10:44:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T10:44:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000869 post PendingInvicesDO 2 KHM-131000889 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000889 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c0f8c6a1-7421-4d0d-8a57-327bb0808ed4' LIMIT 1 Date : 2025-02-22T11:24:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T11:24:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000870 post PendingInvicesDO 2 KHM-131000892 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000892 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b0a3c8ce-0072-4f18-8601-d50f9aa4b594' LIMIT 1 Date : 2025-02-22T13:38:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T13:38:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000871 post PendingInvicesDO 2 KHM-131000893 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000893 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9fe59b1e-aafa-46f7-b25a-3a6fa9f7f0ba' LIMIT 1 Date : 2025-02-22T13:55:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T13:55:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000872 post PendingInvicesDO 2 KHM-131000894 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000894 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='84bf1b12-afce-4384-bf4e-cab567473f18' LIMIT 1 Date : 2025-02-22T14:21:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T14:21:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000873 post PendingInvicesDO 2 KHM-131000895 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000895 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='26484735-09cb-4a1e-be1a-53b9f2dae9c2' LIMIT 1 Date : 2025-02-22T14:47:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T14:47:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000874 post PendingInvicesDO 2 KHM-131000896 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000896 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5dac5e90-315d-4ae4-8107-c466300628da' LIMIT 1 Date : 2025-02-22T15:24:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T15:24:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000875 post PendingInvicesDO 2 KHM-131000898 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000898 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='63702492-fc8e-4296-ac67-b229adefef8c' LIMIT 1 Date : 2025-02-22T16:34:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-22T16:34:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000876 post PendingInvicesDO 2 KHM-131000899 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000899 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3672fce0-ad79-4030-aee4-582c2cd92542' LIMIT 1 Date : 2025-02-23T11:35:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T11:35:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000877 post PendingInvicesDO 2 KHM-131000900 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000900 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5949f65f-99ca-482d-86cc-3a4aadf966e7' LIMIT 1 Date : 2025-02-23T12:28:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T12:28:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000878 post PendingInvicesDO 2 KHM-131000901 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000901 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='45c3776a-20bc-41c2-b949-f3672e80fe35' LIMIT 1 Date : 2025-02-23T12:55:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T12:55:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000879 post PendingInvicesDO 2 KHM-131000902 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000902 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f6a072e5-111e-4385-acd0-1a2d3a932ae9' LIMIT 1 Date : 2025-02-23T13:13:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T13:13:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000880 post PendingInvicesDO 2 KHM-131000903 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000903 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1d47a09d-054f-44c1-8f62-ca64b7f19d96' LIMIT 1 Date : 2025-02-23T13:36:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T13:36:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000881 post PendingInvicesDO 2 KHM-131000904 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000904 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='16ba6b1a-f800-4adc-bea6-a69a5f77979f' LIMIT 1 Date : 2025-02-23T13:40:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T13:40:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000882 post PendingInvicesDO 2 KHM-131000905 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000905 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cc40d1ae-2bd4-4f10-a134-ac1c004e4289' LIMIT 1 Date : 2025-02-23T13:51:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T13:51:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000883 post PendingInvicesDO 2 KHM-131000906 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000906 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e18ac862-78c6-4de2-9653-de5684e5da0d' LIMIT 1 Date : 2025-02-23T14:04:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T14:04:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000884 post PendingInvicesDO 2 KHM-131000907 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000907 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1f28c69b-5e7c-4cc7-a1f7-4f66e41ceb03' LIMIT 1 Date : 2025-02-23T14:20:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T14:20:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000885 post PendingInvicesDO 2 KHM-131000908 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000908 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c541683d-60b3-47d1-bb92-252cf107955b' LIMIT 1 Date : 2025-02-23T15:00:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-23T15:00:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000886 post PendingInvicesDO 2 KHM-131000909 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000909 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f9c77ff7-94ef-4115-904a-f55e7ad8e730' LIMIT 1 Date : 2025-02-24T09:21:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-24T09:21:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000887 post PendingInvicesDO 2 KHM-131000910 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000910 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6a1967de-e11a-40d1-824f-878ff4f15ec4' LIMIT 1 Date : 2025-02-24T09:34:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-24T09:34:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000888 post PendingInvicesDO 2 KHM-131000911 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000911 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e235c461-7f7d-453b-8209-090f310bfa22' LIMIT 1 Date : 2025-02-24T09:47:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-24T09:47:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000889 post PendingInvicesDO 2 KHM-131000912 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000912 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ab040670-5a65-425d-be37-6ba69ff0eaf7' LIMIT 1 Date : 2025-02-24T10:22:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-24T10:22:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000890 post PendingInvicesDO 2 KHM-131000916 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000916 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9a6f83c5-792e-4739-8e40-2dce72131b96' LIMIT 1 Date : 2025-02-25T07:56:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-25T07:56:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000891 post PendingInvicesDO 2 KHM-131000917 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000917 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5b3278e1-ff14-4212-bf28-88126ac92672' LIMIT 1 Date : 2025-02-25T10:46:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-25T10:46:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000892 post PendingInvicesDO 2 KHM-131000920 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000920 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='31a338fd-69b1-47a4-a9de-b08af9e3eeb9' LIMIT 1 Date : 2025-02-25T12:43:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-25T12:43:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000893 post PendingInvicesDO 2 KHM-131000921 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000921 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e5b3ddae-e466-4152-8e99-5f1bdbdde7a3' LIMIT 1 Date : 2025-02-25T13:35:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-25T13:35:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000894 post PendingInvicesDO 2 KHM-131000922 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000922 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7584b1a8-6e18-426e-b873-6074add7da35' LIMIT 1 Date : 2025-02-25T14:16:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-25T14:16:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000896 post PendingInvicesDO 2 KHM-131000924 post PendingInvicesDO 2 KHM-131000923 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000895 post PendingInvicesDO 2 KHM-131000924 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000923 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000924 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e16e84b5-6e43-4327-8e19-5d2a65b7e80e' LIMIT 1 Date : 2025-02-25T16:57:41  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bb2ece06-a332-4942-887b-7dc468f5456d' LIMIT 1 Date : 2025-02-25T16:57:41  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e16e84b5-6e43-4327-8e19-5d2a65b7e80e' LIMIT 1 Date : 2025-02-25T16:57:41  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bb2ece06-a332-4942-887b-7dc468f5456d' LIMIT 1 Date : 2025-02-25T16:57:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-02-25T16:57:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000897 post PendingInvicesDO 2 KHM-131000925 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000925 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='57814c0e-750d-4c66-bd60-4c8eb1a854b6' LIMIT 1 Date : 2025-02-26T11:24:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-26T11:24:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000898 post PendingInvicesDO 2 KHM-131000926 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000926 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='88384561-3c00-4a1d-aaaa-a4170e2cf9d9' LIMIT 1 Date : 2025-02-26T11:57:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-26T11:57:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000899 post PendingInvicesDO 2 KHM-131000927 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000927 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='872b51ae-9f92-445f-b62c-fd85ce9f4d9b' LIMIT 1 Date : 2025-02-26T13:58:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-26T13:58:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000901 post PendingInvicesDO 2 KHM-131000929 post PendingInvicesDO 2 KHM-131000928 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000900 post PendingInvicesDO 2 KHM-131000929 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000928 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000929 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='63618881-5098-4abd-b90b-0ed2e5ee0a15' LIMIT 1 Date : 2025-02-26T14:31:00  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e70f7b80-4ed8-45af-89f9-a7bd5223be17' LIMIT 1 Date : 2025-02-26T14:31:01  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='63618881-5098-4abd-b90b-0ed2e5ee0a15' LIMIT 1 Date : 2025-02-26T14:31:01  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e70f7b80-4ed8-45af-89f9-a7bd5223be17' LIMIT 1 Date : 2025-02-26T14:31:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-02-26T14:31:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000902 post PendingInvicesDO 2 KHM-131000930 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000930 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eedc485b-16ec-4232-8c5f-9796903ec18f' LIMIT 1 Date : 2025-02-26T15:13:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-02-26T15:13:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000903 post PendingInvicesDO 2 KHM-131000771 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000771 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 = 'KHM-131000771' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000771' OR OrderId='KHM-131000771' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-02-27T11:27:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000904 post PendingInvicesDO 2 KHM-131000932 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000932 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f2a27760-29ca-4c18-b304-b746bd75c8fe' LIMIT 1 Date : 2025-03-01T13:58:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-01T13:58:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000905 post PendingInvicesDO 2 KHM-131000933 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000933 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='49e0a759-7009-4740-87da-8a7c1fd7608f' LIMIT 1 Date : 2025-03-01T14:23:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-01T14:23:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000906 post PendingInvicesDO 2 KHM-131000934 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000934 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4357a130-dbfb-4d95-af69-bf25faafc080' LIMIT 1 Date : 2025-03-01T14:58:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-01T14:58:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000907 post PendingInvicesDO 2 KHM-131000935 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000935 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cba76086-5472-4181-9c63-37fd86daa3ce' LIMIT 1 Date : 2025-03-01T15:31:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-01T15:31:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000908 post PendingInvicesDO 2 KHM-131000936 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000936 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f61d941a-868c-4021-b573-3f8bdad8a315' LIMIT 1 Date : 2025-03-01T16:30:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-01T16:30:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000909 post PendingInvicesDO 2 KHM-131000853 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000853 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 = 'KHM-131000853' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000853' OR OrderId='KHM-131000853' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-01T21:54:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000910 post PendingInvicesDO 2 KHM-131000847 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000847 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 = 'KHM-131000847' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000847' OR OrderId='KHM-131000847' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-01T21:55:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000911 post PendingInvicesDO 2 KHM-131000937 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000937 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fa84a2c4-6bfb-4a38-a60b-a686b8d67836' LIMIT 1 Date : 2025-03-02T13:45:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-02T13:45:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000912 post PendingInvicesDO 2 KHM-131000938 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000938 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2a3e6aeb-ee7a-4417-987b-8a84e9a917a9' LIMIT 1 Date : 2025-03-02T14:16:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-02T14:16:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000913 post PendingInvicesDO 2 KHM-131000939 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000939 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e8f6f353-2cbe-4bdd-9f75-2a87875b3bc8' LIMIT 1 Date : 2025-03-02T14:41:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-02T14:41:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000914 post PendingInvicesDO 2 KHM-131000940 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000940 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9ad5aca3-db93-4754-b5e9-34b54e837b46' LIMIT 1 Date : 2025-03-02T15:10:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-02T15:10:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000915 post PendingInvicesDO 2 KHM-131000941 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000941 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='642f8c48-d9f7-4f89-99be-fabf0f5510ed' LIMIT 1 Date : 2025-03-02T15:34:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-02T15:34:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000916 post PendingInvicesDO 2 KHM-131000855 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000855 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 = 'KHM-131000855' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000855' OR OrderId='KHM-131000855' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-02T16:23:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000917 post PendingInvicesDO 2 KHM-131000913 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000913 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 = 'KHM-131000913' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='KHM-131000913' OR OrderId='KHM-131000913' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-02T20:45:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000918 post PendingInvicesDO 2 KHM-131000943 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000943 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='77fe0111-3b8d-4549-ad5d-b66665cc18ab' LIMIT 1 Date : 2025-03-03T13:30:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-03T13:30:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000919 post PendingInvicesDO 2 KHM-131000944 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000944 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3fba7b3d-4464-4928-bb04-de237aef4559' LIMIT 1 Date : 2025-03-03T15:21:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-03T15:21:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000920 post PendingInvicesDO 2 KHM-131000946 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000946 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='272740fa-1ee6-4af7-8e80-e04302796098' LIMIT 1 Date : 2025-03-03T16:42:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-03T16:42:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000921 post PendingInvicesDO 2 KHM-131000947 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000947 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='04c160b6-2d14-400f-af33-2468674181f5' LIMIT 1 Date : 2025-03-03T16:46:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-03T16:46:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000922 post PendingInvicesDO 2 KHM-131000948 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000948 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fd43b953-95bc-4031-b551-919b68947a79' LIMIT 1 Date : 2025-03-04T14:27:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T14:28:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000923 post PendingInvicesDO 2 KHM-131000949 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000949 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fa0f887f-e9d0-4e7a-8327-bf05e4d1a2f7' LIMIT 1 Date : 2025-03-04T15:20:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T15:20:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000924 post PendingInvicesDO 2 KHM-131000950 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000950 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1d3f3eb6-438b-4186-b48b-39a23bf1e797' LIMIT 1 Date : 2025-03-04T16:33:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T16:33:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000925 post PendingInvicesDO 2 KHM-131000951 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000951 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='52f5a67c-d7d9-48cd-89fe-50d9438f9c45' LIMIT 1 Date : 2025-03-04T19:48:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T19:48:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000926 post PendingInvicesDO 2 KHM-131000952 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000952 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cb413448-2dc3-4545-9b3f-bd9b6f29be7b' LIMIT 1 Date : 2025-03-04T19:49:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T19:49:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000927 post PendingInvicesDO 2 KHM-131000953 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000953 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b531fe36-72a5-440a-adb7-ceb168845624' LIMIT 1 Date : 2025-03-04T19:50:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-04T19:50:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000928 post PendingInvicesDO 2 KHM-131000954 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000954 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5b51dfa6-637d-4d6c-93a0-bf2c5332e2e8' LIMIT 1 Date : 2025-03-05T16:14:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T16:14:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000929 post PendingInvicesDO 2 KHM-131000956 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000956 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5dd86a98-9e21-43ec-8148-8f658c5476eb' LIMIT 1 Date : 2025-03-05T16:56:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T16:56:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000930 post PendingInvicesDO 2 KHM-131000958 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000958 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8deb5f77-1d09-42df-a05f-fbcf74d9ecd0' LIMIT 1 Date : 2025-03-05T18:55:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T18:55:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000931 post PendingInvicesDO 2 KHM-131000959 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000959 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='88e24c36-6a66-4aad-8cce-583ed612a32d' LIMIT 1 Date : 2025-03-05T19:18:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-05T19:18:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000932 post PendingInvicesDO 2 KHM-131000961 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000961 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='730978f6-cd36-479c-957c-a6869a404e06' LIMIT 1 Date : 2025-03-08T13:00:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T13:00:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000933 post PendingInvicesDO 2 KHM-131000962 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000962 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='67eca506-cb80-4baa-b61d-876f28ed7d5e' LIMIT 1 Date : 2025-03-08T14:04:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T14:04:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000934 post PendingInvicesDO 2 KHM-131000963 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000963 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e359f9f6-a1ea-4ee6-bda6-3b47d9441a5f' LIMIT 1 Date : 2025-03-08T14:35:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T14:35:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000935 post PendingInvicesDO 2 KHM-131000964 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000964 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='12e30277-e019-4b81-9fb2-ae39a14dfac6' LIMIT 1 Date : 2025-03-08T20:22:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-08T20:22:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000936 post PendingInvicesDO 2 KHM-131000965 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000965 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1b32a4fa-bcab-4f5b-99c2-203ce7ba354d' LIMIT 1 Date : 2025-03-09T13:50:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-09T13:50:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000937 post PendingInvicesDO 2 KHM-131000966 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000966 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5b7cb528-3a82-49b2-a498-106236498ac0' LIMIT 1 Date : 2025-03-09T14:49:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-09T14:49:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000939 post PendingInvicesDO 2 KHM-131000968 post PendingInvicesDO 2 KHM-131000967 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000938 post PendingInvicesDO 2 KHM-131000968 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000967 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000968 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7db6e718-e5d4-4653-8ca7-da8299da62a0' LIMIT 1 Date : 2025-03-10T13:23:25  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='015613b3-9156-41cb-b177-0b5d46e9db97' LIMIT 1 Date : 2025-03-10T13:23:25  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7db6e718-e5d4-4653-8ca7-da8299da62a0' LIMIT 1 Date : 2025-03-10T13:23:25  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='015613b3-9156-41cb-b177-0b5d46e9db97' LIMIT 1 Date : 2025-03-10T13:23:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-03-10T13:23:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000940 post PendingInvicesDO 2 KHM-131000969 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000969 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5d43f67a-1443-4344-bcbc-96a35d80fb08' LIMIT 1 Date : 2025-03-10T14:17:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-10T14:17:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000942 post PendingInvicesDO 2 KHM-131000971 post PendingInvicesDO 2 KHM-131000970 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 KHM-134000941 post PendingInvicesDO 2 KHM-131000971 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : KHM-131000970 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000971 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f569361d-70a1-46e0-81de-c2ae331149a0' LIMIT 1 Date : 2025-03-10T14:59:39  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4d28a831-1add-4f79-80b2-b0888d64fc35' LIMIT 1 Date : 2025-03-10T14:59:39  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f569361d-70a1-46e0-81de-c2ae331149a0' LIMIT 1 Date : 2025-03-10T14:59:39  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4d28a831-1add-4f79-80b2-b0888d64fc35' LIMIT 1 Date : 2025-03-10T14:59:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-03-10T14:59:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000943 post PendingInvicesDO 2 KHM-131000972 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000972 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8403d2a9-6542-4d60-9fb8-35c47664656d' LIMIT 1 Date : 2025-03-10T15:53:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-10T15:53:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000944 post PendingInvicesDO 2 KHM-131000973 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000973 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='13f2889a-a155-4980-b1d8-a7303f22de58' LIMIT 1 Date : 2025-03-11T14:27:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T14:27:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000945 post PendingInvicesDO 2 KHM-131000974 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000974 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='94a0b3fd-5fe7-43f8-9e43-31acde2e02d1' LIMIT 1 Date : 2025-03-11T15:06:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T15:06:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000946 post PendingInvicesDO 2 KHM-131000975 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000975 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='15b26ac6-1d03-4e20-84a2-41c1207166fb' LIMIT 1 Date : 2025-03-11T15:31:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T15:31:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000947 post PendingInvicesDO 2 KHM-131000976 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000976 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dcc462a8-d02f-448c-936d-b124bf1d187d' LIMIT 1 Date : 2025-03-11T15:57:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T15:57:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000948 post PendingInvicesDO 2 KHM-131000977 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000977 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6bc0b91b-993f-4f2a-81ec-505852779cad' LIMIT 1 Date : 2025-03-11T16:28:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T16:28:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000949 post PendingInvicesDO 2 KHM-131000978 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000978 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a4330f8b-4cab-4bdc-9530-449d6826cb28' LIMIT 1 Date : 2025-03-11T18:31:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T18:31:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000950 post PendingInvicesDO 2 KHM-131000979 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000979 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1da6c9a4-bf97-4ab0-94e3-dcef8c5cacec' LIMIT 1 Date : 2025-03-11T19:17:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T19:17:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000951 post PendingInvicesDO 2 KHM-131000980 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000980 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6e8e5415-7306-4ed4-a8e0-f600a1bb32a7' LIMIT 1 Date : 2025-03-11T19:54:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-11T19:55:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000952 post PendingInvicesDO 2 KHM-131000981 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000981 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2d22946f-3626-469b-af45-36a4e32a1f10' LIMIT 1 Date : 2025-03-12T15:19:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T15:19:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000953 post PendingInvicesDO 2 KHM-131000982 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000982 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4e06159-26d2-4a10-a904-7ed0a443801b' LIMIT 1 Date : 2025-03-12T16:18:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T16:18:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000954 post PendingInvicesDO 2 KHM-131000983 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000983 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9c84e372-dc6a-4c67-bb63-cd34a941a3c8' LIMIT 1 Date : 2025-03-12T20:36:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-12T20:36:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000955 post PendingInvicesDO 2 KHM-131000984 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000984 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1f13b2a0-9761-4ed3-850f-676c717cb78c' LIMIT 1 Date : 2025-03-13T14:24:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-13T14:24:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000956 post PendingInvicesDO 2 KHM-131000985 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000985 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a1d91b86-bdf2-4f40-98fa-bed82f18a7ac' LIMIT 1 Date : 2025-03-13T14:56:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-13T14:56:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 KHM-134000957 post PendingInvicesDO 2 KHM-131000987 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : KHM-131000987 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d0b8fccb-bf99-43ad-ad6a-08e657c978ba' LIMIT 1 Date : 2025-03-13T16:21:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-13T16:21:49 payment end 
