INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5239'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5239 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='82' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (1081);
UPDATE invoice_master
                                             SET manual_transaction_id = 82, auto_assign = 0
                                             WHERE invoice_id IN (652,691,878,904,952,990,1029,1081);
DELETE FROM invoice_reserve WHERE invoice_id IN (1081);
DELETE FROM `manual_transactions`  WHERE `manual_transaction_id` ='5239';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5239';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5239' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5247'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5247 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='84' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (467,486,535,2471,2850);
UPDATE invoice_master
                                             SET manual_transaction_id = 84, auto_assign = 0
                                             WHERE invoice_id IN (467,486,535,2471,2850);
DELETE FROM invoice_reserve WHERE invoice_id IN (467,486,535,2471,2850);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5247';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5247';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5247' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5276'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5276 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='102' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (715,717);
UPDATE invoice_master
                                             SET manual_transaction_id = 102, auto_assign = 0
                                             WHERE invoice_id IN (715,717);
DELETE FROM invoice_reserve WHERE invoice_id IN (715,717);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5276';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5276';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5276' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4560'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4560 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='210' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (232,233,234,235,237,238);
UPDATE invoice_master
                                             SET manual_transaction_id = 210, auto_assign = 0
                                             WHERE invoice_id IN (232,233,234,235,237,238);
DELETE FROM invoice_reserve WHERE invoice_id IN (232,233,234,235,237,238);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4560';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4560';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4560' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4581'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4581 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='220' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (1071);
UPDATE invoice_master
                                             SET manual_transaction_id = 220, auto_assign = 0
                                             WHERE invoice_id IN (1071);
DELETE FROM invoice_reserve WHERE invoice_id IN (1071);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4581';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4581';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4581' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4577'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4577 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='301' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (857);
UPDATE invoice_master
                                             SET manual_transaction_id = 301, auto_assign = 0
                                             WHERE invoice_id IN (857);
DELETE FROM invoice_reserve WHERE invoice_id IN (857);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4577';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4577';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4577' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5322'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5322 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='389' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2162,2251);
UPDATE invoice_master
                                             SET manual_transaction_id = 389, auto_assign = 0
                                             WHERE invoice_id IN (2162,2251);
DELETE FROM invoice_reserve WHERE invoice_id IN (2162,2251);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5322';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5322';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5322' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5066'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5066 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='898' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2509,2639);
UPDATE invoice_master
                                             SET manual_transaction_id = 898, auto_assign = 0
                                             WHERE invoice_id IN (2509,2639);
DELETE FROM invoice_reserve WHERE invoice_id IN (2509,2639);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5066';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5066';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5066' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5240'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5240 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='370' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (1108,1164,1300,1357,1412);
UPDATE invoice_master
                                             SET manual_transaction_id = 370, auto_assign = 0
                                             WHERE invoice_id IN (1108,1164,1300,1357,1412);
DELETE FROM invoice_reserve WHERE invoice_id IN (1108,1164,1300,1357,1412);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5240';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5240';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5240' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4609'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4609 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='492' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (269,279,260,263);
UPDATE invoice_master
                                             SET manual_transaction_id = 492, auto_assign = 0
                                             WHERE invoice_id IN (260,263,269,279);
DELETE FROM invoice_reserve WHERE invoice_id IN (269,279,260,263);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4609';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4609';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4609' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4612'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4612 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='494' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (312,317,321,329);
UPDATE invoice_master
                                             SET manual_transaction_id = 494, auto_assign = 0
                                             WHERE invoice_id IN (312,317,321,329);
DELETE FROM invoice_reserve WHERE invoice_id IN (312,317,321,329);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4612';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4612';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4612' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5241'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5241 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='559' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (1479);
UPDATE invoice_master
                                             SET manual_transaction_id = 559, auto_assign = 0
                                             WHERE invoice_id IN (1479,1533,1632);
DELETE FROM invoice_reserve WHERE invoice_id IN (1479);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5241';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5241';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5241' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4602'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4602 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='783' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4391,236,246);
UPDATE invoice_master
                                             SET manual_transaction_id = 783, auto_assign = 0
                                             WHERE invoice_id IN (236,246,4391);
