-- 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;