 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 
