Vantiv Lowell Provisioning Transaction UML

Added On:  05/17/18 

SQL Table:  VANTIV_LOWELL_PROVISIONING_TRANSACTION 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  VantivLowellProvisioningTransaction 

Available Fields:

• Account Number Masked
• Amex Mid
• Annual Credit Card Sales Volume
• Background Check Decision Notes
• Bank Account Number
• Bank Routing Number
• Bankruptcy City
• Bankruptcy Company Name
• Bankruptcy Count
• Bankruptcy Filing Date
• Bankruptcy State
• Bankruptcy Street Address 1
• Bankruptcy Street Address 2
• Bankruptcy Type
• Bankruptcy Zip
• Bankruptcy Zip 4
• Business Address Verified
• Business City Verified
• Business Description
• Business Name Address Phone Association Code
• Business Name Address Phone Association Description
• Business Name Address Tax Id Association Code
• Business Name Address Tax Id Association Description
• Business Name Verified
• Business Phone Verified
• Business Risk Indicator 1 Code
• Business Risk Indicator 1 Description
• Business Risk Indicator 2 Code
• Business Risk Indicator 2 Description
• Business Risk Indicator 3 Code
• Business Risk Indicator 3 Description
• Business Risk Indicator 4 Code
• Business Risk Indicator 4 Description
• Business Risk Indicator 5 Code
• Business Risk Indicator 5 Description
• Business Risk Indicator 6 Code
• Business Risk Indicator 6 Description
• Business Score
• Business State Verified
• Business Tax Id Verified
• Business To Principal Association Description
• Business To Principal Association Score
• Business Zip Verified
• City
• Contact Phone
• Country Code
• Create Credentials
• Create Date
• Customer Service Number
• Disabled
• Discover Conveyed Mid
• Doing Business As

• Echeck Billing Descriptor
• Echeck Company Name
• Error Message
• Hard Coded Billing Descriptor
• Has Accepted Credit Cards
• Id
• Is Amex Acquired
• Is Duplicate
• Is Echeck Enabled
• Is Exclusive To Psp
• Is Pci Compliance Validated
• Legal Entity Id
• Legal Entity Name
• Legal Entity Ownership Type
• Legal Entity Result Data
• Legal Entity Retrieval Result Data
• Legal Entity Type
• Lien City
• Lien Company Name
• Lien Filing Date
• Lien Released Count
• Lien State
• Lien Street Address 1
• Lien Street Address 2
• Lien Type
• Lien Unreleased Count
• Lien Zip
• Lien Zip 4
• Max Transaction Amount
• Merchant Account Code
• Merchant Category Code
• Merchant Ident String
• Merchant Name
• Most Recently Passed Scan
• Original Legal Entity Id
• Original Legal Entity Status
• Pci Level
• Postal Code
• Principal Address Verified
• Principal City
• Principal Contact Phone
• Principal Country Code
• Principal Date Of Birth
• Principal Description
• Principal Dob Verified
• Principal Drivers License
• Principal Drivers License Country Code
• Principal Drivers License State
• Principal Email Address
• Principal First Name
• Principal Id
• Principal Last Name

• Principal Name Address Phone Association Code
• Principal Name Address Phone Association Description
• Principal Name Address Ssn Association Code
• Principal Name Address Ssn Association Description
• Principal Name Address Tax Id Association Code
• Principal Name Address Tax Id Association Description
• Principal Name Verified
• Principal Phone Verified
• Principal Postal Code
• Principal Risk Indicator 1 Code
• Principal Risk Indicator 1 Description
• Principal Risk Indicator 2 Code
• Principal Risk Indicator 2 Description
• Principal Risk Indicator 3 Code
• Principal Risk Indicator 3 Description
• Principal Risk Indicator 4 Code
• Principal Risk Indicator 4 Description
• Principal Risk Indicator 5 Code
• Principal Risk Indicator 5 Description
• Principal Risk Indicator 6 Code
• Principal Risk Indicator 6 Description
• Principal Score
• Principal Ssn
• Principal Ssn Verified
• Principal Stake Percent
• Principal State Province
• Principal Street Address 1
• Principal Street Address 2
• Principal Title
• Provisioning Transaction
• Psp Merchant Id
• Purchase Currency
• Qualified Security Assessor
• Report On Compliance
• Request Cl
• Response Code
• Response Description
• Response Principal First Name
• Response Principal Last Name
• Routing Number Masked
• Scanning Vendor
• Settlement Currency
• State Province
• Street Address 1
• Street Address 2
• Sub Merchant Create Date
• Sub Merchant Error Message
• Sub Merchant Id
• Sub Merchant Processing Status
• Sub Merchant Result Data
• Sub Merchant Transaction Id
• Tax Id

