Trust Commerce Token Transaction UML


Added On:  05/17/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  TrustCommerceTokenTransaction 
Represents tokenization transaction as it is defined in TrustCommerce's tokenization specification.
Added On:  10/06/16
SQL Column:  ACTION
Java Field:  action
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Indicator of the operation results.
Added On:  05/17/16
SQL Column:  ADDRESS1
Java Field:  address1
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Street of the merchant's mailing address.
Personal address information of the merchant.
Added On:  05/17/16
SQL Column:  BILLING_ID
Java Field:  billingId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Alphanumeric code used to retrieve customer payment card and ACH information for future, one-time and recurring/installment transactions.
Added On:  05/17/16
SQL Column:  BLACKLIST_FIELD
Java Field:  blacklistField
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The name of the input field that contained the blacklisted value; this can be one of the following: “name”, “cc”, “ach”, “zip”, “address1”, “state”, “country”, “email”, “phone”, or “ip”.
Added On:  05/17/16
SQL Column:  BLACKLIST_VALUE
Java Field:  blacklistValue
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
The input value that triggered the blacklist decline; for instance, if the decline was due to a blacklisted IP address, the offending IP address would be returned here.
Added On:  05/17/16
SQL Column:  
Java Field:  cc
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Cardholder primary account number (PAN) (for example, a credit or debit card number).
Added On:  05/17/16
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(40)
Java Type:  String
Attributes:
City of the merchant's mailing address.
Personal address information of the merchant.
Added On:  05/17/16
SQL Column:  COUNTRY
Java Field:  country
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Country of the merchant's mailing address.
Personal address information of the merchant.
Added On:  05/17/16
SQL Column:  
Java Field:  custId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Customer identification number assigned by TrustCommerce.
Added On:  05/17/16
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Email of the merchant for discussing any processing issues or sending notifications.
Added On:  05/17/16
SQL Column:  
Java Field:  encryptedTrack
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Track1 or Track2 data encrypted at the swipe device.
Added On:  05/17/16
SQL Column:  
Java Field:  exp
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Payment card expiration date in “MMYY” format.
Added On:  05/17/16
SQL Column:  FRAUD_SCORE
Java Field:  fraudScore
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
The actual numeric score (0 to 100) assigned by TrustCommerce CrediGuard to the transaction.
Added On:  05/17/16
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/06/16
SQL Column:  MASTER_CUST_ID
Java Field:  masterCustId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Identifier that is used for processing sale transactions under Billing ID provided by a processor.
Added On:  10/06/16
SQL Column:  
Java Field:  masterPassword
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Password that is used for processing sale transactions under Billing ID provided by a processor.
Added On:  05/17/16
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/25/16
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Name of the merchant.
Added On:  05/17/16
SQL Column:  
Java Field:  password
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The TrustCommerce Link password associated with the aforementioned CustID.
Added On:  05/17/16
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Phone number of the merchant for discussing any processing issues.
Personal information of the merchant.
Added On:  05/17/16
SQL Column:  RESPONSE_AVS
Java Field:  responseAvs
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Response to AVS verification of the transaction.
Added On:  05/17/16
SQL Column:  RESPONSE_BAD_DATA_TYPE
Java Field:  responseBadDataType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
A status of "baddata" indicates that no transaction was attempted because one or more fields were invalid. In this case, the field error will indicate the problem, and the offender field lists the offending input fields.

See the specification of the processor for more information.
Added On:  05/17/16
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
The response code as sent to TrustCommerce from the processing platform.
Added On:  05/17/16
SQL Column:  RESPONSE_CODE_DESCRIPTOR
Java Field:  responseCodeDescriptor
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
The textual description of what this code indicates, as documented in the processing platform’s messaging documentation.
Added On:  05/17/16
SQL Column:  RESPONSE_CVV
Java Field:  responseCvv
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Response to CVV verification of the credit card.
Added On:  05/17/16
SQL Column:  RESPONSE_DECLINE_TYPE
Java Field:  responseDeclineType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Type of response status.
When status is set to "decline", the "declinetype" field contains corresponding information about declined transaction. See the specification of the processor for more information.
Added On:  05/17/16
SQL Column:  RESPONSE_ERROR_TYPE
Java Field:  responseErrorType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
A status of "error" indicates an error occurred while processing the transaction. See the specification of the processor for more information.
Added On:  05/17/16
SQL Column:  RESPONSE_OFFENDERS
Java Field:  responseOffenders
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Response assigned to offenders list.
Added On:  05/17/16
SQL Column:  RESPONSE_STATUS_TYPE
Java Field:  responseStatusType
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Type of the response status of the transaction.
Added On:  05/17/16
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
State of the merchant's mailing address.
Personal address information of the merchant.
Added On:  05/17/16
SQL Column:  TOKEN_TRANSACTION_FK
Java Field:  tokenTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Token Transaction
Attributes:
Reference to the entity that represents information about token transaction.
Added On:  05/17/16
SQL Column:  TRANS_ID
Java Field:  transId
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Unique identifier assigned to each transaction regardless of the status.
Added On:  05/17/16
SQL Column:  VELOCITY_TYPE
Java Field:  velocityType
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
This is a brief string that contains the precise reason for the velocity decline:
• The first part of the string contains a velocity type, either “global”, “zip”, “ip”, or “cc”.
• The second part of the string contains a time period, either “1day”,
“3day”, “15day”, or “30day”.
• The third part of the string contains an indicator of the type of violation, such as “count” if the transaction count for the velocity type and time period was exceeded, or “total” if the dollar amount sum was exceeded.
Added On:  05/17/16
SQL Column:  VELOCITY_VALUE
Java Field:  velocityValue
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
This is the value that exceeded the velocity rule; for example, if the rule were a limit on CC# usage, this would be set to the last four digits of the credit card number.
Added On:  05/17/16
SQL Column:  VERIFY
Java Field:  verify
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates that payment card (credit or debit) information is valid.
Added On:  05/17/16
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
ZIP (or postal) code of the merchant's mailing address.
Personal address information of the merchant.