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