HEX
Server: Apache/2.2.15 (CentOS)
System: Linux ip-10-0-2-146.eu-west-1.compute.internal 2.6.32-754.35.1.el6.centos.plus.x86_64 #1 SMP Sat Nov 7 11:33:42 UTC 2020 x86_64
User: root (0)
PHP: 5.6.40
Disabled: NONE
$ pwd: /www/exchange2/sql/custom/
Upload Files
File: /www/exchange2/sql/custom/TK24125-New-PF-Limited-Fix-a-ETR-Trades.sql
/* New PF Limited Originator ID : 11912001661 */

 /* Invoice 1*/
UPDATE `invoice_master` SET `face_value` = '87519.80', `reserve` = '2382.04', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138841;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138841;

/* Invoice 2*/
UPDATE `invoice_master` SET `face_value` = '80180.67', `reserve` = '2324.86', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138842;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138842;

/* Invoice 3*/
UPDATE `invoice_master` SET `face_value` = '73228.08', `reserve` = '2243.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138843;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138843;

/* Invoice 4*/
UPDATE `invoice_master` SET `face_value` = '67998.36', `reserve` = '2161.79', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138844;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138844;

/* Invoice 5*/
UPDATE `invoice_master` SET `face_value` = '60477.35', `reserve` = '2014.72', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138845;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138845;

/* Invoice 6*/
UPDATE `invoice_master` SET `face_value` = '51210.20', `reserve` = '1796.98', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138846;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138846;

/* Invoice 7*/
UPDATE `invoice_master` SET `face_value` = '39733.05', `reserve` = '1481.96', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138847;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138847;

/* Invoice 8*/
UPDATE `invoice_master` SET `face_value` = '30674.08', `reserve` = '1197.43', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138848;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138848;

/* Invoice 9*/
UPDATE `invoice_master` SET `face_value` = '19976.27', `reserve` = '818.94', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138849;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138849;

/* Invoice 10*/
UPDATE `invoice_master` SET `face_value` = '8179.42', `reserve` = '354.60', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 138851;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 138851;

/* Invoice Trade 2*/
UPDATE `invoice_master` SET `face_value` = '97440.86', `reserve` = '3918.44', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 139505;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 139505;

/* Invoice Trade 4*/
UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143467;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143467;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143466;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143466;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143465;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143465;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143472;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143472;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143464;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143464;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143471;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143471;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143463;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143463;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143470;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143470;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143469;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143469;

UPDATE `invoice_master` SET `reserve` = '338.57', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 143468;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 143468;

/* Invoice Trade 5 */
UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144979;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144979;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144987;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144987;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144980;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144980;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144981;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144981;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144989;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144989;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144982;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144982;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144983;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144983;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144984;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144984;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144985;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144985;

UPDATE `invoice_master` SET `reserve` = '343.24', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 144986;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 144986;


/* Invoice Trade 6*/
UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145635;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145635;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145643;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145643;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145636;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145636;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145637;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145637;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145638;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145638;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145639;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145639;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145640;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145640;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145641;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145641;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145634;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145634;

UPDATE `invoice_master` SET `reserve` = '335.14', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 145642;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 145642;


/* Payment update */
UPDATE `debx`.`manual_transactions` SET `is_aetr` = '1' WHERE `manual_transactions`.`manual_transaction_id` = 165532;
UPDATE `debx`.`manual_transactions` SET `is_aetr` = '1' WHERE `manual_transactions`.`manual_transaction_id` = 167661;
UPDATE `debx`.`manual_transactions` SET `is_aetr` = '1' WHERE `manual_transactions`.`manual_transaction_id` = 171071;
UPDATE `debx`.`manual_transactions` SET `is_aetr` = '1' WHERE `manual_transactions`.`manual_transaction_id` = 173347;
UPDATE `debx`.`manual_transactions` SET `is_aetr` = '1' WHERE `manual_transactions`.`manual_transaction_id` = 175919;


/* Invoice Trade 7*/
UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146507;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146507;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146508;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146508;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146501;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146501;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146509;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146509;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146502;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146502;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146510;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146510;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146503;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146503;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146504;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146504;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146505;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146505;

UPDATE `invoice_master` SET `reserve` = '458.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 146506;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 146506;

/* Invoice Trade 8*/
UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147692;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147692;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147693;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147693;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147694;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147694;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147695;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147695;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147696;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147696;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147697;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147697;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147690;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147690;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147698;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147698;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147691;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147691;

UPDATE `invoice_master` SET `reserve` = '492.83', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147699;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147699;

/* Invoice Trade 9*/
UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147692;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147692;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147693;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147693;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147694;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147694;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147695;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147695;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147696;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147696;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147697;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147697;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147690;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147690;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147698;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147698;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147691;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147691;

UPDATE `invoice_master` SET `reserve` = '447.15', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 147699;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 147699;

/* Invoice Trade 10*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150199;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150199;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150200;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150200;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150201;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150201;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150194;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150194;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150202;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150202;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150195;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150195;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150203;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150203;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150196;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150196;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150197;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150197;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '406.66', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 150198;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 150198;

/* Invoice Trade 11*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151799;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151799;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151800;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151800;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151793;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151793;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151801;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151801;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151794;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151794;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151802;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151802;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151795;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151795;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151796;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151796;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151797;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151797;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '394.76', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 151798;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 151798;

/* Invoice Trade 12*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153246;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153246;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153254;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153254;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153247;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153247;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153248;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153248;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153249;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153249;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153250;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153250;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153251;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153251;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153252;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153252;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153245;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153245;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.91', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 153253;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 153253;

/* Invoice Trade 13*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154675;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154675;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154676;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154676;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154677;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154677;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154670;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154670;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154678;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154678;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154671;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154671;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154679;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154679;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154672;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154672;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154673;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154673;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '312.41', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 154674;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 154674;


/* Invoice Trade 14*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156107;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156107;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156100;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156100;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156108;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156108;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156101;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156101;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156109;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156109;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156102;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156102;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156103;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156103;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156104;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156104;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156105;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156105;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '291.13', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 156106;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 156106;

/* Invoice Trade 15*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157184;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157184;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157192;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157192;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157185;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157185;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157193;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157193;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157186;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157186;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157187;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157187;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157188;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157188;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157189;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157189;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157190;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157190;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '322.07', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 157191;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 157191;

/* Invoice Trade 16*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158049;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158049;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158050;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158050;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158051;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158051;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158044;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158044;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158052;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158052;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158045;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158045;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158053;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158053;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158046;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158046;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158047;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158047;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '436.50', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 158048;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 158048;

/* Invoice Trade 17*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159294;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159294;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159295;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159295;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159296;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159296;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159289;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159289;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159297;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159297;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159290;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159290;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159299;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159299;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159291;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159291;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159292;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159292;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '593.23', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 159293;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 159293;

/* Invoice Trade 18*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160423;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160423;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160424;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160424;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160425;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160425;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160426;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160426;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160419;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160419;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160427;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160427;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160420;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160420;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160428;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160428;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160421;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160421;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '531.02', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 160422;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 160422;

/* Invoice Trade 19*/
UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161903;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161903;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161904;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161904;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161905;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161905;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161898;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161898;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161906;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161906;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161899;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161899;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161907;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161907;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161900;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161900;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161901;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161901;

UPDATE `invoice_master` SET `is_aetr` = '1', `reserve` = '331.10', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`invoice_id` = 161902;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` = 161902;
@ Telegram