-- Create Table Statement for 'Vantiv Tandem Provisioning Transaction'
DROP TABLE IF EXISTS `VANTIV_TANDEM_PROVISIONING_TRANSACTION`;
CREATE TABLE `VANTIV_TANDEM_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_NUMBER varchar,
	STATUS varchar,
	DATE_MERCHANT_ADDED varchar,
	STORE_TIME_ZONE varchar,
	MERCHANT_NAME varchar,
	DDA varchar,
	ABA varchar,
	MCC_CODE varchar,
	FEDERAL_TAX_ID varchar,
	STORE_NAME varchar,
	STORE_PHYSICAL_ADDRESS1 varchar,
	STORE_ADDRESS2 varchar,
	STORE_CITY varchar,
	STORE_STATE varchar,
	STORE_ZIP varchar,
	AVERAGE_TICKET_PRICE varchar,
	SWIPE_PERCENTAGE varchar,
	CONTACT_NAME varchar,
	ALTERNATE_MAIL_ADDRESS1 varchar,
	ALTERNATE_MAIL_ADDRESS2 varchar,
	ALTERNATE_MAIL_CITY varchar,
	ALTERNATE_MAIL_STATE varchar,
	ALTERNATE_MAIL_ZIP varchar,
	CONTACT_PHONE varchar,
	STORE_NUMBER varchar,
	STORE_EXTENDED_ZIP varchar,
	CHARGE_BACK_MAILING_ADDRESS varchar,
	STATEMENT_MAILING_ADDRESS varchar,
	VOUCHER_FLAGS varchar,
	ALTERNATE_MAIL_EXTENDED_ZIP varchar,
	CUSTOMER_SERVICE_PHONE varchar,
	ALTERNATE_MAIL_TIME_ZONE varchar,
	CARD_TYPE1 varchar,
	CARD_TYPE2 varchar,
	CARD_TYPE3 varchar,
	CARD_TYPE4 varchar,
	CARD_TYPE5 varchar,
	CARD_TYPE6 varchar,
	CARD_TYPE7 varchar,
	CARD_TYPE8 varchar,
	CARD_TYPE9 varchar,
	CARD_TYPE10 varchar,
	EXTERNAL_ACCOUNT_NUMBER1 varchar,
	EXTERNAL_ACCOUNT_NUMBER2 varchar,
	EXTERNAL_ACCOUNT_NUMBER3 varchar,
	EXTERNAL_ACCOUNT_NUMBER4 varchar,
	EXTERNAL_ACCOUNT_NUMBER5 varchar,
	EXTERNAL_ACCOUNT_NUMBER6 varchar,
	EXTERNAL_ACCOUNT_NUMBER7 varchar,
	EXTERNAL_ACCOUNT_NUMBER8 varchar,
	EXTERNAL_ACCOUNT_NUMBER9 varchar,
	EXTERNAL_ACCOUNT_NUMBER10 varchar,
	SALES_VOLUME1 varchar,
	SALES_VOLUME2 varchar,
	SALES_VOLUME3 varchar,
	SALES_VOLUME4 varchar,
	SALES_VOLUME5 varchar,
	SALES_VOLUME6 varchar,
	SALES_VOLUME7 varchar,
	SALES_VOLUME8 varchar,
	SALES_VOLUME9 varchar,
	SALES_VOLUME10 varchar,
	TICKET_AVERAGE1 varchar,
	TICKET_AVERAGE2 varchar,
	TICKET_AVERAGE3 varchar,
	TICKET_AVERAGE4 varchar,
	TICKET_AVERAGE5 varchar,
	TICKET_AVERAGE6 varchar,
	TICKET_AVERAGE7 varchar,
	TICKET_AVERAGE8 varchar,
	TICKET_AVERAGE9 varchar,
	TICKET_AVERAGE10 varchar,
	DISCOUNT_METHOD1 varchar,
	DISCOUNT_METHOD2 varchar,
	DISCOUNT_METHOD3 varchar,
	DISCOUNT_METHOD4 varchar,
	DISCOUNT_METHOD5 varchar,
	DISCOUNT_METHOD6 varchar,
	DISCOUNT_METHOD7 varchar,
	DISCOUNT_METHOD8 varchar,
	DISCOUNT_METHOD9 varchar,
	DISCOUNT_METHOD10 varchar,
	DISCOUNT_PERCENTAGE1 varchar,
	DISCOUNT_PERCENTAGE2 varchar,
	DISCOUNT_PERCENTAGE3 varchar,
	DISCOUNT_PERCENTAGE4 varchar,
	DISCOUNT_PERCENTAGE5 varchar,
	DISCOUNT_PERCENTAGE6 varchar,
	DISCOUNT_PERCENTAGE7 varchar,
	DISCOUNT_PERCENTAGE8 varchar,
	DISCOUNT_PERCENTAGE9 varchar,
	DISCOUNT_PERCENTAGE10 varchar,
	EQUIPMENT_CODE varchar,
	ENVIRONMENT varchar,
	AUTO_CLOSE varchar,
	AUTO_CLOSE_TIME varchar,
	EQUIPMENT_FLAG varchar,
	TERMINAL_ID varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	VANTIV_TANDEM_PROVISIONING_FILE_BATCH_FK bigint(20),
	BACKGROUND_VERIFICATION_RESULT_CODE bigint(20),
	VANTIV_TANDEM_PROVISIONING_TRANSACTION_RESPONSE_DETAIL_FK bigint(20),
	FEDERAL_TAX_ID varchar,
	ABA varchar,
	DDA varchar,
	FEDERAL_TAX_ID varchar,
	ABA varchar,
	DDA varchar,
	ALTERNATE_MAIL_TIME_ZONE varchar,
	CARD_TYPE7 varchar,
	EXTERNAL_ACCOUNT_NUMBER7 varchar,
	SALES_VOLUME7 varchar,
	CARD_TYPE8 varchar,
	CARD_TYPE9 varchar,
	CARD_TYPE10 varchar,
	EXTERNAL_ACCOUNT_NUMBER8 varchar,
	EXTERNAL_ACCOUNT_NUMBER9 varchar,
	EXTERNAL_ACCOUNT_NUMBER10 varchar,
	SALES_VOLUME8 varchar,
	SALES_VOLUME10 varchar,
	SALES_VOLUME9 varchar,
	TICKET_AVERAGE7 varchar,
	TICKET_AVERAGE8 varchar,
	TICKET_AVERAGE9 varchar,
	TICKET_AVERAGE10 varchar,
	DISCOUNT_METHOD7 varchar,
	DISCOUNT_METHOD8 varchar,
	DISCOUNT_METHOD10 varchar,
	DISCOUNT_METHOD9 varchar,
	DISCOUNT_PERCENTAGE7 varchar,
	DISCOUNT_PERCENTAGE10 varchar,
	DISCOUNT_PERCENTAGE8 varchar,
	DISCOUNT_PERCENTAGE9 varchar,
	CHARGE_BACK_MAILING_ADDRESS varchar,
	STATEMENT_MAILING_ADDRESS varchar,
	ALTERNATE_MAIL_TIME_ZONE varchar,
	CARD_TYPE7 varchar,
	EXTERNAL_ACCOUNT_NUMBER7 varchar,
	SALES_VOLUME7 varchar,
	CARD_TYPE8 varchar,
	CARD_TYPE9 varchar,
	CARD_TYPE10 varchar,
	EXTERNAL_ACCOUNT_NUMBER8 varchar,
	EXTERNAL_ACCOUNT_NUMBER9 varchar,
	EXTERNAL_ACCOUNT_NUMBER10 varchar,
	SALES_VOLUME8 varchar,
	SALES_VOLUME10 varchar,
	SALES_VOLUME9 varchar,
	TICKET_AVERAGE7 varchar,
	TICKET_AVERAGE8 varchar,
	TICKET_AVERAGE9 varchar,
	TICKET_AVERAGE10 varchar,
	DISCOUNT_METHOD7 varchar,
	DISCOUNT_METHOD8 varchar,
	DISCOUNT_METHOD10 varchar,
	DISCOUNT_METHOD9 varchar,
	DISCOUNT_PERCENTAGE7 varchar,
	DISCOUNT_PERCENTAGE10 varchar,
	DISCOUNT_PERCENTAGE8 varchar,
	DISCOUNT_PERCENTAGE9 varchar,
	CHARGE_BACK_MAILING_ADDRESS varchar,
	STATEMENT_MAILING_ADDRESS varchar,
	WEB_SITE_URL varchar,
	CUSTOMER_SPECIFIC_MERCHANT_LEVEL_ID varchar,
	WEB_SITE_URL varchar,
	CUSTOMER_SPECIFIC_MERCHANT_LEVEL_ID varchar,
	WEB_SITE_URL varchar,
	CUSTOMER_SPECIFIC_MERCHANT_LEVEL_ID varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	VANTIV_TANDEM_PROVISIONING_FILE_BATCH_FK bigint(20),
	VANTIV_TANDEM_PROVISIONING_FILE_BATCH_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	VANTIV_TANDEM_PROVISIONING_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;