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='8328.00',sales_prin_amt='53722.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='2022-08-22 16:06:19',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-08-22 16:29:24',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221124',sales_AssignTo='',sales_PNumber='LRN11420221568',sales_Amt='10000.00',sales_Area='B5',sales_Cycle='1',sales_Released='2022-08-22',sales_Maturity='2022-11-30',sales_BegBalance='10000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221568' ; 
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='116592.00',sales_prin_amt='627108.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='2022-10-17 15:41:47',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='15000.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-10-17 17:02:05',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221115',sales_AssignTo='',sales_PNumber='LRN11420221719',sales_Amt='15000.00',sales_Area='B5',sales_Cycle='2',sales_Released='2022-10-17',sales_Maturity='2023-01-25',sales_BegBalance='15000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221719' ; 
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='-1730.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='34977.60',sales_prin_amt='198632.40',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='2022-11-10 16:49:49',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='16730.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-11-10 16:52:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221037',sales_AssignTo='',sales_PNumber='LRN11420221786',sales_Amt='15000.00',sales_Area='B5',sales_Cycle='4',sales_Released='2022-11-10',sales_Maturity='2023-02-18',sales_BegBalance='15000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221786' ; 
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='-2100.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='98280.00',sales_prin_amt='530970.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='2022-11-17 16:12:58',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='17100.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-11-17 16:57:20',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221129',sales_AssignTo='',sales_PNumber='LRN11420221803',sales_Amt='15000.00',sales_Area='B5',sales_Cycle='2',sales_Released='2022-11-17',sales_Maturity='2023-02-25',sales_BegBalance='15000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221803' ; 
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='139920.00',sales_prin_amt='744580.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='2022-11-23 14:35:04',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-11-23 16:43:09',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180493',sales_AssignTo='',sales_PNumber='LRN11420221816',sales_Amt='10000.00',sales_Area='B1',sales_Cycle='9',sales_Released='2022-11-23',sales_Maturity='2023-03-03',sales_BegBalance='10000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221816' ; 
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='32648.00',sales_prin_amt='181402.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='2022-12-12 18:45:52',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-12-12 18:48:51',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180297',sales_AssignTo='',sales_PNumber='LRN11420221859',sales_Amt='10000.00',sales_Area='B1',sales_Cycle='4',sales_Released='2022-12-12',sales_Maturity='2023-03-22',sales_BegBalance='10000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221859' ; 
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='139920.00',sales_prin_amt='754580.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='2022-12-14 10:16:12',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-12-14 10:18:39',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420190543',sales_AssignTo='',sales_PNumber='LRN11420221863',sales_Amt='20000.00',sales_Area='B1',sales_Cycle='9',sales_Released='2022-12-14',sales_Maturity='2023-03-24',sales_BegBalance='20000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221863' ; 
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='600.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='60000.00',sales_interest_amt='79968.00',sales_prin_amt='479832.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='2022-12-14 15:38:58',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='60000.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2022-12-14 15:40:16',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180467',sales_AssignTo='',sales_PNumber='LRN11420221867',sales_Amt='60000.00',sales_Area='B5',sales_Cycle='9',sales_Released='2022-12-14',sales_Maturity='2023-03-24',sales_BegBalance='60000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420221867' ; 
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='97944.00',sales_prin_amt='529206.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-01-27 17:12:47',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='15000.00',sales_PaymentCutoff='2400.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-01-27 19:19:30',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210929',sales_AssignTo='',sales_PNumber='LRN11420231977',sales_Amt='15000.00',sales_Area='B1',sales_Cycle='8',sales_Released='2023-01-27',sales_Maturity='2023-05-07',sales_BegBalance='15000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420231977' ; 
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='450.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='45000.00',sales_interest_amt='181896.00',sales_prin_amt='999954.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-01-31 11:38:03',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='45000.00',sales_PaymentCutoff='9800.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-01-31 15:27:48',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180215',sales_AssignTo='',sales_PNumber='LRN11420231988',sales_Amt='45000.00',sales_Area='B1',sales_Cycle='9',sales_Released='2023-01-31',sales_Maturity='2023-05-11',sales_BegBalance='45000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420231988' ; 
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='303160.00',sales_prin_amt='1616590.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-01-31 11:40:23',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='25000.00',sales_PaymentCutoff='5925.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-01-31 15:27:48',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420211006',sales_AssignTo='',sales_PNumber='LRN11420231989',sales_Amt='25000.00',sales_Area='B1',sales_Cycle='6',sales_Released='2023-01-31',sales_Maturity='2023-05-11',sales_BegBalance='25000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420231989' ; 
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='130592.00',sales_prin_amt='705608.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-02-07 16:47:58',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='20000.00',sales_PaymentCutoff='2600.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-02-07 16:49:45',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420180044',sales_AssignTo='',sales_PNumber='LRN11420231998',sales_Amt='20000.00',sales_Area='B1',sales_Cycle='10',sales_Released='2023-02-07',sales_Maturity='2023-05-18',sales_BegBalance='20000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420231998' ; 
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='-823952.00',sales_prin_amt='-4315748.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-03-15 16:48:22',sales_Timestamp='2023-08-27 04:47:49',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='10000.00',sales_PaymentCutoff='3000.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-03-15 16:49:02',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420231214',sales_AssignTo='',sales_PNumber='LRN11420232118',sales_Amt='10000.00',sales_Area='B6',sales_Cycle='1',sales_Released='2023-03-15',sales_Maturity='2023-06-23',sales_BegBalance='10000.00',sales_LPD='2023-05-18' WHERE sales_PNumber = 'LRN11420232118' ; 
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','9803','EWB','Check','Cash','Daily','100','Advance','16.00','0000-00-00 00:00:00','','','2023-08-29 12:47:40','027','10000.00','1','AN1142023081156','','CORO','LEONORA','CUYA','','','','','8668','ALITAGTAG','1977-01-12','10000.00','2023-08-27','B7','003B','WITH CHECK','10000.00','002B','2023-08-29 11:31:55','0','NEW','002B','2023-08-27 04:51:09','114','2023-08-29 12:52:00');
