-- Create Table Statement for 'Split Out Balance Log'
DROP TABLE IF EXISTS `SPLIT_OUT_BALANCE_LOG`;
CREATE TABLE `SPLIT_OUT_BALANCE_LOG` (
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE1 int(11),
	MERCHANT_ACCOUNT_CODE2 int(11),
	BALANCE_IN1_PRE int(11),
	BALANCE_IN1_POST int(11),
	BALANCE_IN2_PRE int(11),
	BALANCE_IN2_POST int(11),
	BALANCE_OUT1_PRE int(11),
	BALANCE_OUT1_POST int(11),
	BALANCE_OUT2_PRE int(11),
	BALANCE_OUT2_POST int(11),
	SPLIT_IN_AMOUNT1_PRE int(11),
	SPLIT_IN_AMOUNT1_POST int(11),
	SPLIT_IN_AMOUNT2_PRE int(11),
	SPLIT_IN_AMOUNT2_POST int(11),
	SPLIT_IN_REDUCTION_AMOUNT1_PRE int(11),
	SPLIT_IN_REDUCTION_AMOUNT1_POST int(11),
	SPLIT_IN_REDUCTION_AMOUNT2_PRE int(11),
	SPLIT_IN_REDUCTION_AMOUNT2_POST int(11),
	MERCHANT_STATEMENT_FK bigint(20),
	SPLIT_OUT_BALANCE_CODE bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;