-- Create Table Statement for 'Amex Processing Cost Batch'
DROP TABLE IF EXISTS `AMEX_PROCESSING_COST_BATCH`;
CREATE TABLE `AMEX_PROCESSING_COST_BATCH` (
	ID bigint(20) NOT NULL,
	DF_HDR_DATE varchar,
	DF_HDR_TIME varchar,
	DF_HDR_FILE_ID varchar,
	DF_HDR_FILE_NAME varchar,
	AMEX_PAYEE_NUMBER varchar,
	PAYMENT_YEAR varchar,
	PAYMENT_NUMBER varchar,
	PAYMENT_AMOUNT varchar,
	DEBIT_BALANCE_AMOUNT varchar,
	ABA_BANK_NUMBER varchar,
	SE_DDA_NUMBER varchar,
	TRL_DATE varchar,
	TRL_TIME varchar,
	TRL_FILE_ID varchar,
	TRL_FILE_NAME varchar,
	TRL_RECIPIENT_KEY varchar,
	TRL_RECORD_COUNT varchar,
	PAYMENT_DATE datetime,
	AMEX_PROCESSING_COST_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;