First Data Compass Auth Retail Transaction UML
Added On: 02/13/12
Module: UniCharge
Type: Entity
Status: Active
Java Class: FirstDataCompassAuthRetailTransaction
FirstData Compass specific low-level representation of Retail Transaction produced by
Forward Transformation Process within
Authorization Process.
During
Generation Process, FirstData Compass specific interchange message is generated from this object for authorization. Consequently, all fields of the object are mapped into message segments/elements.
Added On: 06/14/16
SQL Column:
Java Field: accountNumber
Status: Active
SQL Type:
Java Type: String
Contains the credit card account number which identifies the customer. The account number is left justified with trailing spaces.
Added On: 11/30/17
SQL Column: ACCOUNT_STATUS
Java Field: accountStatus
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: ACCOUNT_TYPE_DEBIT
Java Field: accountTypeDebit
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: ACCOUNT_TYPE_EBT
Java Field: accountTypeEbt
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/13/12
SQL Column: ACTION_CODE
Java Field: actionCode
Status: Active
SQL Type: varchar(2)
Java Type: String
This action tells First Data what service to perform on the transaction.
We use:
DR - Refund Auth Reversal (PINLess Debit)
PR - Purchase Auth Reversal (PINLess Debit)
AR - Authorization Reversal (Amex, MasterCard, Visa, Discover, JCB, GoogleCheckout, PayPal, ValueLink)
RA - Refund Auth (PINLess Debit)
PA - Purchase Auth (PINLess Debit)
AU - Authorize (Credit Card, Alt Pay, ValueLink)
Added On: 02/13/12
SQL Column: ADDRESS_LINE1
Java Field: addressLine1
Status: Active
SQL Type: varchar(30)
Java Type: String
Accountholder’s address information
Added On: 02/13/12
SQL Column: AMOUNT
Java Field: amount
Status: Active
SQL Type: varchar(12)
Java Type: String
Amount of the authorization. 2 decimal implied. Minimum amount for all card types is $0.01 U.S. dollars* (or established international currency equivalent), but no greater than the established Transaction Division limit. The default is $99,999.99
Added On: 06/14/16
SQL Column:
Java Field: applicationId
Status: Active
SQL Type:
Java Type: String
Identification number of the used application.
Added On: 02/18/22
SQL Column: AUTH_MID
Java Field: authMid
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 02/18/22
SQL Column: AUTH_PASSWORD
Java Field: authPassword
Status: Active
SQL Type: varchar
Java Type: String
Added On: 02/18/22
SQL Column: AUTH_USERNAME
Java Field: authUsername
Status: Active
SQL Type: varchar
Java Type: String
Added On: 02/13/12
SQL Column: AUTHORIZATION_CODE
Java Field: authorizationCode
Status: Active
SQL Type: varchar(6)
Java Type: String
Authorization code of the approved, original, authorized transaction. This field cannot be blank or the transaction will reject with Response Reason Code 262 (Authorization Code/Response Date Invalid).
Added On: 02/13/12
SQL Column: AVS_RESPONSE_CODE
Java Field: avsResponseCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Response to address verification request.
Added On: 11/30/17
SQL Column: BALANCE_AMOUNT1
Java Field: balanceAmount1
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_AMOUNT2
Java Field: balanceAmount2
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_AMOUNT3
Java Field: balanceAmount3
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_AMOUNT4
Java Field: balanceAmount4
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_AMOUNT5
Java Field: balanceAmount5
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_AMOUNT6
Java Field: balanceAmount6
Status: Active
SQL Type: varchar(13)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_TYPE1
Java Field: balanceType1
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_TYPE2
Java Field: balanceType2
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_TYPE3
Java Field: balanceType3
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_TYPE4
Java Field: balanceType4
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_TYPE5
Java Field: balanceType5
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/30/17
SQL Column: BALANCE_TYPE6
Java Field: balanceType6
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/30/17
SQL Column: BILL_TO_FIRST_NAME
Java Field: billToFirstName
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 11/30/17
SQL Column: BILL_TO_LAST_NAME
Java Field: billToLastName
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 11/30/17
SQL Column: BILL_TO_TELEPHONE_NUMBER
Java Field: billToTelephoneNumber
Status: Active
SQL Type: varchar(14)
Java Type: String
Added On: 11/30/17
SQL Column: BILL_TO_TELEPHONE_TYPE
Java Field: billToTelephoneType
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/13/12
SQL Column: BILLER_REFERENCE_NUMBER
Java Field: billerReferenceNumber
Status: Active
SQL Type: varchar(25)
Java Type: String
Reference number the biller (merchant) uses on his system to identify this customer
Added On: 02/13/12
SQL Column: CARD_SECURITY_PRESENCE
Java Field: cardSecurityPresence
Status: Active
SQL Type: varchar(1)
Java Type: String
Used to validate the presence of a card security value.
We use:
1 – Value is present (DI, MC, MD, or VI)
“ ” – Blank, indicator not sent (AX, MC, MD)
Added On: 06/14/16
SQL Column:
Java Field: cardSecurityValue
Status: Active
SQL Type:
Java Type: String
CVV code of the credit card.
Added On: 11/30/17
SQL Column: CARD_TYPE_INFO1
Java Field: cardTypeInfo1
Status: Active
SQL Type: varchar(11)
Java Type: String
Added On: 11/30/17
SQL Column: CARD_TYPE_INFO2
Java Field: cardTypeInfo2
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/30/17
SQL Column: CASH_BACK_AMOUNT
Java Field: cashBackAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/30/17
SQL Column: CASH_BACK_AMOUNT_APPROVED
Java Field: cashBackAmountApproved
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/30/17
SQL Column: CASH_BACK_AMOUNT_REQUESTED
Java Field: cashBackAmountRequested
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 06/14/16
SQL Column:
Java Field: cavv
Status: Active
SQL Type:
Java Type: String
Added On: 02/13/12
SQL Column: CAVV_RESPONSE_CODE
Java Field: cavvResponseCode
Status: Active
SQL Type: varchar(1)
Java Type: String
This field will be populated for any Verified by Visa transaction.
It is used during authorization processing to verify that authentication, or attempted authentication, was performed. The Issuer receives the authorization request and validates the CAVV and responds with a CAVV response code, as well as an approval or a decline of the authorization. If the CAVV does not match, the Issuer should decline the transaction.
Added On: 06/14/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: 11/30/17
SQL Column: CHIP_DATA
Java Field: chipData
Status: Active
SQL Type: varchar(1002)
Java Type: String
Added On: 11/30/17
SQL Column: CHIP_DATA_RESPONSE
Java Field: chipDataResponse
Status: Active
SQL Type: varchar(999)
Java Type: String
Added On: 02/13/12
SQL Column: CITY
Java Field: city
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 02/13/12
SQL Column: CLIENT_REF
Java Field: clientRef
Status: Active
SQL Type: varchar(14)
Java Type: String
Unique value, that identifies the transaction.
This value is calculated by the gateway, according to the processor's specification rules. This value is taken into account by the processor on the communications layer.
Added On: 11/30/17
SQL Column: CLINIC_OTHER_AMOUNT
Java Field: clinicOtherAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 02/13/12
SQL Column: COUNTRY_CODE
Java Field: countryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Accountholder’s country code.
Added On: 03/23/18
SQL Column: CRYPTOGRAM_TYPE
Java Field: cryptogramType
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/13/12
SQL Column: CSV_RESPONSE_CODE
Java Field: csvResponseCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Card Security Value Response Code returned by the card Issuer in response to a card security verification request.
Added On: 11/30/17
SQL Column: CURRENCY_CODE
Java Field: currencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 02/13/12
SQL Column: CURRENT_BALANCE
Java Field: currentBalance
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/01/18
SQL Column: CURRENT_BALANCE_CURRENCY_CODE
Java Field: currentBalanceCurrencyCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Added On: 11/01/18
SQL Column: CURRENT_BALANCE_SIGN
Java Field: currentBalanceSign
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: DENTAL_AMOUNT
Java Field: dentalAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 02/17/15
SQL Column: DESCRIPTION
Java Field: description
Status: Active
SQL Type: varchar(38)
Java Type: String
Item Description (optional). Left justified/space filled.
Notes: First Data will not pass the full 38 bytes of this field.
Added On: 11/30/17
SQL Column: DEVICE_TYPE
Java Field: deviceType
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 06/14/16
SQL Column:
Java Field: did
Status: Active
SQL Type:
Java Type: String
Identifier of the merchant. Assigned by the processor.
Added On: 02/13/12
SQL Column: DIVISION_NUMBER
Java Field: divisionNumber
Status: Active
SQL Type: varchar(10)
Java Type: String
Assigned and provided to merchant by First Data. First Data assigns a unique Division Number to process each international currency. A single Division Number can support different transaction types and methods of payment in the same currency.
Added On: 11/30/17
SQL Column: EMAIL_ADDRESS
Java Field: emailAddress
Status: Active
SQL Type: varchar(50)
Java Type: String
Added On: 11/30/17
SQL Column: ENCRYPTED_PIN_NUMBER
Java Field: encryptedPinNumber
Status: Active
SQL Type: varchar(16)
Java Type: String
Added On: 03/30/14
SQL Column: ENCRYPTION_FLAG
Java Field: encryptionFlag
Status: Active
SQL Type: varchar(3)
Java Type: String
Indicates transaction token status.
Possible values:
PAN – TransArmor token request (or on response if tokenization failure and PAN masked;
TOK – TransArmor token supplied.
Added On: 06/14/16
SQL Column:
Java Field: expirationDate
Status: Active
SQL Type:
Java Type: String
Expiration date of the associated credit card.
Added On: 03/30/14
SQL Column: FIRST_DATA_TOKEN_CODE
Java Field: firstDataTokenCode
Status: Active
SQL Type: varchar(19)
Java Type: String
The tokenized value of Account Number.
Added On: 11/30/17
SQL Column: FOOD_AND_CONSUMER_NUMBER
Java Field: foodAndConsumerNumber
Status: Active
SQL Type: varchar(8)
Java Type: String
Added On: 11/30/17
SQL Column: FORMAT_VERSION
Java Field: formatVersion
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 02/13/12
SQL Column: ID
Java Field: id
Status: Active
SQL Type: bigint(20)
Java Type: Long
Attributes:
Unique, Required
Identifier of the object used for references; auto-incremented integer value.
Added On: 03/23/18
SQL Column: INITIATION_INDICATOR
Java Field: initiationIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/13/12
SQL Column: LENGTH_INDICATOR
Java Field: lengthIndicator
Status: Active
SQL Type: varchar(3)
Java Type: String
Indicates the number of positions submitted for the following field
Added On: 02/13/12
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: 11/30/17
SQL Column: MERCHANT_CATEGORY_CODE
Java Field: merchantCategoryCode
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 02/17/15
SQL Column: MERCHANT_CITY
Java Field: merchantCity
Status: Active
SQL Type: varchar(21)
Java Type: String
City of the merchant's postal address.
Added On: 02/17/15
SQL Column: MERCHANT_COUNTRY_CODE
Java Field: merchantCountryCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Country code of the merchant's postal address.
Added On: 11/30/17
SQL Column: MERCHANT_ID
Java Field: merchantId
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 02/17/15
SQL Column: MERCHANT_POSTAL_CODE
Java Field: merchantPostalCode
Status: Active
SQL Type: varchar(15)
Java Type: String
ZIP code of the merchant's postal address.
Added On: 02/17/15
SQL Column: MERCHANT_REGION
Java Field: merchantRegion
Status: Active
SQL Type: varchar(3)
Java Type: String
Region code of the merchant's postal address.
Added On: 02/17/15
SQL Column: MERCHANT_STREET
Java Field: merchantStreet
Status: Active
SQL Type: varchar(38)
Java Type: String
Street of the merchant's postal address.
Added On: 11/30/17
SQL Column: MESSAGE_TYPE
Java Field: messageType
Status: Active
SQL Type: varchar(4)
Java Type: String
Added On: 06/14/16
SQL Column:
Java Field: mid
Status: Active
SQL Type:
Java Type: String
Identifier of the merchant. Assigned by the processor.
Added On: 02/13/12
SQL Column: MOP_REQUEST
Java Field: mopRequest
Status: Active
SQL Type: varchar(2)
Java Type: String
Method of Payment (MOP) defines the MOP associated with this transaction.
Added On: 03/06/15
SQL Column: MOP_RESPONSE
Java Field: mopResponse
Status: Active
SQL Type: varchar(2)
Java Type: String
Method of Payment (MOP) defines the MOP associated with this transaction.
Added On: 02/13/12
SQL Column: NAME_TEXT
Java Field: nameText
Status: Active
SQL Type: varchar(30)
Java Type: String
Accountholder’s name (asterisk should precede last name).
Added On: 02/13/12
SQL Column: ORDER_NUMBER
Java Field: orderNumber
Status: Active
SQL Type: varchar(22)
Java Type: String
A value composed of any alpha, blank, digit, or punctuation combination that will be returned in the transaction response. This field will tie the merchant’s request to the First Data response.
Added On: 03/23/18
SQL Column: ORIGINAL_DATA_REQUEST_INDICATOR
Java Field: originalDataRequestIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: ORIGINAL_REFERENCE_NUMBER
Java Field: originalReferenceNumber
Status: Active
SQL Type: varchar(40)
Java Type: String
Added On: 03/23/18
SQL Column: ORIGINAL_VISA_TRANSACTION_ID
Java Field: originalVisaTransactionId
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 02/13/12
SQL Column: PARTIAL_REDEMPTION_INDICATOR
Java Field: partialRedemptionIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Determines approval functionality for pre-paid/gift card authorizations.
Valid values for American Express:
Y – Transaction is not declined if authorization amount is greater than the current balance
N – Transaction is declined if authorization amount is greater than the current balance
Valid values for Discover:
Y – The sale amount can be partially approved but the cash back amount cannot be partially approved.
N – Merchant does not support partial authorization. Partial authorization not allowed for both sale amount and cash back amount.
Valid values for Visa/MasterCard/MasterCard Diners:
Y – Attempt a partial authorization if allowed for the account.
N – Do not attempt a partial authorization.
Added On: 11/30/17
SQL Column: PARTIAL_REDEMPTION_INDICATOR_GIFT
Java Field: partialRedemptionIndicatorGift
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: PAYMENT_DEVICE
Java Field: paymentDevice
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 11/30/17
SQL Column: PIN_KEY_SEQUENCE_NUMBER
Java Field: pinKeySequenceNumber
Status: Active
SQL Type: varchar(16)
Java Type: String
Added On: 11/30/17
SQL Column: POS_CAPABILITY_CODE
Java Field: posCapabilityCode
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: POS_ENTRY_MODE
Java Field: posEntryMode
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 11/30/17
SQL Column: POS_ENTRY_MODE_RESPONSE
Java Field: posEntryModeResponse
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 02/13/12
SQL Column: POSTAL_CODE
Java Field: postalCode
Status: Active
SQL Type: varchar(10)
Java Type: String
Accountholder’s postal code.
Added On: 11/30/17
SQL Column: PREVIOUS_BALANCE
Java Field: previousBalance
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/30/17
SQL Column: QHP_AMOUNT
Java Field: qhpAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 02/13/12
SQL Column: RECURRING_PAYMENT_ADVICE_CODE
Java Field: recurringPaymentAdviceCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Field Recurring payment advice code (MasterCard/MasterCard Diners Only) has such valid values:
01 – New account information available. Obtain new account information.
02 – Try again later. Recycle transaction in 72 hours.
03 – Do not try again. Obtain another type of payment from customer.
21 – Do not try again. Issuer has blocked recurring payment transaction. Default space filled
Added On: 02/13/12
SQL Column: REDEMPTION_AMOUNT
Java Field: redemptionAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Approved amount. Partial authorization is done and redemption amount is returned if authorized amount > available balance.
Added On: 02/13/12
SQL Column: RESPONSE_DATE
Java Field: responseDate
Status: Active
SQL Type: varchar(6)
Java Type: String
Date of approved, original, authorized transaction. YYMMDD format.
Response date must be current or prior date or the transaction will reject with Response Reason Code 262 (Authorization Code/Response Date Invalid).
Added On: 02/13/12
SQL Column: RESPONSE_REASON_CODE
Java Field: responseReasonCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Description of the response code
Added On: 02/13/12
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: 11/30/17
SQL Column: RX_AMOUNT
Java Field: rxAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 03/23/18
SQL Column: SCHEDULE_INDICATOR
Java Field: scheduleIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_ADDRESS_LINE1
Java Field: shipToAddressLine1
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_CITY
Java Field: shipToCity
Status: Active
SQL Type: varchar(20)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_COUNTRY_CODE
Java Field: shipToCountryCode
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_FIRST_NAME
Java Field: shipToFirstName
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_LAST_NAME
Java Field: shipToLastName
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_NAME_TEXT
Java Field: shipToNameText
Status: Active
SQL Type: varchar(30)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_POSTAL_CODE
Java Field: shipToPostalCode
Status: Active
SQL Type: varchar(10)
Java Type: String
Added On: 11/30/17
SQL Column: SHIP_TO_STATE
Java Field: shipToState
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 03/23/18
SQL Column: SPECIAL_PAYMENT_TYPE_INDICATOR
Java Field: specialPaymentTypeIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/13/12
SQL Column: STATE
Java Field: state
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 03/23/18
SQL Column: STORED_CREDENTIAL_INDICATOR
Java Field: storedCredentialIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 11/30/17
SQL Column: SUBTYPE_FLAG
Java Field: subtypeFlag
Status: Active
SQL Type: varchar(1)
Java Type: String
Added On: 02/13/12
SQL Column: SURCHARGE_AMOUNT
Java Field: surchargeAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 06/14/16
SQL Column:
Java Field: svcid
Status: Active
SQL Type:
Java Type: String
Identifier of the merchant. Assigned by the processor.
Added On: 06/14/16
SQL Column:
Java Field: swipeData
Status: Active
SQL Type:
Java Type: String
Track data of the swipe card associated with the transaction.
Added On: 05/16/14
SQL Column: TERMINAL_ID
Java Field: terminalId
Status: Active
SQL Type: varchar(8)
Java Type: String
Terminal identification – code identifying the balancing features available to the POS from the Host.
Added On: 06/14/16
SQL Column:
Java Field: tid
Status: Active
SQL Type:
Java Type: String
Identifier of the terminal. Assigned by the processor.
Added On: 11/30/17
SQL Column: TOKEN_ASSURANCE_LEVEL
Java Field: tokenAssuranceLevel
Status: Active
SQL Type: varchar(2)
Java Type: String
Added On: 11/30/17
SQL Column: TOKEN_REQUESTOR_ID
Java Field: tokenRequestorId
Status: Active
SQL Type: varchar(11)
Java Type: String
Added On: 04/12/14
SQL Column: TOKEN_TYPE
Java Field: tokenType
Status: Active
SQL Type: varchar(4)
Java Type: String
Merchant Specific Token Value issued by First Data.
This Format record will be returned on all TransArmor submissions.
Added On: 02/13/12
SQL Column: TOTAL_AMOUNT
Java Field: totalAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Total transaction amount, including surcharge (if any)
Added On: 02/13/12
SQL Column: TPP_ID
Java Field: tppId
Status: Active
SQL Type: varchar(6)
Java Type: String
Third Party Processor ID is mandatory on all Authorization requests submitted by Third Parties who have been issued one by First Data.
If you were assigned a Third Party Processor ID, you are required to send this additional format record.
If you were not assigned a Third Party Processor ID, this record should not be sent.
Added On: 02/13/12
SQL Column: TRACE_NUMBER
Java Field: traceNumber
Status: Active
SQL Type: varchar(8)
Java Type: String
Trace number returned from debit vendor
Added On: 11/30/17
SQL Column: TRACE_NUMBER_RESPONSE
Java Field: traceNumberResponse
Status: Active
SQL Type: varchar(8)
Java Type: String
Added On: 02/13/12
SQL Column: TRACK_INDICATOR
Java Field: trackIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Track that was read.
Valid values: 1 – Track 1 2 – Track 2
Added On: 02/13/12
SQL Column: TRANSACTION_TYPE
Java Field: transactionType
Status: Active
SQL Type: varchar(1)
Java Type: String
Describes the circumstances under which the transaction takes place. Default space filled.
We use:
1 – MOTO Indicator – Single Transaction Mail/telephone order: designates a transaction where the cardholder is not present at a merchant location and consummates the sale via the phone or through the mail. The transaction is not for recurring services or product and does not include sales that are processed via an installment plan.
2 – MOTO Indicator – Recurring Transaction: Designates a transaction that represents an arrangement between a cardholder and the merchant where transactions are going to occur on a periodic basis.
3 – MOTO Indicator – Installment Payment: Designates a group of transactions that originated from a single purchase where the merchant agrees to bill the cardholder in installments.
7 – ECI Indicator – Channel Encrypted Transaction: Designates a transaction between a cardholder and a merchant consummated via the Internet where the transaction includes the use of transaction encryption such as SSL, but authentication was not performed. The cardholder payment data was protected with a form of Internet security, such as SSL, but authentication was not performed.
R – Retail Indicator – designates a transaction where the cardholder was present at a merchant location. If an “R” is sent for a transaction with a MOTO Merchant Category Code (MCC) the transaction will downgrade.
Added On: 05/04/17
SQL Column: URLS
Java Field: urls
Status: Active
SQL Type: varchar
Java Type: String
Datawire address where the transactions are sent to.
Added On: 03/23/18
SQL Column: VISA_TRANSACTION_ID
Java Field: visaTransactionId
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 11/30/17
SQL Column: VISION_AMOUNT
Java Field: visionAmount
Status: Active
SQL Type: varchar(12)
Java Type: String
Added On: 11/30/17
SQL Column: VOUCHER_NUMBER
Java Field: voucherNumber
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 06/14/16
SQL Column:
Java Field: xid
Status: Active
SQL Type:
Java Type: String
Identifier of the merchant. Assigned by the processor.