Transient Transaction

Added On: 10/27/14

SQL Table: TRANSIENT_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: TransientTransaction

Available Fields:

Account Accessory
Account Accessory Encoded
Account Accessory Encrypted
Account Accessory Masked
Account Accessory Optimized
Account CL
Account Number Encoded
Account Profile Code
Account Type
Amount
Bank Country Code
BIN

BIN Code
City
Country Code
Holder Name
Id
Is Account Profile Update
Is Blacklist Applied
Is Organization
Merchant Account Code
Provider Response Code
Provider Response Message
Response Code

Response Message
Sequence Number
SPID
Split Schema Code
Split Schema Id
State
Street
Submission Code
Subscription Code
Subscription Transaction Code
Sum Split Amount
Token Code

Token Sequence Number
ZIP Code

Account Accessory

Added On: 12/10/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: 12/10/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 Encrypted

Added On: 08/21/20

SQL Column: ACCOUNT_ACCESSORY_ENCRYPTED

Java Field: accountAccessoryEncrypted

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Account Accessory Masked

Added On: 07/28/22

SQL Column: ACCOUNT_ACCESSORY_MASKED

Java Field: accountAccessoryMasked

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Account Accessory Optimized

Added On: 07/28/22

SQL Column: ACCOUNT_ACCESSORY_OPTIMIZED

Java Field: accountAccessoryOptimized

Status: Active

SQL Type: varchar(11)

Java Type: String

Attributes:

Account CL

Added On: 10/29/14

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.

Account Number Encoded

Added On: 10/27/14

SQL Column: ACCOUNT_NUMBER_ENCODED

Java Field: accountNumberEncoded

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

The encoded identifier of the merchant within the system of the company serving as the business reference. Normally, a unique value, that is used to locate the information about the merchant within the system of the business reference.

Account Profile Code

Added On: 12/17/14

SQL Column: ACCOUNT_PROFILE_CODE

Java Field: accountProfileCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the account profile.

Account Type

Added On: 12/26/14

SQL Column: ACCOUNT_TYPE

Java Field: accountType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Indicates type of the account within the system.

Amount

Added On: 10/17/17

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Bank Country Code

Added On: 10/27/14

SQL Column: BANK_COUNTRY_CODE

Java Field: bankCountryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

BIN

Added On: 10/27/14

SQL Column: BIN

Java Field: bin

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The BIN element provides the 6-digit Bank (or Issuer) Identification Number of the Issuing Bank. The system returns this value in XML responses when issuing new tokens to replace Visa or MasterCard account numbers. For Discover and American Express cards, this element is empty.

BIN Code

Added On: 10/27/14

SQL Column: BIN_CODE

Java Field: binCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

City

Added On: 12/10/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: 12/10/14

SQL Column: COUNTRY_CODE

Java Field: countryCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Country code of the mailing address.

Holder Name

Added On: 12/10/14

SQL Column: HOLDER_NAME

Java Field: holderName

Status: Active

SQL Type: varchar(151)

Java Type: String

Attributes:

Name of the credit card or bank account holder.

Added On: 10/27/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 Account Profile Update

Added On: 12/17/14

SQL Column: IS_ACCOUNT_PROFILE_UPDATE

Java Field: isAccountProfileUpdate

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Indicates whether the account profile is updated.

Is Blacklist Applied

Added On: 12/23/14

SQL Column: IS_BLACKLIST_APPLIED

Java Field: isBlacklistApplied

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Is Organization

Added On: 12/10/14

SQL Column: IS_ORGANIZATION

Java Field: isOrganization

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Merchant Account Code

Added On: 10/27/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.

Provider Response Code

Added On: 11/30/18

SQL Column: PROVIDER_RESPONSE_CODE

Java Field: providerResponseCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Provider Response Message

Added On: 11/30/18

SQL Column: PROVIDER_RESPONSE_MESSAGE

Java Field: providerResponseMessage

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Response Code

Added On: 10/27/14

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Gateway generated response code.

Response Message

Added On: 10/29/14

SQL Column: RESPONSE_MESSAGE

Java Field: responseMessage

Status: Active

SQL Type: varchar(550)

Java Type: String

Attributes:

Gateway generated response message.

Sequence Number

Added On: 10/27/14

SQL Column: SEQUENCE_NUMBER

Java Field: sequenceNumber

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

SPID

Added On: 04/16/15

SQL Column: SPID

Java Field: spid

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Split Schema Code

Added On: 10/17/17

SQL Column: SPLIT_SCHEMA_CODE

Java Field: splitSchemaCode

Status: Active

SQL Type: varchar(61)

Java Type: String

Attributes:

Split Schema Id

Added On: 10/17/17

SQL Column: SPLIT_SCHEMA_ID

Java Field: splitSchemaId

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

State

Added On: 12/10/14

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State code of the mailing address.

Street

Added On: 12/10/14

SQL Column: STREET

Java Field: street

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street of the mailing address.

Submission Code

Added On: 10/27/14

SQL Column: SUBMISSION_CODE

Java Field: submissionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Subscription Code

Added On: 11/25/15

SQL Column: SUBSCRIPTION_CODE

Java Field: subscriptionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

Code of the subscription transaction.

Subscription Transaction Code

Added On: 11/27/15

SQL Column: SUBSCRIPTION_TRANSACTION_CODE

Java Field: subscriptionTransactionCode

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes:

The initial code of the subscription transaction.

Sum Split Amount

Added On: 10/17/17

SQL Column: SUM_SPLIT_AMOUNT

Java Field: sumSplitAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Token Code

Added On: 10/27/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.

Token Sequence Number

Added On: 12/10/14

SQL Column: TOKEN_SEQUENCE_NUMBER

Java Field: tokenSequenceNumber

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

ZIP Code

Added On: 12/10/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.