-- Create Table Statement for 'Elavon EISOP Retail File Batch'
DROP TABLE IF EXISTS `ELAVON_EISOP_RETAIL_FILE_BATCH`;
CREATE TABLE `ELAVON_EISOP_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	ECTL_FILE_NUMBER varchar,
	SENDING_INSTITUTION_NAME varchar,
	MERCHANT_ID varchar,
	MERCHANT_DBA_NAME varchar,
	MERCHANT_CITY varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_SETTLEMENT_CURRENCY_CODE varchar,
	SETTLEMENT_DATE varchar,
	BATCH_NUMBER varchar,
	CUSTOMER_REFERENCE_NUMBER varchar,
	SUBMISSION_CURRENCY_CODE varchar,
	DYNAMIC_MERCHANT_INDICATOR varchar,
	DIGITAL_WALLET_MERCHANT_ENABLED_FLAG varchar,
	BATCH_PURCHASES_COUNT varchar,
	BATCH_PURCHASES_AMOUNT varchar,
	BATCH_REFUND_COUNT varchar,
	BATCH_REFUND_AMOUNT varchar,
	BATCH_PURCHASES_REVERSALS_COUNT varchar,
	BATCH_PURCHASES_REVERSALS_AMOUNT varchar,
	BATCH_TOTAL_COUNT varchar,
	BATCH_REFUND_REVERSAL_COUNT varchar,
	BATCH_REFUND_REVERSAL_AMOUNT varchar,
	BATCH_NET_AMOUNT varchar,
	BATCH_NET_SIGN varchar,
	FILE_PURCHASES_COUNT varchar,
	FILE_PURCHASES_AMOUNT varchar,
	FILE_REFUND_COUNT varchar,
	FILE_REFUND_AMOUNT varchar,
	FILE_PURCHASE_REVERSALS_COUNT varchar,
	FILE_PURCHASE_REVERSALS_AMOUNT varchar,
	FILE_REFUND_REVERSAL_COUNT varchar,
	FILE_REFUND_REVERSAL_AMOUNT varchar,
	FILE_TOTAL_COUNT varchar,
	FILE_NET_AMOUNT varchar,
	FILE_NET_SIGN varchar,
	FILE_RECORD_COUNT varchar,
	FILE_CREATION_DATE varchar,
	FILE_CREATION_TIME varchar,
	PROCESSOR_ID varchar,
	PROCESSOR_NAME varchar,
	BUILDING_NUMBER varchar,
	STREET_NAME varchar,
	CITY varchar,
	COUNTRY varchar,
	ZIP_CODE varchar,
	PHONE_NUMBER varchar,
	EMAIL_ADDRESS varchar,
	SE_NUMBER varchar,
	SETTLEMENT_CURRENCY varchar,
	MERCHANT_NAME varchar,
	MERCHANT_GROUP_IDENTIFIER varchar,
	SOC_NUMBER varchar,
	CURRENCY_OF_TDR_RECORDS varchar,
	SOC_MERCHANT_REFERENCE varchar,
	TDR_RECORD_COUNT varchar,
	AUXILIARY_RECORD_COUNT varchar,
	TOTAL_RECORD_COUNT varchar,
	CREDIT_TRANSACTIONS_COUNT varchar,
	VALUE_OF_CREDIT_TRANSACTIONS varchar,
	DEBIT_TRANSACTIONS_COUNT varchar,
	VALUE_OF_DEBIT_TRANSACTIONS varchar,
	NET_VALUE_OF_TRANSACTIONS varchar,
	FILE_NUMBER varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;