-- Create Table Statement for 'CC Amex Batch'
DROP TABLE IF EXISTS `CC_AMEX_BATCH`;
CREATE TABLE `CC_AMEX_BATCH` (
	ID bigint(20) NOT NULL,
	SAID varchar,
	MERCHANT_ID varchar,
	FILE_SEQUENCE_NUMBER varchar,
	CREATE_DATE_TIME varchar,
	JULIAN_DATE varchar,
	SERVICE_ESTABLISHMENT_NUMBER varchar,
	INVOICE_DATE varchar,
	BATCH_DEBIT_COUNT varchar,
	BATCH_DEBIT_AMOUNT varchar,
	BATCH_CREDIT_COUNT varchar,
	BATCH_CREDIT_AMOUNT varchar,
	BATCH_TOTAL_COUNT varchar,
	BATCH_TOTAL_AMOUNT varchar,
	REJECT_RECORD_NUMBER varchar,
	FILE_RESPONSE_CODE varchar,
	BATCH_REJECT_TRANSACTION_COUNT varchar,
	BATCH_REJECT_AMOUNT varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;