• Transaction Id
• Url

Account Number Masked

Added On:  05/16/18

SQL Column:  ACCOUNT_NUMBER_MASKED

Java Field:  accountNumberMasked

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Amex Mid

Added On:  05/16/18

SQL Column:  AMEX_MID

Java Field:  amexMid

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Annual Credit Card Sales Volume

Added On:  05/16/18

SQL Column:  ANNUAL_CREDIT_CARD_SALES_VOLUME

Java Field:  annualCreditCardSalesVolume

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Background Check Decision Notes

Added On:  05/16/18

SQL Column:  BACKGROUND_CHECK_DECISION_NOTES

Java Field:  backgroundCheckDecisionNotes

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Bank Account Number

Added On:  05/16/18

SQL Column:  BANK_ACCOUNT_NUMBER

Java Field:  bankAccountNumber

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Bank Routing Number

Added On:  05/16/18

SQL Column:  BANK_ROUTING_NUMBER

Java Field:  bankRoutingNumber

Status:  Active

SQL Type:  varchar

Java Type:  String

Attributes: Transient

Bankruptcy City

Added On:  05/16/18

SQL Column:  BANKRUPTCY_CITY

Java Field:  bankruptcyCity

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Bankruptcy Company Name

Added On:  05/16/18

SQL Column:  BANKRUPTCY_COMPANY_NAME

Java Field:  bankruptcyCompanyName

Status:  Active

SQL Type:  varchar(120)

Java Type:  String

Attributes:

Bankruptcy Count

Added On:  05/16/18

SQL Column:  BANKRUPTCY_COUNT

Java Field:  bankruptcyCount

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Bankruptcy Filing Date

Added On:  05/16/18

SQL Column:  BANKRUPTCY_FILING_DATE

Java Field:  bankruptcyFilingDate

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Bankruptcy State

Added On:  05/16/18

SQL Column:  BANKRUPTCY_STATE

Java Field:  bankruptcyState

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Bankruptcy Street Address 1

Added On:  05/16/18

SQL Column:  BANKRUPTCY_STREET_ADDRESS1

Java Field:  bankruptcyStreetAddress1

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Bankruptcy Street Address 2

Added On:  05/16/18

SQL Column:  BANKRUPTCY_STREET_ADDRESS2

Java Field:  bankruptcyStreetAddress2

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Bankruptcy Type

Added On:  05/16/18

SQL Column:  BANKRUPTCY_TYPE

Java Field:  bankruptcyType

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Bankruptcy Zip

Added On:  05/16/18

SQL Column:  BANKRUPTCY_ZIP

Java Field:  bankruptcyZip

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Bankruptcy Zip 4

Added On:  05/16/18

SQL Column:  BANKRUPTCY_ZIP4

Java Field:  bankruptcyZip4

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Business Address Verified

Added On:  05/16/18

SQL Column:  BUSINESS_ADDRESS_VERIFIED

Java Field:  businessAddressVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Business City Verified

Added On:  05/16/18

SQL Column:  BUSINESS_CITY_VERIFIED

Java Field:  businessCityVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Business Description

Added On:  05/16/18

SQL Column:  BUSINESS_DESCRIPTION

Java Field:  businessDescription

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business Name Address Phone Association Code

Added On:  05/16/18

SQL Column:  BUSINESS_NAME_ADDRESS_PHONE_ASSOCIATION_CODE

Java Field:  businessNameAddressPhoneAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Name Address Phone Association Description

