-- Create Table Statement for 'TSYS Retail File Batch'
DROP TABLE IF EXISTS `TSYS_RETAIL_FILE_BATCH`;
CREATE TABLE `TSYS_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	RECORD_TYPE varchar,
	ACQUIRER_BIN varchar,
	AGENT_BANK_NUMBER varchar,
	AGENT_CHAIN_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	STORE_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	INDUSTRY_CODE varchar,
	TIME_ZONE_DIFFERENTIAL varchar,
	BATCH_TRANSMISSION_DATE varchar,
	BATCH_NUMBER varchar,
	CITY_CODE varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_NAME varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	MERCHANT_LOCATION_NUMBER varchar,
	TERMINAL_ID_NUMBER varchar,
	BATCH_RECORD_COUNT varchar,
	BATCH_HASHING_TOTAL varchar,
	BATCH_NET_DEPOSIT varchar,
	BATCH_RESPONSE_CODE varchar,
	BATCH_RESPONSE_TEXT varchar,
	ERROR_TYPE varchar,
	ERROR_RECORD_SEQUENCE_NUMBER varchar,
	ERROR_RECORD_TYPE varchar,
	ERROR_DATA_FIELD_NUMBER varchar,
	ERROR_DATA varchar,
	DUPLICATE_BATCH_TRANSMISSION_DATE varchar,
	GROUP2 varchar,
	APPLICATION_TYPE varchar,
	CASH_BACK_TOTAL varchar,
	GROUP5 varchar,
	PROVIDER_CHARGE_TRANSACTIONS_FK bigint(20),
	GROUP3 varchar,
	GROUP3 varchar,
	GROUP3 varchar,
	CURRENCY_CODE varchar,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	COUNTRY_CODE varchar,
	CURRENCY_CODE varchar,
	COUNTRY_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;