Added On:  10/27/17 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  TokenTransaction 
                    
        
        
     
    
        
            
                
                    Entity that represents information about token transaction.                
             
         
     
        
        
                    
                        
                Added On:  04/29/13
                SQL Column:  ACCOUNT_ACCESSORY
                Java Field:  accountAccessory
             
            
                Status:  Active
                SQL Type:  varchar(80)
                Java Type:  String
             
            
            
            
                
                    
                        
                        When transaction is associated with a credit card, the field contains card's expiration date. When transaction is associated with a bank account, the field contains account's routing number.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_CL
                Java Field:  accountCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of the account (e.g. credit card or bank account) associated with the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/18/16
                SQL Column:  
                Java Field:  accountDataEncrypted
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Account data associated with a merchant, represented in encrypted state.                        
                     
                 
             
                    
                        
                Added On:  04/29/13
                SQL Column:  
                Java Field:  accountNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        When 
Tokenization is not available and encryption is allowed on the server, the field contains encrypted credit card number or bank account number. 
Note: if encryption is not allowed on the server and tokenization is not properly configured, transactions will fail and will not be either processed or persisted.                         
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ACCOUNT_NUMBER_LAST4
                Java Field:  accountNumberLast4
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Last four digits of the account number or credit card number. Used to serve as an account identifier, when full account number is not available.                        
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  
                Java Field:  accountProfile
             
            
                Status:  Active
                SQL Type:  
                Java Type:  Object
             
            
            
            
                
                    
                        
                        Type of the selected account profile.                        
                     
                 
             
                    
                        
                Added On:  10/20/16
                SQL Column:  BANK_INFO_FK
                Java Field:  bankInfo
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Reference to the entity that represents information about the issuing bank.                        
                     
                 
             
                    
                        
                Added On:  12/26/14
                SQL Column:  BILLING_PROFILE_TYPE
                Java Field:  billingProfileType
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/26/14
                SQL Column:  CITY
                Java Field:  city
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The city of the consumer’s address.                        
                     
                 
             
                    
                        
                Added On:  07/01/14
                SQL Column:  CLIENT_HOST
                Java Field:  clientHost
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Host address of the client.                        
                     
                 
             
                    
                        
                Added On:  05/26/14
                SQL Column:  COUNTRY_CODE
                Java Field:  countryCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The country code of the consumer’s address.                        
                     
                 
             
                    
                        
                Added On:  08/28/17
                SQL Column:  CUSTOM_FIELD_DATA
                Java Field:  customFieldData
             
            
                Status:  Active
                SQL Type:  varchar(300)
                Java Type:  String
             
            
            
            
                
                    
                        
                        for saving custom fields _key=value                        
                     
                 
             
                    
                        
                Added On:  05/26/14
                SQL Column:  EMAIL
                Java Field:  email
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  05/26/14
                SQL Column:  FIRST_NAME
                Java Field:  firstName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The first name of the consumer.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  
                Java Field:  isAccountDataEncrypted
             
            
                Status:  Active
                SQL Type:  
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Transient, Default:false                
                             
            
                
                    
                        
                        Indicates whether encryption of the account credentials is enabled.                        
                     
                 
             
                    
                        
                Added On:  02/28/17
                SQL Column:  
                Java Field:  isIntegratedTokenization
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Transient, Default:false                
                             
            
                
                    
                        
                        Indicates whether tokenization appliance is integrated with the application.                        
                     
                 
             
                    
                        
                Added On:  05/26/14
                SQL Column:  IS_ORGANIZATION
                Java Field:  isOrganization
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the transaction belongs to organization or a simple customer.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  IS_PROXYNIZATION_ENABLED
                Java Field:  isProxynizationEnabled
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Default:false                
                             
            
                
                    
                        
                        Indicates whether the proxynization is enabled in the system.                        
                     
                 
             
                    
                        
                Added On:  12/02/24
                SQL Column:  IS_ROW_ACCOUNT_NUMBER_ALLOWED
                Java Field:  isRowAccountNumberAllowed
             
            
                Status:  Active
                SQL Type:  tinyint(1)
                Java Type:  Boolean
             
            
            
                
                    Attributes:
                    Transient, Default:false                
                             
            
                    
                        
                Added On:  05/26/14
                SQL Column:  LAST_NAME
                Java Field:  lastName
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The last name of the consumer.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                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:  05/26/14
                SQL Column:  PHONE
                Java Field:  phone
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Phone number of the consumer’s address.                        
                     
                 
             
                    
                        
                Added On:  08/25/15
                SQL Column:  PROCESSING_MODE_CL
                Java Field:  processingModeCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the selected type of processing mode for current transaction.                        
                     
                 
             
                    
                        
                Added On:  11/22/16
                SQL Column:  PROVIDER_REFERENCE_NUMBER
                Java Field:  providerReferenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Secondary identifier of the provider which can be used to cross-reference records between UniPay and integrated systems.                         
                     
                 
             
                    
                        
                Added On:  11/22/16
                SQL Column:  PROVIDER_RESPONSE_CODE
                Java Field:  providerResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code or the response generated by a processor.                        
                     
                 
             
                    
                        
                Added On:  11/22/16
                SQL Column:  PROVIDER_RESPONSE_MESSAGE
                Java Field:  providerResponseMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response message generated by a processor.                        
                     
                 
             
                    
                        
                Added On:  07/01/14
                SQL Column:  REQUEST_HOST
                Java Field:  requestHost
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        IP-address or respective domain name, from which the request was sent.                        
                     
                 
             
                    
                        
                Added On:  08/26/15
                SQL Column:  
                Java Field:  requestType
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  RESPONSE_CODE
                Java Field:  responseCode
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated response code.                         
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  RESPONSE_MESSAGE
                Java Field:  responseMessage
             
            
                Status:  Active
                SQL Type:  varchar(255)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Gateway generated response message, explaining corresponding response code.                         
                     
                 
             
                    
                        
                Added On:  05/26/14
                SQL Column:  STATE
                Java Field:  state
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The state of the consumer’s address.                        
                     
                 
             
                    
                        
                Added On:  05/26/14
                SQL Column:  STREET
                Java Field:  street
             
            
                Status:  Active
                SQL Type:  varchar(128)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Street of the consumer's postal address.                        
                     
                 
             
                    
                        
                Added On:  12/13/13
                SQL Column:  TEMPORARY_TOKEN_CODE
                Java Field:  temporaryTokenCode
             
            
                Status:  Active
                SQL Type:  varchar(512)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/25/15
                SQL Column:  TERMINAL_CODE
                Java Field:  terminalCode
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Code that identifies the terminal.                        
                     
                 
             
                    
                        
                Added On:  12/04/14
                SQL Column:  TOKEN
                Java Field:  token
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Token value replacing account number.                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TOKEN_CODE
                Java Field:  tokenCode
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Token generated for the provided payment information. Always present when tokenization service is enabled.                        
                     
                 
             
                    
                        
                Added On:  05/10/13
                SQL Column:  TOKENIZATION_TRANSACTION_CL
                Java Field:  tokenizationTransactionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the type of tokenization transaction selected.                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  
                Java Field:  trackData
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Track data associated with a token (line 1).                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  
                Java Field:  trackData1
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Track data associated with a token (line 2).                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  
                Java Field:  trackData2
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Track data associated with a token (line 3).                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TRANSACTION_CODE
                Java Field:  transactionCode
             
            
                Status:  Active
                SQL Type:  varchar(60)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value identifying transaction in submitter’s system.                         
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  TRANSACTION_DATE
                Java Field:  transactionDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date when the record was created                        
                     
                 
             
                    
                        
                Added On:  03/11/17
                SQL Column:  VERIFICATION_MODE_CL
                Java Field:  verificationModeCl
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Reference to the entity that represents the ways how pre-tokenization verification can be handled.                        
                     
                 
             
                    
                        
                Added On:  05/26/14
                SQL Column:  ZIP_CODE
                Java Field:  zipCode
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP code of the consumer’s postal address.