Added On:  05/16/18

SQL Column:  BUSINESS_NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION

Java Field:  businessNameAddressPhoneAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

Business Name Address Tax Id Association Code

Added On:  05/16/18

SQL Column:  BUSINESS_NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE

Java Field:  businessNameAddressTaxIdAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Name Address Tax Id Association Description

Added On:  05/16/18

SQL Column:  BUSINESS_NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION

Java Field:  businessNameAddressTaxIdAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

Business Name Verified

Added On:  05/16/18

SQL Column:  BUSINESS_NAME_VERIFIED

Java Field:  businessNameVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Business Phone Verified

Added On:  05/16/18

SQL Column:  BUSINESS_PHONE_VERIFIED

Java Field:  businessPhoneVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Business Risk Indicator 1 Code

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR1_CODE

Java Field:  businessRiskIndicator1Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Risk Indicator 1 Description

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR1_DESCRIPTION

Java Field:  businessRiskIndicator1Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business Risk Indicator 2 Code

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR2_CODE

Java Field:  businessRiskIndicator2Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Risk Indicator 2 Description

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR2_DESCRIPTION

Java Field:  businessRiskIndicator2Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business Risk Indicator 3 Code

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR3_CODE

Java Field:  businessRiskIndicator3Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Risk Indicator 3 Description

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR3_DESCRIPTION

Java Field:  businessRiskIndicator3Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business Risk Indicator 4 Code

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR4_CODE

Java Field:  businessRiskIndicator4Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Risk Indicator 4 Description

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR4_DESCRIPTION

Java Field:  businessRiskIndicator4Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business Risk Indicator 5 Code

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR5_CODE

Java Field:  businessRiskIndicator5Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Risk Indicator 5 Description

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR5_DESCRIPTION

Java Field:  businessRiskIndicator5Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business Risk Indicator 6 Code

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR6_CODE

Java Field:  businessRiskIndicator6Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Business Risk Indicator 6 Description

Added On:  05/16/18

SQL Column:  BUSINESS_RISK_INDICATOR6_DESCRIPTION

Java Field:  businessRiskIndicator6Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business Score

Added On:  05/16/18

SQL Column:  BUSINESS_SCORE

Java Field:  businessScore

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Business State Verified

Added On:  05/16/18

SQL Column:  BUSINESS_STATE_VERIFIED

Java Field:  businessStateVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Business Tax Id Verified

Added On:  05/16/18

SQL Column:  BUSINESS_TAX_ID_VERIFIED

Java Field:  businessTaxIdVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Business To Principal Association Description

Added On:  05/16/18

SQL Column:  BUSINESS_TO_PRINCIPAL_ASSOCIATION_DESCRIPTION

Java Field:  businessToPrincipalAssociationDescription

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Business To Principal Association Score

Added On:  05/16/18

SQL Column:  BUSINESS_TO_PRINCIPAL_ASSOCIATION_SCORE

Java Field:  businessToPrincipalAssociationScore

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Business Zip Verified

Added On:  05/16/18

SQL Column:  BUSINESS_ZIP_VERIFIED

Java Field:  businessZipVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

City

Added On:  05/16/18

SQL Column:  CITY

Java Field:  city

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Contact Phone

Added On:  05/16/18

SQL Column:  CONTACT_PHONE

Java Field:  contactPhone

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Country Code

Added On:  05/16/18

SQL Column:  COUNTRY_CODE

Java Field:  countryCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Create Credentials

Added On:  05/16/18

SQL Column:  CREATE_CREDENTIALS

Java Field:  createCredentials

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Create Date

Added On:  05/16/18

SQL Column:  CREATE_DATE

Java Field:  createDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Customer Service Number

Added On:  05/16/18

SQL Column:  CUSTOMER_SERVICE_NUMBER

Java Field:  customerServiceNumber

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Disabled

Added On:  05/16/18

SQL Column:  DISABLED

Java Field:  disabled

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Discover Conveyed Mid

Added On:  05/16/18

SQL Column:  DISCOVER_CONVEYED_MID

Java Field:  discoverConveyedMid

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Doing Business As

