-- Create Table Statement for 'FirstData Nashville Retail File Batch'
DROP TABLE IF EXISTS `FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH`;
CREATE TABLE `FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT varchar,
	SECURITY_CODE varchar,
	SUBMISSION_CREATE_DATE_JULIAN varchar,
	SUBMISSION_CREATE_DATE varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	CHARGE_DESCRIPTION varchar,
	TOTAL_SALES_AMOUNT int(11),
	TOTAL_CREDIT_AMOUNT int(11),
	MERCHANT_NAME varchar,
	ACKNOWLEDGMENT_CODE varchar,
	SUBMISSION_ID varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;