-- Create Table Statement for 'Vantiv Lowell Provisioning Transaction'
DROP TABLE IF EXISTS `VANTIV_LOWELL_PROVISIONING_TRANSACTION`;
CREATE TABLE `VANTIV_LOWELL_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	REQUEST_CL varchar,
	ERROR_MESSAGE varchar,
	MERCHANT_ACCOUNT_CODE int(11),
	LEGAL_ENTITY_NAME varchar,
	LEGAL_ENTITY_TYPE varchar,
	DOING_BUSINESS_AS varchar,
	TAX_ID varchar,
	CONTACT_PHONE varchar,
	ANNUAL_CREDIT_CARD_SALES_VOLUME varchar,
	HAS_ACCEPTED_CREDIT_CARDS varchar,
	STREET_ADDRESS1 varchar,
	STREET_ADDRESS2 varchar,
	CITY varchar,
	STATE_PROVINCE varchar,
	POSTAL_CODE varchar,
	COUNTRY_CODE varchar,
	IS_EXCLUSIVE_TO_PSP varchar,
	IS_PCI_COMPLIANCE_VALIDATED varchar,
	SCANNING_VENDOR varchar,
	QUALIFIED_SECURITY_ASSESSOR varchar,
	MOST_RECENTLY_PASSED_SCAN varchar,
	REPORT_ON_COMPLIANCE varchar,
	PCI_LEVEL varchar,
	PRINCIPAL_FIRST_NAME varchar,
	PRINCIPAL_LAST_NAME varchar,
	PRINCIPAL_EMAIL_ADDRESS varchar,
	PRINCIPAL_CONTACT_PHONE varchar,
	PRINCIPAL_DATE_OF_BIRTH varchar,
	PRINCIPAL_DRIVERS_LICENSE_STATE varchar,
	PRINCIPAL_STREET_ADDRESS1 varchar,
	PRINCIPAL_STREET_ADDRESS2 varchar,
	PRINCIPAL_CITY varchar,
	PRINCIPAL_STATE_PROVINCE varchar,
	PRINCIPAL_POSTAL_CODE varchar,
	PRINCIPAL_COUNTRY_CODE varchar,
	TRANSACTION_ID varchar,
	LEGAL_ENTITY_ID varchar,
	PRINCIPAL_ID varchar,
	RESPONSE_PRINCIPAL_FIRST_NAME varchar,
	RESPONSE_PRINCIPAL_LAST_NAME varchar,
	RESPONSE_CODE varchar,
	RESPONSE_DESCRIPTION varchar,
	BUSINESS_SCORE varchar,
	BUSINESS_DESCRIPTION varchar,
	BUSINESS_NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE varchar,
	BUSINESS_NAME_ADDRESS_PHONE_ASSOCIATION_CODE varchar,
	BUSINESS_NAME_VERIFIED varchar,
	BUSINESS_ADDRESS_VERIFIED varchar,
	BUSINESS_CITY_VERIFIED varchar,
	BUSINESS_STATE_VERIFIED varchar,
	BUSINESS_ZIP_VERIFIED varchar,
	BUSINESS_PHONE_VERIFIED varchar,
	BUSINESS_TAX_ID_VERIFIED varchar,
	BUSINESS_RISK_INDICATOR1_CODE varchar,
	BUSINESS_RISK_INDICATOR2_CODE varchar,
	BUSINESS_RISK_INDICATOR3_CODE varchar,
	BUSINESS_RISK_INDICATOR4_CODE varchar,
	BUSINESS_RISK_INDICATOR5_CODE varchar,
	BUSINESS_RISK_INDICATOR6_CODE varchar,
	BUSINESS_RISK_INDICATOR1_DESCRIPTION varchar,
	BUSINESS_RISK_INDICATOR2_DESCRIPTION varchar,
	BUSINESS_RISK_INDICATOR3_DESCRIPTION varchar,
	BUSINESS_RISK_INDICATOR4_DESCRIPTION varchar,
	BUSINESS_RISK_INDICATOR5_DESCRIPTION varchar,
	BUSINESS_RISK_INDICATOR6_DESCRIPTION varchar,
	PRINCIPAL_SCORE varchar,
	PRINCIPAL_DESCRIPTION varchar,
	PRINCIPAL_NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE varchar,
	PRINCIPAL_NAME_ADDRESS_PHONE_ASSOCIATION_CODE varchar,
	PRINCIPAL_NAME_VERIFIED varchar,
	PRINCIPAL_ADDRESS_VERIFIED varchar,
	PRINCIPAL_PHONE_VERIFIED varchar,
	PRINCIPAL_SSN_VERIFIED varchar,
	PRINCIPAL_DOB_VERIFIED varchar,
	PRINCIPAL_RISK_INDICATOR1_CODE varchar,
	PRINCIPAL_RISK_INDICATOR2_CODE varchar,
	PRINCIPAL_RISK_INDICATOR3_CODE varchar,
	PRINCIPAL_RISK_INDICATOR4_CODE varchar,
	PRINCIPAL_RISK_INDICATOR5_CODE varchar,
	PRINCIPAL_RISK_INDICATOR6_CODE varchar,
	PRINCIPAL_RISK_INDICATOR1_DESCRIPTION varchar,
	PRINCIPAL_RISK_INDICATOR2_DESCRIPTION varchar,
	PRINCIPAL_RISK_INDICATOR3_DESCRIPTION varchar,
	PRINCIPAL_RISK_INDICATOR4_DESCRIPTION varchar,
	PRINCIPAL_RISK_INDICATOR5_DESCRIPTION varchar,
	PRINCIPAL_RISK_INDICATOR6_DESCRIPTION varchar,
	BUSINESS_TO_PRINCIPAL_ASSOCIATION_SCORE varchar,
	BUSINESS_TO_PRINCIPAL_ASSOCIATION_DESCRIPTION varchar,
	BUSINESS_NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION varchar,
	BUSINESS_NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION varchar,
	PRINCIPAL_NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION varchar,
	PRINCIPAL_NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION varchar,
	PRINCIPAL_NAME_ADDRESS_SSN_ASSOCIATION_CODE varchar,
	PRINCIPAL_NAME_ADDRESS_SSN_ASSOCIATION_DESCRIPTION varchar,
	BACKGROUND_CHECK_DECISION_NOTES varchar,
	BANKRUPTCY_TYPE varchar,
	BANKRUPTCY_COUNT varchar,
	BANKRUPTCY_COMPANY_NAME varchar,
	BANKRUPTCY_STREET_ADDRESS1 varchar,
	BANKRUPTCY_STREET_ADDRESS2 varchar,
	BANKRUPTCY_CITY varchar,
	BANKRUPTCY_STATE varchar,
	BANKRUPTCY_ZIP varchar,
	BANKRUPTCY_ZIP4 varchar,
	BANKRUPTCY_FILING_DATE varchar,
	LIEN_TYPE varchar,
	LIEN_RELEASED_COUNT varchar,
	LIEN_UNRELEASED_COUNT varchar,
	LIEN_COMPANY_NAME varchar,
	LIEN_STREET_ADDRESS1 varchar,
	LIEN_STREET_ADDRESS2 varchar,
	LIEN_CITY varchar,
	LIEN_STATE varchar,
	LIEN_ZIP varchar,
	LIEN_ZIP4 varchar,
	LIEN_FILING_DATE varchar,
	PRINCIPAL_DRIVERS_LICENSE_COUNTRY_CODE varchar,
	CREATE_DATE datetime,
	PROVISIONING_TRANSACTION_FK bigint(20),
	PRINCIPAL_SSN varchar,
	PRINCIPAL_DRIVERS_LICENSE varchar,
	SUB_MERCHANT_CREATE_DATE datetime,
	AMEX_MID varchar,
	ROUTING_NUMBER_MASKED varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	DISCOVER_CONVEYED_MID varchar,
	CUSTOMER_SERVICE_NUMBER varchar,
	HARD_CODED_BILLING_DESCRIPTOR varchar,
	MAX_TRANSACTION_AMOUNT varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_NAME varchar,
	PSP_MERCHANT_ID varchar,
	URL varchar,
	CREATE_CREDENTIALS varchar,
	IS_ECHECK_ENABLED tinyint(1),
	ECHECK_BILLING_DESCRIPTOR varchar,
	ECHECK_COMPANY_NAME varchar,
	IS_AMEX_ACQUIRED tinyint(1),
	PURCHASE_CURRENCY varchar,
	SETTLEMENT_CURRENCY varchar,
	MERCHANT_IDENT_STRING varchar,
	SUB_MERCHANT_ID varchar,
	SUB_MERCHANT_TRANSACTION_ID varchar,
	DISABLED varchar,
	SUB_MERCHANT_ERROR_MESSAGE varchar,
	SUB_MERCHANT_PROCESSING_STATUS varchar,
	SUB_MERCHANT_RESULT_DATA longtext,
	LEGAL_ENTITY_RESULT_DATA longtext,
	LEGAL_ENTITY_OWNERSHIP_TYPE varchar,
	PRINCIPAL_STAKE_PERCENT varchar,
	IS_DUPLICATE tinyint(1),
	ORIGINAL_LEGAL_ENTITY_ID varchar,
	ORIGINAL_LEGAL_ENTITY_STATUS varchar,
	LEGAL_ENTITY_RETRIEVAL_RESULT_DATA longtext,
	PRINCIPAL_TITLE varchar,
	LEGAL_ENTITY_RETRIEVAL_RESULT_DATA longtext,
	PRINCIPAL_TITLE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;