Added On:  05/16/18

SQL Column:  DOING_BUSINESS_AS

Java Field:  doingBusinessAs

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Echeck Billing Descriptor

Added On:  05/16/18

SQL Column:  ECHECK_BILLING_DESCRIPTOR

Java Field:  echeckBillingDescriptor

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Echeck Company Name

Added On:  05/16/18

SQL Column:  ECHECK_COMPANY_NAME

Java Field:  echeckCompanyName

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Error Message

Added On:  05/16/18

SQL Column:  ERROR_MESSAGE

Java Field:  errorMessage

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Hard Coded Billing Descriptor

Added On:  05/16/18

SQL Column:  HARD_CODED_BILLING_DESCRIPTOR

Java Field:  hardCodedBillingDescriptor

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Has Accepted Credit Cards

Added On:  05/16/18

SQL Column:  HAS_ACCEPTED_CREDIT_CARDS

Java Field:  hasAcceptedCreditCards

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Id

Added On:  05/17/18

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Identifier of the object used for references; auto-incremented integer value.

Is Amex Acquired

Added On:  05/16/18

SQL Column:  IS_AMEX_ACQUIRED

Java Field:  isAmexAcquired

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Is Duplicate

Added On:  05/16/18

SQL Column:  IS_DUPLICATE

Java Field:  isDuplicate

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Is Echeck Enabled

Added On:  05/16/18

SQL Column:  IS_ECHECK_ENABLED

Java Field:  isEcheckEnabled

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes:

Is Exclusive To Psp

Added On:  05/16/18

SQL Column:  IS_EXCLUSIVE_TO_PSP

Java Field:  isExclusiveToPsp

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Is Pci Compliance Validated

Added On:  05/16/18

SQL Column:  IS_PCI_COMPLIANCE_VALIDATED

Java Field:  isPciComplianceValidated

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Legal Entity Id

Added On:  05/16/18

SQL Column:  LEGAL_ENTITY_ID

Java Field:  legalEntityId

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Legal Entity Name

Added On:  05/16/18

SQL Column:  LEGAL_ENTITY_NAME

Java Field:  legalEntityName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Legal Entity Ownership Type

Added On:  05/16/18

SQL Column:  LEGAL_ENTITY_OWNERSHIP_TYPE

Java Field:  legalEntityOwnershipType

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Legal Entity Result Data

Added On:  05/16/18

SQL Column:  LEGAL_ENTITY_RESULT_DATA

Java Field:  legalEntityResultData

Status:  Active

SQL Type:  longtext

Java Type:  String

Attributes:

Legal Entity Retrieval Result Data

Added On:  11/22/18

SQL Column:  LEGAL_ENTITY_RETRIEVAL_RESULT_DATA

Java Field:  legalEntityRetrievalResultData

Status:  Active

SQL Type:  longtext

Java Type:  String

Attributes:

Legal Entity Type

Added On:  05/16/18

SQL Column:  LEGAL_ENTITY_TYPE

Java Field:  legalEntityType

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Lien City

Added On:  05/16/18

SQL Column:  LIEN_CITY

Java Field:  lienCity

Status:  Active

SQL Type:  varchar(30)

Java Type:  String

Attributes:

Lien Company Name

Added On:  05/16/18

SQL Column:  LIEN_COMPANY_NAME

Java Field:  lienCompanyName

Status:  Active

SQL Type:  varchar(120)

Java Type:  String

Attributes:

Lien Filing Date

Added On:  05/16/18

SQL Column:  LIEN_FILING_DATE

Java Field:  lienFilingDate

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Lien Released Count

Added On:  05/16/18

SQL Column:  LIEN_RELEASED_COUNT

Java Field:  lienReleasedCount

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Lien State

Added On:  05/16/18

SQL Column:  LIEN_STATE

Java Field:  lienState

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Lien Street Address 1

Added On:  05/16/18

SQL Column:  LIEN_STREET_ADDRESS1

Java Field:  lienStreetAddress1

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Lien Street Address 2

Added On:  05/16/18

