-- Create Table Statement for 'Funds Distribution'
DROP TABLE IF EXISTS `FUNDS_DISTRIBUTION`;
CREATE TABLE `FUNDS_DISTRIBUTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	SEQUENCE_NUMBER int(11),
	DESTINATION_CL varchar,
	DESTINATION_CODE int(11),
	BASE_AMOUNT int(11),
	AMOUNT int(11),
	NET_AMOUNT int(11),
	CONVENIENCE_FEE_AMOUNT int(11),
	TAX_AMOUNT int(11),
	VENDOR_AMOUNT int(11),
	GROSS_AMOUNT int(11),
	BALANCE_CL varchar,
	DISTRIBUTION_SCHEMA_CODE int(11),
	DISTRIBUTION_SCHEMA_DETAIL_CODE bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;