UPDATE fund_sales SET sales_ho_date='2023-06-07 17:46:26',sales_ho_edit='008',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='170.00',pdi_amount='0.00',penalty_amount='0.00',penalty_percent='0.00',sales_interest_bal='0.00',sales_prin_bal='17000.00',sales_interest_amt='37824.00',sales_prin_amt='215576.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-06-01 14:41:39',sales_Timestamp='2023-12-23 10:35:02',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='17000.00',sales_PaymentCutoff='0.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-06-01 14:56:14',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320190608',sales_AssignTo='014',sales_PNumber='LRN11320233465',sales_Amt='17000.00',sales_Area='TC3',sales_Cycle='3',sales_Released='2023-05-31',sales_Maturity='2023-09-08',sales_BegBalance='17000.00',sales_LPD='2023-09-14' WHERE sales_PNumber = 'LRN11320233465' ; 
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='-2890.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='-58016.00',sales_prin_amt='-294584.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-07-25 15:03:24',sales_Timestamp='2023-12-23 10:35:03',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='12890.00',sales_PaymentCutoff='4600.00',sales_Status='ACTIVE',sales_ValidatedBy='031',sales_ValidatedDate='2023-07-25 15:12:41',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11320230239',sales_AssignTo='011',sales_PNumber='LRN11320233671',sales_Amt='10000.00',sales_Area='TC2',sales_Cycle='3',sales_Released='2023-07-25',sales_Maturity='2023-11-02',sales_BegBalance='10000.00',sales_LPD='2023-09-15' WHERE sales_PNumber = 'LRN11320233671' ; 
