-- Create Table Statement for 'Tsys Merchant Statement Detail'
DROP TABLE IF EXISTS `TSYS_MERCHANT_STATEMENT_DETAIL`;
CREATE TABLE `TSYS_MERCHANT_STATEMENT_DETAIL` (
	BANK_NUMBER varchar,
	GROUP_NUMBER varchar,
	ASSOCIATION_NUMBER varchar,
	ACCOUNT_NUMBER varchar,
	MERCHANT_DBA_NAME varchar,
	RECORD_SEQUENCE_NUMBER varchar,
	PROCESSING_DATE varchar,
	ESID varchar,
	EFFECTIVE_DATE varchar,
	ROUTING_NUMBER varchar,
	DDA_NUMBER varchar,
	ACCOUNT_TYPE varchar,
	ACH_HIERARCHY_LEVEL varchar,
	ACH_TABLE varchar,
	TRANSACTION_TYPES varchar,
	CARD_TYPE varchar,
	AMOUNT varchar,
	DEBIT_CREDIT_INDICATOR varchar,
	CHARGEBACK_CASE_NUMBER varchar,
	REFERENCE_NUMBER varchar,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	TSYS_MERCHANT_STATEMENT_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;