UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2025-02-01 08:16:25',add_HouseNo='14', add_Street= 'P.BURGOS', add_Subd= '', add_Brgy= '34899', add_City= 'CALOOCAN CITY', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '9039' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2025-02-01 08:16:25',add_HouseNo='', add_Street= '14 P.BURGOS  BARANGAY 13 CALOO', add_Subd= '', add_Brgy= '34899', add_City= 'CALOOCAN CITY', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '9040' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2025-02-01 08:16:25',add_HouseNo='463', add_Street= 'NBBN', add_Subd= '', add_Brgy= '35103', add_City= 'CITY OF NAVOTAS', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '9041' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2025-02-01 08:16:25',add_HouseNo='', add_Street= '463 NBBN  NORTH BAY BLVD., NOR', add_Subd= '', add_Brgy= '35103', add_City= 'CITY OF NAVOTAS', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '9042' and add_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='15000.00',bus_gross_daily_income='25000.00',buss_worth_stocks='50000.00',buss_capitalization='50000.00',buss_description='MEAT SHOP',buss_Type='Primary', buss_Name= '19', buss_Address= '14 P.BURGOS BARANGAY 13 CALOOCAN CITY', buss_Started= '2015-01-01', buss_Contact= '', buss_Deleted= '0', buss_Encoded= '015', buss_EncodedDate= '2025-01-31 13:38:27', buss_timestamp= '2025-02-01 08:16:25' WHERE buss_ID = '3962' and buss_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='5000.00',bus_gross_daily_income='10000.00',buss_worth_stocks='20000.00',buss_capitalization='20000.00',buss_description='EATERY',buss_Type='Primary', buss_Name= '4', buss_Address= '463 NBBN NORTH BAY BLVD., NORTH CITY OF NAVOTAS', buss_Started= '2009-01-01', buss_Contact= '', buss_Deleted= '0', buss_Encoded= '015', buss_EncodedDate= '2025-01-31 13:43:53', buss_timestamp= '2025-02-01 08:16:25' WHERE buss_ID = '3963' and buss_Branch = '112'; 
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','396576','0.00','0.00','0.00','0.00','0.00','112-158065','112','12CLC','LRN11220240683','2025-02-01','0','','140.00','','002','0','112','015','2025-02-01 13:54:05','0','0000-00-00 00:00:00','0','015','2025-02-01 13:43:31','2025-02-01 13:54: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','396577','0.00','0.00','0.00','0.00','0.00','112-158066','112','12CLC','LRN11220231854','2025-02-01','0','','50.00','','002','0','112','015','2025-02-01 13:54:07','0','0000-00-00 00:00:00','0','015','2025-02-01 13:43:31','2025-02-01 13:54: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','396578','0.00','0.00','0.00','0.00','0.00','112-158067','112','2CLC','LRN11220250036','2025-02-01','0','','260.00','','002','0','112','015','2025-02-01 13:47:28','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396579','0.00','0.00','0.00','0.00','0.00','112-158068','112','2CLC','LRN11220240795','2025-02-01','0','','250.00','','002','0','112','015','2025-02-01 13:47:31','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396580','0.00','0.00','0.00','0.00','0.00','112-158069','112','2CLC','LRN11220240789','2025-02-01','0','','100.00','','002','0','112','015','2025-02-01 13:47:33','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396581','0.00','0.00','0.00','0.00','0.00','112-158070','112','2CLC','LRN11220240799','2025-02-01','0','','225.00','','002','0','112','015','2025-02-01 13:47:35','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396582','0.00','0.00','0.00','0.00','0.00','112-158071','112','2CLC','LRN11220250060','2025-02-01','0','','260.00','','002','0','112','015','2025-02-01 13:47:37','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396583','0.00','0.00','0.00','0.00','0.00','112-158072','112','2CLC','LRN11220250040','2025-02-01','0','','200.00','','002','0','112','015','2025-02-01 13:47:39','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396584','0.00','0.00','0.00','0.00','0.00','112-158073','112','2CLC','LRN11220240894','2025-02-01','0','','3110.00','','002','0','112','015','2025-02-01 13:47:41','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396585','0.00','0.00','0.00','0.00','0.00','112-158074','112','2CLC','LRN11220250059','2025-02-01','0','','280.00','','002','0','112','015','2025-02-01 13:47:43','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396586','0.00','0.00','0.00','0.00','0.00','112-158075','112','2CLC','LRN11220240780','2025-02-01','0','','300.00','','002','0','112','015','2025-02-01 13:47:45','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396587','0.00','0.00','0.00','0.00','0.00','112-158076','112','2CLC','LRN11220240714','2025-02-01','0','','100.00','','002','0','112','015','2025-02-01 13:47:47','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396588','0.00','0.00','0.00','0.00','0.00','112-158077','112','2CLC','LRN11220240887','2025-02-01','0','','350.00','','002','0','112','015','2025-02-01 13:47:49','0','0000-00-00 00:00:00','0','015','2025-02-01 13:45:36','2025-02-01 13:47: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','396589','0.00','0.00','0.00','0.00','0.00','112-158078','112','4CLC','LRN11220240851','2025-02-01','0','','350.00','','004i','0','112','015','2025-02-01 14:34:33','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14: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','396590','0.00','0.00','0.00','0.00','0.00','112-158079','112','4CLC','LRN11220240890','2025-02-01','0','','280.00','','004i','0','112','015','2025-02-01 14:34:35','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14: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','396591','0.00','0.00','0.00','0.00','0.00','112-158080','112','4CLC','LRN11220240849','2025-02-01','0','','210.00','','004i','0','112','015','2025-02-01 14:34:38','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14:34: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','396592','0.00','0.00','0.00','0.00','0.00','112-158081','112','4CLC','LRN11220250007','2025-02-01','0','','140.00','','004i','0','112','015','2025-02-01 14:34:40','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14:34: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','396593','0.00','0.00','0.00','0.00','0.00','112-158082','112','4CLC','LRN11220240868','2025-02-01','0','','200.00','','004i','0','112','015','2025-02-01 14:34:42','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14:34: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','396594','0.00','0.00','0.00','0.00','0.00','112-158083','112','4CLC','LRN11220250012','2025-02-01','0','','600.00','','004i','0','112','015','2025-02-01 14:34:44','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14:34: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','396595','0.00','0.00','0.00','0.00','0.00','112-158084','112','4CLC','LRN11220250042','2025-02-01','0','','600.00','','004i','0','112','015','2025-02-01 14:34:46','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14:34: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','396596','0.00','0.00','0.00','0.00','0.00','112-158085','112','4CLC','LRN11220240805','2025-02-01','0','','4900.00','','004i','0','112','015','2025-02-01 14:34:48','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14:34: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','396597','0.00','0.00','0.00','0.00','0.00','112-158086','112','4CLC','LRN11220250019','2025-02-01','0','','400.00','','004i','0','112','015','2025-02-01 14:34:50','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14:34: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','396598','0.00','0.00','0.00','0.00','0.00','112-158087','112','4CLC','LRN11220250003','2025-02-01','0','','140.00','','004i','0','112','015','2025-02-01 14:34:52','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14: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','396599','0.00','0.00','0.00','0.00','0.00','112-158088','112','4CLC','LRN11220240827','2025-02-01','0','','300.00','','004i','0','112','015','2025-02-01 14:34:54','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14: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','396600','0.00','0.00','0.00','0.00','0.00','112-158089','112','4CLC','LRN11220240467','2025-02-01','0','','50.00','','004i','0','112','015','2025-02-01 14:34:56','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14: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','396601','0.00','0.00','0.00','0.00','0.00','112-158090','112','4CLC','LRN11220250021','2025-02-01','0','','252.00','','004i','0','112','015','2025-02-01 14:34:58','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14: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','396602','0.00','0.00','0.00','0.00','0.00','112-158091','112','4CLC','LRN11220240797','2025-02-01','0','','3360.00','','004i','0','112','015','2025-02-01 14:35:00','0','0000-00-00 00:00:00','0','015','2025-02-01 14:32:52','2025-02-01 14: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','396603','0.00','0.00','0.00','0.00','0.00','112-158092','112','4CLC','LRN11220240895','2025-02-01','0','','1500.00','','004i','0','112','015','2025-02-01 15:04:22','0','0000-00-00 00:00:00','0','015','2025-02-01 15:03:16','2025-02-01 15:04:22');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','396604','0.00','0.00','0.00','0.00','0.00','112-158093','112','13CLC','LRN11220240843','2025-02-01','0','','1200.00','','006','0','112','015','2025-02-01 15:18:08','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396605','0.00','0.00','0.00','0.00','0.00','112-158094','112','13CLC','LRN11220250062','2025-02-01','0','','400.00','','006','0','112','015','2025-02-01 15:18:10','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396606','0.00','0.00','0.00','0.00','0.00','112-158095','112','13CLC','LRN11220240798','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 15:18:12','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396607','0.00','0.00','0.00','0.00','0.00','112-158096','112','13CLC','LRN11220240569','2025-02-01','0','','100.00','','006','0','112','015','2025-02-01 15:18:15','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396608','0.00','0.00','0.00','0.00','0.00','112-158097','112','13CLC','LRN11220240272','2025-02-01','0','','100.00','','006','0','112','015','2025-02-01 15:18:17','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396609','0.00','0.00','0.00','0.00','0.00','112-158098','112','13CLC','LRN11220250002','2025-02-01','0','','760.00','','006','0','112','015','2025-02-01 15:18:19','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396610','0.00','0.00','0.00','0.00','0.00','112-158099','112','13CLC','LRN11220240891','2025-02-01','0','','350.00','','006','0','112','015','2025-02-01 15:18:21','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396611','0.00','0.00','0.00','0.00','0.00','112-158100','112','13CLC','LRN11220250038','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 15:18:23','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18:23');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','396612','0.00','0.00','0.00','0.00','0.00','112-158101','112','13CLC','LRN11220240862','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 15:18:25','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396613','0.00','0.00','0.00','0.00','0.00','112-158102','112','13CLC','LRN11220240869','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 15:18:27','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396614','0.00','0.00','0.00','0.00','0.00','112-158103','112','13CLC','LRN11220240508','2025-02-01','0','','100.00','','006','0','112','015','2025-02-01 15:18:29','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396615','0.00','0.00','0.00','0.00','0.00','112-158104','112','13CLC','LRN11220240759','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 15:18:31','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396616','0.00','0.00','0.00','0.00','0.00','112-158105','112','13CLC','LRN11220240707','2025-02-01','0','','50.00','','006','0','112','015','2025-02-01 15:18:33','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396617','0.00','0.00','0.00','0.00','0.00','112-158106','112','13CLC','LRN11220240847','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 15:18:35','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396618','0.00','0.00','0.00','0.00','0.00','112-158107','112','13CLC','LRN11220240723','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 15:18:37','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396619','0.00','0.00','0.00','0.00','0.00','112-158108','112','13CLC','LRN11220240318','2025-02-01','0','','150.00','','006','0','112','015','2025-02-01 15:18:39','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396620','0.00','0.00','0.00','0.00','0.00','112-158109','112','13CLC','LRN11220240796','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 15:18:42','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396621','0.00','0.00','0.00','0.00','0.00','112-158110','112','13CLC','LRN11220240877','2025-02-01','0','','400.00','','006','0','112','015','2025-02-01 15:18:44','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396622','0.00','0.00','0.00','0.00','0.00','112-158111','112','13CLC','LRN11220240583','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 15:18:46','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396623','0.00','0.00','0.00','0.00','0.00','112-158112','112','13CLC','LRN11220240047','2025-02-01','0','','20.00','','006','0','112','015','2025-02-01 15:18:48','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396624','0.00','0.00','0.00','0.00','0.00','112-158113','112','13CLC','LRN11220250057','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 15:18:50','0','0000-00-00 00:00:00','0','015','2025-02-01 15:16:57','2025-02-01 15:18: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','396625','0.00','0.00','0.00','0.00','0.00','112-158114','112','2CLC','LRN11220250005','2025-02-01','0','','450.00','','002','0','112','015','2025-02-01 15:59:47','0','0000-00-00 00:00:00','0','015','2025-02-01 15:55:11','2025-02-01 15:59: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','396626','0.00','0.00','0.00','0.00','0.00','112-158115','112','3CLC','LRN11220250050','2025-02-01','0','','1000.00','','006','0','112','015','2025-02-01 16:00:21','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396627','0.00','0.00','0.00','0.00','0.00','112-158116','112','3CLC','LRN11220250026','2025-02-01','0','','255.00','','006','0','112','015','2025-02-01 16:00:23','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00:23');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','396628','0.00','0.00','0.00','0.00','0.00','112-158117','112','3CLC','LRN11220240751','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 16:00:25','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396629','0.00','0.00','0.00','0.00','0.00','112-158118','112','3CLC','LRN11220250015','2025-02-01','0','','250.00','','006','0','112','015','2025-02-01 16:00:27','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396630','0.00','0.00','0.00','0.00','0.00','112-158119','112','3CLC','LRN11220240818','2025-02-01','0','','4200.00','','006','0','112','015','2025-02-01 16:00:29','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396631','0.00','0.00','0.00','0.00','0.00','112-158120','112','3CLC','LRN11220240812','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 16:00:31','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396632','0.00','0.00','0.00','0.00','0.00','112-158121','112','3CLC','LRN11220240872','2025-02-01','0','','300.00','','006','0','112','015','2025-02-01 16:00:33','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396633','0.00','0.00','0.00','0.00','0.00','112-158122','112','3CLC','LRN11220250006','2025-02-01','0','','400.00','','006','0','112','015','2025-02-01 16:00:35','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396634','0.00','0.00','0.00','0.00','0.00','112-158123','112','3CLC','LRN11220240630','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 16:00:37','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396635','0.00','0.00','0.00','0.00','0.00','112-158124','112','3CLC','LRN11220240848','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 16:00:39','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396636','0.00','0.00','0.00','0.00','0.00','112-158125','112','3CLC','LRN11220240853','2025-02-01','0','','100.00','','006','0','112','015','2025-02-01 16:00:41','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396637','0.00','0.00','0.00','0.00','0.00','112-158126','112','3CLC','LRN11220250055','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 16:00:43','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396638','0.00','0.00','0.00','0.00','0.00','112-158127','112','3CLC','LRN11220250058','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 16:00:46','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396639','0.00','0.00','0.00','0.00','0.00','112-158128','112','3CLC','LRN11220240881','2025-02-01','0','','210.00','','006','0','112','015','2025-02-01 16:00:48','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396640','0.00','0.00','0.00','0.00','0.00','112-158129','112','3CLC','LRN11220250020','2025-02-01','0','','150.00','','006','0','112','015','2025-02-01 16:00:50','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396641','0.00','0.00','0.00','0.00','0.00','112-158130','112','3CLC','LRN11220250004','2025-02-01','0','','400.00','','006','0','112','015','2025-02-01 16:00:52','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396642','0.00','0.00','0.00','0.00','0.00','112-158131','112','3CLC','LRN11220240850','2025-02-01','0','','400.00','','006','0','112','015','2025-02-01 16:00:54','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396643','0.00','0.00','0.00','0.00','0.00','112-158132','112','3CLC','LRN11220240693','2025-02-01','0','','310.00','','006','0','112','015','2025-02-01 16:00:56','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396644','0.00','0.00','0.00','0.00','0.00','112-158133','112','3CLC','LRN11220240706','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 16:00:58','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:00: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','396645','0.00','0.00','0.00','0.00','0.00','112-158134','112','3CLC','LRN11220240328','2025-02-01','0','','100.00','','006','0','112','015','2025-02-01 16:01:00','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396646','0.00','0.00','0.00','0.00','0.00','112-158135','112','3CLC','LRN11220240807','2025-02-01','0','','600.00','','006','0','112','015','2025-02-01 16:01:02','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01:02');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','396647','0.00','0.00','0.00','0.00','0.00','112-158136','112','3CLC','LRN11220240858','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 16:01:04','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01:04');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','396648','0.00','0.00','0.00','0.00','0.00','112-158137','112','3CLC','LRN11220240811','2025-02-01','0','','1000.00','','006','0','112','015','2025-02-01 16:01:06','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396649','0.00','0.00','0.00','0.00','0.00','112-158138','112','3CLC','LRN11220250041','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 16:01:08','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396650','0.00','0.00','0.00','0.00','0.00','112-158139','112','3CLC','LRN11220240738','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 16:01:10','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396651','0.00','0.00','0.00','0.00','0.00','112-158140','112','3CLC','LRN11220250054','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 16:01:12','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396652','0.00','0.00','0.00','0.00','0.00','112-158141','112','3CLC','LRN11220250013','2025-02-01','0','','200.00','','006','0','112','015','2025-02-01 16:01:14','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396653','0.00','0.00','0.00','0.00','0.00','112-158142','112','3CLC','LRN11220240886','2025-02-01','0','','700.00','','006','0','112','015','2025-02-01 16:01:17','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396654','0.00','0.00','0.00','0.00','0.00','112-158143','112','3CLC','LRN11220232266','2025-02-01','0','','100.00','','006','0','112','015','2025-02-01 16:01:19','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396655','0.00','0.00','0.00','0.00','0.00','112-158144','112','3CLC','LRN11220240056','2025-02-01','0','','3000.00','','006','0','112','015','2025-02-01 16:01:21','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01: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','396656','0.00','0.00','0.00','0.00','0.00','112-158145','112','3CLC','LRN11220240704','2025-02-01','0','','400.00','','006','0','112','015','2025-02-01 16:01:23','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01:23');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','396657','0.00','0.00','0.00','0.00','0.00','112-158146','112','3CLC','LRN11220250014','2025-02-01','0','','500.00','','006','0','112','015','2025-02-01 16:01:25','0','0000-00-00 00:00:00','0','015','2025-02-01 15:58:47','2025-02-01 16:01:25');
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09924035213', contact_Status= 'ACTIVE', contact_Encoded= '015', contact_EncodedDate= '2025-01-31 13:34:57', contact_timestamp= '2025-02-01 08:16:25' WHERE contact_Cust_ID = '5858' and contact_ID = '7566'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09359892250', contact_Status= 'ACTIVE', contact_Encoded= '015', contact_EncodedDate= '2025-01-31 13:40:23', contact_timestamp= '2025-02-01 08:16:25' WHERE contact_Cust_ID = '5859' and contact_ID = '7567'; 
UPDATE cust_dependent SET dep_ho_date='',dep_ho_edit='',dep_yearOFBirth='',dep_School='',dep_Contact='',dep_Deleted='',dep_Encoded='',dep_EncodedDate='',dep_timestamp='',dep_Relationship='', dep_LastName= '', dep_FirstName= '', dep_MiddleName= '', dep_Status= '', dep_Birthday= '' WHERE dep_ID = '' and dep_Branch = ''; 
UPDATE cust_dependent SET dep_ho_date='',dep_ho_edit='',dep_yearOFBirth='',dep_School='',dep_Contact='',dep_Deleted='',dep_Encoded='',dep_EncodedDate='',dep_timestamp='',dep_Relationship='', dep_LastName= '', dep_FirstName= '', dep_MiddleName= '', dep_Status= '', dep_Birthday= '' WHERE dep_ID = '' and dep_Branch = ''; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220242398', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='006', createdBy='015', createddate='2025-01-31 11:18:45', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16399'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220211785', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='006', createdBy='015', createddate='2025-01-31 11:18:45', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16400'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220232269', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='042', createdBy='015', createddate='2025-01-31 14:03:09', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16401'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420221143', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16402'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420210890', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16403'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420231341', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='040', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16404'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420190722', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16405'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420231252', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16406'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420231219', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='040', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16407'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420231270', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16408'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420190759', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16409'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420190552', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16410'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420251609', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='040', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16411'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420251610', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='040', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16412'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420231296', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2025-01-31 14:32:30', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16413'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220252405', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='006', createdBy='015', createddate='2025-01-31 14:42:12', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16414'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220242364', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='002', createdBy='015', createddate='2025-01-31 14:42:12', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16415'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220242372', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='002', createdBy='015', createddate='2025-01-31 15:35:52', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16416'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220242356', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='042', createdBy='015', createddate='2025-01-31 15:51:05', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16417'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220242385', typetrans='insurance', datetrans='2025-01-31', amttrans='0.00', remarks1='', empid='042', createdBy='015', createddate='2025-01-31 15:51:05', timestamp='2025-02-01 08:16:26' WHERE branch = '112' and saveid = '16418'; 
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09924035213',spouse_Occupation='RENT A CAR',spouse_Encoded='015',spouse_EncodedDate='2025-01-31 13:36:44',spouse_timestamp='2025-02-01 08:16:26',spouse_LastName='DELA CRUZ', spouse_FirstName='FREDERICK', spouse_MiddleName='GONZALES', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='14 P.BURGOS BARANGAY 13 CALOOCAN CITY', spouse_Bday='0000-00-00', spouse_BirthPlace='CALOOCAN CITY' WHERE spouse_ID = '2396' and spouse_Branch = '112'; 
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09359892250',spouse_Occupation='OFW',spouse_Encoded='015',spouse_EncodedDate='2025-01-31 13:42:14',spouse_timestamp='2025-02-01 08:16:26',spouse_LastName='HAGORILES', spouse_FirstName='ALVIE', spouse_MiddleName='BAYLOSIS', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='463 NBBN NORTH BAY BLVD., NORTH CITY OF NAVOTAS', spouse_Bday='0000-00-00', spouse_BirthPlace='NAVOTAS CITY' WHERE spouse_ID = '2397' and spouse_Branch = '112'; 
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','2025-02-01','166','2025-02-01','5435.00','0.00','0.00','','ACTIVE','015','2025-02-01 13:54:55','2025-02-01 13:54:55');
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','2025-02-01','166','2025-02-01','190.00','0.00','0.00','','ACTIVE','015','2025-02-01 13:55:24','2025-02-01 13:55:24');
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','2025-02-01','166','2025-02-01','11782.00','0.00','0.00','','ACTIVE','015','2025-02-01 14:29:42','2025-02-01 14:29:42');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','4CLC','Deposited','2025-02-01','166','2025-02-01','1500.00','0.00','0.00','','ACTIVE','015','2025-02-01 15:05:07','2025-02-01 15:05:07');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','13CLC','Deposited','2025-02-01','166','2025-02-01','6530.00','0.00','0.00','','ACTIVE','015','2025-02-01 15:12:08','2025-02-01 15:12:08');
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','2025-02-01','166','2025-02-01','450.00','0.00','0.00','','ACTIVE','015','2025-02-01 16:02:33','2025-02-01 16:02:33');
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','2025-02-01','166','2025-02-01','18575.00','0.00','0.00','','ACTIVE','015','2025-02-01 16:03:12','2025-02-01 16:03:12');
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='015',sales_PostedDate='2024-10-23 13:29:03',sales_Timestamp='2025-02-01 08:15:06',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='3780.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-10-23 13:31:55',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242389',sales_AssignTo='002',sales_PNumber='LRN11220240764',sales_Amt='20000.00',sales_Area='2CLC',sales_Cycle='1',sales_Released='2024-10-23',sales_Maturity='2025-01-31',sales_BegBalance='20000.00',sales_LPD='2025-01-31' WHERE sales_PNumber = 'LRN11220240764' ; 
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='19210.00',sales_amortization='220.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='22000.00',sales_interest_amt='0.00',sales_prin_amt='22000.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-11-27 13:30:53',sales_Timestamp='2025-02-01 08:15:06',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2790.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-11-27 13:31:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232260',sales_AssignTo='042',sales_PNumber='LRN11220240834',sales_Amt='22000.00',sales_Area='13CLC',sales_Cycle='6',sales_Released='2024-11-27',sales_Maturity='2025-03-07',sales_BegBalance='22000.00',sales_LPD='2025-01-31' WHERE sales_PNumber = 'LRN11220240834' ; 
