Token Transaction UML


Added On:  10/27/17 
SQL Table:  TOKEN_TRANSACTION 
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
Attributes:
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
References Account Classifier
Attributes:
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
Attributes: Transient
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
Attributes: Transient
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
Attributes:
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
Attributes: Transient
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
References Bank Info
Attributes:
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
Attributes:
Type of billing profile.
Added On:  05/26/14
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Email of the consumer.
Added On:  05/26/14
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
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
Identifier / Primary Key
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:  05/26/14
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
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
Attributes: Required
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Transient
Type of request.
Added On:  02/13/12
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Temporary token code.
Added On:  08/25/15
SQL Column:  TERMINAL_CODE
Java Field:  terminalCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Represents the type of tokenization transaction selected.
Added On:  06/16/16
SQL Column:  
Java Field:  trackData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
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
Attributes: Transient
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
Attributes: Transient
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
ZIP code of the consumer’s postal address.