SQL Column:  LIEN_STREET_ADDRESS2

Java Field:  lienStreetAddress2

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Lien Type

Added On:  05/16/18

SQL Column:  LIEN_TYPE

Java Field:  lienType

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Lien Unreleased Count

Added On:  05/16/18

SQL Column:  LIEN_UNRELEASED_COUNT

Java Field:  lienUnreleasedCount

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Lien Zip

Added On:  05/16/18

SQL Column:  LIEN_ZIP

Java Field:  lienZip

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Lien Zip 4

Added On:  05/16/18

SQL Column:  LIEN_ZIP4

Java Field:  lienZip4

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Max Transaction Amount

Added On:  05/16/18

SQL Column:  MAX_TRANSACTION_AMOUNT

Java Field:  maxTransactionAmount

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Merchant Account Code

Added On:  05/16/18

SQL Column:  MERCHANT_ACCOUNT_CODE

Java Field:  merchantAccountCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Merchant Category Code

Added On:  05/16/18

SQL Column:  MERCHANT_CATEGORY_CODE

Java Field:  merchantCategoryCode

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Merchant Ident String

Added On:  05/16/18

SQL Column:  MERCHANT_IDENT_STRING

Java Field:  merchantIdentString

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Merchant Name

Added On:  05/16/18

SQL Column:  MERCHANT_NAME

Java Field:  merchantName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Most Recently Passed Scan

Added On:  05/16/18

SQL Column:  MOST_RECENTLY_PASSED_SCAN

Java Field:  mostRecentlyPassedScan

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Original Legal Entity Id

Added On:  05/16/18

SQL Column:  ORIGINAL_LEGAL_ENTITY_ID

Java Field:  originalLegalEntityId

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Original Legal Entity Status

Added On:  05/16/18

SQL Column:  ORIGINAL_LEGAL_ENTITY_STATUS

Java Field:  originalLegalEntityStatus

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Pci Level

Added On:  05/16/18

SQL Column:  PCI_LEVEL

Java Field:  pciLevel

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Postal Code

Added On:  05/16/18

SQL Column:  POSTAL_CODE

Java Field:  postalCode

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Principal Address Verified

Added On:  05/16/18

SQL Column:  PRINCIPAL_ADDRESS_VERIFIED

Java Field:  principalAddressVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Principal City

Added On:  05/16/18

SQL Column:  PRINCIPAL_CITY

Java Field:  principalCity

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Principal Contact Phone

Added On:  05/16/18

SQL Column:  PRINCIPAL_CONTACT_PHONE

Java Field:  principalContactPhone

Status:  Active

SQL Type:  varchar(13)

Java Type:  String

Attributes:

Principal Country Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_COUNTRY_CODE

Java Field:  principalCountryCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Principal Date Of Birth

Added On:  05/16/18

SQL Column:  PRINCIPAL_DATE_OF_BIRTH

Java Field:  principalDateOfBirth

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Principal Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_DESCRIPTION

Java Field:  principalDescription

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Principal Dob Verified

Added On:  05/16/18

SQL Column:  PRINCIPAL_DOB_VERIFIED

Java Field:  principalDobVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Principal Drivers License

Added On:  05/16/18

SQL Column:  PRINCIPAL_DRIVERS_LICENSE

Java Field:  principalDriversLicense

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Principal Drivers License Country Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_DRIVERS_LICENSE_COUNTRY_CODE

Java Field:  principalDriversLicenseCountryCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Principal Drivers License State

Added On:  05/16/18

SQL Column:  PRINCIPAL_DRIVERS_LICENSE_STATE

Java Field:  principalDriversLicenseState

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Principal Email Address

Added On:  05/16/18

SQL Column:  PRINCIPAL_EMAIL_ADDRESS

Java Field:  principalEmailAddress

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

Principal First Name

Added On:  05/16/18

SQL Column:  PRINCIPAL_FIRST_NAME

Java Field:  principalFirstName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Principal Id

Added On:  05/16/18

SQL Column:  PRINCIPAL_ID

Java Field:  principalId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Principal Last Name

Added On:  05/16/18

