INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','275594','0.00','0.00','0.00','0.00','0.00','113-104579','113','TC2','LRN11320234128','2023-11-25','0','','700.00','','011','0','113','031','2023-11-25 11:59:20','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275595','0.00','0.00','0.00','0.00','0.00','113-104580','113','TC2','LRN11320234149','2023-11-25','0','','700.00','','011','0','113','031','2023-11-25 11:59:22','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275596','0.00','0.00','0.00','0.00','0.00','113-104581','113','TC2','LRN11320234169','2023-11-25','0','','300.00','','011','0','113','031','2023-11-25 11:59:24','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275597','0.00','0.00','0.00','0.00','0.00','113-104582','113','TC2','LRN11320233989','2023-11-25','0','','840.00','','011','0','113','031','2023-11-25 11:59:26','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275598','0.00','0.00','0.00','0.00','0.00','113-104583','113','TC2','LRN11320234153','2023-11-25','0','','700.00','','011','0','113','031','2023-11-25 11:59:28','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275599','0.00','0.00','0.00','0.00','0.00','113-104584','113','TC2','LRN11320234056','2023-11-25','0','','500.00','','011','0','113','031','2023-11-25 11:59:30','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275600','0.00','0.00','0.00','0.00','0.00','113-104585','113','TC2','LRN11320234024','2023-11-25','0','','500.00','','011','0','113','031','2023-11-25 11:59:32','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275601','0.00','0.00','0.00','0.00','0.00','113-104586','113','TC2','LRN11320233959','2023-11-25','0','','700.00','','011','0','113','031','2023-11-25 11:59:34','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275602','0.00','0.00','0.00','0.00','0.00','113-104587','113','TC2','LRN11320234060','2023-11-25','0','','590.00','','011','0','113','031','2023-11-25 11:59:36','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275603','0.00','0.00','0.00','0.00','0.00','113-104588','113','TC2','LRN11320233928','2023-11-25','0','','3000.00','','011','0','113','031','2023-11-25 11:59:38','0','0000-00-00 00:00:00','0','031','2023-11-25 11:10:56','2023-11-25 11:59: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','275604','0.00','0.00','0.00','0.00','0.00','113-104589','113','TC4','LRN11320234054','2023-11-25','0','','600.00','','016','0','113','031','2023-11-25 12:01:26','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275605','0.00','0.00','0.00','0.00','0.00','113-104590','113','TC4','LRN11320233933','2023-11-25','0','','1000.00','','016','0','113','031','2023-11-25 12:01:28','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275606','0.00','0.00','0.00','0.00','0.00','113-104591','113','TC4','LRN11320234083','2023-11-25','0','','300.00','','016','0','113','031','2023-11-25 12:01:30','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275607','0.00','0.00','0.00','0.00','0.00','113-104592','113','TC4','LRN11320233268','2023-11-25','0','','1000.00','','016','0','113','031','2023-11-25 12:01:32','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275608','0.00','0.00','0.00','0.00','0.00','113-104593','113','TC4','LRN11320234180','2023-11-25','0','','210.00','','016','0','113','031','2023-11-25 12:01:34','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275609','0.00','0.00','0.00','0.00','0.00','113-104594','113','TC4','LRN11320234043','2023-11-25','0','','1500.00','','016','0','113','031','2023-11-25 12:01:36','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275610','0.00','0.00','0.00','0.00','0.00','113-104595','113','TC4','LRN11320233953','2023-11-25','0','','150.00','','016','0','113','031','2023-11-25 12:01:38','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275611','0.00','0.00','0.00','0.00','0.00','113-104596','113','TC4','LRN11320233979','2023-11-25','0','','400.00','','016','0','113','031','2023-11-25 12:01:40','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275612','0.00','0.00','0.00','0.00','0.00','113-104597','113','TC4','LRN11320221679','2023-11-25','0','','300.00','','016','0','113','031','2023-11-25 12:01:42','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12: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','275613','0.00','0.00','0.00','0.00','0.00','113-104598','113','TC4','LRN11320233739','2023-11-25','0','','100.00','','016','0','113','031','2023-11-25 12:01:44','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12: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','275614','0.00','0.00','0.00','0.00','0.00','113-104599','113','TC4','LRN11320221443','2023-11-25','0','','100.00','','016','0','113','031','2023-11-25 12:01:46','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12: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','275615','0.00','0.00','0.00','0.00','0.00','113-104600','113','TC4','LRN11320234004','2023-11-25','0','','700.00','','016','0','113','031','2023-11-25 12:01:49','0','0000-00-00 00:00:00','0','031','2023-11-25 11:24:04','2023-11-25 12:01: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','275616','0.00','0.00','0.00','0.00','0.00','113-104601','113','TC1','LRN11320234175','2023-11-25','0','','600.00','','004','0','113','031','2023-11-25 11:58:33','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275617','0.00','0.00','0.00','0.00','0.00','113-104602','113','TC1','LRN11320234176','2023-11-25','0','','700.00','','004','0','113','031','2023-11-25 11:58:35','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275618','0.00','0.00','0.00','0.00','0.00','113-104603','113','TC1','LRN11320234119','2023-11-25','0','','2100.00','','004','0','113','031','2023-11-25 11:58:37','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275619','0.00','0.00','0.00','0.00','0.00','113-104604','113','TC1','LRN11320221514','2023-11-25','0','','1000.00','','004','0','113','031','2023-11-25 11:58:39','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275620','0.00','0.00','0.00','0.00','0.00','113-104605','113','TC1','LRN11320233689','2023-11-25','0','','200.00','','004','0','113','031','2023-11-25 11:58:41','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275621','0.00','0.00','0.00','0.00','0.00','113-104606','113','TC1','LRN11320234010','2023-11-25','0','','3000.00','','004','0','113','031','2023-11-25 11:58:43','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275622','0.00','0.00','0.00','0.00','0.00','113-104607','113','TC1','LRN11320233824','2023-11-25','0','','1400.00','','004','0','113','031','2023-11-25 11:58:45','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275623','0.00','0.00','0.00','0.00','0.00','113-104608','113','TC1','LRN11320233941','2023-11-25','0','','1000.00','','004','0','113','031','2023-11-25 11:58:47','0','0000-00-00 00:00:00','0','031','2023-11-25 11:45:42','2023-11-25 11:58: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','275624','0.00','0.00','0.00','0.00','0.00','113-104609','113','TC3','LRN11320234157','2023-11-25','0','','1050.00','','014','0','113','031','2023-11-25 12:00:21','0','0000-00-00 00:00:00','0','031','2023-11-25 11:48:00','2023-11-25 12:00:21'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','275625','0.00','0.00','0.00','0.00','0.00','113-104610','113','TC3','LRN11320222774','2023-11-25','0','','60.00','','014','0','113','031','2023-11-25 12:00:23','0','0000-00-00 00:00:00','0','031','2023-11-25 11:48:00','2023-11-25 12:00: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','275626','0.00','0.00','0.00','0.00','0.00','113-104611','113','TC3','LRN11320234147','2023-11-25','0','','1000.00','','014','0','113','031','2023-11-25 12:00:25','0','0000-00-00 00:00:00','0','031','2023-11-25 11:48:00','2023-11-25 12:00: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','275627','0.00','0.00','0.00','0.00','0.00','113-104612','113','TC3','LRN11320233927','2023-11-25','0','','840.00','','014','0','113','031','2023-11-25 12:00:27','0','0000-00-00 00:00:00','0','031','2023-11-25 11:48:00','2023-11-25 12:00: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','275628','0.00','0.00','0.00','0.00','0.00','113-104613','113','TC3','LRN11320234022','2023-11-25','0','','1050.00','','014','0','113','031','2023-11-25 12:00:29','0','0000-00-00 00:00:00','0','031','2023-11-25 11:48:00','2023-11-25 12:00: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','275629','0.00','0.00','0.00','0.00','0.00','113-104614','113','TC3','LRN11320233843','2023-11-25','0','','500.00','','014','0','113','031','2023-11-25 12:00:31','0','0000-00-00 00:00:00','0','031','2023-11-25 11:48:00','2023-11-25 12:00: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','275630','0.00','0.00','0.00','0.00','0.00','113-104615','113','TC3','LRN11320233567','2023-11-25','0','','500.00','','014','0','113','031','2023-11-25 12:00:33','0','0000-00-00 00:00:00','0','031','2023-11-25 11:48:00','2023-11-25 12:00: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','275631','0.00','0.00','0.00','0.00','0.00','113-104616','113','TC5','LRN11320234161','2023-11-25','0','','500.00','','05','0','113','031','2023-11-25 12:02:24','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12:02: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','275632','0.00','0.00','0.00','0.00','0.00','113-104617','113','TC5','LRN11320233659','2023-11-25','0','','500.00','','05','0','113','031','2023-11-25 12:02:26','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12: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','275633','0.00','0.00','0.00','0.00','0.00','113-104618','113','TC5','LRN11320234015','2023-11-25','0','','500.00','','05','0','113','031','2023-11-25 12:02:28','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12: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','275634','0.00','0.00','0.00','0.00','0.00','113-104619','113','TC5','LRN11320234014','2023-11-25','0','','500.00','','05','0','113','031','2023-11-25 12:02:31','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12:02: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','275635','0.00','0.00','0.00','0.00','0.00','113-104620','113','TC5','LRN11320233821','2023-11-25','0','','750.00','','05','0','113','031','2023-11-25 12:02:33','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12:02: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','275636','0.00','0.00','0.00','0.00','0.00','113-104621','113','TC5','LRN11320233722','2023-11-25','0','','300.00','','05','0','113','031','2023-11-25 12:02:35','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12:02: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','275637','0.00','0.00','0.00','0.00','0.00','113-104622','113','TC5','LRN11320234177','2023-11-25','0','','1120.00','','05','0','113','031','2023-11-25 12:02:37','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12:02: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','275638','0.00','0.00','0.00','0.00','0.00','113-104623','113','TC5','LRN11320233841','2023-11-25','0','','2000.00','','05','0','113','031','2023-11-25 12:02:39','0','0000-00-00 00:00:00','0','031','2023-11-25 11:50:34','2023-11-25 12:02: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','275639','0.00','0.00','0.00','0.00','0.00','113-104624','113','TC6','LRN11320233971','2023-11-25','0','','1400.00','','029','0','113','031','2023-11-25 12:03:12','0','0000-00-00 00:00:00','0','031','2023-11-25 11:52:09','2023-11-25 12:03: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','275640','0.00','0.00','0.00','0.00','0.00','113-104625','113','TC6','LRN11320233264','2023-11-25','0','','2000.00','','029','0','113','031','2023-11-25 12:03:14','0','0000-00-00 00:00:00','0','031','2023-11-25 11:52:09','2023-11-25 12:03: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','275641','0.00','0.00','0.00','0.00','0.00','113-104626','113','TC6','LRN11320234033','2023-11-25','0','','700.00','','029','0','113','031','2023-11-25 12:03:17','0','0000-00-00 00:00:00','0','031','2023-11-25 11:52:09','2023-11-25 12:03:17'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','275642','0.00','0.00','0.00','0.00','0.00','113-104627','113','TC6','LRN11320233934','2023-11-25','0','','1260.00','','029','0','113','031','2023-11-25 12:03:19','0','0000-00-00 00:00:00','0','031','2023-11-25 11:52:09','2023-11-25 12:03:19'); INSERT INTO `cust_collection` (coll_ho_date,coll_ho_edit,dmcmorDate,dmcm,coll_type,coll_pdi,coll_prn,collectionID,coll_other_charges1,coll_other_charges,coll_penalty,coll_interest,coll_prn_amt,coll_UnikOR,`coll_Branch`, `coll_Area`, `coll_SalesloanNo`, `coll_OrDate`, `coll_TypePayment`, `coll_OrNumber`, `coll_Amount`, `coll_Remarks`, `coll_CollectedBy`, `coll_Interbranch`, `coll_OriginalBranch`, `coll_ApprovedBy`, `coll_ApprovedDate`, `coll_Void`, `coll_Voiddate`, `coll_ReasonVoid`, `coll_CreatedBy`, `coll_Createddate`, `coll_timestamp`) VALUES ('','','0000-00-00','','0','0.00','0','275643','0.00','0.00','0.00','0.00','0.00','113-104628','113','TC8','LRN11320233597','2023-11-25','0','','700.00','','038','0','113','031','2023-11-25 12:04:32','0','0000-00-00 00:00:00','0','031','2023-11-25 11:56:08','2023-11-25 12:04: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','275644','0.00','0.00','0.00','0.00','0.00','113-104629','113','TC8','LRN11320233904','2023-11-25','0','','700.00','','038','0','113','031','2023-11-25 12:04:34','0','0000-00-00 00:00:00','0','031','2023-11-25 11:56:08','2023-11-25 12:04: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','275645','0.00','0.00','0.00','0.00','0.00','113-104630','113','TC8','LRN11320233924','2023-11-25','0','','1100.00','','038','0','113','031','2023-11-25 12:04:36','0','0000-00-00 00:00:00','0','031','2023-11-25 11:56:08','2023-11-25 12:04: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','275646','0.00','0.00','0.00','0.00','0.00','113-104631','113','TC8','LRN11320234052','2023-11-25','0','','700.00','','038','0','113','031','2023-11-25 12:04:39','0','0000-00-00 00:00:00','0','031','2023-11-25 11:56:08','2023-11-25 12:04: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','275647','0.00','0.00','0.00','0.00','0.00','113-104632','113','TC8','LRN11320234099','2023-11-25','0','','500.00','','038','0','113','031','2023-11-25 12:04:41','0','0000-00-00 00:00:00','0','031','2023-11-25 11:56:08','2023-11-25 12:04: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','275648','0.00','0.00','0.00','0.00','0.00','113-104633','113','TC8','LRN11320234098','2023-11-25','0','','200.00','','038','0','113','031','2023-11-25 12:04:43','0','0000-00-00 00:00:00','0','031','2023-11-25 11:56:08','2023-11-25 12:04: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','275649','0.00','0.00','0.00','0.00','0.00','113-104634','113','TC7','LRN11320234039','2023-11-25','0','','840.00','','041','0','113','031','2023-11-25 12:03:50','0','0000-00-00 00:00:00','0','031','2023-11-25 11:57:53','2023-11-25 12:03: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','275650','0.00','0.00','0.00','0.00','0.00','113-104635','113','TC7','LRN11320234008','2023-11-25','0','','700.00','','041','0','113','031','2023-11-25 12:03:52','0','0000-00-00 00:00:00','0','031','2023-11-25 11:57:53','2023-11-25 12:03: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','275651','0.00','0.00','0.00','0.00','0.00','113-104636','113','TC7','LRN11320234009','2023-11-25','0','','700.00','','041','0','113','031','2023-11-25 12:03:54','0','0000-00-00 00:00:00','0','031','2023-11-25 11:57:53','2023-11-25 12:03: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','275652','0.00','0.00','0.00','0.00','0.00','113-104637','113','TC7','LRN11320234030','2023-11-25','0','','700.00','','041','0','113','031','2023-11-25 12:03:56','0','0000-00-00 00:00:00','0','031','2023-11-25 11:57:53','2023-11-25 12:03: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','275653','0.00','0.00','0.00','0.00','0.00','113-104638','113','TC7','LRN11320234115','2023-11-25','0','','1500.00','','041','0','113','031','2023-11-25 12:03:58','0','0000-00-00 00:00:00','0','031','2023-11-25 11:57:53','2023-11-25 12:03: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','275654','0.00','0.00','0.00','0.00','0.00','113-104639','113','TC7','LRN11320234116','2023-11-25','0','','500.00','','041','0','113','031','2023-11-25 12:04:00','0','0000-00-00 00:00:00','0','031','2023-11-25 11:57:53','2023-11-25 12:04:00'); UPDATE cust_information SET cust_ho_date='',cust_ho_edit='',cust_picture='0000-00-00 00:00:00',cust_Code='11220221909', cust_Gender='FEMALE', cust_CivilStatus='SINGLE', cust_Cycle='6', cust_Status='ACTIVE', cust_encoded='015', cust_encodeDate='2022-02-25 11:28:32', cust_timestamp='2023-11-25 11:12:13', cust_LastName='MARIANO',cust_FirstName='DANIKA',cust_MiddleName='MANALASTAS',cust_Suffix='',cust_MaidenName='MANALASTAS',cust_NickName='NIKA',cust_Area='13CLC',cust_Nationality='FILIPINO', cust_Bday= '1995-02-09', cust_BirthPlace= 'CALOOCAN CITY' WHERE cust_ID = '4148' and cust_Branch = '112'; UPDATE cust_information SET cust_ho_date='',cust_ho_edit='',cust_picture='0000-00-00 00:00:00',cust_Code='11220232128', cust_Gender='FEMALE', cust_CivilStatus='MARRIED', cust_Cycle='3', cust_Status='ACTIVE', cust_encoded='015', cust_encodeDate='2023-05-29 10:51:49', cust_timestamp='2023-11-25 11:12:13', cust_LastName='LOPEZ',cust_FirstName='OLIVIA',cust_MiddleName='PINGOL',cust_Suffix='',cust_MaidenName='PINGOL',cust_NickName='OLIVIA',cust_Area='11CLC',cust_Nationality='FILIPINO', cust_Bday= '1966-06-29', cust_BirthPlace= 'NAVOTAS CITY' WHERE cust_ID = '4976' and cust_Branch = '112'; INSERT INTO `cust_savings` (ho_date,ho_edit,saveid,branch,accountno,typetrans,datetrans,amttrans,remarks,remarks1,empid,createdBy,`timestamp`) VALUES ('','','12273','112','11220232128','insurance','2023-11-25','0.00','LRN11220232393','','004i','015','2023-11-29 16:13:32'); INSERT INTO `cust_savings` (ho_date,ho_edit,saveid,branch,accountno,typetrans,datetrans,amttrans,remarks,remarks1,empid,createdBy,`timestamp`) VALUES ('','','12274','112','11220221909','insurance','2023-11-25','0.00','LRN11220232394','','006','015','2023-11-29 16:13:32'); UPDATE fund_check_status SET check_Status='Released',check_Reason='0',check_CanceledDate='0000-00-00 00:00:00',check_Encoded='027',check_timestamp='2023-11-25 11:10:59' WHERE check_Branch = '112' and check_ID_Unique = 'AN11220231110492004741558'; UPDATE fund_check_status SET check_Status='Released',check_Reason='0',check_CanceledDate='0000-00-00 00:00:00',check_Encoded='027',check_timestamp='2023-11-25 11:11:35' WHERE check_Branch = '112' and check_ID_Unique = 'AN11220231110522004741560'; 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 ('113','TC1','Deposited','2023-11-25','167','2023-11-25','10000.00','0.00','0.00','','ACTIVE','031','2023-11-25 11:59:50','2023-11-25 11:59:50'); 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 ('113','TC2','Deposited','2023-11-25','168','2023-11-25','8530.00','0.00','0.00','','ACTIVE','031','2023-11-25 12:01:17','2023-11-25 12:01:17'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC3','Deposited','2023-11-25','167','2023-11-25','5000.00','0.00','0.00','','ACTIVE','031','2023-11-25 12:05:08','2023-11-25 12:05:08'); 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 ('113','TC4','Deposited','2023-11-25','168','2023-11-25','6360.00','0.00','0.00','','ACTIVE','031','2023-11-25 12:05:33','2023-11-25 12:05: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 ('113','TC5','Deposited','2023-11-25','167','2023-11-25','6170.00','0.00','0.00','','ACTIVE','031','2023-11-25 12:06:00','2023-11-25 12:06:00'); INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES ('113','TC6','Deposited','2023-11-25','168','2023-11-25','5360.00','0.00','0.00','','ACTIVE','031','2023-11-25 12:06:23','2023-11-25 12:06:23'); 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 ('113','TC7','Deposited','2023-11-25','167','2023-11-25','4940.00','0.00','0.00','','ACTIVE','031','2023-11-25 12:06:51','2023-11-25 12:06:51'); 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 ('113','TC8','Deposited','2023-11-25','168','2023-11-25','3900.00','0.00','0.00','','ACTIVE','031','2023-11-25 12:07:33','2023-11-25 12:07:33'); 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','','9700.00','100.00','0.00','0.00','0.00','10714','Daily','0.00','10000.00','0.00','10000.00','0.00','0.00','0.00','0.00','0.00','0.00','1','100','AN1122023111049','112','11220232128','004i','LRN11220232393','10000.00','4CLC','3','2023-11-25','2024-03-04','10000.00','2023-11-29','0.00','0.00','580.00','580.00','ACTIVE','015','2023-11-25 11:12:13','0000-00-00','0','015','2023-11-25 11:10:59','2023-11-29 16:10:08'); 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','','12750.00','130.00','0.00','0.00','0.00','10716','Daily','0.00','13000.00','0.00','13000.00','0.00','0.00','0.00','0.00','0.00','0.00','1','100','AN1122023111052','112','11220221909','006','LRN11220232394','13000.00','3CLC','6','2023-11-25','2024-03-04','13000.00','2023-11-29','0.00','0.00','400.00','400.00','ACTIVE','015','2023-11-25 11:12:13','0000-00-00','0','015','2023-11-25 11:11:35','2023-11-29 16:36:34'); UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='-318699.20',sales_prin_amt='-1663170.80',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='031',sales_PostedDate='2022-01-04 13:33:22',sales_Timestamp='2023-11-25 10:15:26',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='1995.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2022-01-04 13:58:52',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211041',sales_AssignTo='014',sales_PNumber='LRN11320211379',sales_Amt='10000.00',sales_Area='TC3',sales_Cycle='2',sales_Released='2021-12-30',sales_Maturity='2022-04-09',sales_BegBalance='10000.00',sales_LPD='2023-08-18' WHERE sales_PNumber = 'LRN11320211379' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='-1731.20',sales_prin_amt='911.20',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='031',sales_PostedDate='2022-04-01 16:45:39',sales_Timestamp='2023-11-25 10:15:26',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='2505.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2022-04-05 13:41:18',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320211009',sales_AssignTo='014',sales_PNumber='LRN11320221714',sales_Amt='10000.00',sales_Area='TC3',sales_Cycle='4',sales_Released='2022-03-31',sales_Maturity='2022-07-09',sales_BegBalance='10000.00',sales_LPD='2023-08-18' WHERE sales_PNumber = 'LRN11320221714' ; 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='90.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='9000.00',sales_interest_amt='-1734.40',sales_prin_amt='-105.60',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='031',sales_PostedDate='2022-06-30 16:48:27',sales_Timestamp='2023-11-25 10:15:26',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9000.00',sales_PaymentCutoff='860.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2022-07-04 10:12:25',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220014',sales_AssignTo='014',sales_PNumber='LRN11320222056',sales_Amt='9000.00',sales_Area='TC3',sales_Cycle='2',sales_Released='2022-06-30',sales_Maturity='2022-10-08',sales_BegBalance='9000.00',sales_LPD='2023-08-18' WHERE sales_PNumber = 'LRN11320222056' ; 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='6490.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='2022-08-23 13:37:23',sales_Timestamp='2023-11-25 10:20:45',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3510.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2022-08-23 13:39:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221978',sales_AssignTo='034',sales_PNumber='LRN11220221050',sales_Amt='10000.00',sales_Area='11CLC',sales_Cycle='1',sales_Released='2022-08-23',sales_Maturity='2022-12-01',sales_BegBalance='10000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220221050' ; 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='1840.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-04-25 11:30:53',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='8160.00',sales_PaymentCutoff='2000.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-04-25 11:34:22',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232076',sales_AssignTo='037',sales_PNumber='LRN11220231707',sales_Amt='10000.00',sales_Area='12CLC',sales_Cycle='2',sales_Released='2023-04-25',sales_Maturity='2023-08-03',sales_BegBalance='10000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220231707' ; 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='870.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-04-25 11:33:40',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='9130.00',sales_PaymentCutoff='150.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-04-25 11:34:22',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211852',sales_AssignTo='006',sales_PNumber='LRN11220231711',sales_Amt='10000.00',sales_Area='3CLC',sales_Cycle='6',sales_Released='2023-04-25',sales_Maturity='2023-08-03',sales_BegBalance='10000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220231711' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='1060256.00',sales_prin_amt='5576344.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='031',sales_PostedDate='2023-04-26 16:39:23',sales_Timestamp='2023-11-25 10:15:26',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='22000.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-04-26 16:46:34',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320220099',sales_AssignTo='011',sales_PNumber='LRN11320233279',sales_Amt='10000.00',sales_Area='TC2',sales_Cycle='4',sales_Released='2023-04-26',sales_Maturity='2023-08-04',sales_BegBalance='10000.00',sales_LPD='2023-08-18' WHERE sales_PNumber = 'LRN11320233279' ; 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='6590.00',sales_amortization='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='0.00',sales_prin_amt='20000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-05-18 14:43:57',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13410.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-05-18 14:44:39',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220222030',sales_AssignTo='043',sales_PNumber='LRN11220231780',sales_Amt='20000.00',sales_Area='12CLC',sales_Cycle='4',sales_Released='2023-05-18',sales_Maturity='2023-08-26',sales_BegBalance='20000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220231780' ; 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='4030.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-06-27 12:01:04',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='5970.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-06-27 12:03:33',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232095',sales_AssignTo='042',sales_PNumber='LRN11220231913',sales_Amt='10000.00',sales_Area='13CLC',sales_Cycle='2',sales_Released='2023-06-27',sales_Maturity='2023-10-05',sales_BegBalance='10000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220231913' ; 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='11820.00',sales_amortization='270.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='27000.00',sales_interest_amt='0.00',sales_prin_amt='27000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-07-19 12:50:34',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='15180.00',sales_PaymentCutoff='100.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-07-19 12:53:53',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220191598',sales_AssignTo='034',sales_PNumber='LRN11220231984',sales_Amt='27000.00',sales_Area='11CLC',sales_Cycle='10',sales_Released='2023-07-19',sales_Maturity='2023-10-27',sales_BegBalance='27000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220231984' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='130.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='13000.00',sales_interest_amt='0.00',sales_prin_amt='13000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-09 15:02:24',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='13000.00',sales_PaymentCutoff='5370.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-09 15:09:33',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220221909',sales_AssignTo='006',sales_PNumber='LRN11220232040',sales_Amt='13000.00',sales_Area='3CLC',sales_Cycle='5',sales_Released='2023-08-09',sales_Maturity='2023-11-17',sales_BegBalance='13000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232040' ; 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='150.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='15000.00',sales_interest_amt='0.00',sales_prin_amt='15000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-15 13:19:06',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='15000.00',sales_PaymentCutoff='390.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-15 13:20:40',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232222',sales_AssignTo='004i',sales_PNumber='LRN11220232067',sales_Amt='15000.00',sales_Area='4CLC',sales_Cycle='1',sales_Released='2023-08-15',sales_Maturity='2023-11-23',sales_BegBalance='15000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232067' ; 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='6940.00',sales_amortization='230.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='23000.00',sales_interest_amt='0.00',sales_prin_amt='23000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-17 13:36:04',sales_Timestamp='2023-11-25 10:20:46',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='16060.00',sales_PaymentCutoff='150.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-17 13:42:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220211838',sales_AssignTo='034',sales_PNumber='LRN11220232074',sales_Amt='23000.00',sales_Area='11CLC',sales_Cycle='10',sales_Released='2023-08-17',sales_Maturity='2023-11-25',sales_BegBalance='23000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232074' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='0.00',sales_amortization='100.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='10000.00',sales_interest_amt='0.00',sales_prin_amt='10000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-08-29 13:53:46',sales_Timestamp='2023-11-25 10:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='1880.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-08-29 14:12:21',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232128',sales_AssignTo='034',sales_PNumber='LRN11220232129',sales_Amt='10000.00',sales_Area='11CLC',sales_Cycle='2',sales_Released='2023-08-29',sales_Maturity='2023-12-07',sales_BegBalance='10000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232129' ; 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='16500.00',sales_amortization='500.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='50000.00',sales_interest_amt='0.00',sales_prin_amt='50000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-09-20 13:10:04',sales_Timestamp='2023-11-25 10:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='33500.00',sales_PaymentCutoff='3500.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-09-20 13:10:41',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220170360',sales_AssignTo='006',sales_PNumber='LRN11220232195',sales_Amt='50000.00',sales_Area='3CLC',sales_Cycle='14',sales_Released='2023-09-20',sales_Maturity='2023-12-29',sales_BegBalance='50000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232195' ; 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='4260.00',sales_amortization='80.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='8000.00',sales_interest_amt='0.00',sales_prin_amt='8000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-10-13 11:53:17',sales_Timestamp='2023-11-25 10:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3740.00',sales_PaymentCutoff='120.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-13 11:54:48',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232164',sales_AssignTo='002',sales_PNumber='LRN11220232257',sales_Amt='8000.00',sales_Area='2CLC',sales_Cycle='2',sales_Released='2023-10-13',sales_Maturity='2024-01-21',sales_BegBalance='8000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232257' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='9150.00',sales_amortization='120.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='12000.00',sales_interest_amt='0.00',sales_prin_amt='12000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-10-24 14:21:32',sales_Timestamp='2023-11-25 10:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='2850.00',sales_PaymentCutoff='170.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-24 14:22:11',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232205',sales_AssignTo='004i',sales_PNumber='LRN11220232292',sales_Amt='12000.00',sales_Area='4CLC',sales_Cycle='2',sales_Released='2023-10-24',sales_Maturity='2024-02-01',sales_BegBalance='12000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232292' ; 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='14486.00',sales_amortization='180.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='18000.00',sales_interest_amt='0.00',sales_prin_amt='18000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-10-28 10:14:18',sales_Timestamp='2023-11-25 10:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='3514.00',sales_PaymentCutoff='250.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-10-28 10:15:32',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232177',sales_AssignTo='002',sales_PNumber='LRN11220232315',sales_Amt='18000.00',sales_Area='2CLC',sales_Cycle='3',sales_Released='2023-10-28',sales_Maturity='2024-02-05',sales_BegBalance='18000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232315' ; UPDATE fund_sales SET sales_ho_date='',sales_ho_edit='',overdue_asofdate='',overdue_amount='0.00',sales_delay_asof='',sales_no_delay='0',sales_restructured_tag='0',sales_transfer='',sales_balance='11580.00',sales_amortization='130.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='13000.00',sales_interest_amt='0.00',sales_prin_amt='13000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='015',sales_PostedDate='2023-11-15 12:27:51',sales_Timestamp='2023-11-25 10:20:47',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='1420.00',sales_PaymentCutoff='555.00',sales_Status='ACTIVE',sales_ValidatedBy='015',sales_ValidatedDate='2023-11-15 12:30:19',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11220232142',sales_AssignTo='004i',sales_PNumber='LRN11220232345',sales_Amt='13000.00',sales_Area='4CLC',sales_Cycle='3',sales_Released='2023-11-15',sales_Maturity='2024-02-23',sales_BegBalance='13000.00',sales_LPD='2023-11-24' WHERE sales_PNumber = 'LRN11220232345' ; 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 ('2023-11-25 11:09:36','0','10000.00','0.00','0.00','0.00','0.00','0.00','1044751','LRN11220232393','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 ('2023-11-25 11:09:36','0','9900.00','0.00','0.00','0.00','0.00','100.00','1044752','LRN11220232393','112','1','0','','100.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 ('2023-11-25 11:09:36','0','9800.00','0.00','0.00','0.00','0.00','100.00','1044753','LRN11220232393','112','2','0','','100.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 ('2023-11-25 11:09:36','0','9700.00','0.00','0.00','0.00','0.00','100.00','1044754','LRN11220232393','112','3','0','','100.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 ('2023-11-25 11:09:36','0','9600.00','0.00','0.00','0.00','0.00','100.00','1044755','LRN11220232393','112','4','0','','100.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 ('2023-11-25 11:09:36','0','9500.00','0.00','0.00','0.00','0.00','100.00','1044756','LRN11220232393','112','5','0','','100.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 ('2023-11-25 11:09:36','0','9400.00','0.00','0.00','0.00','0.00','100.00','1044757','LRN11220232393','112','6','0','','100.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 ('2023-11-25 11:09:36','0','9300.00','0.00','0.00','0.00','0.00','100.00','1044758','LRN11220232393','112','7','0','','100.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 ('2023-11-25 11:09:36','0','9200.00','0.00','0.00','0.00','0.00','100.00','1044759','LRN11220232393','112','8','0','','100.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 ('2023-11-25 11:09:36','0','9100.00','0.00','0.00','0.00','0.00','100.00','1044760','LRN11220232393','112','9','0','','100.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 ('2023-11-25 11:09:36','0','9000.00','0.00','0.00','0.00','0.00','100.00','1044761','LRN11220232393','112','10','0','','100.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 ('2023-11-25 11:09:36','0','8900.00','0.00','0.00','0.00','0.00','100.00','1044762','LRN11220232393','112','11','0','','100.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 ('2023-11-25 11:09:36','0','8800.00','0.00','0.00','0.00','0.00','100.00','1044763','LRN11220232393','112','12','0','','100.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 ('2023-11-25 11:09:36','0','8700.00','0.00','0.00','0.00','0.00','100.00','1044764','LRN11220232393','112','13','0','','100.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 ('2023-11-25 11:09:36','0','8600.00','0.00','0.00','0.00','0.00','100.00','1044765','LRN11220232393','112','14','0','','100.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 ('2023-11-25 11:09:36','0','8500.00','0.00','0.00','0.00','0.00','100.00','1044766','LRN11220232393','112','15','0','','100.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 ('2023-11-25 11:09:36','0','8400.00','0.00','0.00','0.00','0.00','100.00','1044767','LRN11220232393','112','16','0','','100.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 ('2023-11-25 11:09:36','0','8300.00','0.00','0.00','0.00','0.00','100.00','1044768','LRN11220232393','112','17','0','','100.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 ('2023-11-25 11:09:36','0','8200.00','0.00','0.00','0.00','0.00','100.00','1044769','LRN11220232393','112','18','0','','100.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 ('2023-11-25 11:09:36','0','8100.00','0.00','0.00','0.00','0.00','100.00','1044770','LRN11220232393','112','19','0','','100.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 ('2023-11-25 11:09:36','0','8000.00','0.00','0.00','0.00','0.00','100.00','1044771','LRN11220232393','112','20','0','','100.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 ('2023-11-25 11:09:36','0','7900.00','0.00','0.00','0.00','0.00','100.00','1044772','LRN11220232393','112','21','0','','100.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 ('2023-11-25 11:09:36','0','7800.00','0.00','0.00','0.00','0.00','100.00','1044773','LRN11220232393','112','22','0','','100.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 ('2023-11-25 11:09:36','0','7700.00','0.00','0.00','0.00','0.00','100.00','1044774','LRN11220232393','112','23','0','','100.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 ('2023-11-25 11:09:36','0','7600.00','0.00','0.00','0.00','0.00','100.00','1044775','LRN11220232393','112','24','0','','100.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 ('2023-11-25 11:09:36','0','7500.00','0.00','0.00','0.00','0.00','100.00','1044776','LRN11220232393','112','25','0','','100.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 ('2023-11-25 11:09:36','0','7400.00','0.00','0.00','0.00','0.00','100.00','1044777','LRN11220232393','112','26','0','','100.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 ('2023-11-25 11:09:36','0','7300.00','0.00','0.00','0.00','0.00','100.00','1044778','LRN11220232393','112','27','0','','100.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 ('2023-11-25 11:09:36','0','7200.00','0.00','0.00','0.00','0.00','100.00','1044779','LRN11220232393','112','28','0','','100.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 ('2023-11-25 11:09:36','0','7100.00','0.00','0.00','0.00','0.00','100.00','1044780','LRN11220232393','112','29','0','','100.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 ('2023-11-25 11:09:36','0','7000.00','0.00','0.00','0.00','0.00','100.00','1044781','LRN11220232393','112','30','0','','100.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 ('2023-11-25 11:09:36','0','6900.00','0.00','0.00','0.00','0.00','100.00','1044782','LRN11220232393','112','31','0','','100.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 ('2023-11-25 11:09:36','0','6800.00','0.00','0.00','0.00','0.00','100.00','1044783','LRN11220232393','112','32','0','','100.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 ('2023-11-25 11:09:36','0','6700.00','0.00','0.00','0.00','0.00','100.00','1044784','LRN11220232393','112','33','0','','100.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 ('2023-11-25 11:09:36','0','6600.00','0.00','0.00','0.00','0.00','100.00','1044785','LRN11220232393','112','34','0','','100.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 ('2023-11-25 11:09:36','0','6500.00','0.00','0.00','0.00','0.00','100.00','1044786','LRN11220232393','112','35','0','','100.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 ('2023-11-25 11:09:36','0','6400.00','0.00','0.00','0.00','0.00','100.00','1044787','LRN11220232393','112','36','0','','100.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 ('2023-11-25 11:09:36','0','6300.00','0.00','0.00','0.00','0.00','100.00','1044788','LRN11220232393','112','37','0','','100.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 ('2023-11-25 11:09:36','0','6200.00','0.00','0.00','0.00','0.00','100.00','1044789','LRN11220232393','112','38','0','','100.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 ('2023-11-25 11:09:36','0','6100.00','0.00','0.00','0.00','0.00','100.00','1044790','LRN11220232393','112','39','0','','100.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 ('2023-11-25 11:09:36','0','6000.00','0.00','0.00','0.00','0.00','100.00','1044791','LRN11220232393','112','40','0','','100.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 ('2023-11-25 11:09:36','0','5900.00','0.00','0.00','0.00','0.00','100.00','1044792','LRN11220232393','112','41','0','','100.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 ('2023-11-25 11:09:36','0','5800.00','0.00','0.00','0.00','0.00','100.00','1044793','LRN11220232393','112','42','0','','100.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 ('2023-11-25 11:09:36','0','5700.00','0.00','0.00','0.00','0.00','100.00','1044794','LRN11220232393','112','43','0','','100.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 ('2023-11-25 11:09:36','0','5600.00','0.00','0.00','0.00','0.00','100.00','1044795','LRN11220232393','112','44','0','','100.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 ('2023-11-25 11:09:36','0','5500.00','0.00','0.00','0.00','0.00','100.00','1044796','LRN11220232393','112','45','0','','100.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 ('2023-11-25 11:09:36','0','5400.00','0.00','0.00','0.00','0.00','100.00','1044797','LRN11220232393','112','46','0','','100.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 ('2023-11-25 11:09:36','0','5300.00','0.00','0.00','0.00','0.00','100.00','1044798','LRN11220232393','112','47','0','','100.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 ('2023-11-25 11:09:36','0','5200.00','0.00','0.00','0.00','0.00','100.00','1044799','LRN11220232393','112','48','0','','100.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 ('2023-11-25 11:09:36','0','5100.00','0.00','0.00','0.00','0.00','100.00','1044800','LRN11220232393','112','49','0','','100.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 ('2023-11-25 11:09:36','0','5000.00','0.00','0.00','0.00','0.00','100.00','1044801','LRN11220232393','112','50','0','','100.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 ('2023-11-25 11:09:36','0','4900.00','0.00','0.00','0.00','0.00','100.00','1044802','LRN11220232393','112','51','0','','100.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 ('2023-11-25 11:09:36','0','4800.00','0.00','0.00','0.00','0.00','100.00','1044803','LRN11220232393','112','52','0','','100.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 ('2023-11-25 11:09:36','0','4700.00','0.00','0.00','0.00','0.00','100.00','1044804','LRN11220232393','112','53','0','','100.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 ('2023-11-25 11:09:36','0','4600.00','0.00','0.00','0.00','0.00','100.00','1044805','LRN11220232393','112','54','0','','100.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 ('2023-11-25 11:09:36','0','4500.00','0.00','0.00','0.00','0.00','100.00','1044806','LRN11220232393','112','55','0','','100.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 ('2023-11-25 11:09:36','0','4400.00','0.00','0.00','0.00','0.00','100.00','1044807','LRN11220232393','112','56','0','','100.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 ('2023-11-25 11:09:36','0','4300.00','0.00','0.00','0.00','0.00','100.00','1044808','LRN11220232393','112','57','0','','100.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 ('2023-11-25 11:09:36','0','4200.00','0.00','0.00','0.00','0.00','100.00','1044809','LRN11220232393','112','58','0','','100.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 ('2023-11-25 11:09:36','0','4100.00','0.00','0.00','0.00','0.00','100.00','1044810','LRN11220232393','112','59','0','','100.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 ('2023-11-25 11:09:36','0','4000.00','0.00','0.00','0.00','0.00','100.00','1044811','LRN11220232393','112','60','0','','100.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 ('2023-11-25 11:09:36','0','3900.00','0.00','0.00','0.00','0.00','100.00','1044812','LRN11220232393','112','61','0','','100.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 ('2023-11-25 11:09:36','0','3800.00','0.00','0.00','0.00','0.00','100.00','1044813','LRN11220232393','112','62','0','','100.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 ('2023-11-25 11:09:36','0','3700.00','0.00','0.00','0.00','0.00','100.00','1044814','LRN11220232393','112','63','0','','100.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 ('2023-11-25 11:09:36','0','3600.00','0.00','0.00','0.00','0.00','100.00','1044815','LRN11220232393','112','64','0','','100.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 ('2023-11-25 11:09:36','0','3500.00','0.00','0.00','0.00','0.00','100.00','1044816','LRN11220232393','112','65','0','','100.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 ('2023-11-25 11:09:36','0','3400.00','0.00','0.00','0.00','0.00','100.00','1044817','LRN11220232393','112','66','0','','100.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 ('2023-11-25 11:09:36','0','3300.00','0.00','0.00','0.00','0.00','100.00','1044818','LRN11220232393','112','67','0','','100.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 ('2023-11-25 11:09:36','0','3200.00','0.00','0.00','0.00','0.00','100.00','1044819','LRN11220232393','112','68','0','','100.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 ('2023-11-25 11:09:36','0','3100.00','0.00','0.00','0.00','0.00','100.00','1044820','LRN11220232393','112','69','0','','100.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 ('2023-11-25 11:09:36','0','3000.00','0.00','0.00','0.00','0.00','100.00','1044821','LRN11220232393','112','70','0','','100.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 ('2023-11-25 11:09:36','0','2900.00','0.00','0.00','0.00','0.00','100.00','1044822','LRN11220232393','112','71','0','','100.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 ('2023-11-25 11:09:36','0','2800.00','0.00','0.00','0.00','0.00','100.00','1044823','LRN11220232393','112','72','0','','100.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 ('2023-11-25 11:09:36','0','2700.00','0.00','0.00','0.00','0.00','100.00','1044824','LRN11220232393','112','73','0','','100.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 ('2023-11-25 11:09:36','0','2600.00','0.00','0.00','0.00','0.00','100.00','1044825','LRN11220232393','112','74','0','','100.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 ('2023-11-25 11:09:36','0','2500.00','0.00','0.00','0.00','0.00','100.00','1044826','LRN11220232393','112','75','0','','100.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 ('2023-11-25 11:09:36','0','2400.00','0.00','0.00','0.00','0.00','100.00','1044827','LRN11220232393','112','76','0','','100.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 ('2023-11-25 11:09:36','0','2300.00','0.00','0.00','0.00','0.00','100.00','1044828','LRN11220232393','112','77','0','','100.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 ('2023-11-25 11:09:36','0','2200.00','0.00','0.00','0.00','0.00','100.00','1044829','LRN11220232393','112','78','0','','100.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 ('2023-11-25 11:09:36','0','2100.00','0.00','0.00','0.00','0.00','100.00','1044830','LRN11220232393','112','79','0','','100.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 ('2023-11-25 11:09:36','0','2000.00','0.00','0.00','0.00','0.00','100.00','1044831','LRN11220232393','112','80','0','','100.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 ('2023-11-25 11:09:36','0','1900.00','0.00','0.00','0.00','0.00','100.00','1044832','LRN11220232393','112','81','0','','100.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 ('2023-11-25 11:09:36','0','1800.00','0.00','0.00','0.00','0.00','100.00','1044833','LRN11220232393','112','82','0','','100.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 ('2023-11-25 11:09:36','0','1700.00','0.00','0.00','0.00','0.00','100.00','1044834','LRN11220232393','112','83','0','','100.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 ('2023-11-25 11:09:36','0','1600.00','0.00','0.00','0.00','0.00','100.00','1044835','LRN11220232393','112','84','0','','100.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 ('2023-11-25 11:09:36','0','1500.00','0.00','0.00','0.00','0.00','100.00','1044836','LRN11220232393','112','85','0','','100.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 ('2023-11-25 11:09:36','0','1400.00','0.00','0.00','0.00','0.00','100.00','1044837','LRN11220232393','112','86','0','','100.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 ('2023-11-25 11:09:36','0','1300.00','0.00','0.00','0.00','0.00','100.00','1044838','LRN11220232393','112','87','0','','100.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 ('2023-11-25 11:09:36','0','1200.00','0.00','0.00','0.00','0.00','100.00','1044839','LRN11220232393','112','88','0','','100.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 ('2023-11-25 11:09:36','0','1100.00','0.00','0.00','0.00','0.00','100.00','1044840','LRN11220232393','112','89','0','','100.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 ('2023-11-25 11:09:36','0','1000.00','0.00','0.00','0.00','0.00','100.00','1044841','LRN11220232393','112','90','0','','100.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 ('2023-11-25 11:09:36','0','900.00','0.00','0.00','0.00','0.00','100.00','1044842','LRN11220232393','112','91','0','','100.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 ('2023-11-25 11:09:36','0','800.00','0.00','0.00','0.00','0.00','100.00','1044843','LRN11220232393','112','92','0','','100.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 ('2023-11-25 11:09:36','0','700.00','0.00','0.00','0.00','0.00','100.00','1044844','LRN11220232393','112','93','0','','100.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 ('2023-11-25 11:09:36','0','600.00','0.00','0.00','0.00','0.00','100.00','1044845','LRN11220232393','112','94','0','','100.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 ('2023-11-25 11:09:36','0','500.00','0.00','0.00','0.00','0.00','100.00','1044846','LRN11220232393','112','95','0','','100.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 ('2023-11-25 11:09:36','0','400.00','0.00','0.00','0.00','0.00','100.00','1044847','LRN11220232393','112','96','0','','100.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 ('2023-11-25 11:09:36','0','300.00','0.00','0.00','0.00','0.00','100.00','1044848','LRN11220232393','112','97','0','','100.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 ('2023-11-25 11:09:36','0','200.00','0.00','0.00','0.00','0.00','100.00','1044849','LRN11220232393','112','98','0','','100.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 ('2023-11-25 11:09:36','0','100.00','0.00','0.00','0.00','0.00','100.00','1044850','LRN11220232393','112','99','0','','100.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 ('2023-11-25 11:09:36','0','0.00','0.00','0.00','0.00','0.00','100.00','1044851','LRN11220232393','112','100','0','','100.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 ('2023-11-25 11:09:56','0','13000.00','0.00','0.00','0.00','0.00','0.00','1044852','LRN11220232394','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 ('2023-11-25 11:09:56','0','12870.00','0.00','0.00','0.00','0.00','130.00','1044853','LRN11220232394','112','1','0','','130.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 ('2023-11-25 11:09:56','0','12740.00','0.00','0.00','0.00','0.00','130.00','1044854','LRN11220232394','112','2','0','','130.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 ('2023-11-25 11:09:56','0','12610.00','0.00','0.00','0.00','0.00','130.00','1044855','LRN11220232394','112','3','0','','130.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 ('2023-11-25 11:09:56','0','12480.00','0.00','0.00','0.00','0.00','130.00','1044856','LRN11220232394','112','4','0','','130.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 ('2023-11-25 11:09:56','0','12350.00','0.00','0.00','0.00','0.00','130.00','1044857','LRN11220232394','112','5','0','','130.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 ('2023-11-25 11:09:56','0','12220.00','0.00','0.00','0.00','0.00','130.00','1044858','LRN11220232394','112','6','0','','130.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 ('2023-11-25 11:09:56','0','12090.00','0.00','0.00','0.00','0.00','130.00','1044859','LRN11220232394','112','7','0','','130.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 ('2023-11-25 11:09:56','0','11960.00','0.00','0.00','0.00','0.00','130.00','1044860','LRN11220232394','112','8','0','','130.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 ('2023-11-25 11:09:56','0','11830.00','0.00','0.00','0.00','0.00','130.00','1044861','LRN11220232394','112','9','0','','130.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 ('2023-11-25 11:09:56','0','11700.00','0.00','0.00','0.00','0.00','130.00','1044862','LRN11220232394','112','10','0','','130.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 ('2023-11-25 11:09:56','0','11570.00','0.00','0.00','0.00','0.00','130.00','1044863','LRN11220232394','112','11','0','','130.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 ('2023-11-25 11:09:56','0','11440.00','0.00','0.00','0.00','0.00','130.00','1044864','LRN11220232394','112','12','0','','130.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 ('2023-11-25 11:09:56','0','11310.00','0.00','0.00','0.00','0.00','130.00','1044865','LRN11220232394','112','13','0','','130.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 ('2023-11-25 11:09:56','0','11180.00','0.00','0.00','0.00','0.00','130.00','1044866','LRN11220232394','112','14','0','','130.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 ('2023-11-25 11:09:56','0','11050.00','0.00','0.00','0.00','0.00','130.00','1044867','LRN11220232394','112','15','0','','130.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 ('2023-11-25 11:09:56','0','10920.00','0.00','0.00','0.00','0.00','130.00','1044868','LRN11220232394','112','16','0','','130.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 ('2023-11-25 11:09:56','0','10790.00','0.00','0.00','0.00','0.00','130.00','1044869','LRN11220232394','112','17','0','','130.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 ('2023-11-25 11:09:56','0','10660.00','0.00','0.00','0.00','0.00','130.00','1044870','LRN11220232394','112','18','0','','130.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 ('2023-11-25 11:09:56','0','10530.00','0.00','0.00','0.00','0.00','130.00','1044871','LRN11220232394','112','19','0','','130.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 ('2023-11-25 11:09:56','0','10400.00','0.00','0.00','0.00','0.00','130.00','1044872','LRN11220232394','112','20','0','','130.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 ('2023-11-25 11:09:56','0','10270.00','0.00','0.00','0.00','0.00','130.00','1044873','LRN11220232394','112','21','0','','130.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 ('2023-11-25 11:09:56','0','10140.00','0.00','0.00','0.00','0.00','130.00','1044874','LRN11220232394','112','22','0','','130.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 ('2023-11-25 11:09:56','0','10010.00','0.00','0.00','0.00','0.00','130.00','1044875','LRN11220232394','112','23','0','','130.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 ('2023-11-25 11:09:56','0','9880.00','0.00','0.00','0.00','0.00','130.00','1044876','LRN11220232394','112','24','0','','130.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 ('2023-11-25 11:09:56','0','9750.00','0.00','0.00','0.00','0.00','130.00','1044877','LRN11220232394','112','25','0','','130.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 ('2023-11-25 11:09:56','0','9620.00','0.00','0.00','0.00','0.00','130.00','1044878','LRN11220232394','112','26','0','','130.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 ('2023-11-25 11:09:56','0','9490.00','0.00','0.00','0.00','0.00','130.00','1044879','LRN11220232394','112','27','0','','130.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 ('2023-11-25 11:09:56','0','9360.00','0.00','0.00','0.00','0.00','130.00','1044880','LRN11220232394','112','28','0','','130.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 ('2023-11-25 11:09:56','0','9230.00','0.00','0.00','0.00','0.00','130.00','1044881','LRN11220232394','112','29','0','','130.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 ('2023-11-25 11:09:56','0','9100.00','0.00','0.00','0.00','0.00','130.00','1044882','LRN11220232394','112','30','0','','130.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 ('2023-11-25 11:09:56','0','8970.00','0.00','0.00','0.00','0.00','130.00','1044883','LRN11220232394','112','31','0','','130.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 ('2023-11-25 11:09:56','0','8840.00','0.00','0.00','0.00','0.00','130.00','1044884','LRN11220232394','112','32','0','','130.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 ('2023-11-25 11:09:56','0','8710.00','0.00','0.00','0.00','0.00','130.00','1044885','LRN11220232394','112','33','0','','130.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 ('2023-11-25 11:09:56','0','8580.00','0.00','0.00','0.00','0.00','130.00','1044886','LRN11220232394','112','34','0','','130.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 ('2023-11-25 11:09:56','0','8450.00','0.00','0.00','0.00','0.00','130.00','1044887','LRN11220232394','112','35','0','','130.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 ('2023-11-25 11:09:56','0','8320.00','0.00','0.00','0.00','0.00','130.00','1044888','LRN11220232394','112','36','0','','130.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 ('2023-11-25 11:09:56','0','8190.00','0.00','0.00','0.00','0.00','130.00','1044889','LRN11220232394','112','37','0','','130.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 ('2023-11-25 11:09:56','0','8060.00','0.00','0.00','0.00','0.00','130.00','1044890','LRN11220232394','112','38','0','','130.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 ('2023-11-25 11:09:56','0','7930.00','0.00','0.00','0.00','0.00','130.00','1044891','LRN11220232394','112','39','0','','130.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 ('2023-11-25 11:09:56','0','7800.00','0.00','0.00','0.00','0.00','130.00','1044892','LRN11220232394','112','40','0','','130.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 ('2023-11-25 11:09:56','0','7670.00','0.00','0.00','0.00','0.00','130.00','1044893','LRN11220232394','112','41','0','','130.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 ('2023-11-25 11:09:56','0','7540.00','0.00','0.00','0.00','0.00','130.00','1044894','LRN11220232394','112','42','0','','130.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 ('2023-11-25 11:09:56','0','7410.00','0.00','0.00','0.00','0.00','130.00','1044895','LRN11220232394','112','43','0','','130.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 ('2023-11-25 11:09:56','0','7280.00','0.00','0.00','0.00','0.00','130.00','1044896','LRN11220232394','112','44','0','','130.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 ('2023-11-25 11:09:56','0','7150.00','0.00','0.00','0.00','0.00','130.00','1044897','LRN11220232394','112','45','0','','130.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 ('2023-11-25 11:09:56','0','7020.00','0.00','0.00','0.00','0.00','130.00','1044898','LRN11220232394','112','46','0','','130.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 ('2023-11-25 11:09:56','0','6890.00','0.00','0.00','0.00','0.00','130.00','1044899','LRN11220232394','112','47','0','','130.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 ('2023-11-25 11:09:56','0','6760.00','0.00','0.00','0.00','0.00','130.00','1044900','LRN11220232394','112','48','0','','130.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 ('2023-11-25 11:09:56','0','6630.00','0.00','0.00','0.00','0.00','130.00','1044901','LRN11220232394','112','49','0','','130.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 ('2023-11-25 11:09:56','0','6500.00','0.00','0.00','0.00','0.00','130.00','1044902','LRN11220232394','112','50','0','','130.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 ('2023-11-25 11:09:56','0','6370.00','0.00','0.00','0.00','0.00','130.00','1044903','LRN11220232394','112','51','0','','130.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 ('2023-11-25 11:09:56','0','6240.00','0.00','0.00','0.00','0.00','130.00','1044904','LRN11220232394','112','52','0','','130.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 ('2023-11-25 11:09:56','0','6110.00','0.00','0.00','0.00','0.00','130.00','1044905','LRN11220232394','112','53','0','','130.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 ('2023-11-25 11:09:56','0','5980.00','0.00','0.00','0.00','0.00','130.00','1044906','LRN11220232394','112','54','0','','130.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 ('2023-11-25 11:09:56','0','5850.00','0.00','0.00','0.00','0.00','130.00','1044907','LRN11220232394','112','55','0','','130.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 ('2023-11-25 11:09:56','0','5720.00','0.00','0.00','0.00','0.00','130.00','1044908','LRN11220232394','112','56','0','','130.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 ('2023-11-25 11:09:56','0','5590.00','0.00','0.00','0.00','0.00','130.00','1044909','LRN11220232394','112','57','0','','130.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 ('2023-11-25 11:09:56','0','5460.00','0.00','0.00','0.00','0.00','130.00','1044910','LRN11220232394','112','58','0','','130.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 ('2023-11-25 11:09:56','0','5330.00','0.00','0.00','0.00','0.00','130.00','1044911','LRN11220232394','112','59','0','','130.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 ('2023-11-25 11:09:56','0','5200.00','0.00','0.00','0.00','0.00','130.00','1044912','LRN11220232394','112','60','0','','130.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 ('2023-11-25 11:09:56','0','5070.00','0.00','0.00','0.00','0.00','130.00','1044913','LRN11220232394','112','61','0','','130.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 ('2023-11-25 11:09:56','0','4940.00','0.00','0.00','0.00','0.00','130.00','1044914','LRN11220232394','112','62','0','','130.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 ('2023-11-25 11:09:56','0','4810.00','0.00','0.00','0.00','0.00','130.00','1044915','LRN11220232394','112','63','0','','130.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 ('2023-11-25 11:09:56','0','4680.00','0.00','0.00','0.00','0.00','130.00','1044916','LRN11220232394','112','64','0','','130.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 ('2023-11-25 11:09:56','0','4550.00','0.00','0.00','0.00','0.00','130.00','1044917','LRN11220232394','112','65','0','','130.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 ('2023-11-25 11:09:56','0','4420.00','0.00','0.00','0.00','0.00','130.00','1044918','LRN11220232394','112','66','0','','130.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 ('2023-11-25 11:09:56','0','4290.00','0.00','0.00','0.00','0.00','130.00','1044919','LRN11220232394','112','67','0','','130.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 ('2023-11-25 11:09:56','0','4160.00','0.00','0.00','0.00','0.00','130.00','1044920','LRN11220232394','112','68','0','','130.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 ('2023-11-25 11:09:56','0','4030.00','0.00','0.00','0.00','0.00','130.00','1044921','LRN11220232394','112','69','0','','130.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 ('2023-11-25 11:09:56','0','3900.00','0.00','0.00','0.00','0.00','130.00','1044922','LRN11220232394','112','70','0','','130.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 ('2023-11-25 11:09:56','0','3770.00','0.00','0.00','0.00','0.00','130.00','1044923','LRN11220232394','112','71','0','','130.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 ('2023-11-25 11:09:56','0','3640.00','0.00','0.00','0.00','0.00','130.00','1044924','LRN11220232394','112','72','0','','130.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 ('2023-11-25 11:09:56','0','3510.00','0.00','0.00','0.00','0.00','130.00','1044925','LRN11220232394','112','73','0','','130.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 ('2023-11-25 11:09:56','0','3380.00','0.00','0.00','0.00','0.00','130.00','1044926','LRN11220232394','112','74','0','','130.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 ('2023-11-25 11:09:56','0','3250.00','0.00','0.00','0.00','0.00','130.00','1044927','LRN11220232394','112','75','0','','130.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 ('2023-11-25 11:09:56','0','3120.00','0.00','0.00','0.00','0.00','130.00','1044928','LRN11220232394','112','76','0','','130.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 ('2023-11-25 11:09:56','0','2990.00','0.00','0.00','0.00','0.00','130.00','1044929','LRN11220232394','112','77','0','','130.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 ('2023-11-25 11:09:56','0','2860.00','0.00','0.00','0.00','0.00','130.00','1044930','LRN11220232394','112','78','0','','130.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 ('2023-11-25 11:09:56','0','2730.00','0.00','0.00','0.00','0.00','130.00','1044931','LRN11220232394','112','79','0','','130.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 ('2023-11-25 11:09:56','0','2600.00','0.00','0.00','0.00','0.00','130.00','1044932','LRN11220232394','112','80','0','','130.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 ('2023-11-25 11:09:56','0','2470.00','0.00','0.00','0.00','0.00','130.00','1044933','LRN11220232394','112','81','0','','130.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 ('2023-11-25 11:09:56','0','2340.00','0.00','0.00','0.00','0.00','130.00','1044934','LRN11220232394','112','82','0','','130.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 ('2023-11-25 11:09:56','0','2210.00','0.00','0.00','0.00','0.00','130.00','1044935','LRN11220232394','112','83','0','','130.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 ('2023-11-25 11:09:56','0','2080.00','0.00','0.00','0.00','0.00','130.00','1044936','LRN11220232394','112','84','0','','130.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 ('2023-11-25 11:09:56','0','1950.00','0.00','0.00','0.00','0.00','130.00','1044937','LRN11220232394','112','85','0','','130.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 ('2023-11-25 11:09:56','0','1820.00','0.00','0.00','0.00','0.00','130.00','1044938','LRN11220232394','112','86','0','','130.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 ('2023-11-25 11:09:56','0','1690.00','0.00','0.00','0.00','0.00','130.00','1044939','LRN11220232394','112','87','0','','130.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 ('2023-11-25 11:09:56','0','1560.00','0.00','0.00','0.00','0.00','130.00','1044940','LRN11220232394','112','88','0','','130.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 ('2023-11-25 11:09:56','0','1430.00','0.00','0.00','0.00','0.00','130.00','1044941','LRN11220232394','112','89','0','','130.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 ('2023-11-25 11:09:56','0','1300.00','0.00','0.00','0.00','0.00','130.00','1044942','LRN11220232394','112','90','0','','130.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 ('2023-11-25 11:09:56','0','1170.00','0.00','0.00','0.00','0.00','130.00','1044943','LRN11220232394','112','91','0','','130.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 ('2023-11-25 11:09:56','0','1040.00','0.00','0.00','0.00','0.00','130.00','1044944','LRN11220232394','112','92','0','','130.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 ('2023-11-25 11:09:56','0','910.00','0.00','0.00','0.00','0.00','130.00','1044945','LRN11220232394','112','93','0','','130.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 ('2023-11-25 11:09:56','0','780.00','0.00','0.00','0.00','0.00','130.00','1044946','LRN11220232394','112','94','0','','130.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 ('2023-11-25 11:09:56','0','650.00','0.00','0.00','0.00','0.00','130.00','1044947','LRN11220232394','112','95','0','','130.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 ('2023-11-25 11:09:56','0','520.00','0.00','0.00','0.00','0.00','130.00','1044948','LRN11220232394','112','96','0','','130.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 ('2023-11-25 11:09:56','0','390.00','0.00','0.00','0.00','0.00','130.00','1044949','LRN11220232394','112','97','0','','130.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 ('2023-11-25 11:09:56','0','260.00','0.00','0.00','0.00','0.00','130.00','1044950','LRN11220232394','112','98','0','','130.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 ('2023-11-25 11:09:56','0','130.00','0.00','0.00','0.00','0.00','130.00','1044951','LRN11220232394','112','99','0','','130.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 ('2023-11-25 11:09:56','0','0.00','0.00','0.00','0.00','0.00','130.00','1044952','LRN11220232394','112','100','0','','130.00'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10807','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:44:33','027','25000.00','1','AN1132023111906','11320230348','TULABOT','DONNA DHAY','CUTCHON','','','','','0','','0000-00-00','25000.00','2023-11-25','TC2','011','WITH CHECK','25000.00','031','2023-11-25 11:18:58','0','RENEWAL','031','2023-11-25 10:14:55','113','2023-11-27 12:45:53'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10808','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 13:23:43','027','22000.00','1','AN1132023111907','11320230237','BERMUDO','ALMA','DOMINGO','','','','','0','','0000-00-00','22000.00','2023-11-25','TC4','016','WITH CHECK','22000.00','031','2023-11-25 11:05:34','0','RENEWAL','031','2023-11-25 10:16:11','113','2023-11-27 13:25:15'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10809','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:44:33','027','28000.00','1','AN1132023111908','11320220040','DANOCUP','EVELYN','MANANSALA','','','','','0','','0000-00-00','28000.00','2023-11-25','TC7','','WITH CHECK','28000.00','031','2023-11-25 11:12:36','0','RENEWAL','031','2023-11-25 10:17:30','113','2023-11-27 12:45:53'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('LRN11320234208','','','2023-11-29','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10810','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:44:33','027','40000.00','1','AN1132023111909','11320220188','PAMINTUAN','JANETTE','MARTIN','','','','','0','','0000-00-00','40000.00','2023-11-25','TC6','029','Released','40000.00','031','2023-11-25 11:16:57','0','RENEWAL','031','2023-11-25 10:18:43','113','2023-11-29 14:47:32'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10811','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 13:23:43','027','60000.00','1','AN1132023111911','11320190648','BERNABE','MARIA DOLORES','MERCADO','','','','','0','','0000-00-00','60000.00','2023-11-25','TC2','011','WITH CHECK','60000.00','031','2023-11-25 11:06:27','0','RENEWAL','031','2023-11-25 10:20:52','113','2023-11-27 13:25:56'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('LRN11320234215','','','2023-11-29','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10812','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 13:23:43','027','12000.00','1','AN1132023111913','11320230374','DENOSO','LORELYN','SUTABINTO','','','','','0','','0000-00-00','15000.00','2023-11-25','TC8','038','Released','15000.00','031','2023-11-25 11:13:33','0','RENEWAL','031','2023-11-25 10:22:54','113','2023-11-29 14:37:05'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('LRN11320234224','','','2023-11-29','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10813','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 13:23:43','027','15000.00','1','AN1132023111914','11320230263','CALMA','ELENOR','MALUBAY','','','','','0','','0000-00-00','15000.00','2023-11-25','TC6','029','Released','15000.00','031','2023-11-25 11:10:28','0','RENEWAL','031','2023-11-25 10:23:54','113','2023-11-29 15:13:33'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('LRN11220232399','','','2023-11-28','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10814','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:23:12','027','15000.00','1','AN1122023111061','11220232183','SOLIS','MELANIE','MAGPUSAO','','','','','0','','0000-00-00','15000.00','2023-11-25','4CLC','004i','Released','15000.00','015','2023-11-25 10:27:59','0','RENEWAL','015','2023-11-25 10:24:24','112','2023-11-28 11:35:33'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10815','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:44:33','027','17000.00','1','AN1132023111915','11320220069','CALABIT','NINO REYMOND','FERRER','','','','','0','','0000-00-00','17000.00','2023-11-25','TC4','016','WITH CHECK','17000.00','031','2023-11-25 11:09:37','0','RENEWAL','031','2023-11-25 10:24:43','113','2023-11-27 12:45:53'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10816','UBP','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:23:12','027','15000.00','1','AN1122023111062','11220232114','DELMONTE','CECILIA','MALLARI','','','','','0','','0000-00-00','15000.00','2023-11-25','13CLC','042','WITH CHECK','15000.00','015','2023-11-25 10:27:02','0','RENEWAL','015','2023-11-25 10:25:31','112','2023-11-27 12:24:35'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10817','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 13:23:43','027','10000.00','1','AN1132023111916','11320210936','BUCU','ELINO','TANJUAKIO','','','','','0','','0000-00-00','10000.00','2023-11-25','TC6','029','WITH CHECK','10000.00','031','2023-11-25 11:07:26','0','RENEWAL','031','2023-11-25 10:25:47','113','2023-11-27 13:25:15'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('LRN11320234219','','','2023-11-29','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10818','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:44:33','027','18000.00','1','AN1132023111917','11320200919','GALSIM','JERRY','DOMINGO','','','','','0','','0000-00-00','18000.00','2023-11-25','TC4','016','Released','18000.00','031','2023-11-25 11:14:42','0','RENEWAL','031','2023-11-25 10:26:49','113','2023-11-29 14:40:05'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('LRN11320234223','','','2023-11-29','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10819','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:44:33','027','17000.00','1','AN1132023111918','11320180144','MEJIA','REGGIE','DAVID','','','','','0','','0000-00-00','17000.00','2023-11-25','TC4','016','Released','17000.00','031','2023-11-25 11:15:50','0','RENEWAL','031','2023-11-25 10:27:46','113','2023-11-29 14:45:02'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10820','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 12:44:33','027','19000.00','1','AN1132023111919','11320180358','BUSTARDE','EMMANUEL','PAGCO','','','','','0','','0000-00-00','19000.00','2023-11-25','TC4','016','WITH CHECK','19000.00','031','2023-11-25 11:08:36','0','RENEWAL','031','2023-11-25 10:28:42','113','2023-11-27 12:45:53'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('','','','','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10821','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 13:23:43','027','10000.00','1','AN1132023111920','11320230252','SUMAWANG','ILENE','POLICARPIO','','','','','0','','0000-00-00','10000.00','2023-11-25','TC3','014','WITH CHECK','10000.00','031','2023-11-25 11:17:53','0','RENEWAL','031','2023-11-25 10:29:21','113','2023-11-27 13:25:15'); INSERT INTO `pros_application` (temp_pnumber,app_ho_date,app_ho_edit,app_contract_printing,dateForwaredtoBH,reasonFADisapproved,recAmount,faREcommendation,dateReturned,dateEndorsed,app_ID,app_bank,app_disbursement,app_mode_of_payment,app_payment_terms,app_terms,app_interest_deduct,app_interest_rate,ho_cancellationDAdate,ho_cancellationDAby,ho_cancellationDA,hoApprovedDate,hoApprvoedBy,app_ho_approved_amt,app_product,app_Number,app_AccountNo,app_LastName,app_FirstName,app_MiddleName,app_Suffix,app_HouseNo,app_Street,app_Subd,app_Brgy,app_municipality,app_BirthDay,app_AppliedAmt,app_Date_Applied,app_Area,app_MarketBy,app_Status,app_recAmt,app_AppDisBy,app_AppDisDate,app_Reason_Cancellation,app_Type,app_Entry,app_EntryDate,app_Branch,app_timestamp) VALUES ('LRN11320234216','','','2023-11-29','0000-00-00','0','0.00','','0000-00-00','0000-00-00','10822','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-11-27 13:23:43','027','20000.00','1','AN1132023111921','11320220031','CORCUERA','MHAY','PABION','','','','','0','','0000-00-00','20000.00','2023-11-25','TC6','029','Released','20000.00','031','2023-11-25 11:11:43','0','RENEWAL','031','2023-11-25 10:30:17','113','2023-11-29 14:34:50'); UPDATE pros_application SET temp_pnumber='LRN11220232393',app_ho_date='',app_ho_edit='',app_contract_printing='2023-11-25',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='2023-11-22 16:11:57',hoApprvoedBy='027',app_ho_approved_amt='10000.00',app_Entry='015',app_EntryDate='2023-11-21 11:46:06',app_Branch='112',app_timestamp='2023-11-25 11:10:59',app_Number='AN1122023111049',app_AccountNo='11220232128',app_LastName='LOPEZ',app_FirstName='OLIVIA',app_MiddleName='PINGOL',app_Suffix='',app_HouseNo='',app_Street='',app_Subd='',app_Brgy='0',app_municipality='',app_BirthDay='0000-00-00',app_AppliedAmt='10000.00',app_Date_Applied='2023-11-21',app_Area='4CLC',app_MarketBy='004i',app_Status='Released',app_recAmt='10000.00',app_AppDisBy='015',app_AppDisDate='2023-11-21 11:52:36',app_Reason_Cancellation='0',app_Type='RENEWAL' WHERE app_Number = 'AN1122023111049'; UPDATE pros_application SET temp_pnumber='LRN11220232394',app_ho_date='',app_ho_edit='',app_contract_printing='2023-11-25',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='2023-11-22 16:11:57',hoApprvoedBy='027',app_ho_approved_amt='13000.00',app_Entry='015',app_EntryDate='2023-11-21 11:50:01',app_Branch='112',app_timestamp='2023-11-25 11:11:35',app_Number='AN1122023111052',app_AccountNo='11220221909',app_LastName='MARIANO',app_FirstName='DANIKA',app_MiddleName='MANALASTAS',app_Suffix='',app_HouseNo='',app_Street='',app_Subd='',app_Brgy='0',app_municipality='',app_BirthDay='0000-00-00',app_AppliedAmt='13000.00',app_Date_Applied='2023-11-21',app_Area='3CLC',app_MarketBy='006',app_Status='Released',app_recAmt='13000.00',app_AppDisBy='015',app_AppDisDate='2023-11-21 11:54:30',app_Reason_Cancellation='0',app_Type='RENEWAL' WHERE app_Number = 'AN1122023111052';