-- Create Table Statement for 'Paymentech Provisioning Transaction'
DROP TABLE IF EXISTS `PAYMENTECH_PROVISIONING_TRANSACTION`;
CREATE TABLE `PAYMENTECH_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SUB_MERCHANT_IDENTIFIER varchar,
	SUB_MERCHANT_NAME varchar,
	SUB_MERCHANT_DBA_NAME varchar,
	SUB_MERCHANT_TAX_ID varchar,
	SUB_MERCHANT_TAX_ID_IDENTIFIER varchar,
	SUB_MERCHANT_CATEGORY_CODE varchar,
	SUB_MERCHANT_STATUS varchar,
	STREET_ADDRESS1 varchar,
	STREET_ADDRESS2 varchar,
	CITY varchar,
	STATE varchar,
	COUNTRY varchar,
	ZIP_CODE varchar,
	PHONE varchar,
	PRIMARY_CONTACT_EMAIL_ADDRESS varchar,
	WEBSITE varchar,
	CARD_HOLDER_TERMINAL_INDICATOR varchar,
	ERROR_DESCRIPTION varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	PAYMENTECH_PROVISIONING_FILE_BATCH_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;