-- Create Table Statement for 'Merchant Processing Statistics Fee Detail'
DROP TABLE IF EXISTS `MERCHANT_PROCESSING_STATISTICS_FEE_DETAIL`;
CREATE TABLE `MERCHANT_PROCESSING_STATISTICS_FEE_DETAIL` (
STEREOTYPE varchar,
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11),
STEREOTYPE varchar,
DESCRIPTION varchar,
TRANSACTION_COUNT int(11),
AUTHORIZATION_AMOUNT bigint(20),
SETTLEMENT_AMOUNT bigint(20),
REMITTANCE_SOURCE_CL varchar,
TRANSACTION_CL varchar,
BUY_RATE int(11),
FEE int(11),
COMMISSIONABLE_RATE int(11),
COMMISSIONS_RATE int(11),
BUY_RATE_AMOUNT bigint(20),
FEE_AMOUNT bigint(20),
COMMISSIONS_AMOUNT bigint(20),
STATEMENT_DETAIL_GROUP_FK bigint(20),
TAX_RATE_VALUE int(11),
TAX_AMOUNT int(11),
TAX_RATE_FK bigint(20),
TAX_RATE_VALUE int(11),
TAX_AMOUNT int(11),
TAX_RATE_FK bigint(20),
TAX_RATE_VALUE int(11),
TAX_AMOUNT int(11),
TAX_RATE_FK bigint(20),
PRIMARY KEY (ID)
) ENGINE=InnoDB;