-- Create Table Statement for 'First Data OmniPay Retail File Batch'
DROP TABLE IF EXISTS `FIRST_DATA_OMNI_PAY_RETAIL_FILE_BATCH`;
CREATE TABLE `FIRST_DATA_OMNI_PAY_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PSP_NAME varchar,
	FILE_CREATION_DATE varchar,
	FILE_REFERENCE varchar,
	TEST_IDENTIFIER varchar,
	FILE_IDENTIFICATION varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	MERCHANT_CLASSIFICATION_CODE varchar,
	MERCHANT_STREET_ADDRESS varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MC_SUBMERCHANT_ID varchar,
	SE_NUMBER varchar,
	CHARGE_DESCRIPTOR varchar,
	MERCHANT_NUMBER varchar,
	NET_SALES_AMOUNT int(11),
	BATCH_IDENTIFICATION_NUMBER varchar,
	FILE_RECORD_COUNT varchar,
	TOTAL_AMOUNT int(11),
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	SUMMARY_TRANS_TYPE varchar,
	TRAILER_TRANS_TYPE varchar,
	CONFIRMATION_MESSAGE varchar,
	CONFIRMATION_ERROR_MESSAGE varchar,
	INSTITUTION_ID varchar,
	USE_LEGACY_FILE_HEADER tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;