-- Create Table Statement for 'Vantiv Tandem Retail File Batch'
DROP TABLE IF EXISTS `VANTIV_TANDEM_RETAIL_FILE_BATCH`;
CREATE TABLE `VANTIV_TANDEM_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	NETWORK_ROUTING varchar,
	BIT_MAP_TYPE varchar,
	BIT03 varchar,
	BIT11 varchar,
	BIT32 varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT70 varchar,
	BIT74 varchar,
	BIT76 varchar,
	BIT86 varchar,
	BIT88 varchar,
	BIT115 varchar,
	BIT66_SETTLEMENT_CODE varchar,
	BIT74_RETURNS_COUNT varchar,
	BIT76_SALES_COUNT varchar,
	BIT86_RETURNS_AMOUNT varchar,
	BIT88_SALES_AMOUNT varchar,
	BIT124_WORKING_KEY varchar,
	BIT123_RESPONSE_CODE varchar,
	BIT123_ERROR_TEXT varchar,
	IS_TERMINAL_CAPTURE tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;