INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287716','0.00','0.00','0.00','0.00','0.00','112-112029','112','13CLC','LRN11220232303','2024-01-06','0','','500.00','','042','0','112','015','2024-01-06 14:10:08','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10:08');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287717','0.00','0.00','0.00','0.00','0.00','112-112030','112','13CLC','LRN11220232304','2024-01-06','0','','170.00','','042','0','112','015','2024-01-06 14:10:10','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10:10');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287718','0.00','0.00','0.00','0.00','0.00','112-112031','112','13CLC','LRN11220232305','2024-01-06','0','','500.00','','042','0','112','015','2024-01-06 14:10:12','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10:12');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287719','0.00','0.00','0.00','0.00','0.00','112-112032','112','13CLC','LRN11220232252','2024-01-06','0','','310.00','','042','0','112','015','2024-01-06 14:10:14','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287720','0.00','0.00','0.00','0.00','0.00','112-112033','112','13CLC','LRN11220232284','2024-01-06','0','','150.00','','042','0','112','015','2024-01-06 14:10:16','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287721','0.00','0.00','0.00','0.00','0.00','112-112034','112','13CLC','LRN11220232439','2024-01-06','0','','200.00','','042','0','112','015','2024-01-06 14:10:18','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287722','0.00','0.00','0.00','0.00','0.00','112-112035','112','13CLC','LRN11220232434','2024-01-06','0','','210.00','','042','0','112','015','2024-01-06 14:10:20','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287723','0.00','0.00','0.00','0.00','0.00','112-112036','112','13CLC','LRN11220232323','2024-01-06','0','','660.00','','042','0','112','015','2024-01-06 14:10:22','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287724','0.00','0.00','0.00','0.00','0.00','112-112037','112','13CLC','LRN11220232299','2024-01-06','0','','100.00','','042','0','112','015','2024-01-06 14:10:24','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287725','0.00','0.00','0.00','0.00','0.00','112-112038','112','13CLC','LRN11220232408','2024-01-06','0','','280.00','','042','0','112','015','2024-01-06 14:10:26','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287726','0.00','0.00','0.00','0.00','0.00','112-112039','112','13CLC','LRN11220240001','2024-01-06','0','','160.00','','042','0','112','015','2024-01-06 14:10:28','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287727','0.00','0.00','0.00','0.00','0.00','112-112040','112','13CLC','LRN11220232436','2024-01-06','0','','150.00','','042','0','112','015','2024-01-06 14:10:30','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287728','0.00','0.00','0.00','0.00','0.00','112-112041','112','13CLC','LRN11220232483','2024-01-06','0','','250.00','','042','0','112','015','2024-01-06 14:10:32','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287729','0.00','0.00','0.00','0.00','0.00','112-112042','112','13CLC','LRN11220232318','2024-01-06','0','','350.00','','042','0','112','015','2024-01-06 14:10:35','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287730','0.00','0.00','0.00','0.00','0.00','112-112043','112','13CLC','LRN11220232113','2024-01-06','0','','100.00','','042','0','112','015','2024-01-06 14:10:37','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287731','0.00','0.00','0.00','0.00','0.00','112-112044','112','13CLC','LRN11220232392','2024-01-06','0','','500.00','','042','0','112','015','2024-01-06 14:10:39','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287732','0.00','0.00','0.00','0.00','0.00','112-112045','112','13CLC','LRN11220232471','2024-01-06','0','','400.00','','042','0','112','015','2024-01-06 14:10:41','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10: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','287733','0.00','0.00','0.00','0.00','0.00','112-112046','112','13CLC','LRN11220232347','2024-01-06','0','','300.00','','042','0','112','015','2024-01-06 14:10:43','0','0000-00-00 00:00:00','0','015','2024-01-06 14:09:00','2024-01-06 14:10:43');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287734','0.00','0.00','0.00','0.00','0.00','112-112047','112','12CLC','LRN11220232171','2024-01-06','0','','1000.00','','004i','0','112','015','2024-01-06 14:18:14','0','0000-00-00 00:00:00','0','015','2024-01-06 14:14:56','2024-01-06 14:18: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','287735','0.00','0.00','0.00','0.00','0.00','112-112048','112','2CLC','LRN11220232480','2024-01-06','0','','500.00','','002','0','112','015','2024-01-06 14:18:46','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:18: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','287736','0.00','0.00','0.00','0.00','0.00','112-112049','112','2CLC','LRN11220232234','2024-01-06','0','','500.00','','002','0','112','015','2024-01-06 14:18:48','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:18: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','287737','0.00','0.00','0.00','0.00','0.00','112-112050','112','2CLC','LRN11220232279','2024-01-06','0','','112.00','','002','0','112','015','2024-01-06 14:18:50','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:18: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','287738','0.00','0.00','0.00','0.00','0.00','112-112051','112','2CLC','LRN11220232447','2024-01-06','0','','250.00','','002','0','112','015','2024-01-06 14:18:53','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:18: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','287739','0.00','0.00','0.00','0.00','0.00','112-112052','112','2CLC','LRN11220232448','2024-01-06','0','','200.00','','002','0','112','015','2024-01-06 14:18:55','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:18: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','287740','0.00','0.00','0.00','0.00','0.00','112-112053','112','2CLC','LRN11220232444','2024-01-06','0','','220.00','','002','0','112','015','2024-01-06 14:18:57','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:18: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','287741','0.00','0.00','0.00','0.00','0.00','112-112054','112','2CLC','LRN11220232131','2024-01-06','0','','100.00','','002','0','112','015','2024-01-06 14:18:59','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:18: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','287742','0.00','0.00','0.00','0.00','0.00','112-112055','112','2CLC','LRN11220232352','2024-01-06','0','','200.00','','002','0','112','015','2024-01-06 14:19:01','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:19: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','287743','0.00','0.00','0.00','0.00','0.00','112-112056','112','2CLC','LRN11220232358','2024-01-06','0','','200.00','','002','0','112','015','2024-01-06 14:19:03','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:19: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','287744','0.00','0.00','0.00','0.00','0.00','112-112057','112','2CLC','LRN11220232485','2024-01-06','0','','260.00','','002','0','112','015','2024-01-06 14:19:05','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:19: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','287745','0.00','0.00','0.00','0.00','0.00','112-112058','112','2CLC','LRN11220232272','2024-01-06','0','','200.00','','002','0','112','015','2024-01-06 14:19:07','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:19: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','287746','0.00','0.00','0.00','0.00','0.00','112-112059','112','2CLC','LRN11220232466','2024-01-06','0','','500.00','','002','0','112','015','2024-01-06 14:19:09','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:19: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','287747','0.00','0.00','0.00','0.00','0.00','112-112060','112','2CLC','LRN11220232409','2024-01-06','0','','900.00','','002','0','112','015','2024-01-06 14:19:11','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:19: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','287748','0.00','0.00','0.00','0.00','0.00','112-112061','112','2CLC','LRN11220232333','2024-01-06','0','','210.00','','002','0','112','015','2024-01-06 14:19:13','0','0000-00-00 00:00:00','0','015','2024-01-06 14:17:13','2024-01-06 14:19: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','287749','0.00','0.00','0.00','0.00','0.00','112-112062','112','12CLC','LRN11220231854','2024-01-06','0','','100.00','','004i','0','112','015','2024-01-06 14:37:31','0','0000-00-00 00:00:00','0','015','2024-01-06 14:30:52','2024-01-06 14:37: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','287750','0.00','0.00','0.00','0.00','0.00','112-112063','112','11CLC','LRN11220232116','2024-01-06','0','','200.00','','034','0','112','015','2024-01-06 14:36:49','0','0000-00-00 00:00:00','0','015','2024-01-06 14:31:59','2024-01-06 14:36:49');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287751','0.00','0.00','0.00','0.00','0.00','112-112064','112','11CLC','LRN11220232038','2024-01-06','0','','100.00','','034','0','112','015','2024-01-06 14:36:51','0','0000-00-00 00:00:00','0','015','2024-01-06 14:31:59','2024-01-06 14:36:51');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287752','0.00','0.00','0.00','0.00','0.00','112-112065','112','4CLC','LRN11220232413','2024-01-06','0','','210.00','','004i','0','112','015','2024-01-06 14:38:20','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287753','0.00','0.00','0.00','0.00','0.00','112-112066','112','4CLC','LRN11220232331','2024-01-06','0','','1050.00','','004i','0','112','015','2024-01-06 14:38:22','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287754','0.00','0.00','0.00','0.00','0.00','112-112067','112','4CLC','LRN11220232375','2024-01-06','0','','200.00','','004i','0','112','015','2024-01-06 14:38:24','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287755','0.00','0.00','0.00','0.00','0.00','112-112068','112','4CLC','LRN11220232432','2024-01-06','0','','500.00','','004i','0','112','015','2024-01-06 14:38:26','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287756','0.00','0.00','0.00','0.00','0.00','112-112069','112','4CLC','LRN11220232251','2024-01-06','0','','170.00','','004i','0','112','015','2024-01-06 14:38:28','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287757','0.00','0.00','0.00','0.00','0.00','112-112070','112','4CLC','LRN11220232334','2024-01-06','0','','170.00','','004i','0','112','015','2024-01-06 14:38:30','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287758','0.00','0.00','0.00','0.00','0.00','112-112071','112','4CLC','LRN11220232356','2024-01-06','0','','200.00','','004i','0','112','015','2024-01-06 14:38:32','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287759','0.00','0.00','0.00','0.00','0.00','112-112072','112','4CLC','LRN11220232321','2024-01-06','0','','800.00','','004i','0','112','015','2024-01-06 14:38:34','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287760','0.00','0.00','0.00','0.00','0.00','112-112073','112','4CLC','LRN11220232406','2024-01-06','0','','700.00','','004i','0','112','015','2024-01-06 14:38:37','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287761','0.00','0.00','0.00','0.00','0.00','112-112074','112','4CLC','LRN11220232343','2024-01-06','0','','300.00','','004i','0','112','015','2024-01-06 14:38:39','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287762','0.00','0.00','0.00','0.00','0.00','112-112075','112','4CLC','LRN11220232150','2024-01-06','0','','400.00','','004i','0','112','015','2024-01-06 14:38:41','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287763','0.00','0.00','0.00','0.00','0.00','112-112076','112','4CLC','LRN11220232449','2024-01-06','0','','170.00','','004i','0','112','015','2024-01-06 14:38:43','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38:43');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287764','0.00','0.00','0.00','0.00','0.00','112-112077','112','4CLC','LRN11220232253','2024-01-06','0','','252.00','','004i','0','112','015','2024-01-06 14:38:45','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38:45');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287765','0.00','0.00','0.00','0.00','0.00','112-112078','112','4CLC','LRN11220232418','2024-01-06','0','','200.00','','004i','0','112','015','2024-01-06 14:38:47','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38:47');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287766','0.00','0.00','0.00','0.00','0.00','112-112079','112','4CLC','LRN11220232367','2024-01-06','0','','350.00','','004i','0','112','015','2024-01-06 14:38:49','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38:49');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287767','0.00','0.00','0.00','0.00','0.00','112-112080','112','4CLC','LRN11220232424','2024-01-06','0','','100.00','','004i','0','112','015','2024-01-06 14:38:51','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38:51');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287768','0.00','0.00','0.00','0.00','0.00','112-112081','112','4CLC','LRN11220232276','2024-01-06','0','','250.00','','004i','0','112','015','2024-01-06 14:38:53','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287769','0.00','0.00','0.00','0.00','0.00','112-112082','112','4CLC','LRN11220232310','2024-01-06','0','','300.00','','004i','0','112','015','2024-01-06 14:38:55','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287770','0.00','0.00','0.00','0.00','0.00','112-112083','112','4CLC','LRN11220232440','2024-01-06','0','','200.00','','004i','0','112','015','2024-01-06 14:38:57','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287771','0.00','0.00','0.00','0.00','0.00','112-112084','112','4CLC','LRN11220232353','2024-01-06','0','','130.00','','004i','0','112','015','2024-01-06 14:38:59','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:38: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','287772','0.00','0.00','0.00','0.00','0.00','112-112085','112','4CLC','LRN11220232399','2024-01-06','0','','250.00','','004i','0','112','015','2024-01-06 14:39:01','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:39: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','287773','0.00','0.00','0.00','0.00','0.00','112-112086','112','4CLC','LRN11220232390','2024-01-06','0','','250.00','','004i','0','112','015','2024-01-06 14:39:03','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:39: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','287774','0.00','0.00','0.00','0.00','0.00','112-112087','112','4CLC','LRN11220232442','2024-01-06','0','','200.00','','004i','0','112','015','2024-01-06 14:39:06','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:39:06');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287775','0.00','0.00','0.00','0.00','0.00','112-112088','112','4CLC','LRN11220232314','2024-01-06','0','','420.00','','004i','0','112','015','2024-01-06 14:39:08','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:39: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','287776','0.00','0.00','0.00','0.00','0.00','112-112089','112','4CLC','LRN11220232292','2024-01-06','0','','200.00','','004i','0','112','015','2024-01-06 14:39:10','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:39: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','287777','0.00','0.00','0.00','0.00','0.00','112-112090','112','4CLC','LRN11220232312','2024-01-06','0','','300.00','','004i','0','112','015','2024-01-06 14:39:12','0','0000-00-00 00:00:00','0','015','2024-01-06 14:35:30','2024-01-06 14:39: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','287778','0.00','0.00','0.00','0.00','0.00','112-112091','112','4CLC','LRN11220232414','2024-01-06','0','','700.00','','004i','0','112','015','2024-01-06 15:07:21','0','0000-00-00 00:00:00','0','015','2024-01-06 15:06:11','2024-01-06 15:07:21');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287779','0.00','0.00','0.00','0.00','0.00','112-112092','112','2CLC','LRN11220232264','2024-01-06','0','','100.00','','002','0','112','015','2024-01-06 15:38:22','0','0000-00-00 00:00:00','0','015','2024-01-06 15:32:02','2024-01-06 15:38: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','287780','0.00','0.00','0.00','0.00','0.00','112-112093','112','3CLC','LRN11220232302','2024-01-06','0','','2100.00','','006','0','112','015','2024-01-06 15:38:55','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:38: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','287781','0.00','0.00','0.00','0.00','0.00','112-112094','112','3CLC','LRN11220232446','2024-01-06','0','','210.00','','006','0','112','015','2024-01-06 15:38:57','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:38: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','287782','0.00','0.00','0.00','0.00','0.00','112-112095','112','3CLC','LRN11220232274','2024-01-06','0','','1000.00','','006','0','112','015','2024-01-06 15:38:59','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:38: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','287783','0.00','0.00','0.00','0.00','0.00','112-112096','112','3CLC','LRN11220232469','2024-01-06','0','','300.00','','006','0','112','015','2024-01-06 15:39:01','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287784','0.00','0.00','0.00','0.00','0.00','112-112097','112','3CLC','LRN11220232259','2024-01-06','0','','300.00','','006','0','112','015','2024-01-06 15:39:03','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287785','0.00','0.00','0.00','0.00','0.00','112-112098','112','3CLC','LRN11220232281','2024-01-06','0','','350.00','','006','0','112','015','2024-01-06 15:39:05','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287786','0.00','0.00','0.00','0.00','0.00','112-112099','112','3CLC','LRN11220232328','2024-01-06','0','','210.00','','006','0','112','015','2024-01-06 15:39:07','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287787','0.00','0.00','0.00','0.00','0.00','112-112100','112','3CLC','LRN11220232327','2024-01-06','0','','300.00','','006','0','112','015','2024-01-06 15:39:09','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287788','0.00','0.00','0.00','0.00','0.00','112-112101','112','3CLC','LRN11220232268','2024-01-06','0','','500.00','','006','0','112','015','2024-01-06 15:39:11','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287789','0.00','0.00','0.00','0.00','0.00','112-112102','112','3CLC','LRN11220231629','2024-01-06','0','','100.00','','006','0','112','015','2024-01-06 15:39:13','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287790','0.00','0.00','0.00','0.00','0.00','112-112103','112','3CLC','LRN11220232425','2024-01-06','0','','400.00','','006','0','112','015','2024-01-06 15:39:15','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287791','0.00','0.00','0.00','0.00','0.00','112-112104','112','3CLC','LRN11220232460','2024-01-06','0','','1470.00','','006','0','112','015','2024-01-06 15:39:17','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287792','0.00','0.00','0.00','0.00','0.00','112-112105','112','3CLC','LRN11220232401','2024-01-06','0','','3500.00','','006','0','112','015','2024-01-06 15:39:19','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287793','0.00','0.00','0.00','0.00','0.00','112-112106','112','3CLC','LRN11220232415','2024-01-06','0','','150.00','','006','0','112','015','2024-01-06 15:39:21','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287794','0.00','0.00','0.00','0.00','0.00','112-112107','112','3CLC','LRN11220232405','2024-01-06','0','','225.00','','006','0','112','015','2024-01-06 15:39:24','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287795','0.00','0.00','0.00','0.00','0.00','112-112108','112','3CLC','LRN11220232330','2024-01-06','0','','182.00','','006','0','112','015','2024-01-06 15:39:26','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287796','0.00','0.00','0.00','0.00','0.00','112-112109','112','3CLC','LRN11220232209','2024-01-06','0','','200.00','','006','0','112','015','2024-01-06 15:39:28','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287797','0.00','0.00','0.00','0.00','0.00','112-112110','112','3CLC','LRN11220210145','2024-01-06','0','','100.00','','006','0','112','015','2024-01-06 15:39:30','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287798','0.00','0.00','0.00','0.00','0.00','112-112111','112','3CLC','LRN11220232394','2024-01-06','0','','200.00','','006','0','112','015','2024-01-06 15:39:32','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287799','0.00','0.00','0.00','0.00','0.00','112-112112','112','3CLC','LRN11220232484','2024-01-06','0','','400.00','','006','0','112','015','2024-01-06 15:39:34','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287800','0.00','0.00','0.00','0.00','0.00','112-112113','112','3CLC','LRN11220232290','2024-01-06','0','','350.00','','006','0','112','015','2024-01-06 15:39:36','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287801','0.00','0.00','0.00','0.00','0.00','112-112114','112','3CLC','LRN11220232433','2024-01-06','0','','600.00','','006','0','112','015','2024-01-06 15:39:38','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287802','0.00','0.00','0.00','0.00','0.00','112-112115','112','3CLC','LRN11220232421','2024-01-06','0','','600.00','','006','0','112','015','2024-01-06 15:39:40','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287803','0.00','0.00','0.00','0.00','0.00','112-112116','112','3CLC','LRN11220232348','2024-01-06','0','','500.00','','006','0','112','015','2024-01-06 15:39:42','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287804','0.00','0.00','0.00','0.00','0.00','112-112117','112','3CLC','LRN11220232231','2024-01-06','0','','400.00','','006','0','112','015','2024-01-06 15:39:44','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287805','0.00','0.00','0.00','0.00','0.00','112-112118','112','3CLC','LRN11220232487','2024-01-06','0','','420.00','','006','0','112','015','2024-01-06 15:39:46','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287806','0.00','0.00','0.00','0.00','0.00','112-112119','112','3CLC','LRN11220232380','2024-01-06','0','','200.00','','006','0','112','015','2024-01-06 15:39:48','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287807','0.00','0.00','0.00','0.00','0.00','112-112120','112','3CLC','LRN11220232341','2024-01-06','0','','300.00','','006','0','112','015','2024-01-06 15:39:51','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39:51');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','287808','0.00','0.00','0.00','0.00','0.00','112-112121','112','3CLC','LRN11220232458','2024-01-06','0','','150.00','','006','0','112','015','2024-01-06 15:39:53','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287809','0.00','0.00','0.00','0.00','0.00','112-112122','112','3CLC','LRN11220232476','2024-01-06','0','','210.00','','006','0','112','015','2024-01-06 15:39:55','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287810','0.00','0.00','0.00','0.00','0.00','112-112123','112','3CLC','LRN11220232191','2024-01-06','0','','700.00','','006','0','112','015','2024-01-06 15:39:57','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287811','0.00','0.00','0.00','0.00','0.00','112-112124','112','3CLC','LRN11220231656','2024-01-06','0','','200.00','','006','0','112','015','2024-01-06 15:39:59','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:39: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','287812','0.00','0.00','0.00','0.00','0.00','112-112125','112','3CLC','LRN11220232064','2024-01-06','0','','1700.00','','006','0','112','015','2024-01-06 15:40:01','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:40: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','287813','0.00','0.00','0.00','0.00','0.00','112-112126','112','3CLC','LRN11220232411','2024-01-06','0','','700.00','','006','0','112','015','2024-01-06 15:40:03','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15: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','287814','0.00','0.00','0.00','0.00','0.00','112-112127','112','3CLC','LRN11220232470','2024-01-06','0','','250.00','','006','0','112','015','2024-01-06 15:40:05','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15: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','287815','0.00','0.00','0.00','0.00','0.00','112-112128','112','3CLC','LRN11220232300','2024-01-06','0','','100.00','','006','0','112','015','2024-01-06 15:40:07','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15: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','287816','0.00','0.00','0.00','0.00','0.00','112-112129','112','3CLC','LRN11220232258','2024-01-06','0','','500.00','','006','0','112','015','2024-01-06 15:40:09','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15: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','287817','0.00','0.00','0.00','0.00','0.00','112-112130','112','3CLC','LRN11220232365','2024-01-06','0','','500.00','','006','0','112','015','2024-01-06 15:40:11','0','0000-00-00 00:00:00','0','015','2024-01-06 15:36:58','2024-01-06 15:40:11');
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-01-06','163','2001-12-12','100.00','100.00','100.00','','INACTIVE','006','2024-01-06 09:11:32','2024-01-08 11:01:20');
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','Undeposited','2024-01-06','0','0000-00-00','100.00','0.00','0.00','','INACTIVE','006','2024-01-06 09:11:33','2024-01-06 09:14:36');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','13CLC','Deposited','2024-01-06','166','2024-01-06','5290.00','0.00','0.00','','ACTIVE','015','2024-01-06 14:11:28','2024-01-06 14:11: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-01-06','166','2024-01-06','1000.00','0.00','0.00','','ACTIVE','015','2024-01-06 14:20:13','2024-01-06 14:20:13');
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-01-06','166','2024-01-06','4352.00','0.00','0.00','','ACTIVE','015','2024-01-06 14:20:41','2024-01-06 14:20:41');
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-01-06','166','2024-01-06','4352.00','0.00','0.00','','INACTIVE','015','2024-01-06 14:24:28','2024-01-06 15:08:42');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','4CLC','Deposited','2024-01-06','166','2024-01-06','8272.00','0.00','0.00','','ACTIVE','015','2024-01-06 14:47:30','2024-01-06 14:47:30');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','12CLC','Deposited','2024-01-06','166','2024-01-06','100.00','0.00','0.00','','INACTIVE','015','2024-01-06 14:47:59','2024-01-06 15:09:18');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','11CLC','Deposited','2024-01-06','166','2024-01-06','300.00','0.00','0.00','','ACTIVE','015','2024-01-06 14:48:26','2024-01-06 14:48:26');
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-01-06','166','2024-01-06','700.00','0.00','0.00','','ACTIVE','015','2024-01-06 15:08:01','2024-01-06 15:08:01');
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-01-06','166','2024-01-06','100.00','0.00','0.00','','ACTIVE','015','2024-01-06 15:41:10','2024-01-06 15:41:10');
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-01-06','166','2024-01-06','20577.00','0.00','0.00','','ACTIVE','015','2024-01-06 15:41:35','2024-01-06 15:41:35');
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='12800.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='2021-04-13 13:55:18',sales_Timestamp='2024-01-06 16:02:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='27200.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2021-04-13 13:56:39',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220201774',sales_AssignTo='006',sales_PNumber='LRN11220210145',sales_Amt='40000.00',sales_Area='3CLC',sales_Cycle='3',sales_Released='2021-04-13',sales_Maturity='2021-07-22',sales_BegBalance='40000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220210145' ; 
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='9141.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='2022-07-19 13:15:29',sales_Timestamp='2024-01-06 09:02:11',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10859.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2022-07-19 13:16:00',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221901',sales_AssignTo='034',sales_PNumber='LRN11220220977',sales_Amt='20000.00',sales_Area='11CLC',sales_Cycle='3',sales_Released='2022-07-19',sales_Maturity='2022-10-27',sales_BegBalance='20000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220220977' ; 
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='1560.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-03-23 12:53:30',sales_Timestamp='2024-01-06 16:02:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='11440.00',sales_PaymentCutoff='250.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-03-23 12:57:21',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222038',sales_AssignTo='006',sales_PNumber='LRN11220231629',sales_Amt='13000.00',sales_Area='3CLC',sales_Cycle='3',sales_Released='2023-03-23',sales_Maturity='2023-07-01',sales_BegBalance='13000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220231629' ; 
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='9150.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-03-30 14:26:31',sales_Timestamp='2024-01-06 16:02:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5850.00',sales_PaymentCutoff='200.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-03-30 14:27:29',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222015',sales_AssignTo='006',sales_PNumber='LRN11220231656',sales_Amt='15000.00',sales_Area='3CLC',sales_Cycle='3',sales_Released='2023-03-30',sales_Maturity='2023-07-08',sales_BegBalance='15000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220231656' ; 
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='16800.00',sales_amortization='420.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='42000.00',sales_interest_amt='0.00',sales_prin_amt='42000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-06-13 12:45:18',sales_Timestamp='2024-01-06 09:02:12',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='25200.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-06-13 12:45:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191738',sales_AssignTo='034',sales_PNumber='LRN11220231838',sales_Amt='42000.00',sales_Area='11CLC',sales_Cycle='12',sales_Released='2023-06-13',sales_Maturity='2023-09-21',sales_BegBalance='42000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220231838' ; 
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='6350.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='2023-06-14 14:14:25',sales_Timestamp='2024-01-06 16:02:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9650.00',sales_PaymentCutoff='200.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-06-14 14:18:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232074',sales_AssignTo='043',sales_PNumber='LRN11220231854',sales_Amt='16000.00',sales_Area='12CLC',sales_Cycle='3',sales_Released='2023-06-14',sales_Maturity='2023-09-22',sales_BegBalance='16000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220231854' ; 
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='1346.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-07-07 15:58:45',sales_Timestamp='2024-01-06 09:02:12',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='21654.00',sales_PaymentCutoff='2000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-07-07 16:05:55',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221946',sales_AssignTo='004i',sales_PNumber='LRN11220231936',sales_Amt='23000.00',sales_Area='4CLC',sales_Cycle='5',sales_Released='2023-07-07',sales_Maturity='2023-10-15',sales_BegBalance='23000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220231936' ; 
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='12750.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-01-06 09:02:12',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7250.00',sales_PaymentCutoff='100.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-01-05' 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='10620.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-01-06 09:02:12',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='16380.00',sales_PaymentCutoff='200.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-01-05' 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='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-07-25 11:49:47',sales_Timestamp='2024-01-06 09:02:12',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='250.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-07-25 11:50:56',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232200',sales_AssignTo='034',sales_PNumber='LRN11220232004',sales_Amt='10000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2023-07-25',sales_Maturity='2023-11-02',sales_BegBalance='10000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232004' ; 
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='10600.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-07-28 10:38:03',sales_Timestamp='2024-01-06 09:02:12',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='14400.00',sales_PaymentCutoff='150.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-07-28 10:40:12',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211863',sales_AssignTo='034',sales_PNumber='LRN11220232012',sales_Amt='25000.00',sales_Area='11CLC',sales_Cycle='9',sales_Released='2023-07-28',sales_Maturity='2023-11-05',sales_BegBalance='25000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232012' ; 
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='7720.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-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5280.00',sales_PaymentCutoff='250.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-01-05' 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='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-18 13:38:49',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='560.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-18 14:30:32',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232119',sales_AssignTo='034',sales_PNumber='LRN11220232092',sales_Amt='10000.00',sales_Area='11CLC',sales_Cycle='2',sales_Released='2023-08-18',sales_Maturity='2023-11-26',sales_BegBalance='10000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232092' ; 
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='1920.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-24 10:49:04',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10080.00',sales_PaymentCutoff='170.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-24 10:52:01',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232126',sales_AssignTo='002',sales_PNumber='LRN11220232109',sales_Amt='12000.00',sales_Area='2CLC',sales_Cycle='2',sales_Released='2023-08-24',sales_Maturity='2023-12-02',sales_BegBalance='12000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232109' ; 
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='1900.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='2023-08-24 10:49:53',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8100.00',sales_PaymentCutoff='450.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-24 10:52:01',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232099',sales_AssignTo='042',sales_PNumber='LRN11220232113',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='3',sales_Released='2023-08-24',sales_Maturity='2023-12-02',sales_BegBalance='10000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232113' ; 
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='7300.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='2023-08-24 14:29:18',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='32700.00',sales_PaymentCutoff='400.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-24 14:29:59',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220201754',sales_AssignTo='034',sales_PNumber='LRN11220232116',sales_Amt='40000.00',sales_Area='11CLC',sales_Cycle='12',sales_Released='2023-08-24',sales_Maturity='2023-12-02',sales_BegBalance='40000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232116' ; 
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='3480.00',sales_amortization='70.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='7000.00',sales_interest_amt='0.00',sales_prin_amt='7000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-30 12:08:59',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3520.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-30 12:21:26',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232237',sales_AssignTo='002',sales_PNumber='LRN11220232131',sales_Amt='7000.00',sales_Area='2CLC',sales_Cycle='1',sales_Released='2023-08-30',sales_Maturity='2023-12-08',sales_BegBalance='7000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232131' ; 
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='5980.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-30 12:13:07',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='17020.00',sales_PaymentCutoff='300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-30 12:21:26',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222034',sales_AssignTo='034',sales_PNumber='LRN11220232134',sales_Amt='23000.00',sales_Area='11CLC',sales_Cycle='7',sales_Released='2023-08-30',sales_Maturity='2023-12-08',sales_BegBalance='23000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232134' ; 
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='9700.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='015',sales_PostedDate='2023-09-07 13:58:42',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20300.00',sales_PaymentCutoff='800.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-09-07 14:02:10',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220201762',sales_AssignTo='004i',sales_PNumber='LRN11220232150',sales_Amt='30000.00',sales_Area='4CLC',sales_Cycle='11',sales_Released='2023-09-07',sales_Maturity='2023-12-16',sales_BegBalance='30000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232150' ; 
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='2023-09-13 13:44:13',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4700.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-09-13 13:44:43',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232249',sales_AssignTo='037',sales_PNumber='LRN11220232171',sales_Amt='10000.00',sales_Area='12CLC',sales_Cycle='1',sales_Released='2023-09-13',sales_Maturity='2023-12-22',sales_BegBalance='10000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232171' ; 
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='9350.00',sales_amortization='140.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='14000.00',sales_interest_amt='0.00',sales_prin_amt='14000.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-09-23 14:57:47',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4650.00',sales_PaymentCutoff='250.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-09-23 15:00:08',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211860',sales_AssignTo='006',sales_PNumber='LRN11220232204',sales_Amt='14000.00',sales_Area='3CLC',sales_Cycle='8',sales_Released='2023-09-23',sales_Maturity='2024-01-01',sales_BegBalance='14000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232204' ; 
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='5770.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-09-26 13:37:54',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6230.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-09-26 13:38:34',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232166',sales_AssignTo='002',sales_PNumber='LRN11220232213',sales_Amt='12000.00',sales_Area='2CLC',sales_Cycle='2',sales_Released='2023-09-26',sales_Maturity='2024-01-04',sales_BegBalance='12000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232213' ; 
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='4500.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-09-29 13:55:17',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20500.00',sales_PaymentCutoff='800.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-09-29 13:57:08',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211876',sales_AssignTo='006',sales_PNumber='LRN11220232231',sales_Amt='25000.00',sales_Area='3CLC',sales_Cycle='7',sales_Released='2023-09-29',sales_Maturity='2024-01-07',sales_BegBalance='25000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232231' ; 
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='8870.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-09-30 11:12:01',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6130.00',sales_PaymentCutoff='600.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-09-30 11:12:48',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221954',sales_AssignTo='006',sales_PNumber='LRN11220232236',sales_Amt='15000.00',sales_Area='3CLC',sales_Cycle='6',sales_Released='2023-09-30',sales_Maturity='2024-01-08',sales_BegBalance='15000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232236' ; 
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='17560.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='015',sales_PostedDate='2023-10-13 11:53:58',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12440.00',sales_PaymentCutoff='1500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-13 11:54:48',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211875',sales_AssignTo='006',sales_PNumber='LRN11220232258',sales_Amt='30000.00',sales_Area='3CLC',sales_Cycle='10',sales_Released='2023-10-13',sales_Maturity='2024-01-21',sales_BegBalance='30000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232258' ; 
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='16000.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='2023-10-19 13:12:08',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='34000.00',sales_PaymentCutoff='4000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-19 13:15:13',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170613',sales_AssignTo='006',sales_PNumber='LRN11220232274',sales_Amt='50000.00',sales_Area='3CLC',sales_Cycle='12',sales_Released='2023-10-19',sales_Maturity='2024-01-27',sales_BegBalance='50000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232274' ; 
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='9700.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-10-19 13:14:01',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='15300.00',sales_PaymentCutoff='1250.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-19 13:15:13',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211890',sales_AssignTo='004i',sales_PNumber='LRN11220232276',sales_Amt='25000.00',sales_Area='4CLC',sales_Cycle='9',sales_Released='2023-10-19',sales_Maturity='2024-01-27',sales_BegBalance='25000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232276' ; 
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='5946.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-10-19 13:33:11',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='14054.00',sales_PaymentCutoff='840.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-19 13:34:22',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221992',sales_AssignTo='004i',sales_PNumber='LRN11220232280',sales_Amt='20000.00',sales_Area='4CLC',sales_Cycle='6',sales_Released='2023-10-19',sales_Maturity='2024-01-27',sales_BegBalance='20000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232280' ; 
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='12110.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-10-20 13:37:22',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12890.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-20 13:40:58',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211868',sales_AssignTo='006',sales_PNumber='LRN11220232281',sales_Amt='25000.00',sales_Area='3CLC',sales_Cycle='10',sales_Released='2023-10-20',sales_Maturity='2024-01-28',sales_BegBalance='25000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232281' ; 
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='3970.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='2023-10-26 12:35:06',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6030.00',sales_PaymentCutoff='700.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-26 12:36:21',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232211',sales_AssignTo='042',sales_PNumber='LRN11220232299',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2023-10-26',sales_Maturity='2024-02-03',sales_BegBalance='10000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232299' ; 
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='15140.00',sales_amortization='380.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='38000.00',sales_interest_amt='0.00',sales_prin_amt='38000.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-10-27 10:55:42',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='22860.00',sales_PaymentCutoff='5700.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-27 11:19:54',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170357',sales_AssignTo='006',sales_PNumber='LRN11220232302',sales_Amt='38000.00',sales_Area='3CLC',sales_Cycle='9',sales_Released='2023-10-27',sales_Maturity='2024-02-04',sales_BegBalance='38000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232302' ; 
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='9766.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='2023-10-27 11:01:32',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8234.00',sales_PaymentCutoff='765.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-27 11:19:54',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222047',sales_AssignTo='004i',sales_PNumber='LRN11220232309',sales_Amt='18000.00',sales_Area='4CLC',sales_Cycle='5',sales_Released='2023-10-27',sales_Maturity='2024-02-04',sales_BegBalance='18000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232309' ; 
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='9486.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='2023-10-28 10:14:18',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8514.00',sales_PaymentCutoff='800.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-28 10:15:32',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232177',sales_AssignTo='002',sales_PNumber='LRN11220232315',sales_Amt='18000.00',sales_Area='2CLC',sales_Cycle='3',sales_Released='2023-10-28',sales_Maturity='2024-02-05',sales_BegBalance='18000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232315' ; 
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='8825.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-10-30 13:35:43',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='16175.00',sales_PaymentCutoff='1750.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-30 13:38:21',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191557',sales_AssignTo='042',sales_PNumber='LRN11220232318',sales_Amt='25000.00',sales_Area='13CLC',sales_Cycle='6',sales_Released='2023-10-30',sales_Maturity='2024-02-07',sales_BegBalance='25000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232318' ; 
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='3900.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='2023-10-31 12:56:29',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6100.00',sales_PaymentCutoff='900.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-31 12:58:28',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232218',sales_AssignTo='042',sales_PNumber='LRN11220232320',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2023-10-31',sales_Maturity='2024-02-08',sales_BegBalance='10000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232320' ; 
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='4800.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-10-31 12:57:50',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7200.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-31 12:58:28',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232093',sales_AssignTo='004i',sales_PNumber='LRN11220232321',sales_Amt='12000.00',sales_Area='4CLC',sales_Cycle='4',sales_Released='2023-10-31',sales_Maturity='2024-02-08',sales_BegBalance='12000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232321' ; 
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='15610.00',sales_amortization='470.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='47000.00',sales_interest_amt='0.00',sales_prin_amt='47000.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-10-31 13:54:49',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='31390.00',sales_PaymentCutoff='3300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-31 13:55:21',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191564',sales_AssignTo='042',sales_PNumber='LRN11220232323',sales_Amt='47000.00',sales_Area='13CLC',sales_Cycle='13',sales_Released='2023-10-31',sales_Maturity='2024-02-08',sales_BegBalance='47000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232323' ; 
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='7750.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-08 12:34:35',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12250.00',sales_PaymentCutoff='1200.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-08 12:35:16',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222013',sales_AssignTo='006',sales_PNumber='LRN11220232327',sales_Amt='20000.00',sales_Area='3CLC',sales_Cycle='6',sales_Released='2023-11-08',sales_Maturity='2024-02-16',sales_BegBalance='20000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232327' ; 
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='6812.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-11 10:55:23',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6188.00',sales_PaymentCutoff='728.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-11 10:56:12',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221914',sales_AssignTo='006',sales_PNumber='LRN11220232330',sales_Amt='13000.00',sales_Area='3CLC',sales_Cycle='7',sales_Released='2023-11-11',sales_Maturity='2024-02-19',sales_BegBalance='13000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232330' ; 
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='6540.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-13 11:51:56',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8460.00',sales_PaymentCutoff='1050.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-13 11:55:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232153',sales_AssignTo='004i',sales_PNumber='LRN11220232331',sales_Amt='15000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2023-11-13',sales_Maturity='2024-02-21',sales_BegBalance='15000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232331' ; 
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='7220.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-13 11:54:42',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7780.00',sales_PaymentCutoff='630.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-13 11:55:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232123',sales_AssignTo='002',sales_PNumber='LRN11220232333',sales_Amt='15000.00',sales_Area='2CLC',sales_Cycle='3',sales_Released='2023-11-13',sales_Maturity='2024-02-21',sales_BegBalance='15000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232333' ; 
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='7240.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-11-14 10:39:56',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4760.00',sales_PaymentCutoff='400.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-14 10:43:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232092',sales_AssignTo='042',sales_PNumber='LRN11220232335',sales_Amt='12000.00',sales_Area='13CLC',sales_Cycle='4',sales_Released='2023-11-14',sales_Maturity='2024-02-22',sales_BegBalance='12000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232335' ; 
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='29250.00',sales_amortization='650.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='65000.00',sales_interest_amt='0.00',sales_prin_amt='65000.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-14 16:20:14',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='35750.00',sales_PaymentCutoff='4550.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-14 16:21:37',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232178',sales_AssignTo='004i',sales_PNumber='LRN11220232340',sales_Amt='65000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2023-11-14',sales_Maturity='2024-02-22',sales_BegBalance='65000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232340' ; 
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='6370.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-16 14:52:22',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6630.00',sales_PaymentCutoff='910.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-16 14:52:59',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191591',sales_AssignTo='004i',sales_PNumber='LRN11220232353',sales_Amt='13000.00',sales_Area='4CLC',sales_Cycle='2',sales_Released='2023-11-16',sales_Maturity='2024-02-24',sales_BegBalance='13000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232353' ; 
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='5610.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='2023-11-20 15:23:58',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4390.00',sales_PaymentCutoff='420.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-20 15:24:45',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232271',sales_AssignTo='042',sales_PNumber='LRN11220232371',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='1',sales_Released='2023-11-20',sales_Maturity='2024-02-28',sales_BegBalance='10000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232371' ; 
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='14990.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-21 11:37:27',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10010.00',sales_PaymentCutoff='1050.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-21 11:38:43',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222007',sales_AssignTo='006',sales_PNumber='LRN11220232376',sales_Amt='25000.00',sales_Area='3CLC',sales_Cycle='7',sales_Released='2023-11-21',sales_Maturity='2024-02-29',sales_BegBalance='25000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232376' ; 
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='38082.00',sales_amortization='700.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='70000.00',sales_interest_amt='0.00',sales_prin_amt='70000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-21 11:38:03',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='31918.00',sales_PaymentCutoff='3920.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-21 11:38:43',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170406',sales_AssignTo='006',sales_PNumber='LRN11220232377',sales_Amt='70000.00',sales_Area='3CLC',sales_Cycle='3',sales_Released='2023-11-21',sales_Maturity='2024-02-29',sales_BegBalance='70000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232377' ; 
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='8950.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-24 12:09:32',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6050.00',sales_PaymentCutoff='750.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-24 12:13:01',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222011',sales_AssignTo='004i',sales_PNumber='LRN11220232390',sales_Amt='15000.00',sales_Area='4CLC',sales_Cycle='5',sales_Released='2023-11-24',sales_Maturity='2024-03-03',sales_BegBalance='15000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232390' ; 
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='2023-11-24 13:24:13',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4700.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-24 13:24:48',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232215',sales_AssignTo='042',sales_PNumber='LRN11220232392',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='3',sales_Released='2023-11-24',sales_Maturity='2024-03-03',sales_BegBalance='10000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232392' ; 
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='5640.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='2023-11-25 11:10:59',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4360.00',sales_PaymentCutoff='700.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-25 11:12:13',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232128',sales_AssignTo='004i',sales_PNumber='LRN11220232393',sales_Amt='10000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2023-11-25',sales_Maturity='2024-03-04',sales_BegBalance='10000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232393' ; 
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='30500.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='2023-11-28 13:24:38',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='19500.00',sales_PaymentCutoff='3500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-28 13:25:12',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232117',sales_AssignTo='006',sales_PNumber='LRN11220232401',sales_Amt='50000.00',sales_Area='3CLC',sales_Cycle='3',sales_Released='2023-11-28',sales_Maturity='2024-03-07',sales_BegBalance='50000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232401' ; 
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='13210.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-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6790.00',sales_PaymentCutoff='1200.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-01-06' 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='6150.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='2023-11-30 11:15:03',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3850.00',sales_PaymentCutoff='700.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-30 11:16:47',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232256',sales_AssignTo='042',sales_PNumber='LRN11220232408',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2023-11-30',sales_Maturity='2024-03-09',sales_BegBalance='10000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232408' ; 
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='13000.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-30 11:15:38',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7000.00',sales_PaymentCutoff='1400.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-30 11:16:47',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232141',sales_AssignTo='002',sales_PNumber='LRN11220232409',sales_Amt='20000.00',sales_Area='2CLC',sales_Cycle='3',sales_Released='2023-11-30',sales_Maturity='2024-03-09',sales_BegBalance='20000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232409' ; 
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='35200.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='2023-12-07 11:10:06',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='14800.00',sales_PaymentCutoff='4200.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-07 11:11:54',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170127',sales_AssignTo='004i',sales_PNumber='LRN11220232414',sales_Amt='50000.00',sales_Area='4CLC',sales_Cycle='13',sales_Released='2023-12-07',sales_Maturity='2024-03-16',sales_BegBalance='50000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232414' ; 
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='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-12-08 10:09:16',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3860.00',sales_PaymentCutoff='800.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-08 10:09:47',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232255',sales_AssignTo='006',sales_PNumber='LRN11220232420',sales_Amt='13000.00',sales_Area='3CLC',sales_Cycle='2',sales_Released='2023-12-08',sales_Maturity='2024-03-17',sales_BegBalance='13000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232420' ; 
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='34150.00',sales_amortization='450.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='45000.00',sales_interest_amt='0.00',sales_prin_amt='45000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-12-09 10:13:36',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10850.00',sales_PaymentCutoff='2100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-09 10:14:24',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170597',sales_AssignTo='006',sales_PNumber='LRN11220232421',sales_Amt='45000.00',sales_Area='3CLC',sales_Cycle='10',sales_Released='2023-12-09',sales_Maturity='2024-03-18',sales_BegBalance='45000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232421' ; 
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='20050.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-12-12 10:44:39',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6950.00',sales_PaymentCutoff='1600.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-12 10:49:29',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221923',sales_AssignTo='006',sales_PNumber='LRN11220232425',sales_Amt='27000.00',sales_Area='3CLC',sales_Cycle='9',sales_Released='2023-12-12',sales_Maturity='2024-03-21',sales_BegBalance='27000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232425' ; 
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='12730.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='2023-12-14 13:49:45',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4270.00',sales_PaymentCutoff='1200.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-14 13:52:10',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232148',sales_AssignTo='004i',sales_PNumber='LRN11220232432',sales_Amt='17000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2023-12-14',sales_Maturity='2024-03-23',sales_BegBalance='17000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232432' ; 
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='31740.00',sales_amortization='420.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='42000.00',sales_interest_amt='0.00',sales_prin_amt='42000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-12-14 13:51:19',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10260.00',sales_PaymentCutoff='2400.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-14 13:52:10',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220201763',sales_AssignTo='006',sales_PNumber='LRN11220232433',sales_Amt='42000.00',sales_Area='3CLC',sales_Cycle='9',sales_Released='2023-12-14',sales_Maturity='2024-03-23',sales_BegBalance='42000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232433' ; 
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='12180.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-15 12:26:37',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2820.00',sales_PaymentCutoff='630.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-15 12:27:58',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232114',sales_AssignTo='042',sales_PNumber='LRN11220232434',sales_Amt='15000.00',sales_Area='13CLC',sales_Cycle='4',sales_Released='2023-12-15',sales_Maturity='2024-03-24',sales_BegBalance='15000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232434' ; 
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='9940.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-12-15 12:27:21',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3060.00',sales_PaymentCutoff='1000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-15 12:27:58',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232254',sales_AssignTo='042',sales_PNumber='LRN11220232435',sales_Amt='13000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2023-12-15',sales_Maturity='2024-03-24',sales_BegBalance='13000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232435' ; 
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='21380.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-12-16 11:31:17',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5620.00',sales_PaymentCutoff='4550.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-16 11:31:49',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221897',sales_AssignTo='006',sales_PNumber='LRN11220232438',sales_Amt='27000.00',sales_Area='3CLC',sales_Cycle='9',sales_Released='2023-12-16',sales_Maturity='2024-03-25',sales_BegBalance='27000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232438' ; 
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='9610.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-12-18 12:01:46',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2390.00',sales_PaymentCutoff='710.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-18 12:02:22',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232157',sales_AssignTo='004i',sales_PNumber='LRN11220232442',sales_Amt='12000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2023-12-18',sales_Maturity='2024-03-27',sales_BegBalance='12000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232442' ; 
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='40500.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='2023-12-19 12:22:12',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9500.00',sales_PaymentCutoff='3500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-19 12:22:44',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170360',sales_AssignTo='006',sales_PNumber='LRN11220232452',sales_Amt='50000.00',sales_Area='3CLC',sales_Cycle='15',sales_Released='2023-12-19',sales_Maturity='2024-03-28',sales_BegBalance='50000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232452' ; 
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='75680.00',sales_amortization='880.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='88000.00',sales_interest_amt='0.00',sales_prin_amt='88000.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-19 13:50:11',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12320.00',sales_PaymentCutoff='12320.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-19 13:50:43',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211850',sales_AssignTo='004i',sales_PNumber='LRN11220232453',sales_Amt='88000.00',sales_Area='4CLC',sales_Cycle='7',sales_Released='2023-12-19',sales_Maturity='2024-03-28',sales_BegBalance='88000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232453' ; 
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='12280.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-20 10:56:26',sales_Timestamp='2024-01-06 09:02:13',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2720.00',sales_PaymentCutoff='1300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-20 11:02:14',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232230',sales_AssignTo='042',sales_PNumber='LRN11220232454',sales_Amt='15000.00',sales_Area='13CLC',sales_Cycle='3',sales_Released='2023-12-20',sales_Maturity='2024-03-29',sales_BegBalance='15000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232454' ; 
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='17520.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-12-20 11:00:34',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2480.00',sales_PaymentCutoff='950.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-20 11:02:14',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211848',sales_AssignTo='006',sales_PNumber='LRN11220232458',sales_Amt='20000.00',sales_Area='3CLC',sales_Cycle='10',sales_Released='2023-12-20',sales_Maturity='2024-03-29',sales_BegBalance='20000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232458' ; 
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='11150.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-21 11:10:21',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3850.00',sales_PaymentCutoff='2100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-21 11:11:32',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191618',sales_AssignTo='006',sales_PNumber='LRN11220232460',sales_Amt='15000.00',sales_Area='3CLC',sales_Cycle='10',sales_Released='2023-12-21',sales_Maturity='2024-03-30',sales_BegBalance='15000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232460' ; 
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='13290.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-27 08:21:21',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1710.00',sales_PaymentCutoff='510.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-27 08:26:09',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221947',sales_AssignTo='006',sales_PNumber='LRN11220232469',sales_Amt='15000.00',sales_Area='3CLC',sales_Cycle='7',sales_Released='2023-12-27',sales_Maturity='2024-04-05',sales_BegBalance='15000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232469' ; 
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='22300.00',sales_amortization='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='0.00',sales_prin_amt='25000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-12-27 08:25:30',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2700.00',sales_PaymentCutoff='1150.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-27 08:26:09',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222027',sales_AssignTo='006',sales_PNumber='LRN11220232470',sales_Amt='25000.00',sales_Area='3CLC',sales_Cycle='5',sales_Released='2023-12-27',sales_Maturity='2024-04-05',sales_BegBalance='25000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220232470' ; 
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='16280.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='2023-12-29 11:19:55',sales_Timestamp='2024-01-06 09:02:14',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1720.00',sales_PaymentCutoff='800.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-12-29 11:21:20',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211886',sales_AssignTo='004i',sales_PNumber='LRN11220232490',sales_Amt='18000.00',sales_Area='4CLC',sales_Cycle='10',sales_Released='2023-12-29',sales_Maturity='2024-04-07',sales_BegBalance='18000.00',sales_LPD='2024-01-05' WHERE sales_PNumber = 'LRN11220232490' ; 
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='10960.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-01-02 08:55:35',sales_Timestamp='2024-01-06 16:02:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1040.00',sales_PaymentCutoff='750.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-01-02 08:56:27',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232115',sales_AssignTo='042',sales_PNumber='LRN11220240001',sales_Amt='12000.00',sales_Area='13CLC',sales_Cycle='4',sales_Released='2024-01-02',sales_Maturity='2024-04-11',sales_BegBalance='12000.00',sales_LPD='2024-01-06' WHERE sales_PNumber = 'LRN11220240001' ; 
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','11200','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','50000.00','1','AN1122024011159','11220170607','TESORO','REMEDIOS','SAGABAEN','','','','','0','','0000-00-00','50000.00','2024-01-06','3CLC','006','WITH CHECK','50000.00','015','2024-01-06 10:42:26','0','RENEWAL','015','2024-01-06 10:24:07','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11201','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','15000.00','1','AN1122024011160','11220232225','GOTOS','VIRGINIA','TAMONDONG','','','','','0','','0000-00-00','16000.00','2024-01-06','13CLC','042','WITH CHECK','16000.00','015','2024-01-06 10:37:48','0','RENEWAL','015','2024-01-06 10:25:11','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11202','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','13000.00','1','AN1122024011161','11220232214','MOTIN','VALENTINA','BASARTE','','','','','0','','0000-00-00','13000.00','2024-01-06','2CLC','002','WITH CHECK','13000.00','015','2024-01-06 10:38:44','0','RENEWAL','015','2024-01-06 10:26:24','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11203','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','25000.00','1','AN1122024011163','11220170205','SULIT','ALONA','GUILLEN','','','','','0','','0000-00-00','25000.00','2024-01-06','4CLC','004i','WITH CHECK','25000.00','015','2024-01-06 10:41:31','0','RENEWAL','015','2024-01-06 10:29:08','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11204','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','30000.00','1','AN1122024011164','11220211791','TOLENTINO','JULIANA','DELA ROSA','','','','','0','','0000-00-00','30000.00','2024-01-06','4CLC','004i','WITH CHECK','30000.00','015','2024-01-06 10:43:23','0','RENEWAL','015','2024-01-06 10:30:20','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11205','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','17000.00','1','AN1122024011165','11220232174','ROMULO','RHEA','FALGUERA','','','','','0','','0000-00-00','18000.00','2024-01-06','4CLC','004i','WITH CHECK','18000.00','015','2024-01-06 10:40:37','0','RENEWAL','015','2024-01-06 10:31:24','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11206','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','17000.00','1','AN1122024011166','11220232091','ALINA','RENELYN','SUYAT','','','','','0','','0000-00-00','17000.00','2024-01-06','4CLC','004i','WITH CHECK','17000.00','015','2024-01-06 10:36:52','0','RENEWAL','015','2024-01-06 10:32:33','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11207','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','18000.00','1','AN1122024011167','11220222053','PIGALAN','ELIODORO','NARSOLIS','','','','','0','','0000-00-00','18000.00','2024-01-06','4CLC','004i','WITH CHECK','18000.00','015','2024-01-06 10:39:40','0','RENEWAL','015','2024-01-06 10:33:49','112','2024-01-08 17:33: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 
('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','11208','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2024-01-08 17:27:38','027','15000.00','1','AN1122024011168','11220232216','SOLOMON','HILDA','ESPLANA','','','','','0','','0000-00-00','16000.00','2024-01-06','13CLC','042','WITH CHECK','16000.00','015','2024-01-06 10:54:10','0','RENEWAL','015','2024-01-06 10:52:59','112','2024-01-08 17:33:27');
