UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233184', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '1750.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:12:45', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:12:45' WHERE coll_UnikOR = '114-63425' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233211', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '1400.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:12:47', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:12:47' WHERE coll_UnikOR = '114-63426' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420210747', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '300.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:12:49', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:12:49' WHERE coll_UnikOR = '114-63427' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232963', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '3000.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:12:51', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:12:51' WHERE coll_UnikOR = '114-63428' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232536', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '250.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:12:53', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:12:53' WHERE coll_UnikOR = '114-63429' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233188', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '1960.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:12:55', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:12:55' WHERE coll_UnikOR = '114-63430' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232966', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '700.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:12:57', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:12:57' WHERE coll_UnikOR = '114-63431' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233097', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '150.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:00', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:00' WHERE coll_UnikOR = '114-63432' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232936', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '1200.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:02', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:02' WHERE coll_UnikOR = '114-63433' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233150', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '600.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:06', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:06' WHERE coll_UnikOR = '114-63434' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233007', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '770.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:08', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:08' WHERE coll_UnikOR = '114-63435' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233175', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '1400.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:10', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:10' WHERE coll_UnikOR = '114-63436' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233213', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '450.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:12', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:12' WHERE coll_UnikOR = '114-63437' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232967', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '700.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:14', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:14' WHERE coll_UnikOR = '114-63438' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232968', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '3150.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:16', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:16' WHERE coll_UnikOR = '114-63439' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233101', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '2160.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:18', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:18' WHERE coll_UnikOR = '114-63440' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233079', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '700.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:20', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:20' WHERE coll_UnikOR = '114-63441' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233165', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '700.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:22', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:22' WHERE coll_UnikOR = '114-63442' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420233104', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '700.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:24', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:24' WHERE coll_UnikOR = '114-63443' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232882', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '1700.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:26', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:11:50', coll_timestamp= '2023-12-17 10:13:26' WHERE coll_UnikOR = '114-63444' and coll_Branch = '114'; 
UPDATE cust_collection SET coll_ho_date='',coll_ho_edit='',dmcmorDate='0000-00-00',dmcm='',coll_type='0',coll_pdi='0.00',coll_prn='0',coll_other_charges1='0.00',coll_other_charges='0.00',coll_penalty='0.00',coll_interest='0.00',coll_prn_amt='0.00',coll_Area='B1', coll_SalesloanNo= 'LRN11420232971', coll_OrDate= '2023-12-08', coll_TypePayment= '0', coll_OrNumber= '', coll_Amount= '170.00', coll_Remarks= '', coll_CollectedBy= '001B', coll_Interbranch= '0', coll_OriginalBranch= '114', coll_ApprovedBy= '002B', coll_ApprovedDate= '2023-12-17 10:13:04', coll_Void= '0', coll_Voiddate= '0000-00-00 00:00:00', coll_ReasonVoid= '0', coll_CreatedBy= '002B', coll_Createddate= '2023-12-15 12:49:57', coll_timestamp= '2023-12-17 10:13:04' WHERE coll_UnikOR = '114-63504' and coll_Branch = '114'; 
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='-1400.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='-130144.00',sales_prin_amt='-673256.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-06-13 11:53:29',sales_Timestamp='2023-12-17 09:52:52',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='11400.00',sales_PaymentCutoff='1600.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-06-13 19:38:54',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420221157',sales_AssignTo='',sales_PNumber='LRN11420232484',sales_Amt='10000.00',sales_Area='B9',sales_Cycle='3',sales_Released='2023-06-13',sales_Maturity='2023-09-21',sales_BegBalance='10000.00',sales_LPD='2023-09-08' WHERE sales_PNumber = 'LRN11420232484' ; 
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='002B',sales_PostedDate='2023-12-11 12:15:57',sales_Timestamp='2023-12-17 10:13:12',sales_Due='0.00',sales_Overdue='0.00',sales_Payment='450.00',sales_PaymentCutoff='450.00',sales_Status='ACTIVE',sales_ValidatedBy='002B',sales_ValidatedDate='2023-12-11 12:31:39',sales_IncentiveClaim='0000-00-00',sales_AccountNo='11420210912',sales_AssignTo='',sales_PNumber='LRN11420233213',sales_Amt='15000.00',sales_Area='B1',sales_Cycle='10',sales_Released='2023-12-11',sales_Maturity='2024-03-20',sales_BegBalance='15000.00',sales_LPD='2023-12-08' WHERE sales_PNumber = 'LRN11420233213' ;