Zip and Country Codes
Development
Reference Materials
Vantiv Tandem Auth Retail Transaction UML
Added On: 05/27/13
Module: UniCharge
Type: Entity
Status: Active
Java Class: VantivTandemAuthRetailTransaction
Added On: 06/04/13
SQL Column: APPROVED_AMOUNT
Java Field: approvedAmount
Status: Active
SQL Type: int(11)
Java Type: Integer
Approved amount of the transaction.
Added On: 06/10/16
SQL Column:
Java Field: basicAuthentication
Status: Active
SQL Type:
Java Type: String
Indicator of the result of the transaction that requested authentication.
Added On: 05/27/13
SQL Column: BIT_MAP_TYPE
Java Field: bitMapType
Status: Active
SQL Type: varchar(2)
Java Type: String
Used in conjunction with the Message Type Identifier to determine which data elements are in the message being transmitted.
Added On: 05/27/13
SQL Column:
Java Field: bit02
Status: Active
SQL Type:
Java Type: String
Primary Account Number.
The PAN field must appear in the following message type:
0400 Reversal request
The field can contain up to 19 bytes of alphanumeric data representing the debit or credit card number associated with the transaction being reversed (voided). The data is left justified, space filled. This field can contain the encrypted PAN when the POS is using a supported encryption vendor’s software.
When transaction using token (POS condition code position 8 = 5 with group request data G028) must set this field to spaces for applicable base request messages.
Added On: 05/27/13
SQL Column: BIT03
Java Field: bit03
Status: Active
SQL Type: varchar(6)
Java Type: String
Processing Code.
May appear in the following message types:
- 0100 and 0110 - Authorization request and response
- 0200 and 0210 - Financial request and response
- 0220 and 0230 - Financial request and response
- 0400 - Unsolicited Reversal request (this is the Processing code of the original that is being reversed. The original processing code was ISO Format. This code will be its equivalent value in TPS format.)
- 0410 - Reversal response
- 0500 - Reconciliation request
Consists of three two-digit sub fields that indicate how the transaction specified by the message type affects the customer’s related account(s).
Note: The authorization service can update the "From" and "To" account information. The operating rules for the authorization service may require the terminal device to print the account information on the receipt.
Added On: 05/27/13
SQL Column: BIT04
Java Field: bit04
Status: Active
SQL Type: varchar(9)
Java Type: String
Transaction Amount.
This field may appear in the following message types:
- 0100 Authorization request
- 0110 Authorization response
- 0200 Financial request
- 0220 Financial request
- 0400 Unsolicited Reversal Request
The nine-digit transaction amount field represents the monetary value associated with the cardholder’s authorization, debit, or credit transaction request. The amount is entered in the terminal as a seven-digit number and is always right justified and zero filled. This field does not include cash back.
- For authorization reversals this field must contain the approved amount authorized from the original transaction.
- For timeout scenarios where the approved amount is not known, populate this field with the original amount requested in the timed-out transaction.
- For AVS verification only (Processing code 514000) request, this field must be zero filled.
- For MasterCard and Discover Account Status Inquiry transactions this field must be zero-filled.
- For Visa Product Eligibility Inquiry transactions this field must be zero-filled.
- For EBT WIC purchases, this represents the amount of the transaction BEFORE any coupons or discounts are applied.
Added On: 08/28/13
SQL Column: BIT04_AMOUNT
Java Field: bit04Amount
Status: Active
SQL Type: varchar(9)
Java Type: String
Amount.
This field may appear in the following message types:
- 0100 Authorization request
- 0110 Authorization response
- 0200 Financial request
- 0220 Financial request
- 0400 Unsolicited Reversal Request
The nine-digit transaction amount field represents the monetary value associated with the cardholder’s authorization, debit, or credit transaction request. The amount is entered in the terminal as a seven-digit number and is always right justified and zero filled. This field does not include cash back.
Added On: 05/27/13
SQL Column: BIT07
Java Field: bit07
Status: Active
SQL Type: varchar(10)
Java Type: String
Transmission Date and Time.
The transmission date and time field may appear in the following message types:
- 0100 Check and financial authorization request (controller)
- 0100 Partial reversal
- 0110 Authorization response
- 0200 Financial request (controller)
- 0210 Financial response
- 0220 Credit card prior authorization
- 0400 Reversal (void) request (controller)
- 0410 Reversal (void) response
In the host capture terminal messages this field represents the date and time that the transaction was processed by the host.
In the host capture controller messages this is the date/time at which the controller transmitted the transaction to the Tandem Online System. It is set by the controller.
In a 0400 reversal message, the date and time apply to the reversal/void request itself, not the original transaction.
The ten-digit field is in MMDDYYhhmm format, with the time portion expressed in 24-hour (military) notation. For example, 1114971346 represents Nov. 14, 1997, at 1:46 P.M.
Added On: 05/27/13
SQL Column: BIT105
Java Field: bit105
Status: Active
SQL Type: varchar(22)
Java Type: String
Contains several fields:
- Additional Response Data/CVV2/AVS Result Code;
- Payment Service Indicator;
- Transaction Identifier Banknet/POSA SAF Ref. Num.;
- VISA Validation Code.
Refer to the specification of the processor for more information.
Added On: 05/27/13
SQL Column: BIT105_AVS_RESULT_CODE
Java Field: bit105AvsResultCode
Status: Active
SQL Type: varchar(2)
Java Type: String
AVS Result Code.
The field contains the CVV2 and address verification (AVS) result codes. Used for transactions where CVV2 and/or AVS was requested, it provides an additional indication that the card is being used by the person to which it was issued.
The first character is the CVV2 result code, the second character is the AVS result code (space when the transaction does not qualify for AVS). Visa and MasterCard return CVV2/CVC2 response codes. The following tables list the CVV2 and AVS result codes.
AVS RESULT CODE (POSITION 2)
- A - Address Matches, ZIP does not
- E - Error
- G - International issuer not participating in AVS
- N - Neither address nor ZIP matches
- R - Retry, system unavailable or timed out
- U - Issuer is unavailable
- Y - Address and ZIP both match
- Z - ZIP matches, address does not
Added On: 05/27/13
SQL Column: BIT105_PAYMENT_SERVICE_INDICATOR
Java Field: bit105PaymentServiceIndicator
Status: Active
SQL Type: varchar(1)
Java Type: String
Payment Service Indicator.
This single-character field must appear in the following message types:
- 0100 EFT partial reversal request
- 0110 Authorization response
- 0220 Financial request (Bit Map Type 04, 24)
- 0210 Financial response
- 0230 Financial response
- 0410 Reversal response
For VISA, the field contains a code that indicates whether the authorization qualifies for PS 2000 processing. ‘N’ = not PS2000 qualified; other values are as documented by VISA.
For MasterCard, the field contains a CVC (card validation character) compliance flag, used internally by the Tandem Online System.
Added On: 05/27/13
SQL Column: BIT105_TRANSACTION_IDENTIFIER
Java Field: bit105TransactionIdentifier
Status: Active
SQL Type: varchar(15)
Java Type: String
Transaction Identifier Banknet/POSA SAF Ref. Num.
(VISA)/Banknet Data (MC)/POSA SAF Reference Number This 15-character field must appear in the following message types:
- 0100 EFT partial reversal request
- 0110 Authorization response
- 0220 Financial request (Bit Map Type 04, 24)
- 0210 Financial response
- 0230 Financial response
- 0410 Reversal response
The field will contain information provided by the authorizer.
- For VISA CPS implementation, it is a unique identifier used to link together all related transactions authorized and cleared through VISANet. If the Payment Service Indicator (bit 105.2) is ‘A’ and this field is not all zeros, it may be printed on receipts to facilitate retrieval requests but is not required. The printing of the Transaction ID is required for e-Сommerce Transaction Receipts.
- For POSA Prepaid, the field contains the POSA SAF Reference Number uniquely assigned by the host. This value occupies the first twelve positions left-justified space filled. The POS device should use this value to populate POSA SAF Reference Number (field 136) when sending a POSA SAF Activation/Reload transaction request message. POSA SAF requests also require that the POSA Stand-In Indicator (Field 135) be set to a value of “Y” in the transaction request message.
- For 'MasterCard values, please, refer o the specification of the processor for more information.
Added On: 05/27/13
SQL Column: BIT105_VISA_VALIDATION_CODE
Java Field: bit105VisaValidationCode
Status: Active
SQL Type: varchar(4)
Java Type: String
VISA Validation Code.
This four-character field must appear in the following message types:
- 0100 EFT partial reversal request
- 0110 Authorization response
- 0220 Financial request (Bit Map Type 04, 24)
- 0210 Financial response
- 0230 Financial response
- 0410 Reversal response
For VISA transactions, the code in the field is used to determine the accuracy of the authorization data. It is generated by VISA using a VISA-proprietary algorithm based on the following request and response data fields.
Primary Account Number Authorization Identification Response
Transaction Amount Response Code
Merchant Type Payment Service Indicator
POS Entry Mode Code (positions 1-2) Transaction Identifier
For MasterCard transactions, this field contains the Banknet date.
Added On: 05/27/13
SQL Column: BIT106
Java Field: bit106
Status: Active
SQL Type: varchar(29)
Java Type: String
Cardholder Identification (AVS).
This 29-character field must appear in the 0100 authorization request or 0200 financial transaction request message when the Bit Map Type is 05, 06, 25, or 26. It contains the data used for address verification.
The field contains two data subfields:
The first 20 positions are the cardholder’s address data, left justified and space filled; the last nine positions contain the ZIP code. If the ZIP code is present, it must be either five or nine characters in length, left justified and padded with spaces if only five characters.
Added On: 05/27/13
SQL Column: BIT107
Java Field: bit107
Status: Active
SQL Type: varchar(2)
Java Type: String
Point-of-Service Device Capability Code.
This two-character field must appear in the following messages:
- 0100 authorization request
- 0200 financial request
- 0220 financial request
- 0400 reversal request
The field contains two subfields that indicate the type of POS device used and the device’s ability to read encoded data.
Added On: 05/27/13
SQL Column: BIT109
Java Field: bit109
Status: Active
SQL Type: varchar(20)
Java Type: String
P.O. Number/Customer Code.
This twenty-character field contains the purchase order number applicable to a financial transaction or the customer code associated with a purchase card. It is required in the following message types:
- 0100 credit authorization only (Bit Map Type 21 or 25)
- 0200 and 0220 credit card requests (Bit Map Types 21–26)
- 0200 VISA POS check conversion request (Bit Map Type 16)
- 0400 VISA POS check conversion request (Bit Map Type 16)
- 0100 check verification/guarantee request (Bit Map Type 32)
- 0200 check conversion request (Bit Map Type 32)
The field is optional in the 0200 financial request for a private-label (Bit Map Type 07) or fuel (Bit Map Type 09) sale.
Added On: 05/27/13
SQL Column: BIT11
Java Field: bit11
Status: Active
SQL Type: varchar(6)
Java Type: String
System Trace Audit Number (STAN).
The in-store controller creates this six-digit number at transaction time to uniquely identify the transaction. This field appears in every message type supported by the Tandem Online System and the instore controller.
Added On: 05/27/13
SQL Column: BIT110
Java Field: bit110
Status: Active
SQL Type: varchar(9)
Java Type: String
Tax Amount.
This nine-digit field appears in 0100 authorization requests and 0200 financial requests that apply to corporate or purchase credit cards.
It contains the dollar amount of tax included in the transaction, in the format 999999999. Sending a value of all 9’s (999999999) in the request message indicates that this is a non-taxable transaction. Sending a value of all 8’s (888888888) in the request message indicates that this is a tax-exempt transaction.
Note: For non-corporate/purchase cards, this data element can be sent as all zeroes.
Added On: 05/27/13
SQL Column: BIT111
Java Field: bit111
Status: Active
SQL Type: varchar(15)
Java Type: String
Additional Data, Private EBT.
This 15-byte field is conditional in the 0200 financial message. Present only when the processing code indicates an EBT transaction, it contains the voucher number required for clearing EBT voice authorizations.
Added On: 05/27/13
SQL Column: BIT112
Java Field: bit112
Status: Active
SQL Type: varchar(3)
Java Type: String
Card Sequence Number.
The three-digit card sequence number field is conditional in the 0200 financial request message when the processing code indicates an EBT transaction. The field is required only if the card has a generation number and the card was not swiped.
The card sequence number distinguishes between separate cards with the same primary account number.
Added On: 05/27/13
SQL Column: BIT115
Java Field: bit115
Status: Active
SQL Type: varchar(16)
Java Type: String
Trace Data 1.
In the host capture terminal message set, this 16-character field must appear in the 0800 (Bit Map Type 02) and 0810 (Bit Map Type 94) network management request and response when processing the line management test function (echo test).
The field is included in all controller messages as an echo field for the controller’s use.
The Tandem Online System echoes the data exactly as it was received.
Added On: 05/27/13
SQL Column:
Java Field: bit117
Status: Active
SQL Type:
Java Type: String
DUKPT Serial Number.
For PIN-based transactions using DUKPT encryption, this is the 20-character terminal serial number used in the encryption process. This field is populated by the POS system (typically from the PIN pad) for every PIN-based request.
Can be spaces in 0400 reversal requests.
Added On: 05/27/13
SQL Column: BIT12
Java Field: bit12
Status: Active
SQL Type: varchar(6)
Java Type: String
Local Transaction Date.
The six-digit transaction date appears in all request messages handled by the in-store controller; it indicates the date (MMDDYY) on which the transaction occurred at the point of sale.
In 0400 reversal/void requests, this field represents the transaction being voided; see 07 Transmission Date/Time.
In a Gift Card Completion message the Local Transaction Date must be populated with the Local Transaction Date received in the Gift Card Preauth approval message.
In an Unsolicited Reversal the Local Transaction Date must be populated with the Local Transaction Date received in the original Authorization request message.
Added On: 05/27/13
SQL Column: BIT120_BATCH_NUMBER
Java Field: bit120BatchNumber
Status: Active
SQL Type: varchar(6)
Java Type: String
Julian Day/Batch Number.
This six-digit field appears in the 0210 and 0230 financial response and 0410 reversal response messages. It indicates under which batch the EFT transaction was captured at the host. The field contains the three-digit Julian day when the batch was opened and the three-digit batch number. (The batch number increases by one whenever a batch is released and resets to one for each Julian day). The field does not appear if Bit Map Type is 99.
Added On: 05/27/13
SQL Column: BIT120_CARD_TYPE
Java Field: bit120CardType
Status: Active
SQL Type: varchar(4)
Java Type: String
Network Mnemonic/Card Type.
This field serves one of two purposes, depending on the transaction type.
The two- to four-character Card Type appears in the 0110 purchase/corporate card, check verification/guarantee authorization responses, 0210/0230 credit, check conversion responses, and 0410 reversal response messages for credit transactions and check conversion reversals.
The value is controlled by the in-store application and the Tandem Online System (BIN table).
The third character, when present, indicates the card category.
- L (Business-to-Business settlement match edits eligible card),
- B (Business),
- R (Corporate), and
- S (Purchase)
are the VISA purchase-card categories;
S is the MasterCard purchase-card category.
The fourth character, if present, is the authorization source indicator returned by Visa. The code is left justified with the remainder of the field space filled.
Example of network switch value for payment type DB is “MAES“, for payment type EB is “EWA1”.
Added On: 05/27/13
SQL Column: BIT120_DEMO_MERCHANT_FLAG
Java Field: bit120DemoMerchantFlag
Status: Active
SQL Type: varchar(1)
Java Type: String
Demo Merchant Flag.
This single-character field appears in the 0210 and 0230 financial response and 0410 reversal response messages. It indicates whether or not the terminal is being operated in demonstration or production mode. Does not appear if Bit Map Type is 99.
- ‘Y’ = Demo mode;
- ‘N’ = Production mode
Added On: 05/27/13
SQL Column: BIT123_ERROR_TEXT
Java Field: bit123ErrorText
Status: Active
SQL Type: varchar(20)
Java Type: String
Error Text.
This 20-character field must appear in all response messages when the Bit Map Type is 99 (i.e., error responses). The field indicates an error condition; the text is displayed on the POS terminal.
Added On: 05/27/13
SQL Column: BIT123_RESPONSE_CODE
Java Field: bit123ResponseCode
Status: Active
SQL Type: varchar(3)
Java Type: String
Response Code.
The three-digit response code must appear in all response messages when the Bit Map Type is 99 (i.e., error responses). In the case of the 0330 file update response (Bit Map Types 81 and 89), both approval and error messages include the response code. This field is used to further define the cause of a decline or error response, and is displayed in the scroll area of the terminal.
POSA Prepaid Transactions
When error response code values of “001” or “795” is received, the POS device should place the transaction on a store-and-forward (SAF) queue for retransmission. SAF request messages must have the POSA-Stand-In indicator (Field 135) to “Y” and include the POSA SAF Reference Number (Field 136) of the original transaction when available.
The POSA SAF Reference Number is provided in field 105.3 of the response message. A POS device time-out should be treated the same as receiving a “001” response code except that the POSA SAF Reference Number should be set to spaces. If SAF queuing is used, the POS should use parameters to determine number of retries and retry interval.
Added On: 05/27/13
SQL Column: BIT124_WORKING_KEY
Java Field: bit124WorkingKey
Status: Active
SQL Type: varchar(16)
Java Type: String
Working Key.
The 16-character working key appears in all response messages. It is not used when DUKPT encryption is employed.
The field will contain blanks if the host does not require a key exchange. If the field does not contain blanks, the terminal uses this working key for future debit/EBT transaction processing.
Added On: 05/27/13
SQL Column: BIT128_ADDITIONAL_AMOUNTS
Java Field: bit128AdditionalAmounts
Status: Active
SQL Type: varchar(120)
Java Type: String
Additional Amounts.
This 20-byte field contains information — up to six amounts and related account data — for which specific data elements are not defined. It is used in 0110, for Premier Issue Mass Transaction, EBT and used in 0210 for EBT, POSA Prepaid and Gift Card responses, where it contains balance information.
Added On: 05/27/13
SQL Column: BIT13
Java Field: bit13
Status: Active
SQL Type: varchar(6)
Java Type: String
Local Transaction Time.
The six-digit transaction time appears in all request messages handled by the in-store controller; it indicates the time (hhmmss) at which the transaction occurred at the point of sale.
In 0400 reversal/void requests, this field represents the transaction being voided; see 07 Transmission Date/Time.
In a Gift Card Completion message the Local Transaction Time must be populated with the Local Transaction Time received in the Gift Card Preauth approval message.
In a Unsolicited Reversal the Local Transaction Time must be populated with the Local Transaction Time received in the original Authorization request message.
Added On: 05/27/13
SQL Column: BIT133
Java Field: bit133
Status: Active
SQL Type: varchar(4)
Java Type: String
POSA Network ID.
This four-byte field defines the POSA network used to authorize the POSA transaction. This field must appear in all POSA transactions. POSA networks are:
- “SWAY” Safeway
- “INCM” InComm
- “PRES” PreSolutions
- “SVSG” Stored Value Systems
- “VALU” ValueLink
- “ “ Non POSA card (spaces)
If the merchant is processing POSA cards, but the point-of-sale system is unable to determine the POSA Network, then that merchant can only successfully process for a single POSA network. In this case, the POSA Network ID field must be set up at the point of sale to always indicate the merchant’s selected network (e.g. SWAY). The value should either be hard-coded into the system or set as a parameter. If the merchant also sells their own gift cards via non-POSA networks, then the BIN range(s) for the merchant’s gift cards must be registered with Vantiv, LLC (Tandem Onlines) for processing.
Notes: Merchants that do not participate in POSA need to fill the POSA Network ID field with spaces.
Contact Vantiv, LLC for current supported networks.
Added On: 05/27/13
SQL Column: BIT134
Java Field: bit134
Status: Active
SQL Type: varchar(20)
Java Type: String
POSA UPC Data.
This twenty-byte field contains the POSA scanned UPC (bar code data) on the card used to authorize the POSA prepaid transaction.
This field must appear in all POSA prepaid transactions
Added On: 05/27/13
SQL Column: BIT135
Java Field: bit135
Status: Active
SQL Type: varchar(1)
Java Type: String
POSA Stand-In indicator.
This one-byte field is used to indicate a POSA store and forward transaction request due to a merchant stand-in condition. Applicable to POSA activation and reload SAF transaction requests only. Use a value of “Y”, if the POS device has timed out or the host responds with response code “001” or “795” and load the POSA SAF reference number into field 136 of the request message. The POSA SAF Reference Number is returned in field 105.3 of every POSA response message, and should be retained for use in any SAF retransmission request.
When setting the POSA Stand-In indicator to “N”, the POSA SAF reference number must be initialized to spaces.
This field must appear in any POSA activation or reload SAF requests when the transaction is queued for re-transmission by the POS device.
Added On: 05/27/13
SQL Column: BIT136
Java Field: bit136
Status: Active
SQL Type: varchar(12)
Java Type: String
POSA SAF Reference Number.
This twelve-byte field contains a unique number generated by the host for each POSA prepaid transaction.
The host returns this value on every POSA prepaid transaction that is approved or declined (see field 105.3 – Transaction Identifier). In a Store-and-Forward scenario, where the transaction is queued for retransmission by the POS device this field contains the POSA SAF reference number of the original Activation/Reload transaction in the POSA prepaid request message. If a POSA device time out occurs no POSA SAF Reference Number is available then set the POSA SAF Reference Number to spaces and the POSA Stand-In Indicator (field 135) to a value of “Y”.
Added On: 05/27/13
SQL Column: BIT137
Java Field: bit137
Status: Active
SQL Type: varchar(9)
Java Type: String
Replacement Amount.
In a partial authorization reversal, the Replacement Amount reflects the corrected total amount of the authorization for the transaction. For a partial reversal, the Transaction Amount field must contain the original amount authorized. The host subtracts the Replacement Amount from the Transaction Amount to determine the amount being reversed. For timeout reversals, and for other cases where the original authorization is to be fully reversed, the replacement amount must be zero.
The replacement amount must not be equal to or greater than the transaction amount. Partial reversals are currently only supported for VISA and MasterCard payment types.
Added On: 05/27/13
SQL Column: BIT22
Java Field: bit22
Status: Active
SQL Type: varchar(3)
Java Type: String
Point-of-Service Entry Mode.
The three-digit POS entry mode field must appear in the following messages:
- 0100 Authorization request
- 0200 Financial request
- 0220 Financial request
Contains two subfields that indicate the method used to enter the primary account number (PAN) and whether the POS terminal allows entry of personal identification numbers (PINs).
Added On: 05/27/13
SQL Column: BIT25
Java Field: bit25
Status: Active
SQL Type: varchar(10)
Java Type: String
Point-of-Service Condition Code.
The ten-digit POS condition code field must appear in the following messages:
- 0100 Authorization request
- 0200 Financial request
- 0220 Financial request
- 0400 Unsolicited reversal request
Contains four subfields that, together, identify the kind of terminal and indicate whether the customer and/or the customer’s credit card were present at the time of the transaction.
Added On: 05/27/13
SQL Column: BIT32
Java Field: bit32
Status: Active
SQL Type: varchar(4)
Java Type: String
Acquiring Institution Identification Code.
This four-digit field must appear in the following message types:
- 0100 Authorization request
- 0200 Financial request
- 0220 Financial request
- 0400 Reversal request
- 0500 Reconciliation request
- 0800 Network management request
The code (referred to in the Tandem Online Systems as the Bank ID) identifies the acquiring institution (i.e., merchant bank, merchant grouping, or merchants’ hierarchy) for the associated Card Acceptor ID Code (the Tandem Online Systems Merchant Number).
Added On: 05/27/13
SQL Column: BIT37_RETRIEVAL_REFERENCE_NUMBER
Java Field: bit37RetrievalReferenceNumber
Status: Active
SQL Type: varchar(8)
Java Type: String
Retrieval Reference Number.
This eight-digit must appear in the following message types:
- 0110 Check auth response
- 0210 Financial response
- 0230 Financial response
- 0410 Reversal response
The retrieval reference number is used to identify and track the original transaction. The field is conditional; it is present in the message only when the Bit Map Type is not 99.
Added On: 05/27/13
SQL Column: BIT41
Java Field: bit41
Status: Active
SQL Type: varchar(4)
Java Type: String
Card Acceptor Terminal Identification.
The three-digit card acceptor terminal ID code (referred to as the Terminal ID in the Tandem Online System) identifies the terminal at the merchant (card acceptor) location at which the transaction was entered.
This field must appear in all transaction request messages.
Added On: 05/27/13
SQL Column: BIT42
Java Field: bit42
Status: Active
SQL Type: varchar(12)
Java Type: String
Card Acceptor Identification Code.
The 12-digit card acceptor ID code (referred to as the Merchant ID in the Tandem Online System) must appear in all transaction request messages. This field, in conjunction with the acquiring institution identification code (Field 32), uniquely identifies the merchant in the Tandem Online System.
Added On: 05/27/13
SQL Column: BIT43
Java Field: bit43
Status: Active
SQL Type: varchar(3)
Java Type: String
Lane Number.
This three-digit field appears in the following controller message types:
- 0100 Authorization request
- 0200 Financial request
- 0220 Financial request
- 0400 Reversal (void) request
It identifies the cashier location at which the transaction occurred.
Note: Of the 3 digit lane number only the right most two bytes are used. Lane numbers must be within the range of 01 to 99.
Added On: 05/27/13
SQL Column:
Java Field: bit45
Status: Active
SQL Type:
Java Type: String
Track Data.
Track data must appear in the following message types*:
- 0100 Authorization request
- 0200 Financial request
- 0220 Financial request
This field contains up to 76 alphanumeric, encrypted, or special characters of data read from track 1 or track 2 of the magnetic stripe on the card, excluding the beginning and end sentinels and the LRC character. Tandem Onlines recommends that the data be right justified, space filled. If the cardholder information (PAN and expiration date) is manually entered, the data must be right justified and space filled in the following format.
Refer to the specification of processor for more information.
Added On: 05/27/13
SQL Column:
Java Field: bit52
Status: Active
SQL Type:
Java Type: String
Personal Identification Number (PIN) Data.
This 16-character (64 binary bits) field may appear in the following message types:
- 0100 Authorization request
- 0200 Financial request
- 0220 Financial request
- 0400 Reversal request
The PIN data field uniquely identifies a cardholder at the POS terminal and is associated primarily with debit transactions. Each four-bit group in the field translates to a single hexadecimal character to yield a total of 16 ASCII display characters.
Can be spaces in 0400 reversal requests.
Added On: 11/19/14
SQL Column:
Java Field: bit55
Status: Active
SQL Type:
Java Type: String
Clerk Number.
This eight-digit field appears in all controller requests that represent in-lane transactions. It identifies the employee associated with the transaction. If not applicable, the field should be zero filled.
Added On: 05/27/13
SQL Column: BIT60
Java Field: bit60
Status: Active
SQL Type: varchar(9)
Java Type: String
Cash Back Amount.
This nine-digit field appears in the 0100 authorization and 0200 financial request messages. It represents the amount of money being given back to the cardholder. The entered amount can be up to seven digits; in the message it must be right-justified and padded with zeros to the full nine positions. This amount should not be included in the transaction amount field.
For AVS verification only (Processing code 514000) request, this field must be zero filled.
Added On: 05/27/13
SQL Column: BIT63
Java Field: bit63
Status: Active
SQL Type: varchar(26)
Java Type: String
Contains several fields:
Invoice/Folio Number.
This six-digit field appears in the 0200 and 0220 financial messages for those transactions (usually designated for specific card types) that use the extended prompts option. The field is required when settling American Express retail transactions. If the message also includes the P.O. Number/Customer Code field (bit 109), this field is ignored unless bit 109 is space-filled.
Item Code (from one to five)
These four-digit fields appear in the 0200 and 0220 financial messages for those transactions (usually designated for specific card types) that use the extended prompts option. These fields are used to cross reference a table in the Tandem Online Systems database that designates the type of merchandise purchased. Required when settling American Express retail transactions.
Added On: 05/27/13
SQL Column: BIT65
Java Field: bit65
Status: Active
SQL Type: varchar(6)
Java Type: String
Authorization Identification Response.
This six-character field appears in the following messages:
- 0110 Authorization response (controller)
- 0200 EBT voice authorization/voucher clear request
- 0220 Financial request (prior authorized sale transactions) (controller)
- 0210 Financial response (controller)
- 0230 Financial response (controller)
- 0410 Reversal response (controller)
The auth ID response contains an authorization number assigned to the transaction by the authorizing institution. In all host capture terminal messages but the EBT voice-auth request, this data is in bit 38.
Added On: 05/27/13
SQL Column: BIT65_AUTHORIZATION_IDENTIFICATION_RESPONSE
Java Field: bit65AuthorizationIdentificationResponse
Status: Active
SQL Type: varchar(6)
Java Type: String
Authorization Identification Response.
This six-character field appears in the following messages:
- 0110 Authorization response (controller)
- 0200 EBT voice authorization/voucher clear request
- 0220 Financial request (prior authorized sale transactions) (controller)
- 0210 Financial response (controller)
- 0230 Financial response (controller)
- 0410 Reversal response (controller)
The auth ID response contains an authorization number assigned to the transaction by the authorizing institution. In all host capture terminal messages but the EBT voice-auth request, this data is in bit 38.
Added On: 05/27/13
SQL Column: BIT67
Java Field: bit67
Status: Active
SQL Type: varchar(2)
Java Type: String
Extended Payment Code.
The two-digit extended payment code field appears in the 0200 and 0220 financial request message. It pertains specifically to JCB transactions where the consumer can specify the number of installment payments they wish to make for each purchase.
Added On: 05/27/13
SQL Column: BIT70
Java Field: bit70
Status: Active
SQL Type: varchar(3)
Java Type: String
Network Management Information Code.
All request message types support the following codes:
- 000 = Default (no key change required)
- 101 = Key change requested
- 900-999 = Log transaction as given error.
The Tandem Online System will record this transaction as an error transaction with the given code and the error server name as ‘SLHBAS’.
Full reversals support the following value:
400 = Suspected Fraud
In addition, message type 0800 supports the following values:
- 360 = Terminal validation
- 380 = FleetOne Batch Close
Added On: 06/07/13
SQL Column: BIT90
Java Field: bit90
Status: Active
SQL Type: varchar(9)
Java Type: String
Original Data Elements.
This eight-character field must appear in 0400 reversals and the nine-character field must appear in 0100 authorization reversal request messages. It contains the retrieval reference number from the original transaction response, and helps identify the original transaction for reversal processing.
For timeout reversals where the original transaction's retrieval reference number is not known, populate this field with zeroes.
Added On: 11/19/14
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/27/13
SQL Column: G009
Java Field: g009
Status: Active
SQL Type: varchar(27)
Java Type: String
Optional Processing Indicators.
It is a series of codes that identify terminal capability, terminal environment. Refer to the specification of the processor for more information.
Added On: 03/09/18
SQL Column: G012
Java Field: g012
Status: Active
SQL Type: varchar(15)
Java Type: String
Added On: 07/05/13
SQL Column: G001
Java Field: g001
Status: Active
SQL Type: varchar(28)
Java Type: String
Merchant Reference Data.
Used in settlement to uniquely identify a merchant’s transaction. The Merchant Reference Number can be present in any 0100, 0200, or 0220 authorization request transaction.
The Draft locator ID field is a unique value assigned by the POS device for each transaction.
The Merchant reference number should be a unique value assigned by the POS device for each transaction.
Added On: 05/27/13
SQL Column:
Java Field: g002
Status: Active
SQL Type:
Java Type: String
eCommerce Verified by VISA.
Used for eCommerce websites that support Verified by VISA (VBV) Internet payer authentication transactions. This group field can be present in any eCommerce VISA credit 0100, 0200, or 0220 authorization request transaction when VISA VBV authentication is desired. It will be ignored for all other authorization transaction requests.
Contains several fields. Each field must be 40 bytes in length. This group (G002) is not allowed in conjunction with G003. For field 03 Electronic Commerce Indicator valid values are 5, 6, 7, or 8. For a description see Bit 25 Pos Condition Code Position 4.
When present the host includes the data in the authorization request message to VISA. The response to the POS device will include an Electronic Commerce Indicator field that indicates the result of authentication.
Refer to the specification of the processor for more information.
Added On: 05/27/13
SQL Column:
Java Field: g003
Status: Active
SQL Type:
Java Type: String
eCommerce MasterCard SecureCode.
Used for eCommerce websites that support MasterCard SecureCode, Internet payer authentication. This group field can be present in any eCommerce MasterCard credit 0100, 0200, or 0220 authorization request transaction when MasterCard SecureCode is desired. It will be ignored for all other authorization transaction requests.
UCAF collection indicator must be one byte. If UCAF accountholder authentication value (AVV) is provided then the UCAF collection indicator must be a value of “2”. The host will ignore the UCAF AVV data if the UCAF collection indicator is a value of “0” or “1”.
Note: This group (G003) is not allowed in conjunction with G002.
When present the host includes the data in the authorization request message to MasterCard. The response to the POS device will include an Electronic Commerce Indicator field (one byte alphanumeric character), which indicates the result of authentication.
Added On: 05/05/16
SQL Column: G008
Java Field: g008
Status: Active
SQL Type: varchar(12)
Java Type: String
Value that identifies terminal capability, terminal environment, and point-of-interaction security data at the time a transaction occurred. The values differ by card type.
Added On: 06/10/16
SQL Column:
Java Field: g011
Status: Active
SQL Type:
Java Type: String
AMEX customer related data for swiped transactions that indicates whether the terminal will provide the CVV2/CID data, and what its value is.
Added On: 05/27/13
SQL Column: G014
Java Field: g014
Status: Active
SQL Type: varchar(9)
Java Type: String
Original Authorization Retrieval Reference Number.
Provides a way to send an original authorization retrieval reference number.
This field should be used when sending a 0220 force post. It should also be used with all full and partial reversals. This enables the Host to retrieve the original authorization information (if still available) to supplement settlement data.
Note: Must be numeric. Any invalid data will be ignored by the host.
Added On: 05/27/13
SQL Column: G015
Java Field: g015
Status: Active
SQL Type: varchar(120)
Java Type: String
Additional Amounts Request.
This 20-byte field contains information — up to six amount sets.
The presence of this group is mandatory and indicates to the host this is an IIAS transaction request.
The presence of G015 is optional in an EBT WIC authorization request transaction.
IIAS transaction request:
Amount type 4S must be present. The sum of the additional amount type fields must not exceed the total healthcare amount (4S). Any amount type can only appear once.
EBT WIC transaction request:
Only a single amount type 52 can be present in an EBT WIC authorization request transaction.
Refer to the specification of the processor for more information.
Added On: 05/05/16
SQL Column: G017
Java Field: g017
Status: Active
SQL Type: varchar(13)
Java Type: String
Specific Card information capture conditions that were present at the time a card transaction took place at the POS.
Added On: 09/26/13
SQL Column: G021
Java Field: g021
Status: Active
SQL Type: varchar(8)
Java Type: String
Fee Data.
Use this group to send convenience fee data. Please refer to card association regulations for details regarding fee usage.
Convenience fees can be sent in a single transaction (Fee Type = 1) or in two transactions (Fee Types 2 and 3).
For a single convenience fee transaction (Fee Type 1):
put the fee in the Fee Amount field of this group and also include it with the Transaction Amount.
For a two-step convenience fee transaction:
1. The first transaction must have Fee Type = 2 and Fee Amount = zero.
2. The second transaction must have Fee Type = 3 and both Transaction Amount and Fee Amount containing the convenience fee.
VISA CPS/Debit tax fees must be sent in a two-step transaction (Fee Types 2 and 3).
For a two-step VISA CPS/Debit tax transaction convenience fee transaction:
1. The first transaction must have Fee Type = 2 and Fee Amount = zero.
2. The second transaction must have Fee Type = 3 and both Transaction Amount and Fee Amount containing the convenience fee.
VISA limits the convenience fee amount for CPS/Debit Tax fee payment transactions, it is recommended to verify the fee limits and other terms during the merchant registration process.
Added On: 05/27/13
SQL Column: G023
Java Field: g023
Status: Active
SQL Type: varchar(9)
Java Type: String
Restaurant Tip Amount.
Used in conjunction with a sale or adjustment message to log the tip amount received. The cents portion is the last two positions, and the decimal point is implied.
Must be numeric. Invalid data will result in a declined transaction. This group is ignored if the merchant is not configured on the host as Restaurant industry.
Added On: 11/26/14
SQL Column: G034
Java Field: g034
Status: Active
SQL Type: varchar(82)
Java Type: String
POS Identification Data.
These fields provide identification data for POS applications and associated devices. It is required for applications using EMV chip card technology, and will ultimately be required for all 610 applications in the future.
Added On: 06/10/16
SQL Column:
Java Field: g035
Status: Active
SQL Type:
Java Type: String
Tag data included for all chip card transactions. EMV chip card data determined by the POS application and chip card involved in the transaction.
Added On: 06/10/16
SQL Column:
Java Field: g036
Status: Active
SQL Type:
Java Type: String
Credit card PIN data used for standard magnetic stripe swiped transactions and EMV online PIN verification transactions.
Added On: 11/02/16
SQL Column: G048
Java Field: g048
Status: Active
SQL Type: varchar(10)
Java Type: String
Additional request information that can contain multiple tags in any order with different information.
Added On: 05/27/13
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: 06/04/13
SQL Column: IS_DEBIT_TRANSACTION
Java Field: isDebitTransaction
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Attributes:
Default:false
Indicates whether the processed transaction is debit type.
Added On: 10/30/13
SQL Column: IS_REVERSAL_APPLIED
Java Field: isReversalApplied
Status: Active
SQL Type: tinyint(1)
Java Type: Boolean
Attributes:
Default:false
Indicates whether the original transactions was already reversed.
Added On: 05/27/13
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/27/13
SQL Column: MESSAGE_TYPE_IDENTIFIER
Java Field: messageTypeIdentifier
Status: Active
SQL Type: varchar(4)
Java Type: String
Appears in every message type supported by the Tandem Online Systems host capture message set.
The first two digits identify the class of the message (authorization, financial, reversal, and so on); the last two digits represent the message function (request or response).
Added On: 05/27/13
SQL Column: NETWORK_ROUTING
Java Field: networkRouting
Status: Active
SQL Type: varchar(6)
Java Type: String
Сan be used to route the transaction through the front-end communications network (for example, CompuServe’s Routing Identifier – CRI). It appears in all messages, but is ignored by the Tandem Online System.
Added On: 05/27/13
SQL Column: R001
Java Field: r001
Status: Active
SQL Type: varchar(1)
Java Type: String
eCommerce VISA Authentication Result.
Used to indicate the result of an eCommerce VISA transaction that requested authentication. This response is only applicable to VISA transactions when G002 is sent in the request message.
Notes:
Non-U.S. acquired transactions that occur on cards issued in the U.S. region can receive a CAVV result code values of 7,8,9, or A.
V.I.P. will reject a transaction with Reject Reason Code 0193 (invalid value) when an issuer returns the response message with the value C or D.
Added On: 05/27/13
SQL Column: R006
Java Field: r006
Status: Active
SQL Type: varchar(2)
Java Type: String
Card-Level Results.
The field contains a two-character code created by Visa during the authorization process. Refer to the specification of processor for more information.
Added On: 05/27/13
SQL Column: R007
Java Field: r007
Status: Active
SQL Type: varchar(80)
Java Type: String
Additional Amounts.
This 20-byte field contains information — up to four amount sets. This group is returned when the transaction has been partially approved and on balance inquiries. Refer to the specification of processor for more information.
Added On: 05/27/13
SQL Column: R008
Java Field: r008
Status: Active
SQL Type: varchar(9)
Java Type: String
Original Authorization Retrieval Reference Number.
This group is used to respond with the retrieval reference number of the authorization transaction. To request this group to be returned the sixth byte of G009 (Optional Processing Indicators) on authorization request has to be set to “Y”.
Added On: 07/15/13
SQL Column: R009
Java Field: r009
Status: Active
SQL Type: varchar(15)
Java Type: String
AMEX Transaction Identifier/Discover Network Reference ID.
Used to pass the AMEX Transaction Identifier/Discover Network Reference ID. This response group is returned on approvals or declines when G009 position 4 in request is set to "Y" and the American Express transaction was sent to American Express for authorization, or when G009 position 9 in request is set to "Y" and the Discover transaction was sent to Discover for authorization.
Added On: 11/26/14
SQL Column: R023
Java Field: r023
Status: Active
SQL Type: varchar(999)
Java Type: String
EMV Response Data.
EMV tag data format is BER-TLV as defined in ISO/IEC 8825. The tag data is Base64 encoded.
This group contains the Base64 response data returned by the issuer or networks for EMV chip card transactions. The POS device must be prepared to receive this group even on declines.
Note: Since the 600 and 610 message formats do not allow for the presence of binary data, the POS device must convert the ASCII Base64 data back to binary tag data for TLV decoding.
Added On: 11/26/14
SQL Column: R025
Java Field: r025
Status: Active
SQL Type: varchar(3)
Java Type: String
MasterCard Additional Processing Information for Chip Transactions.
MasterCard DE 48, subelement 74 (Additional Processing Information) provides additional information about chip transaction processing and results. Terminal applications may receive R025 if issuers performing chip cryptogram validation return their validation results.
Terminal applications request this group by setting G009 position 18 to “Y” in the transaction request.
Refer to the MasterCard Customer Interface Specification, section "DE 48 - Additional Data - Private Use, Subelement 74 - Additional Processing Information" for complete details and current list of valid values.
Added On: 11/26/14
SQL Column: R026
Java Field: r026
Status: Active
SQL Type: varchar(1)
Java Type: String
Visa Spend Qualified Indicator.
Indicates if the account has met its’ spend qualification threshold.
Refer to the Visa Base I Technical Specifications, Volume 1, section "Field 62.25 – Spend Qualified Indicator" for complete details and the current list of valid values.
Added On: 11/26/14
SQL Column: R027
Java Field: r027
Status: Active
SQL Type: varchar(1)
Java Type: String
Pinless Debit Indicator.
This response field indicates that the transaction was processed as a pinless debit transaction.
This flag will be returned only if the transaction processed as pinless debit. The terminal does not need to send any information in the request to receive this response field. The merchant record must have the MERC PINLESS Eligible flag set to Y and the IBM must have processed the transaction as pinless debit rather than credit. If this response field is returned it will always contain a Y, if the response field is not present it indicates the transaction was processed as it was originally sent and not flipped to debit.
Added On: 05/27/13
SQL Column: R999
Java Field: r999
Status: Active
SQL Type: varchar(26)
Java Type: String
Error Group Data Response.
This group response is applicable to any transaction that sends group data in a request message and is determined by the host that it is invalid.
Note: A value of “00” in the group field indicates group level error no specific field.
Used to indicate any errors found by the host when processing authorization requests that contain any optional group data. Refer to the specification of processor for more information.
Added On: 05/27/13
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: 06/10/16
SQL Column:
Java Field: serviceCode
Status: Active
SQL Type:
Java Type: String
Specific identifier associated by a processor.
Added On: 04/12/19
SQL Column: TRANSACTION_IDENTITY
Java Field: transactionIdentity
Status: Active
SQL Type: varchar(25)
Java Type: String
|