-- Create Table Statement for 'FirstData Omaha Retail File Batch'
DROP TABLE IF EXISTS `FIRST_DATA_OMAHA_RETAIL_FILE_BATCH`;
CREATE TABLE `FIRST_DATA_OMAHA_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	TERMINAL_ID varchar,
	MERCHANT_NUMBER varchar,
	DEVICE_ID varchar,
	CREDIT_BATCH_AMOUNT varchar,
	BATCHED_ITEMS varchar,
	BATCH_NUMBER varchar,
	ITEM_NUMBER varchar,
	ACTION_CODE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_TEXT1 varchar,
	RESPONSE_TEXT2 varchar,
	BATCH_ID_NUMBER varchar,
	AUTO_DOWNLOAD_INDICATOR varchar,
	DEBIT_BATCH_COUNT varchar,
	DEBIT_BATCH_AMOUNT varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;