DELETE FROM invoice_reserve WHERE invoice_id IN (4391,236,246);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4602';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4602';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4602' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5262'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5262 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='911' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2924,2973);
UPDATE invoice_master
                                             SET manual_transaction_id = 911, auto_assign = 0
                                             WHERE invoice_id IN (2924,2973);
DELETE FROM invoice_reserve WHERE invoice_id IN (2924,2973);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5262';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5262';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5262' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4564'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4564 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1148' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (250,320,307,324,308,328,309,242,330,311,249,316);
UPDATE invoice_master
                                             SET manual_transaction_id = 1148, auto_assign = 0
                                             WHERE invoice_id IN (242,307,308,309,311,249,250,316,320,324,328,330);
DELETE FROM invoice_reserve WHERE invoice_id IN (250,320,307,324,308,328,309,242,330,311,249,316);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4564';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4564';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4564' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4595'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4595 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1024' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (1066,2764,1165,2994,1492,3345,1848,2181,2358);
UPDATE invoice_master
                                             SET manual_transaction_id = 1024, auto_assign = 0
                                             WHERE invoice_id IN (1066,1165,1492,1848,2181,2358,2764,2994,3345);
DELETE FROM invoice_reserve WHERE invoice_id IN (1066,2764,1165,2994,1492,3345,1848,2181,2358);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4595';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4595';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4595' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5263'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5263 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1065' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2974,3155,3196,3331);
UPDATE invoice_master
                                             SET manual_transaction_id = 1065, auto_assign = 0
                                             WHERE invoice_id IN (2974,3155,3196,3331);
DELETE FROM invoice_reserve WHERE invoice_id IN (2974,3155,3196,3331);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5263';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5263';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5263' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5389'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5389 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1390' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (3220,4431);
UPDATE invoice_master
                                             SET manual_transaction_id = 1390, auto_assign = 0
                                             WHERE invoice_id IN (3220,4431);
DELETE FROM invoice_reserve WHERE invoice_id IN (3220,4431);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5389';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5389';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5389' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5112'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5112 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1517' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (444,517);
UPDATE invoice_master
                                             SET manual_transaction_id = 1517, auto_assign = 0
                                             WHERE invoice_id IN (444,517);
DELETE FROM invoice_reserve WHERE invoice_id IN (444,517);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5112';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5112';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5112' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5258'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5258 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1625' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (3047,3208);
UPDATE invoice_master
                                             SET manual_transaction_id = 1625, auto_assign = 0
                                             WHERE invoice_id IN (3047,3208);
DELETE FROM invoice_reserve WHERE invoice_id IN (3047,3208);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5258';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5258';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5258' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5137'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5137 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1640' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (1349,1402,1470,3452,3605,4591);
UPDATE invoice_master
                                             SET manual_transaction_id = 1640, auto_assign = 0
                                             WHERE invoice_id IN (4591,779,1349,1402,1470,3452,3605);
DELETE FROM invoice_reserve WHERE invoice_id IN (1349,1402,1470,3452,3605,4591);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5137';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5137';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5137' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4596'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4596 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1697' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (3776);
UPDATE invoice_master
                                             SET manual_transaction_id = 1697, auto_assign = 0
                                             WHERE invoice_id IN (3776);
DELETE FROM invoice_reserve WHERE invoice_id IN (3776);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4596';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4596';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4596' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5108'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5108 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1792' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (415,1020,1026,1048);
UPDATE invoice_master
                                             SET manual_transaction_id = 1792, auto_assign = 0
                                             WHERE invoice_id IN (415,1020,1026,1048);
DELETE FROM invoice_reserve WHERE invoice_id IN (415,1020,1026,1048);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5108';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5108';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5108' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5143'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5143 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2503' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4033,4315);
UPDATE invoice_master
                                             SET manual_transaction_id = 2503, auto_assign = 0
                                             WHERE invoice_id IN (4033,4207,4315);