SQL Column:  PRINCIPAL_LAST_NAME

Java Field:  principalLastName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Principal Name Address Phone Association Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_NAME_ADDRESS_PHONE_ASSOCIATION_CODE

Java Field:  principalNameAddressPhoneAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Name Address Phone Association Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION

Java Field:  principalNameAddressPhoneAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

Principal Name Address Ssn Association Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_NAME_ADDRESS_SSN_ASSOCIATION_CODE

Java Field:  principalNameAddressSsnAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Name Address Ssn Association Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_NAME_ADDRESS_SSN_ASSOCIATION_DESCRIPTION

Java Field:  principalNameAddressSsnAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

Principal Name Address Tax Id Association Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE

Java Field:  principalNameAddressTaxIdAssociationCode

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Name Address Tax Id Association Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION

Java Field:  principalNameAddressTaxIdAssociationDescription

Status:  Active

SQL Type:  varchar(150)

Java Type:  String

Attributes:

Principal Name Verified

Added On:  05/16/18

SQL Column:  PRINCIPAL_NAME_VERIFIED

Java Field:  principalNameVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Principal Phone Verified

Added On:  05/16/18

SQL Column:  PRINCIPAL_PHONE_VERIFIED

Java Field:  principalPhoneVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Principal Postal Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_POSTAL_CODE

Java Field:  principalPostalCode

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Principal Risk Indicator 1 Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR1_CODE

Java Field:  principalRiskIndicator1Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Risk Indicator 1 Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR1_DESCRIPTION

Java Field:  principalRiskIndicator1Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Principal Risk Indicator 2 Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR2_CODE

Java Field:  principalRiskIndicator2Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Risk Indicator 2 Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR2_DESCRIPTION

Java Field:  principalRiskIndicator2Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Principal Risk Indicator 3 Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR3_CODE

Java Field:  principalRiskIndicator3Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Risk Indicator 3 Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR3_DESCRIPTION

Java Field:  principalRiskIndicator3Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Principal Risk Indicator 4 Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR4_CODE

Java Field:  principalRiskIndicator4Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Risk Indicator 4 Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR4_DESCRIPTION

Java Field:  principalRiskIndicator4Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Principal Risk Indicator 5 Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR5_CODE

Java Field:  principalRiskIndicator5Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Risk Indicator 5 Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR5_DESCRIPTION

Java Field:  principalRiskIndicator5Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Principal Risk Indicator 6 Code

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR6_CODE

Java Field:  principalRiskIndicator6Code

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Principal Risk Indicator 6 Description

Added On:  05/16/18

SQL Column:  PRINCIPAL_RISK_INDICATOR6_DESCRIPTION

Java Field:  principalRiskIndicator6Description

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Principal Score

Added On:  05/16/18

SQL Column:  PRINCIPAL_SCORE

Java Field:  principalScore

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Principal Ssn

Added On:  05/16/18

SQL Column:  PRINCIPAL_SSN

Java Field:  principalSsn

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Principal Ssn Verified

Added On:  05/16/18

SQL Column:  PRINCIPAL_SSN_VERIFIED

Java Field:  principalSsnVerified

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Principal Stake Percent

Added On:  05/16/18

SQL Column:  PRINCIPAL_STAKE_PERCENT

Java Field:  principalStakePercent

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Principal State Province

Added On:  05/16/18

SQL Column:  PRINCIPAL_STATE_PROVINCE

Java Field:  principalStateProvince

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Principal Street Address 1

Added On:  05/16/18

SQL Column:  PRINCIPAL_STREET_ADDRESS1

Java Field:  principalStreetAddress1

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Principal Street Address 2

Added On:  05/16/18

SQL Column:  PRINCIPAL_STREET_ADDRESS2

Java Field:  principalStreetAddress2

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Principal Title

Added On:  12/13/18

SQL Column:  PRINCIPAL_TITLE

Java Field:  principalTitle

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Provisioning Transaction

Added On:  05/16/18

SQL Column:  PROVISIONING_TRANSACTION_FK

Java Field:  provisioningTransaction

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References Provisioning Transaction

Attributes:

Psp Merchant Id

Added On:  05/16/18

