/* TK25579 Reassign Debtor with Trades and Receipts */
-- debtor ID: 7491
-- old org ID: 1676
-- old trader ID: 1809
-- new org ID: 1835
-- new traded ID: 1967

UPDATE debtor_relation SET trader_id=1967, organisation_id=1835 WHERE debtor_id=7491;
UPDATE invoice_master SET user_id=1967 WHERE debtor_id=7491;
UPDATE manual_transactions SET originator_id=1967 WHERE manual_transaction_id = 205909;

--Batches: 100857, 100990, 101068, 101578

UPDATE spool_transactions SET originator_id=1835 WHERE batch_id IN (100857, 100990, 101068, 101578);


--New Originator CRM ID: 0011v00002z6XFGAA2
--Old Originator CRM ID: 0011v00002NepHZAAZ