DELETE FROM invoice_reserve WHERE invoice_id IN (4033,4315);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5143';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5143';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5143' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5215'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5215 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2498' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (494,519,561);
UPDATE invoice_master
                                             SET manual_transaction_id = 2498, auto_assign = 0
                                             WHERE invoice_id IN (494,519,561);
DELETE FROM invoice_reserve WHERE invoice_id IN (494,519,561);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5215';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5215';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5215' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5109'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5109 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1816' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (1079,1301,1354,1407,2013,2168,2231,2939,2987,3087,3241);
UPDATE invoice_master
                                             SET manual_transaction_id = 1816, auto_assign = 0
                                             WHERE invoice_id IN (1079,1301,1354,1407,2013,2168,2231,2939,2987,3087,3241);
DELETE FROM invoice_reserve WHERE invoice_id IN (1079,1301,1354,1407,2013,2168,2231,2939,2987,3087,3241);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5109';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5109';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5109' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5232'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5232 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1831' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (599,3934,4123,4293);
UPDATE invoice_master
                                             SET manual_transaction_id = 1831, auto_assign = 0
                                             WHERE invoice_id IN (599,3934,4123,4293);
DELETE FROM invoice_reserve WHERE invoice_id IN (599,3934,4123,4293);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5232';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5232';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5232' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5113'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5113 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1925' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (532,555,593,630,1317);
UPDATE invoice_master
                                             SET manual_transaction_id = 1925, auto_assign = 0
                                             WHERE invoice_id IN (532,555,593,630,1317);
DELETE FROM invoice_reserve WHERE invoice_id IN (532,555,593,630,1317);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5113';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5113';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5113' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5138'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5138 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1985' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (3722,3924);
UPDATE invoice_master
                                             SET manual_transaction_id = 1985, auto_assign = 0
                                             WHERE invoice_id IN (3722,3924);
DELETE FROM invoice_reserve WHERE invoice_id IN (3722,3924);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5138';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5138';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5138' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5212'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5212 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='1987' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (456,473);
UPDATE invoice_master
                                             SET manual_transaction_id = 1987, auto_assign = 0
                                             WHERE invoice_id IN (456,473);
DELETE FROM invoice_reserve WHERE invoice_id IN (456,473);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5212';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5212';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5212' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4352'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4352 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2095' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (5473,5555,5349,5350,5469);
UPDATE invoice_master
                                             SET manual_transaction_id = 2095, auto_assign = 0
                                             WHERE invoice_id IN (5349,5350,5473,5469,5555);
DELETE FROM invoice_reserve WHERE invoice_id IN (5473,5555,5349,5350,5469);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4352';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4352';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4352' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5121'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5121 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2338' ;
UPDATE invoice_master
SET manual_transaction_id = 0, auto_assign = 0
WHERE invoice_id IN (3763,4122,4292,4817);

UPDATE invoice_master
SET manual_transaction_id = 2338, auto_assign = 0
WHERE invoice_id IN (3763,4817,4122,4292,4380,4518,5125);
DELETE FROM invoice_reserve WHERE invoice_id IN (3763,4122,4292,4817);

DELETE FROM `manual_transactions`  WHERE `manual_transaction_id` ='5121';
DELETE FROM `statements`  WHERE `manual_transaction_id` ='5121';
DELETE FROM manual_transactions_invoice  WHERE transaction_id='5121' ;



INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5264'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5264 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2439' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (3461,4791);
UPDATE invoice_master
                                             SET manual_transaction_id = 2439, auto_assign = 0
                                             WHERE invoice_id IN (3461,4791);
DELETE FROM invoice_reserve WHERE invoice_id IN (3461,4791);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5264';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5264';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5264' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4598'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4598 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2672' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (310,1637,323,2047,327,2754,332,2965,338,343);
UPDATE invoice_master
                                             SET manual_transaction_id = 2672, auto_assign = 0
                                             WHERE invoice_id IN (310,323,327,332,338,343,1637,2047,2754,2965);
