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.