-- Create Table Statement for 'Wells Fargo Provisioning Transaction'
DROP TABLE IF EXISTS `WELLS_FARGO_PROVISIONING_TRANSACTION`;
CREATE TABLE `WELLS_FARGO_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PROVISIONING_TRANSACTION_FK bigint(20),
	AGENT_ID varchar,
	REGISTRATION_ID varchar,
	CORPORATE_ID varchar,
	CHAIN_ID varchar,
	REGISTRATION_TYPE varchar,
	ACCOUNT_STATUS varchar,
	ACCOUNT_CLOSE_REASON varchar,
	DBA_NAME varchar,
	LEGAL_NAME varchar,
	IRS_FILING_NM varchar,
	TIN_TYPE varchar,
	DBA_CONTACT_F_NAME varchar,
	DBA_CONTACT_L_NAME varchar,
	DBA_CONTACT_TITLE varchar,
	DBA_EMAIL_ADDRESS varchar,
	DBA_PHONE_NUMBER varchar,
	DBA_STREET varchar,
	DBA_CITY varchar,
	DBA_STATE varchar,
	DBA_ZIP varchar,
	INTERNATIONAL_POSTAL_CODE varchar,
	DBA_COUNTRY varchar,
	BILL_TO_CONTACT_F_NAME varchar,
	BILL_TO_CONTACT_L_NAME varchar,
	BILL_TO_CONTACT_TITLE varchar,
	BILL_TO_EMAIL_ADDRESS varchar,
	BILL_TO_PHONE_NUMBER varchar,
	BILL_TO_STREET varchar,
	BILL_TO_CITY varchar,
	BILL_TO_STATE varchar,
	BILL_TO_ZIP varchar,
	BILL_TO_COUNTRY varchar,
	STATE_INCORPORATED varchar,
	CUSTOMER_SIGN_DATE varchar,
	CUST_SERVICE_PHONE varchar,
	WEB_SITE_ADDRESS varchar,
	PRODUCT_SERVICE_DESCRIPTION varchar,
	MCC_CODE varchar,
	OUTLET_VOLUME varchar,
	CHAIN_VOLUME varchar,
	AVERAGE_TKT varchar,
	MAXIMUM_TKT varchar,
	SHIP_TO_DAYS varchar,
	SEASONAL_IND varchar,
	BUSINESS_OPERATES_FROM_TYPE varchar,
	ACC_DEP_DEL_IN_FUTURE varchar,
	BUSINESS_TYPE varchar,
	CURRENCY_CODE varchar,
	PERCENT_KEYED varchar,
	B2B_PERCENT varchar,
	TRANS_SOURCE_PERCENT_INTERNET varchar,
	DDA3_ACCOUNT_TYPE varchar,
	MC_AUTH_INTEGRITY varchar,
	AMEX_INDUSTRY_TYPE varchar,
	STATUS_CODE varchar,
	ACCOUNT_NO varchar,
	TERMINAL_NUMBER varchar,
	COMPASS_DID varchar,
	DATA_WIRE_DID varchar,
	NASHVILLE_MERCHANT_NUMBER varchar,
	CREATE_DATE varchar,
	SERIAL_NO varchar,
	COMMENTS varchar,
	RESPONSE_FILE_FILE_STORE_CODE bigint(20),
	WELLS_FARGO_PROVISIONING_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;