INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242041','0.00','0.00','0.00','0.00','0.00','114-52815','114','B7','LRN11420232613','2023-08-19','0','','300.00','','003B','0','114','002B','2023-08-20 09:18:54','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:53:05','2023-08-20 09:18: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','242042','0.00','0.00','0.00','0.00','0.00','114-52816','114','B7','LRN11420232687','2023-08-19','0','','1010.00','','003B','0','114','002B','2023-08-20 09:18:56','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:53:05','2023-08-20 09:18:56');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242043','0.00','0.00','0.00','0.00','0.00','114-52817','114','B1','LRN11420221040','2023-08-19','0','','500.00','','001B','0','114','002B','2023-08-20 09:04:08','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:55:22','2023-08-20 09:04:08');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242044','0.00','0.00','0.00','0.00','0.00','114-52818','114','B1','LRN11420232295','2023-08-19','0','','2000.00','','001B','0','114','002B','2023-08-20 09:04:10','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:55:22','2023-08-20 09:04:10');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242045','0.00','0.00','0.00','0.00','0.00','114-52819','114','B1','LRN11420221890','2023-08-19','0','','500.00','','001B','0','114','002B','2023-08-20 09:04:12','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:55:22','2023-08-20 09:04: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','242046','0.00','0.00','0.00','0.00','0.00','114-52820','114','B1','LRN11420221806','2023-08-19','0','','500.00','','001B','0','114','002B','2023-08-20 09:04:14','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:55:22','2023-08-20 09:04: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','242047','0.00','0.00','0.00','0.00','0.00','114-52821','114','B1','LRN11420221167','2023-08-19','0','','1025.00','','001B','0','114','002B','2023-08-20 09:04:16','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:55:22','2023-08-20 09:04: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','242048','0.00','0.00','0.00','0.00','0.00','114-52822','114','B1','LRN11420210638','2023-08-19','0','','300.00','','001B','0','114','002B','2023-08-20 09:04:18','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:55:22','2023-08-20 09:04: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','242049','0.00','0.00','0.00','0.00','0.00','114-52823','114','B6','LRN11420232327','2023-08-19','0','','1380.00','','040','0','114','002B','2023-08-20 09:06:36','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:57:20','2023-08-20 09:06:36');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242050','0.00','0.00','0.00','0.00','0.00','114-52824','114','B6','LRN11420232440','2023-08-19','0','','990.00','','040','0','114','002B','2023-08-20 09:06:38','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:57:20','2023-08-20 09:06: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','242051','0.00','0.00','0.00','0.00','0.00','114-52825','114','B6','LRN11420232527','2023-08-19','0','','910.00','','040','0','114','002B','2023-08-20 09:06:40','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:57:20','2023-08-20 09:06: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','242052','0.00','0.00','0.00','0.00','0.00','114-52826','114','B5','LRN11420232634','2023-08-19','0','','3500.00','','006B','0','114','002B','2023-08-20 09:05:56','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:59:07','2023-08-20 09:05:56');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242053','0.00','0.00','0.00','0.00','0.00','114-52827','114','B5','LRN11420232794','2023-08-19','0','','1060.00','','006B','0','114','002B','2023-08-20 09:05:58','0','0000-00-00 00:00:00','0','002B','2023-08-20 08:59:07','2023-08-20 09:05: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','242054','0.00','0.00','0.00','0.00','0.00','114-52828','114','B2','LRN11420232389','2023-08-19','0','','1400.00','','003B','0','114','002B','2023-08-20 09:04:52','0','0000-00-00 00:00:00','0','002B','2023-08-20 09:00:28','2023-08-20 09:04: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','242055','0.00','0.00','0.00','0.00','0.00','114-52829','114','B9','LRN11420232675','2023-08-19','0','','2100.00','','010B','0','114','002B','2023-08-20 09:19:32','0','0000-00-00 00:00:00','0','002B','2023-08-20 09:02:55','2023-08-20 09:19:32');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242056','0.00','0.00','0.00','0.00','0.00','114-52830','114','B9','LRN11420232709','2023-08-19','0','','1400.00','','010B','0','114','002B','2023-08-20 09:19:34','0','0000-00-00 00:00:00','0','002B','2023-08-20 09:02:55','2023-08-20 09:19:34');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242057','0.00','0.00','0.00','0.00','0.00','114-52831','114','B9','LRN11420232788','2023-08-19','0','','1540.00','','010B','0','114','002B','2023-08-20 09:19:37','0','0000-00-00 00:00:00','0','002B','2023-08-20 09:02:55','2023-08-20 09:19:37');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','242058','0.00','0.00','0.00','0.00','0.00','114-52832','114','B9','LRN11420232742','2023-08-19','0','','1400.00','','010B','0','114','002B','2023-08-20 09:19:39','0','0000-00-00 00:00:00','0','002B','2023-08-20 09:02:55','2023-08-20 09:19: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 
('114','B1','Undeposited','2023-08-19','0','0000-00-00','4825.00','0.00','0.00','','ACTIVE','002B','2023-08-20 09:22:16','2023-08-20 09:22:16');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B2','Undeposited','2023-08-19','0','0000-00-00','1400.00','0.00','0.00','','ACTIVE','002B','2023-08-20 09:22:42','2023-08-20 09:22:42');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B5','Undeposited','2023-08-19','0','0000-00-00','4560.00','0.00','0.00','','ACTIVE','002B','2023-08-20 09:23:16','2023-08-20 09:23:16');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B6','Undeposited','2023-08-19','0','0000-00-00','3280.00','0.00','0.00','','ACTIVE','002B','2023-08-20 09:23:48','2023-08-20 09:23:48');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B7','Undeposited','2023-08-19','0','0000-00-00','1310.00','0.00','0.00','','ACTIVE','002B','2023-08-20 09:24:15','2023-08-20 09:24:15');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B9','Undeposited','2023-08-19','0','0000-00-00','6440.00','0.00','0.00','','ACTIVE','002B','2023-08-20 09:24:43','2023-08-20 09:24:43');
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='8900.00',sales_amortization='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='0.00',sales_prin_amt='20000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2021-08-27 16:41:09',sales_Timestamp='2023-08-20 09:25:27',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='11100.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2021-08-27 16:42:06',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210909',sales_AssignTo='',sales_PNumber='LRN11420210638',sales_Amt='20000.00',sales_Area='B1',sales_Cycle='3',sales_Released='2021-08-27',sales_Maturity='2021-12-05',sales_BegBalance='20000.00',sales_LPD='2023-08-19' WHERE sales_PNumber = 'LRN11420210638' ; 
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='11500.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2022-01-31 17:26:56',sales_Timestamp='2023-08-20 09:25:27',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13500.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-01-31 17:34:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210903',sales_AssignTo='',sales_PNumber='LRN11420221040',sales_Amt='25000.00',sales_Area='B1',sales_Cycle='5',sales_Released='2022-01-31',sales_Maturity='2022-05-11',sales_BegBalance='25000.00',sales_LPD='2023-08-19' WHERE sales_PNumber = 'LRN11420221040' ; 
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='18000.00',sales_amortization='750.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='75000.00',sales_interest_amt='0.00',sales_prin_amt='75000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2022-03-25 18:16:04',sales_Timestamp='2023-08-20 09:25:27',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='57000.00',sales_PaymentCutoff='1025.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-03-25 18:18:53',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420190700',sales_AssignTo='',sales_PNumber='LRN11420221167',sales_Amt='75000.00',sales_Area='B1',sales_Cycle='5',sales_Released='2022-03-25',sales_Maturity='2022-07-03',sales_BegBalance='75000.00',sales_LPD='2023-08-19' WHERE sales_PNumber = 'LRN11420221167' ; 
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='1500.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='150000.00',sales_interest_amt='-1018080.00',sales_prin_amt='-5194920.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-02-17 18:36:46',sales_Timestamp='2023-08-20 06:06:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='150000.00',sales_PaymentCutoff='30000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-02-17 18:45:40',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180096',sales_AssignTo='',sales_PNumber='LRN11420232040',sales_Amt='150000.00',sales_Area='B2',sales_Cycle='11',sales_Released='2023-02-17',sales_Maturity='2023-05-28',sales_BegBalance='150000.00',sales_LPD='2023-05-11' WHERE sales_PNumber = 'LRN11420232040' ; 
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='9400.00',sales_amortization='300.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='30000.00',sales_interest_amt='0.00',sales_prin_amt='30000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-04-28 16:48:55',sales_Timestamp='2023-08-20 09:25:28',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20600.00',sales_PaymentCutoff='2000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-04-28 17:16:01',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210999',sales_AssignTo='',sales_PNumber='LRN11420232295',sales_Amt='30000.00',sales_Area='B1',sales_Cycle='4',sales_Released='2023-04-28',sales_Maturity='2023-08-06',sales_BegBalance='30000.00',sales_LPD='2023-08-19' WHERE sales_PNumber = 'LRN11420232295' ; 
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='002B',sales_PostedDate='2023-05-10 16:29:28',sales_Timestamp='2023-08-20 09:25:28',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13000.00',sales_PaymentCutoff='2080.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-05-10 17:07:30',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231198',sales_AssignTo='',sales_PNumber='LRN11420232327',sales_Amt='13000.00',sales_Area='B6',sales_Cycle='2',sales_Released='2023-05-10',sales_Maturity='2023-08-18',sales_BegBalance='13000.00',sales_LPD='2023-08-19' WHERE sales_PNumber = 'LRN11420232327' ; 
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='20460.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='002B',sales_PostedDate='2023-08-17 10:13:04',sales_Timestamp='2023-08-20 09:25:28',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1540.00',sales_PaymentCutoff='1540.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-08-17 16:05:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420211002',sales_AssignTo='',sales_PNumber='LRN11420232788',sales_Amt='22000.00',sales_Area='B9',sales_Cycle='9',sales_Released='2023-08-17',sales_Maturity='2023-11-25',sales_BegBalance='22000.00',sales_LPD='2023-08-19' WHERE sales_PNumber = 'LRN11420232788' ; 
INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES 
('LRN11420232832','','','2023-08-25','0000-00-00','0','0.00','','0000-00-00','0000-00-00','9690','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-08-22 16:21:56','027','23000.00','1','AN1142023081115','11420231294','MANONGSONG','MARY ANN','GREGORIO','','','','','0','','0000-00-00','25000.00','2023-08-20','B2','','Released','25000.00','002B','2023-08-22 12:14:44','0','RENEWAL','002B','2023-08-20 16:20:58','114','2023-08-25 11:01:27');
INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES 
('LRN11420232844','','','2023-08-29','0000-00-00','0','0.00','','0000-00-00','0000-00-00','9691','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-08-22 16:21:56','027','13000.00','1','AN1142023081116','11420231208','MEDRANO','MYRA','ORFALAS','','','','','0','','0000-00-00','13000.00','2023-08-20','B6','040','Released','13000.00','002B','2023-08-22 12:15:40','0','RENEWAL','002B','2023-08-20 16:23:47','114','2023-08-29 15:21:15');
INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','9692','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-08-22 16:21:56','027','12000.00','1','AN1142023081117','11420231327','PATULOT','ELIZABETH','ALMARIA','','','','','0','','0000-00-00','15000.00','2023-08-20','B6','040','WITH CHECK','15000.00','002B','2023-08-22 12:16:37','0','RENEWAL','002B','2023-08-20 16:25:31','114','2023-08-22 16:23:51');
INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES 
('LRN11420232831','','','2023-08-25','0000-00-00','0','0.00','','0000-00-00','0000-00-00','9693','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-08-22 16:21:56','027','10000.00','1','AN1142023081118','11420221135','FAJARDO','JANET','DATINGUINOO','','','','','0','','0000-00-00','10000.00','2023-08-20','B9','','Released','10000.00','002B','2023-08-20 22:18:55','0','RENEWAL','002B','2023-08-20 16:27:18','114','2023-08-25 10:59:23');
