Transient Transaction


Added On:  10/27/14 
SQL Table:  TRANSIENT_TRANSACTION 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  TransientTransaction 
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.
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.
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.
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.
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.
Added On:  10/27/14
SQL Column:  SEQUENCE_NUMBER
Java Field:  sequenceNumber
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  10/27/14
SQL Column:  SUBMISSION_CODE
Java Field:  submissionCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/27/14
SQL Column:  BIN_CODE
Java Field:  binCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  10/27/14
SQL Column:  BANK_COUNTRY_CODE
Java Field:  bankCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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.
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.
Added On:  10/29/14
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Gateway generated response message.
Added On:  12/10/14
SQL Column:  TOKEN_SEQUENCE_NUMBER
Java Field:  tokenSequenceNumber
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
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.
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:  12/10/14
SQL Column:  IS_ORGANIZATION
Java Field:  isOrganization
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
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.
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.
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.
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.
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.
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.
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.
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
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.
Added On:  04/16/15
SQL Column:  SPID
Java Field:  spid
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
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.
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.
Added On:  10/17/17
SQL Column:  SPLIT_SCHEMA_CODE
Java Field:  splitSchemaCode
Status:  Active
SQL Type:  varchar(61)
Java Type:  String
Attributes:
Added On:  10/17/17
SQL Column:  SPLIT_SCHEMA_ID
Java Field:  splitSchemaId
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Added On:  10/17/17
SQL Column:  SUM_SPLIT_AMOUNT
Java Field:  sumSplitAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  10/17/17
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  11/30/18
SQL Column:  PROVIDER_RESPONSE_CODE
Java Field:  providerResponseCode
Status:  Active
SQL Type:  varchar(5)
Java Type:  String
Attributes:
Added On:  11/30/18
SQL Column:  PROVIDER_RESPONSE_MESSAGE
Java Field:  providerResponseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes: