-- Create Table Statement for 'Distribution Statement'
DROP TABLE IF EXISTS `IAPP_DISTRIBUTION_STATEMENT`;
CREATE TABLE `IAPP_DISTRIBUTION_STATEMENT` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	STATUS_CL varchar,
	AMOUNT int(11),
	ADJUSTED_AMOUNT int(11),
	NOTE varchar,
	TRANSACTION_CODE varchar,
	START_DATE datetime,
	END_DATE datetime,
	APPROVER_CODE varchar,
	REMITTER_CODE varchar,
	EMAIL_SENT_DATE datetime,
	DUE_DATE datetime,
	RESELLER_FK int(11),
	DISTRIBUTION_SCHEMA_FK int(11),
	REMITTER_FK int(11),
	DISTRIBUTION_STATEMENT_DETAIL_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;