Token Profile


Added On:  07/07/14 
SQL Table:  TOKEN_PROFILE 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  TokenProfile 
Represents information about token profile.
Added On:  07/07/14
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  07/07/14
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:  07/07/14
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:  07/07/14
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:  07/07/14
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates the type of the account withn the system.
Added On:  07/07/14
SQL Column:  HOLDER_NAME
Java Field:  holderName
Status:  Active
SQL Type:  varchar(151)
Java Type:  String
Attributes:
Name of the associated holder.
Added On:  07/07/14
SQL Column:  IS_ORGANIZATION
Java Field:  isOrganization
Status:  Active
SQL Type:  tinyint(1)(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether a holder is represented as an organization.
Added On:  07/07/14
SQL Column:  STREET
Java Field:  street
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street of the holder's mailing address.
Added On:  07/07/14
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City of the mailing address.
Added On:  07/07/14
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the holder's mailing address.
Added On:  07/07/14
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP or postal code of the mailing address.
Added On:  07/07/14
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Country code of the holder's mailing address.
Added On:  07/18/14
SQL Column:  ACCOUNT_ACCESSORY_ENCODED
Java Field:  accountAccessoryEncoded
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
When transaction is associated with a credit card, the field contains encoded card's expiration date. When transaction is associated with a bank account, the field contains encoded account's routing number.
Added On:  12/04/14
SQL Column:  SEQUENCE_NUMBER
Java Field:  sequenceNumber
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Sequence number assigned by a processor.
Added On:  11/28/16
SQL Column:  ACCOUNT_ACCESSORY_MASKED
Java Field:  accountAccessoryMasked
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes:
When transaction is associated with a credit card, the field contains masked card's expiration date. When transaction is associated with a bank account, the field contains masked account's routing number.
Added On:  11/28/16
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of record statuses.
Added On:  12/07/16
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created.
Added On:  12/07/16
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.
Added On:  12/07/16
SQL Column:  ACCOUNT_ACCESSORY_OPTIMIZED
Java Field:  accountAccessoryOptimized
Status:  Active
SQL Type:  varchar(11)
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:  12/07/16
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Telephone number of the holder.
Added On:  12/07/16
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address of the holder.
Added On:  12/14/16
SQL Column:  TOKEN
Java Field:  token
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Token associated with a record.
Added On:  05/30/17
SQL Column:  IS_UPDATED
Java Field:  isUpdated
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Transient, Default:false
Indicates that the record was updated.