-- Create Table Statement for 'Distribution Statement Detail'
DROP TABLE IF EXISTS `IAPP_DISTRIBUTION_STATEMENT_DETAIL`;
CREATE TABLE `IAPP_DISTRIBUTION_STATEMENT_DETAIL` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11),
AMOUNT int(11),
DESCRIPTION varchar,
ACTIVITY_DATE datetime,
IS_VISIBLE_EXTERNALLY tinyint(1),
CREATOR_CODE varchar,
DISTRIBUTION_SCHEMA_DETAIL_FK bigint(20),
DISTRIBUTION_STATEMENT_FK bigint(20),
DISTRIBUTION_STATEMENT_DISTRIBUTION_STATEMENT_DETAILS_IDX int(11),
PRIMARY KEY (ID)
) ENGINE=InnoDB;