DELETE FROM invoice_reserve WHERE invoice_id IN (310,1637,323,2047,327,2754,332,2965,338,343);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4598';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4598';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4598' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '3970'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=3970 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2710' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (6178);
UPDATE invoice_master
                                             SET manual_transaction_id = 2710, auto_assign = 0
                                             WHERE invoice_id IN (6178);
DELETE FROM invoice_reserve WHERE invoice_id IN (6178);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='3970';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='3970';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='3970' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5305'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5305 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2707' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (919,711);
UPDATE invoice_master
                                             SET manual_transaction_id = 2707, auto_assign = 0
                                             WHERE invoice_id IN (711,919);
DELETE FROM invoice_reserve WHERE invoice_id IN (919,711);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5305';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5305';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5305' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5216'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5216 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2738' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (582);
UPDATE invoice_master
                                             SET manual_transaction_id = 2738, auto_assign = 0
                                             WHERE invoice_id IN (582);
DELETE FROM invoice_reserve WHERE invoice_id IN (582);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5216';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5216';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5216' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4275'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4275 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2839' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4678);
UPDATE invoice_master
                                             SET manual_transaction_id = 2839, auto_assign = 0
                                             WHERE invoice_id IN (4678);
DELETE FROM invoice_reserve WHERE invoice_id IN (4678);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4275';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4275';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4275' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5144'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5144 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2857' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (5811,5923,6069,6213,6326,6488,6597);
UPDATE invoice_master
                                             SET manual_transaction_id = 2857, auto_assign = 0
                                             WHERE invoice_id IN (5811,5923,6069,6213,6326,6488,6597);
DELETE FROM invoice_reserve WHERE invoice_id IN (5811,5923,6069,6213,6326,6488,6597);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5144';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5144';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5144' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5253'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5253 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='2925' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2575);
UPDATE invoice_master
                                             SET manual_transaction_id = 2925, auto_assign = 0
                                             WHERE invoice_id IN (2575);
DELETE FROM invoice_reserve WHERE invoice_id IN (2575);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5253';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5253';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5253' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5065'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5065 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3033' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (6464);
UPDATE invoice_master
                                             SET manual_transaction_id = 3033, auto_assign = 0
                                             WHERE invoice_id IN (6464);
DELETE FROM invoice_reserve WHERE invoice_id IN (6464);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5065';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5065';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5065' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5254'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5254 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3077' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2700);
UPDATE invoice_master
                                             SET manual_transaction_id = 3077, auto_assign = 0
                                             WHERE invoice_id IN (2700);
DELETE FROM invoice_reserve WHERE invoice_id IN (2700);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5254';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5254';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5254' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4078'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4078 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3084' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (7202);
UPDATE invoice_master
                                             SET manual_transaction_id = 3084, auto_assign = 0
                                             WHERE invoice_id IN (7202);
DELETE FROM invoice_reserve WHERE invoice_id IN (7202);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4078';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4078';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4078' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4620'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4620 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3221' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (267);
UPDATE invoice_master
                                             SET manual_transaction_id = 3221, auto_assign = 0
                                             WHERE invoice_id IN (267);
DELETE FROM invoice_reserve WHERE invoice_id IN (267);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4620';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4620';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4620' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5145'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5145 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3265' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4207);
UPDATE invoice_master
                                             SET manual_transaction_id = 3265, auto_assign = 0
                                             WHERE invoice_id IN (4207);
DELETE FROM invoice_reserve WHERE invoice_id IN (4207);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5145';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5145';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5145' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4104'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4104 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3341' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (7875);
UPDATE invoice_master
                                             SET manual_transaction_id = 3341, auto_assign = 0
                                             WHERE invoice_id IN (7875);
DELETE FROM invoice_reserve WHERE invoice_id IN (7875);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4104';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4104';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4104' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5156'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5156 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3344' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (3925,4034);
UPDATE invoice_master
                                             SET manual_transaction_id = 3344, auto_assign = 0
                                             WHERE invoice_id IN (3925,4034);
DELETE FROM invoice_reserve WHERE invoice_id IN (3925,4034);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5156';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5156';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5156' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5294'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5294 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3345' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (720);
UPDATE invoice_master
                                             SET manual_transaction_id = 3345, auto_assign = 0
                                             WHERE invoice_id IN (720);
