-- Create Table Statement for 'Elavon4 Global Retail File Batch'
DROP TABLE IF EXISTS `ELAVON4_GLOBAL_RETAIL_FILE_BATCH`;
CREATE TABLE `ELAVON4_GLOBAL_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	NET_AMOUNT varchar,
	SETTLEMENT_AMOUNT varchar,
	TOTAL_DEBIT_AMOUNT varchar,
	TOTAL_DEBIT_ITEMS varchar,
	TOTAL_CREDIT_AMOUNT varchar,
	TOTAL_CREDIT_ITEMS varchar,
	TOTAL_ITEM_COUNT varchar,
	CURRENCY_INDICATOR_CODE varchar,
	CUSTOMER_SERVICE_PHONE varchar,
	FILE_IDENTIFICATION varchar,
	CREATION_DATE varchar,
	CREATION_TIME varchar,
	TOTAL_RECORD_COUNT varchar,
	MERCHANT_CITY varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_NAME varchar,
	MERCHANT_IDENTIFICATION varchar,
	MERCHANT_STATE varchar,
	MERCHANT_STREET_ADDRESS varchar,
	MERCHANT_ZIP_CODE varchar,
	PROCESSOR_ID varchar,
	PROCESSOR_NAME varchar,
	PROCESSOR_BUILDING_NUMBER varchar,
	PROCESSOR_STREET_NAME varchar,
	PROCESSOR_CITY varchar,
	PROCESSOR_COUNTRY varchar,
	PROCESSOR_ZIP_CODE varchar,
	PROCESSOR_PHONE_NUMBER varchar,
	EMAIL_ADDRESS varchar,
	SE_NUMBER varchar,
	SOC_NUMBER varchar,
	SOC_TEXT varchar,
	MERCHANT_DBA_NAME varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	FILE_NAME varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;