UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-07-20 09:08:10',add_HouseNo='079', add_Street= 'VILLA SAN JOSE', add_Subd= '', add_Brgy= '7822', add_City= 'CAPAS', add_Type= 'PRESENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1961', add_Status= 'ACTIVE'  WHERE add_ID = '8721' and add_Branch = '114'; 
UPDATE cust_address SET add_ho_date='',add_ho_edit='',add_timestamp='2024-07-20 09:08:10',add_HouseNo='', add_Street= '079 VILLA SAN JOSE', add_Subd= '', add_Brgy= '7822', add_City= 'CAPAS', add_Type= 'PERMANENT ADDRESS', add_PropertyType= 'OWNED', add_Since= '1961', add_Status= 'ACTIVE'  WHERE add_ID = '8722' and add_Branch = '114'; 
UPDATE cust_business SET buss_ho_date='',buss_ho_edit='',bus_net_daily_income='2300.00',bus_gross_daily_income='7000.00',buss_worth_stocks='28000.00',buss_capitalization='30000.00',buss_description='SARI SAI STORE, FROZEN & UKAY UKAY',buss_Type='Primary', buss_Name= '2', buss_Address= 'VILLA SAN JOSE CUT CUT 1ST CAPAS TARLAC', buss_Started= '2018-01-01', buss_Contact= '09474154651', buss_Deleted= '0', buss_Encoded= '031', buss_EncodedDate= '2024-07-19 13:26:42', buss_timestamp= '2024-07-20 09:08:11' WHERE buss_ID = '3799' and buss_Branch = '114'; 
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347667','0.00','0.00','0.00','0.00','0.00','112-136900','112','12CLC','LRN11220240387','2024-07-20','0','','150.00','','006','0','112','015','2024-07-20 13:59:21','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13:59: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','347668','0.00','0.00','0.00','0.00','0.00','112-136901','112','12CLC','LRN11220240437','2024-07-20','0','','140.00','','006','0','112','015','2024-07-20 13:59:23','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13:59: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','347669','0.00','0.00','0.00','0.00','0.00','112-136902','112','12CLC','LRN11220240457','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 13:59:25','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13:59: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','347670','0.00','0.00','0.00','0.00','0.00','112-136903','112','12CLC','LRN11220240485','2024-07-20','0','','140.00','','006','0','112','015','2024-07-20 13:59:27','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13:59: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','347671','0.00','0.00','0.00','0.00','0.00','112-136904','112','12CLC','LRN11220240481','2024-07-20','0','','140.00','','006','0','112','015','2024-07-20 13:59:29','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13:59: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','347672','0.00','0.00','0.00','0.00','0.00','112-136905','112','12CLC','LRN11220240524','2024-07-20','0','','170.00','','006','0','112','015','2024-07-20 13:59:31','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13: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','347673','0.00','0.00','0.00','0.00','0.00','112-136906','112','12CLC','LRN11220240458','2024-07-20','0','','150.00','','006','0','112','015','2024-07-20 13:59:33','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13: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','347674','0.00','0.00','0.00','0.00','0.00','112-136907','112','12CLC','LRN11220240406','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 13:59:35','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13: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','347675','0.00','0.00','0.00','0.00','0.00','112-136908','112','12CLC','LRN11220240449','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 13:59:37','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13: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','347676','0.00','0.00','0.00','0.00','0.00','112-136909','112','12CLC','LRN11220240480','2024-07-20','0','','140.00','','006','0','112','015','2024-07-20 13:59:40','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13:59:40');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347677','0.00','0.00','0.00','0.00','0.00','112-136910','112','12CLC','LRN11220240464','2024-07-20','0','','160.00','','006','0','112','015','2024-07-20 13:59:42','0','0000-00-00 00:00:00','0','015','2024-07-20 13:57:55','2024-07-20 13:59:42');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347678','0.00','0.00','0.00','0.00','0.00','112-136911','112','4CLC','LRN11220240370','2024-07-20','0','','200.00','','004i','0','112','015','2024-07-20 14:56:00','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347679','0.00','0.00','0.00','0.00','0.00','112-136912','112','4CLC','LRN11220240359','2024-07-20','0','','6860.00','','004i','0','112','015','2024-07-20 14:56:02','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347680','0.00','0.00','0.00','0.00','0.00','112-136913','112','4CLC','LRN11220240345','2024-07-20','0','','210.00','','004i','0','112','015','2024-07-20 14:56:04','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347681','0.00','0.00','0.00','0.00','0.00','112-136914','112','4CLC','LRN11220240364','2024-07-20','0','','500.00','','004i','0','112','015','2024-07-20 14:56:06','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347682','0.00','0.00','0.00','0.00','0.00','112-136915','112','4CLC','LRN11220240543','2024-07-20','0','','600.00','','004i','0','112','015','2024-07-20 14:56:08','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347683','0.00','0.00','0.00','0.00','0.00','112-136916','112','4CLC','LRN11220232360','2024-07-20','0','','100.00','','004i','0','112','015','2024-07-20 14:56:10','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347684','0.00','0.00','0.00','0.00','0.00','112-136917','112','4CLC','LRN11220240535','2024-07-20','0','','150.00','','004i','0','112','015','2024-07-20 14:56:12','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56:12');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347685','0.00','0.00','0.00','0.00','0.00','112-136918','112','4CLC','LRN11220240498','2024-07-20','0','','925.00','','004i','0','112','015','2024-07-20 14:56:14','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56:14');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347686','0.00','0.00','0.00','0.00','0.00','112-136919','112','4CLC','LRN11220240324','2024-07-20','0','','150.00','','004i','0','112','015','2024-07-20 14:56:16','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56:16');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347687','0.00','0.00','0.00','0.00','0.00','112-136920','112','4CLC','LRN11220240484','2024-07-20','0','','500.00','','004i','0','112','015','2024-07-20 14:56:18','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56:18');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347688','0.00','0.00','0.00','0.00','0.00','112-136921','112','4CLC','LRN11220240338','2024-07-20','0','','300.00','','004i','0','112','015','2024-07-20 14:56:20','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347689','0.00','0.00','0.00','0.00','0.00','112-136922','112','4CLC','LRN11220232442','2024-07-20','0','','100.00','','004i','0','112','015','2024-07-20 14:56:22','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347690','0.00','0.00','0.00','0.00','0.00','112-136923','112','4CLC','LRN11220240467','2024-07-20','0','','210.00','','004i','0','112','015','2024-07-20 14:56:24','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347691','0.00','0.00','0.00','0.00','0.00','112-136924','112','4CLC','LRN11220240291','2024-07-20','0','','200.00','','004i','0','112','015','2024-07-20 14:56:27','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347692','0.00','0.00','0.00','0.00','0.00','112-136925','112','4CLC','LRN11220240409','2024-07-20','0','','200.00','','004i','0','112','015','2024-07-20 14:56:29','0','0000-00-00 00:00:00','0','015','2024-07-20 14:54:55','2024-07-20 14:56: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','347693','0.00','0.00','0.00','0.00','0.00','112-136926','112','2CLC','LRN11220240218','2024-07-20','0','','200.00','','002','0','112','015','2024-07-20 15:00:38','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00: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','347694','0.00','0.00','0.00','0.00','0.00','112-136927','112','2CLC','LRN11220240413','2024-07-20','0','','320.00','','002','0','112','015','2024-07-20 15:00:40','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00:40');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347695','0.00','0.00','0.00','0.00','0.00','112-136928','112','2CLC','LRN11220240284','2024-07-20','0','','250.00','','002','0','112','015','2024-07-20 15:00:42','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00:42');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347696','0.00','0.00','0.00','0.00','0.00','112-136929','112','2CLC','LRN11220240414','2024-07-20','0','','300.00','','002','0','112','015','2024-07-20 15:00:44','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00:44');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347697','0.00','0.00','0.00','0.00','0.00','112-136930','112','2CLC','LRN11220240336','2024-07-20','0','','300.00','','002','0','112','015','2024-07-20 15:00:46','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00:46');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347698','0.00','0.00','0.00','0.00','0.00','112-136931','112','2CLC','LRN11220240432','2024-07-20','0','','150.00','','002','0','112','015','2024-07-20 15:00:48','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00:48');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347699','0.00','0.00','0.00','0.00','0.00','112-136932','112','2CLC','LRN11220240326','2024-07-20','0','','800.00','','002','0','112','015','2024-07-20 15:00:50','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00:50');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347700','0.00','0.00','0.00','0.00','0.00','112-136933','112','2CLC','LRN11220240323','2024-07-20','0','','200.00','','002','0','112','015','2024-07-20 15:00:53','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00: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','347701','0.00','0.00','0.00','0.00','0.00','112-136934','112','2CLC','LRN11220240492','2024-07-20','0','','300.00','','002','0','112','015','2024-07-20 15:00:55','0','0000-00-00 00:00:00','0','015','2024-07-20 14:59:24','2024-07-20 15:00: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','347702','0.00','0.00','0.00','0.00','0.00','112-136935','112','11CLC','LRN11220240438','2024-07-20','0','','1200.00','','006','0','112','015','2024-07-20 15:20:43','0','0000-00-00 00:00:00','0','015','2024-07-20 15:11:55','2024-07-20 15:20: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','347703','0.00','0.00','0.00','0.00','0.00','112-136936','112','11CLC','LRN11220240391','2024-07-20','0','','140.00','','006','0','112','015','2024-07-20 15:20:45','0','0000-00-00 00:00:00','0','015','2024-07-20 15:11:55','2024-07-20 15:20: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','347704','0.00','0.00','0.00','0.00','0.00','112-136937','112','13CLC','LRN11220240347','2024-07-20','0','','400.00','','006','0','112','015','2024-07-20 15:19:33','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19: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','347705','0.00','0.00','0.00','0.00','0.00','112-136938','112','13CLC','LRN11220240461','2024-07-20','0','','140.00','','006','0','112','015','2024-07-20 15:19:35','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19: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','347706','0.00','0.00','0.00','0.00','0.00','112-136939','112','13CLC','LRN11220240429','2024-07-20','0','','250.00','','006','0','112','015','2024-07-20 15:19:37','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19: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','347707','0.00','0.00','0.00','0.00','0.00','112-136940','112','13CLC','LRN11220240123','2024-07-20','0','','500.00','','006','0','112','015','2024-07-20 15:19:39','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19: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','347708','0.00','0.00','0.00','0.00','0.00','112-136941','112','13CLC','LRN11220240362','2024-07-20','0','','300.00','','006','0','112','015','2024-07-20 15:19:41','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15: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','347709','0.00','0.00','0.00','0.00','0.00','112-136942','112','13CLC','LRN11220240478','2024-07-20','0','','1050.00','','006','0','112','015','2024-07-20 15:19:44','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19:44');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347710','0.00','0.00','0.00','0.00','0.00','112-136943','112','13CLC','LRN11220240434','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:19:46','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19:46');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347711','0.00','0.00','0.00','0.00','0.00','112-136944','112','13CLC','LRN11220240448','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:19:48','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19:48');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347712','0.00','0.00','0.00','0.00','0.00','112-136945','112','13CLC','LRN11220240380','2024-07-20','0','','300.00','','006','0','112','015','2024-07-20 15:19:50','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19:50');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347713','0.00','0.00','0.00','0.00','0.00','112-136946','112','13CLC','LRN11220240446','2024-07-20','0','','150.00','','006','0','112','015','2024-07-20 15:19:52','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19:52');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347714','0.00','0.00','0.00','0.00','0.00','112-136947','112','13CLC','LRN11220240321','2024-07-20','0','','300.00','','006','0','112','015','2024-07-20 15:19:54','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:40','2024-07-20 15:19:54');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347715','0.00','0.00','0.00','0.00','0.00','112-136948','112','13CLC','LRN11220240340','2024-07-20','0','','890.00','','006','0','112','015','2024-07-20 15:19:56','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:41','2024-07-20 15:19:56');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347716','0.00','0.00','0.00','0.00','0.00','112-136949','112','13CLC','LRN11220240384','2024-07-20','0','','400.00','','006','0','112','015','2024-07-20 15:19:58','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:41','2024-07-20 15:19:58');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347717','0.00','0.00','0.00','0.00','0.00','112-136950','112','13CLC','LRN11220240505','2024-07-20','0','','170.00','','006','0','112','015','2024-07-20 15:20:00','0','0000-00-00 00:00:00','0','015','2024-07-20 15:14:41','2024-07-20 15:20: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','347718','0.00','0.00','0.00','0.00','0.00','112-136951','112','3CLC','LRN11220240454','2024-07-20','0','','1200.00','','006','0','112','015','2024-07-20 15:30:47','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:30:47');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347719','0.00','0.00','0.00','0.00','0.00','112-136952','112','3CLC','LRN11220240451','2024-07-20','0','','210.00','','006','0','112','015','2024-07-20 15:30:49','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:30:49');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347720','0.00','0.00','0.00','0.00','0.00','112-136953','112','3CLC','LRN11220240263','2024-07-20','0','','100.00','','006','0','112','015','2024-07-20 15:30:51','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:30: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','347721','0.00','0.00','0.00','0.00','0.00','112-136954','112','3CLC','LRN11220240366','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:30:53','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:30: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','347722','0.00','0.00','0.00','0.00','0.00','112-136955','112','3CLC','LRN11220240377','2024-07-20','0','','250.00','','006','0','112','015','2024-07-20 15:30:55','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:30: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','347723','0.00','0.00','0.00','0.00','0.00','112-136956','112','3CLC','LRN11220240367','2024-07-20','0','','210.00','','006','0','112','015','2024-07-20 15:30:58','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:30:58');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347724','0.00','0.00','0.00','0.00','0.00','112-136957','112','3CLC','LRN11220240339','2024-07-20','0','','400.00','','006','0','112','015','2024-07-20 15:31:00','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:00');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347725','0.00','0.00','0.00','0.00','0.00','112-136958','112','3CLC','LRN11220240343','2024-07-20','0','','500.00','','006','0','112','015','2024-07-20 15:31:02','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:02');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347726','0.00','0.00','0.00','0.00','0.00','112-136959','112','3CLC','LRN11220240494','2024-07-20','0','','420.00','','006','0','112','015','2024-07-20 15:31:04','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:04');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347727','0.00','0.00','0.00','0.00','0.00','112-136960','112','3CLC','LRN11220240487','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:31:06','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:06');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347728','0.00','0.00','0.00','0.00','0.00','112-136961','112','3CLC','LRN11220240084','2024-07-20','0','','100.00','','006','0','112','015','2024-07-20 15:31:08','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:08');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347729','0.00','0.00','0.00','0.00','0.00','112-136962','112','3CLC','LRN11220240453','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:31:10','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:10');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347730','0.00','0.00','0.00','0.00','0.00','112-136963','112','3CLC','LRN11220240328','2024-07-20','0','','150.00','','006','0','112','015','2024-07-20 15:31:12','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:12');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347731','0.00','0.00','0.00','0.00','0.00','112-136964','112','3CLC','LRN11220240217','2024-07-20','0','','600.00','','006','0','112','015','2024-07-20 15:31:14','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:14');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347732','0.00','0.00','0.00','0.00','0.00','112-136965','112','3CLC','LRN11220240399','2024-07-20','0','','500.00','','006','0','112','015','2024-07-20 15:31:16','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:16');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347733','0.00','0.00','0.00','0.00','0.00','112-136966','112','3CLC','LRN11220240534','2024-07-20','0','','500.00','','006','0','112','015','2024-07-20 15:31:18','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31:18');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347734','0.00','0.00','0.00','0.00','0.00','112-136967','112','3CLC','LRN11220210343','2024-07-20','0','','50.00','','006','0','112','015','2024-07-20 15:31:20','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347735','0.00','0.00','0.00','0.00','0.00','112-136968','112','3CLC','LRN11220240540','2024-07-20','0','','300.00','','006','0','112','015','2024-07-20 15:31:22','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347736','0.00','0.00','0.00','0.00','0.00','112-136969','112','3CLC','LRN11220240418','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:31:25','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347737','0.00','0.00','0.00','0.00','0.00','112-136970','112','3CLC','LRN11220240444','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:31:27','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347738','0.00','0.00','0.00','0.00','0.00','112-136971','112','3CLC','LRN11220240542','2024-07-20','0','','200.00','','006','0','112','015','2024-07-20 15:31:29','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347739','0.00','0.00','0.00','0.00','0.00','112-136972','112','3CLC','LRN11220231555','2024-07-20','0','','50.00','','006','0','112','015','2024-07-20 15:31:31','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347740','0.00','0.00','0.00','0.00','0.00','112-136973','112','3CLC','LRN11220221167','2024-07-20','0','','100.00','','006','0','112','015','2024-07-20 15:31:33','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347741','0.00','0.00','0.00','0.00','0.00','112-136974','112','3CLC','LRN11220240421','2024-07-20','0','','500.00','','006','0','112','015','2024-07-20 15:31:35','0','0000-00-00 00:00:00','0','015','2024-07-20 15:29:46','2024-07-20 15:31: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','347742','0.00','0.00','0.00','0.00','0.00','114-80579','114','B1','LRN11420243897','2024-07-20','0','','1400.00','','002B','0','114','002B','2024-07-20 16:03:13','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:53:25','2024-07-20 16:03: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','347743','0.00','0.00','0.00','0.00','0.00','114-80580','114','B1','LRN11420243809','2024-07-20','0','','2800.00','','002B','0','114','002B','2024-07-20 16:03:15','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:53:25','2024-07-20 16:03: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','347744','0.00','0.00','0.00','0.00','0.00','114-80581','114','B1','LRN11420243617','2024-07-20','0','','1010.00','','002B','0','114','002B','2024-07-20 16:03:17','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:53:25','2024-07-20 16:03: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','347745','0.00','0.00','0.00','0.00','0.00','114-80582','114','B1','LRN11420243754','2024-07-20','0','','260.00','','002B','0','114','002B','2024-07-20 16:03:19','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:53:25','2024-07-20 16:03: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','347746','0.00','0.00','0.00','0.00','0.00','114-80583','114','B1','LRN11420232986','2024-07-20','0','','1150.00','','002B','0','114','002B','2024-07-20 16:03:21','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:53:25','2024-07-20 16:03: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','347747','0.00','0.00','0.00','0.00','0.00','114-80584','114','B2','LRN11420243910','2024-07-20','0','','6650.00','','002B','0','114','002B','2024-07-20 16:03:57','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:56:33','2024-07-20 16:03: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','347748','0.00','0.00','0.00','0.00','0.00','114-80585','114','B2','LRN11420243988','2024-07-20','0','','1750.00','','002B','0','114','002B','2024-07-20 16:03:59','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:56:33','2024-07-20 16:03: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','347749','0.00','0.00','0.00','0.00','0.00','114-80586','114','B2','LRN11420243843','2024-07-20','0','','840.00','','002B','0','114','002B','2024-07-20 16:04:01','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:56:33','2024-07-20 16:04: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','347750','0.00','0.00','0.00','0.00','0.00','114-80587','114','B2','LRN11420243878','2024-07-20','0','','2100.00','','002B','0','114','002B','2024-07-20 16:04:03','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:56:33','2024-07-20 16:04: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','347751','0.00','0.00','0.00','0.00','0.00','114-80588','114','B2','LRN11420243954','2024-07-20','0','','3070.00','','002B','0','114','002B','2024-07-20 16:04:05','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:56:33','2024-07-20 16:04: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','347752','0.00','0.00','0.00','0.00','0.00','114-80589','114','B2','LRN11420243849','2024-07-20','0','','2100.00','','002B','0','114','002B','2024-07-20 16:04:08','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:56:33','2024-07-20 16:04: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','347753','0.00','0.00','0.00','0.00','0.00','114-80590','114','B2','LRN11420243738','2024-07-20','0','','3000.00','','002B','0','114','002B','2024-07-20 16:04:10','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:56:33','2024-07-20 16:04: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','347754','0.00','0.00','0.00','0.00','0.00','114-80591','114','B7','LRN11420243766','2024-07-20','0','','2300.00','','002B','0','114','002B','2024-07-20 16:07:06','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07: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','347755','0.00','0.00','0.00','0.00','0.00','114-80592','114','B7','LRN11420243635','2024-07-20','0','','2000.00','','002B','0','114','002B','2024-07-20 16:07:08','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07: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','347756','0.00','0.00','0.00','0.00','0.00','114-80593','114','B7','LRN11420243935','2024-07-20','0','','320.00','','002B','0','114','002B','2024-07-20 16:07:10','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07: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','347757','0.00','0.00','0.00','0.00','0.00','114-80594','114','B7','LRN11420243891','2024-07-20','0','','700.00','','002B','0','114','002B','2024-07-20 16:07:12','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07:12');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347758','0.00','0.00','0.00','0.00','0.00','114-80595','114','B7','LRN11420243807','2024-07-20','0','','840.00','','002B','0','114','002B','2024-07-20 16:07:14','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07:14');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','347759','0.00','0.00','0.00','0.00','0.00','114-80596','114','B7','LRN11420243676','2024-07-20','0','','490.00','','002B','0','114','002B','2024-07-20 16:07:17','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07: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','347760','0.00','0.00','0.00','0.00','0.00','114-80597','114','B7','LRN11420243483','2024-07-20','0','','200.00','','002B','0','114','002B','2024-07-20 16:07:19','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07: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','347761','0.00','0.00','0.00','0.00','0.00','114-80598','114','B7','LRN11420243729','2024-07-20','0','','300.00','','002B','0','114','002B','2024-07-20 16:07:21','0','0000-00-00 00:00:00','0','002B','2024-07-20 15:59:18','2024-07-20 16:07: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','347762','0.00','0.00','0.00','0.00','0.00','114-80599','114','B6','LRN11420243984','2024-07-20','0','','1610.00','','040','0','114','002B','2024-07-20 16:04:43','0','0000-00-00 00:00:00','0','002B','2024-07-20 16:01:29','2024-07-20 16:04: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','347763','0.00','0.00','0.00','0.00','0.00','114-80600','114','B6','LRN11420243844','2024-07-20','0','','1200.00','','040','0','114','002B','2024-07-20 16:04:45','0','0000-00-00 00:00:00','0','002B','2024-07-20 16:01:29','2024-07-20 16:04: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','347764','0.00','0.00','0.00','0.00','0.00','114-80601','114','B6','LRN11420243817','2024-07-20','0','','1730.00','','040','0','114','002B','2024-07-20 16:04:47','0','0000-00-00 00:00:00','0','002B','2024-07-20 16:01:29','2024-07-20 16:04: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','347765','0.00','0.00','0.00','0.00','0.00','114-80602','114','B6','LRN11420243800','2024-07-20','0','','1050.00','','040','0','114','002B','2024-07-20 16:04:49','0','0000-00-00 00:00:00','0','002B','2024-07-20 16:01:29','2024-07-20 16:04:49');
UPDATE cust_contactno SET contact_ho_date='',contact_ho_edit='',contract_Type='CELLPHONE NO', contact_Number= '09474154651', contact_Status= 'ACTIVE', contact_Encoded= '031', contact_EncodedDate= '2024-07-19 13:22:58', contact_timestamp= '2024-07-20 09:08:11' WHERE contact_Cust_ID = '5701' and contact_ID = '7366'; 
UPDATE cust_dependent SET dep_ho_date='',dep_ho_edit='',dep_yearOFBirth='',dep_School='',dep_Contact='',dep_Deleted='',dep_Encoded='',dep_EncodedDate='',dep_timestamp='',dep_Relationship='', dep_LastName= '', dep_FirstName= '', dep_MiddleName= '', dep_Status= '', dep_Birthday= '' WHERE dep_ID = '' and dep_Branch = ''; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220232272', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='006', createdBy='015', createddate='2024-07-19 11:59:56', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14732'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220242315', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='042', createdBy='015', createddate='2024-07-19 11:59:56', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14733'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220181452', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='006', createdBy='015', createddate='2024-07-19 11:59:56', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14734'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11220232152', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='004i', createdBy='015', createddate='2024-07-19 13:09:38', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14735'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320180302', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='004', createdBy='031', createddate='2024-07-19 15:31:57', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14736'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320240426', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='029', createdBy='031', createddate='2024-07-19 15:31:57', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14737'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320240495', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='004', createdBy='031', createddate='2024-07-19 15:31:57', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14738'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320210943', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='004', createdBy='031', createddate='2024-07-19 15:31:57', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14739'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320240473', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='014', createdBy='031', createddate='2024-07-19 15:31:58', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14740'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320211046', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='016', createdBy='031', createddate='2024-07-19 15:31:58', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14741'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11320211127', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='05', createdBy='031', createddate='2024-07-19 15:31:58', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14742'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420180497', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-07-19 15:32:53', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14743'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420211005', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-07-19 15:32:53', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14744'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420180181', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-07-19 15:32:53', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14745'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420190691', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-07-19 15:32:53', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14746'; 
UPDATE cust_savings SET ho_date='',ho_edit='',accountno='11420200882', typetrans='insurance', datetrans='2024-07-19', amttrans='0.00', remarks1='', empid='', createdBy='002B', createddate='2024-07-19 15:32:53', timestamp='2024-07-20 09:08:11' WHERE branch = '114' and saveid = '14747'; 
UPDATE cust_spouse SET spouse_ho_date='',spouse_ho_edit='',spouse_ContactNo='09474154651',spouse_Occupation='PENSIONER',spouse_Encoded='031',spouse_EncodedDate='2024-07-19 13:25:24',spouse_timestamp='2024-07-20 09:08:11',spouse_LastName='VALDEZ', spouse_FirstName='ALFREDO', spouse_MiddleName='VINLUAN', spouse_Suffix='', spouse_NickName='nickname', spouse_MaidenName='', spouse_Address='CAPAS TARLAC', spouse_Bday='0000-00-00', spouse_BirthPlace='NUEVA VIZCAYA' WHERE spouse_ID = '2273' and spouse_Branch = '114'; 
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-07-20','166','2024-07-20','1790.00','0.00','0.00','','ACTIVE','015','2024-07-20 14:00:18','2024-07-20 14:00:18');
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-07-20','166','2024-07-20','11205.00','0.00','0.00','','ACTIVE','015','2024-07-20 15:01:38','2024-07-20 15:01:38');
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-07-20','166','2024-07-20','2820.00','0.00','0.00','','ACTIVE','015','2024-07-20 15:02:04','2024-07-20 15:02:04');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','13CLC','Deposited','2024-07-20','166','2024-07-20','5250.00','0.00','0.00','','ACTIVE','015','2024-07-20 15:22:25','2024-07-20 15:22:25');
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-07-20','166','2024-07-20','1340.00','0.00','0.00','','ACTIVE','015','2024-07-20 15:22:54','2024-07-20 15:22: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','3CLC','Deposited','2024-07-20','166','2024-07-20','7340.00','0.00','0.00','','ACTIVE','015','2024-07-20 15:32:16','2024-07-20 15:32:16');
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 
('114','B1','Undeposited','2024-07-19','0','0000-00-00','30710.00','0.00','0.00','','ACTIVE','002B','2024-07-20 15:44:30','2024-07-20 15:44:30');
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 
('114','B2','Deposited','2024-07-19','169','2024-07-19','44420.00','0.00','0.00','','ACTIVE','002B','2024-07-20 15:44:59','2024-07-20 15:44: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 
('114','B5','Deposited','2024-07-19','164','2024-07-19','360.00','0.00','0.00','','ACTIVE','002B','2024-07-20 15:45:34','2024-07-20 15:45:34');
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 
('114','B6','Deposited','2024-07-19','164','2024-07-19','26530.00','0.00','0.00','','ACTIVE','002B','2024-07-20 15:46:36','2024-07-20 15:46:36');
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 
('114','B7','Undeposited','2024-07-19','0','0000-00-00','12260.00','0.00','0.00','','ACTIVE','002B','2024-07-20 15:47:04','2024-07-20 15:47:04');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B9','Deposited','2024-07-19','169','2024-07-19','9100.00','0.00','0.00','','ACTIVE','002B','2024-07-20 15:47:31','2024-07-20 15:47:31');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B9','Deposited','2024-07-19','169','2024-07-19','40960.00','0.00','0.00','','ACTIVE','002B','2024-07-20 15:48:00','2024-07-20 15:48:00');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B1','Undeposited','2024-07-20','0','0000-00-00','6620.00','0.00','0.00','','ACTIVE','002B','2024-07-20 16:08:59','2024-07-20 16:08: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 
('114','B2','Undeposited','2024-07-20','0','0000-00-00','19510.00','0.00','0.00','','ACTIVE','002B','2024-07-20 16:09:27','2024-07-20 16:09:27');
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 
('114','B6','Undeposited','2024-07-20','0','0000-00-00','5590.00','0.00','0.00','','ACTIVE','002B','2024-07-20 16:10:12','2024-07-20 16:10:12');
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 
('114','B7','Undeposited','2024-07-20','0','0000-00-00','7150.00','0.00','0.00','','ACTIVE','002B','2024-07-20 16:11:12','2024-07-20 16:11:12');
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='4930.00',sales_amortization='180.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='18000.00',sales_interest_amt='0.00',sales_prin_amt='18000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2022-08-11 15:06:25',sales_Timestamp='2024-07-20 08:49:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13070.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2022-08-11 15:07:07',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221925',sales_AssignTo='006',sales_PNumber='LRN11220221029',sales_Amt='18000.00',sales_Area='3CLC',sales_Cycle='2',sales_Released='2022-08-11',sales_Maturity='2022-11-19',sales_BegBalance='18000.00',sales_LPD='2024-07-19' WHERE sales_PNumber = 'LRN11220221029' ; 
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='4220.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:38:05',sales_Timestamp='2024-07-20 08:49:20',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7780.00',sales_PaymentCutoff='30.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-17 13:42:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232160',sales_AssignTo='034',sales_PNumber='LRN11220232077',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-07-19' WHERE sales_PNumber = 'LRN11220232077' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-09-29 14:16:06',sales_Timestamp='2024-07-20 16:15:44',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='1150.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-09-29 14:55:03',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231385',sales_AssignTo='',sales_PNumber='LRN11420232986',sales_Amt='10000.00',sales_Area='B1',sales_Cycle='2',sales_Released='2023-09-29',sales_Maturity='2024-01-07',sales_BegBalance='10000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420232986' ; 
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='1600.00',sales_amortization='300.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='30000.00',sales_interest_amt='0.00',sales_prin_amt='30000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2024-03-22 11:48:46',sales_Timestamp='2024-07-20 16:15:44',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='28400.00',sales_PaymentCutoff='6800.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-03-22 12:46:04',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180446',sales_AssignTo='',sales_PNumber='LRN11420243617',sales_Amt='30000.00',sales_Area='B1',sales_Cycle='3',sales_Released='2024-03-22',sales_Maturity='2024-06-30',sales_BegBalance='30000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243617' ; 
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='70.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='7000.00',sales_interest_amt='0.00',sales_prin_amt='7000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2024-04-12 10:07:57',sales_Timestamp='2024-07-20 16:15:44',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7000.00',sales_PaymentCutoff='490.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-04-12 10:22:12',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420241553',sales_AssignTo='',sales_PNumber='LRN11420243676',sales_Amt='7000.00',sales_Area='B7',sales_Cycle='1',sales_Released='2024-04-12',sales_Maturity='2024-07-21',sales_BegBalance='7000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243676' ; 
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='12960.00',sales_amortization='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='0.00',sales_prin_amt='20000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2024-04-24 12:00:40',sales_Timestamp='2024-07-20 16:15:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7040.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-04-24 12:07:14',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231451',sales_AssignTo='',sales_PNumber='LRN11420243729',sales_Amt='20000.00',sales_Area='B7',sales_Cycle='4',sales_Released='2024-04-24',sales_Maturity='2024-08-02',sales_BegBalance='20000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243729' ; 
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='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='002B',sales_PostedDate='2024-04-30 10:14:08',sales_Timestamp='2024-07-20 16:15:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12000.00',sales_PaymentCutoff='2360.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-04-30 10:31:31',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420190563',sales_AssignTo='',sales_PNumber='LRN11420243754',sales_Amt='12000.00',sales_Area='B1',sales_Cycle='13',sales_Released='2024-04-30',sales_Maturity='2024-08-08',sales_BegBalance='12000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243754' ; 
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='5855.00',sales_amortization='160.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='16000.00',sales_interest_amt='0.00',sales_prin_amt='16000.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-13 13:34:11',sales_Timestamp='2024-07-20 08:49:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10145.00',sales_PaymentCutoff='1250.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-13 13:34:49',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232245',sales_AssignTo='042',sales_PNumber='LRN11220240352',sales_Amt='16000.00',sales_Area='13CLC',sales_Cycle='4',sales_Released='2024-05-13',sales_Maturity='2024-08-21',sales_BegBalance='16000.00',sales_LPD='2024-07-19' WHERE sales_PNumber = 'LRN11220240352' ; 
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='2384.00',sales_amortization='80.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='8000.00',sales_interest_amt='0.00',sales_prin_amt='8000.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-17 14:08:57',sales_Timestamp='2024-07-20 08:49:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5616.00',sales_PaymentCutoff='560.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-17 14:09:36',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242336',sales_AssignTo='034',sales_PNumber='LRN11220240365',sales_Amt='8000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2024-05-17',sales_Maturity='2024-08-25',sales_BegBalance='8000.00',sales_LPD='2024-07-19' WHERE sales_PNumber = 'LRN11220240365' ; 
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='6230.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='002B',sales_PostedDate='2024-05-21 12:33:00',sales_Timestamp='2024-07-20 16:15:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5770.00',sales_PaymentCutoff='840.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-05-22 14:39:32',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420241535',sales_AssignTo='',sales_PNumber='LRN11420243807',sales_Amt='12000.00',sales_Area='B7',sales_Cycle='2',sales_Released='2024-05-21',sales_Maturity='2024-08-29',sales_BegBalance='12000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243807' ; 
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='14470.00',sales_amortization='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='0.00',sales_prin_amt='20000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2024-05-24 16:08:41',sales_Timestamp='2024-07-20 16:15:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5530.00',sales_PaymentCutoff='1730.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-05-24 16:11:53',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231314',sales_AssignTo='040',sales_PNumber='LRN11420243817',sales_Amt='20000.00',sales_Area='B6',sales_Cycle='5',sales_Released='2024-05-24',sales_Maturity='2024-09-01',sales_BegBalance='20000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243817' ; 
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='11950.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2024-05-29 11:52:49',sales_Timestamp='2024-07-20 16:15:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3050.00',sales_PaymentCutoff='1200.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-05-29 14:31:23',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231477',sales_AssignTo='040',sales_PNumber='LRN11420243844',sales_Amt='15000.00',sales_Area='B6',sales_Cycle='4',sales_Released='2024-05-29',sales_Maturity='2024-09-06',sales_BegBalance='15000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243844' ; 
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='29400.00',sales_amortization='420.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='42000.00',sales_interest_amt='0.00',sales_prin_amt='42000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2024-06-24 09:15:25',sales_Timestamp='2024-07-20 16:15:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12600.00',sales_PaymentCutoff='6650.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2024-06-24 09:45:33',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420190694',sales_AssignTo='',sales_PNumber='LRN11420243910',sales_Amt='42000.00',sales_Area='B2',sales_Cycle='10',sales_Released='2024-06-24',sales_Maturity='2024-10-02',sales_BegBalance='42000.00',sales_LPD='2024-07-20' WHERE sales_PNumber = 'LRN11420243910' ; 
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='12390.00',sales_amortization='130.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='13000.00',sales_interest_amt='0.00',sales_prin_amt='13000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-07-12 11:53:43',sales_Timestamp='2024-07-20 08:49:21',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='610.00',sales_PaymentCutoff='350.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-07-12 11:57:50',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242331',sales_AssignTo='042',sales_PNumber='LRN11220240527',sales_Amt='13000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2024-07-12',sales_Maturity='2024-10-20',sales_BegBalance='13000.00',sales_LPD='2024-07-19' WHERE sales_PNumber = 'LRN11220240527' ; 
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 
('LRN11220240580','','','2024-07-31','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13425','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-07-25 14:46:35','027','48000.00','1','AN1122024071783','11220201743','NADALA','JENILYN','LACHICA','','','','','0','','0000-00-00','50000.00','2024-07-20','3CLC','006','Released','50000.00','015','2024-07-20 11:03:43','0','RENEWAL','015','2024-07-20 10:52:18','112','2024-07-31 14:04:49');
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 
('LRN11220240577','','','2024-07-31','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13426','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-07-25 14:46:35','027','18000.00','1','AN1122024071784','11220232222','SISTINA','MARIA GINA','PALMONES','','','','','0','','0000-00-00','18000.00','2024-07-20','4CLC','004i','Released','18000.00','015','2024-07-20 11:06:29','0','RENEWAL','015','2024-07-20 10:53:48','112','2024-07-31 11:18:38');
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 
('LRN11220240576','','','2024-07-31','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13427','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-07-25 15:13:37','027','16000.00','1','AN1122024071785','11220232215','SAMAR','EDNA','DELA ROSA','','','','','0','','0000-00-00','16000.00','2024-07-20','13CLC','042','Released','16000.00','015','2024-07-20 11:04:39','0','RENEWAL','015','2024-07-20 10:55:10','112','2024-07-31 11:18:03');
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 
('LRN11220240556','','','2024-07-26','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13428','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-07-25 15:13:37','027','23000.00','1','AN1122024071786','11220232241','SORIANO','LUNINGNING','BANDE','','','','','0','','0000-00-00','23000.00','2024-07-20','13CLC','042','Released','23000.00','015','2024-07-20 11:07:25','0','RENEWAL','015','2024-07-20 10:56:29','112','2024-07-26 11:32:28');
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 
('LRN11220240567','','','2024-07-30','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13429','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-07-25 15:13:37','027','15000.00','1','AN1122024071787','11220242284','ARENAS','ROSSANA','PADILLA','','','','','0','','0000-00-00','15000.00','2024-07-20','13CLC','042','Released','15000.00','015','2024-07-20 11:02:46','0','RENEWAL','015','2024-07-20 10:57:42','112','2024-07-30 14:11:43');
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 
('LRN11220240571','','','2024-07-30','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13430','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-07-25 15:13:37','027','15000.00','1','AN1122024071788','11220232204','SANTIAGO','PORFERIA','ARRIESGADO','','','','','0','','0000-00-00','15000.00','2024-07-20','13CLC','042','Released','15000.00','015','2024-07-20 11:05:35','0','RENEWAL','015','2024-07-20 10:58:55','112','2024-07-30 14:14:16');
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 
('LRN11220240578','','','2024-07-31','0000-00-00','0','0.00','','0000-00-00','0000-00-00','13431','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-07-25 15:30:01','027','15000.00','1','AN1122024071789','11220232094','TAMBOR','RONALD','FEDERICO','','','','','0','','0000-00-00','15000.00','2024-07-20','13CLC','042','Released','15000.00','015','2024-07-20 11:08:21','0','RENEWAL','015','2024-07-20 11:00:07','112','2024-07-31 11:19:20');
