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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Added On: 05/10/16
SQL Column:
Java Field: cvv
Status: Active
SQL Type:
Java Type: String
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Added On: 05/12/16
SQL Column: OFFLINE_AUTH_CODE
Java Field: offlineAuthCode
Status: Active
SQL Type: varchar(6)
Java Type: String
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Added On: 04/25/17
SQL Column: RESPONSE_PARTIAL_AMOUNT
Java Field: responsePartialAmount
Status: Active
SQL Type: varchar(20)
Java Type: String
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
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
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
Added On: 05/10/16
SQL Column: SHIP_TO_ADDRESS1
Java Field: shipToAddress1
Status: Active
SQL Type: varchar(80)
Java Type: String
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
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
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
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
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
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
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
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
"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
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
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
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
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
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
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
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
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
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
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
ZIP (or postal) code of the merchant's mailing address.
Personal address information of the merchant.