-- Create Table Statement for 'Merchant Statement Extended Fee Detail'
DROP TABLE IF EXISTS `MERCHANT_STATEMENT_EXTENDED_FEE_DETAIL`;
CREATE TABLE `MERCHANT_STATEMENT_EXTENDED_FEE_DETAIL` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11),
STATEMENT_CODE bigint(20),
STEREOTYPE varchar,
SUBMISSION_CL varchar,
SUBMISSION_CODE bigint(20),
PERCENTAGE_RATE_P4 int(11),
PER_ITEM int(11),
TRANSACTION_COUNT int(11),
TRANSACTION_AMOUNT bigint(20),
TOTAL_AMOUNT bigint(20),
POSITION int(11),
CAPTION varchar,
REMITTANCE_SOURCE_CL varchar,
REMITTANCE_SOURCE_CL varchar,
STEREOTYPE varchar,
STEREOTYPE varchar,
TAX_AMOUNT int(11),
TAX_AMOUNT int(11),
TAX_AMOUNT int(11),
PRIMARY KEY (ID)
) ENGINE=InnoDB;