-- Create Table Statement for 'First Data Compass Retail File Batch'
DROP TABLE IF EXISTS `FIRST_DATA_COMPASS_RETAIL_FILE_BATCH`;
CREATE TABLE `FIRST_DATA_COMPASS_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_NAME varchar,
	PID varchar,
	SID varchar,
	CREATION_DATE varchar,
	MERCHANT_SPACE varchar,
	CUSTOMER_SERVICE_PHONE_NUMBER varchar,
	SALES_AMOUNT varchar,
	REFUNDS_AMOUNT varchar,
	ORDER_COUNT varchar,
	BATCH_RECORD_COUNT varchar,
	FILE_RECORD_COUNT varchar,
	TOTAL_AMOUNT varchar,
	SUBMISSION_NUMBER varchar,
	TPP_ID varchar,
	MERCHANT_STREET varchar,
	MERCHANT_CITY varchar,
	MERCHANT_REGION varchar,
	MERCHANT_POSTAL_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	TOKEN_TYPE varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	MERCHANT_CITY varchar,
	UNIQUE_FILE_ID varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_ID varchar,
	UNIQUE_FILE_ID varchar,
	MERCHANT_CITY varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_ID varchar,
	UNIQUE_FILE_ID varchar,
	MERCHANT_CITY varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;