-- Create Table Statement for 'Balancing Summary'
DROP TABLE IF EXISTS `BALANCING_SUMMARY`;
CREATE TABLE `BALANCING_SUMMARY` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	AMOUNT int(11),
	IS_ACTIVE tinyint(1),
	IS_IN_COLLECTIONS tinyint(1),
	AGE int(11),
	TRANSACTION_SOURCE_CL varchar,
	PAYMENT_OPTION_TYPE varchar,
	IS_SOURCE_INVALID tinyint(1),
	IS_TARGET_INVALID tinyint(1),
	COMMISSION_STATUS_CL varchar,
	SOURCE_FK bigint(20),
	TARGET_FK bigint(20),
	AGENT_COMMISSIONS bigint(20),
	CAUSE_TRANSACTION_CODE bigint(20),
	CAUSE_TRANSACTION_CL varchar,
	CAUSE_TRANSACTION_CODE bigint(20),
	CAUSE_TRANSACTION_CL varchar,
	CAUSE_TRANSACTION_CODE bigint(20),
	CAUSE_TRANSACTION_CL varchar,
	TAX_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;