UniPay Provisioning Transaction UML
Added On: 09/29/16
Module: UniCharge
Type: Entity
Status: Active
Java Class: UniPayProvisioningTransaction
Represents information about UniPay provisioning transaction.
Added On: 09/29/16
SQL Column: ACCOUNT_ID
Java Field: accountId
Status: Active
SQL Type: int(11)
Java Type: Integer
Identifier of the account assigned by a processor.
Added On: 09/29/16
SQL Column: APPLICATION_CODE
Java Field: applicationCode
Status: Active
SQL Type: varchar(20)
Java Type: String
Secondary identifier which can be used to cross-reference records between UniPay and integrated systems.
Added On: 09/29/16
SQL Column: APPLICATION_ID
Java Field: applicationId
Status: Active
SQL Type: bigint(20)
Java Type: Long
Identifier of the application assigned to the record.
Added On: 04/11/17
SQL Column: BILLING_CONFIGURATION_SCRIPT
Java Field: billingConfigurationScript
Status: Active
SQL Type: varchar(63)
Java Type: String
Billing configuration script associated with the merchant that is being onboarded.
Added On: 09/29/16
SQL Column: BUSINESS_BUSINESS_NAME
Java Field: businessBusinessName
Status: Active
SQL Type: varchar(50)
Java Type: String
Name of the business entity.
Added On: 09/29/16
SQL Column: BUSINESS_CITY
Java Field: businessCity
Status: Active
SQL Type: varchar(50)
Java Type: String
City of the business entity's address.
Added On: 09/29/16
SQL Column: BUSINESS_COUNTRY_CODE
Java Field: businessCountryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Country code of the business entity address.
Added On: 12/06/16
SQL Column: BUSINESS_CURRENCY_CODE
Java Field: businessCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Code of the currency associated with business entity.
Added On: 09/29/16
SQL Column: BUSINESS_DESCRIPTION
Java Field: businessDescription
Status: Active
SQL Type: varchar(255)
Java Type: String
Additional information about the business entity.
Added On: 09/29/16
SQL Column: BUSINESS_DESCRIPTOR_PHONE
Java Field: businessDescriptorPhone
Status: Active
SQL Type: varchar(10)
Java Type: String
Dynamic field that contains phone number of the business entity.
Added On: 12/06/16
SQL Column: BUSINESS_DRIVER_LICENSE
Java Field: businessDriverLicense
Status: Active
SQL Type: varchar(50)
Java Type: String
Driver license number assigned to the business entity.
Added On: 12/06/16
SQL Column: BUSINESS_DRIVER_LICENSE_COUNTRY_CODE
Java Field: businessDriverLicenseCountryCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Code fo the country where driver license for business entity was issued.
Added On: 12/06/16
SQL Column: BUSINESS_DRIVER_LICENSE_STATE
Java Field: businessDriverLicenseState
Status: Active
SQL Type: varchar(3)
Java Type: String
State where driver license for business entity was issued.
Added On: 09/29/16
SQL Column: BUSINESS_EMAIL
Java Field: businessEmail
Status: Active
SQL Type: varchar(100)
Java Type: String
Email address of the business entity.
Added On: 09/29/16
SQL Column: BUSINESS_LEGAL_NAME
Java Field: businessLegalName
Status: Active
SQL Type: varchar(50)
Java Type: String
Legal name of the business entity.
Added On: 09/29/16
SQL Column: BUSINESS_MERCHANT_CATEGORY_CODE
Java Field: businessMerchantCategoryCode
Status: Active
SQL Type: varchar(4)
Java Type: String
MCC assigned to the business entity.
Added On: 09/29/16
SQL Column: BUSINESS_OWNERSHIP_STRUCTURE_TYPE
Java Field: businessOwnershipStructureType
Status: Active
SQL Type: varchar(3)
Java Type: String
Structure type of the business entity ownership.
Added On: 12/07/16
SQL Column: BUSINESS_REGISTRATION_COUNTRY_CODE
Java Field: businessRegistrationCountryCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Code of the country where business entity was registered.
Added On: 12/07/16
SQL Column: BUSINESS_REGISTRATION_STATE
Java Field: businessRegistrationState
Status: Active
SQL Type: varchar(3)
Java Type: String
State where business entity was registered.
Added On: 12/07/16
SQL Column: BUSINESS_REGISTRATION_YEAR
Java Field: businessRegistrationYear
Status: Active
SQL Type: int(11)
Java Type: Integer
Year when business entity was registered.
Added On: 09/29/16
SQL Column: BUSINESS_STATE
Java Field: businessState
Status: Active
SQL Type: varchar(3)
Java Type: String
State code of the business entity's address.
Added On: 09/29/16
SQL Column: BUSINESS_STREET1
Java Field: businessStreet1
Status: Active
SQL Type: varchar(128)
Java Type: String
Street (line 1) of the business entity's address.
Added On: 09/29/16
SQL Column: BUSINESS_STREET2
Java Field: businessStreet2
Status: Active
SQL Type: varchar(128)
Java Type: String
Street (line 2) of the business entity's address.
Added On: 09/29/16
SQL Column: BUSINESS_TAX_ID
Java Field: businessTaxId
Status: Active
SQL Type: varchar(128)
Java Type: String
Identifier of the business tax applied to the transaction.
Added On: 04/11/17
SQL Column: BUSINESS_TIME_ZOME
Java Field: businessTimeZome
Status: Active
SQL Type: varchar(20)
Java Type: String
Time zone of the merchant that is being onboarded.
Added On: 09/29/16
SQL Column: BUSINESS_WEB_SITE
Java Field: businessWebSite
Status: Active
SQL Type: varchar(255)
Java Type: String
Web site of the business entity.
Added On: 12/07/16
SQL Column: BUSINESS_WORK_HOURS
Java Field: businessWorkHours
Status: Active
SQL Type: varchar(255)
Java Type: String
Work hours of the business entity.
Added On: 09/29/16
SQL Column: BUSINESS_ZIP_CODE
Java Field: businessZipCode
Status: Active
SQL Type: varchar(15)
Java Type: String
ZIP/postal code of the business entity's address.
Added On: 09/29/16
SQL Column: CANCEL_URL
Java Field: cancelUrl
Status: Active
SQL Type: varchar(255)
Java Type: String
URL to which a user gets redirected if it is needed to terminate transaction without completing.
Added On: 09/29/16
SQL Column: CARDS_DESCRIPTOR
Java Field: cardsDescriptor
Status: Active
SQL Type: varchar(50)
Java Type: String
Name of the merchant used as a descriptor for card transactions.
Added On: 06/26/17
SQL Column: CLIENT_HOST
Java Field: clientHost
Status: Active
SQL Type: varchar(63)
Java Type: String
IP address associated with API call sent by the merchant.
Added On: 02/22/19
SQL Column: CONTACT_INFO_PHONE
Java Field: contactInfoPhone
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 09/29/16
SQL Column:
Java Field: depositAccountNumber
Status: Active
SQL Type:
Java Type: String
Account number assigned to the deposit processing.
Added On: 09/29/16
SQL Column: DEPOSIT_ACCOUNT_TYPE
Java Field: depositAccountType
Status: Active
SQL Type: varchar(1)
Java Type: String
Type of the deposit account.
Added On: 09/29/16
SQL Column: DEPOSIT_BANK_NAME
Java Field: depositBankName
Status: Active
SQL Type: varchar(80)
Java Type: String
Name of the bank that is assigned to the deposit processing.
Added On: 09/29/16
SQL Column: DEPOSIT_HOLDER_NAME
Java Field: depositHolderName
Status: Active
SQL Type: varchar(56)
Java Type: String
Name of the holder assigned to the deposit processing.
Added On: 09/29/16
SQL Column:
Java Field: depositRoutingNumber
Status: Active
SQL Type:
Java Type: String
Routing number used for deposit processing.
Added On: 09/29/16
SQL Column: DIRECT_DEBIT_DESCRIPTOR
Java Field: directDebitDescriptor
Status: Active
SQL Type: varchar(50)
Java Type: String
Name of the merchant used as a descriptor for direct debit transactions.
Added On: 01/27/17
SQL Column: DISTRIBUTION_SCHEMA_CODE
Java Field: distributionSchemaCode
Status: Active
SQL Type: varchar(20)
Java Type: String
Code of the distribution schema associated with the merchant.
Added On: 09/29/16
SQL Column: ESTIMATES_ANNUAL_CARDS_VOLUME
Java Field: estimatesAnnualCardsVolume
Status: Active
SQL Type: int(11)
Java Type: Integer
Estimated volume of the annual card transactions processed by the business entity.
Added On: 09/29/16
SQL Column: ESTIMATES_ANNUAL_DIRECT_DEBIT_VOLUME
Java Field: estimatesAnnualDirectDebitVolume
Status: Active
SQL Type: int(11)
Java Type: Integer
Estimated volume of the annual direct debit transactions processed by the business entity.
Added On: 09/29/16
SQL Column: ESTIMATES_AVG_CARDS_TRANSACTION_AMOUNT
Java Field: estimatesAvgCardsTransactionAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Estimated average amount of card transactions processed by the business entity.
Added On: 09/29/16
SQL Column: ESTIMATES_AVG_DIRECT_DEBIT_TRANSACTION_AMOUNT
Java Field: estimatesAvgDirectDebitTransactionAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Estimated average amount of direct debit transactions processed by the business entity.
Added On: 09/29/16
SQL Column: ESTIMATES_MAX_TRANSACTION_AMOUNT
Java Field: estimatesMaxTransactionAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Maximum amount that the transaction can contain.
Added On: 09/29/16
SQL Column: FEE_TEMPLATE_CODE
Java Field: feeTemplateCode
Status: Active
SQL Type: varchar(20)
Java Type: String
Code of fee template assigned to the transaction.
Added On: 09/29/16
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: 02/22/19
SQL Column: INDUSTRY_TYPE
Java Field: industryType
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 09/29/16
SQL Column: IS_EMBEDDED
Java Field: isEmbedded
Status: Active
SQL Type: varchar(1)
Java Type: String
Indicates whether onboarding application is used in standalone (both header and footer are present on every page) or embedded (header and footer will be suppressed and only forms content is visible) mode.
Added On: 09/29/16
SQL Column: MERCHANT_ACCOUNT_CODE
Java Field: merchantAccountCode
Status: Active
SQL Type: int(11)
Java Type: Integer
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/18/18
SQL Column: MERCHANT_CODE
Java Field: merchantCode
Status: Active
SQL Type: varchar(61)
Java Type: String
Added On: 09/29/16
SQL Column: MERCHANT_ID
Java Field: merchantId
Status: Active
SQL Type: varchar(100)
Java Type: String
Identifier of the merchant associated with the transaction.
Added On: 04/11/17
SQL Column: MERCHANT_PROFILE
Java Field: merchantProfile
Status: Active
SQL Type: varchar(5)
Java Type: String
Profile associated with the merchant that is being onboarded.
Added On: 09/29/17
SQL Column: MERCHANT_TYPE
Java Field: merchantType
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/07/17
SQL Column: NOTIFICATION_POLICY
Java Field: notificationPolicy
Status: Active
SQL Type: varchar(1)
Java Type: String
Policy of how notifications about onboarding process results are delivered to the merchant.
Added On: 09/29/16
SQL Column: NOTIFY_URL
Java Field: notifyUrl
Status: Active
SQL Type: varchar(255)
Java Type: String
URL where the result of the transaction is delivered. The format of the callback to this URL is for Sale, Sale-Auth, Credit, Credit-Auth or Tokenization response.
Added On: 02/22/19
SQL Column: OFFICER_CODE
Java Field: officerCode
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OFFICER_ID
Java Field: officerId
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER1_CODE
Java Field: owner1Code
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER1_ID
Java Field: owner1Id
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER1_STATUS_CODE
Java Field: owner1StatusCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER2_CODE
Java Field: owner2Code
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER2_ID
Java Field: owner2Id
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER2_STATUS_CODE
Java Field: owner2StatusCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER3_CODE
Java Field: owner3Code
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER3_ID
Java Field: owner3Id
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER3_STATUS_CODE
Java Field: owner3StatusCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER4_CODE
Java Field: owner4Code
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER4_ID
Java Field: owner4Id
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER4_STATUS_CODE
Java Field: owner4StatusCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER5_CODE
Java Field: owner5Code
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER5_ID
Java Field: owner5Id
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER5_STATUS_CODE
Java Field: owner5StatusCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER6_CODE
Java Field: owner6Code
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER6_ID
Java Field: owner6Id
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: OWNER6_STATUS_CODE
Java Field: owner6StatusCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 09/29/16
SQL Column: OWNER_BIRTH_DATE
Java Field: ownerBirthDate
Status: Active
SQL Type: varchar(10)
Java Type: String
Added On: 09/29/16
SQL Column: OWNER_CITY
Java Field: ownerCity
Status: Active
SQL Type: varchar(50)
Java Type: String
City of the owner's mailing address.
Added On: 05/24/19
SQL Column: OWNER_CODE
Java Field: ownerCode
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 09/29/16
SQL Column: OWNER_COUNTRY_CODE
Java Field: ownerCountryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Country code of the owner's mailing address.
Added On: 09/29/16
SQL Column: OWNER_EMAIL
Java Field: ownerEmail
Status: Active
SQL Type: varchar(100)
Java Type: String
Added On: 09/29/16
SQL Column: OWNER_FIRST_NAME
Java Field: ownerFirstName
Status: Active
SQL Type: varchar(50)
Java Type: String
Added On: 05/24/19
SQL Column: OWNER_ID
Java Field: ownerId
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 09/29/16
SQL Column: OWNER_LAST_NAME
Java Field: ownerLastName
Status: Active
SQL Type: varchar(50)
Java Type: String
Added On: 09/29/16
SQL Column: OWNER_PHONE
Java Field: ownerPhone
Status: Active
SQL Type: varchar(15)
Java Type: String
Telephone number of the owner.
Added On: 09/29/16
SQL Column: OWNER_SOCIAL_SECURITY
Java Field: ownerSocialSecurity
Status: Active
SQL Type: varchar(50)
Java Type: String
Social security number of the owner.
Added On: 06/13/18
SQL Column: OWNER_STAKE_PERCENTAGE
Java Field: ownerStakePercentage
Status: Active
SQL Type: int(11)(3)
Java Type: Integer
Added On: 09/29/16
SQL Column: OWNER_STATE
Java Field: ownerState
Status: Active
SQL Type: varchar(3)
Java Type: String
State code of the owner's mailing address.
Added On: 09/29/16
SQL Column: OWNER_STREET1
Java Field: ownerStreet1
Status: Active
SQL Type: varchar(128)
Java Type: String
Street (line 1) of the owner's mailing address.
Added On: 09/29/16
SQL Column: OWNER_STREET2
Java Field: ownerStreet2
Status: Active
SQL Type: varchar(128)
Java Type: String
Street (line 2) of the owner's mailing address.
Added On: 05/24/19
SQL Column: OWNER_TITLE
Java Field: ownerTitle
Status: Active
SQL Type: varchar(60)
Java Type: String
Added On: 09/29/16
SQL Column: OWNER_ZIP_CODE
Java Field: ownerZipCode
Status: Active
SQL Type: varchar(15)
Java Type: String
ZIP/postal code of the owner's mailing address.
Added On: 09/29/16
SQL Column: PAGE_FORMAT
Java Field: pageFormat
Status: Active
SQL Type: varchar(5)
Java Type: String
List of the values that indicate which pages of the onboarding application are available for viewing.
Added On: 10/03/16
SQL Column:
Java Field: password
Status: Active
SQL Type:
Java Type: String
Password of the user assigned to the record.
Added On: 09/29/16
SQL Column: PORTFOLIO_ID
Java Field: portfolioId
Status: Active
SQL Type: int(11)
Java Type: Integer
Identifier of the portfolio associated with the transaction.
Added On: 09/29/16
SQL Column: PROCESSING_CONFIGURATION_SCRIPT
Java Field: processingConfigurationScript
Status: Active
SQL Type: varchar(63)
Java Type: String
Code of the configuration assigned to the transaction.
Added On: 04/21/17
SQL Column: PROFILE_ID
Java Field: profileId
Status: Active
SQL Type: varchar(15)
Java Type: String
Identifier of the processor used for onboarding of the merchants associated with a particular reseller. Assigned to the reseller.
Added On: 09/29/16
SQL Column: PROFILE_TYPE
Java Field: profileType
Status: Active
SQL Type: varchar(20)
Java Type: String
Type of the processor's profile used for provisioning.
Added On: 10/24/18
SQL Column: PROVIDER_RESPONSE_CODE
Java Field: providerResponseCode
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 10/24/18
SQL Column: PROVIDER_RESPONSE_MESSAGE
Java Field: providerResponseMessage
Status: Active
SQL Type: varchar(1024)
Java Type: String
Added On: 09/29/16
SQL Column: PROVISIONING_TRANSACTION_FK
Java Field: provisioningTransaction
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents information about provisioning transaction.
Added On: 04/11/17
SQL Column: RELATIONSHIP_BEGIN_DATE
Java Field: relationshipBeginDate
Status: Active
SQL Type: varchar(10)
Java Type: String
Date when business relationship between the processor and a merchant was registered.
Added On: 09/29/16
SQL Column: REQUEST_TYPE
Java Field: requestType
Status: Active
SQL Type: varchar(20)
Java Type: String
Type of the request associated with the transaction.
Added On: 09/29/16
SQL Column: RESELLER_ID
Java Field: resellerId
Status: Active
SQL Type: varchar(50)
Java Type: String
Identifier of the reseller associated with the transaction.
Added On: 09/29/16
SQL Column: RESPONSE_CODE
Java Field: responseCode
Status: Active
SQL Type: varchar(5)
Java Type: String
Code of the response message generated by a processor.
Added On: 09/29/16
SQL Column: RESPONSE_MESSAGE
Java Field: responseMessage
Status: Active
SQL Type: varchar(255)
Java Type: String
Response message generated by a processor.
Added On: 02/22/19
SQL Column: RESPONSE_TERMINAL_ID
Java Field: responseTerminalId
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 09/29/16
SQL Column: RETAIL_TRANSACTION_CYCLE_FK
Java Field: retailTransactionCycle
Status: Active
SQL Type: bigint(20)
Java Type: Long
Reference to the entity that represents information about retail transaction cycle.
Added On: 09/29/16
SQL Column: RETURN_URL
Java Field: returnUrl
Status: Active
SQL Type: varchar(255)
Java Type: String
URL to which a user gets redirected after a transaction is successfully processed.
Added On: 09/29/16
SQL Column: RETURN_URL_POLICY
Java Field: returnUrlPolicy
Status: Active
SQL Type: varchar(10)
Java Type: String
Indicates how returnURL is used when a transaction is completed.
Added On: 02/22/19
SQL Column: TERMINAL_CODE
Java Field: terminalCode
Status: Active
SQL Type: varchar(16)
Java Type: String
Added On: 02/22/19
SQL Column: TERMINAL_ID
Java Field: terminalId
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/22/19
SQL Column: TERMINAL_SETUP
Java Field: terminalSetup
Status: Active
SQL Type: varchar(128)
Java Type: String
Added On: 02/22/19
SQL Column: TERMINAL_STATUS
Java Field: terminalStatus
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/22/17
SQL Column: TERMINALS
Java Field: terminals
Status: Active
SQL Type: varchar(255)
Java Type: String
Added On: 10/03/16
SQL Column:
Java Field: userName
Status: Active
SQL Type:
Java Type: String
Name of the user assigned to the record.