-- Create Table Statement for 'ProPay Provisioning Transaction'
DROP TABLE IF EXISTS `PRO_PAY_PROVISIONING_TRANSACTION`;
CREATE TABLE `PRO_PAY_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BUSINESS_ZIP varchar,
	COUNTRY varchar,
	DOING_BUSINESS_AS varchar,
	ACCOUNT_OWNERSHIP_TYPE varchar,
	EXP_DATE varchar,
	ZIP varchar,
	MAIL_ADDR3 varchar,
	ADDR3 varchar,
	SECONDARY_ACCOUNT_NAME varchar,
	DESCRIPTION varchar,
	BUSINESS_COUNTRY varchar,
	STATE varchar,
	MINITIAL varchar,
	PHONE_PIN varchar,
	MAIL_ZIP varchar,
	EVEN_PHONE varchar,
	EIN varchar,
	MCC_CODE varchar,
	APT_NUM varchar,
	MAIL_CITY varchar,
	DOB varchar,
	CITY varchar,
	LAST_NAME varchar,
	SOURCE_EMAIL varchar,
	MAIL_STATE varchar,
	DAY_PHONE varchar,
	SECONDARY_ACCOUNT_TYPE varchar,
	CURRENCY_CODE varchar,
	FIRST_NAME varchar,
	BUSINESS_ADDRESS2 varchar,
	BANK_NAME varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	EXTERNAL_ID varchar,
	TIER varchar,
	ACCOUNT_TYPE varchar,
	BUSINESS_STATE varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	ACCOUNT_NAME varchar,
	MAIL_ADDR varchar,
	INTL_ID varchar,
	USER_ID varchar,
	ADDR varchar,
	PAYMENT_METHOD_ID varchar,
	BUSINESS_ADDRESS varchar,
	ROUTING_NUMBER_MASKED varchar,
	PORTFOLIO_CODE int(11),
	STATUS varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	ACCNT_NUM varchar,
	ERROR_MESSAGE varchar,
	ERROR_CODE varchar,
	PASSWORD varchar,
	SECONDARY_ACCOUNT_COUNTRY_CODE varchar,
	SECONDARY_ROUTING_NUMBER_MASKED varchar,
	SECONDARY_ACCOUNT_OWNERSHIP_TYPE varchar,
	SECONDARY_ACCOUNT_NUMBER_MASKED varchar,
	TRANS_TYPE varchar,
	ROUTING_NUMBER_ENCODED varchar,
	SSN_ENCODED varchar,
	SECONDARY_ACCOUNT_NUMBER_ENCODED varchar,
	EIN_ENCODED varchar,
	SECONDARY_ROUTING_NUMBER_ENCODED varchar,
	ACCOUNT_NUMBER_ENCODED varchar,
	MAIL_COUNTRY varchar,
	ACCOUNT_COUNTRY_CODE varchar,
	SECONDARY_BANK_NAME varchar,
	BUSINESS_CITY varchar,
	RESELLER_CODE int(11),
	TERM_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;