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