-- Create Table Statement for 'Split Out Balance'
DROP TABLE IF EXISTS `SPLIT_OUT_BALANCE`;
CREATE TABLE `SPLIT_OUT_BALANCE` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE1 int(11),
MERCHANT_ACCOUNT_CODE2 int(11),
BALANCE_IN1 int(11),
SPLIT_IN_AMOUNT1 int(11),
BALANCE_IN2 int(11),
SPLIT_IN_AMOUNT2 int(11),
BALANCE_OUT1 int(11),
BALANCE_OUT2 int(11),
SPLIT_IN_REDUCTION_AMOUNT1 int(11),
SPLIT_IN_REDUCTION_AMOUNT2 int(11),
SPLIT_IN_REDUCTION_AMOUNT1 int(11),
SPLIT_IN_REDUCTION_AMOUNT2 int(11),
SPLIT_IN_REDUCTION_AMOUNT1 int(11),
SPLIT_IN_REDUCTION_AMOUNT2 int(11),
SPLIT_IN_REDUCTION_AMOUNT1 int(11),
SPLIT_IN_REDUCTION_AMOUNT2 int(11),
BALANCE_IN1 int(11),
BALANCE_IN2 int(11),
BALANCE_OUT1 int(11),
BALANCE_OUT2 int(11),
BALANCE_IN1 int(11),
BALANCE_IN2 int(11),
BALANCE_OUT1 int(11),
BALANCE_OUT2 int(11),
PRIMARY KEY (ID)
) ENGINE=InnoDB;