INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','325251','0.00','0.00','0.00','0.00','0.00','112-126847','112','11CLC','LRN11220231842','2024-05-04','0','','300.00','','006','0','112','015','2024-05-04 14:28:14','0','0000-00-00 00:00:00','0','015','2024-05-04 14:21:55','2024-05-04 14:28: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','325252','0.00','0.00','0.00','0.00','0.00','112-126848','112','4CLC','LRN11220240211','2024-05-04','0','','1440.00','','004i','0','112','015','2024-05-04 14:29:35','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325253','0.00','0.00','0.00','0.00','0.00','112-126849','112','4CLC','LRN11220240207','2024-05-04','0','','252.00','','004i','0','112','015','2024-05-04 14:29:37','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325254','0.00','0.00','0.00','0.00','0.00','112-126850','112','4CLC','LRN11220240125','2024-05-04','0','','200.00','','004i','0','112','015','2024-05-04 14:29:39','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325255','0.00','0.00','0.00','0.00','0.00','112-126851','112','4CLC','LRN11220240111','2024-05-04','0','','350.00','','004i','0','112','015','2024-05-04 14:29:41','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325256','0.00','0.00','0.00','0.00','0.00','112-126852','112','4CLC','LRN11220240151','2024-05-04','0','','1000.00','','004i','0','112','015','2024-05-04 14:29:43','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325257','0.00','0.00','0.00','0.00','0.00','112-126853','112','4CLC','LRN11220240174','2024-05-04','0','','200.00','','004i','0','112','015','2024-05-04 14:29:45','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325258','0.00','0.00','0.00','0.00','0.00','112-126854','112','4CLC','LRN11220240129','2024-05-04','0','','800.00','','004i','0','112','015','2024-05-04 14:29:48','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325259','0.00','0.00','0.00','0.00','0.00','112-126855','112','4CLC','LRN11220240308','2024-05-04','0','','300.00','','004i','0','112','015','2024-05-04 14:29:50','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325260','0.00','0.00','0.00','0.00','0.00','112-126856','112','4CLC','LRN11220240233','2024-05-04','0','','250.00','','004i','0','112','015','2024-05-04 14:29:52','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325261','0.00','0.00','0.00','0.00','0.00','112-126857','112','4CLC','LRN11220240090','2024-05-04','0','','600.00','','004i','0','112','015','2024-05-04 14:29:54','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29:54');
INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES 
('','','0000-00-00','','0','0.00','0','325262','0.00','0.00','0.00','0.00','0.00','112-126858','112','4CLC','LRN11220240093','2024-05-04','0','','270.00','','004i','0','112','015','2024-05-04 14:29:56','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325263','0.00','0.00','0.00','0.00','0.00','112-126859','112','4CLC','LRN11220240246','2024-05-04','0','','210.00','','004i','0','112','015','2024-05-04 14:29:58','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:29: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','325264','0.00','0.00','0.00','0.00','0.00','112-126860','112','4CLC','LRN11220240291','2024-05-04','0','','200.00','','004i','0','112','015','2024-05-04 14:30:00','0','0000-00-00 00:00:00','0','015','2024-05-04 14:27:04','2024-05-04 14:30: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','325265','0.00','0.00','0.00','0.00','0.00','112-126861','112','13CLC','LRN11220240123','2024-05-04','0','','500.00','','006','0','112','015','2024-05-04 14:38:06','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325266','0.00','0.00','0.00','0.00','0.00','112-126862','112','13CLC','LRN11220240114','2024-05-04','0','','150.00','','006','0','112','015','2024-05-04 14:38:08','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325267','0.00','0.00','0.00','0.00','0.00','112-126863','112','13CLC','LRN11220240160','2024-05-04','0','','100.00','','006','0','112','015','2024-05-04 14:38:10','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325268','0.00','0.00','0.00','0.00','0.00','112-126864','112','13CLC','LRN11220240287','2024-05-04','0','','200.00','','006','0','112','015','2024-05-04 14:38:12','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325269','0.00','0.00','0.00','0.00','0.00','112-126865','112','13CLC','LRN11220240272','2024-05-04','0','','100.00','','006','0','112','015','2024-05-04 14:38:14','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325270','0.00','0.00','0.00','0.00','0.00','112-126866','112','13CLC','LRN11220240220','2024-05-04','0','','100.00','','006','0','112','015','2024-05-04 14:38:16','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325271','0.00','0.00','0.00','0.00','0.00','112-126867','112','13CLC','LRN11220240002','2024-05-04','0','','100.00','','006','0','112','015','2024-05-04 14:38:18','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325272','0.00','0.00','0.00','0.00','0.00','112-126868','112','13CLC','LRN11220240280','2024-05-04','0','','200.00','','006','0','112','015','2024-05-04 14:38:20','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 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','325273','0.00','0.00','0.00','0.00','0.00','112-126869','112','13CLC','LRN11220240210','2024-05-04','0','','200.00','','006','0','112','015','2024-05-04 14:38:23','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325274','0.00','0.00','0.00','0.00','0.00','112-126870','112','13CLC','LRN11220240139','2024-05-04','0','','50.00','','006','0','112','015','2024-05-04 14:38:25','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325275','0.00','0.00','0.00','0.00','0.00','112-126871','112','13CLC','LRN11220240042','2024-05-04','0','','500.00','','006','0','112','015','2024-05-04 14:38:27','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325276','0.00','0.00','0.00','0.00','0.00','112-126872','112','13CLC','LRN11220240252','2024-05-04','0','','150.00','','006','0','112','015','2024-05-04 14:38:29','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325277','0.00','0.00','0.00','0.00','0.00','112-126873','112','13CLC','LRN11220240318','2024-05-04','0','','70.00','','006','0','112','015','2024-05-04 14:38:31','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325278','0.00','0.00','0.00','0.00','0.00','112-126874','112','13CLC','LRN11220232384','2024-05-04','0','','250.00','','006','0','112','015','2024-05-04 14:38:33','0','0000-00-00 00:00:00','0','015','2024-05-04 14:36:31','2024-05-04 14:38: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','325279','0.00','0.00','0.00','0.00','0.00','112-126875','112','12CLC','LRN11220240198','2024-05-04','0','','240.00','','004i','0','112','015','2024-05-04 15:01:42','0','0000-00-00 00:00:00','0','015','2024-05-04 14:44:31','2024-05-04 15:01: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','325280','0.00','0.00','0.00','0.00','0.00','112-126876','112','12CLC','LRN11220240243','2024-05-04','0','','120.00','','004i','0','112','015','2024-05-04 15:01:44','0','0000-00-00 00:00:00','0','015','2024-05-04 14:44:31','2024-05-04 15:01: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','325281','0.00','0.00','0.00','0.00','0.00','112-126877','112','12CLC','LRN11220240201','2024-05-04','0','','150.00','','004i','0','112','015','2024-05-04 15:01:46','0','0000-00-00 00:00:00','0','015','2024-05-04 14:44:31','2024-05-04 15:01: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','325282','0.00','0.00','0.00','0.00','0.00','112-126878','112','2CLC','LRN11220240271','2024-05-04','0','','300.00','','002','0','112','015','2024-05-04 15:02:26','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325283','0.00','0.00','0.00','0.00','0.00','112-126879','112','2CLC','LRN11220240286','2024-05-04','0','','112.00','','002','0','112','015','2024-05-04 15:02:28','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325284','0.00','0.00','0.00','0.00','0.00','112-126880','112','2CLC','LRN11220240172','2024-05-04','0','','300.00','','002','0','112','015','2024-05-04 15:02:30','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325285','0.00','0.00','0.00','0.00','0.00','112-126881','112','2CLC','LRN11220240137','2024-05-04','0','','250.00','','002','0','112','015','2024-05-04 15:02:32','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325286','0.00','0.00','0.00','0.00','0.00','112-126882','112','2CLC','LRN11220240074','2024-05-04','0','','1500.00','','002','0','112','015','2024-05-04 15:02:34','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325287','0.00','0.00','0.00','0.00','0.00','112-126883','112','2CLC','LRN11220240317','2024-05-04','0','','150.00','','002','0','112','015','2024-05-04 15:02:36','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325288','0.00','0.00','0.00','0.00','0.00','112-126884','112','2CLC','LRN11220240282','2024-05-04','0','','200.00','','002','0','112','015','2024-05-04 15:02:38','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325289','0.00','0.00','0.00','0.00','0.00','112-126885','112','2CLC','LRN11220240281','2024-05-04','0','','200.00','','002','0','112','015','2024-05-04 15:02:40','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325290','0.00','0.00','0.00','0.00','0.00','112-126886','112','2CLC','LRN11220240261','2024-05-04','0','','280.00','','002','0','112','015','2024-05-04 15:02:42','0','0000-00-00 00:00:00','0','015','2024-05-04 14:46:42','2024-05-04 15:02: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','325291','0.00','0.00','0.00','0.00','0.00','112-126887','112','11CLC','LRN11220232074','2024-05-04','0','','100.00','','006','0','112','015','2024-05-04 15:15:05','0','0000-00-00 00:00:00','0','015','2024-05-04 15:14:00','2024-05-04 15:15: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','325292','0.00','0.00','0.00','0.00','0.00','112-126888','112','11CLC','LRN11220240331','2024-05-04','0','','80.00','','006','0','112','015','2024-05-04 15:15:07','0','0000-00-00 00:00:00','0','015','2024-05-04 15:14:00','2024-05-04 15:15: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','325293','0.00','0.00','0.00','0.00','0.00','112-126889','112','11CLC','LRN11220240309','2024-05-04','0','','420.00','','006','0','112','015','2024-05-04 15:15:09','0','0000-00-00 00:00:00','0','015','2024-05-04 15:14:00','2024-05-04 15:15: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','325294','0.00','0.00','0.00','0.00','0.00','112-126890','112','11CLC','LRN11220240289','2024-05-04','0','','460.00','','006','0','112','015','2024-05-04 15:15:11','0','0000-00-00 00:00:00','0','015','2024-05-04 15:14:00','2024-05-04 15:15: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','325295','0.00','0.00','0.00','0.00','0.00','112-126891','112','11CLC','LRN11220240330','2024-05-04','0','','115.00','','006','0','112','015','2024-05-04 15:15:13','0','0000-00-00 00:00:00','0','015','2024-05-04 15:14:00','2024-05-04 15:15: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','325296','0.00','0.00','0.00','0.00','0.00','112-126892','112','12CLC','LRN11220240185','2024-05-04','0','','150.00','','002','0','112','015','2024-05-04 15:34:43','0','0000-00-00 00:00:00','0','015','2024-05-04 15:33:41','2024-05-04 15:34: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','325297','0.00','0.00','0.00','0.00','0.00','112-126893','112','3CLC','LRN11220240230','2024-05-04','0','','1000.00','','006','0','112','015','2024-05-04 15:46:18','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325298','0.00','0.00','0.00','0.00','0.00','112-126894','112','3CLC','LRN11220240021','2024-05-04','0','','250.00','','006','0','112','015','2024-05-04 15:46:20','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325299','0.00','0.00','0.00','0.00','0.00','112-126895','112','3CLC','LRN11220240076','2024-05-04','0','','500.00','','006','0','112','015','2024-05-04 15:46:22','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325300','0.00','0.00','0.00','0.00','0.00','112-126896','112','3CLC','LRN11220240258','2024-05-04','0','','420.00','','006','0','112','015','2024-05-04 15:46:24','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325301','0.00','0.00','0.00','0.00','0.00','112-126897','112','3CLC','LRN11220240156','2024-05-04','0','','3500.00','','006','0','112','015','2024-05-04 15:46:26','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325302','0.00','0.00','0.00','0.00','0.00','112-126898','112','3CLC','LRN11220240089','2024-05-04','0','','100.00','','006','0','112','015','2024-05-04 15:46:28','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325303','0.00','0.00','0.00','0.00','0.00','112-126899','112','3CLC','LRN11220240105','2024-05-04','0','','182.00','','006','0','112','015','2024-05-04 15:46:30','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325304','0.00','0.00','0.00','0.00','0.00','112-126900','112','3CLC','LRN11220240118','2024-05-04','0','','300.00','','006','0','112','015','2024-05-04 15:46:32','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325305','0.00','0.00','0.00','0.00','0.00','112-126901','112','3CLC','LRN11220240173','2024-05-04','0','','120.00','','006','0','112','015','2024-05-04 15:46:34','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325306','0.00','0.00','0.00','0.00','0.00','112-126902','112','3CLC','LRN11220232394','2024-05-04','0','','100.00','','006','0','112','015','2024-05-04 15:46:37','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325307','0.00','0.00','0.00','0.00','0.00','112-126903','112','3CLC','LRN11220240254','2024-05-04','0','','300.00','','006','0','112','015','2024-05-04 15:46:39','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325308','0.00','0.00','0.00','0.00','0.00','112-126904','112','3CLC','LRN11220240329','2024-05-04','0','','300.00','','006','0','112','015','2024-05-04 15:46:41','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325309','0.00','0.00','0.00','0.00','0.00','112-126905','112','3CLC','LRN11220240166','2024-05-04','0','','504.00','','006','0','112','015','2024-05-04 15:46:43','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325310','0.00','0.00','0.00','0.00','0.00','112-126906','112','3CLC','LRN11220240191','2024-05-04','0','','200.00','','006','0','112','015','2024-05-04 15:46:45','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325311','0.00','0.00','0.00','0.00','0.00','112-126907','112','3CLC','LRN11220240147','2024-05-04','0','','200.00','','006','0','112','015','2024-05-04 15:46:47','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325312','0.00','0.00','0.00','0.00','0.00','112-126908','112','3CLC','LRN11220240186','2024-05-04','0','','150.00','','006','0','112','015','2024-05-04 15:46:49','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325313','0.00','0.00','0.00','0.00','0.00','112-126909','112','3CLC','LRN11220240098','2024-05-04','0','','1050.00','','006','0','112','015','2024-05-04 15:46:51','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325314','0.00','0.00','0.00','0.00','0.00','112-126910','112','3CLC','LRN11220240293','2024-05-04','0','','500.00','','006','0','112','015','2024-05-04 15:46:53','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46: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','325315','0.00','0.00','0.00','0.00','0.00','112-126911','112','3CLC','LRN11220240073','2024-05-04','0','','150.00','','006','0','112','015','2024-05-04 15:46:55','0','0000-00-00 00:00:00','0','015','2024-05-04 15:45:11','2024-05-04 15:46:55');
UPDATE cust_information SET cust_ho_date='',cust_ho_edit='',cust_picture='0000-00-00 00:00:00',cust_Code='11220242334', cust_Gender='MALE', cust_CivilStatus='SINGLE', cust_Cycle='1', cust_Status='ACTIVE', cust_encoded='015', cust_encodeDate='2024-04-27 13:29:37', cust_timestamp='2024-05-04 10:39:48', cust_LastName='BUNDALIAN',cust_FirstName='RENELL',cust_MiddleName='ALACBAY',cust_Suffix='',cust_MaidenName='',cust_NickName='RENELL',cust_Area='11CLC',cust_Nationality='FILIPINO', cust_Bday= '1994-04-23', cust_BirthPlace= 'MALABON CITY' WHERE cust_ID = '5608' and cust_Branch = '112'; 
INSERT INTO `cust_savings` (ho_date,ho_edit,saveid,branch,accountno,typetrans,datetrans,amttrans,remarks,remarks1,empid,createdBy,`timestamp`) VALUES 
('','','13987','112','11220242334','insurance','2024-05-04','0.00','LRN11220240331','','034','015','2024-05-06 08:00:39');
UPDATE fund_check_status SET check_Status='Released',check_Reason='0',check_CanceledDate='0000-00-00 00:00:00',check_Encoded='027',check_timestamp='2024-05-04 10:39:48' WHERE check_Branch = '112' and check_ID_Unique = 'AN11220240415242004815042'; 
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-05-04','166','2024-05-04','300.00','0.00','0.00','','ACTIVE','015','2024-05-04 14:30:33','2024-05-04 14:30:33');
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-05-04','166','2024-05-04','6072.00','0.00','0.00','','ACTIVE','015','2024-05-04 14:31:05','2024-05-04 14:31:05');
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-05-04','166','2024-05-04','2670.00','0.00','0.00','','ACTIVE','015','2024-05-04 14:39:27','2024-05-04 14:39:27');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','12CLC','Deposited','2024-05-04','166','2024-05-04','510.00','0.00','0.00','','ACTIVE','015','2024-05-04 15:06:32','2024-05-04 15:06:32');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','2CLC','Deposited','2024-05-04','166','2024-05-04','3292.00','0.00','0.00','','ACTIVE','015','2024-05-04 15:07:01','2024-05-04 15:07: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','11CLC','Deposited','2024-05-04','166','2024-05-04','1175.00','0.00','0.00','','ACTIVE','015','2024-05-04 15:20:34','2024-05-04 15:20:34');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','12CLC','Deposited','2024-05-04','166','2024-05-04','150.00','0.00','0.00','','ACTIVE','015','2024-05-04 15:32:39','2024-05-04 15:32:39');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('112','3CLC','Deposited','2024-05-04','166','2024-05-04','9826.00','0.00','0.00','','ACTIVE','015','2024-05-04 15:48:18','2024-05-04 15:48:18');
INSERT INTO `fund_sales` (sales_ho_date,sales_ho_edit,overdue_asofdate,overdue_amount,sales_delay_asof,sales_no_delay,sales_restructured_tag,sales_transfer,sales_balance,sales_amortization,pdi_amount,penalty_amount,penalty_percent,sales_csrf_no,sales_mode_payment,sales_interest_bal,sales_prin_bal,sales_interest_amt,sales_prin_amt,sales_other_charger1,sales_other_charges,sales_penalty,sales_other_charger1_bal,sales_other_charges_bal,sales_penalty_bal,sales_product,sales_terms,sales_App_Number,sales_Branch,sales_AccountNo,sales_AssignTo,sales_PNumber,sales_Amt,sales_Area,sales_Cycle,sales_Released,sales_Maturity,sales_BegBalance,sales_LPD,sales_Due,sales_Overdue,sales_Payment,sales_PaymentCutoff,sales_Status,sales_ValidatedBy,sales_ValidatedDate,sales_IncentiveClaim,sales_Void,sales_PostedBy,sales_PostedDate,sales_Timestamp) VALUES 
('','','','0.00','','0','0','','7608.00','80.00','0.00','0.00','0.00','12493','Daily','0.00','8000.00','0.00','8000.00','0.00','0.00','0.00','0.00','0.00','0.00','1','100','AN1122024041524','112','11220242334','034','LRN11220240331','8000.00','11CLC','1','2024-05-04','2024-08-12','8000.00','2024-05-08','0.00','0.00','504.00','112.00','ACTIVE','015','2024-05-04 10:41:03','0000-00-00','0','015','2024-05-04 10:39:48','2024-05-08 15:46:46');
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='5330.00',sales_amortization='180.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='18000.00',sales_interest_amt='0.00',sales_prin_amt='18000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2022-08-11 15:06:25',sales_Timestamp='2024-05-04 08:35:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12670.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2022-08-11 15:07:07',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221925',sales_AssignTo='006',sales_PNumber='LRN11220221029',sales_Amt='18000.00',sales_Area='3CLC',sales_Cycle='2',sales_Released='2022-08-11',sales_Maturity='2022-11-19',sales_BegBalance='18000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220221029' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='5200.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-17 13:38:05',sales_Timestamp='2024-05-04 08:35:23',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='6800.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-17 13:42:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232160',sales_AssignTo='034',sales_PNumber='LRN11220232077',sales_Amt='12000.00',sales_Area='11CLC',sales_Cycle='2',sales_Released='2023-08-17',sales_Maturity='2023-11-25',sales_BegBalance='12000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220232077' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='4930.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-01-23 13:30:09',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5070.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-01-23 13:33:29',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232266',sales_AssignTo='042',sales_PNumber='LRN11220240040',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2024-01-23',sales_Maturity='2024-05-02',sales_BegBalance='10000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240040' ; 
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='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='2024-01-30 10:59:44',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='27000.00',sales_PaymentCutoff='2780.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-01-30 11:03:15',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220201773',sales_AssignTo='042',sales_PNumber='LRN11220240068',sales_Amt='27000.00',sales_Area='13CLC',sales_Cycle='14',sales_Released='2024-01-30',sales_Maturity='2024-05-09',sales_BegBalance='27000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240068' ; 
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='180.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='18000.00',sales_interest_amt='0.00',sales_prin_amt='18000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-02-12 13:03:10',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='18000.00',sales_PaymentCutoff='3300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-02-12 13:05:24',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232177',sales_AssignTo='002',sales_PNumber='LRN11220240092',sales_Amt='18000.00',sales_Area='2CLC',sales_Cycle='4',sales_Released='2024-02-12',sales_Maturity='2024-05-22',sales_BegBalance='18000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240092' ; 
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='23500.00',sales_amortization='500.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='50000.00',sales_interest_amt='0.00',sales_prin_amt='50000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-03-13 11:17:50',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='26500.00',sales_PaymentCutoff='3500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-13 11:20:49',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170360',sales_AssignTo='006',sales_PNumber='LRN11220240176',sales_Amt='50000.00',sales_Area='3CLC',sales_Cycle='16',sales_Released='2024-03-13',sales_Maturity='2024-06-21',sales_BegBalance='50000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240176' ; 
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='45900.00',sales_amortization='900.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='90000.00',sales_interest_amt='0.00',sales_prin_amt='90000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-03-18 14:31:06',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='44100.00',sales_PaymentCutoff='12600.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-18 14:33:13',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211850',sales_AssignTo='004i',sales_PNumber='LRN11220240188',sales_Amt='90000.00',sales_Area='4CLC',sales_Cycle='8',sales_Released='2024-03-18',sales_Maturity='2024-06-26',sales_BegBalance='90000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240188' ; 
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='17150.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='2024-03-22 11:19:16',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='7850.00',sales_PaymentCutoff='1050.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-22 11:21:14',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221958',sales_AssignTo='002',sales_PNumber='LRN11220240205',sales_Amt='25000.00',sales_Area='2CLC',sales_Cycle='10',sales_Released='2024-03-22',sales_Maturity='2024-06-30',sales_BegBalance='25000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240205' ; 
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='7740.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-03-27 11:30:58',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2260.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-03-27 11:35:24',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220242302',sales_AssignTo='037',sales_PNumber='LRN11220240221',sales_Amt='10000.00',sales_Area='12CLC',sales_Cycle='1',sales_Released='2024-03-27',sales_Maturity='2024-07-05',sales_BegBalance='10000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240221' ; 
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='10775.00',sales_amortization='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-04-08 13:31:06',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='4225.00',sales_PaymentCutoff='550.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-08 13:33:02',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191618',sales_AssignTo='006',sales_PNumber='LRN11220240240',sales_Amt='15000.00',sales_Area='3CLC',sales_Cycle='11',sales_Released='2024-04-08',sales_Maturity='2024-07-17',sales_BegBalance='15000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240240' ; 
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='16400.00',sales_amortization='190.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='19000.00',sales_interest_amt='0.00',sales_prin_amt='19000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2024-04-25 11:06:34',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2600.00',sales_PaymentCutoff='1300.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-04-25 11:07:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232230',sales_AssignTo='042',sales_PNumber='LRN11220240304',sales_Amt='19000.00',sales_Area='13CLC',sales_Cycle='5',sales_Released='2024-04-25',sales_Maturity='2024-08-03',sales_BegBalance='19000.00',sales_LPD='2024-05-03' WHERE sales_PNumber = 'LRN11220240304' ; 
UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='25000.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='2024-05-03 12:00:58',sales_Timestamp='2024-05-04 08:35:24',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='0.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2024-05-03 12:03:03',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211872',sales_AssignTo='006',sales_PNumber='LRN11220240328',sales_Amt='25000.00',sales_Area='3CLC',sales_Cycle='10',sales_Released='2024-05-03',sales_Maturity='2024-08-11',sales_BegBalance='25000.00',sales_LPD='0000-00-00' WHERE sales_PNumber = 'LRN11220240328' ; 
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','8000.00','0.00','0.00','0.00','0.00','0.00','1217870','LRN11220240331','112','0','0','','0.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7920.00','0.00','0.00','0.00','0.00','80.00','1217871','LRN11220240331','112','1','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7840.00','0.00','0.00','0.00','0.00','80.00','1217872','LRN11220240331','112','2','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7760.00','0.00','0.00','0.00','0.00','80.00','1217873','LRN11220240331','112','3','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7680.00','0.00','0.00','0.00','0.00','80.00','1217874','LRN11220240331','112','4','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7600.00','0.00','0.00','0.00','0.00','80.00','1217875','LRN11220240331','112','5','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7520.00','0.00','0.00','0.00','0.00','80.00','1217876','LRN11220240331','112','6','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7440.00','0.00','0.00','0.00','0.00','80.00','1217877','LRN11220240331','112','7','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7360.00','0.00','0.00','0.00','0.00','80.00','1217878','LRN11220240331','112','8','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7280.00','0.00','0.00','0.00','0.00','80.00','1217879','LRN11220240331','112','9','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7200.00','0.00','0.00','0.00','0.00','80.00','1217880','LRN11220240331','112','10','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7120.00','0.00','0.00','0.00','0.00','80.00','1217881','LRN11220240331','112','11','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','7040.00','0.00','0.00','0.00','0.00','80.00','1217882','LRN11220240331','112','12','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6960.00','0.00','0.00','0.00','0.00','80.00','1217883','LRN11220240331','112','13','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6880.00','0.00','0.00','0.00','0.00','80.00','1217884','LRN11220240331','112','14','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6800.00','0.00','0.00','0.00','0.00','80.00','1217885','LRN11220240331','112','15','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6720.00','0.00','0.00','0.00','0.00','80.00','1217886','LRN11220240331','112','16','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6640.00','0.00','0.00','0.00','0.00','80.00','1217887','LRN11220240331','112','17','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6560.00','0.00','0.00','0.00','0.00','80.00','1217888','LRN11220240331','112','18','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6480.00','0.00','0.00','0.00','0.00','80.00','1217889','LRN11220240331','112','19','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6400.00','0.00','0.00','0.00','0.00','80.00','1217890','LRN11220240331','112','20','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6320.00','0.00','0.00','0.00','0.00','80.00','1217891','LRN11220240331','112','21','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6240.00','0.00','0.00','0.00','0.00','80.00','1217892','LRN11220240331','112','22','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6160.00','0.00','0.00','0.00','0.00','80.00','1217893','LRN11220240331','112','23','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6080.00','0.00','0.00','0.00','0.00','80.00','1217894','LRN11220240331','112','24','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','6000.00','0.00','0.00','0.00','0.00','80.00','1217895','LRN11220240331','112','25','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5920.00','0.00','0.00','0.00','0.00','80.00','1217896','LRN11220240331','112','26','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5840.00','0.00','0.00','0.00','0.00','80.00','1217897','LRN11220240331','112','27','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5760.00','0.00','0.00','0.00','0.00','80.00','1217898','LRN11220240331','112','28','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5680.00','0.00','0.00','0.00','0.00','80.00','1217899','LRN11220240331','112','29','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5600.00','0.00','0.00','0.00','0.00','80.00','1217900','LRN11220240331','112','30','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5520.00','0.00','0.00','0.00','0.00','80.00','1217901','LRN11220240331','112','31','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5440.00','0.00','0.00','0.00','0.00','80.00','1217902','LRN11220240331','112','32','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5360.00','0.00','0.00','0.00','0.00','80.00','1217903','LRN11220240331','112','33','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5280.00','0.00','0.00','0.00','0.00','80.00','1217904','LRN11220240331','112','34','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5200.00','0.00','0.00','0.00','0.00','80.00','1217905','LRN11220240331','112','35','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5120.00','0.00','0.00','0.00','0.00','80.00','1217906','LRN11220240331','112','36','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','5040.00','0.00','0.00','0.00','0.00','80.00','1217907','LRN11220240331','112','37','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4960.00','0.00','0.00','0.00','0.00','80.00','1217908','LRN11220240331','112','38','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4880.00','0.00','0.00','0.00','0.00','80.00','1217909','LRN11220240331','112','39','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4800.00','0.00','0.00','0.00','0.00','80.00','1217910','LRN11220240331','112','40','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4720.00','0.00','0.00','0.00','0.00','80.00','1217911','LRN11220240331','112','41','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4640.00','0.00','0.00','0.00','0.00','80.00','1217912','LRN11220240331','112','42','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4560.00','0.00','0.00','0.00','0.00','80.00','1217913','LRN11220240331','112','43','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4480.00','0.00','0.00','0.00','0.00','80.00','1217914','LRN11220240331','112','44','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4400.00','0.00','0.00','0.00','0.00','80.00','1217915','LRN11220240331','112','45','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4320.00','0.00','0.00','0.00','0.00','80.00','1217916','LRN11220240331','112','46','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4240.00','0.00','0.00','0.00','0.00','80.00','1217917','LRN11220240331','112','47','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4160.00','0.00','0.00','0.00','0.00','80.00','1217918','LRN11220240331','112','48','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4080.00','0.00','0.00','0.00','0.00','80.00','1217919','LRN11220240331','112','49','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','4000.00','0.00','0.00','0.00','0.00','80.00','1217920','LRN11220240331','112','50','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3920.00','0.00','0.00','0.00','0.00','80.00','1217921','LRN11220240331','112','51','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3840.00','0.00','0.00','0.00','0.00','80.00','1217922','LRN11220240331','112','52','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3760.00','0.00','0.00','0.00','0.00','80.00','1217923','LRN11220240331','112','53','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3680.00','0.00','0.00','0.00','0.00','80.00','1217924','LRN11220240331','112','54','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3600.00','0.00','0.00','0.00','0.00','80.00','1217925','LRN11220240331','112','55','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3520.00','0.00','0.00','0.00','0.00','80.00','1217926','LRN11220240331','112','56','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3440.00','0.00','0.00','0.00','0.00','80.00','1217927','LRN11220240331','112','57','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3360.00','0.00','0.00','0.00','0.00','80.00','1217928','LRN11220240331','112','58','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3280.00','0.00','0.00','0.00','0.00','80.00','1217929','LRN11220240331','112','59','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3200.00','0.00','0.00','0.00','0.00','80.00','1217930','LRN11220240331','112','60','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3120.00','0.00','0.00','0.00','0.00','80.00','1217931','LRN11220240331','112','61','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','3040.00','0.00','0.00','0.00','0.00','80.00','1217932','LRN11220240331','112','62','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2960.00','0.00','0.00','0.00','0.00','80.00','1217933','LRN11220240331','112','63','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2880.00','0.00','0.00','0.00','0.00','80.00','1217934','LRN11220240331','112','64','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2800.00','0.00','0.00','0.00','0.00','80.00','1217935','LRN11220240331','112','65','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2720.00','0.00','0.00','0.00','0.00','80.00','1217936','LRN11220240331','112','66','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2640.00','0.00','0.00','0.00','0.00','80.00','1217937','LRN11220240331','112','67','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2560.00','0.00','0.00','0.00','0.00','80.00','1217938','LRN11220240331','112','68','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2480.00','0.00','0.00','0.00','0.00','80.00','1217939','LRN11220240331','112','69','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2400.00','0.00','0.00','0.00','0.00','80.00','1217940','LRN11220240331','112','70','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2320.00','0.00','0.00','0.00','0.00','80.00','1217941','LRN11220240331','112','71','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2240.00','0.00','0.00','0.00','0.00','80.00','1217942','LRN11220240331','112','72','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2160.00','0.00','0.00','0.00','0.00','80.00','1217943','LRN11220240331','112','73','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2080.00','0.00','0.00','0.00','0.00','80.00','1217944','LRN11220240331','112','74','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','2000.00','0.00','0.00','0.00','0.00','80.00','1217945','LRN11220240331','112','75','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1920.00','0.00','0.00','0.00','0.00','80.00','1217946','LRN11220240331','112','76','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1840.00','0.00','0.00','0.00','0.00','80.00','1217947','LRN11220240331','112','77','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1760.00','0.00','0.00','0.00','0.00','80.00','1217948','LRN11220240331','112','78','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1680.00','0.00','0.00','0.00','0.00','80.00','1217949','LRN11220240331','112','79','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1600.00','0.00','0.00','0.00','0.00','80.00','1217950','LRN11220240331','112','80','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1520.00','0.00','0.00','0.00','0.00','80.00','1217951','LRN11220240331','112','81','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1440.00','0.00','0.00','0.00','0.00','80.00','1217952','LRN11220240331','112','82','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1360.00','0.00','0.00','0.00','0.00','80.00','1217953','LRN11220240331','112','83','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1280.00','0.00','0.00','0.00','0.00','80.00','1217954','LRN11220240331','112','84','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1200.00','0.00','0.00','0.00','0.00','80.00','1217955','LRN11220240331','112','85','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1120.00','0.00','0.00','0.00','0.00','80.00','1217956','LRN11220240331','112','86','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','1040.00','0.00','0.00','0.00','0.00','80.00','1217957','LRN11220240331','112','87','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','960.00','0.00','0.00','0.00','0.00','80.00','1217958','LRN11220240331','112','88','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','880.00','0.00','0.00','0.00','0.00','80.00','1217959','LRN11220240331','112','89','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','800.00','0.00','0.00','0.00','0.00','80.00','1217960','LRN11220240331','112','90','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','720.00','0.00','0.00','0.00','0.00','80.00','1217961','LRN11220240331','112','91','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','640.00','0.00','0.00','0.00','0.00','80.00','1217962','LRN11220240331','112','92','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','560.00','0.00','0.00','0.00','0.00','80.00','1217963','LRN11220240331','112','93','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','480.00','0.00','0.00','0.00','0.00','80.00','1217964','LRN11220240331','112','94','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','400.00','0.00','0.00','0.00','0.00','80.00','1217965','LRN11220240331','112','95','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','320.00','0.00','0.00','0.00','0.00','80.00','1217966','LRN11220240331','112','96','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','240.00','0.00','0.00','0.00','0.00','80.00','1217967','LRN11220240331','112','97','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','160.00','0.00','0.00','0.00','0.00','80.00','1217968','LRN11220240331','112','98','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','80.00','0.00','0.00','0.00','0.00','80.00','1217969','LRN11220240331','112','99','0','','80.00');
INSERT INTO `payment_sched` (paysched_timestamp,paysched_status,paysched_balance,other_charges1,other_charges,penalty,interest_amt,principal_amt,paysched_id,paysched_pn,paysched_code,paysched_countter,paysched_prn,paysched_duedate,paysched_amortization) VALUES 
('2024-05-04 10:38:53','0','0.00','0.00','0.00','0.00','0.00','80.00','1217970','LRN11220240331','112','100','0','','80.00');
UPDATE pros_application SET temp_pnumber='LRN11220240331',app_ho_date='',app_ho_edit='',app_contract_printing='2024-05-04',dateForwaredtoBH='0000-00-00',reasonFADisapproved='0',recAmount='0.00',faREcommendation='',dateReturned='0000-00-00',dateEndorsed='0000-00-00',app_product='1',app_bank='UBP',app_disbursement='Check',app_mode_of_payment='Cash',app_payment_terms='Daily',app_terms='100',app_interest_deduct='Advance',app_interest_rate='16.00',ho_cancellationDAdate='0000-00-00 00:00:00',ho_cancellationDAby='',ho_cancellationDA='',hoApprovedDate='2024-05-02 17:43:28',hoApprvoedBy='027',app_ho_approved_amt='8000.00',app_Entry='015',app_EntryDate='2024-04-27 13:21:16',app_Branch='112',app_timestamp='2024-05-04 10:39:48',app_Number='AN1122024041524',app_AccountNo='11220242334',app_LastName='BUNDALIAN',app_FirstName='RENELL',app_MiddleName='ALACBAY',app_Suffix='',app_HouseNo='83',app_Street='TUMARES ST.',app_Subd='',app_Brgy='35095',app_municipality='CITY OF MALABON',app_BirthDay='1994-04-23',app_AppliedAmt='8000.00',app_Date_Applied='2024-04-27',app_Area='11CLC',app_MarketBy='004I',app_Status='Released',app_recAmt='8000.00',app_AppDisBy='015',app_AppDisDate='2024-04-27 13:40:37',app_Reason_Cancellation='0',app_Type='NEW' WHERE app_Number = 'AN1122024041524'; 
