INSERT INTO `cust_address` (add_ho_date,add_ho_edit,add_timestamp,add_CustID,`add_HouseNo`, `add_Street`, `add_Subd`, `add_Brgy`, `add_City`, `add_Type`, `add_PropertyType`, `add_Since`, `add_Status`, `add_encoded`, `add_encodedDate`, `add_Branch`) VALUES ('','','2024-11-11 07:49:16','5807','206','USUSAN','','34914','CALOOCAN CITY','PRESENT ADDRESS','OWNED','1980','ACTIVE','015','2024-11-09 11:09:03','112'); INSERT INTO `cust_address` (add_ho_date,add_ho_edit,add_timestamp,add_CustID,`add_HouseNo`, `add_Street`, `add_Subd`, `add_Brgy`, `add_City`, `add_Type`, `add_PropertyType`, `add_Since`, `add_Status`, `add_encoded`, `add_encodedDate`, `add_Branch`) VALUES ('','','2024-11-11 07:49:16','5807','','206 USUSAN BARANGAY 28 CALOOC','','34914','CALOOCAN CITY','PERMANENT ADDRESS','OWNED','1980','ACTIVE','015','2024-11-09 11:09:03','112'); INSERT INTO `cust_business` (buss_ho_date,buss_ho_edit,buss_ID,bus_gross_daily_income,bus_net_daily_income,buss_worth_stocks,buss_capitalization,buss_description,buss_Cust_ID,`buss_Branch`, `buss_Type`, `buss_Name`, `buss_Address`, `buss_Started`, `buss_Contact`, `buss_Deleted`, `buss_Encoded`, `buss_EncodedDate`, `buss_timestamp`) VALUES ('','','3909','15000.00','5000.00','20000.00','20000.00','SARI SARI STORE','5807','111','Primary','2','206 USUSAN BARANGAY 28 CALOOCAN CITY','2018-01-01','','0','015','2024-11-09 11:14:51','2024-11-11 07:49: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','376787','0.00','0.00','0.00','0.00','0.00','113-138300','113','TC3','LRN11320245539','2024-11-08','0','','1000.00','','014','0','113','031','2024-11-09 09:32:32','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376788','0.00','0.00','0.00','0.00','0.00','113-138301','113','TC3','LRN11320245495','2024-11-08','0','','200.00','','014','0','113','031','2024-11-09 09:32:34','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376789','0.00','0.00','0.00','0.00','0.00','113-138302','113','TC3','LRN11320245546','2024-11-08','0','','1500.00','','014','0','113','031','2024-11-09 09:32:36','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376790','0.00','0.00','0.00','0.00','0.00','113-138303','113','TC3','LRN11320245499','2024-11-08','0','','1800.00','','014','0','113','031','2024-11-09 09:32:39','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376791','0.00','0.00','0.00','0.00','0.00','113-138304','113','TC3','LRN11320245522','2024-11-08','0','','840.00','','014','0','113','031','2024-11-09 09:32:41','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376792','0.00','0.00','0.00','0.00','0.00','113-138305','113','TC3','LRN11320245473','2024-11-08','0','','700.00','','014','0','113','031','2024-11-09 09:32:43','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376793','0.00','0.00','0.00','0.00','0.00','113-138306','113','TC3','LRN11320245589','2024-11-08','0','','840.00','','014','0','113','031','2024-11-09 09:32:45','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376794','0.00','0.00','0.00','0.00','0.00','113-138307','113','TC3','LRN11320245330','2024-11-08','0','','490.00','','014','0','113','031','2024-11-09 09:32:47','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376795','0.00','0.00','0.00','0.00','0.00','113-138308','113','TC3','LRN11320245422','2024-11-08','0','','500.00','','014','0','113','031','2024-11-09 09:32:49','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376796','0.00','0.00','0.00','0.00','0.00','113-138309','113','TC3','LRN11320245263','2024-11-08','0','','700.00','','014','0','113','031','2024-11-09 09:32:51','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376797','0.00','0.00','0.00','0.00','0.00','113-138310','113','TC3','LRN11320245482','2024-11-08','0','','300.00','','014','0','113','031','2024-11-09 09:32:53','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376798','0.00','0.00','0.00','0.00','0.00','113-138311','113','TC3','LRN11320245447','2024-11-08','0','','1190.00','','014','0','113','031','2024-11-09 09:32:55','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376799','0.00','0.00','0.00','0.00','0.00','113-138312','113','TC3','LRN11320245456','2024-11-08','0','','700.00','','014','0','113','031','2024-11-09 09:32:57','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376800','0.00','0.00','0.00','0.00','0.00','113-138313','113','TC3','LRN11320245311','2024-11-08','0','','1000.00','','014','0','113','031','2024-11-09 09:32:59','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:32: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','376801','0.00','0.00','0.00','0.00','0.00','113-138314','113','TC3','LRN11320245375','2024-11-08','0','','200.00','','014','0','113','031','2024-11-09 09:33:01','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:33: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','376802','0.00','0.00','0.00','0.00','0.00','113-138315','113','TC3','LRN11320245574','2024-11-08','0','','2240.00','','014','0','113','031','2024-11-09 09:33:03','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:33: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','376803','0.00','0.00','0.00','0.00','0.00','113-138316','113','TC3','LRN11320244998','2024-11-08','0','','100.00','','014','0','113','031','2024-11-09 09:33:05','0','0000-00-00 00:00:00','0','031','2024-11-09 09:10:51','2024-11-09 09:33: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','376804','0.00','0.00','0.00','0.00','0.00','113-138317','113','TC2','LRN11320245229','2024-11-08','0','','220.00','','011','0','113','031','2024-11-09 09:29:26','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09: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','376805','0.00','0.00','0.00','0.00','0.00','113-138318','113','TC2','LRN11320245397','2024-11-08','0','','100.00','','011','0','113','031','2024-11-09 09:29:28','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09: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','376806','0.00','0.00','0.00','0.00','0.00','113-138319','113','TC2','LRN11320245415','2024-11-08','0','','700.00','','011','0','113','031','2024-11-09 09:29:30','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376807','0.00','0.00','0.00','0.00','0.00','113-138320','113','TC2','LRN11320245453','2024-11-08','0','','1750.00','','011','0','113','031','2024-11-09 09:29:32','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376808','0.00','0.00','0.00','0.00','0.00','113-138321','113','TC2','LRN11320245063','2024-11-08','0','','2000.00','','011','0','113','031','2024-11-09 09:29:34','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376809','0.00','0.00','0.00','0.00','0.00','113-138322','113','TC2','LRN11320245337','2024-11-08','0','','1500.00','','011','0','113','031','2024-11-09 09:29:36','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376810','0.00','0.00','0.00','0.00','0.00','113-138323','113','TC2','LRN11320245267','2024-11-08','0','','1500.00','','011','0','113','031','2024-11-09 09:29:38','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376811','0.00','0.00','0.00','0.00','0.00','113-138324','113','TC2','LRN11320245545','2024-11-08','0','','280.00','','011','0','113','031','2024-11-09 09:29:40','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376812','0.00','0.00','0.00','0.00','0.00','113-138325','113','TC2','LRN11320245264','2024-11-08','0','','6500.00','','011','0','113','031','2024-11-09 09:29:42','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376813','0.00','0.00','0.00','0.00','0.00','113-138326','113','TC2','LRN11320245532','2024-11-08','0','','210.00','','011','0','113','031','2024-11-09 09:29:44','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376814','0.00','0.00','0.00','0.00','0.00','113-138327','113','TC2','LRN11320245439','2024-11-08','0','','200.00','','011','0','113','031','2024-11-09 09:29:46','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376815','0.00','0.00','0.00','0.00','0.00','113-138328','113','TC2','LRN11320245555','2024-11-08','0','','700.00','','011','0','113','031','2024-11-09 09:29:49','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376816','0.00','0.00','0.00','0.00','0.00','113-138329','113','TC2','LRN11320245566','2024-11-08','0','','420.00','','011','0','113','031','2024-11-09 09:29:51','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376817','0.00','0.00','0.00','0.00','0.00','113-138330','113','TC2','LRN11320245608','2024-11-08','0','','500.00','','011','0','113','031','2024-11-09 09:29:53','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376818','0.00','0.00','0.00','0.00','0.00','113-138331','113','TC2','LRN11320245408','2024-11-08','0','','200.00','','011','0','113','031','2024-11-09 09:29:55','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376819','0.00','0.00','0.00','0.00','0.00','113-138332','113','TC2','LRN11320245334','2024-11-08','0','','350.00','','011','0','113','031','2024-11-09 09:29:57','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376820','0.00','0.00','0.00','0.00','0.00','113-138333','113','TC2','LRN11320245401','2024-11-08','0','','2000.00','','011','0','113','031','2024-11-09 09:29:59','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:29: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','376821','0.00','0.00','0.00','0.00','0.00','113-138334','113','TC2','LRN11320245429','2024-11-08','0','','200.00','','011','0','113','031','2024-11-09 09:30:01','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:30: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','376822','0.00','0.00','0.00','0.00','0.00','113-138335','113','TC2','LRN11320245242','2024-11-08','0','','500.00','','011','0','113','031','2024-11-09 09:30:03','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:30: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','376823','0.00','0.00','0.00','0.00','0.00','113-138336','113','TC2','LRN11320245389','2024-11-08','0','','1000.00','','011','0','113','031','2024-11-09 09:30:05','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:30: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','376824','0.00','0.00','0.00','0.00','0.00','113-138337','113','TC2','LRN11320245510','2024-11-08','0','','700.00','','011','0','113','031','2024-11-09 09:30:07','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:30: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','376825','0.00','0.00','0.00','0.00','0.00','113-138338','113','TC2','LRN11320245321','2024-11-08','0','','3850.00','','011','0','113','031','2024-11-09 09:30:09','0','0000-00-00 00:00:00','0','031','2024-11-09 09:17:54','2024-11-09 09:30: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','376826','0.00','0.00','0.00','0.00','0.00','113-138339','113','TC1','LRN11320245404','2024-11-08','0','','250.00','','004','0','113','031','2024-11-09 09:26:01','0','0000-00-00 00:00:00','0','031','2024-11-09 09:20:17','2024-11-09 09:26: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','376827','0.00','0.00','0.00','0.00','0.00','113-138340','113','TC1','LRN11320245325','2024-11-08','0','','1000.00','','004','0','113','031','2024-11-09 09:26:03','0','0000-00-00 00:00:00','0','031','2024-11-09 09:20:17','2024-11-09 09:26: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','376828','0.00','0.00','0.00','0.00','0.00','113-138341','113','TC1','LRN11320245114','2024-11-08','0','','200.00','','004','0','113','031','2024-11-09 09:26:05','0','0000-00-00 00:00:00','0','031','2024-11-09 09:20:17','2024-11-09 09:26: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','376829','0.00','0.00','0.00','0.00','0.00','113-138342','113','TC1','LRN11320245488','2024-11-08','0','','4000.00','','004','0','113','031','2024-11-09 09:26:07','0','0000-00-00 00:00:00','0','031','2024-11-09 09:20:17','2024-11-09 09:26: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','376830','0.00','0.00','0.00','0.00','0.00','113-138343','113','TC1','LRN11320245366','2024-11-08','0','','1000.00','','004','0','113','031','2024-11-09 09:26:09','0','0000-00-00 00:00:00','0','031','2024-11-09 09:20:17','2024-11-09 09:26: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','376831','0.00','0.00','0.00','0.00','0.00','113-138344','113','TC1','LRN11320245607','2024-11-08','0','','700.00','','004','0','113','031','2024-11-09 09:26:11','0','0000-00-00 00:00:00','0','031','2024-11-09 09:20:17','2024-11-09 09:26: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','376832','0.00','0.00','0.00','0.00','0.00','113-138345','113','TC1','LRN11320245611','2024-11-08','0','','210.00','','004','0','113','031','2024-11-09 09:26:13','0','0000-00-00 00:00:00','0','031','2024-11-09 09:20:17','2024-11-09 09:26: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','376833','0.00','0.00','0.00','0.00','0.00','113-138346','113','TC6','LRN11320245273','2024-11-08','0','','2000.00','','029','0','113','031','2024-11-09 09:35:31','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376834','0.00','0.00','0.00','0.00','0.00','113-138347','113','TC6','LRN11320245342','2024-11-08','0','','700.00','','029','0','113','031','2024-11-09 09:35:33','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376835','0.00','0.00','0.00','0.00','0.00','113-138348','113','TC6','LRN11320245477','2024-11-08','0','','1000.00','','029','0','113','031','2024-11-09 09:35:35','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376836','0.00','0.00','0.00','0.00','0.00','113-138349','113','TC6','LRN11320245442','2024-11-08','0','','200.00','','029','0','113','031','2024-11-09 09:35:37','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376837','0.00','0.00','0.00','0.00','0.00','113-138350','113','TC6','LRN11320245454','2024-11-08','0','','200.00','','029','0','113','031','2024-11-09 09:35:39','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376838','0.00','0.00','0.00','0.00','0.00','113-138351','113','TC6','LRN11320245584','2024-11-08','0','','400.00','','029','0','113','031','2024-11-09 09:35:41','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376839','0.00','0.00','0.00','0.00','0.00','113-138352','113','TC6','LRN11320245604','2024-11-08','0','','1200.00','','029','0','113','031','2024-11-09 09:35:43','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376840','0.00','0.00','0.00','0.00','0.00','113-138353','113','TC6','LRN11320245469','2024-11-08','0','','1500.00','','029','0','113','031','2024-11-09 09:35:46','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376841','0.00','0.00','0.00','0.00','0.00','113-138354','113','TC6','LRN11320244973','2024-11-08','0','','300.00','','029','0','113','031','2024-11-09 09:35:48','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35:48'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376842','0.00','0.00','0.00','0.00','0.00','113-138355','113','TC6','LRN11320245491','2024-11-08','0','','500.00','','029','0','113','031','2024-11-09 09:35:50','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35:50'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376843','0.00','0.00','0.00','0.00','0.00','113-138356','113','TC6','LRN11320245370','2024-11-08','0','','500.00','','029','0','113','031','2024-11-09 09:35:52','0','0000-00-00 00:00:00','0','031','2024-11-09 09:22:28','2024-11-09 09:35: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','376844','0.00','0.00','0.00','0.00','0.00','113-138357','113','TC7','LRN11320245617','2024-11-08','0','','200.00','','041','0','113','031','2024-11-09 09:38:38','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376845','0.00','0.00','0.00','0.00','0.00','113-138358','113','TC7','LRN11320245503','2024-11-08','0','','300.00','','041','0','113','031','2024-11-09 09:38:40','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376846','0.00','0.00','0.00','0.00','0.00','113-138359','113','TC7','LRN11320245360','2024-11-08','0','','550.00','','041','0','113','031','2024-11-09 09:38:42','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376847','0.00','0.00','0.00','0.00','0.00','113-138360','113','TC7','LRN11320245143','2024-11-08','0','','100.00','','041','0','113','031','2024-11-09 09:38:44','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376848','0.00','0.00','0.00','0.00','0.00','113-138361','113','TC7','LRN11320245530','2024-11-08','0','','500.00','','041','0','113','031','2024-11-09 09:38:47','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376849','0.00','0.00','0.00','0.00','0.00','113-138362','113','TC7','LRN11320245536','2024-11-08','0','','170.00','','041','0','113','031','2024-11-09 09:38:49','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376850','0.00','0.00','0.00','0.00','0.00','113-138363','113','TC7','LRN11320245372','2024-11-08','0','','210.00','','041','0','113','031','2024-11-09 09:38:51','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376851','0.00','0.00','0.00','0.00','0.00','113-138364','113','TC7','LRN11320245176','2024-11-08','0','','200.00','','041','0','113','031','2024-11-09 09:38:53','0','0000-00-00 00:00:00','0','031','2024-11-09 09:26:59','2024-11-09 09:38: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','376852','0.00','0.00','0.00','0.00','0.00','113-138365','113','TC5','LRN11320245508','2024-11-08','0','','300.00','','05','0','113','031','2024-11-09 09:34:20','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376853','0.00','0.00','0.00','0.00','0.00','113-138366','113','TC5','LRN11320245479','2024-11-08','0','','500.00','','05','0','113','031','2024-11-09 09:34:22','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376854','0.00','0.00','0.00','0.00','0.00','113-138367','113','TC5','LRN11320245119','2024-11-08','0','','1700.00','','05','0','113','031','2024-11-09 09:34:25','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376855','0.00','0.00','0.00','0.00','0.00','113-138368','113','TC5','LRN11320245407','2024-11-08','0','','800.00','','05','0','113','031','2024-11-09 09:34:27','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376856','0.00','0.00','0.00','0.00','0.00','113-138369','113','TC5','LRN11320245403','2024-11-08','0','','210.00','','05','0','113','031','2024-11-09 09:34:29','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376857','0.00','0.00','0.00','0.00','0.00','113-138370','113','TC5','LRN11320245424','2024-11-08','0','','1000.00','','05','0','113','031','2024-11-09 09:34:31','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376858','0.00','0.00','0.00','0.00','0.00','113-138371','113','TC5','LRN11320245615','2024-11-08','0','','2100.00','','05','0','113','031','2024-11-09 09:34:33','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376859','0.00','0.00','0.00','0.00','0.00','113-138372','113','TC5','LRN11320245542','2024-11-08','0','','310.00','','05','0','113','031','2024-11-09 09:34:35','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376860','0.00','0.00','0.00','0.00','0.00','113-138373','113','TC5','LRN11320244888','2024-11-08','0','','100.00','','05','0','113','031','2024-11-09 09:34:37','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376861','0.00','0.00','0.00','0.00','0.00','113-138374','113','TC5','LRN11320244656','2024-11-08','0','','50.00','','05','0','113','031','2024-11-09 09:34:39','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376862','0.00','0.00','0.00','0.00','0.00','113-138375','113','TC5','LRN11320234217','2024-11-08','0','','200.00','','05','0','113','031','2024-11-09 09:34:41','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376863','0.00','0.00','0.00','0.00','0.00','113-138376','113','TC5','LRN11320245109','2024-11-08','0','','100.00','','05','0','113','031','2024-11-09 09:34:43','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376864','0.00','0.00','0.00','0.00','0.00','113-138377','113','TC5','LRN11320245315','2024-11-08','0','','700.00','','05','0','113','031','2024-11-09 09:34:45','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376865','0.00','0.00','0.00','0.00','0.00','113-138378','113','TC5','LRN11320245350','2024-11-08','0','','140.00','','05','0','113','031','2024-11-09 09:34:47','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376866','0.00','0.00','0.00','0.00','0.00','113-138379','113','TC5','LRN11320245497','2024-11-08','0','','300.00','','05','0','113','031','2024-11-09 09:34:49','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376867','0.00','0.00','0.00','0.00','0.00','113-138380','113','TC5','LRN11320245110','2024-11-08','0','','110.00','','05','0','113','031','2024-11-09 09:34:52','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376868','0.00','0.00','0.00','0.00','0.00','113-138381','113','TC5','LRN11320245580','2024-11-08','0','','600.00','','05','0','113','031','2024-11-09 09:34:54','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376869','0.00','0.00','0.00','0.00','0.00','113-138382','113','TC5','LRN11320245467','2024-11-08','0','','100.00','','05','0','113','031','2024-11-09 09:34:56','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376870','0.00','0.00','0.00','0.00','0.00','113-138383','113','TC5','LRN11320245478','2024-11-08','0','','1400.00','','05','0','113','031','2024-11-09 09:34:58','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:34: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','376871','0.00','0.00','0.00','0.00','0.00','113-138384','113','TC5','LRN11320245363','2024-11-08','0','','3000.00','','05','0','113','031','2024-11-09 09:35:00','0','0000-00-00 00:00:00','0','031','2024-11-09 09:30:23','2024-11-09 09:35: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','376872','0.00','0.00','0.00','0.00','0.00','113-138385','113','TC8','LRN11320245380','2024-11-08','0','','200.00','','038','0','113','031','2024-11-09 09:39:33','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376873','0.00','0.00','0.00','0.00','0.00','113-138386','113','TC8','LRN11320245622','2024-11-08','0','','500.00','','038','0','113','031','2024-11-09 09:39:35','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376874','0.00','0.00','0.00','0.00','0.00','113-138387','113','TC8','LRN11320245430','2024-11-08','0','','1500.00','','038','0','113','031','2024-11-09 09:39:37','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376875','0.00','0.00','0.00','0.00','0.00','113-138388','113','TC8','LRN11320245455','2024-11-08','0','','1400.00','','038','0','113','031','2024-11-09 09:39:39','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376876','0.00','0.00','0.00','0.00','0.00','113-138389','113','TC8','LRN11320245481','2024-11-08','0','','350.00','','038','0','113','031','2024-11-09 09:39:41','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376877','0.00','0.00','0.00','0.00','0.00','113-138390','113','TC8','LRN11320245484','2024-11-08','0','','200.00','','038','0','113','031','2024-11-09 09:39:43','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376878','0.00','0.00','0.00','0.00','0.00','113-138391','113','TC8','LRN11320245558','2024-11-08','0','','250.00','','038','0','113','031','2024-11-09 09:39:45','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376879','0.00','0.00','0.00','0.00','0.00','113-138392','113','TC8','LRN11320245344','2024-11-08','0','','200.00','','038','0','113','031','2024-11-09 09:39:47','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376880','0.00','0.00','0.00','0.00','0.00','113-138393','113','TC8','LRN11320245610','2024-11-08','0','','500.00','','038','0','113','031','2024-11-09 09:39:49','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376881','0.00','0.00','0.00','0.00','0.00','113-138394','113','TC8','LRN11320245623','2024-11-08','0','','1600.00','','038','0','113','031','2024-11-09 09:39:51','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376882','0.00','0.00','0.00','0.00','0.00','113-138395','113','TC8','LRN11320245535','2024-11-08','0','','300.00','','038','0','113','031','2024-11-09 09:39:54','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376883','0.00','0.00','0.00','0.00','0.00','113-138396','113','TC8','LRN11320245376','2024-11-08','0','','900.00','','038','0','113','031','2024-11-09 09:39:56','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376884','0.00','0.00','0.00','0.00','0.00','113-138397','113','TC8','LRN11320245572','2024-11-08','0','','350.00','','038','0','113','031','2024-11-09 09:39:58','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:39: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','376885','0.00','0.00','0.00','0.00','0.00','113-138398','113','TC8','LRN11320245582','2024-11-08','0','','250.00','','038','0','113','031','2024-11-09 09:40:00','0','0000-00-00 00:00:00','0','031','2024-11-09 09:33:18','2024-11-09 09:40: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','376886','0.00','0.00','0.00','0.00','0.00','113-138399','113','TC4','LRN11320245547','2024-11-08','0','','3400.00','','016','0','113','031','2024-11-09 09:37:21','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376887','0.00','0.00','0.00','0.00','0.00','113-138400','113','TC4','LRN11320245373','2024-11-08','0','','200.00','','016','0','113','031','2024-11-09 09:37:24','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376888','0.00','0.00','0.00','0.00','0.00','113-138401','113','TC4','LRN11320245333','2024-11-08','0','','350.00','','016','0','113','031','2024-11-09 09:37:26','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376889','0.00','0.00','0.00','0.00','0.00','113-138402','113','TC4','LRN11320245559','2024-11-08','0','','150.00','','016','0','113','031','2024-11-09 09:37:28','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376890','0.00','0.00','0.00','0.00','0.00','113-138403','113','TC4','LRN11320245565','2024-11-08','0','','300.00','','016','0','113','031','2024-11-09 09:37:30','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376891','0.00','0.00','0.00','0.00','0.00','113-138404','113','TC4','LRN11320245564','2024-11-08','0','','1000.00','','016','0','113','031','2024-11-09 09:37:32','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376892','0.00','0.00','0.00','0.00','0.00','113-138405','113','TC4','LRN11320245345','2024-11-08','0','','200.00','','016','0','113','031','2024-11-09 09:37:34','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376893','0.00','0.00','0.00','0.00','0.00','113-138406','113','TC4','LRN11320245171','2024-11-08','0','','300.00','','016','0','113','031','2024-11-09 09:37:36','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376894','0.00','0.00','0.00','0.00','0.00','113-138407','113','TC4','LRN11320245402','2024-11-08','0','','300.00','','016','0','113','031','2024-11-09 09:37:38','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376895','0.00','0.00','0.00','0.00','0.00','113-138408','113','TC4','LRN11320245208','2024-11-08','0','','100.00','','016','0','113','031','2024-11-09 09:37:40','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376896','0.00','0.00','0.00','0.00','0.00','113-138409','113','TC4','LRN11320245302','2024-11-08','0','','50.00','','016','0','113','031','2024-11-09 09:37:42','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376897','0.00','0.00','0.00','0.00','0.00','113-138410','113','TC4','LRN11320245295','2024-11-08','0','','7000.00','','016','0','113','031','2024-11-09 09:37:44','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376898','0.00','0.00','0.00','0.00','0.00','113-138411','113','TC4','LRN11320245425','2024-11-08','0','','350.00','','016','0','113','031','2024-11-09 09:37:46','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376899','0.00','0.00','0.00','0.00','0.00','113-138412','113','TC4','LRN11320244986','2024-11-08','0','','200.00','','016','0','113','031','2024-11-09 09:37:48','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37:48'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376900','0.00','0.00','0.00','0.00','0.00','113-138413','113','TC4','LRN11320245591','2024-11-08','0','','3500.00','','016','0','113','031','2024-11-09 09:37:50','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37:50'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376901','0.00','0.00','0.00','0.00','0.00','113-138414','113','TC4','LRN11320245587','2024-11-08','0','','1000.00','','016','0','113','031','2024-11-09 09:37:53','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376902','0.00','0.00','0.00','0.00','0.00','113-138415','113','TC4','LRN11320245548','2024-11-08','0','','200.00','','016','0','113','031','2024-11-09 09:37:55','0','0000-00-00 00:00:00','0','031','2024-11-09 09:36:32','2024-11-09 09:37: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','376903','0.00','0.00','0.00','0.00','0.00','112-149746','112','12CLC','LRN11220240649','2024-11-09','0','','100.00','','002','0','112','015','2024-11-09 14:07:42','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14:07:42'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376904','0.00','0.00','0.00','0.00','0.00','112-149747','112','12CLC','LRN11220240614','2024-11-09','0','','100.00','','002','0','112','015','2024-11-09 14:07:44','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14:07: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','376905','0.00','0.00','0.00','0.00','0.00','112-149748','112','12CLC','LRN11220240710','2024-11-09','0','','200.00','','002','0','112','015','2024-11-09 14:07:46','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14:07: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','376906','0.00','0.00','0.00','0.00','0.00','112-149749','112','12CLC','LRN11220240626','2024-11-09','0','','190.00','','002','0','112','015','2024-11-09 14:07:48','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14:07:48'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376907','0.00','0.00','0.00','0.00','0.00','112-149750','112','12CLC','LRN11220240629','2024-11-09','0','','150.00','','002','0','112','015','2024-11-09 14:07:50','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14:07:50'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376908','0.00','0.00','0.00','0.00','0.00','112-149751','112','12CLC','LRN11220240679','2024-11-09','0','','140.00','','002','0','112','015','2024-11-09 14:07:52','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14:07: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','376909','0.00','0.00','0.00','0.00','0.00','112-149752','112','12CLC','LRN11220240673','2024-11-09','0','','150.00','','002','0','112','015','2024-11-09 14:07:54','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14:07: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','376910','0.00','0.00','0.00','0.00','0.00','112-149753','112','12CLC','LRN11220240648','2024-11-09','0','','170.00','','002','0','112','015','2024-11-09 14:07:57','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14: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','376911','0.00','0.00','0.00','0.00','0.00','112-149754','112','12CLC','LRN11220240717','2024-11-09','0','','200.00','','002','0','112','015','2024-11-09 14:07:59','0','0000-00-00 00:00:00','0','015','2024-11-09 14:06:30','2024-11-09 14: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','376912','0.00','0.00','0.00','0.00','0.00','112-149755','112','4CLC','LRN11220240677','2024-11-09','0','','280.00','','004i','0','112','015','2024-11-09 14:15:59','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:15: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','376913','0.00','0.00','0.00','0.00','0.00','112-149756','112','4CLC','LRN11220240699','2024-11-09','0','','1460.00','','004i','0','112','015','2024-11-09 14:16:01','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376914','0.00','0.00','0.00','0.00','0.00','112-149757','112','4CLC','LRN11220240725','2024-11-09','0','','250.00','','004i','0','112','015','2024-11-09 14:16:03','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376915','0.00','0.00','0.00','0.00','0.00','112-149758','112','4CLC','LRN11220240611','2024-11-09','0','','500.00','','004i','0','112','015','2024-11-09 14:16:06','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376916','0.00','0.00','0.00','0.00','0.00','112-149759','112','4CLC','LRN11220240612','2024-11-09','0','','500.00','','004i','0','112','015','2024-11-09 14:16:08','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376917','0.00','0.00','0.00','0.00','0.00','112-149760','112','4CLC','LRN11220240640','2024-11-09','0','','500.00','','004i','0','112','015','2024-11-09 14:16:10','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376918','0.00','0.00','0.00','0.00','0.00','112-149761','112','4CLC','LRN11220240660','2024-11-09','0','','1000.00','','004i','0','112','015','2024-11-09 14:16:12','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376919','0.00','0.00','0.00','0.00','0.00','112-149762','112','4CLC','LRN11220240644','2024-11-09','0','','275.00','','004i','0','112','015','2024-11-09 14:16:14','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376920','0.00','0.00','0.00','0.00','0.00','112-149763','112','4CLC','LRN11220240727','2024-11-09','0','','350.00','','004i','0','112','015','2024-11-09 14:16:16','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376921','0.00','0.00','0.00','0.00','0.00','112-149764','112','4CLC','LRN11220240338','2024-11-09','0','','300.00','','004i','0','112','015','2024-11-09 14:16:18','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376922','0.00','0.00','0.00','0.00','0.00','112-149765','112','4CLC','LRN11220232442','2024-11-09','0','','50.00','','004i','0','112','015','2024-11-09 14:16:20','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376923','0.00','0.00','0.00','0.00','0.00','112-149766','112','4CLC','LRN11220240635','2024-11-09','0','','3440.00','','004i','0','112','015','2024-11-09 14:16:22','0','0000-00-00 00:00:00','0','015','2024-11-09 14:14:53','2024-11-09 14:16: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','376924','0.00','0.00','0.00','0.00','0.00','112-149767','112','2CLC','LRN11220240756','2024-11-09','0','','210.00','','002','0','112','015','2024-11-09 14:28:27','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 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','376925','0.00','0.00','0.00','0.00','0.00','112-149768','112','2CLC','LRN11220240493','2024-11-09','0','','100.00','','002','0','112','015','2024-11-09 14:28:29','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 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','376926','0.00','0.00','0.00','0.00','0.00','112-149769','112','2CLC','LRN11220240413','2024-11-09','0','','320.00','','002','0','112','015','2024-11-09 14:28:31','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 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','376927','0.00','0.00','0.00','0.00','0.00','112-149770','112','2CLC','LRN11220240284','2024-11-09','0','','100.00','','002','0','112','015','2024-11-09 14:28:33','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 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','376928','0.00','0.00','0.00','0.00','0.00','112-149771','112','2CLC','LRN11220240789','2024-11-09','0','','160.00','','002','0','112','015','2024-11-09 14:28:35','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 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','376929','0.00','0.00','0.00','0.00','0.00','112-149772','112','2CLC','LRN11220240768','2024-11-09','0','','240.00','','002','0','112','015','2024-11-09 14:28:37','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 14:28: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','376930','0.00','0.00','0.00','0.00','0.00','112-149773','112','2CLC','LRN11220240641','2024-11-09','0','','220.00','','002','0','112','015','2024-11-09 14:28:39','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 14:28: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','376931','0.00','0.00','0.00','0.00','0.00','112-149774','112','2CLC','LRN11220240703','2024-11-09','0','','80.00','','002','0','112','015','2024-11-09 14:28:41','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 14:28: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','376932','0.00','0.00','0.00','0.00','0.00','112-149775','112','2CLC','LRN11220240780','2024-11-09','0','','400.00','','002','0','112','015','2024-11-09 14:28:43','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 14:28: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','376933','0.00','0.00','0.00','0.00','0.00','112-149776','112','2CLC','LRN11220240714','2024-11-09','0','','170.00','','002','0','112','015','2024-11-09 14:28:45','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 14:28: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','376934','0.00','0.00','0.00','0.00','0.00','112-149777','112','2CLC','LRN11220240684','2024-11-09','0','','330.00','','002','0','112','015','2024-11-09 14:28:48','0','0000-00-00 00:00:00','0','015','2024-11-09 14:24:43','2024-11-09 14:28:48'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376935','0.00','0.00','0.00','0.00','0.00','112-149778','112','13CLC','LRN11220240647','2024-11-09','0','','1200.00','','006','0','112','015','2024-11-09 15:25:01','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376936','0.00','0.00','0.00','0.00','0.00','112-149779','112','13CLC','LRN11220240767','2024-11-09','0','','200.00','','006','0','112','015','2024-11-09 15:25:03','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376937','0.00','0.00','0.00','0.00','0.00','112-149780','112','13CLC','LRN11220240470','2024-11-09','0','','100.00','','006','0','112','015','2024-11-09 15:25:05','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376938','0.00','0.00','0.00','0.00','0.00','112-149781','112','13CLC','LRN11220240667','2024-11-09','0','','300.00','','006','0','112','015','2024-11-09 15:25:07','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376939','0.00','0.00','0.00','0.00','0.00','112-149782','112','13CLC','LRN11220240600','2024-11-09','0','','600.00','','006','0','112','015','2024-11-09 15:25:09','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376940','0.00','0.00','0.00','0.00','0.00','112-149783','112','13CLC','LRN11220240645','2024-11-09','0','','1000.00','','006','0','112','015','2024-11-09 15:25:11','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376941','0.00','0.00','0.00','0.00','0.00','112-149784','112','13CLC','LRN11220240586','2024-11-09','0','','150.00','','006','0','112','015','2024-11-09 15:25:13','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376942','0.00','0.00','0.00','0.00','0.00','112-149785','112','13CLC','LRN11220240601','2024-11-09','0','','200.00','','006','0','112','015','2024-11-09 15:25:15','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25:15'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376943','0.00','0.00','0.00','0.00','0.00','112-149786','112','13CLC','LRN11220240672','2024-11-09','0','','1200.00','','006','0','112','015','2024-11-09 15:25:17','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','376944','0.00','0.00','0.00','0.00','0.00','112-149787','112','13CLC','LRN11220240479','2024-11-09','0','','200.00','','006','0','112','015','2024-11-09 15:25:19','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376945','0.00','0.00','0.00','0.00','0.00','112-149788','112','13CLC','LRN11220240321','2024-11-09','0','','300.00','','006','0','112','015','2024-11-09 15:25:22','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376946','0.00','0.00','0.00','0.00','0.00','112-149789','112','13CLC','LRN11220240784','2024-11-09','0','','840.00','','006','0','112','015','2024-11-09 15:25:24','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376947','0.00','0.00','0.00','0.00','0.00','112-149790','112','13CLC','LRN11220240576','2024-11-09','0','','2900.00','','006','0','112','015','2024-11-09 15:25:26','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376948','0.00','0.00','0.00','0.00','0.00','112-149791','112','13CLC','LRN11220240785','2024-11-09','0','','250.00','','006','0','112','015','2024-11-09 15:25:28','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376949','0.00','0.00','0.00','0.00','0.00','112-149792','112','13CLC','LRN11220240718','2024-11-09','0','','500.00','','006','0','112','015','2024-11-09 15:25:30','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376950','0.00','0.00','0.00','0.00','0.00','112-149793','112','13CLC','LRN11220240651','2024-11-09','0','','250.00','','006','0','112','015','2024-11-09 15:25:32','0','0000-00-00 00:00:00','0','015','2024-11-09 15:23:38','2024-11-09 15:25: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','376951','0.00','0.00','0.00','0.00','0.00','112-149794','112','3CLC','LRN11220240734','2024-11-09','0','','1000.00','','006','0','112','015','2024-11-09 15:42:01','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376952','0.00','0.00','0.00','0.00','0.00','112-149795','112','3CLC','LRN11220240736','2024-11-09','0','','210.00','','006','0','112','015','2024-11-09 15:42:03','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376953','0.00','0.00','0.00','0.00','0.00','112-149796','112','3CLC','LRN11220240625','2024-11-09','0','','100.00','','006','0','112','015','2024-11-09 15:42:05','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376954','0.00','0.00','0.00','0.00','0.00','112-149797','112','3CLC','LRN11220240624','2024-11-09','0','','300.00','','006','0','112','015','2024-11-09 15:42:07','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376955','0.00','0.00','0.00','0.00','0.00','112-149798','112','3CLC','LRN11220240631','2024-11-09','0','','500.00','','006','0','112','015','2024-11-09 15:42:09','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376956','0.00','0.00','0.00','0.00','0.00','112-149799','112','3CLC','LRN11220240685','2024-11-09','0','','1800.00','','006','0','112','015','2024-11-09 15:42:11','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376957','0.00','0.00','0.00','0.00','0.00','112-149800','112','3CLC','LRN11220240140','2024-11-09','0','','100.00','','006','0','112','015','2024-11-09 15:42:14','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376958','0.00','0.00','0.00','0.00','0.00','112-149801','112','3CLC','LRN11220232286','2024-11-09','0','','100.00','','006','0','112','015','2024-11-09 15:42:16','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376959','0.00','0.00','0.00','0.00','0.00','112-149802','112','3CLC','LRN11220240487','2024-11-09','0','','200.00','','006','0','112','015','2024-11-09 15:42:18','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376960','0.00','0.00','0.00','0.00','0.00','112-149803','112','3CLC','LRN11220240089','2024-11-09','0','','100.00','','006','0','112','015','2024-11-09 15:42:20','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376961','0.00','0.00','0.00','0.00','0.00','112-149804','112','3CLC','LRN11220240666','2024-11-09','0','','300.00','','006','0','112','015','2024-11-09 15:42:22','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376962','0.00','0.00','0.00','0.00','0.00','112-149805','112','3CLC','LRN11220240559','2024-11-09','0','','100.00','','006','0','112','015','2024-11-09 15:42:24','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376963','0.00','0.00','0.00','0.00','0.00','112-149806','112','3CLC','LRN11220240706','2024-11-09','0','','200.00','','006','0','112','015','2024-11-09 15:42:26','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376964','0.00','0.00','0.00','0.00','0.00','112-149807','112','3CLC','LRN11220240588','2024-11-09','0','','2400.00','','006','0','112','015','2024-11-09 15:42:28','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376965','0.00','0.00','0.00','0.00','0.00','112-149808','112','3CLC','LRN11220240766','2024-11-09','0','','500.00','','006','0','112','015','2024-11-09 15:42:30','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376966','0.00','0.00','0.00','0.00','0.00','112-149809','112','3CLC','LRN11220240743','2024-11-09','0','','350.00','','006','0','112','015','2024-11-09 15:42:32','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376967','0.00','0.00','0.00','0.00','0.00','112-149810','112','3CLC','LRN11220240698','2024-11-09','0','','300.00','','006','0','112','015','2024-11-09 15:42:34','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376968','0.00','0.00','0.00','0.00','0.00','112-149811','112','3CLC','LRN11220240762','2024-11-09','0','','100.00','','006','0','112','015','2024-11-09 15:42:36','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376969','0.00','0.00','0.00','0.00','0.00','112-149812','112','3CLC','LRN11220240731','2024-11-09','0','','500.00','','006','0','112','015','2024-11-09 15:42:38','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376970','0.00','0.00','0.00','0.00','0.00','112-149813','112','3CLC','LRN11220240697','2024-11-09','0','','250.00','','006','0','112','015','2024-11-09 15:42:40','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376971','0.00','0.00','0.00','0.00','0.00','112-149814','112','3CLC','LRN11220240694','2024-11-09','0','','200.00','','006','0','112','015','2024-11-09 15:42:43','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376972','0.00','0.00','0.00','0.00','0.00','112-149815','112','3CLC','LRN11220240726','2024-11-09','0','','240.00','','006','0','112','015','2024-11-09 15:42:45','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376973','0.00','0.00','0.00','0.00','0.00','112-149816','112','3CLC','LRN11220240621','2024-11-09','0','','500.00','','006','0','112','015','2024-11-09 15:42:47','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376974','0.00','0.00','0.00','0.00','0.00','112-149817','112','3CLC','LRN11220240787','2024-11-09','0','','3500.00','','006','0','112','015','2024-11-09 15:42:49','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376975','0.00','0.00','0.00','0.00','0.00','112-149818','112','3CLC','LRN11220240607','2024-11-09','0','','1120.00','','006','0','112','015','2024-11-09 15:42:51','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376976','0.00','0.00','0.00','0.00','0.00','112-149819','112','3CLC','LRN11220240704','2024-11-09','0','','700.00','','006','0','112','015','2024-11-09 15:42:53','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376977','0.00','0.00','0.00','0.00','0.00','112-149820','112','3CLC','LRN11220240599','2024-11-09','0','','1000.00','','006','0','112','015','2024-11-09 15:42:55','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42: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','376978','0.00','0.00','0.00','0.00','0.00','112-149821','112','3CLC','LRN11220240782','2024-11-09','0','','500.00','','006','0','112','015','2024-11-09 15:42:57','0','0000-00-00 00:00:00','0','015','2024-11-09 15:40:57','2024-11-09 15:42:57'); INSERT INTO `cust_contactno` (contact_ho_date,contact_ho_edit,contact_Cust_ID,`contact_Branch`, `contract_Type`, `contact_Number`, `contact_Status`, `contact_Encoded`, `contact_EncodedDate`, `contact_timestamp`) VALUES ('','','5807','112','CELLPHONE NO','09702159858','ACTIVE','015','2024-11-09 11:09:03','2024-11-11 07:49:16'); INSERT INTO `cust_information` (cust_ho_date,cust_ho_edit,cust_picture,cust_BirthPlace,cust_Gender,cust_CivilStatus,cust_Cycle,cust_Status,cust_encoded,cust_encodeDate,cust_timestamp,cust_ID,`cust_Branch`, `cust_Code`, `cust_LastName`, `cust_FirstName`, `cust_MiddleName`, `cust_Suffix`, `cust_MaidenName`, `cust_NickName`, `cust_Area`, `cust_Nationality`, `cust_Bday`) VALUES ('','','0000-00-00 00:00:00','CALOOCAN CITY','FEMALE','MARRIED','1','ACTIVE','015','2024-11-09 11:09:03','2024-11-13 11:41:38','5807','112','11220242399','MENDOZA','OLIVIA','AMICAN','','AMICAN','OLIVE','2CLC','FILIPINO','1984-02-12'); INSERT INTO `cust_spouse` (spouse_ho_date,spouse_ho_edit,spouse_ID,spouse_BirthPlace,spouse_ContactNo,spouse_Occupation,spouse_Encoded,spouse_EncodedDate,spouse_timestamp,spouse_CustID,spouse_Branch,spouse_LastName,spouse_FirstName,spouse_MiddleName,spouse_Suffix,spouse_NickName,spouse_MaidenName,spouse_Address,`spouse_Bday`) VALUES ('','','2351','CALOOCAN CITY','09702159858','PRODUCTION STAFF','015','2024-11-09 11:12:53','2024-11-11 07:49:16','5807','112','MENDOZA','SONNY BOY','SUANO','','nickname','','206 USUSAN BARANGAY 28 CALOOCAN CITY','0000-00-00'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC1','Deposited','2024-11-08','167','2024-11-08','7360.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:40:31','2024-11-09 09:40:31'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC2','Deposited','2024-11-08','168','2024-11-08','25380.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:40:46','2024-11-09 09:40:46'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC3','Deposited','2024-11-08','167','2024-11-08','14300.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:40:53','2024-11-09 09:40:53'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC4','Deposited','2024-11-08','168','2024-11-08','18600.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:41:17','2024-11-09 09:41:17'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC5','Deposited','2024-11-08','167','2024-11-08','13720.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:41:31','2024-11-09 09:41:31'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC6','Deposited','2024-11-08','168','2024-11-08','8500.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:41:45','2024-11-09 09:41:45'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC7','Deposited','2024-11-08','167','2024-11-08','2230.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:41:59','2024-11-09 09:41:59'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC8','Deposited','2024-11-08','168','2024-11-08','8500.00','0.00','0.00','','ACTIVE','031','2024-11-09 09:42:13','2024-11-09 09:42: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-11-09','166','2024-11-09','1400.00','0.00','0.00','','ACTIVE','015','2024-11-09 14:08:37','2024-11-09 14:08:37'); 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-11-09','166','2024-11-09','8905.00','0.00','0.00','','ACTIVE','015','2024-11-09 14:17:57','2024-11-09 14:17:57'); 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-11-09','166','2024-11-09','2330.00','0.00','0.00','','ACTIVE','015','2024-11-09 14:22:40','2024-11-09 14:22: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','13CLC','Deposited','2024-11-09','166','2024-11-09','10190.00','0.00','0.00','','ACTIVE','015','2024-11-09 15:18:26','2024-11-09 15:18:26'); 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-11-09','166','2024-11-09','17170.00','0.00','0.00','','ACTIVE','015','2024-11-09 15:37:24','2024-11-09 15:37:24'); 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='6850.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='031',sales_PostedDate='2023-11-29 14:39:10',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13150.00',sales_PaymentCutoff='200.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-11-29 16:03:23',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211109',sales_AssignTo='05',sales_PNumber='LRN11320234217',sales_Amt='20000.00',sales_Area='TC5',sales_Cycle='11',sales_Released='2023-11-29',sales_Maturity='2024-03-08',sales_BegBalance='20000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320234217' ; 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='8030.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-03-13 14:25:23',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1970.00',sales_PaymentCutoff='50.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-03-13 16:00:40',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211043',sales_AssignTo='05',sales_PNumber='LRN11320244656',sales_Amt='10000.00',sales_Area='TC5',sales_Cycle='7',sales_Released='2024-03-13',sales_Maturity='2024-06-21',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320244656' ; 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='380.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='38000.00',sales_interest_amt='-1064281.60',sales_prin_amt='-5549478.40',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-03-21 14:14:24',sales_Timestamp='2024-11-09 09:43:30',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='38000.00',sales_PaymentCutoff='2660.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-03-21 16:27:34',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220123',sales_AssignTo='004',sales_PNumber='LRN11320244697',sales_Amt='38000.00',sales_Area='TC1',sales_Cycle='8',sales_Released='2024-03-21',sales_Maturity='2024-06-29',sales_BegBalance='38000.00',sales_LPD='2024-08-02' WHERE sales_PNumber = 'LRN11320244697' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='170.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='17000.00',sales_interest_amt='-18688.00',sales_prin_amt='-81112.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-04-05 16:18:55',sales_Timestamp='2024-11-09 09:43:30',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='17000.00',sales_PaymentCutoff='10750.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-04-05 16:50:03',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211007',sales_AssignTo='004',sales_PNumber='LRN11320244768',sales_Amt='17000.00',sales_Area='TC1',sales_Cycle='14',sales_Released='2024-04-05',sales_Maturity='2024-07-14',sales_BegBalance='17000.00',sales_LPD='2024-08-02' WHERE sales_PNumber = 'LRN11320244768' ; 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='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='-65408.00',sales_prin_amt='-318392.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-04-30 16:46:02',sales_Timestamp='2024-11-09 09:43:30',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='25000.00',sales_PaymentCutoff='9450.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-04-30 17:24:17',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180478',sales_AssignTo='016',sales_PNumber='LRN11320244877',sales_Amt='25000.00',sales_Area='TC4',sales_Cycle='1',sales_Released='2024-04-30',sales_Maturity='2024-08-08',sales_BegBalance='25000.00',sales_LPD='2024-08-02' WHERE sales_PNumber = 'LRN11320244877' ; 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='6110.00',sales_amortization='130.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='13000.00',sales_interest_amt='0.00',sales_prin_amt='13000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-05-29 14:47:53',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6890.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-05-29 15:54:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220175',sales_AssignTo='029',sales_PNumber='LRN11320244973',sales_Amt='13000.00',sales_Area='TC6',sales_Cycle='6',sales_Released='2024-05-29',sales_Maturity='2024-09-06',sales_BegBalance='13000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320244973' ; 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='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='031',sales_PostedDate='2024-06-24 14:42:36',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='2000.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-06-24 16:29:35',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180115',sales_AssignTo='011',sales_PNumber='LRN11320245063',sales_Amt='20000.00',sales_Area='TC2',sales_Cycle='2',sales_Released='2024-06-24',sales_Maturity='2024-10-02',sales_BegBalance='20000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245063' ; 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='2290.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-06-28 16:04:05',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9710.00',sales_PaymentCutoff='1700.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-06-28 16:58:34',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230369',sales_AssignTo='05',sales_PNumber='LRN11320245119',sales_Amt='12000.00',sales_Area='TC5',sales_Cycle='4',sales_Released='2024-06-28',sales_Maturity='2024-10-06',sales_BegBalance='12000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245119' ; 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='7900.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-06-28 16:58:02',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2100.00',sales_PaymentCutoff='200.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-06-28 16:58:34',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211007',sales_AssignTo='004',sales_PNumber='LRN11320245114',sales_Amt='10000.00',sales_Area='TC1',sales_Cycle='15',sales_Released='2024-06-28',sales_Maturity='2024-10-06',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245114' ; 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='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='031',sales_PostedDate='2024-07-17 15:19:05',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-07-17 15:46:44',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180027',sales_AssignTo='016',sales_PNumber='LRN11320245171',sales_Amt='20000.00',sales_Area='TC4',sales_Cycle='9',sales_Released='2024-07-17',sales_Maturity='2024-10-25',sales_BegBalance='20000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245171' ; 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='950.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-07-30 14:27:36',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9050.00',sales_PaymentCutoff='220.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-07-30 16:08:02',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230303',sales_AssignTo='011',sales_PNumber='LRN11320245229',sales_Amt='10000.00',sales_Area='TC2',sales_Cycle='4',sales_Released='2024-07-30',sales_Maturity='2024-11-07',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245229' ; 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='800.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-07-31 15:11:25',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9200.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-07-31 16:53:37',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211141',sales_AssignTo='011',sales_PNumber='LRN11320245242',sales_Amt='10000.00',sales_Area='TC2',sales_Cycle='11',sales_Released='2024-07-31',sales_Maturity='2024-11-08',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245242' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='330.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='33000.00',sales_interest_amt='0.00',sales_prin_amt='33000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-09 14:19:29',sales_Timestamp='2024-11-09 09:43:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='33000.00',sales_PaymentCutoff='6500.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-09 15:33:11',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180291',sales_AssignTo='011',sales_PNumber='LRN11320245264',sales_Amt='33000.00',sales_Area='TC2',sales_Cycle='17',sales_Released='2024-08-09',sales_Maturity='2024-11-17',sales_BegBalance='33000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245264' ; 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='3000.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-12 15:11:43',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7000.00',sales_PaymentCutoff='700.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-12 15:44:37',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180100',sales_AssignTo='014',sales_PNumber='LRN11320245263',sales_Amt='10000.00',sales_Area='TC3',sales_Cycle='11',sales_Released='2024-08-08',sales_Maturity='2024-11-16',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245263' ; 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='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-20 15:11:54',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='25000.00',sales_PaymentCutoff='7000.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-20 15:50:31',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320190808',sales_AssignTo='016',sales_PNumber='LRN11320245295',sales_Amt='25000.00',sales_Area='TC4',sales_Cycle='15',sales_Released='2024-08-20',sales_Maturity='2024-11-28',sales_BegBalance='25000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245295' ; 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='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-27 16:16:22',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='25000.00',sales_PaymentCutoff='3850.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-27 16:36:41',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230250',sales_AssignTo='011',sales_PNumber='LRN11320245321',sales_Amt='25000.00',sales_Area='TC2',sales_Cycle='6',sales_Released='2024-08-27',sales_Maturity='2024-12-05',sales_BegBalance='25000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245321' ; 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='12500.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='031',sales_PostedDate='2024-08-29 16:24:48',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7500.00',sales_PaymentCutoff='1500.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-29 17:09:08',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180269',sales_AssignTo='011',sales_PNumber='LRN11320245337',sales_Amt='20000.00',sales_Area='TC2',sales_Cycle='16',sales_Released='2024-08-29',sales_Maturity='2024-12-07',sales_BegBalance='20000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245337' ; 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='7900.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-29 16:31:11',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2100.00',sales_PaymentCutoff='200.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-29 17:09:08',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180328',sales_AssignTo='016',sales_PNumber='LRN11320245345',sales_Amt='10000.00',sales_Area='TC4',sales_Cycle='4',sales_Released='2024-08-29',sales_Maturity='2024-12-07',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245345' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-30 16:26:43',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='3000.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-30 17:18:19',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230403',sales_AssignTo='05',sales_PNumber='LRN11320245363',sales_Amt='10000.00',sales_Area='TC5',sales_Cycle='3',sales_Released='2024-08-30',sales_Maturity='2024-12-08',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245363' ; 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='5170.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-30 16:28:01',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6830.00',sales_PaymentCutoff='550.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-30 17:18:19',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220155',sales_AssignTo='',sales_PNumber='LRN11320245360',sales_Amt='12000.00',sales_Area='TC7',sales_Cycle='8',sales_Released='2024-08-30',sales_Maturity='2024-12-08',sales_BegBalance='12000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245360' ; 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='3250.00',sales_amortization='110.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='11000.00',sales_interest_amt='0.00',sales_prin_amt='11000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-08-30 16:38:57',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7750.00',sales_PaymentCutoff='900.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-08-30 17:18:19',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220146',sales_AssignTo='038',sales_PNumber='LRN11320245376',sales_Amt='11000.00',sales_Area='TC8',sales_Cycle='9',sales_Released='2024-08-30',sales_Maturity='2024-12-08',sales_BegBalance='11000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245376' ; 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='10780.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='031',sales_PostedDate='2024-09-19 14:50:26',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4220.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-09-19 15:15:15',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230351',sales_AssignTo='014',sales_PNumber='LRN11320245422',sales_Amt='15000.00',sales_Area='TC3',sales_Cycle='6',sales_Released='2024-09-19',sales_Maturity='2024-12-28',sales_BegBalance='15000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245422' ; 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='14000.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='015',sales_PostedDate='2024-09-20 12:13:18',sales_Timestamp='2024-11-09 08:13:55',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='11000.00',sales_PaymentCutoff='1750.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-09-20 12:17:37',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232153',sales_AssignTo='004i',sales_PNumber='LRN11220240676',sales_Amt='25000.00',sales_Area='4CLC',sales_Cycle='7',sales_Released='2024-09-20',sales_Maturity='2024-12-29',sales_BegBalance='25000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11220240676' ; 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='14400.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='031',sales_PostedDate='2024-09-26 15:54:27',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5600.00',sales_PaymentCutoff='1400.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-09-26 16:16:58',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230374',sales_AssignTo='038',sales_PNumber='LRN11320245455',sales_Amt='20000.00',sales_Area='TC8',sales_Cycle='6',sales_Released='2024-09-26',sales_Maturity='2025-01-04',sales_BegBalance='20000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245455' ; 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='5800.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-09-26 16:08:37',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4200.00',sales_PaymentCutoff='700.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-09-26 16:16:58',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320240521',sales_AssignTo='014',sales_PNumber='LRN11320245456',sales_Amt='10000.00',sales_Area='TC3',sales_Cycle='1',sales_Released='2024-09-26',sales_Maturity='2025-01-04',sales_BegBalance='10000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245456' ; 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='12900.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='031',sales_PostedDate='2024-09-30 17:50:19',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2100.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-09-30 18:48:23',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220193',sales_AssignTo='',sales_PNumber='LRN11320245503',sales_Amt='15000.00',sales_Area='TC7',sales_Cycle='8',sales_Released='2024-09-30',sales_Maturity='2025-01-08',sales_BegBalance='15000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245503' ; 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='10060.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-10-17 14:26:28',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1940.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-10-17 15:02:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220033',sales_AssignTo='038',sales_PNumber='LRN11320245535',sales_Amt='12000.00',sales_Area='TC8',sales_Cycle='11',sales_Released='2024-10-17',sales_Maturity='2025-01-25',sales_BegBalance='12000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245535' ; 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='25270.00',sales_amortization='320.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='32000.00',sales_interest_amt='0.00',sales_prin_amt='32000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-10-25 13:51:18',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6730.00',sales_PaymentCutoff='2240.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-10-25 14:01:10',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320240499',sales_AssignTo='014',sales_PNumber='LRN11320245574',sales_Amt='32000.00',sales_Area='TC3',sales_Cycle='2',sales_Released='2024-10-25',sales_Maturity='2025-02-02',sales_BegBalance='32000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245574' ; 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='10400.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-10-29 14:43:07',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1600.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-10-29 14:50:57',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220207',sales_AssignTo='016',sales_PNumber='LRN11320245587',sales_Amt='12000.00',sales_Area='TC4',sales_Cycle='7',sales_Released='2024-10-29',sales_Maturity='2025-02-06',sales_BegBalance='12000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245587' ; 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='10320.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-10-29 14:46:21',sales_Timestamp='2024-11-09 09:43:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1680.00',sales_PaymentCutoff='840.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-10-29 14:50:57',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320240455',sales_AssignTo='014',sales_PNumber='LRN11320245589',sales_Amt='12000.00',sales_Area='TC3',sales_Cycle='3',sales_Released='2024-10-29',sales_Maturity='2025-02-06',sales_BegBalance='12000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11320245589' ; 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='11082.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-10-31 10:28:43',sales_Timestamp='2024-11-09 08:13:55',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='918.00',sales_PaymentCutoff='400.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-10-31 10:35:19',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242330',sales_AssignTo='042',sales_PNumber='LRN11220240783',sales_Amt='12000.00',sales_Area='13CLC',sales_Cycle='3',sales_Released='2024-10-31',sales_Maturity='2025-02-08',sales_BegBalance='12000.00',sales_LPD='2024-11-08' WHERE sales_PNumber = 'LRN11220240783' ; 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='20000.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='031',sales_PostedDate='2024-11-08 15:19:15',sales_Timestamp='2024-11-09 09:18:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='0.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-11-08 15:31:17',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180115',sales_AssignTo='011',sales_PNumber='LRN11320245626',sales_Amt='20000.00',sales_Area='TC2',sales_Cycle='3',sales_Released='2024-11-08',sales_Maturity='2025-02-16',sales_BegBalance='20000.00',sales_LPD='0000-00-00' WHERE sales_PNumber = 'LRN11320245626' ; 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='33000.00',sales_amortization='330.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='33000.00',sales_interest_amt='0.00',sales_prin_amt='33000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='031',sales_PostedDate='2024-11-08 15:26:21',sales_Timestamp='2024-11-09 09:18:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='0.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2024-11-08 15:31:17',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320180291',sales_AssignTo='011',sales_PNumber='LRN11320245630',sales_Amt='33000.00',sales_Area='TC2',sales_Cycle='18',sales_Released='2024-11-08',sales_Maturity='2025-02-16',sales_BegBalance='33000.00',sales_LPD='0000-00-00' WHERE sales_PNumber = 'LRN11320245630' ; 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 ('LRN11220240803','','','2024-11-13','0000-00-00','0','0.00','','0000-00-00','0000-00-00','14409','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-11-11 15:03:13','027','30000.00','1','AN1122024112034','11220211875','VILLASIS','MELINDA','DILAN','','','','','0','','0000-00-00','30000.00','2024-11-09','3CLC','006','Released','30000.00','015','2024-11-09 11:04:39','0','RENEWAL','015','2024-11-09 10:57:36','112','2024-11-13 11:42:17'); 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 ('LRN11220240805','','','2024-11-13','0000-00-00','0','0.00','','0000-00-00','0000-00-00','14410','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-11-11 15:03:13','027','20000.00','1','AN1122024112035','11220232142','SABULAO','LIBERTY','DARO','','','','','0','','0000-00-00','20000.00','2024-11-09','4CLC','004i','Released','20000.00','015','2024-11-09 11:03:41','0','RENEWAL','015','2024-11-09 10:58:55','112','2024-11-13 14:10:55'); 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 ('LRN11220240801','','','2024-11-13','0000-00-00','0','0.00','','0000-00-00','0000-00-00','14411','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-11-11 15:03:13','027','18000.00','1','AN1122024112036','11220232238','MARIANO','ANN LAURENCE','ABUAN','','','','','0','','0000-00-00','18000.00','2024-11-09','13CLC','042','Released','18000.00','015','2024-11-09 11:02:19','0','RENEWAL','015','2024-11-09 11:00:37','112','2024-11-13 11:40:57'); 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 ('LRN11220240802','','','2024-11-13','0000-00-00','0','0.00','','0000-00-00','0000-00-00','14412','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-11-11 15:17:03','027','8000.00','1','AN1122024112037','11220242399','MENDOZA','OLIVIA','AMICAN','','206','USUSAN','','34914','CALOOCAN CITY','1984-02-12','8000.00','2024-11-09','2CLC','002','Released','8000.00','015','2024-11-09 11:16:02','0','NEW','015','2024-11-09 11:06:47','112','2024-11-13 11:41:38');