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.

Available Fields:

Account Accessory
Account Accessory Encoded
Account Accessory Masked
Account Accessory Optimized
Account Number Last4
Account Type
City

Country Code
Create Date
Email
Holder Name
Id
Is Organization
Is Updated

Merchant Account Code
Phone
Sequence Number
State
Status CL
Street
Token

Token Code
ZIP Code

Account Accessory

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.

Account Accessory Encoded

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.

Account Accessory Masked

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.

Account Accessory Optimized

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.

Account Number Last4

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.

Account Type

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.

City

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.

Country Code

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.

Create Date

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: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Email address of the holder.

Holder Name

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: 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.

Is Organization

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.

Is Updated

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.

Merchant Account Code

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.

Phone

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.

Sequence 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.

State

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.

Status CL

Added On: 11/28/16

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Account Profile Status Classifier

Attributes:

Reference to the entity that represents enumeration of record statuses.

Street

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.

Token

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.

Token Code

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.

ZIP Code

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.