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
Upload Files
File: /www/exchange2/sql/custom/TK25717-MIPLC-Holdings-Fix-b-ETR-Trades.sql
/* MIPLC Holdings Limited Originator ID : 12106001858 */

UPDATE `invoice_master` SET `reserve` = '9357.84', `processing_fee` = '0.00', `c_etr_commission` = NULL WHERE `invoice_master`.`debtor_id` = 7563 AND `invoice_master`.`spooled` = 1;
UPDATE `invoice_closed_attributes` SET `processing_fee` = NULL WHERE `invoice_closed_attributes`.`invoice_id` IN (SELECT invoice_id FROM invoice_master WHERE `invoice_master`.`debtor_id` = 7563  AND `invoice_master`.`spooled` = 1);