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.
 |