-- Create Table Statement for 'Paymentech UTF Retail File Batch'
DROP TABLE IF EXISTS `PAYMENTECH_UTF_RETAIL_FILE_BATCH`;
CREATE TABLE `PAYMENTECH_UTF_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	CLIENT_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	TRANSACTION_SEQUENCE_FLAG varchar,
	SEQUENCE_NUMBER varchar,
	TRANSACTION_CODE varchar,
	BATCH_NUMBER varchar,
	BATCH_SEQUENCE_NUMBER varchar,
	BATCH_OFFSET varchar,
	TRANSACTION_COUNT varchar,
	NET_AMOUNT varchar,
	APPLICATION_NAME varchar,
	APPLICATION_RELEASE_DATE varchar,
	EPROM_VERSION_NUMBER varchar,
	HEADER_ACTION_CODE varchar,
	HEADER_AUTHORIZATION_OR_ERROR_CODE varchar,
	HEADER_RESPONSE_MESSAGE varchar,
	HEADER_DOWNLOAD_FLAG varchar,
	HEADER_BATCH_OPEN_DATE_TIME varchar,
	HEADER_BATCH_CLOSE_DATE_TIME varchar,
	HEADER_BATCH_TRANSACTION_COUNT varchar,
	FINAL_RESPONSE_ACTION_CODE varchar,
	FINAL_RESPONSE_AUTHORIZATION_OR_ERROR_CODE varchar,
	FINAL_RESPONSE_RESPONSE_MESSAGE varchar,
	FINAL_RESPONSE_DOWNLOAD_FLAG varchar,
	FINAL_RESPONSE_BATCH_OPEN_DATE_TIME varchar,
	FINAL_RESPONSE_BATCH_CLOSE_DATE_TIME varchar,
	FINAL_RESPONSE_BATCH_TRANSACTION_COUNT varchar,
	FINAL_RESPONSE_BATCH_NET_AMOUNT varchar,
	SYSTEM_INDICATOR varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;