FirstData Nashville Token Transaction UML


Added On:  12/21/15 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataNashvilleTokenTransaction 
Represents tokenization transaction as it is defined in FirstData Nashville's tokenization specification.
Added On:  12/21/15
SQL Column:  
Java Field:  applicationId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identification number of the application used.
Added On:  06/10/16
SQL Column:  
Java Field:  bit35
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  06/10/16
SQL Column:  
Java Field:  bit45
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  12/21/15
SQL Column:  BIT11
Java Field:  bit11
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
A system-generated number provided by the merchant, the System Trace Number uniquely identifies a transaction.
Added On:  12/21/15
SQL Column:  BIT12_RESPONSE
Java Field:  bit12Response
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Time, Local Transmission response.

For Point-of-Service (POS) terminals sending credit card transactions identifies the hour, minute and second a transaction is sent. If submitted, it must be POS terminal time and match the printed receipt.

It is always recommended that merchants must submit relevant Time, Local Transmission (Bitmap 12) value for Amex and Discover (JCB (US Domestic only), and Diners) transactions. However, if Bitmap 12 is not populated, First Data will submit Eastern Time (ET) as the time for local transmission. It should be however, taken into consideration that not all merchants are based out of East Coast of United States.

This is the time stamp of the transaction, and as a Regulation E requirement it should be printed on the Debit Receipt given to a customer. It does not change on subsequent transactions (i.e., on debit reversals).

For any merchant sending Debit/EBT card transactions, this field must be sent with the request. It is assigned by the terminal.

On 0400 (Debit/EBT) reversal message the time of the transaction must match the Transmission Date/Time in the original 0200 (Debit/EBT) request.
Added On:  12/21/15
SQL Column:  
Java Field:  bit2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Primary Account Number.

This field identifies the card member‘s account number. Unlike most numeric fields, the Primary Account Number is left-justified. In this case, the rightmost byte is padded with a ½ byte binary zero (e.g., a three-position field, X ‘03 12 30‘).

Not included for check transactions message.
In the 0200 Financial Transaction messages for EBT Card, this field is mandatory if the Track 2 Data cannot be read.
Added On:  12/21/15
SQL Column:  BIT3
Java Field:  bit3
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Processing Code.

A required code is used in conjunction with the message type to define the type of transaction that is by the terminal to the host.
Added On:  12/21/15
SQL Column:  BIT37
Java Field:  bit37
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
Retrieval Reference Number.

Authorization only — For Credit and debit transactions (excluding Canadian Debit) the retrieval reference number can be any value based on the merchant‘s choosing (e.g. sequential tracking of transactions, fixed value etc.). The value submitted in the request message is then echoed back in response. For example the value of 000000000001 for all transactions can be used. If the merchant leaves the retrieval reference number blank in the request, First Data will assign a unique 12-byte retrieval reference number and the assigned value will be returned in the response.
Authorization with capture — For Credit and debit transactions (excluding Canadian Debit), this is a unique 12-byte reference number assigned to a transaction by the merchant and returned in the response message. The retrieval reference number should increment from …..001 to ….999 and should not be reset on a daily basis until it reaches ….999.
Capture Only – For Credit card transactions the retrieval reference number must be the same value that was submitted in the original authorization request.
Canadian Debit — The POS terminal at the merchant‘s location generates the retrieval reference number and includes it in the transaction request. The host echoes the value back in the response. The terminal must ensure that the number is unique.
Reversals — In a 0400 (Debit/Credit) reversal request message, the retrieval reference number does not have to match the original 0100 (Credit) and 0200 (Debit) request. This is applicable to all transaction type (Credit, Debit inclusive of Canadian Debit). For Host Draft Capture, RRN submitted at the time of authorization should match the RRN submitted in the reversal for Auth and Capture transactions.
Added On:  12/21/15
SQL Column:  BIT41
Java Field:  bit41
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Terminal ID.

