Update Invoice Number from Backend

Modified on Tue, 25 Feb at 2:08 AM

WE need to update the invoice number for the following tables

select * from fs_Orders where invoice='51'

select * from fs_Orders_audit where invoice='51'

select * from payment_details where invoice='51'

select * from hanauseraudit where invoice='51'

select * from CCTransactionLog where invoice='51'

select * from CCRequestsResponses where invoice='51'

select * from PrintJobs where invoice='51'

select * from fs_orders_items where invoice='51'

select * from fs_orders_items_audit where invoice='51'

--update fs_Orders set invoice='75088345' where invoice='51'

--update fs_Orders_audit set invoice='75088345' where invoice='51'

--update fs_orders_items set invoice='75088345' where invoice='51'

--update fs_orders_items_audit set invoice='75088345' where invoice='51'

--update payment_details set invoice='75088345' where invoice='51'

--update hanauseraudit set invoice='75088345' where invoice='51'

--update CCTransactionLog set invoice='75088345' where invoice='51'

--update CCRequestsResponses set invoice='75088345' where invoice='51'

--update PrintJobs set invoice='75088345' where invoice='51'