UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='', add_Street= 'STA CRUZ ROSARIO', add_Subd= '', add_Brgy= '8785', add_City= 'BATANGAS CITY (CAPITAL)', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1990', add_Status= 'ACTIVE'  WHERE add_ID = '8763' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='', add_Street= 'STA CRUZ ROSARIO', add_Subd= '', add_Brgy= '8785', add_City= 'BATANGAS CITY (Capital)', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1990', add_Status= 'ACTIVE'  WHERE add_ID = '8764' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='', add_Street= 'STA CRUZ ROSARIO', add_Subd= '', add_Brgy= '8785', add_City= 'BATANGAS CITY (CAPITAL)', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1989', add_Status= 'ACTIVE'  WHERE add_ID = '8765' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='', add_Street= 'STA CRUZ ROSARIO', add_Subd= '', add_Brgy= '8785', add_City= 'BATANGAS CITY (Capital)', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1989', add_Status= 'ACTIVE'  WHERE add_ID = '8766' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='', add_Street= 'STA CRUZ ROSARIO', add_Subd= '', add_Brgy= '8785', add_City= 'BATANGAS CITY (CAPITAL)', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '2003', add_Status= 'ACTIVE'  WHERE add_ID = '8767' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='', add_Street= 'STA CRUZ ROSARIO', add_Subd= '', add_Brgy= '8785', add_City= 'BATANGAS CITY (Capital)', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '2003', add_Status= 'ACTIVE'  WHERE add_ID = '8768' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='BLK.11 LOT 16', add_Street= 'PLA PLA', add_Subd= '', add_Brgy= '34898', add_City= 'CALOOCAN CITY', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '8769' and add_Branch = '112'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-09-07 08:38:20',add_HouseNo='', add_Street= 'BLK.11 LOT 16 PLA PLA  BARANGA', add_Subd= '', add_Brgy= '34898', add_City= 'CALOOCAN CITY', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1980', add_Status= 'ACTIVE'  WHERE add_ID = '8770' and add_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='TELEVISION', asset_purchased= '2021-10-13', asset_Description= 'FUKUDA', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:45:56', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10156' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='REFRIGERATOR', asset_purchased= '2022-02-09', asset_Description= 'SHARP', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:45:56', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10157' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='ELECTRIC FAN', asset_purchased= '2021-07-07', asset_Description= 'STANDARD', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:45:56', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10158' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='OTHERS', asset_purchased= '2023-03-07', asset_Description= 'EUREKA STOVE', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:45:56', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10159' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='RICE COOKER', asset_purchased= '2021-02-10', asset_Description= 'HANABISHI', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:45:56', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10160' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='OTHERS', asset_purchased= '2023-02-01', asset_Description= 'AIR FRYER', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:45:56', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10161' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='TELEVISION', asset_purchased= '2022-06-30', asset_Description= 'NATIONAL', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:49:01', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10162' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='REFRIGERATOR', asset_purchased= '2022-03-09', asset_Description= 'LG', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:49:01', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10163' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='WASHING MACHINE', asset_purchased= '2021-07-14', asset_Description= 'SHARP', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:49:01', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10164' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='OTHERS', asset_purchased= '2023-03-09', asset_Description= 'EUREKA DRYER', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:49:01', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10165' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='ELECTRIC FAN', asset_purchased= '2021-07-06', asset_Description= 'EUREKA', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:49:01', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10166' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='OTHERS', asset_purchased= '2023-06-28', asset_Description= 'SEWING MACHINE', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:49:01', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10167' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='WASHING MACHINE', asset_purchased= '2023-03-24', asset_Description= 'SHARP', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:51:31', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10168' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='OTHERS', asset_purchased= '2021-03-16', asset_Description= 'SHARP DRYER', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:51:31', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10169' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='REFRIGERATOR', asset_purchased= '2022-06-14', asset_Description= 'SHARP', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:51:31', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10170' and asset_Branch = '112'; 
UPDATE cust_asset SET asset_ho_date='',asset_ho_by='',asset_Item='ELECTRIC FAN', asset_purchased= '2022-03-08', asset_Description= 'SHARP', asset_Deleted= '0', asset_Encoded= '002B', asset_EncodedDate= '2024-09-06 09:51:31', asset_timestamp= '2024-09-07 08:38:20' WHERE asset_ID = '10171' and asset_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='650.00',bus_gross_daily_income='1000.00',buss_worth_stocks='20000.00',buss_capitalization='25000.00',buss_description='SARI SARI STORE',buss_Type='Primary', buss_Name= '2', buss_Address= 'STA CRUZ ROSARIO ', buss_Started= '2022-02-09', buss_Contact= '09918081993', buss_Deleted= '0', buss_Encoded= '002B', buss_EncodedDate= '2024-09-06 09:30:24', buss_timestamp= '2024-09-07 08:38:20' WHERE buss_ID = '3821' and buss_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='706.00',bus_gross_daily_income='1050.00',buss_worth_stocks='30000.00',buss_capitalization='35000.00',buss_description='SARI SARI STORE',buss_Type='Primary', buss_Name= '2', buss_Address= 'STA CRUZ ROSARIO ', buss_Started= '2019-02-06', buss_Contact= '09535461751', buss_Deleted= '0', buss_Encoded= '002B', buss_EncodedDate= '2024-09-06 09:35:59', buss_timestamp= '2024-09-07 08:38:20' WHERE buss_ID = '3822' and buss_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='573.00',bus_gross_daily_income='1000.00',buss_worth_stocks='20000.00',buss_capitalization='30000.00',buss_description='SARI SARI STORE',buss_Type='Primary', buss_Name= '2', buss_Address= 'STA CRUZ ROSARIO ', buss_Started= '2022-03-02', buss_Contact= '09635679242', buss_Deleted= '0', buss_Encoded= '002B', buss_EncodedDate= '2024-09-06 10:04:20', buss_timestamp= '2024-09-07 08:38:20' WHERE buss_ID = '3823' and buss_Branch = '112'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='45000.00',bus_gross_daily_income='100000.00',buss_worth_stocks='100000.00',buss_capitalization='100000.00',buss_description='VAN FOR HIRE',buss_Type='Primary', buss_Name= '314', buss_Address= ' BLK.11 LOT 16 PLA PLA BARANGAY 12 CALOOCAN CITY', buss_Started= '1994-01-01', buss_Contact= '', buss_Deleted= '0', buss_Encoded= '015', buss_EncodedDate= '2024-09-06 14:12:29', buss_timestamp= '2024-09-07 08:38:20' WHERE buss_ID = '3824' 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','360553','0.00','0.00','0.00','0.00','0.00','112-142587','112','12CLC','LRN11220240579','2024-09-07','0','','170.00','','006','0','112','015','2024-09-07 14:19:32','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19:32');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360554','0.00','0.00','0.00','0.00','0.00','112-142588','112','12CLC','LRN11220240616','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 14:19:34','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19:34');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360555','0.00','0.00','0.00','0.00','0.00','112-142589','112','12CLC','LRN11220240485','2024-09-07','0','','150.00','','006','0','112','015','2024-09-07 14:19:36','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19:36');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360556','0.00','0.00','0.00','0.00','0.00','112-142590','112','12CLC','LRN11220240483','2024-09-07','0','','100.00','','006','0','112','015','2024-09-07 14:19:38','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19: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','360557','0.00','0.00','0.00','0.00','0.00','112-142591','112','12CLC','LRN11220240626','2024-09-07','0','','190.00','','006','0','112','015','2024-09-07 14:19:41','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19: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','360558','0.00','0.00','0.00','0.00','0.00','112-142592','112','12CLC','LRN11220240511','2024-09-07','0','','120.00','','006','0','112','015','2024-09-07 14:19:43','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19: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','360559','0.00','0.00','0.00','0.00','0.00','112-142593','112','12CLC','LRN11220240480','2024-09-07','0','','150.00','','006','0','112','015','2024-09-07 14:19:45','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19: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','360560','0.00','0.00','0.00','0.00','0.00','112-142594','112','12CLC','LRN11220240539','2024-09-07','0','','100.00','','006','0','112','015','2024-09-07 14:19:47','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19: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','360561','0.00','0.00','0.00','0.00','0.00','112-142595','112','12CLC','LRN11220240549','2024-09-07','0','','150.00','','006','0','112','015','2024-09-07 14:19:49','0','0000-00-00 00:00:00','0','015','2024-09-07 14:17:51','2024-09-07 14:19: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','360562','0.00','0.00','0.00','0.00','0.00','112-142596','112','11CLC','LRN11220232079','2024-09-07','0','','50.00','','006','0','112','015','2024-09-07 14:48:11','0','0000-00-00 00:00:00','0','015','2024-09-07 14:40:44','2024-09-07 14:48:11');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360563','0.00','0.00','0.00','0.00','0.00','112-142597','112','4CLC','LRN11220240441','2024-09-07','0','','280.00','','004i','0','112','015','2024-09-07 14:49:30','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49:30');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360564','0.00','0.00','0.00','0.00','0.00','112-142598','112','4CLC','LRN11220240476','2024-09-07','0','','1440.00','','004i','0','112','015','2024-09-07 14:49:32','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49:32');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360565','0.00','0.00','0.00','0.00','0.00','112-142599','112','4CLC','LRN11220240431','2024-09-07','0','','300.00','','004i','0','112','015','2024-09-07 14:49:35','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360566','0.00','0.00','0.00','0.00','0.00','112-142600','112','4CLC','LRN11220240370','2024-09-07','0','','100.00','','004i','0','112','015','2024-09-07 14:49:37','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360567','0.00','0.00','0.00','0.00','0.00','112-142601','112','4CLC','LRN11220232366','2024-09-07','0','','100.00','','004i','0','112','015','2024-09-07 14:49:39','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360568','0.00','0.00','0.00','0.00','0.00','112-142602','112','4CLC','LRN11220240612','2024-09-07','0','','500.00','','004i','0','112','015','2024-09-07 14:49:41','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360569','0.00','0.00','0.00','0.00','0.00','112-142603','112','4CLC','LRN11220240640','2024-09-07','0','','350.00','','004i','0','112','015','2024-09-07 14:49:43','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360570','0.00','0.00','0.00','0.00','0.00','112-142604','112','4CLC','LRN11220240543','2024-09-07','0','','420.00','','004i','0','112','015','2024-09-07 14:49:45','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360571','0.00','0.00','0.00','0.00','0.00','112-142605','112','4CLC','LRN11220240535','2024-09-07','0','','350.00','','004i','0','112','015','2024-09-07 14:49:47','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360572','0.00','0.00','0.00','0.00','0.00','112-142606','112','4CLC','LRN11220240472','2024-09-07','0','','300.00','','004i','0','112','015','2024-09-07 14:49:49','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360573','0.00','0.00','0.00','0.00','0.00','112-142607','112','4CLC','LRN11220240119','2024-09-07','0','','200.00','','004i','0','112','015','2024-09-07 14:49:51','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360574','0.00','0.00','0.00','0.00','0.00','112-142608','112','4CLC','LRN11220240498','2024-09-07','0','','300.00','','004i','0','112','015','2024-09-07 14:49:53','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360575','0.00','0.00','0.00','0.00','0.00','112-142609','112','4CLC','LRN11220232442','2024-09-07','0','','50.00','','004i','0','112','015','2024-09-07 14:49:55','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360576','0.00','0.00','0.00','0.00','0.00','112-142610','112','4CLC','LRN11220240467','2024-09-07','0','','100.00','','004i','0','112','015','2024-09-07 14:49:57','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360577','0.00','0.00','0.00','0.00','0.00','112-142611','112','4CLC','LRN11220240514','2024-09-07','0','','190.00','','004i','0','112','015','2024-09-07 14:49:59','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:49: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','360578','0.00','0.00','0.00','0.00','0.00','112-142612','112','4CLC','LRN11220240635','2024-09-07','0','','100.00','','004i','0','112','015','2024-09-07 14:50:02','0','0000-00-00 00:00:00','0','015','2024-09-07 14:46:36','2024-09-07 14:50:02');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360579','0.00','0.00','0.00','0.00','0.00','112-142613','112','2CLC','LRN11220240475','2024-09-07','0','','140.00','','002','0','112','015','2024-09-07 14:59:31','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360580','0.00','0.00','0.00','0.00','0.00','112-142614','112','2CLC','LRN11220240617','2024-09-07','0','','400.00','','002','0','112','015','2024-09-07 14:59:33','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360581','0.00','0.00','0.00','0.00','0.00','112-142615','112','2CLC','LRN11220240486','2024-09-07','0','','300.00','','002','0','112','015','2024-09-07 14:59:35','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360582','0.00','0.00','0.00','0.00','0.00','112-142616','112','2CLC','LRN11220240553','2024-09-07','0','','700.00','','002','0','112','015','2024-09-07 14:59:37','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360583','0.00','0.00','0.00','0.00','0.00','112-142617','112','2CLC','LRN11220240646','2024-09-07','0','','170.00','','002','0','112','015','2024-09-07 14:59:39','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360584','0.00','0.00','0.00','0.00','0.00','112-142618','112','2CLC','LRN11220240562','2024-09-07','0','','350.00','','002','0','112','015','2024-09-07 14:59:41','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360585','0.00','0.00','0.00','0.00','0.00','112-142619','112','2CLC','LRN11220240641','2024-09-07','0','','220.00','','002','0','112','015','2024-09-07 14:59:43','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360586','0.00','0.00','0.00','0.00','0.00','112-142620','112','2CLC','LRN11220240609','2024-09-07','0','','200.00','','002','0','112','015','2024-09-07 14:59:45','0','0000-00-00 00:00:00','0','015','2024-09-07 14:58:27','2024-09-07 14:59: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','360587','0.00','0.00','0.00','0.00','0.00','112-142621','112','13CLC','LRN11220240628','2024-09-07','0','','400.00','','006','0','112','015','2024-09-07 15:35:59','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:35: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','360588','0.00','0.00','0.00','0.00','0.00','112-142622','112','13CLC','LRN11220240647','2024-09-07','0','','1150.00','','006','0','112','015','2024-09-07 15:36:01','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36: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','360589','0.00','0.00','0.00','0.00','0.00','112-142623','112','13CLC','LRN11220240567','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:36:03','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36: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','360590','0.00','0.00','0.00','0.00','0.00','112-142624','112','13CLC','LRN11220240573','2024-09-07','0','','120.00','','006','0','112','015','2024-09-07 15:36:05','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36: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','360591','0.00','0.00','0.00','0.00','0.00','112-142625','112','13CLC','LRN11220240586','2024-09-07','0','','170.00','','006','0','112','015','2024-09-07 15:36:07','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:07');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360592','0.00','0.00','0.00','0.00','0.00','112-142626','112','13CLC','LRN11220240582','2024-09-07','0','','300.00','','006','0','112','015','2024-09-07 15:36:09','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:09');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360593','0.00','0.00','0.00','0.00','0.00','112-142627','112','13CLC','LRN11220240618','2024-09-07','0','','500.00','','006','0','112','015','2024-09-07 15:36:11','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:11');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360594','0.00','0.00','0.00','0.00','0.00','112-142628','112','13CLC','LRN11220240601','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:36:13','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:13');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360595','0.00','0.00','0.00','0.00','0.00','112-142629','112','13CLC','LRN11220232344','2024-09-07','0','','500.00','','006','0','112','015','2024-09-07 15:36:15','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36: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','360596','0.00','0.00','0.00','0.00','0.00','112-142630','112','13CLC','LRN11220240478','2024-09-07','0','','1050.00','','006','0','112','015','2024-09-07 15:36:17','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36: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','360597','0.00','0.00','0.00','0.00','0.00','112-142631','112','13CLC','LRN11220240508','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:36:20','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:20');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360598','0.00','0.00','0.00','0.00','0.00','112-142632','112','13CLC','LRN11220240321','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:36:22','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:22');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360599','0.00','0.00','0.00','0.00','0.00','112-142633','112','13CLC','LRN11220240587','2024-09-07','0','','400.00','','006','0','112','015','2024-09-07 15:36:24','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:24');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360600','0.00','0.00','0.00','0.00','0.00','112-142634','112','13CLC','LRN11220240571','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:36:26','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36: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','360601','0.00','0.00','0.00','0.00','0.00','112-142635','112','13CLC','LRN11220240340','2024-09-07','0','','500.00','','006','0','112','015','2024-09-07 15:36:28','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:28');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360602','0.00','0.00','0.00','0.00','0.00','112-142636','112','13CLC','LRN11220240556','2024-09-07','0','','400.00','','006','0','112','015','2024-09-07 15:36:30','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:30');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360603','0.00','0.00','0.00','0.00','0.00','112-142637','112','13CLC','LRN11220240505','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:36:32','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:32');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360604','0.00','0.00','0.00','0.00','0.00','112-142638','112','13CLC','LRN11220240499','2024-09-07','0','','500.00','','006','0','112','015','2024-09-07 15:36:34','0','0000-00-00 00:00:00','0','015','2024-09-07 15:34:49','2024-09-07 15:36:34');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360605','0.00','0.00','0.00','0.00','0.00','112-142639','112','11CLC','LRN11220240390','2024-09-07','0','','120.00','','006','0','112','015','2024-09-07 15:40:25','0','0000-00-00 00:00:00','0','015','2024-09-07 15:39:10','2024-09-07 15:40:25');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360606','0.00','0.00','0.00','0.00','0.00','112-142640','112','11CLC','LRN11220240438','2024-09-07','0','','1500.00','','006','0','112','015','2024-09-07 15:40:27','0','0000-00-00 00:00:00','0','015','2024-09-07 15:39:10','2024-09-07 15:40: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','360607','0.00','0.00','0.00','0.00','0.00','112-142641','112','3CLC','LRN11220240507','2024-09-07','0','','210.00','','006','0','112','015','2024-09-07 15:51:00','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51:00');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360608','0.00','0.00','0.00','0.00','0.00','112-142642','112','3CLC','LRN11220240624','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:51:02','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360609','0.00','0.00','0.00','0.00','0.00','112-142643','112','3CLC','LRN11220240551','2024-09-07','0','','350.00','','006','0','112','015','2024-09-07 15:51:04','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51:04');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360610','0.00','0.00','0.00','0.00','0.00','112-142644','112','3CLC','LRN11220240377','2024-09-07','0','','1700.00','','006','0','112','015','2024-09-07 15:51:06','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360611','0.00','0.00','0.00','0.00','0.00','112-142645','112','3CLC','LRN11220240602','2024-09-07','0','','210.00','','006','0','112','015','2024-09-07 15:51:08','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360612','0.00','0.00','0.00','0.00','0.00','112-142646','112','3CLC','LRN11220240630','2024-09-07','0','','400.00','','006','0','112','015','2024-09-07 15:51:10','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360613','0.00','0.00','0.00','0.00','0.00','112-142647','112','3CLC','LRN11220240494','2024-09-07','0','','420.00','','006','0','112','015','2024-09-07 15:51:13','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51:13');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360614','0.00','0.00','0.00','0.00','0.00','112-142648','112','3CLC','LRN11220240419','2024-09-07','0','','550.00','','006','0','112','015','2024-09-07 15:51:15','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360615','0.00','0.00','0.00','0.00','0.00','112-142649','112','3CLC','LRN11220240118','2024-09-07','0','','200.00','','006','0','112','015','2024-09-07 15:51:17','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360616','0.00','0.00','0.00','0.00','0.00','112-142650','112','3CLC','LRN11220240559','2024-09-07','0','','150.00','','006','0','112','015','2024-09-07 15:51:19','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360617','0.00','0.00','0.00','0.00','0.00','112-142651','112','3CLC','LRN11220240328','2024-09-07','0','','100.00','','006','0','112','015','2024-09-07 15:51:21','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360618','0.00','0.00','0.00','0.00','0.00','112-142652','112','3CLC','LRN11220240588','2024-09-07','0','','600.00','','006','0','112','015','2024-09-07 15:51:23','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360619','0.00','0.00','0.00','0.00','0.00','112-142653','112','3CLC','LRN11220240534','2024-09-07','0','','300.00','','006','0','112','015','2024-09-07 15:51:25','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51:25');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','360620','0.00','0.00','0.00','0.00','0.00','112-142654','112','3CLC','LRN11220240497','2024-09-07','0','','350.00','','006','0','112','015','2024-09-07 15:51:27','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360621','0.00','0.00','0.00','0.00','0.00','112-142655','112','3CLC','LRN11220240542','2024-09-07','0','','700.00','','006','0','112','015','2024-09-07 15:51:29','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360622','0.00','0.00','0.00','0.00','0.00','112-142656','112','3CLC','LRN11220240607','2024-09-07','0','','1120.00','','006','0','112','015','2024-09-07 15:51:31','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360623','0.00','0.00','0.00','0.00','0.00','112-142657','112','3CLC','LRN11220240439','2024-09-07','0','','400.00','','006','0','112','015','2024-09-07 15:51:33','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51: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','360624','0.00','0.00','0.00','0.00','0.00','112-142658','112','3CLC','LRN11220240623','2024-09-07','0','','500.00','','006','0','112','015','2024-09-07 15:51:35','0','0000-00-00 00:00:00','0','015','2024-09-07 15:49:21','2024-09-07 15:51:35');
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09635679242', contact_Status= 'ACTIVE', contact_Encoded= '002B', contact_EncodedDate= '2024-09-06 09:06:52', contact_timestamp= '2024-09-07 08:38:20' WHERE contact_Cust_ID = '5722' and contact_ID = '7390'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='LANDLINE NO', contact_Number= '09635679242', contact_Status= 'ACTIVE', contact_Encoded= '002B', contact_EncodedDate= '2024-09-06 09:06:52', contact_timestamp= '2024-09-07 08:38:20' WHERE contact_Cust_ID = '5722' and contact_ID = '7391'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09918081993', contact_Status= 'ACTIVE', contact_Encoded= '002B', contact_EncodedDate= '2024-09-06 09:09:15', contact_timestamp= '2024-09-07 08:38:20' WHERE contact_Cust_ID = '5723' and contact_ID = '7392'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='LANDLINE NO', contact_Number= '09918081993', contact_Status= 'ACTIVE', contact_Encoded= '002B', contact_EncodedDate= '2024-09-06 09:09:15', contact_timestamp= '2024-09-07 08:38:20' WHERE contact_Cust_ID = '5723' and contact_ID = '7393'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09535461751', contact_Status= 'ACTIVE', contact_Encoded= '002B', contact_EncodedDate= '2024-09-06 09:12:47', contact_timestamp= '2024-09-07 08:38:20' WHERE contact_Cust_ID = '5724' and contact_ID = '7394'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='LANDLINE NO', contact_Number= '06535461751', contact_Status= 'ACTIVE', contact_Encoded= '002B', contact_EncodedDate= '2024-09-06 09:12:47', contact_timestamp= '2024-09-07 08:38:20' WHERE contact_Cust_ID = '5724' and contact_ID = '7395'; 
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09363913170', contact_Status= 'ACTIVE', contact_Encoded= '015', contact_EncodedDate= '2024-09-06 14:06:02', contact_timestamp= '2024-09-07 08:38:20' WHERE contact_Cust_ID = '5725' and contact_ID = '7396'; 
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_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_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_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='11220170597', cust_Gender='FEMALE', cust_CivilStatus='MARRIED', cust_Cycle='13', cust_Status='ACTIVE', cust_encoded='009', cust_encodeDate='2017-09-29 12:11:38', cust_timestamp='2024-09-07 11:59:01', cust_LastName='MIRADOR',cust_FirstName='CARMEN',cust_MiddleName='MERCADO',cust_Suffix='',cust_MaidenName='MERCADO',cust_NickName='CARMEN',cust_Area='3CLC',cust_Nationality='FILIPINO', cust_Bday= '1961-05-08', cust_BirthPlace= 'CALOOCAN CITY' WHERE cust_ID = '616' and cust_Branch = '112'; 
INSERT INTO `cust_savings` (ho_date,ho_edit,saveid,branch,accountno,typetrans,datetrans,amttrans,remarks,remarks1,empid,createdBy,`timestamp`) VALUES 
('','','15162','112','11220170597','insurance','2024-09-07','0.00','LRN11220240652','','006','015','2024-09-07 16:26:50');
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09535461751',spouse_Occupation='TC OPERATOR',spouse_Encoded='002B',spouse_EncodedDate='2024-09-06 09:19:34',spouse_timestamp='2024-09-07 08:38:20',spouse_LastName='BENAMER', spouse_FirstName='ERNESTO', spouse_MiddleName='MAGADIA', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='STA CRUZ ROSARIO BATANGAS', spouse_Bday='0000-00-00', spouse_BirthPlace='ROSARIO BATANGAS' WHERE spouse_ID = '2290' and spouse_Branch = '112'; 
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09941884566',spouse_Occupation='TAGATIMPLA NG GAMOT',spouse_Encoded='002B',spouse_EncodedDate='2024-09-06 09:23:24',spouse_timestamp='2024-09-07 08:38:20',spouse_LastName='REYES', spouse_FirstName='CIRIACO', spouse_MiddleName='PALMA', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='STA CRUZ ROSARIO BATANGAS', spouse_Bday='0000-00-00', spouse_BirthPlace='BATANGAS' WHERE spouse_ID = '2291' and spouse_Branch = '112'; 
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09918081993',spouse_Occupation='MAINTENANCE CREW',spouse_Encoded='002B',spouse_EncodedDate='2024-09-06 09:26:49',spouse_timestamp='2024-09-07 08:38:20',spouse_LastName='VILLAVERDE', spouse_FirstName='ARNEL', spouse_MiddleName='MAGABELEN', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='STA CRUZ ROSARIO BATANGAS', spouse_Bday='0000-00-00', spouse_BirthPlace='ROSARIO BATANGAS' WHERE spouse_ID = '2292' and spouse_Branch = '112'; 
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09363913170',spouse_Occupation='NONE',spouse_Encoded='015',spouse_EncodedDate='2024-09-06 14:09:15',spouse_timestamp='2024-09-07 08:38:20',spouse_LastName='DE LEON', spouse_FirstName='RYAN', spouse_MiddleName='DUYAN', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='BLK.11 LOT 16 PLA PLA BARANGAY 12 CALOOCAN CITY', spouse_Bday='0000-00-00', spouse_BirthPlace='CALOOCAN CITY' WHERE spouse_ID = '2293' 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-09-07 11:58:02' WHERE check_Branch = '112' and check_ID_Unique = 'AN11220240918752004920815'; 
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','12CLC','Deposited','2024-09-07','166','2024-12-07','1330.00','0.00','0.00','','ACTIVE','015','2024-09-07 14:39:42','2024-09-07 14:39:42');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','4CLC','Deposited','2024-09-07','166','2024-09-07','5080.00','0.00','0.00','','ACTIVE','015','2024-09-07 14:50:54','2024-09-07 14:50:54');
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-09-07','166','2024-09-07','50.00','0.00','0.00','','ACTIVE','015','2024-09-07 14:51:59','2024-09-07 14:51:59');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','2CLC','Deposited','2024-09-07','166','2024-09-07','2480.00','0.00','0.00','','ACTIVE','015','2024-09-07 15:01:14','2024-09-07 15:01:14');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','13CLC','Deposited','2024-09-07','166','2024-09-07','7190.00','0.00','0.00','','ACTIVE','015','2024-09-07 15:37:53','2024-09-07 15:37:53');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','13CLC','Deposited','2024-09-07','166','2024-09-07','1620.00','0.00','0.00','','ACTIVE','015','2024-09-07 15:53:56','2024-09-07 15:53:56');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','3CLC','Deposited','2024-09-07','166','2024-09-07','8460.00','0.00','0.00','','ACTIVE','015','2024-09-07 15:54:22','2024-09-07 15:54:22');
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','','41050.00','450.00','0.00','0.00','0.00','13748','Daily','0.00','45000.00','0.00','45000.00','0.00','0.00','0.00','0.00','0.00','0.00','1','100','AN1122024091875','112','11220170597','006','LRN11220240652','45000.00','3CLC','13','2024-09-07','2024-12-16','45000.00','2024-09-16','0.00','0.00','3950.00','500.00','ACTIVE','015','2024-09-07 11:59:01','0000-00-00','0','015','2024-09-07 11:58:02','2024-09-17 07:56:10');
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='3330.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-17 13:39:18',sales_Timestamp='2024-09-07 16:30:15',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8670.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-17 13:42:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232161',sales_AssignTo='034',sales_PNumber='LRN11220232079',sales_Amt='12000.00',sales_Area='11CLC',sales_Cycle='2',sales_Released='2023-08-17',sales_Maturity='2023-11-25',sales_BegBalance='12000.00',sales_LPD='2024-09-07' WHERE sales_PNumber = 'LRN11220232079' ; 
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='12620.00',sales_amortization='700.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='70000.00',sales_interest_amt='0.00',sales_prin_amt='70000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-15 12:27:02',sales_Timestamp='2024-09-07 16:30:15',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='57380.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-15 12:30:19',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211812',sales_AssignTo='042',sales_PNumber='LRN11220232344',sales_Amt='70000.00',sales_Area='13CLC',sales_Cycle='14',sales_Released='2023-11-15',sales_Maturity='2024-02-23',sales_BegBalance='70000.00',sales_LPD='2024-09-07' WHERE sales_PNumber = 'LRN11220232344' ; 
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='450.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='45000.00',sales_interest_amt='0.00',sales_prin_amt='45000.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-05-30 10:10:01',sales_Timestamp='2024-09-07 08:34:58',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='45000.00',sales_PaymentCutoff='12750.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-30 10:10:41',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170597',sales_AssignTo='006',sales_PNumber='LRN11220240399',sales_Amt='45000.00',sales_Area='3CLC',sales_Cycle='12',sales_Released='2024-05-30',sales_Maturity='2024-09-07',sales_BegBalance='45000.00',sales_LPD='2024-09-06' WHERE sales_PNumber = 'LRN11220240399' ; 
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='8400.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-08-22 13:24:15',sales_Timestamp='2024-09-07 16:30:16',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1600.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-08-22 13:28:06',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242336',sales_AssignTo='042',sales_PNumber='LRN11220240618',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2024-08-22',sales_Maturity='2024-11-30',sales_BegBalance='10000.00',sales_LPD='2024-09-07' WHERE sales_PNumber = 'LRN11220240618' ; 
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-09-07 11:57:08','0','45000.00','0.00','0.00','0.00','0.00','0.00','1337761','LRN11220240652','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-09-07 11:57:08','0','44550.00','0.00','0.00','0.00','0.00','450.00','1337762','LRN11220240652','112','1','0','','450.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-09-07 11:57:08','0','44100.00','0.00','0.00','0.00','0.00','450.00','1337763','LRN11220240652','112','2','0','','450.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-09-07 11:57:08','0','43650.00','0.00','0.00','0.00','0.00','450.00','1337764','LRN11220240652','112','3','0','','450.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-09-07 11:57:08','0','43200.00','0.00','0.00','0.00','0.00','450.00','1337765','LRN11220240652','112','4','0','','450.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-09-07 11:57:08','0','42750.00','0.00','0.00','0.00','0.00','450.00','1337766','LRN11220240652','112','5','0','','450.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-09-07 11:57:09','0','42300.00','0.00','0.00','0.00','0.00','450.00','1337767','LRN11220240652','112','6','0','','450.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-09-07 11:57:09','0','41850.00','0.00','0.00','0.00','0.00','450.00','1337768','LRN11220240652','112','7','0','','450.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-09-07 11:57:09','0','41400.00','0.00','0.00','0.00','0.00','450.00','1337769','LRN11220240652','112','8','0','','450.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-09-07 11:57:09','0','40950.00','0.00','0.00','0.00','0.00','450.00','1337770','LRN11220240652','112','9','0','','450.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-09-07 11:57:09','0','40500.00','0.00','0.00','0.00','0.00','450.00','1337771','LRN11220240652','112','10','0','','450.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-09-07 11:57:09','0','40050.00','0.00','0.00','0.00','0.00','450.00','1337772','LRN11220240652','112','11','0','','450.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-09-07 11:57:09','0','39600.00','0.00','0.00','0.00','0.00','450.00','1337773','LRN11220240652','112','12','0','','450.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-09-07 11:57:09','0','39150.00','0.00','0.00','0.00','0.00','450.00','1337774','LRN11220240652','112','13','0','','450.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-09-07 11:57:09','0','38700.00','0.00','0.00','0.00','0.00','450.00','1337775','LRN11220240652','112','14','0','','450.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-09-07 11:57:09','0','38250.00','0.00','0.00','0.00','0.00','450.00','1337776','LRN11220240652','112','15','0','','450.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-09-07 11:57:09','0','37800.00','0.00','0.00','0.00','0.00','450.00','1337777','LRN11220240652','112','16','0','','450.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-09-07 11:57:09','0','37350.00','0.00','0.00','0.00','0.00','450.00','1337778','LRN11220240652','112','17','0','','450.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-09-07 11:57:09','0','36900.00','0.00','0.00','0.00','0.00','450.00','1337779','LRN11220240652','112','18','0','','450.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-09-07 11:57:09','0','36450.00','0.00','0.00','0.00','0.00','450.00','1337780','LRN11220240652','112','19','0','','450.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-09-07 11:57:09','0','36000.00','0.00','0.00','0.00','0.00','450.00','1337781','LRN11220240652','112','20','0','','450.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-09-07 11:57:09','0','35550.00','0.00','0.00','0.00','0.00','450.00','1337782','LRN11220240652','112','21','0','','450.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-09-07 11:57:09','0','35100.00','0.00','0.00','0.00','0.00','450.00','1337783','LRN11220240652','112','22','0','','450.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-09-07 11:57:09','0','34650.00','0.00','0.00','0.00','0.00','450.00','1337784','LRN11220240652','112','23','0','','450.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-09-07 11:57:09','0','34200.00','0.00','0.00','0.00','0.00','450.00','1337785','LRN11220240652','112','24','0','','450.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-09-07 11:57:09','0','33750.00','0.00','0.00','0.00','0.00','450.00','1337786','LRN11220240652','112','25','0','','450.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-09-07 11:57:09','0','33300.00','0.00','0.00','0.00','0.00','450.00','1337787','LRN11220240652','112','26','0','','450.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-09-07 11:57:09','0','32850.00','0.00','0.00','0.00','0.00','450.00','1337788','LRN11220240652','112','27','0','','450.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-09-07 11:57:09','0','32400.00','0.00','0.00','0.00','0.00','450.00','1337789','LRN11220240652','112','28','0','','450.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-09-07 11:57:09','0','31950.00','0.00','0.00','0.00','0.00','450.00','1337790','LRN11220240652','112','29','0','','450.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-09-07 11:57:09','0','31500.00','0.00','0.00','0.00','0.00','450.00','1337791','LRN11220240652','112','30','0','','450.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-09-07 11:57:09','0','31050.00','0.00','0.00','0.00','0.00','450.00','1337792','LRN11220240652','112','31','0','','450.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-09-07 11:57:09','0','30600.00','0.00','0.00','0.00','0.00','450.00','1337793','LRN11220240652','112','32','0','','450.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-09-07 11:57:09','0','30150.00','0.00','0.00','0.00','0.00','450.00','1337794','LRN11220240652','112','33','0','','450.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-09-07 11:57:09','0','29700.00','0.00','0.00','0.00','0.00','450.00','1337795','LRN11220240652','112','34','0','','450.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-09-07 11:57:09','0','29250.00','0.00','0.00','0.00','0.00','450.00','1337796','LRN11220240652','112','35','0','','450.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-09-07 11:57:09','0','28800.00','0.00','0.00','0.00','0.00','450.00','1337797','LRN11220240652','112','36','0','','450.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-09-07 11:57:09','0','28350.00','0.00','0.00','0.00','0.00','450.00','1337798','LRN11220240652','112','37','0','','450.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-09-07 11:57:09','0','27900.00','0.00','0.00','0.00','0.00','450.00','1337799','LRN11220240652','112','38','0','','450.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-09-07 11:57:09','0','27450.00','0.00','0.00','0.00','0.00','450.00','1337800','LRN11220240652','112','39','0','','450.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-09-07 11:57:09','0','27000.00','0.00','0.00','0.00','0.00','450.00','1337801','LRN11220240652','112','40','0','','450.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-09-07 11:57:09','0','26550.00','0.00','0.00','0.00','0.00','450.00','1337802','LRN11220240652','112','41','0','','450.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-09-07 11:57:09','0','26100.00','0.00','0.00','0.00','0.00','450.00','1337803','LRN11220240652','112','42','0','','450.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-09-07 11:57:09','0','25650.00','0.00','0.00','0.00','0.00','450.00','1337804','LRN11220240652','112','43','0','','450.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-09-07 11:57:09','0','25200.00','0.00','0.00','0.00','0.00','450.00','1337805','LRN11220240652','112','44','0','','450.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-09-07 11:57:09','0','24750.00','0.00','0.00','0.00','0.00','450.00','1337806','LRN11220240652','112','45','0','','450.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-09-07 11:57:09','0','24300.00','0.00','0.00','0.00','0.00','450.00','1337807','LRN11220240652','112','46','0','','450.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-09-07 11:57:09','0','23850.00','0.00','0.00','0.00','0.00','450.00','1337808','LRN11220240652','112','47','0','','450.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-09-07 11:57:09','0','23400.00','0.00','0.00','0.00','0.00','450.00','1337809','LRN11220240652','112','48','0','','450.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-09-07 11:57:09','0','22950.00','0.00','0.00','0.00','0.00','450.00','1337810','LRN11220240652','112','49','0','','450.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-09-07 11:57:09','0','22500.00','0.00','0.00','0.00','0.00','450.00','1337811','LRN11220240652','112','50','0','','450.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-09-07 11:57:09','0','22050.00','0.00','0.00','0.00','0.00','450.00','1337812','LRN11220240652','112','51','0','','450.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-09-07 11:57:09','0','21600.00','0.00','0.00','0.00','0.00','450.00','1337813','LRN11220240652','112','52','0','','450.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-09-07 11:57:09','0','21150.00','0.00','0.00','0.00','0.00','450.00','1337814','LRN11220240652','112','53','0','','450.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-09-07 11:57:09','0','20700.00','0.00','0.00','0.00','0.00','450.00','1337815','LRN11220240652','112','54','0','','450.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-09-07 11:57:09','0','20250.00','0.00','0.00','0.00','0.00','450.00','1337816','LRN11220240652','112','55','0','','450.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-09-07 11:57:09','0','19800.00','0.00','0.00','0.00','0.00','450.00','1337817','LRN11220240652','112','56','0','','450.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-09-07 11:57:09','0','19350.00','0.00','0.00','0.00','0.00','450.00','1337818','LRN11220240652','112','57','0','','450.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-09-07 11:57:09','0','18900.00','0.00','0.00','0.00','0.00','450.00','1337819','LRN11220240652','112','58','0','','450.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-09-07 11:57:09','0','18450.00','0.00','0.00','0.00','0.00','450.00','1337820','LRN11220240652','112','59','0','','450.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-09-07 11:57:09','0','18000.00','0.00','0.00','0.00','0.00','450.00','1337821','LRN11220240652','112','60','0','','450.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-09-07 11:57:09','0','17550.00','0.00','0.00','0.00','0.00','450.00','1337822','LRN11220240652','112','61','0','','450.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-09-07 11:57:09','0','17100.00','0.00','0.00','0.00','0.00','450.00','1337823','LRN11220240652','112','62','0','','450.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-09-07 11:57:09','0','16650.00','0.00','0.00','0.00','0.00','450.00','1337824','LRN11220240652','112','63','0','','450.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-09-07 11:57:09','0','16200.00','0.00','0.00','0.00','0.00','450.00','1337825','LRN11220240652','112','64','0','','450.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-09-07 11:57:09','0','15750.00','0.00','0.00','0.00','0.00','450.00','1337826','LRN11220240652','112','65','0','','450.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-09-07 11:57:09','0','15300.00','0.00','0.00','0.00','0.00','450.00','1337827','LRN11220240652','112','66','0','','450.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-09-07 11:57:09','0','14850.00','0.00','0.00','0.00','0.00','450.00','1337828','LRN11220240652','112','67','0','','450.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-09-07 11:57:09','0','14400.00','0.00','0.00','0.00','0.00','450.00','1337829','LRN11220240652','112','68','0','','450.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-09-07 11:57:09','0','13950.00','0.00','0.00','0.00','0.00','450.00','1337830','LRN11220240652','112','69','0','','450.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-09-07 11:57:09','0','13500.00','0.00','0.00','0.00','0.00','450.00','1337831','LRN11220240652','112','70','0','','450.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-09-07 11:57:09','0','13050.00','0.00','0.00','0.00','0.00','450.00','1337832','LRN11220240652','112','71','0','','450.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-09-07 11:57:09','0','12600.00','0.00','0.00','0.00','0.00','450.00','1337833','LRN11220240652','112','72','0','','450.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-09-07 11:57:09','0','12150.00','0.00','0.00','0.00','0.00','450.00','1337834','LRN11220240652','112','73','0','','450.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-09-07 11:57:09','0','11700.00','0.00','0.00','0.00','0.00','450.00','1337835','LRN11220240652','112','74','0','','450.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-09-07 11:57:09','0','11250.00','0.00','0.00','0.00','0.00','450.00','1337836','LRN11220240652','112','75','0','','450.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-09-07 11:57:09','0','10800.00','0.00','0.00','0.00','0.00','450.00','1337837','LRN11220240652','112','76','0','','450.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-09-07 11:57:09','0','10350.00','0.00','0.00','0.00','0.00','450.00','1337838','LRN11220240652','112','77','0','','450.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-09-07 11:57:09','0','9900.00','0.00','0.00','0.00','0.00','450.00','1337839','LRN11220240652','112','78','0','','450.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-09-07 11:57:09','0','9450.00','0.00','0.00','0.00','0.00','450.00','1337840','LRN11220240652','112','79','0','','450.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-09-07 11:57:09','0','9000.00','0.00','0.00','0.00','0.00','450.00','1337841','LRN11220240652','112','80','0','','450.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-09-07 11:57:09','0','8550.00','0.00','0.00','0.00','0.00','450.00','1337842','LRN11220240652','112','81','0','','450.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-09-07 11:57:09','0','8100.00','0.00','0.00','0.00','0.00','450.00','1337843','LRN11220240652','112','82','0','','450.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-09-07 11:57:09','0','7650.00','0.00','0.00','0.00','0.00','450.00','1337844','LRN11220240652','112','83','0','','450.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-09-07 11:57:09','0','7200.00','0.00','0.00','0.00','0.00','450.00','1337845','LRN11220240652','112','84','0','','450.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-09-07 11:57:09','0','6750.00','0.00','0.00','0.00','0.00','450.00','1337846','LRN11220240652','112','85','0','','450.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-09-07 11:57:09','0','6300.00','0.00','0.00','0.00','0.00','450.00','1337847','LRN11220240652','112','86','0','','450.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-09-07 11:57:09','0','5850.00','0.00','0.00','0.00','0.00','450.00','1337848','LRN11220240652','112','87','0','','450.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-09-07 11:57:09','0','5400.00','0.00','0.00','0.00','0.00','450.00','1337849','LRN11220240652','112','88','0','','450.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-09-07 11:57:09','0','4950.00','0.00','0.00','0.00','0.00','450.00','1337850','LRN11220240652','112','89','0','','450.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-09-07 11:57:09','0','4500.00','0.00','0.00','0.00','0.00','450.00','1337851','LRN11220240652','112','90','0','','450.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-09-07 11:57:09','0','4050.00','0.00','0.00','0.00','0.00','450.00','1337852','LRN11220240652','112','91','0','','450.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-09-07 11:57:09','0','3600.00','0.00','0.00','0.00','0.00','450.00','1337853','LRN11220240652','112','92','0','','450.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-09-07 11:57:09','0','3150.00','0.00','0.00','0.00','0.00','450.00','1337854','LRN11220240652','112','93','0','','450.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-09-07 11:57:09','0','2700.00','0.00','0.00','0.00','0.00','450.00','1337855','LRN11220240652','112','94','0','','450.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-09-07 11:57:09','0','2250.00','0.00','0.00','0.00','0.00','450.00','1337856','LRN11220240652','112','95','0','','450.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-09-07 11:57:09','0','1800.00','0.00','0.00','0.00','0.00','450.00','1337857','LRN11220240652','112','96','0','','450.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-09-07 11:57:09','0','1350.00','0.00','0.00','0.00','0.00','450.00','1337858','LRN11220240652','112','97','0','','450.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-09-07 11:57:09','0','900.00','0.00','0.00','0.00','0.00','450.00','1337859','LRN11220240652','112','98','0','','450.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-09-07 11:57:09','0','450.00','0.00','0.00','0.00','0.00','450.00','1337860','LRN11220240652','112','99','0','','450.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-09-07 11:57:09','0','0.00','0.00','0.00','0.00','0.00','450.00','1337861','LRN11220240652','112','100','0','','450.00');
INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES 
('LRN11220240667','','','2024-09-16','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13821','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-09-10 15:07:50','027','20000.00','1','AN1122024091887','11220232260','BALAJADIA','ROSALIE','APUNTAR','','','','','0','','0000-00-00','20000.00','2024-09-07','13CLC','042','Released','20000.00','015','2024-09-07 10:55:30','0','RENEWAL','015','2024-09-07 10:52:56','112','2024-09-16 13:12:04');
INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES 
('LRN11220240662','','','2024-09-13','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13822','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-09-10 15:07:50','027','23000.00','1','AN1122024091888','11220232190','JUMAWAN','JANE MARIE','GATUZ','','','','','0','','0000-00-00','23000.00','2024-09-07','13CLC','042','Released','23000.00','015','2024-09-07 10:56:26','0','RENEWAL','015','2024-09-07 10:54:07','112','2024-09-13 13:19:56');
UPDATE pros_application SET temp_pnumber='LRN11220240652',app_ho_date='',app_ho_edit='',app_contract_printing='2024-09-07',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-09-04 16:34:16',hoApprvoedBy='027',app_ho_approved_amt='45000.00',app_Entry='015',app_EntryDate='2024-09-02 13:56:14',app_Branch='112',app_timestamp='2024-09-07 11:58:02',app_Number='AN1122024091875',app_AccountNo='11220170597',app_LastName='MIRADOR',app_FirstName='CARMEN',app_MiddleName='MERCADO',app_Suffix='',app_HouseNo='',app_Street='',app_Subd='',app_Brgy='0',app_municipality='',app_BirthDay='0000-00-00',app_AppliedAmt='45000.00',app_Date_Applied='2024-09-02',app_Area='3CLC',app_MarketBy='006',app_Status='Released',app_recAmt='45000.00',app_AppDisBy='015',app_AppDisDate='2024-09-02 13:58:54',app_Reason_Cancellation='0',app_Type='RENEWAL' WHERE app_Number = 'AN1122024091875'; 
