-- Create Table Statement for 'Merchant Statement Statistics Detail'
DROP TABLE IF EXISTS `IAPP_MERCHANT_STATEMENT_STATISTICS_DETAIL`;
CREATE TABLE `IAPP_MERCHANT_STATEMENT_STATISTICS_DETAIL` (
	ID bigint(20) NOT NULL,
	STEREOTYPE varchar,
	CAPTION varchar,
	DESCRIPTION varchar,
	AUTHORIZATION_CURRENCY_CODE varchar,
	AUTHORIZATION_AMOUNT int(11),
	SETTLEMENT_CURRENCY_CODE varchar,
	SETTLEMENT_AMOUNT int(11),
	CAPTION_VAR0 int(11),
	CAPTION_VAR1 int(11),
	CAPTION_VAR10 int(11),
	CAPTION_VAR11 int(11),
	MERCHANT_STATEMENT_STATISTICS_FK bigint(20),
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	STATEMENT_DETAIL_GROUP_FK bigint(20),
	CAPTION_VAR2 decimal(10,2),
	CAPTION_VAR3 decimal(10,2),
	CAPTION_VAR12 decimal(10,2),
	CAPTION_VAR13 decimal(10,2),
	POSITION int(11),
	STEREOTYPE varchar,
	STEREOTYPE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;