SQL Column:  PSP_MERCHANT_ID

Java Field:  pspMerchantId

Status:  Active

SQL Type:  varchar(32)

Java Type:  String

Attributes:

Purchase Currency

Added On:  05/16/18

SQL Column:  PURCHASE_CURRENCY

Java Field:  purchaseCurrency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Qualified Security Assessor

Added On:  05/16/18

SQL Column:  QUALIFIED_SECURITY_ASSESSOR

Java Field:  qualifiedSecurityAssessor

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Report On Compliance

Added On:  05/16/18

SQL Column:  REPORT_ON_COMPLIANCE

Java Field:  reportOnCompliance

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Request Cl

Added On:  05/16/18

SQL Column:  REQUEST_CL

Java Field:  requestCl

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

References Vantiv Lowell Provisioning Request Classifier

Attributes:

Response Code

Added On:  05/16/18

SQL Column:  RESPONSE_CODE

Java Field:  responseCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Response Description

Added On:  05/16/18

SQL Column:  RESPONSE_DESCRIPTION

Java Field:  responseDescription

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Response Principal First Name

Added On:  05/16/18

SQL Column:  RESPONSE_PRINCIPAL_FIRST_NAME

Java Field:  responsePrincipalFirstName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Response Principal Last Name

Added On:  05/16/18

SQL Column:  RESPONSE_PRINCIPAL_LAST_NAME

Java Field:  responsePrincipalLastName

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Routing Number Masked

Added On:  05/16/18

SQL Column:  ROUTING_NUMBER_MASKED

Java Field:  routingNumberMasked

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

Scanning Vendor

Added On:  05/16/18

SQL Column:  SCANNING_VENDOR

Java Field:  scanningVendor

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Settlement Currency

Added On:  05/16/18

SQL Column:  SETTLEMENT_CURRENCY

Java Field:  settlementCurrency

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

State Province

Added On:  05/16/18

SQL Column:  STATE_PROVINCE

Java Field:  stateProvince

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Street Address 1

Added On:  05/16/18

SQL Column:  STREET_ADDRESS1

Java Field:  streetAddress1

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Street Address 2

Added On:  05/16/18

SQL Column:  STREET_ADDRESS2

Java Field:  streetAddress2

Status:  Active

SQL Type:  varchar(60)

Java Type:  String

Attributes:

Sub Merchant Create Date

Added On:  05/16/18

SQL Column:  SUB_MERCHANT_CREATE_DATE

Java Field:  subMerchantCreateDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

Sub Merchant Error Message

Added On:  05/16/18

SQL Column:  SUB_MERCHANT_ERROR_MESSAGE

Java Field:  subMerchantErrorMessage

Status:  Active

SQL Type:  varchar(512)

Java Type:  String

Attributes:

Sub Merchant Id

Added On:  05/16/18

SQL Column:  SUB_MERCHANT_ID

Java Field:  subMerchantId

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Sub Merchant Processing Status

Added On:  05/16/18

SQL Column:  SUB_MERCHANT_PROCESSING_STATUS

Java Field:  subMerchantProcessingStatus

Status:  Active

SQL Type:  varchar(5)

Java Type:  String

Attributes:

Sub Merchant Result Data

Added On:  05/16/18

SQL Column:  SUB_MERCHANT_RESULT_DATA

Java Field:  subMerchantResultData

Status:  Active

SQL Type:  longtext

Java Type:  String

Attributes:

Sub Merchant Transaction Id

Added On:  05/16/18

SQL Column:  SUB_MERCHANT_TRANSACTION_ID

Java Field:  subMerchantTransactionId

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Tax Id

Added On:  05/16/18

SQL Column:  TAX_ID

Java Field:  taxId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Transaction Id

Added On:  05/16/18

SQL Column:  TRANSACTION_ID

Java Field:  transactionId

Status:  Active

SQL Type:  varchar(19)

Java Type:  String

Attributes:

Url

Added On:  05/16/18

SQL Column:  URL

Java Field:  url

Status:  Active

SQL Type:  varchar(120)

Java Type:  String

Attributes: