-- Create Table Statement for 'Amex Chargeback Batch'
DROP TABLE IF EXISTS `AMEX_CHARGEBACK_BATCH`;
CREATE TABLE `AMEX_CHARGEBACK_BATCH` (
	ID bigint(20) NOT NULL,
	FILE_CREATION_DATE varchar,
	SAID varchar,
	AMEX_TOTAL_RECORDS varchar,
	CONFIRM_RECORD_COUNT varchar,
	FILE_CREATION_TIME varchar,
	STARS_CREATION_DATE varchar,
	JULIAN_DATE varchar,
	HEADER_ID varchar,
	AMEX_CHARGEBACK_TRANSACTION_FK bigint(20),
	AMEX_CHARGEBACK_TRANSACTION_DISPUTE_FK bigint(20),
	AMEX_CHARGEBACK_RESPONSE_BATCH_FK bigint(20),
	AMEX_INQUIRY_TRANSACTION_RESPONSE_FK bigint(20),
	AMEX_INQUIRY_TRANSACTION_FK bigint(20),
	DATA_TYPE varchar,
	ACKNOWLEDGEMENT_CONF_MESSAGE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;