Contains a code that identifies a merchant terminal. A unique code must be assigned to each terminal/POS device (e.g., a register) in a merchant location. This code will be returned on the host response. In certain instances, the Terminal ID may be assigned by the merchant; in other instances, First Data assigns it. Please check with your First Data representative for details.

The Terminal ID does not conform to the standard definition of alphanumeric fields: it is right justified and zero-filled on the left.
On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  12/21/15
SQL Column:  BIT42
Java Field:  bit42
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Merchant ID number.

Contains a code assigned to a merchant location. Merchants must use the First Data-assigned Merchant ID (see note below). The Merchant ID does not conform to the standard definition of alphanumeric fields: it is right-justified and zero-filled on the left.

On a 0100 VRU Authorization only (page 2-10), the Merchant ID can be the First Data internal number or a merchant external number.
On a 0400 reversal message, this field must match the original 0100/0200 request.
Added On:  12/21/15
SQL Column:  BIT63
Java Field:  bit63
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes: Transient
Used for both Balance Information and Partial Auth transactions in VISA, MasterCard, Amex, Discover (Diners, JCB US Domestic), and Debit. These features are supported only for Pre-Paid Gift, FSA, HRA Accounts.
Added On:  12/21/15
SQL Column:  BIT7
Java Field:  bit7
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Transmission Date/Time.

This code identifies the month, day, hour, minute, and second a transaction is sent (MMDDhhmmss). This must be represented in GMT or Universal time.
Added On:  12/21/15
SQL Column:  BIT70
Java Field:  bit70
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Network Management Information Code.

Indicates the function of a particular 0800 Test Message.
Added On:  12/21/15
SQL Column:  CLIENT_REF
Java Field:  clientRef
Status:  Active
SQL Type:  varchar(14)
Java Type:  String
Attributes:
Reference to the client.
Added On:  12/21/15
SQL Column:  
Java Field:  datawireId
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identification number of the datawire.
Added On:  12/21/15
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly, ReadOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  12/21/15
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  12/21/15
SQL Column:  MESSAGE_TYPE
Java Field:  messageType
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
A code that defines the message type. The message types and their associated codes are as follows:

  • Authorization Messages
  • 0100 Authorization Request
    0110 Authorization Request Response

  • Financial Transaction Messages (Debit only)
  • 0200 Authorization/Financial Transaction Request
    0210 Authorization/Financial Transaction Request Response

  • Reversal Messages
  • 0400 Reversal Request
    0410 Reversal Request Response

  • Network Management Messages
  • 0800 Network Management Request
    0810 Network Management Request Response
    Added On:  12/21/15
    SQL Column:  PROVIDER_ID
    Java Field:  providerId
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    Identification number of the provider.
    Added On:  12/21/15
    SQL Column:  RESPONSE_TEXT
    Java Field:  responseText
    Status:  Active
    SQL Type:  varchar(16)
    Java Type:  String
    Attributes:
    Getaway generated response message.
    Added On:  12/21/15
    SQL Column:  
    Java Field:  serviceId
    Status:  Active
    SQL Type:  
    Java Type:  String
    Attributes: Transient
    Identification number of the service.
    Added On:  12/21/15
    SQL Column:  
    Java Field:  tokenCode
    Status:  Active
    SQL Type:  
    Java Type:  String
    Attributes: Transient
    Token code of the transaction.
    Added On:  12/21/15
    SQL Column:  TOKEN_TRANSACTION_FK
    Java Field:  tokenTransaction
    Status:  Active
    SQL Type:  bigint(20)
    Java Type:  Long
    References Token Transaction
    Attributes:
    Reference to the entity that represents the initial token transaction information.
    Added On:  12/21/15
    SQL Column:  
    Java Field:  urls
    Status:  Active
    SQL Type:  
    Java Type:  String
    Attributes: Transient
    URL adresses.

    For example, E-commerce URL address.