INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337735','0.00','0.00','0.00','0.00','0.00','112-132343','112','2CLC','LRN11220240413','2024-06-15','0','','320.00','','002','0','112','015','2024-06-15 14:15:27','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337736','0.00','0.00','0.00','0.00','0.00','112-132344','112','2CLC','LRN11220240284','2024-06-15','0','','200.00','','002','0','112','015','2024-06-15 14:15:29','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337737','0.00','0.00','0.00','0.00','0.00','112-132345','112','2CLC','LRN11220240414','2024-06-15','0','','300.00','','002','0','112','015','2024-06-15 14:15:31','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337738','0.00','0.00','0.00','0.00','0.00','112-132346','112','2CLC','LRN11220240388','2024-06-15','0','','210.00','','002','0','112','015','2024-06-15 14:15:33','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337739','0.00','0.00','0.00','0.00','0.00','112-132347','112','2CLC','LRN11220240297','2024-06-15','0','','200.00','','002','0','112','015','2024-06-15 14:15:35','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337740','0.00','0.00','0.00','0.00','0.00','112-132348','112','2CLC','LRN11220240323','2024-06-15','0','','200.00','','002','0','112','015','2024-06-15 14:15:37','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337741','0.00','0.00','0.00','0.00','0.00','112-132349','112','2CLC','LRN11220240152','2024-06-15','0','','280.00','','002','0','112','015','2024-06-15 14:15:39','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337742','0.00','0.00','0.00','0.00','0.00','112-132350','112','2CLC','LRN11220240342','2024-06-15','0','','200.00','','002','0','112','015','2024-06-15 14:15:41','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337743','0.00','0.00','0.00','0.00','0.00','112-132351','112','2CLC','LRN11220240261','2024-06-15','0','','270.00','','002','0','112','015','2024-06-15 14:15:44','0','0000-00-00 00:00:00','0','015','2024-06-15 14:04:13','2024-06-15 14:15: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','337744','0.00','0.00','0.00','0.00','0.00','112-132352','112','11CLC','LRN11220232077','2024-06-15','0','','50.00','','004i','0','112','015','2024-06-15 14:20:04','0','0000-00-00 00:00:00','0','015','2024-06-15 14:05:54','2024-06-15 14:20: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','337745','0.00','0.00','0.00','0.00','0.00','112-132353','112','4CLC','LRN11220232293','2024-06-15','0','','150.00','','004i','0','112','015','2024-06-15 14:13:59','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:13: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','337746','0.00','0.00','0.00','0.00','0.00','112-132354','112','4CLC','LRN11220240236','2024-06-15','0','','5000.00','','004i','0','112','015','2024-06-15 14:14:01','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337747','0.00','0.00','0.00','0.00','0.00','112-132355','112','4CLC','LRN11220240211','2024-06-15','0','','720.00','','004i','0','112','015','2024-06-15 14:14:03','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337748','0.00','0.00','0.00','0.00','0.00','112-132356','112','4CLC','LRN11220240207','2024-06-15','0','','252.00','','004i','0','112','015','2024-06-15 14:14:05','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337749','0.00','0.00','0.00','0.00','0.00','112-132357','112','4CLC','LRN11220240370','2024-06-15','0','','200.00','','004i','0','112','015','2024-06-15 14:14:07','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14:07');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337750','0.00','0.00','0.00','0.00','0.00','112-132358','112','4CLC','LRN11220240337','2024-06-15','0','','200.00','','004i','0','112','015','2024-06-15 14:14:10','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337751','0.00','0.00','0.00','0.00','0.00','112-132359','112','4CLC','LRN11220240345','2024-06-15','0','','210.00','','004i','0','112','015','2024-06-15 14:14:12','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337752','0.00','0.00','0.00','0.00','0.00','112-132360','112','4CLC','LRN11220240175','2024-06-15','0','','210.00','','004i','0','112','015','2024-06-15 14:14:14','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337753','0.00','0.00','0.00','0.00','0.00','112-132361','112','4CLC','LRN11220240174','2024-06-15','0','','300.00','','004i','0','112','015','2024-06-15 14:14:16','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337754','0.00','0.00','0.00','0.00','0.00','112-132362','112','4CLC','LRN11220232416','2024-06-15','0','','100.00','','004i','0','112','015','2024-06-15 14:14:18','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337755','0.00','0.00','0.00','0.00','0.00','112-132363','112','4CLC','LRN11220240420','2024-06-15','0','','420.00','','004i','0','112','015','2024-06-15 14:14:20','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337756','0.00','0.00','0.00','0.00','0.00','112-132364','112','4CLC','LRN11220240324','2024-06-15','0','','252.00','','004i','0','112','015','2024-06-15 14:14:22','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337757','0.00','0.00','0.00','0.00','0.00','112-132365','112','4CLC','LRN11220240338','2024-06-15','0','','300.00','','004i','0','112','015','2024-06-15 14:14:24','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14: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','337758','0.00','0.00','0.00','0.00','0.00','112-132366','112','4CLC','LRN11220240238','2024-06-15','0','','1150.00','','004i','0','112','015','2024-06-15 14:14:26','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14:26');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337759','0.00','0.00','0.00','0.00','0.00','112-132367','112','4CLC','LRN11220240071','2024-06-15','0','','260.00','','004i','0','112','015','2024-06-15 14:14:28','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14:28');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337760','0.00','0.00','0.00','0.00','0.00','112-132368','112','4CLC','LRN11220240246','2024-06-15','0','','210.00','','004i','0','112','015','2024-06-15 14:14:30','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14:30');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337761','0.00','0.00','0.00','0.00','0.00','112-132369','112','4CLC','LRN11220240351','2024-06-15','0','','200.00','','004i','0','112','015','2024-06-15 14:14:32','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14:32');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337762','0.00','0.00','0.00','0.00','0.00','112-132370','112','4CLC','LRN11220240409','2024-06-15','0','','200.00','','004i','0','112','015','2024-06-15 14:14:34','0','0000-00-00 00:00:00','0','015','2024-06-15 14:08:31','2024-06-15 14:14:34');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337763','0.00','0.00','0.00','0.00','0.00','112-132371','112','3CLC','LRN11220240253','2024-06-15','0','','225.00','','006','0','112','015','2024-06-15 14:20:38','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337764','0.00','0.00','0.00','0.00','0.00','112-132372','112','3CLC','LRN11220231774','2024-06-15','0','','100.00','','006','0','112','015','2024-06-15 14:20:40','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337765','0.00','0.00','0.00','0.00','0.00','112-132373','112','3CLC','LRN11220240377','2024-06-15','0','','250.00','','006','0','112','015','2024-06-15 14:20:42','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337766','0.00','0.00','0.00','0.00','0.00','112-132374','112','3CLC','LRN11220240367','2024-06-15','0','','210.00','','006','0','112','015','2024-06-15 14:20:44','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337767','0.00','0.00','0.00','0.00','0.00','112-132375','112','3CLC','LRN11220240339','2024-06-15','0','','400.00','','006','0','112','015','2024-06-15 14:20:46','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337768','0.00','0.00','0.00','0.00','0.00','112-132376','112','3CLC','LRN11220240343','2024-06-15','0','','500.00','','006','0','112','015','2024-06-15 14:20:48','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337769','0.00','0.00','0.00','0.00','0.00','112-132377','112','3CLC','LRN11220240195','2024-06-15','0','','380.00','','006','0','112','015','2024-06-15 14:20:50','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337770','0.00','0.00','0.00','0.00','0.00','112-132378','112','3CLC','LRN11220240014','2024-06-15','0','','1000.00','','006','0','112','015','2024-06-15 14:20:53','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337771','0.00','0.00','0.00','0.00','0.00','112-132379','112','3CLC','LRN11220240346','2024-06-15','0','','182.00','','006','0','112','015','2024-06-15 14:20:55','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337772','0.00','0.00','0.00','0.00','0.00','112-132380','112','3CLC','LRN11220240084','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:20:57','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337773','0.00','0.00','0.00','0.00','0.00','112-132381','112','3CLC','LRN11220240118','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:20:59','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:20: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','337774','0.00','0.00','0.00','0.00','0.00','112-132382','112','3CLC','LRN11220240285','2024-06-15','0','','160.00','','006','0','112','015','2024-06-15 14:21:01','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21: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','337775','0.00','0.00','0.00','0.00','0.00','112-132383','112','3CLC','LRN11220232394','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:21:03','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21: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','337776','0.00','0.00','0.00','0.00','0.00','112-132384','112','3CLC','LRN11220240254','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:21:05','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21: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','337777','0.00','0.00','0.00','0.00','0.00','112-132385','112','3CLC','LRN11220240217','2024-06-15','0','','600.00','','006','0','112','015','2024-06-15 14:21:07','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21:07');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337778','0.00','0.00','0.00','0.00','0.00','112-132386','112','3CLC','LRN11220240394','2024-06-15','0','','350.00','','006','0','112','015','2024-06-15 14:21:09','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21:09');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337779','0.00','0.00','0.00','0.00','0.00','112-132387','112','3CLC','LRN11220240418','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:21:11','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21:11');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337780','0.00','0.00','0.00','0.00','0.00','112-132388','112','3CLC','LRN11220240357','2024-06-15','0','','1050.00','','006','0','112','015','2024-06-15 14:21:13','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21: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','337781','0.00','0.00','0.00','0.00','0.00','112-132389','112','3CLC','LRN11220240073','2024-06-15','0','','100.00','','006','0','112','015','2024-06-15 14:21:15','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21: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','337782','0.00','0.00','0.00','0.00','0.00','112-132390','112','3CLC','LRN11220240385','2024-06-15','0','','500.00','','006','0','112','015','2024-06-15 14:21:17','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21: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','337783','0.00','0.00','0.00','0.00','0.00','112-132391','112','3CLC','LRN11220240421','2024-06-15','0','','500.00','','006','0','112','015','2024-06-15 14:21:20','0','0000-00-00 00:00:00','0','015','2024-06-15 14:11:42','2024-06-15 14:21: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','337784','0.00','0.00','0.00','0.00','0.00','112-132392','112','12CLC','LRN11220210440','2024-06-15','0','','100.00','','006','0','112','015','2024-06-15 14:19:23','0','0000-00-00 00:00:00','0','015','2024-06-15 14:12:38','2024-06-15 14:19: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','337785','0.00','0.00','0.00','0.00','0.00','112-132393','112','12CLC','LRN11220240437','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:19:21','0','0000-00-00 00:00:00','0','015','2024-06-15 14:17:08','2024-06-15 14:19: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','337786','0.00','0.00','0.00','0.00','0.00','112-132394','112','12CLC','LRN11220240433','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:19:25','0','0000-00-00 00:00:00','0','015','2024-06-15 14:17:08','2024-06-15 14:19: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','337787','0.00','0.00','0.00','0.00','0.00','112-132395','112','12CLC','LRN11220240242','2024-06-15','0','','130.00','','006','0','112','015','2024-06-15 14:19:27','0','0000-00-00 00:00:00','0','015','2024-06-15 14:17:08','2024-06-15 14:19: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','337788','0.00','0.00','0.00','0.00','0.00','112-132396','112','11CLC','LRN11220232074','2024-06-15','0','','100.00','','006','0','112','015','2024-06-15 14:39:58','0','0000-00-00 00:00:00','0','015','2024-06-15 14:38:54','2024-06-15 14:39:58');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337789','0.00','0.00','0.00','0.00','0.00','112-132397','112','11CLC','LRN11220240403','2024-06-15','0','','150.00','','006','0','112','015','2024-06-15 14:40:00','0','0000-00-00 00:00:00','0','015','2024-06-15 14:38:54','2024-06-15 14:40:00');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337790','0.00','0.00','0.00','0.00','0.00','112-132398','112','11CLC','LRN11220240288','2024-06-15','0','','140.00','','006','0','112','015','2024-06-15 14:40:03','0','0000-00-00 00:00:00','0','015','2024-06-15 14:38:54','2024-06-15 14:40: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','337791','0.00','0.00','0.00','0.00','0.00','112-132399','112','11CLC','LRN11220240435','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:40:05','0','0000-00-00 00:00:00','0','015','2024-06-15 14:38:54','2024-06-15 14:40: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','337792','0.00','0.00','0.00','0.00','0.00','112-132400','112','11CLC','LRN11220240391','2024-06-15','0','','280.00','','006','0','112','015','2024-06-15 14:40:07','0','0000-00-00 00:00:00','0','015','2024-06-15 14:38:54','2024-06-15 14:40:07');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337793','0.00','0.00','0.00','0.00','0.00','112-132401','112','11CLC','LRN11220240410','2024-06-15','0','','550.00','','006','0','112','015','2024-06-15 14:40:09','0','0000-00-00 00:00:00','0','015','2024-06-15 14:38:54','2024-06-15 14:40:09');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337794','0.00','0.00','0.00','0.00','0.00','112-132402','112','11CLC','LRN11220240411','2024-06-15','0','','550.00','','006','0','112','015','2024-06-15 14:40:11','0','0000-00-00 00:00:00','0','015','2024-06-15 14:38:54','2024-06-15 14:40:11');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337795','0.00','0.00','0.00','0.00','0.00','112-132403','112','13CLC','LRN11220240369','2024-06-15','0','','150.00','','006','0','112','015','2024-06-15 14:56:48','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:56: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','337796','0.00','0.00','0.00','0.00','0.00','112-132404','112','13CLC','LRN11220240402','2024-06-15','0','','1040.00','','006','0','112','015','2024-06-15 14:56:50','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:56: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','337797','0.00','0.00','0.00','0.00','0.00','112-132405','112','13CLC','LRN11220240315','2024-06-15','0','','400.00','','006','0','112','015','2024-06-15 14:56:52','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:56: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','337798','0.00','0.00','0.00','0.00','0.00','112-132406','112','13CLC','LRN11220240304','2024-06-15','0','','3000.00','','006','0','112','015','2024-06-15 14:56:54','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:56: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','337799','0.00','0.00','0.00','0.00','0.00','112-132407','112','13CLC','LRN11220240257','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:56:57','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:56: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','337800','0.00','0.00','0.00','0.00','0.00','112-132408','112','13CLC','LRN11220240287','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:56:59','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:56: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','337801','0.00','0.00','0.00','0.00','0.00','112-132409','112','13CLC','LRN11220240272','2024-06-15','0','','170.00','','006','0','112','015','2024-06-15 14:57:01','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57: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','337802','0.00','0.00','0.00','0.00','0.00','112-132410','112','13CLC','LRN11220232439','2024-06-15','0','','100.00','','006','0','112','015','2024-06-15 14:57:03','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57: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','337803','0.00','0.00','0.00','0.00','0.00','112-132411','112','13CLC','LRN11220240220','2024-06-15','0','','100.00','','006','0','112','015','2024-06-15 14:57:05','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57: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','337804','0.00','0.00','0.00','0.00','0.00','112-132412','112','13CLC','LRN11220240222','2024-06-15','0','','80.00','','006','0','112','015','2024-06-15 14:57:07','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:07');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337805','0.00','0.00','0.00','0.00','0.00','112-132413','112','13CLC','LRN11220232344','2024-06-15','0','','200.00','','006','0','112','015','2024-06-15 14:57:09','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:09');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337806','0.00','0.00','0.00','0.00','0.00','112-132414','112','13CLC','LRN11220240434','2024-06-15','0','','250.00','','006','0','112','015','2024-06-15 14:57:11','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:11');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337807','0.00','0.00','0.00','0.00','0.00','112-132415','112','13CLC','LRN11220240139','2024-06-15','0','','50.00','','006','0','112','015','2024-06-15 14:57:13','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57: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','337808','0.00','0.00','0.00','0.00','0.00','112-132416','112','13CLC','LRN11220240266','2024-06-15','0','','300.00','','006','0','112','015','2024-06-15 14:57:15','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:15');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337809','0.00','0.00','0.00','0.00','0.00','112-132417','112','13CLC','LRN11220240310','2024-06-15','0','','500.00','','006','0','112','015','2024-06-15 14:57:17','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:17');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337810','0.00','0.00','0.00','0.00','0.00','112-132418','112','13CLC','LRN11220240225','2024-06-15','0','','500.00','','006','0','112','015','2024-06-15 14:57:19','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:19');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337811','0.00','0.00','0.00','0.00','0.00','112-132419','112','13CLC','LRN11220240392','2024-06-15','0','','250.00','','006','0','112','015','2024-06-15 14:57:21','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:21');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337812','0.00','0.00','0.00','0.00','0.00','112-132420','112','13CLC','LRN11220232371','2024-06-15','0','','100.00','','006','0','112','015','2024-06-15 14:57:24','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57: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','337813','0.00','0.00','0.00','0.00','0.00','112-132421','112','13CLC','LRN11220240047','2024-06-15','0','','60.00','','006','0','112','015','2024-06-15 14:57:26','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:26');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337814','0.00','0.00','0.00','0.00','0.00','112-132422','112','13CLC','LRN11220240376','2024-06-15','0','','700.00','','006','0','112','015','2024-06-15 14:57:28','0','0000-00-00 00:00:00','0','015','2024-06-15 14:55:45','2024-06-15 14:57:28');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','337815','0.00','0.00','0.00','0.00','0.00','112-132423','112','11CLC','LRN11220240438','2024-06-15','0','','250.00','','006','0','112','015','2024-06-15 15:51:50','0','0000-00-00 00:00:00','0','015','2024-06-15 15:49:18','2024-06-15 15:51: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','337816','0.00','0.00','0.00','0.00','0.00','112-132424','112','3CLC','LRN11220240355','2024-06-15','0','','1650.00','','006','0','112','015','2024-06-15 15:52:30','0','0000-00-00 00:00:00','0','015','2024-06-15 15:50:46','2024-06-15 15:52:30');
UPDATE cust_information SET cust_ho_date='',cust_ho_edit='',cust_picture='0000-00-00 00:00:00',cust_Code='11220170508', cust_Gender='FEMALE', cust_CivilStatus='MARRIED', cust_Cycle='11', cust_Status='ACTIVE', cust_encoded='009', cust_encodeDate='2017-09-05 10:54:59', cust_timestamp='2024-06-15 10:55:55', cust_LastName='VALLEJOS',cust_FirstName='MARIBEL',cust_MiddleName='BUGTONG',cust_Suffix='',cust_MaidenName='BUGTONG',cust_NickName='MAYETH',cust_Area='3CLC',cust_Nationality='FILIPINO', cust_Bday= '1976-12-23', cust_BirthPlace= 'SAMAR CATBALOGAN' WHERE cust_ID = '303' and cust_Branch = '112'; 
INSERT INTO `cust_savings` (ho_date,ho_edit,saveid,branch,accountno,typetrans,datetrans,amttrans,remarks,remarks1,empid,createdBy,`timestamp`) VALUES 
('','','14380','112','11220170508','insurance','2024-06-15','0.00','LRN11220240439','','006','015','2024-06-15 16:15:22');
UPDATE fund_check_status SET check_Status='Released',check_Reason='0',check_CanceledDate='0000-00-00 00:00:00',check_Encoded='027',check_timestamp='2024-06-15 10:55:21' WHERE check_Branch = '112' and check_ID_Unique = 'AN11220240616392004815135'; 
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-06-15','166','2024-06-15','10334.00','0.00','0.00','','ACTIVE','015','2024-06-15 14:22:00','2024-06-15 14:22:00');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','2CLC','Deposited','2024-06-15','166','2024-06-15','2180.00','0.00','0.00','','ACTIVE','015','2024-06-15 14:22:28','2024-06-15 14:22:28');
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-06-15','166','2024-06-15','630.00','0.00','0.00','','ACTIVE','015','2024-06-15 14:22:53','2024-06-15 14:22:53');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','11CLC','Deposited','2024-06-15','166','2024-06-15','50.00','0.00','0.00','','ACTIVE','015','2024-06-15 14:23:19','2024-06-15 14:23:19');
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-06-15','166','2024-06-15','7507.00','0.00','0.00','','ACTIVE','015','2024-06-15 14:23:46','2024-06-15 14:23:46');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','11CLC','Deposited','2024-06-15','166','2024-06-15','1970.00','0.00','0.00','','ACTIVE','015','2024-06-15 14:40:43','2024-06-15 14:40:43');
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-06-15','166','2024-06-15','8350.00','0.00','0.00','','ACTIVE','015','2024-06-15 14:58:57','2024-06-15 14:58:57');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','11CLC','Deposited','2024-06-15','166','2024-06-15','250.00','0.00','0.00','','INACTIVE','015','2024-06-15 15:53:06','2024-06-15 15:54:39');
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-06-15','166','2024-06-15','1650.00','0.00','0.00','','ACTIVE','015','2024-06-15 15:53:32','2024-06-15 15:53:32');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','11CLC','Deposited','2024-06-15','166','2024-06-15','250.00','0.00','0.00','','ACTIVE','015','2024-06-15 15:55:14','2024-06-15 15:55:14');
INSERT INTO `fund_sales` (sales_ho_date,sales_ho_edit,overdue_asofdate,overdue_amount,sales_delay_asof,sales_no_delay,sales_restructured_tag,sales_transfer,sales_balance,sales_amortization,pdi_amount,penalty_amount,penalty_percent,sales_csrf_no,sales_mode_payment,sales_interest_bal,sales_prin_bal,sales_interest_amt,sales_prin_amt,sales_other_charger1,sales_other_charges,sales_penalty,sales_other_charger1_bal,sales_other_charges_bal,sales_penalty_bal,sales_product,sales_terms,sales_App_Number,sales_Branch,sales_AccountNo,sales_AssignTo,sales_PNumber,sales_Amt,sales_Area,sales_Cycle,sales_Released,sales_Maturity,sales_BegBalance,sales_LPD,sales_Due,sales_Overdue,sales_Payment,sales_PaymentCutoff,sales_Status,sales_ValidatedBy,sales_ValidatedDate,sales_IncentiveClaim,sales_Void,sales_PostedBy,sales_PostedDate,sales_Timestamp) VALUES 
('','','','0.00','','0','0','','48800.00','500.00','0.00','0.00','0.00','12957','Daily','0.00','50000.00','0.00','50000.00','0.00','0.00','0.00','0.00','0.00','0.00','1','100','AN1122024061639','112','11220170508','006','LRN11220240439','50000.00','3CLC','11','2024-06-15','2024-09-23','50000.00','2024-06-17','0.00','0.00','1200.00','1200.00','ACTIVE','015','2024-06-15 10:55:55','0000-00-00','0','015','2024-06-15 10:55:21','2024-06-18 09:02:44');
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='5965.00',sales_amortization='170.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='17000.00',sales_interest_amt='0.00',sales_prin_amt='17000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2021-10-08 13:19:33',sales_Timestamp='2024-06-15 16:20:57',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='11035.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2021-10-08 13:21:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211792',sales_AssignTo='037',sales_PNumber='LRN11220210440',sales_Amt='17000.00',sales_Area='12CLC',sales_Cycle='4',sales_Released='2021-10-08',sales_Maturity='2022-01-16',sales_BegBalance='17000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220210440' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='20500.00',sales_amortization='1000.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='100000.00',sales_interest_amt='0.00',sales_prin_amt='100000.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-06-14 14:00:58',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='79500.00',sales_PaymentCutoff='600.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-06-14 14:18:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191602',sales_AssignTo='034',sales_PNumber='LRN11220231842',sales_Amt='100000.00',sales_Area='11CLC',sales_Cycle='12',sales_Released='2023-06-14',sales_Maturity='2023-09-22',sales_BegBalance='100000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220231842' ; 
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='10147.00',sales_amortization='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='0.00',sales_prin_amt='20000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-07-18 11:54:23',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9853.00',sales_PaymentCutoff='613.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-07-18 11:57:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211869',sales_AssignTo='006',sales_PNumber='LRN11220231972',sales_Amt='20000.00',sales_Area='3CLC',sales_Cycle='8',sales_Released='2023-07-18',sales_Maturity='2023-10-26',sales_BegBalance='20000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220231972' ; 
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='8570.00',sales_amortization='270.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='27000.00',sales_interest_amt='0.00',sales_prin_amt='27000.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-07-19 12:50:34',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='18430.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-07-19 12:53:53',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191598',sales_AssignTo='034',sales_PNumber='LRN11220231984',sales_Amt='27000.00',sales_Area='11CLC',sales_Cycle='10',sales_Released='2023-07-19',sales_Maturity='2023-10-27',sales_BegBalance='27000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220231984' ; 
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='2100.00',sales_amortization='230.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='23000.00',sales_interest_amt='0.00',sales_prin_amt='23000.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:36:04',sales_Timestamp='2024-06-15 16:20:57',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20900.00',sales_PaymentCutoff='200.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-17 13:42:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211838',sales_AssignTo='034',sales_PNumber='LRN11220232074',sales_Amt='23000.00',sales_Area='11CLC',sales_Cycle='10',sales_Released='2023-08-17',sales_Maturity='2023-11-25',sales_BegBalance='23000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220232074' ; 
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='4650.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-06-15 16:20:57',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7350.00',sales_PaymentCutoff='150.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-06-15' 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='4120.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='2023-08-17 13:39:58',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8880.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-17 13:42:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211837',sales_AssignTo='034',sales_PNumber='LRN11220232080',sales_Amt='13000.00',sales_Area='11CLC',sales_Cycle='10',sales_Released='2023-08-17',sales_Maturity='2023-11-25',sales_BegBalance='13000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220232080' ; 
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='6930.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-20 15:20:06',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8070.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-20 15:24:45',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232163',sales_AssignTo='004i',sales_PNumber='LRN11220232366',sales_Amt='15000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2023-11-20',sales_Maturity='2024-02-28',sales_BegBalance='15000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220232366' ; 
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='2770.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='2023-11-25 11:11:35',sales_Timestamp='2024-06-15 16:20:58',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10230.00',sales_PaymentCutoff='600.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-25 11:12:13',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221909',sales_AssignTo='006',sales_PNumber='LRN11220232394',sales_Amt='13000.00',sales_Area='3CLC',sales_Cycle='6',sales_Released='2023-11-25',sales_Maturity='2024-03-04',sales_BegBalance='13000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220232394' ; 
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='2224.00',sales_amortization='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='0.00',sales_prin_amt='20000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-29 10:48:09',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='17776.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-29 10:48:40',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221972',sales_AssignTo='004i',sales_PNumber='LRN11220232406',sales_Amt='20000.00',sales_Area='4CLC',sales_Cycle='7',sales_Released='2023-11-29',sales_Maturity='2024-03-08',sales_BegBalance='20000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220232406' ; 
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='4375.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-12-18 11:59:56',sales_Timestamp='2024-06-15 16:20:58',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10625.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-18 12:02:22',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221932',sales_AssignTo='042',sales_PNumber='LRN11220232439',sales_Amt='15000.00',sales_Area='13CLC',sales_Cycle='7',sales_Released='2023-12-18',sales_Maturity='2024-03-27',sales_BegBalance='15000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220232439' ; 
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='10955.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='2024-02-08 10:54:23',sales_Timestamp='2024-06-15 16:20:58',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7045.00',sales_PaymentCutoff='400.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-02-08 10:55:46',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211813',sales_AssignTo='006',sales_PNumber='LRN11220240084',sales_Amt='18000.00',sales_Area='3CLC',sales_Cycle='12',sales_Released='2024-02-08',sales_Maturity='2024-05-18',sales_BegBalance='18000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240084' ; 
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='500.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='50000.00',sales_interest_amt='0.00',sales_prin_amt='50000.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-03-07 12:58:21',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='50000.00',sales_PaymentCutoff='12800.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-07 12:59:00',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170508',sales_AssignTo='006',sales_PNumber='LRN11220240158',sales_Amt='50000.00',sales_Area='3CLC',sales_Cycle='10',sales_Released='2024-03-07',sales_Maturity='2024-06-15',sales_BegBalance='50000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240158' ; 
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='015',sales_PostedDate='2024-03-15 11:55:58',sales_Timestamp='2024-06-15 08:46:53',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12000.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-15 11:58:12',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232098',sales_AssignTo='042',sales_PNumber='LRN11220240179',sales_Amt='12000.00',sales_Area='13CLC',sales_Cycle='5',sales_Released='2024-03-15',sales_Maturity='2024-06-23',sales_BegBalance='12000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240179' ; 
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='3750.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-03-19 14:08:49',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9250.00',sales_PaymentCutoff='585.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-19 14:09:23',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232201',sales_AssignTo='004i',sales_PNumber='LRN11220240197',sales_Amt='13000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2024-03-19',sales_Maturity='2024-06-27',sales_BegBalance='13000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240197' ; 
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='9140.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-03-27 11:30:13',sales_Timestamp='2024-06-15 16:20:58',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5860.00',sales_PaymentCutoff='350.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-27 11:35:24',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232114',sales_AssignTo='042',sales_PNumber='LRN11220240220',sales_Amt='15000.00',sales_Area='13CLC',sales_Cycle='5',sales_Released='2024-03-27',sales_Maturity='2024-07-05',sales_BegBalance='15000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240220' ; 
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='3698.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-03-27 11:31:40',sales_Timestamp='2024-06-15 16:20:58',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9302.00',sales_PaymentCutoff='1080.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-27 11:35:24',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232254',sales_AssignTo='042',sales_PNumber='LRN11220240222',sales_Amt='13000.00',sales_Area='13CLC',sales_Cycle='3',sales_Released='2024-03-27',sales_Maturity='2024-07-05',sales_BegBalance='13000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240222' ; 
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='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-03-27 11:33:02',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13000.00',sales_PaymentCutoff='3160.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-27 11:35:24',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232261',sales_AssignTo='042',sales_PNumber='LRN11220240224',sales_Amt='13000.00',sales_Area='13CLC',sales_Cycle='3',sales_Released='2024-03-27',sales_Maturity='2024-07-05',sales_BegBalance='13000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240224' ; 
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='1700.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-03-27 13:28:20',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13300.00',sales_PaymentCutoff='900.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-27 13:28:55',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232187',sales_AssignTo='004i',sales_PNumber='LRN11220240228',sales_Amt='15000.00',sales_Area='4CLC',sales_Cycle='4',sales_Released='2024-03-27',sales_Maturity='2024-07-05',sales_BegBalance='15000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240228' ; 
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='3150.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-04-04 14:06:04',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4850.00',sales_PaymentCutoff='610.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-04 14:08:44',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242306',sales_AssignTo='037',sales_PNumber='LRN11220240232',sales_Amt='8000.00',sales_Area='12CLC',sales_Cycle='1',sales_Released='2024-04-04',sales_Maturity='2024-07-13',sales_BegBalance='8000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240232' ; 
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='6800.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-04-15 14:30:55',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6200.00',sales_PaymentCutoff='800.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-15 14:33:52',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221928',sales_AssignTo='004i',sales_PNumber='LRN11220240262',sales_Amt='13000.00',sales_Area='4CLC',sales_Cycle='9',sales_Released='2024-04-15',sales_Maturity='2024-07-24',sales_BegBalance='13000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240262' ; 
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='4470.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-04-16 13:46:08',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5530.00',sales_PaymentCutoff='570.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-16 13:50:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242313',sales_AssignTo='034',sales_PNumber='LRN11220240267',sales_Amt='10000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2024-04-16',sales_Maturity='2024-07-25',sales_BegBalance='10000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240267' ; 
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='24600.00',sales_amortization='480.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='48000.00',sales_interest_amt='0.00',sales_prin_amt='48000.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-04-18 07:58:01',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='23400.00',sales_PaymentCutoff='4560.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-18 08:05:37',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191564',sales_AssignTo='042',sales_PNumber='LRN11220240278',sales_Amt='48000.00',sales_Area='13CLC',sales_Cycle='15',sales_Released='2024-04-17',sales_Maturity='2024-07-26',sales_BegBalance='48000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240278' ; 
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='9010.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-04-18 12:01:00',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2990.00',sales_PaymentCutoff='150.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-18 12:05:13',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232115',sales_AssignTo='042',sales_PNumber='LRN11220240280',sales_Amt='12000.00',sales_Area='13CLC',sales_Cycle='5',sales_Released='2024-04-18',sales_Maturity='2024-07-27',sales_BegBalance='12000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240280' ; 
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='6700.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-04-18 13:56:46',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6300.00',sales_PaymentCutoff='1100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-18 13:59:54',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232247',sales_AssignTo='002',sales_PNumber='LRN11220240282',sales_Amt='13000.00',sales_Area='2CLC',sales_Cycle='4',sales_Released='2024-04-18',sales_Maturity='2024-07-27',sales_BegBalance='13000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240282' ; 
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='14200.00',sales_amortization='220.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='22000.00',sales_interest_amt='0.00',sales_prin_amt='22000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-04-25 10:22:19',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7800.00',sales_PaymentCutoff='900.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-25 10:23:42',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222034',sales_AssignTo='004i',sales_PNumber='LRN11220240302',sales_Amt='22000.00',sales_Area='4CLC',sales_Cycle='9',sales_Released='2024-04-25',sales_Maturity='2024-08-03',sales_BegBalance='22000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240302' ; 
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='12000.00',sales_amortization='190.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='19000.00',sales_interest_amt='0.00',sales_prin_amt='19000.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-04-25 11:06:34',sales_Timestamp='2024-06-15 16:20:58',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7000.00',sales_PaymentCutoff='3000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-25 11:07:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232230',sales_AssignTo='042',sales_PNumber='LRN11220240304',sales_Amt='19000.00',sales_Area='13CLC',sales_Cycle='5',sales_Released='2024-04-25',sales_Maturity='2024-08-03',sales_BegBalance='19000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240304' ; 
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='5300.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-04-30 14:15:21',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4700.00',sales_PaymentCutoff='700.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-30 14:15:56',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232252',sales_AssignTo='002',sales_PNumber='LRN11220240327',sales_Amt='10000.00',sales_Area='2CLC',sales_Cycle='3',sales_Released='2024-04-30',sales_Maturity='2024-08-08',sales_BegBalance='10000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240327' ; 
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='10405.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-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5595.00',sales_PaymentCutoff='1800.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-06-14' 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='9040.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-05-17 11:39:25',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3960.00',sales_PaymentCutoff='925.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-17 11:40:04',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232128',sales_AssignTo='004i',sales_PNumber='LRN11220240364',sales_Amt='13000.00',sales_Area='4CLC',sales_Cycle='5',sales_Released='2024-05-17',sales_Maturity='2024-08-25',sales_BegBalance='13000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240364' ; 
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='4704.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-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3296.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-06-14' 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='10800.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-05-18 10:27:17',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4200.00',sales_PaymentCutoff='1200.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-18 10:27:49',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191591',sales_AssignTo='004i',sales_PNumber='LRN11220240368',sales_Amt='15000.00',sales_Area='4CLC',sales_Cycle='4',sales_Released='2024-05-18',sales_Maturity='2024-08-26',sales_BegBalance='15000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240368' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='8030.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-05-27 11:53:21',sales_Timestamp='2024-06-15 16:20:59',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1970.00',sales_PaymentCutoff='850.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-27 11:54:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242343',sales_AssignTo='034',sales_PNumber='LRN11220240391',sales_Amt='10000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2024-05-27',sales_Maturity='2024-09-04',sales_BegBalance='10000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240391' ; 
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='14280.00',sales_amortization='170.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='17000.00',sales_interest_amt='0.00',sales_prin_amt='17000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-05-30 13:49:01',sales_Timestamp='2024-06-15 16:20:59',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2720.00',sales_PaymentCutoff='2040.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-30 13:49:39',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232158',sales_AssignTo='042',sales_PNumber='LRN11220240402',sales_Amt='17000.00',sales_Area='13CLC',sales_Cycle='5',sales_Released='2024-05-30',sales_Maturity='2024-09-07',sales_BegBalance='17000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240402' ; 
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='6680.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-31 11:44:31',sales_Timestamp='2024-06-15 08:46:54',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1320.00',sales_PaymentCutoff='600.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-31 11:48:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242349',sales_AssignTo='034',sales_PNumber='LRN11220240405',sales_Amt='8000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2024-05-31',sales_Maturity='2024-09-08',sales_BegBalance='8000.00',sales_LPD='2024-06-14' WHERE sales_PNumber = 'LRN11220240405' ; 
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='10140.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-05-31 11:47:44',sales_Timestamp='2024-06-15 16:20:59',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1860.00',sales_PaymentCutoff='840.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-31 11:48:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232130',sales_AssignTo='004i',sales_PNumber='LRN11220240409',sales_Amt='12000.00',sales_Area='4CLC',sales_Cycle='5',sales_Released='2024-05-31',sales_Maturity='2024-09-08',sales_BegBalance='12000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240409' ; 
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='6618.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-31 13:48:33',sales_Timestamp='2024-06-15 16:20:59',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1382.00',sales_PaymentCutoff='774.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-31 13:50:55',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242351',sales_AssignTo='034',sales_PNumber='LRN11220240410',sales_Amt='8000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2024-05-31',sales_Maturity='2024-09-08',sales_BegBalance='8000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240410' ; 
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='6618.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-31 13:49:29',sales_Timestamp='2024-06-15 16:20:59',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1382.00',sales_PaymentCutoff='774.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-31 13:50:55',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242352',sales_AssignTo='034',sales_PNumber='LRN11220240411',sales_Amt='8000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2024-05-31',sales_Maturity='2024-09-08',sales_BegBalance='8000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240411' ; 
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='37640.00',sales_amortization='400.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='40000.00',sales_interest_amt='0.00',sales_prin_amt='40000.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-06-07 13:11:57',sales_Timestamp='2024-06-15 16:20:59',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2360.00',sales_PaymentCutoff='2360.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-06-07 13:12:31',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220201769',sales_AssignTo='006',sales_PNumber='LRN11220240418',sales_Amt='40000.00',sales_Area='3CLC',sales_Cycle='18',sales_Released='2024-06-07',sales_Maturity='2024-09-15',sales_BegBalance='40000.00',sales_LPD='2024-06-15' WHERE sales_PNumber = 'LRN11220240418' ; 
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','50000.00','0.00','0.00','0.00','0.00','0.00','1257565','LRN11220240439','112','0','0','','0.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','49500.00','0.00','0.00','0.00','0.00','500.00','1257566','LRN11220240439','112','1','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','49000.00','0.00','0.00','0.00','0.00','500.00','1257567','LRN11220240439','112','2','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','48500.00','0.00','0.00','0.00','0.00','500.00','1257568','LRN11220240439','112','3','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','48000.00','0.00','0.00','0.00','0.00','500.00','1257569','LRN11220240439','112','4','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','47500.00','0.00','0.00','0.00','0.00','500.00','1257570','LRN11220240439','112','5','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','47000.00','0.00','0.00','0.00','0.00','500.00','1257571','LRN11220240439','112','6','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','46500.00','0.00','0.00','0.00','0.00','500.00','1257572','LRN11220240439','112','7','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','46000.00','0.00','0.00','0.00','0.00','500.00','1257573','LRN11220240439','112','8','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','45500.00','0.00','0.00','0.00','0.00','500.00','1257574','LRN11220240439','112','9','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','45000.00','0.00','0.00','0.00','0.00','500.00','1257575','LRN11220240439','112','10','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','44500.00','0.00','0.00','0.00','0.00','500.00','1257576','LRN11220240439','112','11','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','44000.00','0.00','0.00','0.00','0.00','500.00','1257577','LRN11220240439','112','12','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','43500.00','0.00','0.00','0.00','0.00','500.00','1257578','LRN11220240439','112','13','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','43000.00','0.00','0.00','0.00','0.00','500.00','1257579','LRN11220240439','112','14','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','42500.00','0.00','0.00','0.00','0.00','500.00','1257580','LRN11220240439','112','15','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','42000.00','0.00','0.00','0.00','0.00','500.00','1257581','LRN11220240439','112','16','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','41500.00','0.00','0.00','0.00','0.00','500.00','1257582','LRN11220240439','112','17','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','41000.00','0.00','0.00','0.00','0.00','500.00','1257583','LRN11220240439','112','18','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','40500.00','0.00','0.00','0.00','0.00','500.00','1257584','LRN11220240439','112','19','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','40000.00','0.00','0.00','0.00','0.00','500.00','1257585','LRN11220240439','112','20','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','39500.00','0.00','0.00','0.00','0.00','500.00','1257586','LRN11220240439','112','21','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','39000.00','0.00','0.00','0.00','0.00','500.00','1257587','LRN11220240439','112','22','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','38500.00','0.00','0.00','0.00','0.00','500.00','1257588','LRN11220240439','112','23','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','38000.00','0.00','0.00','0.00','0.00','500.00','1257589','LRN11220240439','112','24','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','37500.00','0.00','0.00','0.00','0.00','500.00','1257590','LRN11220240439','112','25','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','37000.00','0.00','0.00','0.00','0.00','500.00','1257591','LRN11220240439','112','26','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','36500.00','0.00','0.00','0.00','0.00','500.00','1257592','LRN11220240439','112','27','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','36000.00','0.00','0.00','0.00','0.00','500.00','1257593','LRN11220240439','112','28','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','35500.00','0.00','0.00','0.00','0.00','500.00','1257594','LRN11220240439','112','29','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','35000.00','0.00','0.00','0.00','0.00','500.00','1257595','LRN11220240439','112','30','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','34500.00','0.00','0.00','0.00','0.00','500.00','1257596','LRN11220240439','112','31','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','34000.00','0.00','0.00','0.00','0.00','500.00','1257597','LRN11220240439','112','32','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','33500.00','0.00','0.00','0.00','0.00','500.00','1257598','LRN11220240439','112','33','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','33000.00','0.00','0.00','0.00','0.00','500.00','1257599','LRN11220240439','112','34','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','32500.00','0.00','0.00','0.00','0.00','500.00','1257600','LRN11220240439','112','35','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','32000.00','0.00','0.00','0.00','0.00','500.00','1257601','LRN11220240439','112','36','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','31500.00','0.00','0.00','0.00','0.00','500.00','1257602','LRN11220240439','112','37','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','31000.00','0.00','0.00','0.00','0.00','500.00','1257603','LRN11220240439','112','38','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','30500.00','0.00','0.00','0.00','0.00','500.00','1257604','LRN11220240439','112','39','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','30000.00','0.00','0.00','0.00','0.00','500.00','1257605','LRN11220240439','112','40','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','29500.00','0.00','0.00','0.00','0.00','500.00','1257606','LRN11220240439','112','41','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','29000.00','0.00','0.00','0.00','0.00','500.00','1257607','LRN11220240439','112','42','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','28500.00','0.00','0.00','0.00','0.00','500.00','1257608','LRN11220240439','112','43','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','28000.00','0.00','0.00','0.00','0.00','500.00','1257609','LRN11220240439','112','44','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','27500.00','0.00','0.00','0.00','0.00','500.00','1257610','LRN11220240439','112','45','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','27000.00','0.00','0.00','0.00','0.00','500.00','1257611','LRN11220240439','112','46','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','26500.00','0.00','0.00','0.00','0.00','500.00','1257612','LRN11220240439','112','47','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','26000.00','0.00','0.00','0.00','0.00','500.00','1257613','LRN11220240439','112','48','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','25500.00','0.00','0.00','0.00','0.00','500.00','1257614','LRN11220240439','112','49','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','25000.00','0.00','0.00','0.00','0.00','500.00','1257615','LRN11220240439','112','50','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','24500.00','0.00','0.00','0.00','0.00','500.00','1257616','LRN11220240439','112','51','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','24000.00','0.00','0.00','0.00','0.00','500.00','1257617','LRN11220240439','112','52','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','23500.00','0.00','0.00','0.00','0.00','500.00','1257618','LRN11220240439','112','53','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','23000.00','0.00','0.00','0.00','0.00','500.00','1257619','LRN11220240439','112','54','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','22500.00','0.00','0.00','0.00','0.00','500.00','1257620','LRN11220240439','112','55','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','22000.00','0.00','0.00','0.00','0.00','500.00','1257621','LRN11220240439','112','56','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','21500.00','0.00','0.00','0.00','0.00','500.00','1257622','LRN11220240439','112','57','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','21000.00','0.00','0.00','0.00','0.00','500.00','1257623','LRN11220240439','112','58','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','20500.00','0.00','0.00','0.00','0.00','500.00','1257624','LRN11220240439','112','59','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','20000.00','0.00','0.00','0.00','0.00','500.00','1257625','LRN11220240439','112','60','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','19500.00','0.00','0.00','0.00','0.00','500.00','1257626','LRN11220240439','112','61','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','19000.00','0.00','0.00','0.00','0.00','500.00','1257627','LRN11220240439','112','62','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','18500.00','0.00','0.00','0.00','0.00','500.00','1257628','LRN11220240439','112','63','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','18000.00','0.00','0.00','0.00','0.00','500.00','1257629','LRN11220240439','112','64','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','17500.00','0.00','0.00','0.00','0.00','500.00','1257630','LRN11220240439','112','65','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','17000.00','0.00','0.00','0.00','0.00','500.00','1257631','LRN11220240439','112','66','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','16500.00','0.00','0.00','0.00','0.00','500.00','1257632','LRN11220240439','112','67','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','16000.00','0.00','0.00','0.00','0.00','500.00','1257633','LRN11220240439','112','68','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','15500.00','0.00','0.00','0.00','0.00','500.00','1257634','LRN11220240439','112','69','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','15000.00','0.00','0.00','0.00','0.00','500.00','1257635','LRN11220240439','112','70','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','14500.00','0.00','0.00','0.00','0.00','500.00','1257636','LRN11220240439','112','71','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','14000.00','0.00','0.00','0.00','0.00','500.00','1257637','LRN11220240439','112','72','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','13500.00','0.00','0.00','0.00','0.00','500.00','1257638','LRN11220240439','112','73','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','13000.00','0.00','0.00','0.00','0.00','500.00','1257639','LRN11220240439','112','74','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','12500.00','0.00','0.00','0.00','0.00','500.00','1257640','LRN11220240439','112','75','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','12000.00','0.00','0.00','0.00','0.00','500.00','1257641','LRN11220240439','112','76','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','11500.00','0.00','0.00','0.00','0.00','500.00','1257642','LRN11220240439','112','77','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','11000.00','0.00','0.00','0.00','0.00','500.00','1257643','LRN11220240439','112','78','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','10500.00','0.00','0.00','0.00','0.00','500.00','1257644','LRN11220240439','112','79','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','10000.00','0.00','0.00','0.00','0.00','500.00','1257645','LRN11220240439','112','80','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','9500.00','0.00','0.00','0.00','0.00','500.00','1257646','LRN11220240439','112','81','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','9000.00','0.00','0.00','0.00','0.00','500.00','1257647','LRN11220240439','112','82','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','8500.00','0.00','0.00','0.00','0.00','500.00','1257648','LRN11220240439','112','83','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','8000.00','0.00','0.00','0.00','0.00','500.00','1257649','LRN11220240439','112','84','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','7500.00','0.00','0.00','0.00','0.00','500.00','1257650','LRN11220240439','112','85','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','7000.00','0.00','0.00','0.00','0.00','500.00','1257651','LRN11220240439','112','86','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','6500.00','0.00','0.00','0.00','0.00','500.00','1257652','LRN11220240439','112','87','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','6000.00','0.00','0.00','0.00','0.00','500.00','1257653','LRN11220240439','112','88','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','5500.00','0.00','0.00','0.00','0.00','500.00','1257654','LRN11220240439','112','89','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','5000.00','0.00','0.00','0.00','0.00','500.00','1257655','LRN11220240439','112','90','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','4500.00','0.00','0.00','0.00','0.00','500.00','1257656','LRN11220240439','112','91','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','4000.00','0.00','0.00','0.00','0.00','500.00','1257657','LRN11220240439','112','92','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','3500.00','0.00','0.00','0.00','0.00','500.00','1257658','LRN11220240439','112','93','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','3000.00','0.00','0.00','0.00','0.00','500.00','1257659','LRN11220240439','112','94','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','2500.00','0.00','0.00','0.00','0.00','500.00','1257660','LRN11220240439','112','95','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','2000.00','0.00','0.00','0.00','0.00','500.00','1257661','LRN11220240439','112','96','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','1500.00','0.00','0.00','0.00','0.00','500.00','1257662','LRN11220240439','112','97','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','1000.00','0.00','0.00','0.00','0.00','500.00','1257663','LRN11220240439','112','98','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','500.00','0.00','0.00','0.00','0.00','500.00','1257664','LRN11220240439','112','99','0','','500.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-06-15 10:54:29','0','0.00','0.00','0.00','0.00','0.00','500.00','1257665','LRN11220240439','112','100','0','','500.00');
UPDATE pros_application SET temp_pnumber='LRN11220240439',app_ho_date='',app_ho_edit='',app_contract_printing='2024-06-15',dateForwaredtoBH='0000-00-00',reasonFADisapproved='0',recAmount='0.00',faREcommendation='',dateReturned='0000-00-00',dateEndorsed='0000-00-00',app_product='1',app_bank='UBP',app_disbursement='Check',app_mode_of_payment='Cash',app_payment_terms='Daily',app_terms='100',app_interest_deduct='Advance',app_interest_rate='16.00',ho_cancellationDAdate='0000-00-00 00:00:00',ho_cancellationDAby='',ho_cancellationDA='',hoApprovedDate='2024-06-11 16:54:06',hoApprvoedBy='027',app_ho_approved_amt='50000.00',app_Entry='015',app_EntryDate='2024-06-10 09:45:38',app_Branch='112',app_timestamp='2024-06-15 10:55:21',app_Number='AN1122024061639',app_AccountNo='11220170508',app_LastName='VALLEJOS',app_FirstName='MARIBEL',app_MiddleName='BUGTONG',app_Suffix='',app_HouseNo='',app_Street='',app_Subd='',app_Brgy='0',app_municipality='',app_BirthDay='0000-00-00',app_AppliedAmt='50000.00',app_Date_Applied='2024-06-10',app_Area='3CLC',app_MarketBy='006',app_Status='Released',app_recAmt='50000.00',app_AppDisBy='015',app_AppDisDate='2024-06-10 10:19:11',app_Reason_Cancellation='0',app_Type='RENEWAL' WHERE app_Number = 'AN1122024061639'; 
