-- Create Table Statement for 'Merchant Statement Detail'
DROP TABLE IF EXISTS `IAPP_MERCHANT_STATEMENT_DETAIL`;
CREATE TABLE `IAPP_MERCHANT_STATEMENT_DETAIL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	AMOUNT int(11),
	BUY_RATE_AMOUNT int(11),
	SUBMISSION_CODE bigint(20),
	SUBMISSION_CL varchar,
	ACTIVITY_DATE datetime,
	DESCRIPTION varchar,
	CAPTION varchar,
	CAPTION_VAR0 int(11),
	CAPTION_VAR1 int(11),
	CAPTION_VAR2 decimal(10,2),
	CAPTION_VAR3 decimal(10,2),
	CAPTION_VAR10 int(11),
	CAPTION_VAR11 int(11),
	CAPTION_VAR12 decimal(10,2),
	CAPTION_VAR13 decimal(10,2),
	REMITTANCE_SOURCE_CL varchar,
	IS_VISIBLE_EXTERNALLY tinyint(1),
	CREATOR_CODE varchar,
	FUNDS_SOURCE_CL varchar,
	TRANSACTION_CL varchar,
	AUTHORIZATION_CURRENCY_CODE varchar,
	SETTLEMENT_CURRENCY_CODE varchar,
	AUTHORIZATION_AMOUNT int(11),
	STEREOTYPE varchar,
	AMEX_CHARGEBACK_AMOUNT int(11),
	MERCHANT_FEE_DETAIL_FK bigint(20),
	GL_ACCOUNT_FK bigint(20),
	STATEMENT_DETAIL_GROUP_FK bigint(20),
	DEPOSIT_STATEMENT_FK bigint(20),
	FEE_SCHEMA_DETAIL_FK bigint(20),
	MERCHANT_STATEMENT_FK bigint(20),
	MERCHANT_STATEMENT_MERCHANT_STATEMENT_DETAILS_IDX int(11),
	MERCHANT_STATEMENT_FK bigint(20),
	AMOUNT bigint(20),
	AUTHORIZATION_AMOUNT bigint(20),
	MERCHANT_STATEMENT_FK bigint(20),
	DEPOSIT_STATEMENT_FK bigint(20),
	MERCHANT_STATEMENT_FK bigint(20),
	DEPOSIT_STATEMENT_FK bigint(20),
	COMMISSION_BASIS_AMOUNT int(11),
	COMMISSION_RATE int(11),
	COMMISSION_AMOUNT int(11),
	COMMISSION_BASIS_CL varchar,
	RESELLER_COMMISSION_DETAIL_FK bigint(20),
	MASTER_MERCHANT_STATEMENT_DETAIL_FK bigint(20),
	STEREOTYPE varchar,
	STEREOTYPE varchar,
	TAX_AMOUNT int(11),
	TAX_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;