-- Create Table Statement for 'Amex Retail File Batch'
DROP TABLE IF EXISTS `AMEX_RETAIL_FILE_BATCH`;
CREATE TABLE `AMEX_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	RESPONSE_DATA varchar,
	MERCHANT_ID varchar,
	TBT_IDENTIFICATION_NUMBER varchar,
	TBT_CREATION_DATE varchar,
	TOTAL_NO_OF_TABS varchar,
	TBT_AMOUNT varchar,
	TBT_AMOUNT_SIGN varchar,
	TBT_CURRENCY_CODE varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	TPP_ID varchar,
	CREDIT_AMOUNT varchar,
	CREDIT_COUNT varchar,
	DEBIT_AMOUNT varchar,
	DEBIT_COUNT varchar,
	TOTAL_AMOUNT varchar,
	TBT_CREATION_TIME varchar,
	FILE_NUMBER varchar,
	REPORT_ID varchar,
	REPORT_DATE_TIME varchar,
	FILE_STATUS varchar,
	FILE_CREATION_DATE_TIME varchar,
	FILE_RECEIPT_DATE_TIME varchar,
	TOTAL_NUMBER_OF_RECORDS varchar,
	HASH_TOTAL_AMOUNT varchar,
	TOTAL_NUMBER_OF_DEBITS varchar,
	DEBIT_HASH_TOTAL_AMOUNT varchar,
	TOTAL_NUMBER_OF_CREDITS varchar,
	CREDIT_HASH_TOTAL_AMOUNT varchar,
	TOTAL_REJECTED_RECORDS varchar,
	TOTAL_SUSPENDED_BATCHES varchar,
	TOTAL_SUSPENDED_RECORDS varchar,
	FILE_TRACKING_NUMBER varchar,
	CREDIT_AMOUNT varchar,
	CREDIT_COUNT varchar,
	DEBIT_AMOUNT varchar,
	DEBIT_COUNT varchar,
	TOTAL_AMOUNT varchar,
	TBT_CREATION_TIME varchar,
	FILE_NUMBER varchar,
	REPORT_ID varchar,
	REPORT_DATE_TIME varchar,
	FILE_STATUS varchar,
	FILE_CREATION_DATE_TIME varchar,
	FILE_RECEIPT_DATE_TIME varchar,
	TOTAL_NUMBER_OF_RECORDS varchar,
	HASH_TOTAL_AMOUNT varchar,
	TOTAL_NUMBER_OF_DEBITS varchar,
	DEBIT_HASH_TOTAL_AMOUNT varchar,
	TOTAL_NUMBER_OF_CREDITS varchar,
	CREDIT_HASH_TOTAL_AMOUNT varchar,
	TOTAL_REJECTED_RECORDS varchar,
	TOTAL_SUSPENDED_BATCHES varchar,
	TOTAL_SUSPENDED_RECORDS varchar,
	FILE_TRACKING_NUMBER varchar,
	CREDIT_AMOUNT varchar,
	CREDIT_COUNT varchar,
	DEBIT_AMOUNT varchar,
	DEBIT_COUNT varchar,
	TOTAL_AMOUNT varchar,
	TBT_CREATION_TIME varchar,
	FILE_NUMBER varchar,
	REPORT_ID varchar,
	REPORT_DATE_TIME varchar,
	FILE_STATUS varchar,
	FILE_CREATION_DATE_TIME varchar,
	FILE_RECEIPT_DATE_TIME varchar,
	TOTAL_NUMBER_OF_RECORDS varchar,
	HASH_TOTAL_AMOUNT varchar,
	TOTAL_NUMBER_OF_DEBITS varchar,
	DEBIT_HASH_TOTAL_AMOUNT varchar,
	TOTAL_NUMBER_OF_CREDITS varchar,
	CREDIT_HASH_TOTAL_AMOUNT varchar,
	TOTAL_REJECTED_RECORDS varchar,
	TOTAL_SUSPENDED_BATCHES varchar,
	TOTAL_SUSPENDED_RECORDS varchar,
	FILE_TRACKING_NUMBER varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;