INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300955','0.00','0.00','0.00','0.00','0.00','113-113100','113','TC5','LRN11320244498','2024-02-16','0','','700.00','','05','0','113','031','2024-02-17 09:11:28','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:28'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300956','0.00','0.00','0.00','0.00','0.00','113-113101','113','TC5','LRN11320244464','2024-02-16','0','','500.00','','05','0','113','031','2024-02-17 09:11:30','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:30'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300957','0.00','0.00','0.00','0.00','0.00','113-113102','113','TC5','LRN11320234267','2024-02-16','0','','840.00','','05','0','113','031','2024-02-17 09:11:32','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:32'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300958','0.00','0.00','0.00','0.00','0.00','113-113103','113','TC5','LRN11320244379','2024-02-16','0','','300.00','','05','0','113','031','2024-02-17 09:11:34','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:34'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300959','0.00','0.00','0.00','0.00','0.00','113-113104','113','TC5','LRN11320244527','2024-02-16','0','','400.00','','05','0','113','031','2024-02-17 09:11:36','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:36'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300960','0.00','0.00','0.00','0.00','0.00','113-113105','113','TC5','LRN11320234255','2024-02-16','0','','1000.00','','05','0','113','031','2024-02-17 09:11:38','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:38'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300961','0.00','0.00','0.00','0.00','0.00','113-113106','113','TC5','LRN11320211143','2024-02-16','0','','100.00','','05','0','113','031','2024-02-17 09:11:40','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:40'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300962','0.00','0.00','0.00','0.00','0.00','113-113107','113','TC5','LRN11320234287','2024-02-16','0','','500.00','','05','0','113','031','2024-02-17 09:11:42','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:42'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300963','0.00','0.00','0.00','0.00','0.00','113-113108','113','TC5','LRN11320234266','2024-02-16','0','','1050.00','','05','0','113','031','2024-02-17 09:11:44','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:44'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300964','0.00','0.00','0.00','0.00','0.00','113-113109','113','TC5','LRN11320244516','2024-02-16','0','','200.00','','05','0','113','031','2024-02-17 09:11:46','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:46'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300965','0.00','0.00','0.00','0.00','0.00','113-113110','113','TC5','LRN11320233859','2024-02-16','0','','1510.00','','05','0','113','031','2024-02-17 09:11:49','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:49'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300966','0.00','0.00','0.00','0.00','0.00','113-113111','113','TC5','LRN11320244416','2024-02-16','0','','900.00','','05','0','113','031','2024-02-17 09:11:51','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:51'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300967','0.00','0.00','0.00','0.00','0.00','113-113112','113','TC5','LRN11320234081','2024-02-16','0','','150.00','','05','0','113','031','2024-02-17 09:11:53','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:53'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300968','0.00','0.00','0.00','0.00','0.00','113-113113','113','TC5','LRN11320244523','2024-02-16','0','','300.00','','05','0','113','031','2024-02-17 09:11:55','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:55'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300969','0.00','0.00','0.00','0.00','0.00','113-113114','113','TC5','LRN11320233976','2024-02-16','0','','150.00','','05','0','113','031','2024-02-17 09:11:57','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:57'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300970','0.00','0.00','0.00','0.00','0.00','113-113115','113','TC5','LRN11320234347','2024-02-16','0','','250.00','','05','0','113','031','2024-02-17 09:11:59','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:11:59'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300971','0.00','0.00','0.00','0.00','0.00','113-113116','113','TC5','LRN11320244514','2024-02-16','0','','840.00','','05','0','113','031','2024-02-17 09:12:01','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:01'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300972','0.00','0.00','0.00','0.00','0.00','113-113117','113','TC5','LRN11320244528','2024-02-16','0','','1200.00','','05','0','113','031','2024-02-17 09:12:03','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300973','0.00','0.00','0.00','0.00','0.00','113-113118','113','TC5','LRN11320233471','2024-02-16','0','','200.00','','05','0','113','031','2024-02-17 09:12:05','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300974','0.00','0.00','0.00','0.00','0.00','113-113119','113','TC5','LRN11320244479','2024-02-16','0','','500.00','','05','0','113','031','2024-02-17 09:12:07','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:07'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300975','0.00','0.00','0.00','0.00','0.00','113-113120','113','TC5','LRN11320244397','2024-02-16','0','','210.00','','05','0','113','031','2024-02-17 09:12:09','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:09'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300976','0.00','0.00','0.00','0.00','0.00','113-113121','113','TC5','LRN11320244541','2024-02-16','0','','400.00','','05','0','113','031','2024-02-17 09:12:11','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:11'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300977','0.00','0.00','0.00','0.00','0.00','113-113122','113','TC5','LRN11320234335','2024-02-16','0','','140.00','','05','0','113','031','2024-02-17 09:12:13','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:13'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300978','0.00','0.00','0.00','0.00','0.00','113-113123','113','TC5','LRN11320234321','2024-02-16','0','','150.00','','05','0','113','031','2024-02-17 09:12:16','0','0000-00-00 00:00:00','0','031','2024-02-17 08:20:32','2024-02-17 09:12:16'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300979','0.00','0.00','0.00','0.00','0.00','113-113124','113','TC6','LRN11320244436','2024-02-16','0','','950.00','','029','0','113','031','2024-02-17 09:12:54','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:12:54'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300980','0.00','0.00','0.00','0.00','0.00','113-113125','113','TC6','LRN11320244473','2024-02-16','0','','500.00','','029','0','113','031','2024-02-17 09:12:56','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:12:56'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300981','0.00','0.00','0.00','0.00','0.00','113-113126','113','TC6','LRN11320234242','2024-02-16','0','','1000.00','','029','0','113','031','2024-02-17 09:12:58','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:12:58'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300982','0.00','0.00','0.00','0.00','0.00','113-113127','113','TC6','LRN11320234288','2024-02-16','0','','2000.00','','029','0','113','031','2024-02-17 09:13:00','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:00'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300983','0.00','0.00','0.00','0.00','0.00','113-113128','113','TC6','LRN11320234224','2024-02-16','0','','200.00','','029','0','113','031','2024-02-17 09:13:02','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:02'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300984','0.00','0.00','0.00','0.00','0.00','113-113129','113','TC6','LRN11320244449','2024-02-16','0','','300.00','','029','0','113','031','2024-02-17 09:13:04','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:04'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300985','0.00','0.00','0.00','0.00','0.00','113-113130','113','TC6','LRN11320234343','2024-02-16','0','','800.00','','029','0','113','031','2024-02-17 09:13:06','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:06'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300986','0.00','0.00','0.00','0.00','0.00','113-113131','113','TC6','LRN11320244525','2024-02-16','0','','140.00','','029','0','113','031','2024-02-17 09:13:08','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:08'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300987','0.00','0.00','0.00','0.00','0.00','113-113132','113','TC6','LRN11320234188','2024-02-16','0','','6900.00','','029','0','113','031','2024-02-17 09:13:10','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:10'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300988','0.00','0.00','0.00','0.00','0.00','113-113133','113','TC6','LRN11320244484','2024-02-16','0','','500.00','','029','0','113','031','2024-02-17 09:13:14','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:14'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300989','0.00','0.00','0.00','0.00','0.00','113-113134','113','TC6','LRN11320234213','2024-02-16','0','','1050.00','','029','0','113','031','2024-02-17 09:13:17','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300990','0.00','0.00','0.00','0.00','0.00','113-113135','113','TC6','LRN11320244509','2024-02-16','0','','150.00','','029','0','113','031','2024-02-17 09:13:19','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:19'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300991','0.00','0.00','0.00','0.00','0.00','113-113136','113','TC6','LRN11320244458','2024-02-16','0','','300.00','','029','0','113','031','2024-02-17 09:13:21','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:21'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300992','0.00','0.00','0.00','0.00','0.00','113-113137','113','TC6','LRN11320234233','2024-02-16','0','','400.00','','029','0','113','031','2024-02-17 09:13:23','0','0000-00-00 00:00:00','0','031','2024-02-17 08:25:29','2024-02-17 09:13:23'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300993','0.00','0.00','0.00','0.00','0.00','113-113138','113','TC8','LRN11320234187','2024-02-16','0','','200.00','','038','0','113','031','2024-02-17 09:15:03','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300994','0.00','0.00','0.00','0.00','0.00','113-113139','113','TC8','LRN11320244494','2024-02-16','0','','500.00','','038','0','113','031','2024-02-17 09:15:05','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300995','0.00','0.00','0.00','0.00','0.00','113-113140','113','TC8','LRN11320244470','2024-02-16','0','','200.00','','038','0','113','031','2024-02-17 09:15:07','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:07'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300996','0.00','0.00','0.00','0.00','0.00','113-113141','113','TC8','LRN11320234210','2024-02-16','0','','210.00','','038','0','113','031','2024-02-17 09:15:09','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:09'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300997','0.00','0.00','0.00','0.00','0.00','113-113142','113','TC8','LRN11320244415','2024-02-16','0','','1400.00','','038','0','113','031','2024-02-17 09:15:11','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:11'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300998','0.00','0.00','0.00','0.00','0.00','113-113143','113','TC8','LRN11320234345','2024-02-16','0','','100.00','','038','0','113','031','2024-02-17 09:15:13','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:13'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','300999','0.00','0.00','0.00','0.00','0.00','113-113144','113','TC8','LRN11320234309','2024-02-16','0','','310.00','','038','0','113','031','2024-02-17 09:15:15','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301000','0.00','0.00','0.00','0.00','0.00','113-113145','113','TC8','LRN11320234365','2024-02-16','0','','600.00','','038','0','113','031','2024-02-17 09:15:17','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301001','0.00','0.00','0.00','0.00','0.00','113-113146','113','TC8','LRN11320234291','2024-02-16','0','','500.00','','038','0','113','031','2024-02-17 09:15:19','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:19'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301002','0.00','0.00','0.00','0.00','0.00','113-113147','113','TC8','LRN11320234285','2024-02-16','0','','150.00','','038','0','113','031','2024-02-17 09:15:21','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:21'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301003','0.00','0.00','0.00','0.00','0.00','113-113148','113','TC8','LRN11320234361','2024-02-16','0','','280.00','','038','0','113','031','2024-02-17 09:15:23','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:23'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301004','0.00','0.00','0.00','0.00','0.00','113-113149','113','TC8','LRN11320244376','2024-02-16','0','','200.00','','038','0','113','031','2024-02-17 09:15:26','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:26'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301005','0.00','0.00','0.00','0.00','0.00','113-113150','113','TC8','LRN11320234193','2024-02-16','0','','440.00','','038','0','113','031','2024-02-17 09:15:28','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:28'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301006','0.00','0.00','0.00','0.00','0.00','113-113151','113','TC8','LRN11320234148','2024-02-16','0','','400.00','','038','0','113','031','2024-02-17 09:15:30','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:30'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301007','0.00','0.00','0.00','0.00','0.00','113-113152','113','TC8','LRN11320234351','2024-02-16','0','','350.00','','038','0','113','031','2024-02-17 09:15:32','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:32'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301008','0.00','0.00','0.00','0.00','0.00','113-113153','113','TC8','LRN11320244370','2024-02-16','0','','220.00','','038','0','113','031','2024-02-17 09:15:34','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:34'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301009','0.00','0.00','0.00','0.00','0.00','113-113154','113','TC8','LRN11320234152','2024-02-16','0','','420.00','','038','0','113','031','2024-02-17 09:15:36','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:36'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301010','0.00','0.00','0.00','0.00','0.00','113-113155','113','TC8','LRN11320244521','2024-02-16','0','','630.00','','038','0','113','031','2024-02-17 09:15:38','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:38'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301011','0.00','0.00','0.00','0.00','0.00','113-113156','113','TC8','LRN11320244460','2024-02-16','0','','220.00','','038','0','113','031','2024-02-17 09:15:40','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:40'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301012','0.00','0.00','0.00','0.00','0.00','113-113157','113','TC8','LRN11320244448','2024-02-16','0','','220.00','','038','0','113','031','2024-02-17 09:15:42','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:42'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301013','0.00','0.00','0.00','0.00','0.00','113-113158','113','TC8','LRN11320234296','2024-02-16','0','','1800.00','','038','0','113','031','2024-02-17 09:15:44','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:44'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301014','0.00','0.00','0.00','0.00','0.00','113-113159','113','TC8','LRN11320244493','2024-02-16','0','','150.00','','038','0','113','031','2024-02-17 09:15:46','0','0000-00-00 00:00:00','0','031','2024-02-17 08:36:03','2024-02-17 09:15:46'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301015','0.00','0.00','0.00','0.00','0.00','113-113160','113','TC1','LRN11320234144','2024-02-16','0','','500.00','','004','0','113','031','2024-02-17 09:05:16','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:16'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301016','0.00','0.00','0.00','0.00','0.00','113-113161','113','TC1','LRN11320210276','2024-02-16','0','','200.00','','004','0','113','031','2024-02-17 09:05:18','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:18'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301017','0.00','0.00','0.00','0.00','0.00','113-113162','113','TC1','LRN11320234290','2024-02-16','0','','3000.00','','004','0','113','031','2024-02-17 09:05:20','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:20'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301018','0.00','0.00','0.00','0.00','0.00','113-113163','113','TC1','LRN11320244505','2024-02-16','0','','1000.00','','004','0','113','031','2024-02-17 09:05:22','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:22'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301019','0.00','0.00','0.00','0.00','0.00','113-113164','113','TC1','LRN11320234264','2024-02-16','0','','5000.00','','004','0','113','031','2024-02-17 09:05:24','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:24'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301020','0.00','0.00','0.00','0.00','0.00','113-113165','113','TC1','LRN11320234293','2024-02-16','0','','2500.00','','004','0','113','031','2024-02-17 09:05:27','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:27'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301021','0.00','0.00','0.00','0.00','0.00','113-113166','113','TC1','LRN11320244405','2024-02-16','0','','1750.00','','004','0','113','031','2024-02-17 09:05:29','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:29'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301022','0.00','0.00','0.00','0.00','0.00','113-113167','113','TC1','LRN11320234318','2024-02-16','0','','3000.00','','004','0','113','031','2024-02-17 09:05:31','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:31'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301023','0.00','0.00','0.00','0.00','0.00','113-113168','113','TC1','LRN11320244382','2024-02-16','0','','1000.00','','004','0','113','031','2024-02-17 09:05:33','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:33'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301024','0.00','0.00','0.00','0.00','0.00','113-113169','113','TC1','LRN11320244390','2024-02-16','0','','200.00','','004','0','113','031','2024-02-17 09:05:35','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:35'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301025','0.00','0.00','0.00','0.00','0.00','113-113170','113','TC1','LRN11320244404','2024-02-16','0','','10150.00','','004','0','113','031','2024-02-17 09:05:37','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:37'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301026','0.00','0.00','0.00','0.00','0.00','113-113171','113','TC1','LRN11320234140','2024-02-16','0','','1000.00','','004','0','113','031','2024-02-17 09:05:39','0','0000-00-00 00:00:00','0','031','2024-02-17 08:40:21','2024-02-17 09:05:39'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301027','0.00','0.00','0.00','0.00','0.00','113-113172','113','TC3','LRN11320244442','2024-02-16','0','','420.00','','014','0','113','031','2024-02-17 09:08:38','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:38'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301028','0.00','0.00','0.00','0.00','0.00','113-113173','113','TC3','LRN11320244500','2024-02-16','0','','150.00','','014','0','113','031','2024-02-17 09:08:40','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:40'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301029','0.00','0.00','0.00','0.00','0.00','113-113174','113','TC3','LRN11320244453','2024-02-16','0','','2000.00','','014','0','113','031','2024-02-17 09:08:42','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:42'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301030','0.00','0.00','0.00','0.00','0.00','113-113175','113','TC3','LRN11320244389','2024-02-16','0','','210.00','','014','0','113','031','2024-02-17 09:08:44','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:44'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301031','0.00','0.00','0.00','0.00','0.00','113-113176','113','TC3','LRN11320234132','2024-02-16','0','','1160.00','','014','0','113','031','2024-02-17 09:08:46','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:46'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301032','0.00','0.00','0.00','0.00','0.00','113-113177','113','TC3','LRN11320233985','2024-02-16','0','','50.00','','014','0','113','031','2024-02-17 09:08:48','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:48'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301033','0.00','0.00','0.00','0.00','0.00','113-113178','113','TC3','LRN11320234252','2024-02-16','0','','1000.00','','014','0','113','031','2024-02-17 09:08:50','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:50'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301034','0.00','0.00','0.00','0.00','0.00','113-113179','113','TC3','LRN11320234104','2024-02-16','0','','100.00','','014','0','113','031','2024-02-17 09:08:53','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:53'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301035','0.00','0.00','0.00','0.00','0.00','113-113180','113','TC3','LRN11320234241','2024-02-16','0','','8600.00','','014','0','113','031','2024-02-17 09:08:55','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:55'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301036','0.00','0.00','0.00','0.00','0.00','113-113181','113','TC3','LRN11320234366','2024-02-16','0','','1050.00','','014','0','113','031','2024-02-17 09:08:57','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:57'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301037','0.00','0.00','0.00','0.00','0.00','113-113182','113','TC3','LRN11320234274','2024-02-16','0','','210.00','','014','0','113','031','2024-02-17 09:08:59','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:08:59'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301038','0.00','0.00','0.00','0.00','0.00','113-113183','113','TC3','LRN11320233377','2024-02-16','0','','20.00','','014','0','113','031','2024-02-17 09:09:01','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:01'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301039','0.00','0.00','0.00','0.00','0.00','113-113184','113','TC3','LRN11320234127','2024-02-16','0','','14000.00','','014','0','113','031','2024-02-17 09:09:03','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301040','0.00','0.00','0.00','0.00','0.00','113-113185','113','TC3','LRN11320221564','2024-02-16','0','','100.00','','014','0','113','031','2024-02-17 09:09:05','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301041','0.00','0.00','0.00','0.00','0.00','113-113186','113','TC3','LRN11320234340','2024-02-16','0','','600.00','','014','0','113','031','2024-02-17 09:09:07','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:07'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301042','0.00','0.00','0.00','0.00','0.00','113-113187','113','TC3','LRN11320244407','2024-02-16','0','','1050.00','','014','0','113','031','2024-02-17 09:09:09','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:09'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301043','0.00','0.00','0.00','0.00','0.00','113-113188','113','TC3','LRN11320234315','2024-02-16','0','','350.00','','014','0','113','031','2024-02-17 09:09:11','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:11'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301044','0.00','0.00','0.00','0.00','0.00','113-113189','113','TC3','LRN11320234294','2024-02-16','0','','200.00','','014','0','113','031','2024-02-17 09:09:13','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:13'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301045','0.00','0.00','0.00','0.00','0.00','113-113190','113','TC3','LRN11320234240','2024-02-16','0','','100.00','','014','0','113','031','2024-02-17 09:09:15','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301046','0.00','0.00','0.00','0.00','0.00','113-113191','113','TC3','LRN11320234050','2024-02-16','0','','100.00','','014','0','113','031','2024-02-17 09:09:17','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301047','0.00','0.00','0.00','0.00','0.00','113-113192','113','TC3','LRN11320244466','2024-02-16','0','','100.00','','014','0','113','031','2024-02-17 09:09:20','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:20'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301048','0.00','0.00','0.00','0.00','0.00','113-113193','113','TC3','LRN11320234352','2024-02-16','0','','500.00','','014','0','113','031','2024-02-17 09:09:22','0','0000-00-00 00:00:00','0','031','2024-02-17 08:45:12','2024-02-17 09:09:22'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301049','0.00','0.00','0.00','0.00','0.00','113-113194','113','TC7','LRN11320233886','2024-02-16','0','','150.00','','041','0','113','031','2024-02-17 09:13:57','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:13:57'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301050','0.00','0.00','0.00','0.00','0.00','113-113195','113','TC7','LRN11320244481','2024-02-16','0','','140.00','','041','0','113','031','2024-02-17 09:13:59','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:13:59'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301051','0.00','0.00','0.00','0.00','0.00','113-113196','113','TC7','LRN11320244497','2024-02-16','0','','170.00','','041','0','113','031','2024-02-17 09:14:01','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:01'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301052','0.00','0.00','0.00','0.00','0.00','113-113197','113','TC7','LRN11320234167','2024-02-16','0','','150.00','','041','0','113','031','2024-02-17 09:14:03','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301053','0.00','0.00','0.00','0.00','0.00','113-113198','113','TC7','LRN11320233500','2024-02-16','0','','210.00','','041','0','113','031','2024-02-17 09:14:05','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301054','0.00','0.00','0.00','0.00','0.00','113-113199','113','TC7','LRN11320244402','2024-02-16','0','','840.00','','041','0','113','031','2024-02-17 09:14:07','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:07'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301055','0.00','0.00','0.00','0.00','0.00','113-113200','113','TC7','LRN11320244485','2024-02-16','0','','140.00','','041','0','113','031','2024-02-17 09:14:09','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:09'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301056','0.00','0.00','0.00','0.00','0.00','113-113201','113','TC7','LRN11320244377','2024-02-16','0','','1050.00','','041','0','113','031','2024-02-17 09:14:11','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:11'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301057','0.00','0.00','0.00','0.00','0.00','113-113202','113','TC7','LRN11320233318','2024-02-16','0','','200.00','','041','0','113','031','2024-02-17 09:14:13','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:13'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301058','0.00','0.00','0.00','0.00','0.00','113-113203','113','TC7','LRN11320244518','2024-02-16','0','','200.00','','041','0','113','031','2024-02-17 09:14:15','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301059','0.00','0.00','0.00','0.00','0.00','113-113204','113','TC7','LRN11320244452','2024-02-16','0','','210.00','','041','0','113','031','2024-02-17 09:14:17','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301060','0.00','0.00','0.00','0.00','0.00','113-113205','113','TC7','LRN11320244401','2024-02-16','0','','200.00','','041','0','113','031','2024-02-17 09:14:20','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:20'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301061','0.00','0.00','0.00','0.00','0.00','113-113206','113','TC7','LRN11320244478','2024-02-16','0','','140.00','','041','0','113','031','2024-02-17 09:14:22','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:22'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301062','0.00','0.00','0.00','0.00','0.00','113-113207','113','TC7','LRN11320244398','2024-02-16','0','','200.00','','041','0','113','031','2024-02-17 09:14:24','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:24'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301063','0.00','0.00','0.00','0.00','0.00','113-113208','113','TC7','LRN11320244486','2024-02-16','0','','140.00','','041','0','113','031','2024-02-17 09:14:26','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:26'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301064','0.00','0.00','0.00','0.00','0.00','113-113209','113','TC7','LRN11320244451','2024-02-16','0','','950.00','','041','0','113','031','2024-02-17 09:14:28','0','0000-00-00 00:00:00','0','031','2024-02-17 08:50:22','2024-02-17 09:14:28'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301065','0.00','0.00','0.00','0.00','0.00','113-113210','113','TC4','LRN11320244369','2024-02-16','0','','3800.00','','016','0','113','031','2024-02-17 09:10:20','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:20'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301066','0.00','0.00','0.00','0.00','0.00','113-113211','113','TC4','LRN11320234239','2024-02-16','0','','1200.00','','016','0','113','031','2024-02-17 09:10:22','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:22'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301067','0.00','0.00','0.00','0.00','0.00','113-113212','113','TC4','LRN11320233290','2024-02-16','0','','200.00','','016','0','113','031','2024-02-17 09:10:24','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:24'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301068','0.00','0.00','0.00','0.00','0.00','113-113213','113','TC4','LRN11320234363','2024-02-16','0','','3000.00','','016','0','113','031','2024-02-17 09:10:26','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:26'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301069','0.00','0.00','0.00','0.00','0.00','113-113214','113','TC4','LRN11320234092','2024-02-16','0','','200.00','','016','0','113','031','2024-02-17 09:10:29','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:29'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301070','0.00','0.00','0.00','0.00','0.00','113-113215','113','TC4','LRN11320244391','2024-02-16','0','','1400.00','','016','0','113','031','2024-02-17 09:10:31','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:31'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301071','0.00','0.00','0.00','0.00','0.00','113-113216','113','TC4','LRN11320244469','2024-02-16','0','','200.00','','016','0','113','031','2024-02-17 09:10:33','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:33'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301072','0.00','0.00','0.00','0.00','0.00','113-113217','113','TC4','LRN11320244462','2024-02-16','0','','200.00','','016','0','113','031','2024-02-17 09:10:35','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:35'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301073','0.00','0.00','0.00','0.00','0.00','113-113218','113','TC4','LRN11320244427','2024-02-16','0','','500.00','','016','0','113','031','2024-02-17 09:10:37','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:37'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301074','0.00','0.00','0.00','0.00','0.00','113-113219','113','TC4','LRN11320234227','2024-02-16','0','','500.00','','016','0','113','031','2024-02-17 09:10:39','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:39'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301075','0.00','0.00','0.00','0.00','0.00','113-113220','113','TC4','LRN11320234223','2024-02-16','0','','100.00','','016','0','113','031','2024-02-17 09:10:41','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:41'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301076','0.00','0.00','0.00','0.00','0.00','113-113221','113','TC4','LRN11320244467','2024-02-16','0','','600.00','','016','0','113','031','2024-02-17 09:10:43','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:43'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301077','0.00','0.00','0.00','0.00','0.00','113-113222','113','TC4','LRN11320244517','2024-02-16','0','','200.00','','016','0','113','031','2024-02-17 09:10:45','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:45'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301078','0.00','0.00','0.00','0.00','0.00','113-113223','113','TC4','LRN11320233739','2024-02-16','0','','100.00','','016','0','113','031','2024-02-17 09:10:47','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:47'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301079','0.00','0.00','0.00','0.00','0.00','113-113224','113','TC4','LRN11320221443','2024-02-16','0','','100.00','','016','0','113','031','2024-02-17 09:10:49','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:49'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301080','0.00','0.00','0.00','0.00','0.00','113-113225','113','TC4','LRN11320234348','2024-02-16','0','','1050.00','','016','0','113','031','2024-02-17 09:10:51','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:51'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301081','0.00','0.00','0.00','0.00','0.00','113-113226','113','TC4','LRN11320244380','2024-02-16','0','','3000.00','','016','0','113','031','2024-02-17 09:10:53','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:53'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301082','0.00','0.00','0.00','0.00','0.00','113-113227','113','TC4','LRN11320244403','2024-02-16','0','','400.00','','016','0','113','031','2024-02-17 09:10:56','0','0000-00-00 00:00:00','0','031','2024-02-17 08:54:23','2024-02-17 09:10:56'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301083','0.00','0.00','0.00','0.00','0.00','113-113228','113','TC2','LRN11320234226','2024-02-16','0','','140.00','','011','0','113','031','2024-02-17 09:07:07','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:07'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301084','0.00','0.00','0.00','0.00','0.00','113-113229','113','TC2','LRN11320234328','2024-02-16','0','','3000.00','','011','0','113','031','2024-02-17 09:07:09','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:09'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301085','0.00','0.00','0.00','0.00','0.00','113-113230','113','TC2','LRN11320234186','2024-02-16','0','','1000.00','','011','0','113','031','2024-02-17 09:07:11','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:11'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301086','0.00','0.00','0.00','0.00','0.00','113-113231','113','TC2','LRN11320244428','2024-02-16','0','','210.00','','011','0','113','031','2024-02-17 09:07:13','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:13'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301087','0.00','0.00','0.00','0.00','0.00','113-113232','113','TC2','LRN11320234277','2024-02-16','0','','16500.00','','011','0','113','031','2024-02-17 09:07:15','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301088','0.00','0.00','0.00','0.00','0.00','113-113233','113','TC2','LRN11320234168','2024-02-16','0','','500.00','','011','0','113','031','2024-02-17 09:07:18','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:18'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301089','0.00','0.00','0.00','0.00','0.00','113-113234','113','TC2','LRN11320244410','2024-02-16','0','','500.00','','011','0','113','031','2024-02-17 09:07:20','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:20'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301090','0.00','0.00','0.00','0.00','0.00','113-113235','113','TC2','LRN11320244414','2024-02-16','0','','400.00','','011','0','113','031','2024-02-17 09:07:22','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:22'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301091','0.00','0.00','0.00','0.00','0.00','113-113236','113','TC2','LRN11320222393','2024-02-16','0','','100.00','','011','0','113','031','2024-02-17 09:07:24','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:24'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301092','0.00','0.00','0.00','0.00','0.00','113-113237','113','TC2','LRN11320244423','2024-02-16','0','','200.00','','011','0','113','031','2024-02-17 09:07:26','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:26'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301093','0.00','0.00','0.00','0.00','0.00','113-113238','113','TC2','LRN11320234256','2024-02-16','0','','250.00','','011','0','113','031','2024-02-17 09:07:28','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:28'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301094','0.00','0.00','0.00','0.00','0.00','113-113239','113','TC2','LRN11320233614','2024-02-16','0','','1000.00','','011','0','113','031','2024-02-17 09:07:30','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:30'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301095','0.00','0.00','0.00','0.00','0.00','113-113240','113','TC2','LRN11320244422','2024-02-16','0','','140.00','','011','0','113','031','2024-02-17 09:07:32','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:32'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301096','0.00','0.00','0.00','0.00','0.00','113-113241','113','TC2','LRN11320244429','2024-02-16','0','','100.00','','011','0','113','031','2024-02-17 09:07:34','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:34'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301097','0.00','0.00','0.00','0.00','0.00','113-113242','113','TC2','LRN11320234220','2024-02-16','0','','350.00','','011','0','113','031','2024-02-17 09:07:36','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:36'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301098','0.00','0.00','0.00','0.00','0.00','113-113243','113','TC2','LRN11320234324','2024-02-16','0','','3500.00','','011','0','113','031','2024-02-17 09:07:38','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:38'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301099','0.00','0.00','0.00','0.00','0.00','113-113244','113','TC2','LRN11320234292','2024-02-16','0','','300.00','','011','0','113','031','2024-02-17 09:07:40','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:40'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301100','0.00','0.00','0.00','0.00','0.00','113-113245','113','TC2','LRN11320234124','2024-02-16','0','','500.00','','011','0','113','031','2024-02-17 09:07:42','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:42'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301101','0.00','0.00','0.00','0.00','0.00','113-113246','113','TC2','LRN11320234190','2024-02-16','0','','500.00','','011','0','113','031','2024-02-17 09:07:45','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:45'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301102','0.00','0.00','0.00','0.00','0.00','113-113247','113','TC2','LRN11320234336','2024-02-16','0','','500.00','','011','0','113','031','2024-02-17 09:07:47','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:47'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301103','0.00','0.00','0.00','0.00','0.00','113-113248','113','TC2','LRN11320233636','2024-02-16','0','','500.00','','011','0','113','031','2024-02-17 09:07:49','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:49'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301104','0.00','0.00','0.00','0.00','0.00','113-113249','113','TC2','LRN11320244431','2024-02-16','0','','150.00','','011','0','113','031','2024-02-17 09:07:51','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:51'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301105','0.00','0.00','0.00','0.00','0.00','113-113250','113','TC2','LRN11320234142','2024-02-16','0','','6800.00','','011','0','113','031','2024-02-17 09:07:53','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:53'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301106','0.00','0.00','0.00','0.00','0.00','113-113251','113','TC2','LRN11320234323','2024-02-16','0','','800.00','','011','0','113','031','2024-02-17 09:07:55','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:55'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301107','0.00','0.00','0.00','0.00','0.00','113-113252','113','TC2','LRN11320234134','2024-02-16','0','','2500.00','','011','0','113','031','2024-02-17 09:07:57','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:57'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301108','0.00','0.00','0.00','0.00','0.00','113-113253','113','TC2','LRN11320244392','2024-02-16','0','','700.00','','011','0','113','031','2024-02-17 09:07:59','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:07:59'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301109','0.00','0.00','0.00','0.00','0.00','113-113254','113','TC2','LRN11320244519','2024-02-16','0','','400.00','','011','0','113','031','2024-02-17 09:08:01','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:08:01'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301110','0.00','0.00','0.00','0.00','0.00','113-113255','113','TC2','LRN11320234254','2024-02-16','0','','3150.00','','011','0','113','031','2024-02-17 09:08:03','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:08:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301111','0.00','0.00','0.00','0.00','0.00','113-113256','113','TC2','LRN11320234082','2024-02-16','0','','200.00','','011','0','113','031','2024-02-17 09:08:05','0','0000-00-00 00:00:00','0','031','2024-02-17 09:02:23','2024-02-17 09:08:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301112','0.00','0.00','0.00','0.00','0.00','113-113257','113','TC6','LRN11320221587','2024-02-16','0','','200.00','','029','0','113','031','2024-02-17 09:13:12','0','0000-00-00 00:00:00','0','031','2024-02-17 09:03:28','2024-02-17 09:13:12'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301113','0.00','0.00','0.00','0.00','0.00','112-117236','112','11CLC','LRN11220232012','2024-02-17','0','','50.00','','004i','0','112','015','2024-02-17 14:36:02','0','0000-00-00 00:00:00','0','015','2024-02-17 14:31:09','2024-02-17 14:36:02'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301114','0.00','0.00','0.00','0.00','0.00','112-117237','112','4CLC','LRN11220232332','2024-02-17','0','','630.00','','004i','0','112','015','2024-02-17 14:36:44','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:44'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301115','0.00','0.00','0.00','0.00','0.00','112-117238','112','4CLC','LRN11220232481','2024-02-17','0','','1400.00','','004i','0','112','015','2024-02-17 14:36:46','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:46'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301116','0.00','0.00','0.00','0.00','0.00','112-117239','112','4CLC','LRN11220232414','2024-02-17','0','','200.00','','004i','0','112','015','2024-02-17 14:36:48','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:48'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301117','0.00','0.00','0.00','0.00','0.00','112-117240','112','4CLC','LRN11220232356','2024-02-17','0','','200.00','','004i','0','112','015','2024-02-17 14:36:50','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:50'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301118','0.00','0.00','0.00','0.00','0.00','112-117241','112','4CLC','LRN11220232150','2024-02-17','0','','400.00','','004i','0','112','015','2024-02-17 14:36:52','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:52'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301119','0.00','0.00','0.00','0.00','0.00','112-117242','112','4CLC','LRN11220232449','2024-02-17','0','','340.00','','004i','0','112','015','2024-02-17 14:36:55','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:55'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301120','0.00','0.00','0.00','0.00','0.00','112-117243','112','4CLC','LRN11220232253','2024-02-17','0','','155.00','','004i','0','112','015','2024-02-17 14:36:57','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:57'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301121','0.00','0.00','0.00','0.00','0.00','112-117244','112','4CLC','LRN11220232418','2024-02-17','0','','200.00','','004i','0','112','015','2024-02-17 14:36:59','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:36:59'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301122','0.00','0.00','0.00','0.00','0.00','112-117245','112','4CLC','LRN11220232367','2024-02-17','0','','350.00','','004i','0','112','015','2024-02-17 14:37:01','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:01'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301123','0.00','0.00','0.00','0.00','0.00','112-117246','112','4CLC','LRN11220240046','2024-02-17','0','','350.00','','004i','0','112','015','2024-02-17 14:37:03','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301124','0.00','0.00','0.00','0.00','0.00','112-117247','112','4CLC','LRN11220240033','2024-02-17','0','','300.00','','004i','0','112','015','2024-02-17 14:37:05','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301125','0.00','0.00','0.00','0.00','0.00','112-117248','112','4CLC','LRN11220232369','2024-02-17','0','','250.00','','004i','0','112','015','2024-02-17 14:37:07','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:07'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301126','0.00','0.00','0.00','0.00','0.00','112-117249','112','4CLC','LRN11220232288','2024-02-17','0','','200.00','','004i','0','112','015','2024-02-17 14:37:09','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:09'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301127','0.00','0.00','0.00','0.00','0.00','112-117250','112','4CLC','LRN11220232491','2024-02-17','0','','200.00','','004i','0','112','015','2024-02-17 14:37:11','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:11'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301128','0.00','0.00','0.00','0.00','0.00','112-117251','112','4CLC','LRN11220240015','2024-02-17','0','','500.00','','004i','0','112','015','2024-02-17 14:37:13','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:13'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301129','0.00','0.00','0.00','0.00','0.00','112-117252','112','4CLC','LRN11220240093','2024-02-17','0','','270.00','','004i','0','112','015','2024-02-17 14:37:15','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301130','0.00','0.00','0.00','0.00','0.00','112-117253','112','4CLC','LRN11220232442','2024-02-17','0','','100.00','','004i','0','112','015','2024-02-17 14:37:17','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301131','0.00','0.00','0.00','0.00','0.00','112-117254','112','4CLC','LRN11220240078','2024-02-17','0','','170.00','','004i','0','112','015','2024-02-17 14:37:19','0','0000-00-00 00:00:00','0','015','2024-02-17 14:34:07','2024-02-17 14:37:19'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301132','0.00','0.00','0.00','0.00','0.00','112-117255','112','13CLC','LRN11220232386','2024-02-17','0','','120.00','','042','0','112','015','2024-02-17 14:50:01','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:01'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301133','0.00','0.00','0.00','0.00','0.00','112-117256','112','13CLC','LRN11220240013','2024-02-17','0','','200.00','','042','0','112','015','2024-02-17 14:50:03','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301134','0.00','0.00','0.00','0.00','0.00','112-117257','112','13CLC','LRN11220240040','2024-02-17','0','','200.00','','042','0','112','015','2024-02-17 14:50:05','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301135','0.00','0.00','0.00','0.00','0.00','112-117258','112','13CLC','LRN11220232439','2024-02-17','0','','200.00','','042','0','112','015','2024-02-17 14:50:07','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:07'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301136','0.00','0.00','0.00','0.00','0.00','112-117259','112','13CLC','LRN11220232408','2024-02-17','0','','700.00','','042','0','112','015','2024-02-17 14:50:09','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:09'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301137','0.00','0.00','0.00','0.00','0.00','112-117260','112','13CLC','LRN11220240002','2024-02-17','0','','200.00','','042','0','112','015','2024-02-17 14:50:11','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:11'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301138','0.00','0.00','0.00','0.00','0.00','112-117261','112','13CLC','LRN11220240001','2024-02-17','0','','200.00','','042','0','112','015','2024-02-17 14:50:13','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:13'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301139','0.00','0.00','0.00','0.00','0.00','112-117262','112','13CLC','LRN11220231796','2024-02-17','0','','100.00','','042','0','112','015','2024-02-17 14:50:15','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301140','0.00','0.00','0.00','0.00','0.00','112-117263','112','13CLC','LRN11220232398','2024-02-17','0','','250.00','','042','0','112','015','2024-02-17 14:50:18','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:18'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301141','0.00','0.00','0.00','0.00','0.00','112-117264','112','13CLC','LRN11220232368','2024-02-17','0','','70.00','','042','0','112','015','2024-02-17 14:50:20','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:20'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301142','0.00','0.00','0.00','0.00','0.00','112-117265','112','13CLC','LRN11220232370','2024-02-17','0','','500.00','','042','0','112','015','2024-02-17 14:50:22','0','0000-00-00 00:00:00','0','015','2024-02-17 14:48:31','2024-02-17 14:50:22'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301143','0.00','0.00','0.00','0.00','0.00','112-117266','112','2CLC','LRN11220232488','2024-02-17','0','','350.00','','006','0','112','015','2024-02-17 15:05:08','0','0000-00-00 00:00:00','0','015','2024-02-17 15:04:05','2024-02-17 15:05:08'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301144','0.00','0.00','0.00','0.00','0.00','112-117267','112','2CLC','LRN11220232427','2024-02-17','0','','170.00','','006','0','112','015','2024-02-17 15:05:10','0','0000-00-00 00:00:00','0','015','2024-02-17 15:04:05','2024-02-17 15:05:10'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301145','0.00','0.00','0.00','0.00','0.00','112-117268','112','2CLC','LRN11220240079','2024-02-17','0','','300.00','','006','0','112','015','2024-02-17 15:05:12','0','0000-00-00 00:00:00','0','015','2024-02-17 15:04:05','2024-02-17 15:05:12'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301146','0.00','0.00','0.00','0.00','0.00','112-117269','112','2CLC','LRN11220232447','2024-02-17','0','','250.00','','006','0','112','015','2024-02-17 15:05:14','0','0000-00-00 00:00:00','0','015','2024-02-17 15:04:05','2024-02-17 15:05:14'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301147','0.00','0.00','0.00','0.00','0.00','112-117270','112','2CLC','LRN11220232448','2024-02-17','0','','200.00','','006','0','112','015','2024-02-17 15:05:16','0','0000-00-00 00:00:00','0','015','2024-02-17 15:04:05','2024-02-17 15:05:16'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301148','0.00','0.00','0.00','0.00','0.00','112-117271','112','2CLC','LRN11220232109','2024-02-17','0','','100.00','','006','0','112','015','2024-02-17 15:05:19','0','0000-00-00 00:00:00','0','015','2024-02-17 15:04:05','2024-02-17 15:05:19'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301149','0.00','0.00','0.00','0.00','0.00','112-117272','112','2CLC','LRN11220240049','2024-02-17','0','','250.00','','006','0','112','015','2024-02-17 15:05:21','0','0000-00-00 00:00:00','0','015','2024-02-17 15:04:05','2024-02-17 15:05:21'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301150','0.00','0.00','0.00','0.00','0.00','112-117273','112','2CLC','LRN11220232264','2024-02-17','0','','100.00','','002','0','112','015','2024-02-17 15:49:42','0','0000-00-00 00:00:00','0','015','2024-02-17 15:45:02','2024-02-17 15:49:42'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301151','0.00','0.00','0.00','0.00','0.00','112-117274','112','3CLC','LRN11220240069','2024-02-17','0','','300.00','','006','0','112','015','2024-02-17 15:50:15','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301152','0.00','0.00','0.00','0.00','0.00','112-117275','112','3CLC','LRN11220240091','2024-02-17','0','','300.00','','006','0','112','015','2024-02-17 15:50:17','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301153','0.00','0.00','0.00','0.00','0.00','112-117276','112','3CLC','LRN11220240060','2024-02-17','0','','320.00','','006','0','112','015','2024-02-17 15:50:19','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:19'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301154','0.00','0.00','0.00','0.00','0.00','112-117277','112','3CLC','LRN11220240017','2024-02-17','0','','400.00','','006','0','112','015','2024-02-17 15:50:21','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:21'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301155','0.00','0.00','0.00','0.00','0.00','112-117278','112','3CLC','LRN11220240076','2024-02-17','0','','500.00','','006','0','112','015','2024-02-17 15:50:23','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:23'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301156','0.00','0.00','0.00','0.00','0.00','112-117279','112','3CLC','LRN11220232419','2024-02-17','0','','350.00','','006','0','112','015','2024-02-17 15:50:25','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:25'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301157','0.00','0.00','0.00','0.00','0.00','112-117280','112','3CLC','LRN11220232415','2024-02-17','0','','150.00','','006','0','112','015','2024-02-17 15:50:27','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:27'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301158','0.00','0.00','0.00','0.00','0.00','112-117281','112','3CLC','LRN11220232405','2024-02-17','0','','200.00','','006','0','112','015','2024-02-17 15:50:29','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:29'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301159','0.00','0.00','0.00','0.00','0.00','112-117282','112','3CLC','LRN11220240089','2024-02-17','0','','280.00','','006','0','112','015','2024-02-17 15:50:31','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:31'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301160','0.00','0.00','0.00','0.00','0.00','112-117283','112','3CLC','LRN11220240014','2024-02-17','0','','1000.00','','006','0','112','015','2024-02-17 15:50:34','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:34'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301161','0.00','0.00','0.00','0.00','0.00','112-117284','112','3CLC','LRN11220240105','2024-02-17','0','','364.00','','006','0','112','015','2024-02-17 15:50:36','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:36'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301162','0.00','0.00','0.00','0.00','0.00','112-117285','112','3CLC','LRN11220232308','2024-02-17','0','','120.00','','006','0','112','015','2024-02-17 15:50:38','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:38'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301163','0.00','0.00','0.00','0.00','0.00','112-117286','112','3CLC','LRN11220240050','2024-02-17','0','','200.00','','006','0','112','015','2024-02-17 15:50:40','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:40'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301164','0.00','0.00','0.00','0.00','0.00','112-117287','112','3CLC','LRN11220232421','2024-02-17','0','','400.00','','006','0','112','015','2024-02-17 15:50:42','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:42'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301165','0.00','0.00','0.00','0.00','0.00','112-117288','112','3CLC','LRN11220232423','2024-02-17','0','','400.00','','006','0','112','015','2024-02-17 15:50:44','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:44'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301166','0.00','0.00','0.00','0.00','0.00','112-117289','112','3CLC','LRN11220232236','2024-02-17','0','','150.00','','006','0','112','015','2024-02-17 15:50:46','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:46'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301167','0.00','0.00','0.00','0.00','0.00','112-117290','112','3CLC','LRN11220232341','2024-02-17','0','','10300.00','','006','0','112','015','2024-02-17 15:50:48','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:48'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301168','0.00','0.00','0.00','0.00','0.00','112-117291','112','3CLC','LRN11220232361','2024-02-17','0','','500.00','','006','0','112','015','2024-02-17 15:50:50','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:50'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301169','0.00','0.00','0.00','0.00','0.00','112-117292','112','3CLC','LRN11220240106','2024-02-17','0','','600.00','','006','0','112','015','2024-02-17 15:50:52','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:52'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301170','0.00','0.00','0.00','0.00','0.00','112-117293','112','3CLC','LRN11220240101','2024-02-17','0','','1000.00','','006','0','112','015','2024-02-17 15:50:54','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:54'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301171','0.00','0.00','0.00','0.00','0.00','112-117294','112','3CLC','LRN11220232476','2024-02-17','0','','120.00','','006','0','112','015','2024-02-17 15:50:56','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:56'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301172','0.00','0.00','0.00','0.00','0.00','112-117295','112','3CLC','LRN11220240056','2024-02-17','0','','500.00','','006','0','112','015','2024-02-17 15:50:58','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:50:58'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301173','0.00','0.00','0.00','0.00','0.00','112-117296','112','3CLC','LRN11220232411','2024-02-17','0','','700.00','','006','0','112','015','2024-02-17 15:51:00','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:51:00'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301174','0.00','0.00','0.00','0.00','0.00','112-117297','112','3CLC','LRN11220232470','2024-02-17','0','','300.00','','006','0','112','015','2024-02-17 15:51:03','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:51:03'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301175','0.00','0.00','0.00','0.00','0.00','112-117298','112','3CLC','LRN11220240073','2024-02-17','0','','150.00','','006','0','112','015','2024-02-17 15:51:05','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:51:05'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','301176','0.00','0.00','0.00','0.00','0.00','112-117299','112','3CLC','LRN11220240037','2024-02-17','0','','500.00','','006','0','112','015','2024-02-17 15:51:07','0','0000-00-00 00:00:00','0','015','2024-02-17 15:48:37','2024-02-17 15:51:07'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC1','Deposited','2024-02-16','167','2024-02-16','29300.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:16:21','2024-02-17 09:16:21'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC2','Deposited','2024-02-16','168','2024-02-16','44890.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:16:47','2024-02-17 09:16:47'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC3','Deposited','2024-02-16','167','2024-02-16','32070.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:17:12','2024-02-17 09:17:12'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC4','Deposited','2024-02-16','168','2024-02-16','16750.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:17:39','2024-02-17 09:17:39'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC5','Deposited','2024-02-16','167','2024-02-16','12490.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:18:07','2024-02-17 09:18:07'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC6','Deposited','2024-02-16','168','2024-02-16','15390.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:18:35','2024-02-17 09:18:35'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC7','Deposited','2024-02-16','167','2024-02-16','5090.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:19:02','2024-02-17 09:19:02'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC8','Deposited','2024-02-16','168','2024-02-16','9500.00','0.00','0.00','','ACTIVE','031','2024-02-17 09:19:28','2024-02-17 09:19:28'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('112','11CLC','Deposited','2024-02-17','166','2024-02-17','50.00','0.00','0.00','','ACTIVE','015','2024-02-17 14:38:31','2024-02-17 14:38:31'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('112','4CLC','Deposited','2024-02-17','166','2024-02-17','6215.00','0.00','0.00','','ACTIVE','015','2024-02-17 14:39:06','2024-02-17 14:39:06'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('112','13CLC','Deposited','2024-02-17','166','2024-02-17','2740.00','0.00','0.00','','ACTIVE','015','2024-02-17 14:51:10','2024-02-17 14:51:10'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('112','2CLC','Deposited','2024-02-17','166','2024-02-17','1620.00','0.00','0.00','','ACTIVE','015','2024-02-17 15:06:04','2024-02-17 15:06:04'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('112','2CLC','Deposited','2024-02-17','166','2024-02-17','100.00','0.00','0.00','','ACTIVE','015','2024-02-17 15:52:02','2024-02-17 15:52:02'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('112','3CLC','Deposited','2024-02-17','166','2024-02-17','20104.00','0.00','0.00','','ACTIVE','015','2024-02-17 15:52:36','2024-02-17 15:52:36'); UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='28500.00',sales_amortization='500.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='50000.00',sales_interest_amt='0.00',sales_prin_amt='50000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2022-02-25 17:47:50',sales_Timestamp='2024-02-17 09:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='21500.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2022-02-25 17:51:43',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320210967',sales_AssignTo='014',sales_PNumber='LRN11320221564',sales_Amt='50000.00',sales_Area='TC3',sales_Cycle='5',sales_Released='2022-02-25',sales_Maturity='2022-06-05',sales_BegBalance='50000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320221564' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='8350.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-03-30 14:26:31',sales_Timestamp='2024-02-17 09:21:36',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6650.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-03-30 14:27:29',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222015',sales_AssignTo='006',sales_PNumber='LRN11220231656',sales_Amt='15000.00',sales_Area='3CLC',sales_Cycle='3',sales_Released='2023-03-30',sales_Maturity='2023-07-08',sales_BegBalance='15000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11220231656' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-06-19 15:47:56',sales_Timestamp='2024-02-17 09:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='210.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-06-19 15:58:31',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230299',sales_AssignTo='',sales_PNumber='LRN11320233500',sales_Amt='10000.00',sales_Area='TC7',sales_Cycle='1',sales_Released='2023-06-19',sales_Maturity='2023-09-27',sales_BegBalance='10000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320233500' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='-414176.00',sales_prin_amt='-2154424.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-07-28 11:56:47',sales_Timestamp='2024-02-17 12:13:36',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='4800.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-07-29 15:54:25',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420211013',sales_AssignTo='',sales_PNumber='LRN11420232709',sales_Amt='20000.00',sales_Area='B9',sales_Cycle='6',sales_Released='2023-07-28',sales_Maturity='2023-11-05',sales_BegBalance='20000.00',sales_LPD='2023-11-09' WHERE sales_PNumber = 'LRN11420232709' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='-38304.00',sales_prin_amt='-191096.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-07-28 12:08:37',sales_Timestamp='2024-02-17 12:13:36',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='1420.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-07-29 15:54:25',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231305',sales_AssignTo='006B',sales_PNumber='LRN11420232716',sales_Amt='10000.00',sales_Area='B5',sales_Cycle='2',sales_Released='2023-07-28',sales_Maturity='2023-11-05',sales_BegBalance='10000.00',sales_LPD='2023-11-09' WHERE sales_PNumber = 'LRN11420232716' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='-87091.20',sales_prin_amt='-445228.80',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-08-10 14:58:59',sales_Timestamp='2024-02-17 12:13:36',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12000.00',sales_PaymentCutoff='3120.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-08-10 15:00:36',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231301',sales_AssignTo='040',sales_PNumber='LRN11420232750',sales_Amt='12000.00',sales_Area='B6',sales_Cycle='2',sales_Released='2023-08-10',sales_Maturity='2023-11-18',sales_BegBalance='12000.00',sales_LPD='2023-11-10' WHERE sales_PNumber = 'LRN11420232750' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='500.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='50000.00',sales_interest_amt='-845712.00',sales_prin_amt='-4389988.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-08-14 15:35:00',sales_Timestamp='2024-02-17 12:13:36',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='50000.00',sales_PaymentCutoff='7000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-08-14 17:10:41',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420190561',sales_AssignTo='',sales_PNumber='LRN11420232756',sales_Amt='50000.00',sales_Area='B2',sales_Cycle='3',sales_Released='2023-08-14',sales_Maturity='2023-11-22',sales_BegBalance='50000.00',sales_LPD='2023-11-09' WHERE sales_PNumber = 'LRN11420232756' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='130.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='13000.00',sales_interest_amt='-44040.00',sales_prin_amt='-218210.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-08-15 15:11:19',sales_Timestamp='2024-02-17 12:13:36',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13000.00',sales_PaymentCutoff='2750.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-08-15 15:49:33',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231318',sales_AssignTo='',sales_PNumber='LRN11420232768',sales_Amt='13000.00',sales_Area='B7',sales_Cycle='2',sales_Released='2023-08-15',sales_Maturity='2023-11-23',sales_BegBalance='13000.00',sales_LPD='2023-11-09' WHERE sales_PNumber = 'LRN11420232768' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='1200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='120000.00',sales_interest_amt='736512.00',sales_prin_amt='3986688.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-08-22 15:13:38',sales_Timestamp='2024-02-17 09:20:57',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='120000.00',sales_PaymentCutoff='33600.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-08-22 15:21:44',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211057',sales_AssignTo='004',sales_PNumber='LRN11320233790',sales_Amt='120000.00',sales_Area='TC1',sales_Cycle='9',sales_Released='2023-08-22',sales_Maturity='2023-11-30',sales_BegBalance='120000.00',sales_LPD='2023-11-09' WHERE sales_PNumber = 'LRN11320233790' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='-111776.00',sales_prin_amt='-576824.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-08-29 15:22:04',sales_Timestamp='2024-02-17 12:13:36',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='3000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-08-29 15:33:52',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231451',sales_AssignTo='',sales_PNumber='LRN11420232845',sales_Amt='10000.00',sales_Area='B8',sales_Cycle='1',sales_Released='2023-08-29',sales_Maturity='2023-12-07',sales_BegBalance='10000.00',sales_LPD='2023-11-09' WHERE sales_PNumber = 'LRN11420232845' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='170.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='17000.00',sales_interest_amt='0.00',sales_prin_amt='17000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-08-31 14:36:45',sales_Timestamp='2024-02-17 09:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='17000.00',sales_PaymentCutoff='1510.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-08-31 14:59:39',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211023',sales_AssignTo='05',sales_PNumber='LRN11320233859',sales_Amt='17000.00',sales_Area='TC5',sales_Cycle='10',sales_Released='2023-08-31',sales_Maturity='2023-12-09',sales_BegBalance='17000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320233859' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='-300.00',sales_amortization='210.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='21000.00',sales_interest_amt='0.00',sales_prin_amt='21000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-15 12:26:11',sales_Timestamp='2024-02-17 09:21:37',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='21300.00',sales_PaymentCutoff='900.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-15 12:30:19',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232078',sales_AssignTo='004i',sales_PNumber='LRN11220232343',sales_Amt='21000.00',sales_Area='4CLC',sales_Cycle='5',sales_Released='2023-11-15',sales_Maturity='2024-02-23',sales_BegBalance='21000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11220232343' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='350.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-11-20 17:13:26',sales_Timestamp='2024-02-17 09:20:48',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='24650.00',sales_PaymentCutoff='6800.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-11-20 17:14:06',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180309',sales_AssignTo='011',sales_PNumber='LRN11320234142',sales_Amt='25000.00',sales_Area='TC2',sales_Cycle='6',sales_Released='2023-11-20',sales_Maturity='2024-02-28',sales_BegBalance='25000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320234142' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-11-21 16:06:05',sales_Timestamp='2024-02-17 09:20:48',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12000.00',sales_PaymentCutoff='420.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-11-21 16:08:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230260',sales_AssignTo='038',sales_PNumber='LRN11320234152',sales_Amt='12000.00',sales_Area='TC8',sales_Cycle='2',sales_Released='2023-11-21',sales_Maturity='2024-02-29',sales_BegBalance='12000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320234152' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-28 10:05:58',sales_Timestamp='2024-02-17 09:21:37',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='2110.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-28 10:07:06',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232258',sales_AssignTo='042',sales_PNumber='LRN11220232395',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2023-11-28',sales_Maturity='2024-03-07',sales_BegBalance='10000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11220232395' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='300.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='30000.00',sales_interest_amt='0.00',sales_prin_amt='30000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-11-28 13:44:15',sales_Timestamp='2024-02-17 09:20:48',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='30000.00',sales_PaymentCutoff='6900.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-11-28 15:04:46',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211107',sales_AssignTo='029',sales_PNumber='LRN11320234188',sales_Amt='30000.00',sales_Area='TC6',sales_Cycle='9',sales_Released='2023-11-28',sales_Maturity='2024-03-07',sales_BegBalance='30000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320234188' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='350.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='35000.00',sales_interest_amt='0.00',sales_prin_amt='35000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-11-30 14:06:27',sales_Timestamp='2024-02-17 09:20:48',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='35000.00',sales_PaymentCutoff='8600.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-11-30 16:44:14',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180341',sales_AssignTo='014',sales_PNumber='LRN11320234241',sales_Amt='35000.00',sales_Area='TC3',sales_Cycle='8',sales_Released='2023-11-30',sales_Maturity='2024-03-09',sales_BegBalance='35000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320234241' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='330.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='33000.00',sales_interest_amt='0.00',sales_prin_amt='33000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2023-12-15 13:16:37',sales_Timestamp='2024-02-17 09:20:48',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='33000.00',sales_PaymentCutoff='16500.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-12-15 15:50:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180291',sales_AssignTo='011',sales_PNumber='LRN11320234277',sales_Amt='33000.00',sales_Area='TC2',sales_Cycle='14',sales_Released='2023-12-15',sales_Maturity='2024-03-24',sales_BegBalance='33000.00',sales_LPD='2024-02-16' WHERE sales_PNumber = 'LRN11320234277' ;