DELETE FROM invoice_reserve WHERE invoice_id IN (720);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5294';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5294';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5294' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5073'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5073 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3364' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2806,2865);
UPDATE invoice_master
                                             SET manual_transaction_id = 3364, auto_assign = 0
                                             WHERE invoice_id IN (2806,2865);
DELETE FROM invoice_reserve WHERE invoice_id IN (2806,2865);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5073';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5073';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5073' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5157'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5157 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3566' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4208);
UPDATE invoice_master
                                             SET manual_transaction_id = 3566, auto_assign = 0
                                             WHERE invoice_id IN (4208);
DELETE FROM invoice_reserve WHERE invoice_id IN (4208);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5157';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5157';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5157' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5176'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5176 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3645' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (466);
UPDATE invoice_master
                                             SET manual_transaction_id = 3645, auto_assign = 0
                                             WHERE invoice_id IN (466);
DELETE FROM invoice_reserve WHERE invoice_id IN (466);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5176';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5176';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5176' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4568'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4568 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3647' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (333);
UPDATE invoice_master
                                             SET manual_transaction_id = 3647, auto_assign = 0
                                             WHERE invoice_id IN (333);
DELETE FROM invoice_reserve WHERE invoice_id IN (333);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4568';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4568';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4568' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4578'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4578 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3648' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (2765);
UPDATE invoice_master
                                             SET manual_transaction_id = 3648, auto_assign = 0
                                             WHERE invoice_id IN (2765);
DELETE FROM invoice_reserve WHERE invoice_id IN (2765);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4578';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4578';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4578' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4624'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4624 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3649' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (265);
UPDATE invoice_master
                                             SET manual_transaction_id = 3649, auto_assign = 0
                                             WHERE invoice_id IN (265);
DELETE FROM invoice_reserve WHERE invoice_id IN (265);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4624';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4624';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4624' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5297'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5297 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3726' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (730);
UPDATE invoice_master
                                             SET manual_transaction_id = 3726, auto_assign = 0
                                             WHERE invoice_id IN (730);
DELETE FROM invoice_reserve WHERE invoice_id IN (730);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5297';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5297';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5297' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5298'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5298 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3743' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (819);
UPDATE invoice_master
                                             SET manual_transaction_id = 3743, auto_assign = 0
                                             WHERE invoice_id IN (819,1018);
DELETE FROM invoice_reserve WHERE invoice_id IN (819);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5298';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5298';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5298' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5158'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5158 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3760' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4316,4456,4595,4734);
UPDATE invoice_master
                                             SET manual_transaction_id = 3760, auto_assign = 0
                                             WHERE invoice_id IN (4316,4456,4595,4734);
DELETE FROM invoice_reserve WHERE invoice_id IN (4316,4456,4595,4734);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5158';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5158';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5158' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5299'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5299 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3764' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (6604,1110);
UPDATE invoice_master
                                             SET manual_transaction_id = 3764, auto_assign = 0
                                             WHERE invoice_id IN (1110,6604);
DELETE FROM invoice_reserve WHERE invoice_id IN (6604,1110);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5299';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5299';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5299' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4621'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4621 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3831' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4153);
UPDATE invoice_master
                                             SET manual_transaction_id = 3831, auto_assign = 0
                                             WHERE invoice_id IN (4153);
DELETE FROM invoice_reserve WHERE invoice_id IN (4153);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4621';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4621';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4621' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '5146'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=5146 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3853' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4455);
UPDATE invoice_master
                                             SET manual_transaction_id = 3853, auto_assign = 0
                                             WHERE invoice_id IN (4455);
DELETE FROM invoice_reserve WHERE invoice_id IN (4455);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='5146';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='5146';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='5146' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4746'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4746 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='3907' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (3132,3177);
UPDATE invoice_master
                                             SET manual_transaction_id = 3907, auto_assign = 0
                                             WHERE invoice_id IN (3132,3177);
