-- Create Table Statement for 'Vantiv Tandem Provisioning Transaction Response Detail'
DROP TABLE IF EXISTS `VANTIV_TANDEM_PROVISIONING_TRANSACTION_RESPONSE_DETAIL`;
CREATE TABLE `VANTIV_TANDEM_PROVISIONING_TRANSACTION_RESPONSE_DETAIL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	STATUS varchar,
	FIELD_NAME varchar,
	MERCHANT_NUMBER varchar,
	MID_TIE_BREAKER varchar,
	ERROR_DESCRIPTION varchar,
	TERMINAL_ID varchar,
	CUSTOMER_SPECIFIC_MERCHANT_LEVEL_ID varchar,
	CUSTOMER_SPECIFIC_TERMINAL_LEVEL_ID varchar,
	TANDEM_UPDATE_ID varchar,
	VANTIV_TANDEM_PROVISIONING_TRANSACTION_FK bigint(20),
	DBA_NAME varchar,
	VANTIV_MERCHANT_NUMBER varchar,
	VANTIV_STORE_NUMBER varchar,
	VANTIV_CHAIN_NUMBER varchar,
	HIERARCHY_LEVEL varchar,
	HIERARCHY_LEVEL varchar,
	HIERARCHY_LEVEL varchar,
	VANTIV_TANDEM_PROVISIONING_TRANSACTION_FK bigint(20),
	VANTIV_TANDEM_PROVISIONING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;