-- Create Table Statement for 'Payout Statement'
DROP TABLE IF EXISTS `IAPP_PAYOUT_STATEMENT`;
CREATE TABLE `IAPP_PAYOUT_STATEMENT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	CREATE_DATE datetime,
	BEGIN_DATE datetime,
	END_DATE datetime,
	AMOUNT int(11),
	ADJUSTED_AMOUNT int(11),
	REMITTED_AMOUNT int(11),
	BALANCE int(11),
	STATEMENT_CL varchar,
	STATUS_CL varchar,
	APPROVER_CODE varchar,
	REMITTER_CODE varchar,
	DEPOSIT_DATE datetime,
	CLIENT_FEE_FK bigint(20),
	PARTNER_FK int(11),
	AGENT_FK int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;