Trust Commerce Auth Retail Transaction UML


Added On:  05/10/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  TrustCommerceAuthRetailTransaction 
Trust Commerce specific low-level representation of Retail Transaction produced by Forward Transformation Process within Authorization Process.
During Generation Process, Trust Commerce specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On:  05/10/16
SQL Column:  ACTION
Java Field:  action
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Type of transaction action (e.g. "sale", "preauth", "postauth", "credit", "void", "store", and so on).
Added On:  04/25/17
SQL Column:  ADDITIONAL_AMOUNT1
Java Field:  additionalAmount1
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Part of the total amount in the transactions that is assigned to Healthcare Eligible.
Added On:  04/25/17
SQL Column:  ADDITIONAL_AMOUNT2
Java Field:  additionalAmount2
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Part of the total amount in the transactions that is assigned to Healthcare Eligible.
Added On:  05/10/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/10/16
SQL Column:  AMOUNT
Java Field:  amount
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Transaction amount in cents (for example, $1.00 would be submitted as "100").
Added On:  05/10/16
SQL Column:  AVS
Java Field:  avs
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
The "avs" response code returned by the address verification system (AVS).
Added On:  05/12/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/13/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/13/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/10/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/10/16
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  05/10/16
SQL Column:  CHECK_CVV
Java Field:  checkCvv
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicates whether TrustCommerce should decline the transaction on behalf of the integrator if the CSC does not match as reported by the card issuing bank. Only used if “cvv” is provided.
Added On:  05/10/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/10/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/10/16
SQL Column:  
Java Field:  custId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Customer identification number assigned by TrustCommerce.
Added On:  11/20/19
SQL Column:  CUSTOMER_ACCOUNT_INTERNAL_CODE
Java Field:  customerAccountInternalCode
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Added On:  05/10/16
SQL Column:  
Java Field:  cvv
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The three- or four-character field located in the front or back of the card. * For Visa, MasterCard, and Discover, this is a three-character field located on the back of the card to the far right.
  • For American Express, it is a four-character value located on the front of the card above the primary account number.
  • Added On:  05/10/16
    SQL Column:  CVV_STATUS
    Java Field:  cvvStatus
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    This field should be assigned if the “cvv” field is not submitted. Possible values include “present”, “notpresent”, and “illegible”. By default, it will be treated as “notpresent” although some processors may treat it otherwise if this field is not submitted by the integrator.

    • The “present” value states that the integrator did not provide the card code stated above even though it was present.
    • The “notpresent” value states that the integrator did not see a card code.
    • The “illegible” value states that the integrator could not read the card code.

    In all cases, this field is used when the CSC is not submitted. By submitting a CSC, the merchant is stating that the CSC is present and the value is the “cvv” indicated above. Only used if “cvv” is NOT provided.
    Added On:  05/10/16
    SQL Column:  
    Java Field:  demo
    Status:  Active
    SQL Type:  
    Java Type:  String
    Attributes: Transient
    Used to indicate the transaction request is a test or demo transaction regardless of account status.
    Added On:  05/16/17
    SQL Column:  DESTINATION
    Java Field:  destination
    Status:  Active
    SQL Type:  varchar
    Java Type:  String
    Attributes: Transient
    Indicates whether transaction request is processed via TC Link or TC Vault.
    Added On:  05/10/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/12/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/10/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/13/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/10/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:  04/25/17
    SQL Column:  IIAS_LOOKUP
    Java Field:  iiasLookup
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicates that the processor's qualification of eligibility of the provided card number is required.
    Added On:  04/25/17
    SQL Column:  IIAS_TRANSACTION
    Java Field:  iiasTransaction
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicates a submission of an IIAS eligible transaction.
    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/10/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/10/16
    SQL Column:  NAME
    Java Field:  name
    Status:  Active
    SQL Type:  varchar(60)
    Java Type:  String
    Attributes:
    Name of the customer.
    Added On:  05/12/16
    SQL Column:  OFFLINE_AUTH_CODE
    Java Field:  offlineAuthCode
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Six-digit numeric code used to force the transaction.
    Added On:  05/10/16
    SQL Column:  OPERATOR
    Java Field:  operator
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    A field the integrator may choose to use if there are multiple operators that are potentially entering transactions. The operator field is only used for reporting within TrustCommerce systems.
    Added On:  04/25/17
    SQL Column:  PARTIAL_AUTH
    Java Field:  partialAuth
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicates whether partially authorized transactions are supported by the system or not.
    Added On:  05/10/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/10/16
    SQL Column:  PAYMENT_NUMBER
    Java Field:  paymentNumber
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    The payment number associated with the transaction. It is required for both recurring and installment payment transactions and is required for a transaction to be flagged as recurring.
    Added On:  05/10/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:  10/12/16
    SQL Column:  PINLESS_DEBIT
    Java Field:  pinlessDebit
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicates whether debit card is identified in UniPay by BIN.
    Added On:  10/12/16
    SQL Column:  PINLESS_LOOKUP
    Java Field:  pinlessLookup
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicates whether debit card is identified on the processor's side by BIN.
    Added On:  05/10/16
    SQL Column:  PURCHASE_LEVEL
    Java Field:  purchaseLevel
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Purchase level provided by TrustCommerce.
    Added On:  05/10/16
    SQL Column:  PURCHASE_ORDER_NUM
    Java Field:  purchaseOrderNum
    Status:  Active
    SQL Type:  varchar(17)
    Java Type:  String
    Attributes:
    Purchase order number "purchaseordernum" is provided by the customer.
    Added On:  05/10/16
    SQL Column:  RESPONSE_AUTH_CODE
    Java Field:  responseAuthCode
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Authorization response code (result of the authorization).
    Added On:  05/10/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/10/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/13/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/13/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/10/16
    SQL Column:  RESPONSE_COMMERCIAL_CARD
    Java Field:  responseCommercialCard
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicates whether the credit card type is commercial.
    Added On:  05/12/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/10/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/10/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/10/16
    SQL Column:  RESPONSE_OFFENDERS
    Java Field:  responseOffenders
    Status:  Active
    SQL Type:  varchar(255)
    Java Type:  String
    Attributes:
    Response offenders.
    Added On:  04/25/17
    SQL Column:  RESPONSE_PARTIAL_AMOUNT
    Java Field:  responsePartialAmount
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    Partial amount received in response file if the partial authorization is supported by the system.
    Added On:  05/10/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/10/16
    SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
    Java Field:  retailTransactionCycle
    Status:  Active
    SQL Type:  bigint(20)
    Java Type:  Long
    Attributes:
    Reference to the entity that represents a group of real-time transactions which must be settled together.
    Added On:  10/10/16
    SQL Column:  SHIP_DATE
    Java Field:  shipDate
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    Date of the shipping.
    Added On:  05/10/16
    SQL Column:  SHIP_TO_ADDRESS1
    Java Field:  shipToAddress1
    Status:  Active
    SQL Type:  varchar(80)
    Java Type:  String
    Attributes:
    The address of the destination where the goods are being shipped. If this field is not provided, TrustCommerce will send blanks.
    Added On:  05/10/16
    SQL Column:  SHIP_TO_CITY
    Java Field:  shipToCity
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    The city of the destination where the goods are being shipped. If this field is not provided, TrustCommerce will send blanks.
    Added On:  05/10/16
    SQL Column:  SHIP_TO_COUNTRY
    Java Field:  shipToCountry
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    The country of the destination where the goods are being shipped. If this field is not provided, TrustCommerce will send blanks.
    Added On:  05/10/16
    SQL Column:  SHIP_TO_NAME
    Java Field:  shipToName
    Status:  Active
    SQL Type:  varchar(60)
    Java Type:  String
    Attributes:
    The name of the customer to whom the goods are being shipped. If this field is not provided, TrustCommerce will send blanks.
    Added On:  05/10/16
    SQL Column:  SHIP_TO_SAME
    Java Field:  shipToSame
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    The same destination where the goods are being shipped before. If this field is not provided, TrustCommerce will send blanks.
    Added On:  05/10/16
    SQL Column:  SHIP_TO_STATE
    Java Field:  shipToState
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    The state of the destination where the goods are being shipped. If this field is not provided, TrustCommerce will send blanks.
    Added On:  05/10/16
    SQL Column:  SHIP_TO_ZIP
    Java Field:  shipToZip
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    The ZIP (or postal) code of the destination where the goods are being shipped. If this field is not provided, TrustCommerce will send blanks.
    Added On:  05/10/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/12/16
    SQL Column:  STORE
    Java Field:  store
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    "Y" or "N".

    This function pushes credit card data to TrustCommerce Citadel and returns a billingID. This enables merchants to charge the cardholder and keep a record on file for use at a later date. The store function only pushes data to citadel if the sale/preauth is approved. The BillingID is returned in the sale/preauth transaction response. The sale/preauth is associated with the BillingID record.
    Added On:  05/10/16
    SQL Column:  TAX
    Java Field:  tax
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    The amount of tax, in cents, charged for this order. If the order is tax exempt, you may omit this field or set the field to "0".
    Added On:  05/10/16
    SQL Column:  TAX_IDENTIFIER
    Java Field:  taxIdentifier
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    Can be set to "localsales" or "taxexempt" to indicate the specific tax status of the order.
    Added On:  05/10/16
    SQL Column:  TICKET
    Java Field:  ticket
    Status:  Active
    SQL Type:  varchar(30)
    Java Type:  String
    Attributes:
    This discretionary field can be used as a merchant-specified transaction identifier for searching and reporting. In some cases, the value of this field is passed through to the financial institutions.
    Added On:  05/10/16
    SQL Column:  TIP
    Java Field:  tip
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    This is the amount of the tip (in cents) to be included in the “postauth” request (for example, $1.00 would be submitted as “100”).
    Added On:  05/10/16
    SQL Column:  TOTAL_PAYMENTS
    Java Field:  totalPayments
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    This field indicates the number of installments. It is required for installment payment transactions.
    Added On:  05/10/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/12/16
    SQL Column:  TYPE
    Java Field:  type
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    Indicates that the transaction is assigned to MOTO industry.
    Added On:  05/13/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/13/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/10/16
    SQL Column:  
    Java Field:  verify
    Status:  Active
    SQL Type:  
    Java Type:  String
    Attributes: Transient
    Indicates that payment card (credit or debit) information is valid.
    Added On:  05/10/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.