-- Create Table Statement for 'Amex Chargeback Document Transaction'
DROP TABLE IF EXISTS `AMEX_CHARGEBACK_DOCUMENT_TRANSACTION`;
CREATE TABLE `AMEX_CHARGEBACK_DOCUMENT_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FILENAME varchar,
	PAGES int(11),
	CHARGEBACK_CASE_DOCUMENT_CONTENT_FK bigint(20),
	CHARGEBACK_CASE_DOCUMENT_FK bigint(20),
	APP_FORMAT varchar,
	DOC_SCAN_DATE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RECORD_NUMBER varchar,
	ERROR varchar,
	AMEX_CHARGEBACK_DOCUMENT_BATCH_AMEX_CHARGEBACK_DOC_IDX int(11),
	CHARGEBACK_CASE_DOCUMENT_CONTENT_FK bigint(20),
	CHARGEBACK_CASE_DOCUMENT_FK bigint(20),
	AMEX_CHARGEBACK_DOCUMENT_BATCH_FK bigint(20),
	AMEX_CHARGEBACK_DOCUMENT_BATCH_FK bigint(20),
	CHARGEBACK_CASE_DOCUMENT_CONTENT_FK bigint(20),
	CHARGEBACK_CASE_DOCUMENT_FK bigint(20),
	AMEX_CHARGEBACK_DOCUMENT_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;