Zip and Country Codes
Development
Reference Materials
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
Identification number of the application used.
Added On: 06/10/16
SQL Column:
Java Field: bit35
Status: Active
SQL Type:
Java Type: String
Added On: 06/10/16
SQL Column:
Java Field: bit45
Status: Active
SQL Type:
Java Type: String
Added On: 12/21/15
SQL Column: BIT11
Java Field: bit11
Status: Active
SQL Type: varchar(6)
Java Type: String
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
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
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
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
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
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
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
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
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
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
Added On: 12/21/15
SQL Column:
Java Field: datawireId
Status: Active
SQL Type:
Java Type: String
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
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
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
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
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
Getaway generated response message.
Added On: 12/21/15
SQL Column:
Java Field: serviceId
Status: Active
SQL Type:
Java Type: String
Identification number of the service.
Added On: 12/21/15
SQL Column:
Java Field: tokenCode
Status: Active
SQL Type:
Java Type: String
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
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
URL adresses.
For example, E-commerce URL address.
|