-- Create Table Statement for 'Merchant Statement Extended Split Detail'
DROP TABLE IF EXISTS `MERCHANT_STATEMENT_EXTENDED_SPLIT_DETAIL`;
CREATE TABLE `MERCHANT_STATEMENT_EXTENDED_SPLIT_DETAIL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	AFFILIATE_CODE int(11),
	STATEMENT_CODE bigint(20),
	TO_MERCHANT_BALANCE_PRE int(11),
	BY_MERCHANT_BALANCE_PRE int(11),
	SPLIT_IN_AMOUNT int(11),
	SPLIT_OUT_AMOUNT int(11),
	PULL_IN_AMOUNT int(11),
	PULL_OUT_AMOUNT int(11),
	TO_MERCHANT_BALANCE_POST int(11),
	BY_MERCHANT_BALANCE_POST int(11),
	IS_ACTIVE tinyint(1),
	BALANCE_IN_AMOUNT int(11),
	BALANCE_OUT_AMOUNT int(11),
	SPLIT_IN_AMOUNT_FUTURE int(11),
	SPLIT_OUT_AMOUNT_FUTURE int(11),
	PULL_IN_AMOUNT_FUTURE int(11),
	PULL_OUT_AMOUNT_FUTURE int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;