INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268231','0.00','0.00','0.00','0.00','0.00','114-59906','114','B1','LRN11420233049','2023-10-28','0','','910.00','','001B','0','114','002B','2023-11-05 17:50:17','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50: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','268232','0.00','0.00','0.00','0.00','0.00','114-59907','114','B1','LRN11420232782','2023-10-28','0','','3500.00','','001B','0','114','002B','2023-11-05 17:50:19','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50: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','268233','0.00','0.00','0.00','0.00','0.00','114-59908','114','B1','LRN11420232834','2023-10-28','0','','1300.00','','001B','0','114','002B','2023-11-05 17:50:21','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50: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','268234','0.00','0.00','0.00','0.00','0.00','114-59909','114','B1','LRN11420232692','2023-10-28','0','','500.00','','001B','0','114','002B','2023-11-05 17:50:23','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50:23');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268235','0.00','0.00','0.00','0.00','0.00','114-59910','114','B1','LRN11420232966','2023-10-28','0','','700.00','','001B','0','114','002B','2023-11-05 17:50:25','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50:25');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268236','0.00','0.00','0.00','0.00','0.00','114-59911','114','B1','LRN11420232518','2023-10-28','0','','1150.00','','001B','0','114','002B','2023-11-05 17:50:27','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50:27');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268237','0.00','0.00','0.00','0.00','0.00','114-59912','114','B1','LRN11420232936','2023-10-28','0','','1200.00','','001B','0','114','002B','2023-11-05 17:50:29','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50:29');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268238','0.00','0.00','0.00','0.00','0.00','114-59913','114','B1','LRN11420233040','2023-10-28','0','','1200.00','','001B','0','114','002B','2023-11-05 17:50:31','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50: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','268239','0.00','0.00','0.00','0.00','0.00','114-59914','114','B1','LRN11420231983','2023-10-28','0','','500.00','','001B','0','114','002B','2023-11-05 17:50:33','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50:33');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268240','0.00','0.00','0.00','0.00','0.00','114-59915','114','B1','LRN11420232715','2023-10-28','0','','1500.00','','001B','0','114','002B','2023-11-05 17:50:36','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50: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','268241','0.00','0.00','0.00','0.00','0.00','114-59916','114','B1','LRN11420233079','2023-10-28','0','','350.00','','001B','0','114','002B','2023-11-05 17:50:38','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50: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','268242','0.00','0.00','0.00','0.00','0.00','114-59917','114','B1','LRN11420233090','2023-10-28','0','','480.00','','001B','0','114','002B','2023-11-05 17:50:40','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:28:01','2023-11-05 17:50: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','268243','0.00','0.00','0.00','0.00','0.00','114-59918','114','B2','LRN11420233030','2023-10-28','0','','3300.00','','003B','0','114','002B','2023-11-05 17:52:14','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:30:52','2023-11-05 17:52: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','268244','0.00','0.00','0.00','0.00','0.00','114-59919','114','B2','LRN11420233084','2023-10-28','0','','1800.00','','003B','0','114','002B','2023-11-05 17:52:16','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:30:52','2023-11-05 17:52: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','268245','0.00','0.00','0.00','0.00','0.00','114-59920','114','B2','LRN11420232756','2023-10-28','0','','3500.00','','003B','0','114','002B','2023-11-05 17:52:18','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:30:52','2023-11-05 17:52: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','268246','0.00','0.00','0.00','0.00','0.00','114-59921','114','B2','LRN11420233087','2023-10-28','0','','400.00','','003B','0','114','002B','2023-11-05 17:52:20','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:30:52','2023-11-05 17:52: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','268247','0.00','0.00','0.00','0.00','0.00','114-59922','114','B2','LRN11420233072','2023-10-28','0','','600.00','','003B','0','114','002B','2023-11-05 17:52:22','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:30:52','2023-11-05 17:52: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','268248','0.00','0.00','0.00','0.00','0.00','114-59923','114','B2','LRN11420233088','2023-10-28','0','','600.00','','003B','0','114','002B','2023-11-05 17:52:24','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:30:52','2023-11-05 17:52: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','268249','0.00','0.00','0.00','0.00','0.00','114-59924','114','B2','LRN11420232824','2023-10-28','0','','1400.00','','003B','0','114','002B','2023-11-05 17:52:26','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:30:52','2023-11-05 17:52: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','268250','0.00','0.00','0.00','0.00','0.00','114-59925','114','B5','LRN11420233083','2023-10-28','0','','260.00','','006B','0','114','002B','2023-11-05 17:53:04','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:32:34','2023-11-05 17:53:04');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268251','0.00','0.00','0.00','0.00','0.00','114-59926','114','B5','LRN11420232720','2023-10-28','0','','200.00','','006B','0','114','002B','2023-11-05 17:53:06','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:32:34','2023-11-05 17:53: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','268252','0.00','0.00','0.00','0.00','0.00','114-59927','114','B5','LRN11420232783','2023-10-28','0','','200.00','','006B','0','114','002B','2023-11-05 17:53:08','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:32:34','2023-11-05 17:53: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','268253','0.00','0.00','0.00','0.00','0.00','114-59928','114','B6','LRN11420233053','2023-10-28','0','','500.00','','040','0','114','002B','2023-11-05 17:54:24','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:36:11','2023-11-05 17:54: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','268254','0.00','0.00','0.00','0.00','0.00','114-59929','114','B6','LRN11420232949','2023-10-28','0','','1890.00','','040','0','114','002B','2023-11-05 17:54:26','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:36:11','2023-11-05 17:54: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','268255','0.00','0.00','0.00','0.00','0.00','114-59930','114','B6','LRN11420233026','2023-10-28','0','','840.00','','040','0','114','002B','2023-11-05 17:54:28','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:36:11','2023-11-05 17:54: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','268256','0.00','0.00','0.00','0.00','0.00','114-59931','114','B5','LRN11420221837','2023-10-28','0','','500.00','','006B','0','114','002B','2023-11-05 17:53:10','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:37:49','2023-11-05 17:53: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','268257','0.00','0.00','0.00','0.00','0.00','114-59932','114','B5','LRN11420221708','2023-10-28','0','','500.00','','006B','0','114','002B','2023-11-05 17:53:12','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:37:49','2023-11-05 17:53: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','268258','0.00','0.00','0.00','0.00','0.00','114-59933','114','B5','LRN11420221147','2023-10-28','0','','200.00','','006B','0','114','002B','2023-11-05 17:53:14','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:37:49','2023-11-05 17:53: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','268259','0.00','0.00','0.00','0.00','0.00','114-59934','114','B5','LRN11420221427','2023-10-28','0','','100.00','','006B','0','114','002B','2023-11-05 17:53:16','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:37:49','2023-11-05 17:53: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','268260','0.00','0.00','0.00','0.00','0.00','114-59935','114','B7','LRN11420232582','2023-10-28','0','','100.00','','003B','0','114','002B','2023-11-05 17:55:19','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:44:13','2023-11-05 17:55: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','268261','0.00','0.00','0.00','0.00','0.00','114-59936','114','B7','LRN11420233098','2023-10-28','0','','260.00','','003B','0','114','002B','2023-11-05 17:55:21','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:44:13','2023-11-05 17:55: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','268262','0.00','0.00','0.00','0.00','0.00','114-59937','114','B7','LRN11420233099','2023-10-28','0','','260.00','','003B','0','114','002B','2023-11-05 17:55:23','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:44:13','2023-11-05 17:55:23');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268263','0.00','0.00','0.00','0.00','0.00','114-59938','114','B7','LRN11420232605','2023-10-28','0','','200.00','','003B','0','114','002B','2023-11-05 17:55:25','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:44:13','2023-11-05 17:55:25');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268264','0.00','0.00','0.00','0.00','0.00','114-59939','114','B7','LRN11420233012','2023-10-28','0','','1100.00','','003B','0','114','002B','2023-11-05 17:55:28','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:44:13','2023-11-05 17:55: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','268265','0.00','0.00','0.00','0.00','0.00','114-59940','114','B9','LRN11420233093','2023-10-28','0','','150.00','','010B','0','114','002B','2023-11-05 17:56:01','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:48:27','2023-11-05 17:56: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','268266','0.00','0.00','0.00','0.00','0.00','114-59941','114','B9','LRN11420232658','2023-10-28','0','','1400.00','','010B','0','114','002B','2023-11-05 17:56:03','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:48:27','2023-11-05 17:56: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','268267','0.00','0.00','0.00','0.00','0.00','114-59942','114','B9','LRN11420232989','2023-10-28','0','','2800.00','','010B','0','114','002B','2023-11-05 17:56:05','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:48:27','2023-11-05 17:56: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','268268','0.00','0.00','0.00','0.00','0.00','114-59943','114','B9','LRN11420232917','2023-10-28','0','','450.00','','010B','0','114','002B','2023-11-05 17:56:07','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:48:27','2023-11-05 17:56: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','268269','0.00','0.00','0.00','0.00','0.00','114-59944','114','B9','LRN11420232735','2023-10-28','0','','1000.00','','010B','0','114','002B','2023-11-05 17:56:09','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:48:27','2023-11-05 17:56: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','268270','0.00','0.00','0.00','0.00','0.00','114-59945','114','B9','LRN11420233048','2023-10-28','0','','1400.00','','010B','0','114','002B','2023-11-05 17:56:11','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:48:27','2023-11-05 17:56: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','268271','0.00','0.00','0.00','0.00','0.00','114-59946','114','B9','LRN11420232751','2023-10-28','0','','1190.00','','010B','0','114','002B','2023-11-05 17:56:13','0','0000-00-00 00:00:00','0','002B','2023-11-05 17:48:27','2023-11-05 17:56: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','268272','0.00','0.00','0.00','0.00','0.00','114-59947','114','B1','LRN11420232833','2023-10-30','0','','700.00','','001B','0','114','002B','2023-11-06 01:30:50','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:25:34','2023-11-06 01:30: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','268273','0.00','0.00','0.00','0.00','0.00','114-59948','114','B1','LRN11420232956','2023-10-30','0','','3500.00','','001B','0','114','002B','2023-11-06 01:30:52','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:25:34','2023-11-06 01:30:52');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268274','0.00','0.00','0.00','0.00','0.00','114-59949','114','B1','LRN11420232724','2023-10-30','0','','10000.00','','001B','0','114','002B','2023-11-06 01:30:56','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:25:34','2023-11-06 01:30:56');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268275','0.00','0.00','0.00','0.00','0.00','114-59950','114','B1','LRN11420232969','2023-10-30','0','','700.00','','001B','0','114','002B','2023-11-06 01:30:58','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:25:34','2023-11-06 01:30:58');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268276','0.00','0.00','0.00','0.00','0.00','114-59951','114','B1','LRN11420232728','2023-10-30','0','','2185.00','','001B','0','114','002B','2023-11-06 01:31:00','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:25:34','2023-11-06 01:31:00');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','268277','0.00','0.00','0.00','0.00','0.00','114-59952','114','B2','LRN11420233055','2023-10-30','0','','600.00','','003B','0','114','002B','2023-11-06 01:31:34','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:28:35','2023-11-06 01:31: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','268278','0.00','0.00','0.00','0.00','0.00','114-59953','114','B2','LRN11420233072','2023-10-30','0','','500.00','','003B','0','114','002B','2023-11-06 01:31:36','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:28:35','2023-11-06 01:31: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','268279','0.00','0.00','0.00','0.00','0.00','114-59954','114','B2','LRN11420233088','2023-10-30','0','','420.00','','003B','0','114','002B','2023-11-06 01:31:38','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:28:35','2023-11-06 01:31: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','268280','0.00','0.00','0.00','0.00','0.00','114-59955','114','B2','LRN11420232902','2023-10-30','0','','140.00','','003B','0','114','002B','2023-11-06 01:31:40','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:28:35','2023-11-06 01:31: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','268281','0.00','0.00','0.00','0.00','0.00','114-59956','114','B2','LRN11420232815','2023-10-30','0','','300.00','','003B','0','114','002B','2023-11-06 01:31:42','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:28:35','2023-11-06 01:31: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','268282','0.00','0.00','0.00','0.00','0.00','114-59957','114','B2','LRN11420232901','2023-10-30','0','','140.00','','003B','0','114','002B','2023-11-06 01:31:44','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:28:35','2023-11-06 01:31: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','268283','0.00','0.00','0.00','0.00','0.00','114-59958','114','B2','LRN11420233000','2023-10-30','0','','170.00','','003B','0','114','002B','2023-11-06 01:31:46','0','0000-00-00 00:00:00','0','002B','2023-11-05 18:28:35','2023-11-06 01:31: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','268284','0.00','0.00','0.00','0.00','0.00','114-59959','114','B5','LRN11420232961','2023-10-30','0','','200.00','','006B','0','114','002B','2023-11-06 01:32:39','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268285','0.00','0.00','0.00','0.00','0.00','114-59960','114','B5','LRN11420231982','2023-10-30','0','','50.00','','006B','0','114','002B','2023-11-06 01:32:43','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268286','0.00','0.00','0.00','0.00','0.00','114-59961','114','B5','LRN11420233043','2023-10-30','0','','140.00','','006B','0','114','002B','2023-11-06 01:32:45','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268287','0.00','0.00','0.00','0.00','0.00','114-59962','114','B5','LRN11420232786','2023-10-30','0','','3000.00','','006B','0','114','002B','2023-11-06 01:32:47','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268288','0.00','0.00','0.00','0.00','0.00','114-59963','114','B5','LRN11420232860','2023-10-30','0','','850.00','','006B','0','114','002B','2023-11-06 01:32:51','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268289','0.00','0.00','0.00','0.00','0.00','114-59964','114','B5','LRN11420232051','2023-10-30','0','','100.00','','006B','0','114','002B','2023-11-06 01:32:53','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268290','0.00','0.00','0.00','0.00','0.00','114-59965','114','B5','LRN11420232878','2023-10-30','0','','150.00','','006B','0','114','002B','2023-11-06 01:32:55','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268291','0.00','0.00','0.00','0.00','0.00','114-59966','114','B5','LRN11420232400','2023-10-30','0','','100.00','','006B','0','114','002B','2023-11-06 01:32:57','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:32: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','268292','0.00','0.00','0.00','0.00','0.00','114-59967','114','B5','LRN11420232840','2023-10-30','0','','1750.00','','006B','0','114','002B','2023-11-06 01:33:01','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:33: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','268293','0.00','0.00','0.00','0.00','0.00','114-59968','114','B5','LRN11420232802','2023-10-30','0','','168.00','','006B','0','114','002B','2023-11-06 01:33:03','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:05:08','2023-11-06 01:33: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','268294','0.00','0.00','0.00','29.12','152.88','114-59969','114','B5','LRN11420233083','2023-10-30','0','','182.00','','006B','0','114','002B','2023-11-06 01:32:41','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:08:38','2023-11-06 01:32: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','268295','0.00','0.00','0.00','54.40','285.60','114-59970','114','B1','LRN11420232971','2023-10-30','0','','340.00','','006B','0','114','002B','2023-11-06 01:30:54','0','0000-00-00 00:00:00','0','002B','2023-11-05 19:09:56','2023-11-06 01:30:54');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B1','Undeposited','2023-10-28','0','0000-00-00','13290.00','0.00','0.00','','ACTIVE','002B','2023-11-05 17:57:16','2023-11-05 17:57:16');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B2','Undeposited','2023-10-28','0','0000-00-00','11600.00','0.00','0.00','','ACTIVE','002B','2023-11-05 17:57:48','2023-11-05 17:57:48');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B5','Undeposited','2023-10-28','0','0000-00-00','1960.00','0.00','0.00','','ACTIVE','002B','2023-11-05 17:58:37','2023-11-05 17:58:37');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B6','Undeposited','2023-10-28','0','0000-00-00','3230.00','0.00','0.00','','ACTIVE','002B','2023-11-05 18:11:07','2023-11-05 18:11:07');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B7','Undeposited','2023-10-28','0','0000-00-00','1920.00','0.00','0.00','','ACTIVE','002B','2023-11-05 18:12:17','2023-11-05 18:12:17');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B9','Undeposited','2023-10-28','0','0000-00-00','8390.00','0.00','0.00','','ACTIVE','002B','2023-11-05 18:13:07','2023-11-05 18:13:07');
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-06-20 10:00:34',sales_Timestamp='2023-11-05 18:15:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='1150.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-06-20 18:01:47',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231221',sales_AssignTo='',sales_PNumber='LRN11420232518',sales_Amt='10000.00',sales_Area='B1',sales_Cycle='2',sales_Released='2023-06-19',sales_Maturity='2023-09-27',sales_BegBalance='10000.00',sales_LPD='2023-10-28' WHERE sales_PNumber = 'LRN11420232518' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-07-19 14:35:29',sales_Timestamp='2023-11-05 18:15:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='1400.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-07-19 14:37:09',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210959',sales_AssignTo='',sales_PNumber='LRN11420232658',sales_Amt='10000.00',sales_Area='B9',sales_Cycle='4',sales_Released='2023-07-19',sales_Maturity='2023-10-27',sales_BegBalance='10000.00',sales_LPD='2023-10-28' WHERE sales_PNumber = 'LRN11420232658' ; 
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='200.00',sales_amortization='70.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='7000.00',sales_interest_amt='0.00',sales_prin_amt='7000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-07-27 16:13:26',sales_Timestamp='2023-11-05 18:15:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6800.00',sales_PaymentCutoff='500.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-07-27 20:06:25',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231421',sales_AssignTo='',sales_PNumber='LRN11420232692',sales_Amt='7000.00',sales_Area='B1',sales_Cycle='1',sales_Released='2023-07-27',sales_Maturity='2023-11-04',sales_BegBalance='7000.00',sales_LPD='2023-10-28' WHERE sales_PNumber = 'LRN11420232692' ; 
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='12200.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-10-11 16:10:06',sales_Timestamp='2023-11-05 18:15:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2800.00',sales_PaymentCutoff='2200.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-10-11 16:19:46',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231335',sales_AssignTo='',sales_PNumber='LRN11420233012',sales_Amt='15000.00',sales_Area='B7',sales_Cycle='3',sales_Released='2023-10-11',sales_Maturity='2024-01-19',sales_BegBalance='15000.00',sales_LPD='2023-10-28' WHERE sales_PNumber = 'LRN11420233012' ;