-- Create Table Statement for 'Tsys Provisioning Transaction'
DROP TABLE IF EXISTS `TSYS_PROVISIONING_TRANSACTION`;
CREATE TABLE `TSYS_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BE_MERCH_NUM varchar,
	FE_MERCH_NUM varchar,
	ASSOC_NUM varchar,
	BANK_NUMBER varchar,
	BIN_NUM varchar,
	DBA_NAME varchar,
	MERCHANT_LEGAL_NAM varchar,
	DATE_OPENED varchar,
	BRANCH varchar,
	SIC varchar,
	MCC varchar,
	OWNER_FIRST_NAME varchar,
	OWNER_LAST_NAME varchar,
	OWNER_NAME varchar,
	OWNER_DOB varchar,
	SOCIAL_SECURITY_NUMBER varchar,
	DBA_CITY varchar,
	DBA_STATE varchar,
	DBA_COUNTRY varchar,
	DBA_POSTAL_CODE varchar,
	DBA_PHONE varchar,
	YEARS_IN_BUSINESS varchar,
	FEDERAL_TAX_ID varchar,
	DAILY_AUTH_COUNT varchar,
	DRIVERS_LICENSE_NUMBER varchar,
	OWN_STATE varchar,
	MERCHANT_EMAIL varchar,
	MERCHANT_WEBSITE varchar,
	TYPE_BUSINESS varchar,
	CUSTOMER_SERVICE_PHONE_NUM varchar,
	AVERAGE_TICKET varchar,
	ANNUAL_VOLUME varchar,
	INCORPORATION varchar,
	HIGH_TICKET varchar,
	DISCOVER_ACCOUNT_NUMBER varchar,
	DISC_AUTH_CAP_NUMBER varchar,
	AMEX_OWNERSHIP_TYPE varchar,
	REQUEST_CL varchar,
	ADD_MERCHANT_RESULT_DATA longtext,
	DISCOVER_REGISTER_RESULT_DATA longtext,
	PROVISIONING_TRANSACTION_FK bigint(20),
	BUSINESS_TYPE varchar,
	VIEW_MERCHANT_RESULT_DATA longtext,
	DBA_ADDRESS varchar,
	ATTN varchar,
	NAME varchar,
	MERCH_DBA_NAME varchar,
	BUSINESS_NAME varchar,
	SELLER_LEGAL_NAME varchar,
	SIG_OWNER_FIRST_NAME varchar,
	SIG_OWNER_LAST_NAME varchar,
	BUSINESS_PRINCIPAL_FIRST_NAME varchar,
	BUSINESS_PRINCIPAL_LAST_NAME varchar,
	MERCH_DBA_CITY varchar,
	SELLER_CITY varchar,
	SIG_OWNER_CITY varchar,
	CITY varchar,
	MERCH_DBA_POSTAL varchar,
	MERCH_DBA_ADDRESS_LINE1 varchar,
	MERCHANT_ADDRESS varchar,
	MERCH_DBA_ADDRESS_LINE2 varchar,
	SELLER_EMAIL_ADDRESS varchar,
	EMAIL varchar,
	MERCH_DBA_PHONE varchar,
	SIG_OWNER_POSTAL_CD varchar,
	SIG_OWNER_STATE varchar,
	SIG_OWNER_COUNTRY varchar,
	BUSINESS_PRINCIPAL_ADDRESS1 varchar,
	BUSINESS_PRINCIPAL_ADDRESS2 varchar,
	BUSINESS_PRINCIPAL_CITY varchar,
	BUSINESS_PRINCIPAL_COUNTRY_CODE varchar,
	MERCH_DBA_COUNTRY_CODE varchar,
	ACQUIRER_ID varchar,
	CURRENCY varchar,
	DISCOVER_MERCHANT_ID varchar,
	DISCOVER_STORE_NUMBER varchar,
	AGENT varchar,
	CHAIN varchar,
	ADD_MERCHANT_FAULT_CODE varchar,
	ADD_MERCHANT_FAULT_STRING varchar,
	DISCOVER_REGISTER_FAULT_CODE varchar,
	DISCOVER_REGISTER_FAULT_STRING varchar,
	VIEW_MERCHANT_FAULT_CODE varchar,
	VIEW_MERCHANT_FAULT_STRING varchar,
	ADD_MERCHANT_ERROR_CODE varchar,
	ADD_MERCHANT_ERROR_DESCRIPTION varchar,
	ADD_MERCHANT_TRANSACTION_ID varchar,
	ADD_MERCHANT_ERROR_LIST longtext,
	ADD_MERCHANT_WARNING_LIST longtext,
	AMEX_ACCOUNT_NUMBER varchar,
	JCB_ACCOUNT_NUMBER varchar,
	INDUSTRY_SE_NUM varchar,
	SELLER_ID varchar,
	DISCOVER_REGISTER_ERROR_CODE varchar,
	DISCOVER_REGISTER_ERROR_DESCRIPTION varchar,
	DISCOVER_REGISTER_TRANSACTION_ID varchar,
	DISCOVER_REGISTER_ERROR_LIST longtext,
	DISCOVER_REGISTER_WARNING_LIST longtext,
	VIEW_MERCHANT_ERROR_CODE varchar,
	VIEW_MERCHANT_ERROR_DESCRIPTION varchar,
	VIEW_MERCHANT_TRANSACTION_ID varchar,
	VIEW_MERCHANT_ERROR_LIST longtext,
	VIEW_MERCHANT_WARNING_LIST longtext,
	USER_DATA2 varchar,
	SALES_CHANNEL_NAME varchar,
	SALES_REPRESENTIVE_ID varchar,
	SAVE_MERCHANT_DDA_ERROR_CODE varchar,
	SAVE_MERCHANT_DDA_FAULT_CODE varchar,
	SAVE_MERCHANT_DDA_ERROR_DESCRIPTION varchar,
	SAVE_MERCHANT_DDA_FAULT_STRING varchar,
	SAVE_MERCHANT_PRICING_ERROR_CODE varchar,
	SAVE_MERCHANT_PRICING_FAULT_CODE varchar,
	SAVE_MERCHANT_PRICING_ERROR_DESCRIPTION varchar,
	SAVE_MERCHANT_PRICING_FAULT_STRING varchar,
	SAVE_MERCHANT_DDA_REQUEST_ID varchar,
	SAVE_MERCHANT_PRICING_REQUEST_ID varchar,
	SAVE_MERCHANT_DDA_RESULT_DATA longtext,
	SAVE_MERCHANT_PRICING_RESULT_DATA longtext,
	ERG_ID varchar,
	MERCHANT_PRICING_START_DATE varchar,
	SAVE_MERCHANT_DDA_ERROR_LIST longtext,
	SAVE_MERCHANT_PRICING_ERROR_LIST longtext,
	NEXT_ACTION varchar,
	AUTH_SIGNER_TITLE varchar,
	BUSINESS_PRINCIPAL_TITLE varchar,
	DST varchar,
	DST varchar,
	DST varchar,
	EXCESSIVE_TRAN_SALE_AMOUNT int(11),
	EXCESSIVE_TRAN_CREDIT_AMOUNT int(11),
	EXCESSIVE_TRAN_SALE_AMOUNT int(11),
	EXCESSIVE_TRAN_CREDIT_AMOUNT int(11),
	EXCESSIVE_TRAN_SALE_AMOUNT int(11),
	EXCESSIVE_TRAN_CREDIT_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;