Vantiv Lowell Provisioning Transaction UML


Added On:  05/17/18 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  VantivLowellProvisioningTransaction 
Available Fields:
Added On:  05/16/18
SQL Column:  ACCOUNT_NUMBER_MASKED
Java Field:  accountNumberMasked
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  AMEX_MID
Java Field:  amexMid
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
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:
Added On:  05/16/18
SQL Column:  BACKGROUND_CHECK_DECISION_NOTES
Java Field:  backgroundCheckDecisionNotes
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANK_ACCOUNT_NUMBER
Java Field:  bankAccountNumber
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  05/16/18
SQL Column:  BANK_ROUTING_NUMBER
Java Field:  bankRoutingNumber
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  05/16/18
SQL Column:  BANKRUPTCY_CITY
Java Field:  bankruptcyCity
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_COMPANY_NAME
Java Field:  bankruptcyCompanyName
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_COUNT
Java Field:  bankruptcyCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_FILING_DATE
Java Field:  bankruptcyFilingDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_STATE
Java Field:  bankruptcyState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_STREET_ADDRESS1
Java Field:  bankruptcyStreetAddress1
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_STREET_ADDRESS2
Java Field:  bankruptcyStreetAddress2
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_TYPE
Java Field:  bankruptcyType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_ZIP
Java Field:  bankruptcyZip
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BANKRUPTCY_ZIP4
Java Field:  bankruptcyZip4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_ADDRESS_VERIFIED
Java Field:  businessAddressVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_CITY_VERIFIED
Java Field:  businessCityVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_DESCRIPTION
Java Field:  businessDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
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:
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:
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:
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:
Added On:  05/16/18
SQL Column:  BUSINESS_NAME_VERIFIED
Java Field:  businessNameVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_PHONE_VERIFIED
Java Field:  businessPhoneVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR1_CODE
Java Field:  businessRiskIndicator1Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR1_DESCRIPTION
Java Field:  businessRiskIndicator1Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR2_CODE
Java Field:  businessRiskIndicator2Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR2_DESCRIPTION
Java Field:  businessRiskIndicator2Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR3_CODE
Java Field:  businessRiskIndicator3Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR3_DESCRIPTION
Java Field:  businessRiskIndicator3Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR4_CODE
Java Field:  businessRiskIndicator4Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR4_DESCRIPTION
Java Field:  businessRiskIndicator4Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR5_CODE
Java Field:  businessRiskIndicator5Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR5_DESCRIPTION
Java Field:  businessRiskIndicator5Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR6_CODE
Java Field:  businessRiskIndicator6Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_RISK_INDICATOR6_DESCRIPTION
Java Field:  businessRiskIndicator6Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_SCORE
Java Field:  businessScore
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_STATE_VERIFIED
Java Field:  businessStateVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  BUSINESS_TAX_ID_VERIFIED
Java Field:  businessTaxIdVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
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:
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:
Added On:  05/16/18
SQL Column:  BUSINESS_ZIP_VERIFIED
Java Field:  businessZipVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  CONTACT_PHONE
Java Field:  contactPhone
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  CREATE_CREDENTIALS
Java Field:  createCredentials
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  05/16/18
SQL Column:  CUSTOMER_SERVICE_NUMBER
Java Field:  customerServiceNumber
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  DISABLED
Java Field:  disabled
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  DISCOVER_CONVEYED_MID
Java Field:  discoverConveyedMid
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  DOING_BUSINESS_AS
Java Field:  doingBusinessAs
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  ECHECK_BILLING_DESCRIPTOR
Java Field:  echeckBillingDescriptor
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  ECHECK_COMPANY_NAME
Java Field:  echeckCompanyName
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  HARD_CODED_BILLING_DESCRIPTOR
Java Field:  hardCodedBillingDescriptor
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  HAS_ACCEPTED_CREDIT_CARDS
Java Field:  hasAcceptedCreditCards
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
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.
Added On:  05/16/18
SQL Column:  IS_AMEX_ACQUIRED
Java Field:  isAmexAcquired
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  05/16/18
SQL Column:  IS_DUPLICATE
Java Field:  isDuplicate
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  05/16/18
SQL Column:  IS_ECHECK_ENABLED
Java Field:  isEcheckEnabled
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Added On:  05/16/18
SQL Column:  IS_EXCLUSIVE_TO_PSP
Java Field:  isExclusiveToPsp
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  IS_PCI_COMPLIANCE_VALIDATED
Java Field:  isPciComplianceValidated
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LEGAL_ENTITY_ID
Java Field:  legalEntityId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LEGAL_ENTITY_NAME
Java Field:  legalEntityName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LEGAL_ENTITY_OWNERSHIP_TYPE
Java Field:  legalEntityOwnershipType
Status:  Active
SQL Type:  varchar(7)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LEGAL_ENTITY_RESULT_DATA
Java Field:  legalEntityResultData
Status:  Active
SQL Type:  longtext
Java Type:  String
Attributes:
Added On:  11/22/18
SQL Column:  LEGAL_ENTITY_RETRIEVAL_RESULT_DATA
Java Field:  legalEntityRetrievalResultData
Status:  Active
SQL Type:  longtext
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LEGAL_ENTITY_TYPE
Java Field:  legalEntityType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_CITY
Java Field:  lienCity
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_COMPANY_NAME
Java Field:  lienCompanyName
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_FILING_DATE
Java Field:  lienFilingDate
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_RELEASED_COUNT
Java Field:  lienReleasedCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_STATE
Java Field:  lienState
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_STREET_ADDRESS1
Java Field:  lienStreetAddress1
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_STREET_ADDRESS2
Java Field:  lienStreetAddress2
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_TYPE
Java Field:  lienType
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_UNRELEASED_COUNT
Java Field:  lienUnreleasedCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_ZIP
Java Field:  lienZip
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  LIEN_ZIP4
Java Field:  lienZip4
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  MAX_TRANSACTION_AMOUNT
Java Field:  maxTransactionAmount
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  05/16/18
SQL Column:  MERCHANT_CATEGORY_CODE
Java Field:  merchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  MERCHANT_IDENT_STRING
Java Field:  merchantIdentString
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  MERCHANT_NAME
Java Field:  merchantName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  MOST_RECENTLY_PASSED_SCAN
Java Field:  mostRecentlyPassedScan
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  ORIGINAL_LEGAL_ENTITY_ID
Java Field:  originalLegalEntityId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  ORIGINAL_LEGAL_ENTITY_STATUS
Java Field:  originalLegalEntityStatus
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PCI_LEVEL
Java Field:  pciLevel
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  POSTAL_CODE
Java Field:  postalCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_ADDRESS_VERIFIED
Java Field:  principalAddressVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_CITY
Java Field:  principalCity
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_CONTACT_PHONE
Java Field:  principalContactPhone
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_COUNTRY_CODE
Java Field:  principalCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_DATE_OF_BIRTH
Java Field:  principalDateOfBirth
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_DESCRIPTION
Java Field:  principalDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_DOB_VERIFIED
Java Field:  principalDobVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_DRIVERS_LICENSE
Java Field:  principalDriversLicense
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
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:
Added On:  05/16/18
SQL Column:  PRINCIPAL_DRIVERS_LICENSE_STATE
Java Field:  principalDriversLicenseState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_EMAIL_ADDRESS
Java Field:  principalEmailAddress
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_FIRST_NAME
Java Field:  principalFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_ID
Java Field:  principalId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_LAST_NAME
Java Field:  principalLastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
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:
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:
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:
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:
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:
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:
Added On:  05/16/18
SQL Column:  PRINCIPAL_NAME_VERIFIED
Java Field:  principalNameVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_PHONE_VERIFIED
Java Field:  principalPhoneVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_POSTAL_CODE
Java Field:  principalPostalCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR1_CODE
Java Field:  principalRiskIndicator1Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR1_DESCRIPTION
Java Field:  principalRiskIndicator1Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR2_CODE
Java Field:  principalRiskIndicator2Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR2_DESCRIPTION
Java Field:  principalRiskIndicator2Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR3_CODE
Java Field:  principalRiskIndicator3Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR3_DESCRIPTION
Java Field:  principalRiskIndicator3Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR4_CODE
Java Field:  principalRiskIndicator4Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR4_DESCRIPTION
Java Field:  principalRiskIndicator4Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR5_CODE
Java Field:  principalRiskIndicator5Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR5_DESCRIPTION
Java Field:  principalRiskIndicator5Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR6_CODE
Java Field:  principalRiskIndicator6Code
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_RISK_INDICATOR6_DESCRIPTION
Java Field:  principalRiskIndicator6Description
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_SCORE
Java Field:  principalScore
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_SSN
Java Field:  principalSsn
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_SSN_VERIFIED
Java Field:  principalSsnVerified
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_STAKE_PERCENT
Java Field:  principalStakePercent
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_STATE_PROVINCE
Java Field:  principalStateProvince
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_STREET_ADDRESS1
Java Field:  principalStreetAddress1
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PRINCIPAL_STREET_ADDRESS2
Java Field:  principalStreetAddress2
Status:  Active
SQL Type:  varchar(35)
Java Type:  String
Attributes:
Added On:  12/13/18
SQL Column:  PRINCIPAL_TITLE
Java Field:  principalTitle
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PROVISIONING_TRANSACTION_FK
Java Field:  provisioningTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  05/16/18
SQL Column:  PSP_MERCHANT_ID
Java Field:  pspMerchantId
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  PURCHASE_CURRENCY
Java Field:  purchaseCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  QUALIFIED_SECURITY_ASSESSOR
Java Field:  qualifiedSecurityAssessor
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  REPORT_ON_COMPLIANCE
Java Field:  reportOnCompliance
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  REQUEST_CL
Java Field:  requestCl
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  RESPONSE_DESCRIPTION
Java Field:  responseDescription
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  RESPONSE_PRINCIPAL_FIRST_NAME
Java Field:  responsePrincipalFirstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  RESPONSE_PRINCIPAL_LAST_NAME
Java Field:  responsePrincipalLastName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  ROUTING_NUMBER_MASKED
Java Field:  routingNumberMasked
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  SCANNING_VENDOR
Java Field:  scanningVendor
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  SETTLEMENT_CURRENCY
Java Field:  settlementCurrency
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  STATE_PROVINCE
Java Field:  stateProvince
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  STREET_ADDRESS1
Java Field:  streetAddress1
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  STREET_ADDRESS2
Java Field:  streetAddress2
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  SUB_MERCHANT_CREATE_DATE
Java Field:  subMerchantCreateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  05/16/18
SQL Column:  SUB_MERCHANT_ERROR_MESSAGE
Java Field:  subMerchantErrorMessage
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  SUB_MERCHANT_ID
Java Field:  subMerchantId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  SUB_MERCHANT_PROCESSING_STATUS
Java Field:  subMerchantProcessingStatus
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  SUB_MERCHANT_RESULT_DATA
Java Field:  subMerchantResultData
Status:  Active
SQL Type:  longtext
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  SUB_MERCHANT_TRANSACTION_ID
Java Field:  subMerchantTransactionId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  TAX_ID
Java Field:  taxId
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  TRANSACTION_ID
Java Field:  transactionId
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
Added On:  05/16/18
SQL Column:  URL
Java Field:  url
Status:  Active
SQL Type:  varchar(120)
Java Type:  String
Attributes: