Vantiv Lowell Legal Entity Transaction UML


Added On:  04/15/13 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  VantivLowellLegalEntityTransaction 
Represents legal entity account creation transaction as it is defined in Vantiv Lowell's provisioning specification.
Available Fields:
Added On:  04/15/13
SQL Column:  ANNUAL_CREDIT_CARD_SALES_VOLUME
Java Field:  annualCreditCardSalesVolume
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Volume of the annual credit card sales processed by the entity.
Added On:  05/10/13
SQL Column:  BACKGROUND_CHECK_DECISION_NOTES
Java Field:  backgroundCheckDecisionNotes
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Additional notes about the background check associated with the entity.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_CITY
Java Field:  bankruptcyCity
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
City of the bankrupt company's mailing address.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_COMPANY_NAME
Java Field:  bankruptcyCompanyName
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Name of bankrupt company.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_COUNT
Java Field:  bankruptcyCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Bankruptcy count for a company.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_FILING_DATE
Java Field:  bankruptcyFilingDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The date when the bankruptcy was filed.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_STATE
Java Field:  bankruptcyState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
State code of the bankrupt company's mailing address.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_STREET_ADDRESS1
Java Field:  bankruptcyStreetAddress1
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Street (line 1) of the bankrupt company's mailing address.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_STREET_ADDRESS2
Java Field:  bankruptcyStreetAddress2
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Street (line 2) of the bankrupt company's mailing address.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_TYPE
Java Field:  bankruptcyType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  BANKRUPTCY_ZIP
Java Field:  bankruptcyZip
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
ZIP (or postal) code of the bankrupt company's mailing address.
Added On:  05/10/13
SQL Column:  BANKRUPTCY_ZIP4
Java Field:  bankruptcyZip4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Four-digit ZIP code of the bankrupt company's mailing address.
Added On:  04/16/13
SQL Column:  BUSINESS_ADDRESS_VERIFIED
Java Field:  businessAddressVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_CITY_VERIFIED
Java Field:  businessCityVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_DESCRIPTION
Java Field:  businessDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Additional information about the business entity.
Added On:  04/16/13
SQL Column:  BUSINESS_NAME_ADDRESS_PHONE_ASSOCIATION_CODE
Java Field:  businessNameAddressPhoneAssociationCode
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/26/13
SQL Column:  BUSINESS_NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION
Java Field:  businessNameAddressPhoneAssociationDescription
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE
Java Field:  businessNameAddressTaxIdAssociationCode
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/26/13
SQL Column:  BUSINESS_NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION
Java Field:  businessNameAddressTaxIdAssociationDescription
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_NAME_VERIFIED
Java Field:  businessNameVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_PHONE_VERIFIED
Java Field:  businessPhoneVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR1_CODE
Java Field:  businessRiskIndicator1Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR1_DESCRIPTION
Java Field:  businessRiskIndicator1Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR2_CODE
Java Field:  businessRiskIndicator2Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR2_DESCRIPTION
Java Field:  businessRiskIndicator2Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR3_CODE
Java Field:  businessRiskIndicator3Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR3_DESCRIPTION
Java Field:  businessRiskIndicator3Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR4_CODE
Java Field:  businessRiskIndicator4Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR4_DESCRIPTION
Java Field:  businessRiskIndicator4Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR5_CODE
Java Field:  businessRiskIndicator5Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR5_DESCRIPTION
Java Field:  businessRiskIndicator5Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR6_CODE
Java Field:  businessRiskIndicator6Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_RISK_INDICATOR6_DESCRIPTION
Java Field:  businessRiskIndicator6Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_SCORE
Java Field:  businessScore
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_STATE_VERIFIED
Java Field:  businessStateVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_TAX_ID_VERIFIED
Java Field:  businessTaxIdVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_TO_PRINCIPAL_ASSOCIATION_DESCRIPTION
Java Field:  businessToPrincipalAssociationDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_TO_PRINCIPAL_ASSOCIATION_SCORE
Java Field:  businessToPrincipalAssociationScore
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  BUSINESS_ZIP_VERIFIED
Java Field:  businessZipVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/15/13
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
City of the mailing address.
Added On:  04/15/13
SQL Column:  CONTACT_PHONE
Java Field:  contactPhone
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Service phone number that can be used for discussing any processing issues.
Added On:  04/16/13
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the merchant's mailing address.
Added On:  06/20/14
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created.
Added On:  04/15/13
SQL Column:  DOING_BUSINESS_AS
Java Field:  doingBusinessAs
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Merchant's "Doing Business As" name.
Added On:  04/24/13
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Error message generated by a processor.
Added On:  04/15/13
SQL Column:  HAS_ACCEPTED_CREDIT_CARDS
Java Field:  hasAcceptedCreditCards
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Identifies whether the entity accepted credit cards transactions.
Added On:  04/15/13
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.
Added On:  04/16/13
SQL Column:  IS_EXCLUSIVE_TO_PSP
Java Field:  isExclusiveToPsp
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  IS_PCI_COMPLIANCE_VALIDATED
Java Field:  isPciComplianceValidated
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  LEGAL_ENTITY_ID
Java Field:  legalEntityId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Identifier if the legal entity assigned by a processor.
Added On:  04/15/13
SQL Column:  LEGAL_ENTITY_NAME
Java Field:  legalEntityName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Legal name of the entity.
Added On:  04/15/13
SQL Column:  LEGAL_ENTITY_TYPE
Java Field:  legalEntityType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Type of the entity.
Added On:  05/10/13
SQL Column:  LIEN_CITY
Java Field:  lienCity
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
City associated with an object of a lien.
Added On:  05/10/13
SQL Column:  LIEN_COMPANY_NAME
Java Field:  lienCompanyName
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Name of a lien company.
Added On:  05/10/13
SQL Column:  LIEN_FILING_DATE
Java Field:  lienFilingDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The date when the lien act was filed.
Added On:  05/10/13
SQL Column:  LIEN_RELEASED_COUNT
Java Field:  lienReleasedCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  LIEN_STATE
Java Field:  lienState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Code of the state associated with an object of a lien.
Added On:  05/10/13
SQL Column:  LIEN_STREET_ADDRESS1
Java Field:  lienStreetAddress1
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Street address (line 1) associated with an object of a lien.
Added On:  05/10/13
SQL Column:  LIEN_STREET_ADDRESS2
Java Field:  lienStreetAddress2
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Street address (line 2) associated with an object of a lien.
Added On:  05/10/13
SQL Column:  LIEN_TYPE
Java Field:  lienType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Type of the lien object.
Added On:  05/10/13
SQL Column:  LIEN_UNRELEASED_COUNT
Java Field:  lienUnreleasedCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/10/13
SQL Column:  LIEN_ZIP
Java Field:  lienZip
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
ZIP code associated with an object of a lien.
Added On:  05/10/13
SQL Column:  LIEN_ZIP4
Java Field:  lienZip4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Four-digit ZIP associated with an object of a lien.
Added On:  04/15/13
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  04/16/13
SQL Column:  MOST_RECENTLY_PASSED_SCAN
Java Field:  mostRecentlyPassedScan
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PCI_LEVEL
Java Field:  pciLevel
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
PCI level of the merchant.
Added On:  09/30/16
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the associated portfolio.
Added On:  04/16/13
SQL Column:  POSTAL_CODE
Java Field:  postalCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Postal code associated with the legal entity.
Added On:  04/16/13
SQL Column:  PRINCIPAL_ADDRESS_VERIFIED
Java Field:  principalAddressVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_CITY
Java Field:  principalCity
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
City of the principal's mailing address.
Added On:  04/16/13
SQL Column:  PRINCIPAL_CONTACT_PHONE
Java Field:  principalContactPhone
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Contact phone number of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_COUNTRY_CODE
Java Field:  principalCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the principal's mailing address.
Added On:  04/16/13
SQL Column:  PRINCIPAL_DATE_OF_BIRTH
Java Field:  principalDateOfBirth
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Date of birth of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_DESCRIPTION
Java Field:  principalDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Additional information about the business entity.
Added On:  04/16/13
SQL Column:  PRINCIPAL_DOB_VERIFIED
Java Field:  principalDobVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  09/12/14
SQL Column:  
Java Field:  principalDriversLicense
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Code of the driver license.
Added On:  09/30/16
SQL Column:  PRINCIPAL_DRIVERS_LICENSE_COUNTRY_CODE
Java Field:  principalDriversLicenseCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the country that issued user's driver license.
Added On:  04/16/13
SQL Column:  PRINCIPAL_DRIVERS_LICENSE_STATE
Java Field:  principalDriversLicenseState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Driver license number of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_EMAIL_ADDRESS
Java Field:  principalEmailAddress
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_FIRST_NAME
Java Field:  principalFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
First name of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_ID
Java Field:  principalId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identifier of the entity's principal assigned by a processor.
Added On:  04/16/13
SQL Column:  PRINCIPAL_LAST_NAME
Java Field:  principalLastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Last name of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_NAME_ADDRESS_PHONE_ASSOCIATION_CODE
Java Field:  principalNameAddressPhoneAssociationCode
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/26/13
SQL Column:  PRINCIPAL_NAME_ADDRESS_PHONE_ASSOCIATION_DESCRIPTION
Java Field:  principalNameAddressPhoneAssociationDescription
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  04/26/13
SQL Column:  PRINCIPAL_NAME_ADDRESS_SSN_ASSOCIATION_CODE
Java Field:  principalNameAddressSsnAssociationCode
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/26/13
SQL Column:  PRINCIPAL_NAME_ADDRESS_SSN_ASSOCIATION_DESCRIPTION
Java Field:  principalNameAddressSsnAssociationDescription
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_NAME_ADDRESS_TAX_ID_ASSOCIATION_CODE
Java Field:  principalNameAddressTaxIdAssociationCode
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/26/13
SQL Column:  PRINCIPAL_NAME_ADDRESS_TAX_ID_ASSOCIATION_DESCRIPTION
Java Field:  principalNameAddressTaxIdAssociationDescription
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_NAME_VERIFIED
Java Field:  principalNameVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_PHONE_VERIFIED
Java Field:  principalPhoneVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_POSTAL_CODE
Java Field:  principalPostalCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Postal code of the principal's mailing address.
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR1_CODE
Java Field:  principalRiskIndicator1Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR1_DESCRIPTION
Java Field:  principalRiskIndicator1Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR2_CODE
Java Field:  principalRiskIndicator2Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR2_DESCRIPTION
Java Field:  principalRiskIndicator2Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR3_CODE
Java Field:  principalRiskIndicator3Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR3_DESCRIPTION
Java Field:  principalRiskIndicator3Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR4_CODE
Java Field:  principalRiskIndicator4Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR4_DESCRIPTION
Java Field:  principalRiskIndicator4Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR5_CODE
Java Field:  principalRiskIndicator5Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR5_DESCRIPTION
Java Field:  principalRiskIndicator5Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR6_CODE
Java Field:  principalRiskIndicator6Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_RISK_INDICATOR6_DESCRIPTION
Java Field:  principalRiskIndicator6Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_SCORE
Java Field:  principalScore
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  09/12/14
SQL Column:  
Java Field:  principalSsn
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Social security number of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_SSN_VERIFIED
Java Field:  principalSsnVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  PRINCIPAL_STATE_PROVINCE
Java Field:  principalStateProvince
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the principal's mailing address.
Added On:  04/16/13
SQL Column:  PRINCIPAL_STREET_ADDRESS1
Java Field:  principalStreetAddress1
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Street address (line 1) of the entity's principal.
Added On:  04/16/13
SQL Column:  PRINCIPAL_STREET_ADDRESS2
Java Field:  principalStreetAddress2
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Street address (line 2) of the entity's principal.
Added On:  04/15/13
SQL Column:  PROVISION_PROFILE_NAME
Java Field:  provisionProfileName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the provisioning profile assigned to the entity.
Added On:  09/30/16
SQL Column:  PROVISIONING_TRANSACTION_FK
Java Field:  provisioningTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents information about provisioning transaction.
Added On:  04/16/13
SQL Column:  QUALIFIED_SECURITY_ASSESSOR
Java Field:  qualifiedSecurityAssessor
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  REPORT_ON_COMPLIANCE
Java Field:  reportOnCompliance
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  06/20/14
SQL Column:  REQUEST_CL
Java Field:  requestCl
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Represents the type of request.
Added On:  09/30/16
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the associated reseller.
Added On:  04/16/13
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Response code generated by the system.
Added On:  04/16/13
SQL Column:  RESPONSE_DESCRIPTION
Java Field:  responseDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Message assigned to the response code generated by the system.
Added On:  04/16/13
SQL Column:  RESPONSE_PRINCIPAL_FIRST_NAME
Java Field:  responsePrincipalFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
First name of the principal received in the response.
Added On:  04/16/13
SQL Column:  RESPONSE_PRINCIPAL_LAST_NAME
Java Field:  responsePrincipalLastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Last name of the principal received in the response.
Added On:  04/16/13
SQL Column:  SCANNING_VENDOR
Java Field:  scanningVendor
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  04/16/13
SQL Column:  STATE_PROVINCE
Java Field:  stateProvince
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the state of the business entity controlling the merchant account.
Added On:  04/15/13
SQL Column:  STREET_ADDRESS1
Java Field:  streetAddress1
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Street (line 1) of the entity's billing address.
Added On:  04/15/13
SQL Column:  STREET_ADDRESS2
Java Field:  streetAddress2
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Street (line 2) of the entity's billing address.
Added On:  02/01/17
SQL Column:  SUB_MERCHANT_PROCESSING_STATUS
Java Field:  subMerchantProcessingStatus
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Status of the transaction processing of the merchant account.
Added On:  04/15/13
SQL Column:  TAX_ID
Java Field:  taxId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identificator of the tax applied to the entity.
Added On:  04/16/13
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Identification number of the transaction in the system.