-- Create Table Statement for 'Retail Elavon Profile'
DROP TABLE IF EXISTS `RETAIL_ELAVON_PROFILE`;
CREATE TABLE `RETAIL_ELAVON_PROFILE` (
	ID bigint(20) NOT NULL,
	REG_KEY varchar,
	BANK_NBR varchar,
	VENDOR_ID varchar,
	RETAIL_TERMINAL_NBR varchar,
	MOTO_TERMINAL_NBR varchar,
	ECOMMERCE_TERMINAL_NBR varchar,
	DESTINATION_NUMBER varchar,
	MERCHANT_DBA_NAME varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	MERCHANT_ZIP_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	CUSTOMER_SERVICE_NUMBER varchar,
	VERSION_CL varchar,
	RESTAURANT_TERMINAL_NBR varchar,
	RETAIL_MERCHANT_ID varchar,
	RESTAURANT_MERCHANT_ID varchar,
	MOTO_MERCHANT_ID varchar,
	ECOMMERCE_MERCHANT_ID varchar,
	IS_TEST_MODE tinyint(1),
	DESCRIPTOR_PREFIX varchar,
	KEY_POINTER_CL varchar,
	MERCHANT_STREET_ADDRESS varchar,
	DESCRIPTOR varchar,
	INSTITUTION_NAME varchar,
	EMAIL_ADDRESS varchar,
	SUB_MERCHANT_ID varchar,
	FILE_IDENTIFICATION varchar,
	PROCESSOR_ID varchar,
	PROCESSOR_NAME varchar,
	PROCESSOR_BUILDING_NUMBER varchar,
	PROCESSOR_STREET_NAME varchar,
	PROCESSOR_CITY varchar,
	PROCESSOR_COUNTRY_CODE varchar,
	PROCESSOR_ZIP_CODE varchar,
	PROCESSOR_PHONE_NUMBER varchar,
	SE_NUMBER varchar,
	RETAIL_MCC varchar,
	RESTAURANT_MCC varchar,
	MOTO_MCC varchar,
	ECOMMERCE_MCC varchar,
	RETAIL_POINT_OF_SALE_NAME varchar,
	RESTAURANT_POINT_OF_SALE_NAME varchar,
	ECOMMERCE_POINT_OF_SALE_NAME varchar,
	MOTO_POINT_OF_SALE_NAME varchar,
	MERCHANT_COUNTRY_CODE varchar,
	PROCESSOR_COUNTRY_CODE varchar,
	MERCHANT_ZIP_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	PROCESSOR_COUNTRY_CODE varchar,
	MERCHANT_ZIP_CODE varchar,
	VAT_REGISTRATION_NUMBER varchar,
	SUB_MERCHANT_TAX_ID varchar,
	PAYMENT_FACILITATOR_ID varchar,
	VAT_REGISTRATION_NUMBER varchar,
	SUB_MERCHANT_TAX_ID varchar,
	PAYMENT_FACILITATOR_ID varchar,
	IS_FILE_RENAMING_REQUIRED tinyint(1),
	IS_FILE_RENAMING_REQUIRED tinyint(1),
	VAT_REGISTRATION_NUMBER varchar,
	SUB_MERCHANT_TAX_ID varchar,
	PAYMENT_FACILITATOR_ID varchar,
	IS_FILE_RENAMING_REQUIRED tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;