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','359095','0.00','0.00','0.00','0.00','0.00','114-83011','114','B1','LRN11420243943','2024-09-02','0','','2100.00','','001B','0','114','002B','2024-09-02 14:27:35','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:02:33','2024-09-02 14:27: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','359096','0.00','0.00','0.00','0.00','0.00','114-83012','114','B1','LRN11420244039','2024-09-02','0','','2800.00','','001B','0','114','002B','2024-09-02 14:27:37','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:02:33','2024-09-02 14:27: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','359097','0.00','0.00','0.00','0.00','0.00','114-83013','114','B1','LRN11420244066','2024-09-02','0','','200.00','','001B','0','114','002B','2024-09-02 14:27:39','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:02:33','2024-09-02 14:27: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','359098','0.00','0.00','0.00','0.00','0.00','114-83014','114','B7','LRN11420243880','2024-09-02','0','','100.00','','003B','0','114','002B','2024-09-02 14:30:00','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:04:52','2024-09-02 14:30: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','359099','0.00','0.00','0.00','0.00','0.00','114-83015','114','B7','LRN11420243837','2024-09-02','0','','1000.00','','003B','0','114','002B','2024-09-02 14:30:02','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:04:52','2024-09-02 14:30: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','359100','0.00','0.00','0.00','0.00','0.00','114-83016','114','B7','LRN11420243908','2024-09-02','0','','3500.00','','003B','0','114','002B','2024-09-02 14:30:04','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:04:52','2024-09-02 14:30: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','359101','0.00','0.00','0.00','0.00','0.00','114-83017','114','B7','LRN11420243932','2024-09-02','0','','300.00','','003B','0','114','002B','2024-09-02 14:30:06','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:04:52','2024-09-02 14:30: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','359102','0.00','0.00','0.00','0.00','0.00','114-83018','114','B9','LRN11420244007','2024-09-02','0','','1400.00','','010B','0','114','002B','2024-09-02 14:30:37','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359103','0.00','0.00','0.00','0.00','0.00','114-83019','114','B9','LRN11420244024','2024-09-02','0','','150.00','','010B','0','114','002B','2024-09-02 14:30:39','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359104','0.00','0.00','0.00','0.00','0.00','114-83020','114','B9','LRN11420243806','2024-09-02','0','','1000.00','','010B','0','114','002B','2024-09-02 14:30:41','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359105','0.00','0.00','0.00','0.00','0.00','114-83021','114','B9','LRN11420243874','2024-09-02','0','','500.00','','010B','0','114','002B','2024-09-02 14:30:43','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359106','0.00','0.00','0.00','0.00','0.00','114-83022','114','B9','LRN11420243944','2024-09-02','0','','2000.00','','010B','0','114','002B','2024-09-02 14:30:45','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359107','0.00','0.00','0.00','0.00','0.00','114-83023','114','B9','LRN11420243904','2024-09-02','0','','100.00','','010B','0','114','002B','2024-09-02 14:30:47','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359108','0.00','0.00','0.00','0.00','0.00','114-83024','114','B9','LRN11420243960','2024-09-02','0','','170.00','','010B','0','114','002B','2024-09-02 14:30:49','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359109','0.00','0.00','0.00','0.00','0.00','114-83025','114','B9','LRN11420243968','2024-09-02','0','','450.00','','010B','0','114','002B','2024-09-02 14:30:52','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359110','0.00','0.00','0.00','0.00','0.00','114-83026','114','B9','LRN11420244017','2024-09-02','0','','300.00','','010B','0','114','002B','2024-09-02 14:30:54','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359111','0.00','0.00','0.00','0.00','0.00','114-83027','114','B9','LRN11420243907','2024-09-02','0','','150.00','','010B','0','114','002B','2024-09-02 14:30:56','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359112','0.00','0.00','0.00','0.00','0.00','114-83028','114','B9','LRN11420243987','2024-09-02','0','','150.00','','010B','0','114','002B','2024-09-02 14:30:58','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:30: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','359113','0.00','0.00','0.00','0.00','0.00','114-83029','114','B9','LRN11420244022','2024-09-02','0','','140.00','','010B','0','114','002B','2024-09-02 14:31:00','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:31: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','359114','0.00','0.00','0.00','0.00','0.00','114-83030','114','B9','LRN11420244056','2024-09-02','0','','500.00','','010B','0','114','002B','2024-09-02 14:31:02','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:31: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','359115','0.00','0.00','0.00','0.00','0.00','114-83031','114','B9','LRN11420244110','2024-09-02','0','','250.00','','010B','0','114','002B','2024-09-02 14:31:04','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:31: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','359116','0.00','0.00','0.00','0.00','0.00','114-83032','114','B9','LRN11420221701','2024-09-02','0','','200.00','','010B','0','114','002B','2024-09-02 14:31:06','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:31: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','359117','0.00','0.00','0.00','0.00','0.00','114-83033','114','B9','LRN11420244064','2024-09-02','0','','700.00','','010B','0','114','002B','2024-09-02 14:31:08','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:31: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','359118','0.00','0.00','0.00','0.00','0.00','114-83034','114','B9','LRN11420232898','2024-09-02','0','','100.00','','010B','0','114','002B','2024-09-02 14:31:10','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:10:30','2024-09-02 14:31: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','359119','0.00','0.00','0.00','0.00','0.00','114-83035','114','B6','LRN11420244044','2024-09-02','0','','550.00','','040','0','114','002B','2024-09-02 14:29:08','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359120','0.00','0.00','0.00','0.00','0.00','114-83036','114','B6','LRN11420244070','2024-09-02','0','','500.00','','040','0','114','002B','2024-09-02 14:29:10','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359121','0.00','0.00','0.00','0.00','0.00','114-83037','114','B6','LRN11420244030','2024-09-02','0','','1000.00','','040','0','114','002B','2024-09-02 14:29:12','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359122','0.00','0.00','0.00','0.00','0.00','114-83038','114','B6','LRN11420244068','2024-09-02','0','','660.00','','040','0','114','002B','2024-09-02 14:29:14','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359123','0.00','0.00','0.00','0.00','0.00','114-83039','114','B6','LRN11420243903','2024-09-02','0','','2000.00','','040','0','114','002B','2024-09-02 14:29:16','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359124','0.00','0.00','0.00','0.00','0.00','114-83040','114','B6','LRN11420243892','2024-09-02','0','','1400.00','','040','0','114','002B','2024-09-02 14:29:18','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359125','0.00','0.00','0.00','0.00','0.00','114-83041','114','B6','LRN11420243917','2024-09-02','0','','2800.00','','040','0','114','002B','2024-09-02 14:29:20','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359126','0.00','0.00','0.00','0.00','0.00','114-83042','114','B6','LRN11420243930','2024-09-02','0','','250.00','','040','0','114','002B','2024-09-02 14:29:22','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359127','0.00','0.00','0.00','0.00','0.00','114-83043','114','B6','LRN11420244002','2024-09-02','0','','100.00','','040','0','114','002B','2024-09-02 14:29:24','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359128','0.00','0.00','0.00','0.00','0.00','114-83044','114','B6','LRN11420243882','2024-09-02','0','','140.00','','040','0','114','002B','2024-09-02 14:29:26','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359129','0.00','0.00','0.00','0.00','0.00','114-83045','114','B6','LRN11420243963','2024-09-02','0','','420.00','','040','0','114','002B','2024-09-02 14:29:28','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:15:53','2024-09-02 14:29: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','359130','0.00','0.00','0.00','0.00','0.00','114-83046','114','B2','LRN11420243952','2024-09-02','0','','1250.00','','003B','0','114','002B','2024-09-02 14:28:16','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359131','0.00','0.00','0.00','0.00','0.00','114-83047','114','B2','LRN11420244015','2024-09-02','0','','400.00','','003B','0','114','002B','2024-09-02 14:28:18','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359132','0.00','0.00','0.00','0.00','0.00','114-83048','114','B2','LRN11420243911','2024-09-02','0','','1000.00','','003B','0','114','002B','2024-09-02 14:28:20','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359133','0.00','0.00','0.00','0.00','0.00','114-83049','114','B2','LRN11420232427','2024-09-02','0','','250.00','','003B','0','114','002B','2024-09-02 14:28:22','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359134','0.00','0.00','0.00','0.00','0.00','114-83050','114','B2','LRN11420221710','2024-09-02','0','','300.00','','003B','0','114','002B','2024-09-02 14:28:25','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359135','0.00','0.00','0.00','0.00','0.00','114-83051','114','B2','LRN11420243996','2024-09-02','0','','300.00','','003B','0','114','002B','2024-09-02 14:28:27','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359136','0.00','0.00','0.00','0.00','0.00','114-83052','114','B2','LRN11420243905','2024-09-02','0','','280.00','','003B','0','114','002B','2024-09-02 14:28:29','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359137','0.00','0.00','0.00','0.00','0.00','114-83053','114','B2','LRN11420244083','2024-09-02','0','','150.00','','003B','0','114','002B','2024-09-02 14:28:31','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359138','0.00','0.00','0.00','0.00','0.00','114-83054','114','B2','LRN11420243864','2024-09-02','0','','900.00','','003B','0','114','002B','2024-09-02 14:28:33','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359139','0.00','0.00','0.00','0.00','0.00','114-83055','114','B2','LRN11420243994','2024-09-02','0','','170.00','','003B','0','114','002B','2024-09-02 14:28:35','0','0000-00-00 00:00:00','0','002B','2024-09-02 14:20:41','2024-09-02 14:28: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','359140','0.00','0.00','0.00','0.00','0.00','112-141949','112','12CLC','LRN11220240579','2024-09-02','0','','170.00','','006','0','112','015','2024-09-02 15:04:22','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359141','0.00','0.00','0.00','0.00','0.00','112-141950','112','12CLC','LRN11220240437','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 15:04:24','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359142','0.00','0.00','0.00','0.00','0.00','112-141951','112','12CLC','LRN11220240649','2024-09-02','0','','250.00','','006','0','112','015','2024-09-02 15:04:26','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359143','0.00','0.00','0.00','0.00','0.00','112-141952','112','12CLC','LRN11220240614','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 15:04:28','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359144','0.00','0.00','0.00','0.00','0.00','112-141953','112','12CLC','LRN11220240485','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 15:04:30','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359145','0.00','0.00','0.00','0.00','0.00','112-141954','112','12CLC','LRN11220240481','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 15:04:32','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359146','0.00','0.00','0.00','0.00','0.00','112-141955','112','12CLC','LRN11220240524','2024-09-02','0','','170.00','','006','0','112','015','2024-09-02 15:04:34','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359147','0.00','0.00','0.00','0.00','0.00','112-141956','112','12CLC','LRN11220240501','2024-09-02','0','','160.00','','006','0','112','015','2024-09-02 15:04:36','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359148','0.00','0.00','0.00','0.00','0.00','112-141957','112','12CLC','LRN11220240626','2024-09-02','0','','190.00','','006','0','112','015','2024-09-02 15:04:38','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359149','0.00','0.00','0.00','0.00','0.00','112-141958','112','12CLC','LRN11220240547','2024-09-02','0','','120.00','','006','0','112','015','2024-09-02 15:04:40','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359150','0.00','0.00','0.00','0.00','0.00','112-141959','112','12CLC','LRN11220240629','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 15:04:42','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359151','0.00','0.00','0.00','0.00','0.00','112-141960','112','12CLC','LRN11220240510','2024-09-02','0','','120.00','','006','0','112','015','2024-09-02 15:04:44','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359152','0.00','0.00','0.00','0.00','0.00','112-141961','112','12CLC','LRN11220240574','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 15:04:46','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359153','0.00','0.00','0.00','0.00','0.00','112-141962','112','12CLC','LRN11220240650','2024-09-02','0','','400.00','','006','0','112','015','2024-09-02 15:04:49','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359154','0.00','0.00','0.00','0.00','0.00','112-141963','112','12CLC','LRN11220240597','2024-09-02','0','','100.00','','006','0','112','015','2024-09-02 15:04:51','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359155','0.00','0.00','0.00','0.00','0.00','112-141964','112','12CLC','LRN11220240480','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 15:04:53','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359156','0.00','0.00','0.00','0.00','0.00','112-141965','112','12CLC','LRN11220240539','2024-09-02','0','','100.00','','006','0','112','015','2024-09-02 15:04:55','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359157','0.00','0.00','0.00','0.00','0.00','112-141966','112','12CLC','LRN11220240549','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 15:04:57','0','0000-00-00 00:00:00','0','015','2024-09-02 14:58:14','2024-09-02 15:04: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','359158','0.00','0.00','0.00','0.00','0.00','112-141967','112','2CLC','LRN11220240493','2024-09-02','0','','600.00','','002','0','112','015','2024-09-02 15:06:28','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359159','0.00','0.00','0.00','0.00','0.00','112-141968','112','2CLC','LRN11220240637','2024-09-02','0','','280.00','','002','0','112','015','2024-09-02 15:06:30','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359160','0.00','0.00','0.00','0.00','0.00','112-141969','112','2CLC','LRN11220240552','2024-09-02','0','','350.00','','002','0','112','015','2024-09-02 15:06:32','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359161','0.00','0.00','0.00','0.00','0.00','112-141970','112','2CLC','LRN11220240475','2024-09-02','0','','140.00','','002','0','112','015','2024-09-02 15:06:35','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359162','0.00','0.00','0.00','0.00','0.00','112-141971','112','2CLC','LRN11220240617','2024-09-02','0','','400.00','','002','0','112','015','2024-09-02 15:06:37','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359163','0.00','0.00','0.00','0.00','0.00','112-141972','112','2CLC','LRN11220240486','2024-09-02','0','','300.00','','002','0','112','015','2024-09-02 15:06:39','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359164','0.00','0.00','0.00','0.00','0.00','112-141973','112','2CLC','LRN11220240646','2024-09-02','0','','170.00','','002','0','112','015','2024-09-02 15:06:41','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359165','0.00','0.00','0.00','0.00','0.00','112-141974','112','2CLC','LRN11220240639','2024-09-02','0','','210.00','','002','0','112','015','2024-09-02 15:06:43','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359166','0.00','0.00','0.00','0.00','0.00','112-141975','112','2CLC','LRN11220240341','2024-09-02','0','','100.00','','002','0','112','015','2024-09-02 15:06:45','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359167','0.00','0.00','0.00','0.00','0.00','112-141976','112','2CLC','LRN11220240554','2024-09-02','0','','300.00','','002','0','112','015','2024-09-02 15:06:47','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359168','0.00','0.00','0.00','0.00','0.00','112-141977','112','2CLC','LRN11220240548','2024-09-02','0','','170.00','','002','0','112','015','2024-09-02 15:06:49','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359169','0.00','0.00','0.00','0.00','0.00','112-141978','112','2CLC','LRN11220240641','2024-09-02','0','','210.00','','002','0','112','015','2024-09-02 15:06:51','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359170','0.00','0.00','0.00','0.00','0.00','112-141979','112','2CLC','LRN11220240620','2024-09-02','0','','255.00','','002','0','112','015','2024-09-02 15:06:53','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359171','0.00','0.00','0.00','0.00','0.00','112-141980','112','2CLC','LRN11220240585','2024-09-02','0','','182.00','','002','0','112','015','2024-09-02 15:06:55','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359172','0.00','0.00','0.00','0.00','0.00','112-141981','112','2CLC','LRN11220240490','2024-09-02','0','','210.00','','002','0','112','015','2024-09-02 15:06:57','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359173','0.00','0.00','0.00','0.00','0.00','112-141982','112','2CLC','LRN11220240492','2024-09-02','0','','300.00','','002','0','112','015','2024-09-02 15:06:59','0','0000-00-00 00:00:00','0','015','2024-09-02 15:00:33','2024-09-02 15:06: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','359174','0.00','0.00','0.00','0.00','0.00','112-141983','112','4CLC','LRN11220240476','2024-09-02','0','','720.00','','004i','0','112','015','2024-09-02 15:07:36','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359175','0.00','0.00','0.00','0.00','0.00','112-141984','112','4CLC','LRN11220240550','2024-09-02','0','','200.00','','004i','0','112','015','2024-09-02 15:07:39','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15:07: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','359176','0.00','0.00','0.00','0.00','0.00','112-141985','112','4CLC','LRN11220240370','2024-09-02','0','','100.00','','004i','0','112','015','2024-09-02 15:07:41','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15:07: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','359177','0.00','0.00','0.00','0.00','0.00','112-141986','112','4CLC','LRN11220240589','2024-09-02','0','','150.00','','004i','0','112','015','2024-09-02 15:07:43','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15:07: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','359178','0.00','0.00','0.00','0.00','0.00','112-141987','112','4CLC','LRN11220240442','2024-09-02','0','','500.00','','004i','0','112','015','2024-09-02 15:07:45','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359179','0.00','0.00','0.00','0.00','0.00','112-141988','112','4CLC','LRN11220240642','2024-09-02','0','','1200.00','','004i','0','112','015','2024-09-02 15:07:47','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359180','0.00','0.00','0.00','0.00','0.00','112-141989','112','4CLC','LRN11220240530','2024-09-02','0','','200.00','','004i','0','112','015','2024-09-02 15:07:49','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359181','0.00','0.00','0.00','0.00','0.00','112-141990','112','4CLC','LRN11220240543','2024-09-02','0','','420.00','','004i','0','112','015','2024-09-02 15:07:51','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359182','0.00','0.00','0.00','0.00','0.00','112-141991','112','4CLC','LRN11220240593','2024-09-02','0','','350.00','','004i','0','112','015','2024-09-02 15:07:53','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359183','0.00','0.00','0.00','0.00','0.00','112-141992','112','4CLC','LRN11220240119','2024-09-02','0','','100.00','','004i','0','112','015','2024-09-02 15:07:55','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359184','0.00','0.00','0.00','0.00','0.00','112-141993','112','4CLC','LRN11220240644','2024-09-02','0','','255.00','','004i','0','112','015','2024-09-02 15:07:57','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359185','0.00','0.00','0.00','0.00','0.00','112-141994','112','4CLC','LRN11220240634','2024-09-02','0','','260.00','','004i','0','112','015','2024-09-02 15:07:59','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359186','0.00','0.00','0.00','0.00','0.00','112-141995','112','4CLC','LRN11220240577','2024-09-02','0','','252.00','','004i','0','112','015','2024-09-02 15:08:01','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359187','0.00','0.00','0.00','0.00','0.00','112-141996','112','4CLC','LRN11220240467','2024-09-02','0','','100.00','','004i','0','112','015','2024-09-02 15:08:03','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359188','0.00','0.00','0.00','0.00','0.00','112-141997','112','4CLC','LRN11220240514','2024-09-02','0','','200.00','','004i','0','112','015','2024-09-02 15:08:05','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15: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','359189','0.00','0.00','0.00','0.00','0.00','112-141998','112','4CLC','LRN11220240518','2024-09-02','0','','700.00','','004i','0','112','015','2024-09-02 15:08:08','0','0000-00-00 00:00:00','0','015','2024-09-02 15:02:52','2024-09-02 15:08: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','359190','0.00','0.00','0.00','0.00','0.00','112-141999','112','12CLC','LRN11220240648','2024-09-02','0','','170.00','','006','0','112','015','2024-09-02 15:50:02','0','0000-00-00 00:00:00','0','015','2024-09-02 15:49:02','2024-09-02 15:50: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','359191','0.00','0.00','0.00','0.00','0.00','112-142000','112','12CLC','LRN11220240500','2024-09-02','0','','120.00','','006','0','112','015','2024-09-02 15:50:04','0','0000-00-00 00:00:00','0','015','2024-09-02 15:49:02','2024-09-02 15:50: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','359192','0.00','0.00','0.00','0.00','0.00','112-142001','112','11CLC','LRN11220240390','2024-09-02','0','','120.00','','006','0','112','015','2024-09-02 16:09:16','0','0000-00-00 00:00:00','0','015','2024-09-02 16:04:24','2024-09-02 16:09: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','359193','0.00','0.00','0.00','0.00','0.00','112-142002','112','11CLC','LRN11220240469','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:09:18','0','0000-00-00 00:00:00','0','015','2024-09-02 16:04:24','2024-09-02 16:09: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','359194','0.00','0.00','0.00','0.00','0.00','112-142003','112','13CLC','LRN11220240628','2024-09-02','0','','400.00','','006','0','112','015','2024-09-02 16:09:52','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:09: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','359195','0.00','0.00','0.00','0.00','0.00','112-142004','112','13CLC','LRN11220240581','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 16:09:54','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:09: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','359196','0.00','0.00','0.00','0.00','0.00','112-142005','112','13CLC','LRN11220240567','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:09:56','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:09: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','359197','0.00','0.00','0.00','0.00','0.00','112-142006','112','13CLC','LRN11220240429','2024-09-02','0','','250.00','','006','0','112','015','2024-09-02 16:09:58','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:09: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','359198','0.00','0.00','0.00','0.00','0.00','112-142007','112','13CLC','LRN11220240600','2024-09-02','0','','300.00','','006','0','112','015','2024-09-02 16:10:00','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359199','0.00','0.00','0.00','0.00','0.00','112-142008','112','13CLC','LRN11220240460','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 16:10:02','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359200','0.00','0.00','0.00','0.00','0.00','112-142009','112','13CLC','LRN11220240312','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:10:04','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359201','0.00','0.00','0.00','0.00','0.00','112-142010','112','13CLC','LRN11220240645','2024-09-02','0','','700.00','','006','0','112','015','2024-09-02 16:10:06','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359202','0.00','0.00','0.00','0.00','0.00','112-142011','112','13CLC','LRN11220240582','2024-09-02','0','','300.00','','006','0','112','015','2024-09-02 16:10:08','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359203','0.00','0.00','0.00','0.00','0.00','112-142012','112','13CLC','LRN11220240618','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:10:10','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359204','0.00','0.00','0.00','0.00','0.00','112-142013','112','13CLC','LRN11220240601','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:10:12','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359205','0.00','0.00','0.00','0.00','0.00','112-142014','112','13CLC','LRN11220240526','2024-09-02','0','','300.00','','006','0','112','015','2024-09-02 16:10:14','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359206','0.00','0.00','0.00','0.00','0.00','112-142015','112','13CLC','LRN11220240504','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:10:16','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359207','0.00','0.00','0.00','0.00','0.00','112-142016','112','13CLC','LRN11220240619','2024-09-02','0','','150.00','','006','0','112','015','2024-09-02 16:10:19','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359208','0.00','0.00','0.00','0.00','0.00','112-142017','112','13CLC','LRN11220240456','2024-09-02','0','','100.00','','006','0','112','015','2024-09-02 16:10:21','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359209','0.00','0.00','0.00','0.00','0.00','112-142018','112','13CLC','LRN11220240627','2024-09-02','0','','250.00','','006','0','112','015','2024-09-02 16:10:23','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359210','0.00','0.00','0.00','0.00','0.00','112-142019','112','13CLC','LRN11220240180','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:10:25','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359211','0.00','0.00','0.00','0.00','0.00','112-142020','112','13CLC','LRN11220240591','2024-09-02','0','','165.00','','006','0','112','015','2024-09-02 16:10:27','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359212','0.00','0.00','0.00','0.00','0.00','112-142021','112','13CLC','LRN11220240555','2024-09-02','0','','240.00','','006','0','112','015','2024-09-02 16:10:29','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359213','0.00','0.00','0.00','0.00','0.00','112-142022','112','13CLC','LRN11220240608','2024-09-02','0','','300.00','','006','0','112','015','2024-09-02 16:10:31','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359214','0.00','0.00','0.00','0.00','0.00','112-142023','112','13CLC','LRN11220240446','2024-09-02','0','','100.00','','006','0','112','015','2024-09-02 16:10:33','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359215','0.00','0.00','0.00','0.00','0.00','112-142024','112','13CLC','LRN11220240561','2024-09-02','0','','300.00','','006','0','112','015','2024-09-02 16:10:35','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359216','0.00','0.00','0.00','0.00','0.00','112-142025','112','13CLC','LRN11220240584','2024-09-02','0','','295.00','','006','0','112','015','2024-09-02 16:10:37','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359217','0.00','0.00','0.00','0.00','0.00','112-142026','112','13CLC','LRN11220240583','2024-09-02','0','','210.00','','006','0','112','015','2024-09-02 16:10:39','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359218','0.00','0.00','0.00','0.00','0.00','112-142027','112','13CLC','LRN11220240556','2024-09-02','0','','400.00','','006','0','112','015','2024-09-02 16:10:41','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359219','0.00','0.00','0.00','0.00','0.00','112-142028','112','13CLC','LRN11220240505','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:10:43','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16: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','359220','0.00','0.00','0.00','0.00','0.00','112-142029','112','13CLC','LRN11220240651','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:10:46','0','0000-00-00 00:00:00','0','015','2024-09-02 16:07:58','2024-09-02 16:10: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','359221','0.00','0.00','0.00','0.00','0.00','112-142030','112','3CLC','LRN11220240507','2024-09-02','0','','210.00','','006','0','112','015','2024-09-02 16:43:24','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359222','0.00','0.00','0.00','0.00','0.00','112-142031','112','3CLC','LRN11220240625','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:43:26','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359223','0.00','0.00','0.00','0.00','0.00','112-142032','112','3CLC','LRN11220240624','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:43:28','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359224','0.00','0.00','0.00','0.00','0.00','112-142033','112','3CLC','LRN11220240551','2024-09-02','0','','350.00','','006','0','112','015','2024-09-02 16:43:30','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359225','0.00','0.00','0.00','0.00','0.00','112-142034','112','3CLC','LRN11220240523','2024-09-02','0','','350.00','','006','0','112','015','2024-09-02 16:43:32','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359226','0.00','0.00','0.00','0.00','0.00','112-142035','112','3CLC','LRN11220240631','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:43:34','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359227','0.00','0.00','0.00','0.00','0.00','112-142036','112','3CLC','LRN11220240638','2024-09-02','0','','420.00','','006','0','112','015','2024-09-02 16:43:36','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359228','0.00','0.00','0.00','0.00','0.00','112-142037','112','3CLC','LRN11220240423','2024-09-02','0','','280.00','','006','0','112','015','2024-09-02 16:43:38','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359229','0.00','0.00','0.00','0.00','0.00','112-142038','112','3CLC','LRN11220240477','2024-09-02','0','','2000.00','','006','0','112','015','2024-09-02 16:43:40','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359230','0.00','0.00','0.00','0.00','0.00','112-142039','112','3CLC','LRN11220240632','2024-09-02','0','','1200.00','','006','0','112','015','2024-09-02 16:43:42','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359231','0.00','0.00','0.00','0.00','0.00','112-142040','112','3CLC','LRN11220240503','2024-09-02','0','','400.00','','006','0','112','015','2024-09-02 16:43:44','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359232','0.00','0.00','0.00','0.00','0.00','112-142041','112','3CLC','LRN11220240468','2024-09-02','0','','140.00','','006','0','112','015','2024-09-02 16:43:47','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359233','0.00','0.00','0.00','0.00','0.00','112-142042','112','3CLC','LRN11220240605','2024-09-02','0','','182.00','','006','0','112','015','2024-09-02 16:43:49','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359234','0.00','0.00','0.00','0.00','0.00','112-142043','112','3CLC','LRN11220240606','2024-09-02','0','','380.00','','006','0','112','015','2024-09-02 16:43:51','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359235','0.00','0.00','0.00','0.00','0.00','112-142044','112','3CLC','LRN11220240502','2024-09-02','0','','140.00','','006','0','112','015','2024-09-02 16:43:53','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359236','0.00','0.00','0.00','0.00','0.00','112-142045','112','3CLC','LRN11220240118','2024-09-02','0','','3000.00','','006','0','112','015','2024-09-02 16:43:55','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359237','0.00','0.00','0.00','0.00','0.00','112-142046','112','3CLC','LRN11220240466','2024-09-02','0','','310.00','','006','0','112','015','2024-09-02 16:43:57','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359238','0.00','0.00','0.00','0.00','0.00','112-142047','112','3CLC','LRN11220240521','2024-09-02','0','','380.00','','006','0','112','015','2024-09-02 16:43:59','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:43: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','359239','0.00','0.00','0.00','0.00','0.00','112-142048','112','3CLC','LRN11220240566','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:44:01','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359240','0.00','0.00','0.00','0.00','0.00','112-142049','112','3CLC','LRN11220240588','2024-09-02','0','','600.00','','006','0','112','015','2024-09-02 16:44:03','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359241','0.00','0.00','0.00','0.00','0.00','112-142050','112','3CLC','LRN11220240399','2024-09-02','0','','650.00','','006','0','112','015','2024-09-02 16:44:05','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359242','0.00','0.00','0.00','0.00','0.00','112-142051','112','3CLC','LRN11220240534','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:44:07','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359243','0.00','0.00','0.00','0.00','0.00','112-142052','112','3CLC','LRN11220240497','2024-09-02','0','','350.00','','006','0','112','015','2024-09-02 16:44:09','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359244','0.00','0.00','0.00','0.00','0.00','112-142053','112','3CLC','LRN11220240570','2024-09-02','0','','252.00','','006','0','112','015','2024-09-02 16:44:11','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359245','0.00','0.00','0.00','0.00','0.00','112-142054','112','3CLC','LRN11220240445','2024-09-02','0','','300.00','','006','0','112','015','2024-09-02 16:44:13','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359246','0.00','0.00','0.00','0.00','0.00','112-142055','112','3CLC','LRN11220240546','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:44:16','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359247','0.00','0.00','0.00','0.00','0.00','112-142056','112','3CLC','LRN11220240463','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:44:18','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359248','0.00','0.00','0.00','0.00','0.00','112-142057','112','3CLC','LRN11220240354','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:44:20','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359249','0.00','0.00','0.00','0.00','0.00','112-142058','112','3CLC','LRN11220240444','2024-09-02','0','','200.00','','006','0','112','015','2024-09-02 16:44:22','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359250','0.00','0.00','0.00','0.00','0.00','112-142059','112','3CLC','LRN11220240621','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:44:24','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359251','0.00','0.00','0.00','0.00','0.00','112-142060','112','3CLC','LRN11220240517','2024-09-02','0','','1200.00','','006','0','112','015','2024-09-02 16:44:26','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359252','0.00','0.00','0.00','0.00','0.00','112-142061','112','3CLC','LRN11220240604','2024-09-02','0','','1200.00','','006','0','112','015','2024-09-02 16:44:28','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359253','0.00','0.00','0.00','0.00','0.00','112-142062','112','3CLC','LRN11220240594','2024-09-02','0','','300.00','','006','0','112','015','2024-09-02 16:44:30','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359254','0.00','0.00','0.00','0.00','0.00','112-142063','112','3CLC','LRN11220240607','2024-09-02','0','','1120.00','','006','0','112','015','2024-09-02 16:44:32','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359255','0.00','0.00','0.00','0.00','0.00','112-142064','112','3CLC','LRN11220240439','2024-09-02','0','','400.00','','006','0','112','015','2024-09-02 16:44:34','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359256','0.00','0.00','0.00','0.00','0.00','112-142065','112','3CLC','LRN11220240474','2024-09-02','0','','450.00','','006','0','112','015','2024-09-02 16:44:36','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359257','0.00','0.00','0.00','0.00','0.00','112-142066','112','3CLC','LRN11220240599','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:44:38','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44: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','359258','0.00','0.00','0.00','0.00','0.00','112-142067','112','3CLC','LRN11220240623','2024-09-02','0','','500.00','','006','0','112','015','2024-09-02 16:44:40','0','0000-00-00 00:00:00','0','015','2024-09-02 16:40:59','2024-09-02 16:44:40'); 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-09-02','166','2024-09-02','5707.00','0.00','0.00','','ACTIVE','015','2024-09-02 15:08:42','2024-09-02 15:08:42'); 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-09-02','166','2024-09-02','4177.00','0.00','0.00','','ACTIVE','015','2024-09-02 15:09:13','2024-09-02 15:09:13'); 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','12CLC','Deposited','2024-09-02','166','2024-09-02','3080.00','0.00','0.00','','ACTIVE','015','2024-09-02 15:09:43','2024-09-02 15:09:43'); 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','12CLC','Deposited','2024-09-02','166','2024-09-02','290.00','0.00','0.00','','ACTIVE','015','2024-09-02 15:51:06','2024-09-02 15:51: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-09-02','166','2024-09-02','7260.00','0.00','0.00','','ACTIVE','015','2024-09-02 16:11:20','2024-09-02 16:11:20'); 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','12CLC','Deposited','2024-09-02','166','2024-09-02','320.00','0.00','0.00','','ACTIVE','015','2024-09-02 16:11:49','2024-09-02 16:11:49'); 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-09-02','166','2024-09-02','21364.00','0.00','0.00','','ACTIVE','015','2024-09-02 16:46:23','2024-09-02 16:46:23'); 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='4330.00',sales_amortization='180.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='18000.00',sales_interest_amt='0.00',sales_prin_amt='18000.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='2022-09-30 16:47:18',sales_Timestamp='2024-09-02 14:45:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13670.00',sales_PaymentCutoff='200.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-09-30 16:50:45',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420211016',sales_AssignTo='',sales_PNumber='LRN11420221701',sales_Amt='18000.00',sales_Area='B9',sales_Cycle='5',sales_Released='2022-09-30',sales_Maturity='2023-01-08',sales_BegBalance='18000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420221701' ; 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='11880.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='002B',sales_PostedDate='2022-10-13 16:46:27',sales_Timestamp='2024-09-02 14:45:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='18120.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-10-13 16:49:07',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420190533',sales_AssignTo='',sales_PNumber='LRN11420221710',sales_Amt='30000.00',sales_Area='B2',sales_Cycle='9',sales_Released='2022-10-13',sales_Maturity='2023-01-21',sales_BegBalance='30000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420221710' ; 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='661584.00',sales_prin_amt='3493316.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-01-30 15:33:11',sales_Timestamp='2024-09-02 14:45:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-01-30 17:59:16',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221075',sales_AssignTo='',sales_PNumber='LRN11420231983',sales_Amt='20000.00',sales_Area='B1',sales_Cycle='4',sales_Released='2023-01-30',sales_Maturity='2023-05-10',sales_BegBalance='20000.00',sales_LPD='2024-05-25' WHERE sales_PNumber = 'LRN11420231983' ; 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='6780.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='002B',sales_PostedDate='2023-05-29 17:18:44',sales_Timestamp='2024-09-02 14:45:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10220.00',sales_PaymentCutoff='250.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-05-29 17:28:54',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180394',sales_AssignTo='',sales_PNumber='LRN11420232427',sales_Amt='17000.00',sales_Area='B2',sales_Cycle='6',sales_Released='2023-05-29',sales_Maturity='2023-09-06',sales_BegBalance='17000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420232427' ; 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='3700.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='0.00',sales_prin_amt='20000.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='2024-05-21 12:31:53',sales_Timestamp='2024-09-02 14:45:22',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='16300.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-05-22 14:39:32',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231180',sales_AssignTo='',sales_PNumber='LRN11420243806',sales_Amt='20000.00',sales_Area='B9',sales_Cycle='6',sales_Released='2024-05-21',sales_Maturity='2024-08-29',sales_BegBalance='20000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420243806' ; 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='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='002B',sales_PostedDate='2024-05-31 09:03:26',sales_Timestamp='2024-09-02 14:45:22',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='15000.00',sales_PaymentCutoff='900.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-05-31 09:14:39',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231498',sales_AssignTo='',sales_PNumber='LRN11420243864',sales_Amt='15000.00',sales_Area='B2',sales_Cycle='3',sales_Released='2024-05-31',sales_Maturity='2024-09-08',sales_BegBalance='15000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420243864' ; 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='9900.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='0.00',sales_prin_amt='20000.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='2024-06-19 09:31:48',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10100.00',sales_PaymentCutoff='2000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-06-19 09:59:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180421',sales_AssignTo='040',sales_PNumber='LRN11420243903',sales_Amt='20000.00',sales_Area='B6',sales_Cycle='11',sales_Released='2024-06-19',sales_Maturity='2024-09-27',sales_BegBalance='20000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420243903' ; 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='4500.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='002B',sales_PostedDate='2024-06-19 09:53:19',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20500.00',sales_PaymentCutoff='3500.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-06-19 09:59:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231171',sales_AssignTo='',sales_PNumber='LRN11420243908',sales_Amt='25000.00',sales_Area='B7',sales_Cycle='6',sales_Released='2024-06-19',sales_Maturity='2024-09-27',sales_BegBalance='25000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420243908' ; 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='16000.00',sales_amortization='400.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='40000.00',sales_interest_amt='0.00',sales_prin_amt='40000.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='2024-06-24 09:30:42',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='24000.00',sales_PaymentCutoff='2800.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-06-24 09:45:33',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180075',sales_AssignTo='040',sales_PNumber='LRN11420243917',sales_Amt='40000.00',sales_Area='B6',sales_Cycle='11',sales_Released='2024-06-24',sales_Maturity='2024-10-02',sales_BegBalance='40000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420243917' ; 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='10500.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='002B',sales_PostedDate='2024-06-28 08:58:10',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='19500.00',sales_PaymentCutoff='2100.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-06-28 12:59:01',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420190614',sales_AssignTo='',sales_PNumber='LRN11420243943',sales_Amt='30000.00',sales_Area='B1',sales_Cycle='16',sales_Released='2024-06-28',sales_Maturity='2024-10-06',sales_BegBalance='30000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420243943' ; 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='28200.00',sales_amortization='400.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='40000.00',sales_interest_amt='0.00',sales_prin_amt='40000.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='2024-06-28 08:59:10',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='11800.00',sales_PaymentCutoff='2000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-06-28 12:59:01',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221082',sales_AssignTo='',sales_PNumber='LRN11420243944',sales_Amt='40000.00',sales_Area='B9',sales_Cycle='10',sales_Released='2024-06-28',sales_Maturity='2024-10-06',sales_BegBalance='40000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420243944' ; 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='29200.00',sales_amortization='400.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='40000.00',sales_interest_amt='0.00',sales_prin_amt='40000.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='2024-08-12 09:34:07',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10800.00',sales_PaymentCutoff='2800.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-08-12 09:39:16',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231339',sales_AssignTo='',sales_PNumber='LRN11420244039',sales_Amt='40000.00',sales_Area='B1',sales_Cycle='7',sales_Released='2024-08-12',sales_Maturity='2024-11-20',sales_BegBalance='40000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420244039' ; 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='8100.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='002B',sales_PostedDate='2024-08-15 10:17:50',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1900.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-08-15 14:34:29',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231281',sales_AssignTo='',sales_PNumber='LRN11420244056',sales_Amt='10000.00',sales_Area='B9',sales_Cycle='6',sales_Released='2024-08-15',sales_Maturity='2024-11-23',sales_BegBalance='10000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420244056' ; 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='8300.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='002B',sales_PostedDate='2024-08-20 08:28:25',sales_Timestamp='2024-09-02 14:45:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1700.00',sales_PaymentCutoff='700.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-08-20 08:32:17',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420241525',sales_AssignTo='',sales_PNumber='LRN11420244064',sales_Amt='10000.00',sales_Area='B9',sales_Cycle='3',sales_Released='2024-08-19',sales_Maturity='2024-11-27',sales_BegBalance='10000.00',sales_LPD='2024-09-02' WHERE sales_PNumber = 'LRN11420244064' ; INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13765','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-09-04 16:34:16','027','45000.00','1','AN1122024091875','11220170597','MIRADOR','CARMEN','MERCADO','','','','','0','','0000-00-00','45000.00','2024-09-02','3CLC','006','WITH CHECK','45000.00','015','2024-09-02 13:58:54','0','RENEWAL','015','2024-09-02 13:56:14','112','2024-09-04 16:35:29'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13766','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-09-04 16:34:16','027','30000.00','1','AN1122024091876','11220211794','OCAMPO','ROSALIE','HILAB','','','','','0','','0000-00-00','30000.00','2024-09-02','3CLC','006','WITH CHECK','30000.00','015','2024-09-02 13:59:51','0','RENEWAL','015','2024-09-02 13:57:29','112','2024-09-04 16:35:29');