-- Create Table Statement for 'Vantiv Lowell Legal Entity Transaction'
DROP TABLE IF EXISTS `VANTIV_LOWELL_LEGAL_ENTITY_TRANSACTION`;
CREATE TABLE `VANTIV_LOWELL_LEGAL_ENTITY_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PROVISION_PROFILE_NAME varchar,
	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,
	ERROR_MESSAGE 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,
	CREATE_DATE datetime,
	REQUEST_CL varchar,
	PORTFOLIO_CODE int(11),
	RESELLER_CODE int(11),
	PRINCIPAL_DRIVERS_LICENSE_COUNTRY_CODE varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	SUB_MERCHANT_PROCESSING_STATUS varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;