-- Create Table Statement for 'FirstData North EDC Retail File Batch'
DROP TABLE IF EXISTS `FIRST_DATA_NORTH_EDC_RETAIL_FILE_BATCH`;
CREATE TABLE `FIRST_DATA_NORTH_EDC_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	BATCH_TRANSACTION_COUNT varchar,
	BATCH_TRANSACTION_AMOUNT varchar,
	RESPONSE_TEXT varchar,
	MERCHANT_NUMBER varchar,
	TERMINAL_ID varchar,
	SETTLEMENT_DATE_TIME varchar,
	TOTAL_COUNT int(11),
	TOTAL_AMOUNT int(11),
	PROVIDER_CHARGE_TRANSACTIONS bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;