UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-04-06 09:00:11',add_HouseNo='', add_Street= '', add_Subd= '', add_Brgy= '7928', add_City= 'LA PAZ', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1973', add_Status= 'ACTIVE'  WHERE add_ID = '8443' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-04-06 09:00:11',add_HouseNo='', add_Street= '', add_Subd= '', add_Brgy= '7928', add_City= 'LA PAZ', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1973', add_Status= 'ACTIVE'  WHERE add_ID = '8444' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-04-06 09:00:11',add_HouseNo='118 BAGONG SIBOL', add_Street= '', add_Subd= '', add_Brgy= '34914', add_City= 'CALOOCAN CITY', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '8445' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-04-06 09:00:11',add_HouseNo='', add_Street= '118 BAGONG SIBOL   BARANGAY 28', add_Subd= '', add_Brgy= '34914', add_City= 'CALOOCAN CITY', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '8446' and add_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='600.00',bus_gross_daily_income='2500.00',buss_worth_stocks='30000.00',buss_capitalization='30000.00',buss_description='SARI SARI STORE',buss_Type='Primary', buss_Name= '2', buss_Address= 'BALANOY LA PAZ TARLAC', buss_Started= '2015-01-01', buss_Contact= '09452454834', buss_Deleted= '0', buss_Encoded= '031', buss_EncodedDate= '2024-04-05 10:36:39', buss_timestamp= '2024-04-06 09:00:11' WHERE buss_ID = '3652' and buss_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='5000.00',bus_gross_daily_income='30000.00',buss_worth_stocks='30000.00',buss_capitalization='30000.00',buss_description='COMPUTER SHOP',buss_Type='Primary', buss_Name= '35', buss_Address= '118 BAGONG SIBOL BARANGAY 28 CALOOCAN CITY', buss_Started= '2021-01-01', buss_Contact= '', buss_Deleted= '0', buss_Encoded= '015', buss_EncodedDate= '2024-04-05 11:30:03', buss_timestamp= '2024-04-06 09:00:11' WHERE buss_ID = '3653' 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','316739','0.00','0.00','0.00','0.00','0.00','112-123155','112','11CLC','LRN11220231815','2024-04-06','0','','100.00','','042','0','112','015','2024-04-06 14:29:27','0','0000-00-00 00:00:00','0','015','2024-04-06 14:24:48','2024-04-06 14:29: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','316740','0.00','0.00','0.00','0.00','0.00','112-123156','112','4CLC','LRN11220240235','2024-04-06','0','','400.00','','004i','0','112','015','2024-04-06 14:30:27','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316741','0.00','0.00','0.00','0.00','0.00','112-123157','112','4CLC','LRN11220240236','2024-04-06','0','','400.00','','004i','0','112','015','2024-04-06 14:30:29','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316742','0.00','0.00','0.00','0.00','0.00','112-123158','112','4CLC','LRN11220240211','2024-04-06','0','','1440.00','','004i','0','112','015','2024-04-06 14:30:31','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316743','0.00','0.00','0.00','0.00','0.00','112-123159','112','4CLC','LRN11220240161','2024-04-06','0','','210.00','','004i','0','112','015','2024-04-06 14:30:33','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316744','0.00','0.00','0.00','0.00','0.00','112-123160','112','4CLC','LRN11220240203','2024-04-06','0','','700.00','','004i','0','112','015','2024-04-06 14:30:35','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316745','0.00','0.00','0.00','0.00','0.00','112-123161','112','4CLC','LRN11220240151','2024-04-06','0','','500.00','','004i','0','112','015','2024-04-06 14:30:38','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316746','0.00','0.00','0.00','0.00','0.00','112-123162','112','4CLC','LRN11220240061','2024-04-06','0','','1360.00','','004i','0','112','015','2024-04-06 14:30:40','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316747','0.00','0.00','0.00','0.00','0.00','112-123163','112','4CLC','LRN11220240174','2024-04-06','0','','300.00','','004i','0','112','015','2024-04-06 14:30:42','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316748','0.00','0.00','0.00','0.00','0.00','112-123164','112','4CLC','LRN11220240129','2024-04-06','0','','400.00','','004i','0','112','015','2024-04-06 14:30:44','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316749','0.00','0.00','0.00','0.00','0.00','112-123165','112','4CLC','LRN11220232416','2024-04-06','0','','100.00','','004i','0','112','015','2024-04-06 14:30:46','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316750','0.00','0.00','0.00','0.00','0.00','112-123166','112','4CLC','LRN11220240046','2024-04-06','0','','350.00','','004i','0','112','015','2024-04-06 14:30:48','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316751','0.00','0.00','0.00','0.00','0.00','112-123167','112','4CLC','LRN11220240192','2024-04-06','0','','300.00','','004i','0','112','015','2024-04-06 14:30:50','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30: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','316752','0.00','0.00','0.00','0.00','0.00','112-123168','112','4CLC','LRN11220240033','2024-04-06','0','','250.00','','004i','0','112','015','2024-04-06 14:30:52','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30:52');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316753','0.00','0.00','0.00','0.00','0.00','112-123169','112','4CLC','LRN11220240233','2024-04-06','0','','340.00','','004i','0','112','015','2024-04-06 14:30:54','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30:54');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316754','0.00','0.00','0.00','0.00','0.00','112-123170','112','4CLC','LRN11220240169','2024-04-06','0','','225.00','','004i','0','112','015','2024-04-06 14:30:56','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30:56');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316755','0.00','0.00','0.00','0.00','0.00','112-123171','112','4CLC','LRN11220240093','2024-04-06','0','','270.00','','004i','0','112','015','2024-04-06 14:30:58','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:30:58');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316756','0.00','0.00','0.00','0.00','0.00','112-123172','112','4CLC','LRN11220240238','2024-04-06','0','','2300.00','','004i','0','112','015','2024-04-06 14:31:00','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:31:00');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316757','0.00','0.00','0.00','0.00','0.00','112-123173','112','4CLC','LRN11220240078','2024-04-06','0','','300.00','','004i','0','112','015','2024-04-06 14:31:02','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:31:02');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316758','0.00','0.00','0.00','0.00','0.00','112-123174','112','4CLC','LRN11220240019','2024-04-06','0','','12300.00','','004i','0','112','015','2024-04-06 14:31:05','0','0000-00-00 00:00:00','0','015','2024-04-06 14:27:55','2024-04-06 14:31: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','316759','0.00','0.00','0.00','0.00','0.00','112-123175','112','12CLC','LRN11220240184','2024-04-06','0','','150.00','','004i','0','112','015','2024-04-06 14:57:15','0','0000-00-00 00:00:00','0','015','2024-04-06 14:56:13','2024-04-06 14:57: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','316760','0.00','0.00','0.00','0.00','0.00','112-123176','112','12CLC','LRN11220240198','2024-04-06','0','','120.00','','004i','0','112','015','2024-04-06 14:57:17','0','0000-00-00 00:00:00','0','015','2024-04-06 14:56:13','2024-04-06 14:57: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','316761','0.00','0.00','0.00','0.00','0.00','112-123177','112','12CLC','LRN11220240185','2024-04-06','0','','150.00','','004i','0','112','015','2024-04-06 14:57:19','0','0000-00-00 00:00:00','0','015','2024-04-06 14:56:13','2024-04-06 14:57: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','316762','0.00','0.00','0.00','0.00','0.00','112-123178','112','12CLC','LRN11220240201','2024-04-06','0','','150.00','','004i','0','112','015','2024-04-06 14:57:21','0','0000-00-00 00:00:00','0','015','2024-04-06 14:56:13','2024-04-06 14:57: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','316763','0.00','0.00','0.00','0.00','0.00','112-123179','112','12CLC','LRN11220240202','2024-04-06','0','','150.00','','004i','0','112','015','2024-04-06 14:57:23','0','0000-00-00 00:00:00','0','015','2024-04-06 14:56:13','2024-04-06 14:57: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','316764','0.00','0.00','0.00','0.00','0.00','112-123180','112','12CLC','LRN11220231780','2024-04-06','0','','50.00','','004i','0','112','015','2024-04-06 14:57:26','0','0000-00-00 00:00:00','0','015','2024-04-06 14:56:13','2024-04-06 14:57: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','316765','0.00','0.00','0.00','0.00','0.00','112-123181','112','12CLC','LRN11220232044','2024-04-06','0','','100.00','','004i','0','112','015','2024-04-06 15:09:01','0','0000-00-00 00:00:00','0','015','2024-04-06 15:04:59','2024-04-06 15:09:01');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316766','0.00','0.00','0.00','0.00','0.00','112-123182','112','2CLC','LRN11220232355','2024-04-06','0','','50.00','','002','0','112','015','2024-04-06 15:09:47','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:09: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','316767','0.00','0.00','0.00','0.00','0.00','112-123183','112','2CLC','LRN11220240081','2024-04-06','0','','115.00','','002','0','112','015','2024-04-06 15:09:49','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:09: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','316768','0.00','0.00','0.00','0.00','0.00','112-123184','112','2CLC','LRN11220232254','2024-04-06','0','','100.00','','002','0','112','015','2024-04-06 15:09:51','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:09: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','316769','0.00','0.00','0.00','0.00','0.00','112-123185','112','2CLC','LRN11220240124','2024-04-06','0','','600.00','','002','0','112','015','2024-04-06 15:09:53','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:09: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','316770','0.00','0.00','0.00','0.00','0.00','112-123186','112','2CLC','LRN11220240034','2024-04-06','0','','150.00','','002','0','112','015','2024-04-06 15:09:55','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:09: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','316771','0.00','0.00','0.00','0.00','0.00','112-123187','112','2CLC','LRN11220240032','2024-04-06','0','','112.00','','002','0','112','015','2024-04-06 15:09:57','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:09: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','316772','0.00','0.00','0.00','0.00','0.00','112-123188','112','2CLC','LRN11220232174','2024-04-06','0','','200.00','','002','0','112','015','2024-04-06 15:09:59','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:09: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','316773','0.00','0.00','0.00','0.00','0.00','112-123189','112','2CLC','LRN11220240074','2024-04-06','0','','100.00','','002','0','112','015','2024-04-06 15:10:01','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:10: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','316774','0.00','0.00','0.00','0.00','0.00','112-123190','112','2CLC','LRN11220240035','2024-04-06','0','','180.00','','002','0','112','015','2024-04-06 15:10:03','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:10: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','316775','0.00','0.00','0.00','0.00','0.00','112-123191','112','2CLC','LRN11220232407','2024-04-06','0','','140.00','','002','0','112','015','2024-04-06 15:10:06','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:10:06');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316776','0.00','0.00','0.00','0.00','0.00','112-123192','112','2CLC','LRN11220232397','2024-04-06','0','','150.00','','002','0','112','015','2024-04-06 15:10:08','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:10:08');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316777','0.00','0.00','0.00','0.00','0.00','112-123193','112','2CLC','LRN11220232352','2024-04-06','0','','100.00','','002','0','112','015','2024-04-06 15:10:10','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:10:10');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316778','0.00','0.00','0.00','0.00','0.00','112-123194','112','2CLC','LRN11220240082','2024-04-06','0','','140.00','','002','0','112','015','2024-04-06 15:10:12','0','0000-00-00 00:00:00','0','015','2024-04-06 15:07:54','2024-04-06 15:10:12');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316779','0.00','0.00','0.00','0.00','0.00','112-123195','112','13CLC','LRN11220240051','2024-04-06','0','','200.00','','006','0','112','015','2024-04-06 15:35:31','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316780','0.00','0.00','0.00','0.00','0.00','112-123196','112','13CLC','LRN11220240103','2024-04-06','0','','5000.00','','006','0','112','015','2024-04-06 15:35:33','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316781','0.00','0.00','0.00','0.00','0.00','112-123197','112','13CLC','LRN11220240189','2024-04-06','0','','250.00','','006','0','112','015','2024-04-06 15:35:35','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316782','0.00','0.00','0.00','0.00','0.00','112-123198','112','13CLC','LRN11220240114','2024-04-06','0','','200.00','','006','0','112','015','2024-04-06 15:35:37','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316783','0.00','0.00','0.00','0.00','0.00','112-123199','112','13CLC','LRN11220240005','2024-04-06','0','','350.00','','006','0','112','015','2024-04-06 15:35:39','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316784','0.00','0.00','0.00','0.00','0.00','112-123200','112','13CLC','LRN11220240013','2024-04-06','0','','150.00','','006','0','112','015','2024-04-06 15:35:41','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316785','0.00','0.00','0.00','0.00','0.00','112-123201','112','13CLC','LRN11220220976','2024-04-06','0','','50.00','','006','0','112','015','2024-04-06 15:35:43','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316786','0.00','0.00','0.00','0.00','0.00','112-123202','112','13CLC','LRN11220240027','2024-04-06','0','','380.00','','006','0','112','015','2024-04-06 15:35:45','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:35: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','316787','0.00','0.00','0.00','0.00','0.00','112-123203','112','13CLC','LRN11220240127','2024-04-06','0','','840.00','','006','0','112','015','2024-04-06 15:35:47','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:35: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','316788','0.00','0.00','0.00','0.00','0.00','112-123204','112','13CLC','LRN11220240222','2024-04-06','0','','225.00','','006','0','112','015','2024-04-06 15:35:49','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:35: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','316789','0.00','0.00','0.00','0.00','0.00','112-123205','112','13CLC','LRN11220240002','2024-04-06','0','','100.00','','006','0','112','015','2024-04-06 15:35:52','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15: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','316790','0.00','0.00','0.00','0.00','0.00','112-123206','112','13CLC','LRN11220240213','2024-04-06','0','','250.00','','006','0','112','015','2024-04-06 15:35:54','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:35: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','316791','0.00','0.00','0.00','0.00','0.00','112-123207','112','13CLC','LRN11220240180','2024-04-06','0','','200.00','','006','0','112','015','2024-04-06 15:35:56','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:35: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','316792','0.00','0.00','0.00','0.00','0.00','112-123208','112','13CLC','LRN11220240139','2024-04-06','0','','50.00','','006','0','112','015','2024-04-06 15:35:58','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:35: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','316793','0.00','0.00','0.00','0.00','0.00','112-123209','112','13CLC','LRN11220240234','2024-04-06','0','','400.00','','006','0','112','015','2024-04-06 15:36:00','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:36: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','316794','0.00','0.00','0.00','0.00','0.00','112-123210','112','13CLC','LRN11220232384','2024-04-06','0','','200.00','','006','0','112','015','2024-04-06 15:36:02','0','0000-00-00 00:00:00','0','015','2024-04-06 15:23:10','2024-04-06 15:36:02');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','316795','0.00','0.00','0.00','0.00','0.00','112-123211','112','3CLC','LRN11220240021','2024-04-06','0','','250.00','','006','0','112','015','2024-04-06 15:45:50','0','0000-00-00 00:00:00','0','015','2024-04-06 15:44:47','2024-04-06 15:45: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','316796','0.00','0.00','0.00','0.00','0.00','112-123212','112','3CLC','LRN11220240195','2024-04-06','0','','380.00','','006','0','112','015','2024-04-06 15:45:52','0','0000-00-00 00:00:00','0','015','2024-04-06 15:44:47','2024-04-06 15:45: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','316797','0.00','0.00','0.00','0.00','0.00','112-123213','112','3CLC','LRN11220240156','2024-04-06','0','','3500.00','','006','0','112','015','2024-04-06 15:45:54','0','0000-00-00 00:00:00','0','015','2024-04-06 15:44:47','2024-04-06 15:45: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','316798','0.00','0.00','0.00','0.00','0.00','112-123214','112','3CLC','LRN11220240050','2024-04-06','0','','1500.00','','006','0','112','015','2024-04-06 15:45:56','0','0000-00-00 00:00:00','0','015','2024-04-06 15:44:47','2024-04-06 15:45: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','316799','0.00','0.00','0.00','0.00','0.00','112-123215','112','3CLC','LRN11220232470','2024-04-06','0','','200.00','','006','0','112','015','2024-04-06 15:45:58','0','0000-00-00 00:00:00','0','015','2024-04-06 15:44:47','2024-04-06 15:45: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','316800','0.00','0.00','0.00','0.00','0.00','112-123216','112','3CLC','LRN11220240239','2024-04-06','0','','270.00','','006','0','112','015','2024-04-06 15:46:00','0','0000-00-00 00:00:00','0','015','2024-04-06 15:44:47','2024-04-06 15:46: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','316801','0.00','0.00','0.00','0.00','0.00','112-123217','112','3CLC','LRN11220240120','2024-04-06','0','','500.00','','006','0','112','015','2024-04-06 15:46:03','0','0000-00-00 00:00:00','0','015','2024-04-06 15:44:47','2024-04-06 15:46:03');
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09452454834', contact_Status= 'ACTIVE', contact_Encoded= '031', contact_EncodedDate= '2024-04-05 10:35:09', contact_timestamp= '2024-04-06 09:00:11' WHERE contact_Cust_ID = '5563' and contact_ID = '7205'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09701226261', contact_Status= 'ACTIVE', contact_Encoded= '015', contact_EncodedDate= '2024-04-05 11:25:33', contact_timestamp= '2024-04-06 09:00:11' WHERE contact_Cust_ID = '5564' and contact_ID = '7206'; 
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_information SET cust_ho_date='',cust_ho_edit='',cust_picture='0000-00-00 00:00:00',cust_Code='11220222055', cust_Gender='FEMALE', cust_CivilStatus='SEPARATED', cust_Cycle='6', cust_Status='ACTIVE', cust_encoded='015', cust_encodeDate='2022-12-05 10:31:55', cust_timestamp='2024-04-06 11:58:58', cust_LastName='VERANO',cust_FirstName='SISA',cust_MiddleName='DONGON',cust_Suffix='',cust_MaidenName='DONGON',cust_NickName='SIS',cust_Area='3CLC',cust_Nationality='FILIPINO', cust_Bday= '1971-11-19', cust_BirthPlace= 'CALOOCAN CITY' WHERE cust_ID = '4590' and cust_Branch = '112'; 
INSERT INTO `cust_savings` (ho_date,ho_edit,saveid,branch,accountno,typetrans,datetrans,amttrans,remarks,remarks1,empid,createdBy,`timestamp`) VALUES 
('','','13668','112','11220222055','insurance','2024-04-06','0.00','LRN11220240239','','006','015','2024-04-08 08:09:30');
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220232153', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='004i', createdBy='015', createddate='2024-04-05 12:48:11', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13655'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220232091', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='004i', createdBy='015', createddate='2024-04-05 12:48:11', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13656'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220221952', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='006', createdBy='015', createddate='2024-04-05 12:48:11', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13657'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220232142', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='004i', createdBy='015', createddate='2024-04-05 12:48:11', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13658'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220232241', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='042', createdBy='015', createddate='2024-04-05 12:48:11', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13659'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220191722', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='004i', createdBy='015', createddate='2024-04-05 12:48:11', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13660'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420190597', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-04-05 15:42:27', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13661'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420221036', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-04-05 15:42:27', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13662'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420180236', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-04-05 15:42:27', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13663'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320210998', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='014', createdBy='031', createddate='2024-04-05 16:50:03', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13664'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320230324', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='014', createdBy='031', createddate='2024-04-05 16:50:03', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13665'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320180085', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='011', createdBy='031', createddate='2024-04-05 16:50:03', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13666'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320211007', typetrans='insurance', datetrans='2024-04-05', amttrans='0.00', remarks1='', empid='004', createdBy='031', createddate='2024-04-05 16:50:03', timestamp='2024-04-06 09:00:11' WHERE branch = '112' and saveid = '13667'; 
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09701226261',spouse_Occupation='PISONET',spouse_Encoded='015',spouse_EncodedDate='2024-04-05 11:28:09',spouse_timestamp='2024-04-06 09:00:11',spouse_LastName='CABUHAT', spouse_FirstName='EDWIN', spouse_MiddleName='PRADO', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='118 BAGONG SIBOL BARANGAY 28 CALOOCAN CITY', spouse_Bday='0000-00-00', spouse_BirthPlace='CALOOCAN CITY' WHERE spouse_ID = '2191' and spouse_Branch = '112'; 
UPDATE fund_check_status SET check_Status='Released',check_Reason='0',check_CanceledDate='0000-00-00 00:00:00',check_Encoded='027',check_timestamp='2024-04-06 11:58:13' WHERE check_Branch = '112' and check_ID_Unique = 'AN11220240414122004814987'; 
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-04-06','166','2024-04-06','22445.00','0.00','0.00','','ACTIVE','015','2024-04-06 14:53:03','2024-04-06 14:53:03');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','11CLC','Deposited','2024-04-06','166','2024-04-06','100.00','0.00','0.00','','ACTIVE','015','2024-04-06 14:53:32','2024-04-06 14:53:32');
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-04-06','166','2024-04-06','770.00','0.00','0.00','','ACTIVE','015','2024-04-06 14:58:00','2024-04-06 14:58: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 
('112','2CLC','Deposited','2024-04-06','166','2024-04-06','2137.00','0.00','0.00','','ACTIVE','015','2024-04-06 15:11:04','2024-04-06 15:11:04');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','12CLC','Deposited','2024-04-06','166','2024-04-06','100.00','0.00','0.00','','ACTIVE','015','2024-04-06 15:47:03','2024-04-06 15:47:03');
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-04-06','166','2024-04-06','6600.00','0.00','0.00','','ACTIVE','015','2024-04-06 15:47:31','2024-04-06 15:47:31');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','13CLC','Deposited','2024-04-06','166','2024-04-06','8845.00','0.00','0.00','','ACTIVE','015','2024-04-06 15:48:36','2024-04-06 15:48:36');
INSERT INTO `fund_sales` (sales_ho_date,sales_ho_edit,overdue_asofdate,overdue_amount,sales_delay_asof,sales_no_delay,sales_restructured_tag,sales_transfer,sales_balance,sales_amortization,pdi_amount,penalty_amount,penalty_percent,sales_csrf_no,sales_mode_payment,sales_interest_bal,sales_prin_bal,sales_interest_amt,sales_prin_amt,sales_other_charger1,sales_other_charges,sales_penalty,sales_other_charger1_bal,sales_other_charges_bal,sales_penalty_bal,sales_product,sales_terms,sales_App_Number,sales_Branch,sales_AccountNo,sales_AssignTo,sales_PNumber,sales_Amt,sales_Area,sales_Cycle,sales_Released,sales_Maturity,sales_BegBalance,sales_LPD,sales_Due,sales_Overdue,sales_Payment,sales_PaymentCutoff,sales_Status,sales_ValidatedBy,sales_ValidatedDate,sales_IncentiveClaim,sales_Void,sales_PostedBy,sales_PostedDate,sales_Timestamp) VALUES 
('','','','0.00','','0','0','','23930.00','270.00','0.00','0.00','0.00','12204','Daily','0.00','27000.00','0.00','27000.00','0.00','0.00','0.00','0.00','0.00','0.00','1','100','AN1122024041412','112','11220222055','006','LRN11220240239','27000.00','3CLC','6','2024-04-06','2024-07-15','27000.00','2024-04-16','0.00','0.00','3070.00','400.00','ACTIVE','015','2024-04-06 11:58:58','0000-00-00','0','015','2024-04-06 11:58:13','2024-04-17 07:49:35');
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='6215.00',sales_amortization='170.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='17000.00',sales_interest_amt='0.00',sales_prin_amt='17000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2021-10-08 13:19:33',sales_Timestamp='2024-04-06 08:23:16',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10785.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2021-10-08 13:21:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211792',sales_AssignTo='037',sales_PNumber='LRN11220210440',sales_Amt='17000.00',sales_Area='12CLC',sales_Cycle='4',sales_Released='2021-10-08',sales_Maturity='2022-01-16',sales_BegBalance='17000.00',sales_LPD='2024-04-05' WHERE sales_PNumber = 'LRN11220210440' ; 
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='015',sales_PostedDate='2023-12-21 13:32:12',sales_Timestamp='2024-04-06 08:23:19',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='25000.00',sales_PaymentCutoff='3060.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-21 13:32:45',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222055',sales_AssignTo='006',sales_PNumber='LRN11220232463',sales_Amt='25000.00',sales_Area='3CLC',sales_Cycle='5',sales_Released='2023-12-21',sales_Maturity='2024-03-30',sales_BegBalance='25000.00',sales_LPD='2024-04-05' WHERE sales_PNumber = 'LRN11220232463' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-01-29 11:56:46',sales_Timestamp='2024-04-06 08:23:19',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='15000.00',sales_PaymentCutoff='2840.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-01-29 11:57:53',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232225',sales_AssignTo='042',sales_PNumber='LRN11220240065',sales_Amt='15000.00',sales_Area='13CLC',sales_Cycle='3',sales_Released='2024-01-29',sales_Maturity='2024-05-08',sales_BegBalance='15000.00',sales_LPD='2024-04-05' WHERE sales_PNumber = 'LRN11220240065' ; 
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','27000.00','0.00','0.00','0.00','0.00','0.00','1185650','LRN11220240239','112','0','0','','0.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','26730.00','0.00','0.00','0.00','0.00','270.00','1185651','LRN11220240239','112','1','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','26460.00','0.00','0.00','0.00','0.00','270.00','1185652','LRN11220240239','112','2','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','26190.00','0.00','0.00','0.00','0.00','270.00','1185653','LRN11220240239','112','3','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','25920.00','0.00','0.00','0.00','0.00','270.00','1185654','LRN11220240239','112','4','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','25650.00','0.00','0.00','0.00','0.00','270.00','1185655','LRN11220240239','112','5','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','25380.00','0.00','0.00','0.00','0.00','270.00','1185656','LRN11220240239','112','6','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','25110.00','0.00','0.00','0.00','0.00','270.00','1185657','LRN11220240239','112','7','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','24840.00','0.00','0.00','0.00','0.00','270.00','1185658','LRN11220240239','112','8','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','24570.00','0.00','0.00','0.00','0.00','270.00','1185659','LRN11220240239','112','9','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','24300.00','0.00','0.00','0.00','0.00','270.00','1185660','LRN11220240239','112','10','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','24030.00','0.00','0.00','0.00','0.00','270.00','1185661','LRN11220240239','112','11','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','23760.00','0.00','0.00','0.00','0.00','270.00','1185662','LRN11220240239','112','12','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','23490.00','0.00','0.00','0.00','0.00','270.00','1185663','LRN11220240239','112','13','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','23220.00','0.00','0.00','0.00','0.00','270.00','1185664','LRN11220240239','112','14','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','22950.00','0.00','0.00','0.00','0.00','270.00','1185665','LRN11220240239','112','15','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','22680.00','0.00','0.00','0.00','0.00','270.00','1185666','LRN11220240239','112','16','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','22410.00','0.00','0.00','0.00','0.00','270.00','1185667','LRN11220240239','112','17','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','22140.00','0.00','0.00','0.00','0.00','270.00','1185668','LRN11220240239','112','18','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','21870.00','0.00','0.00','0.00','0.00','270.00','1185669','LRN11220240239','112','19','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','21600.00','0.00','0.00','0.00','0.00','270.00','1185670','LRN11220240239','112','20','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','21330.00','0.00','0.00','0.00','0.00','270.00','1185671','LRN11220240239','112','21','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','21060.00','0.00','0.00','0.00','0.00','270.00','1185672','LRN11220240239','112','22','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','20790.00','0.00','0.00','0.00','0.00','270.00','1185673','LRN11220240239','112','23','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','20520.00','0.00','0.00','0.00','0.00','270.00','1185674','LRN11220240239','112','24','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','20250.00','0.00','0.00','0.00','0.00','270.00','1185675','LRN11220240239','112','25','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:24','0','19980.00','0.00','0.00','0.00','0.00','270.00','1185676','LRN11220240239','112','26','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','19710.00','0.00','0.00','0.00','0.00','270.00','1185677','LRN11220240239','112','27','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','19440.00','0.00','0.00','0.00','0.00','270.00','1185678','LRN11220240239','112','28','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','19170.00','0.00','0.00','0.00','0.00','270.00','1185679','LRN11220240239','112','29','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','18900.00','0.00','0.00','0.00','0.00','270.00','1185680','LRN11220240239','112','30','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','18630.00','0.00','0.00','0.00','0.00','270.00','1185681','LRN11220240239','112','31','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','18360.00','0.00','0.00','0.00','0.00','270.00','1185682','LRN11220240239','112','32','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','18090.00','0.00','0.00','0.00','0.00','270.00','1185683','LRN11220240239','112','33','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','17820.00','0.00','0.00','0.00','0.00','270.00','1185684','LRN11220240239','112','34','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','17550.00','0.00','0.00','0.00','0.00','270.00','1185685','LRN11220240239','112','35','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','17280.00','0.00','0.00','0.00','0.00','270.00','1185686','LRN11220240239','112','36','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','17010.00','0.00','0.00','0.00','0.00','270.00','1185687','LRN11220240239','112','37','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','16740.00','0.00','0.00','0.00','0.00','270.00','1185688','LRN11220240239','112','38','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','16470.00','0.00','0.00','0.00','0.00','270.00','1185689','LRN11220240239','112','39','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','16200.00','0.00','0.00','0.00','0.00','270.00','1185690','LRN11220240239','112','40','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','15930.00','0.00','0.00','0.00','0.00','270.00','1185691','LRN11220240239','112','41','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','15660.00','0.00','0.00','0.00','0.00','270.00','1185692','LRN11220240239','112','42','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','15390.00','0.00','0.00','0.00','0.00','270.00','1185693','LRN11220240239','112','43','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','15120.00','0.00','0.00','0.00','0.00','270.00','1185694','LRN11220240239','112','44','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','14850.00','0.00','0.00','0.00','0.00','270.00','1185695','LRN11220240239','112','45','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','14580.00','0.00','0.00','0.00','0.00','270.00','1185696','LRN11220240239','112','46','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','14310.00','0.00','0.00','0.00','0.00','270.00','1185697','LRN11220240239','112','47','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','14040.00','0.00','0.00','0.00','0.00','270.00','1185698','LRN11220240239','112','48','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','13770.00','0.00','0.00','0.00','0.00','270.00','1185699','LRN11220240239','112','49','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','13500.00','0.00','0.00','0.00','0.00','270.00','1185700','LRN11220240239','112','50','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','13230.00','0.00','0.00','0.00','0.00','270.00','1185701','LRN11220240239','112','51','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','12960.00','0.00','0.00','0.00','0.00','270.00','1185702','LRN11220240239','112','52','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','12690.00','0.00','0.00','0.00','0.00','270.00','1185703','LRN11220240239','112','53','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','12420.00','0.00','0.00','0.00','0.00','270.00','1185704','LRN11220240239','112','54','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','12150.00','0.00','0.00','0.00','0.00','270.00','1185705','LRN11220240239','112','55','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','11880.00','0.00','0.00','0.00','0.00','270.00','1185706','LRN11220240239','112','56','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','11610.00','0.00','0.00','0.00','0.00','270.00','1185707','LRN11220240239','112','57','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','11340.00','0.00','0.00','0.00','0.00','270.00','1185708','LRN11220240239','112','58','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','11070.00','0.00','0.00','0.00','0.00','270.00','1185709','LRN11220240239','112','59','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','10800.00','0.00','0.00','0.00','0.00','270.00','1185710','LRN11220240239','112','60','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','10530.00','0.00','0.00','0.00','0.00','270.00','1185711','LRN11220240239','112','61','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','10260.00','0.00','0.00','0.00','0.00','270.00','1185712','LRN11220240239','112','62','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','9990.00','0.00','0.00','0.00','0.00','270.00','1185713','LRN11220240239','112','63','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','9720.00','0.00','0.00','0.00','0.00','270.00','1185714','LRN11220240239','112','64','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','9450.00','0.00','0.00','0.00','0.00','270.00','1185715','LRN11220240239','112','65','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','9180.00','0.00','0.00','0.00','0.00','270.00','1185716','LRN11220240239','112','66','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','8910.00','0.00','0.00','0.00','0.00','270.00','1185717','LRN11220240239','112','67','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','8640.00','0.00','0.00','0.00','0.00','270.00','1185718','LRN11220240239','112','68','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','8370.00','0.00','0.00','0.00','0.00','270.00','1185719','LRN11220240239','112','69','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','8100.00','0.00','0.00','0.00','0.00','270.00','1185720','LRN11220240239','112','70','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','7830.00','0.00','0.00','0.00','0.00','270.00','1185721','LRN11220240239','112','71','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','7560.00','0.00','0.00','0.00','0.00','270.00','1185722','LRN11220240239','112','72','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','7290.00','0.00','0.00','0.00','0.00','270.00','1185723','LRN11220240239','112','73','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','7020.00','0.00','0.00','0.00','0.00','270.00','1185724','LRN11220240239','112','74','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','6750.00','0.00','0.00','0.00','0.00','270.00','1185725','LRN11220240239','112','75','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','6480.00','0.00','0.00','0.00','0.00','270.00','1185726','LRN11220240239','112','76','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','6210.00','0.00','0.00','0.00','0.00','270.00','1185727','LRN11220240239','112','77','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','5940.00','0.00','0.00','0.00','0.00','270.00','1185728','LRN11220240239','112','78','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','5670.00','0.00','0.00','0.00','0.00','270.00','1185729','LRN11220240239','112','79','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','5400.00','0.00','0.00','0.00','0.00','270.00','1185730','LRN11220240239','112','80','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','5130.00','0.00','0.00','0.00','0.00','270.00','1185731','LRN11220240239','112','81','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','4860.00','0.00','0.00','0.00','0.00','270.00','1185732','LRN11220240239','112','82','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','4590.00','0.00','0.00','0.00','0.00','270.00','1185733','LRN11220240239','112','83','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','4320.00','0.00','0.00','0.00','0.00','270.00','1185734','LRN11220240239','112','84','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','4050.00','0.00','0.00','0.00','0.00','270.00','1185735','LRN11220240239','112','85','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','3780.00','0.00','0.00','0.00','0.00','270.00','1185736','LRN11220240239','112','86','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','3510.00','0.00','0.00','0.00','0.00','270.00','1185737','LRN11220240239','112','87','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','3240.00','0.00','0.00','0.00','0.00','270.00','1185738','LRN11220240239','112','88','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','2970.00','0.00','0.00','0.00','0.00','270.00','1185739','LRN11220240239','112','89','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','2700.00','0.00','0.00','0.00','0.00','270.00','1185740','LRN11220240239','112','90','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','2430.00','0.00','0.00','0.00','0.00','270.00','1185741','LRN11220240239','112','91','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','2160.00','0.00','0.00','0.00','0.00','270.00','1185742','LRN11220240239','112','92','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','1890.00','0.00','0.00','0.00','0.00','270.00','1185743','LRN11220240239','112','93','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','1620.00','0.00','0.00','0.00','0.00','270.00','1185744','LRN11220240239','112','94','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','1350.00','0.00','0.00','0.00','0.00','270.00','1185745','LRN11220240239','112','95','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','1080.00','0.00','0.00','0.00','0.00','270.00','1185746','LRN11220240239','112','96','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','810.00','0.00','0.00','0.00','0.00','270.00','1185747','LRN11220240239','112','97','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','540.00','0.00','0.00','0.00','0.00','270.00','1185748','LRN11220240239','112','98','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','270.00','0.00','0.00','0.00','0.00','270.00','1185749','LRN11220240239','112','99','0','','270.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-04-06 11:57:25','0','0.00','0.00','0.00','0.00','0.00','270.00','1185750','LRN11220240239','112','100','0','','270.00');
UPDATE pros_application SET temp_pnumber='LRN11220240239',app_ho_date='',app_ho_edit='',app_contract_printing='2024-04-06',dateForwaredtoBH='0000-00-00',reasonFADisapproved='0',recAmount='0.00',faREcommendation='',dateReturned='0000-00-00',dateEndorsed='0000-00-00',app_product='1',app_bank='UBP',app_disbursement='Check',app_mode_of_payment='Cash',app_payment_terms='Daily',app_terms='100',app_interest_deduct='Advance',app_interest_rate='16.00',ho_cancellationDAdate='0000-00-00 00:00:00',ho_cancellationDAby='',ho_cancellationDA='',hoApprovedDate='2024-04-04 15:50:42',hoApprvoedBy='027',app_ho_approved_amt='27000.00',app_Entry='015',app_EntryDate='2024-04-01 11:42:27',app_Branch='112',app_timestamp='2024-04-06 11:58:13',app_Number='AN1122024041412',app_AccountNo='11220222055',app_LastName='VERANO',app_FirstName='SISA',app_MiddleName='DONGON',app_Suffix='',app_HouseNo='',app_Street='',app_Subd='',app_Brgy='0',app_municipality='',app_BirthDay='0000-00-00',app_AppliedAmt='28000.00',app_Date_Applied='2024-04-01',app_Area='3CLC',app_MarketBy='006',app_Status='Released',app_recAmt='28000.00',app_AppDisBy='015',app_AppDisDate='2024-04-01 12:03:55',app_Reason_Cancellation='0',app_Type='RENEWAL' WHERE app_Number = 'AN1122024041412';