-- Create Table Statement for 'Elavon4 Retail File Batch'
DROP TABLE IF EXISTS `ELAVON4_RETAIL_FILE_BATCH`;
CREATE TABLE `ELAVON4_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	FILE_CREATE_DATE varchar,
	FILE_CREATE_TIME varchar,
	ELAVON_FILE_NUMBER varchar,
	INSTITUTION_NAME varchar,
	ORIGINATING_FILE_NAME varchar,
	MERCHANT_ID varchar,
	MERCHANT_DBA_NAME varchar,
	MERCHANT_CITY varchar,
	MERCHANT_ZIP varchar,
	MERCHANT_STATE varchar,
	MERCHANT_COUNTRY varchar,
	CURRENCY_CODE varchar,
	BATCH_NUMBER varchar,
	REFERENCE_NUMBER varchar,
	CUSTOMER_SERVICE_NUMBER varchar,
	BATCH_PURCHASES_COUNT varchar,
	BATCH_PURCHASES_AMOUNT varchar,
	BATCH_RETURN_COUNT varchar,
	BATCH_RETURN_AMOUNT varchar,
	BATCH_TOTAL_COUNT varchar,
	BATCH_NET_AMOUNT varchar,
	BATCH_NET_SIGN varchar,
	FILE_RECORD_COUNT varchar,
	MERCHANT_STREET_ADDRESS varchar,
	NETWORK_IDENTIFIER varchar,
	BATCH_RESPONSE_CODE varchar,
	PROVIDER_CHARGE_TRANSACTIONS bigint(20),
	SUB_MERCHANT_ID varchar,
	MERCHANT_CATEGORY_CODE varchar,
	SUB_MERCHANT_TAX_ID varchar,
	MERCHANT_PHONE varchar,
	MERCHANT_EMAIL_ADDRESS varchar,
	APPLICATION_ID varchar,
	PAYMENT_FACILITATOR_ID varchar,
	SUB_MERCHANT_ID varchar,
	MERCHANT_CATEGORY_CODE varchar,
	SUB_MERCHANT_TAX_ID varchar,
	MERCHANT_PHONE varchar,
	MERCHANT_EMAIL_ADDRESS varchar,
	APPLICATION_ID varchar,
	PAYMENT_FACILITATOR_ID varchar,
	SUB_MERCHANT_ID varchar,
	MERCHANT_CATEGORY_CODE varchar,
	SUB_MERCHANT_TAX_ID varchar,
	MERCHANT_PHONE varchar,
	MERCHANT_EMAIL_ADDRESS varchar,
	APPLICATION_ID varchar,
	PAYMENT_FACILITATOR_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;