-- Create Table Statement for 'First Data Processing Cost Batch'
DROP TABLE IF EXISTS `FIRST_DATA_PROCESSING_COST_BATCH`;
CREATE TABLE `FIRST_DATA_PROCESSING_COST_BATCH` (
	ID bigint(20) NOT NULL,
	FILE_DATE varchar,
	MERCHANT_NAME varchar,
	LOCATION_ID varchar,
	STORE_NUMBER varchar,
	SIC_CODE varchar,
	EXTERNAL_ID varchar,
	BUYPASS_ID varchar,
	FUNDED_DATE_LOAD_DATE varchar,
	LOCATION_DBA_NAME varchar,
	LOCATION_ADDRESS varchar,
	LOCATION_CITY varchar,
	LOCATION_STATE_PROVINCE varchar,
	LOCATION_ZIP_POSTAL_CODE varchar,
	LOCATION_PHONE_NUMBER varchar,
	LOCATION_CONTACT_NAME varchar,
	HIERARCHY_ID varchar,
	HIERARCHY_LEVEL_NO varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;