DELETE FROM invoice_reserve WHERE invoice_id IN (3132,3177);
DELETE FROM `manual_transactions` 
                             WHERE `manual_transaction_id` ='4746';
DELETE FROM `statements` 
                             WHERE `manual_transaction_id` ='4746';
DELETE FROM manual_transactions_invoice 
                             WHERE transaction_id='4746' ;
INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
                               (
                                SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
                                FROM manual_transactions 
                                WHERE manual_transaction_id = '4892'
                               ) ;
DELETE manual_transactions, manual_transactions_invoice
                                 FROM manual_transactions
                                 LEFT JOIN manual_transactions_invoice ON manual_transactions.manual_transaction_id = manual_transactions_invoice.transaction_id
                                 WHERE manual_transactions.reconcile_ref=4892 AND manual_transactions.transaction_type IN (16,17);
UPDATE manual_transactions 
                                     SET reconcile_status=0,reconcile_ref=0, specific_allocation=0
                                     WHERE manual_transaction_id='4873' ;
UPDATE invoice_master
                                         SET manual_transaction_id = 0, auto_assign = 0
                                         WHERE invoice_id IN (4485);
UPDATE invoice_master
                                             SET manual_transaction_id = 4873, auto_assign = 0
                                             WHERE invoice_id IN (4485);
DELETE FROM invoice_reserve WHERE invoice_id IN (4485);
DELETE FROM `manual_transactions` WHERE `manual_transaction_id` ='4892';
DELETE FROM `statements`  WHERE `manual_transaction_id` ='4892';
DELETE FROM manual_transactions_invoice  WHERE transaction_id='4892';
                             
UPDATE `invoice_master` SET `manual_transaction_id`=5123 WHERE `invoice_id`=4380 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=5123 WHERE `invoice_id`=4518 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=5123 WHERE `invoice_id`=5125 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=5244 WHERE `invoice_id`=1533 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=5244 WHERE `invoice_id`=1632 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=5300 WHERE `invoice_id`=1018 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=5142 WHERE `invoice_id`=779 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=13148 WHERE `invoice_id`=12328 LIMIT 1;
UPDATE `invoice_master` SET `manual_transaction_id`=13148 WHERE `invoice_id`=12212 LIMIT 1;


UPDATE `invoice_master` SET `manual_transaction_id`=7510 WHERE `invoice_id`=5080 LIMIT 1;
INSERT INTO `invoice_reserve` (`invoice_reserve_id`, `manual_transaction_id`, `invoice_id`, `reserve`, `created_at`) VALUES (NULL, 7510, 5080, -16.24, NOW());


UPDATE `manual_transactions` SET `reference_to`='3793,5715,7841,8157,8442' WHERE `manual_transaction_id`=5619 LIMIT 1;
UPDATE `manual_transactions` SET `trailing_balance_amt`=51.25 WHERE `manual_transaction_id`=5619 LIMIT 1;
UPDATE `manual_transactions` SET `amount`=51.25 WHERE `manual_transaction_id`=6610 LIMIT 1;

UPDATE invoice_master
SET manual_transaction_id  = 0
WHERE invoice_id IN (3793,5715,7841,8157,8442);
UPDATE `manual_transactions` SET `reconcile_ref`=0, `reconcile_status`=0 WHERE `manual_transaction_id`=5592 LIMIT 1;

INSERT INTO manual_transactions_rejected (manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,reject_status,created_at,created_by,delete_notes) 
(
SELECT manual_transaction_id,transaction_type,debtor_id,originator_id,currency_id,fx_rate,actual_fx_rate,amount,debtors,reference_to,specific_allocation,notes,transaction_file,specific_deductible,deductible_amount,trailing_balance,trailing_balance_amt,transref_list,reconcile_payment,reconcile_ref,status,reconcile_status,interface,transaction_date,notification_title,transaction_name,0,NOW(),1,''
FROM manual_transactions 
WHERE manual_transaction_id IN (5619,6610)
) ;
DELETE FROM `manual_transactions` WHERE `manual_transaction_id` IN (5619,6610);