-- Create Table Statement for 'Merchant Statement Extended Detail'
DROP TABLE IF EXISTS `MERCHANT_STATEMENT_EXTENDED_DETAIL`;
CREATE TABLE `MERCHANT_STATEMENT_EXTENDED_DETAIL` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11),
STATEMENT_CODE bigint(20),
STEREOTYPE varchar,
SUBMISSION_CL varchar,
SUBMISSION_CODE bigint(20),
CAPTION varchar,
COUNT int(11),
AMOUNT bigint(20),
IS_INFO_ONLY tinyint(1),
ACCOUNT_CODE int(11),
STATEMENT_DETAIL_CODE bigint(20),
POSITION int(11),
REMITTANCE_SOURCE_CL varchar,
REMITTANCE_SOURCE_CL varchar,
STEREOTYPE varchar,
STEREOTYPE varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;