INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B1','Deposited','2024-01-11','169','2024-01-11','700.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:03:45','2024-01-28 17:03:45');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B1','Undeposited','2024-01-11','0','0000-00-00','170.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:03:45','2024-01-28 17:03:45');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B2','Deposited','2024-01-11','169','2024-01-11','31350.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:08:16','2024-01-28 17:08:16');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B5','Deposited','2024-01-11','164','2024-01-11','6780.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:08:58','2024-01-28 17:08:58');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B6','Deposited','2024-01-11','164','2024-01-11','7810.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:09:37','2024-01-28 17:09:37');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B7','Deposited','2024-01-11','169','2024-01-11','4020.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:10:25','2024-01-28 17:10:25');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B7','Undeposited','2024-01-11','0','0000-00-00','910.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:10:25','2024-01-28 17:10:25');
INSERT INTO `fund_collection_status` (coll_status_branch,coll_status_area,coll_status_type,coll_status_date,coll_status_bank,coll_status_deposited_date,coll_status_amount,coll_status_over,coll_status_shortage,coll_status_remarks,coll_status,coll_status_created,coll_status_created_date,coll_status_timestamp) VALUES 
('114','B9','Deposited','2024-01-11','169','2024-01-11','21750.00','0.00','0.00','','ACTIVE','002B','2024-01-28 17:11:06','2024-01-28 17:11:06');
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='650.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='65000.00',sales_interest_amt='-114816.00',sales_prin_amt='-537784.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-07-19 15:54:21',sales_Timestamp='2024-01-28 17:12:25',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='65000.00',sales_PaymentCutoff='12100.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-07-20 17:19:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221130',sales_AssignTo='',sales_PNumber='LRN11420232660',sales_Amt='65000.00',sales_Area='B1',sales_Cycle='5',sales_Released='2023-07-19',sales_Maturity='2023-10-27',sales_BegBalance='65000.00',sales_LPD='2023-10-20' WHERE sales_PNumber = 'LRN11420232660' ; 
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='250.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='25000.00',sales_interest_amt='-281960.00',sales_prin_amt='-1455290.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-08-07 14:13:34',sales_Timestamp='2024-01-28 17:12:25',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='25000.00',sales_PaymentCutoff='9500.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-08-07 16:55:09',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210896',sales_AssignTo='',sales_PNumber='LRN11420232729',sales_Amt='25000.00',sales_Area='B9',sales_Cycle='11',sales_Released='2023-08-07',sales_Maturity='2023-11-15',sales_BegBalance='25000.00',sales_LPD='2023-10-20' WHERE sales_PNumber = 'LRN11420232729' ; 
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='200.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='20000.00',sales_interest_amt='0.00',sales_prin_amt='20000.00',sales_other_charger1='0.00',sales_other_charges='0.00',sales_penalty='0.00',sales_other_charger1_bal='0.00',sales_other_charges_bal='0.00',sales_penalty_bal='0.00',sales_Void='0',sales_PostedBy='002B',sales_PostedDate='2023-09-28 14:52:04',sales_Timestamp='2024-01-28 17:00:09',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='790.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-09-28 15:00:10',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231352',sales_AssignTo='',sales_PNumber='LRN11420232965',sales_Amt='20000.00',sales_Area='B2',sales_Cycle='2',sales_Released='2023-09-28',sales_Maturity='2024-01-06',sales_BegBalance='20000.00',sales_LPD='2024-01-11' WHERE sales_PNumber = 'LRN11420232965' ; 
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='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='002B',sales_PostedDate='2023-10-09 15:50:35',sales_Timestamp='2024-01-28 17:00:09',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12000.00',sales_PaymentCutoff='1060.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-10-09 15:59:11',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210947',sales_AssignTo='',sales_PNumber='LRN11420233000',sales_Amt='12000.00',sales_Area='B2',sales_Cycle='10',sales_Released='2023-10-09',sales_Maturity='2024-01-17',sales_BegBalance='12000.00',sales_LPD='2024-01-11' WHERE sales_PNumber = 'LRN11420233000' ; 
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='-100.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='002B',sales_PostedDate='2023-10-11 14:31:30',sales_Timestamp='2024-01-28 17:00:09',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12100.00',sales_PaymentCutoff='2420.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-10-11 16:19:46',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231417',sales_AssignTo='',sales_PNumber='LRN11420233002',sales_Amt='12000.00',sales_Area='B9',sales_Cycle='2',sales_Released='2023-10-10',sales_Maturity='2024-01-18',sales_BegBalance='12000.00',sales_LPD='2024-01-11' WHERE sales_PNumber = 'LRN11420233002' ;