FirstData Nashville Capture Retail Transaction                                                    UML
                                
         
     
    
    
    
    
        
            Added On:  11/05/12 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  FirstDataNashvilleCaptureRetailTransaction 
                    
        
        
     
    
        
            
                
                    FirstData Nashville specific low-level representation of Retail Transaction produced by 
Forward Transformation Process within 
Settlement Process.
During 
Generation Process, FirstData Nashville specific interchange message is generated from this object for settlement. Consequently, all fields of the object are mapped into message segments/elements.
                
 
         
     
        
        
                    
                        
                Added On:  11/05/12
                SQL Column:  ACI
                Java Field:  aci
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Authorization Characteristics Indicator.
This field indicates the result of the Visa's evaluation of the authorization characteristics of a custom payment service transaction.                        
                     
                 
             
                    
                        
                Added On:  01/02/13
                SQL Column:  ACKNOWLEDGMENT_CODE
                Java Field:  acknowledgmentCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Four (4) digit ACCEPT/HELD/REJECT Reason Code, that indicates whether FDMS accepted, held, or rejected the transaction or submission. This field is found on the Detail Acknowledgment and General Acknowledgment records.
Zeroes (signed) – the Debit/EBT acknowledgement records are a ‗receipt‘ that the records were received, not an indication if they were successfully processed through the debit system.
                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  ADJUSTED_AMOUNT
                Java Field:  adjustedAmount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Adjusted amount of the transaction.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  ADJUSTED_AMOUNT_INDICATOR
                Java Field:  adjustedAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicator of the adjusted amount.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  APPLICATION_CRYPTOGRAM
                Java Field:  applicationCryptogram
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This cryptogram value is returned by the Chip (ICC) in response to a “Generate AC” command. This value indicates the type of cryptogram and the actions to be performed by the terminal.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  APPLICATION_EXPIRATION_DATE
                Java Field:  applicationExpirationDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the date after which the application expires.                         
                     
                 
             
                    
                        
                Added On:  06/14/16
                SQL Column:  APPLICATION_INTERCHANGE_PROFILE
                Java Field:  applicationInterchangeProfile
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the capabilities of the card to support specific functions within the application.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  APPLICATION_TRANSACTION_COUNTER
                Java Field:  applicationTransactionCounter
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This is an incrementing counter value that is managed by the application in the chip card.                         
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  ARRIVAL_DATE
                Java Field:  arrivalDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space filled; Reserved for future use.
Cardholder check-in date in the form MMDDYY. 
(Required for Reduced Interchange).                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  AUTH_AMOUNT
                Java Field:  authAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This record provides market-specific data elements for the Direct Marketing, Car Rental, Lodging, Purchase card (MC-Visa), Business to Business Industries, and Visa Bill payment, Visa Healthcare IIAS.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  AUTH_RESPONSE_CODE
                Java Field:  authResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Alphanumeric value assigned by the bank to a merchant sale or cash advance that has received specific approval. The code is used as proof that the transaction has been properly approved. 
Response to the request message.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  AUTHORIZATION_CODE
                Java Field:  authorizationCode
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Mandatory for Capture only (Bit 31, value of 2) transactions.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  AUTHORIZATION_DATE
                Java Field:  authorizationDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/06/15
                SQL Column:  AUTHORIZATION_RESPONSE_CODE
                Java Field:  authorizationResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is generated by the authorization authority for an approved transaction.                         
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  AUTHORIZATION_SOURCE
                Java Field:  authorizationSource
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  AVS_RESPONSE
                Java Field:  avsResponse
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Address Verification Response.
AVS response from auth — mandatory for Capture only (Bit 31, value of 2) transactions.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  BANK_NET_DATE
                Java Field:  bankNetDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space-fill in the 0100 original authorization request message. The value received in the 0110 original authorization response, must be submitted in the 0100 incremental request & 0400 reversal message and capture only transaction request message. The Issuer will respond with the 4-byte BankNET Date (MMDD).                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  BANK_NET_REFERENCE_ID
                Java Field:  bankNetReferenceId
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space-fill in the 0100 original authorization request message. The value received in the 0110 original authorization response, must be submitted in the 0100 incremental request & 0400 reversal message and capture only transaction request message. The Issuer will respond with the 9-byte BankNET Reference.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  BILLING_ADJUSTMENT_AMOUNT
                Java Field:  billingAdjustmentAmount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of charges added after departure. Must be greater than zero is field 8 is 'Y'. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  BILLING_ADJUSTMENT_INDICATOR
                Java Field:  billingAdjustmentIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Tells whether additional charges were added after departure.
" " - No additional charges added.
"Y" - Additional charges added.                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  CAR_RENTAL_AGREEMENT_NUMBER
                Java Field:  carRentalAgreementNumber
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Car rental agreement number.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  
                Java Field:  cardExpirationDate
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        The expiration date of the card. (MMYY)                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  CARD_SEQUENCE_NUMBER
                Java Field:  cardSequenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Card Sequence Number is a number used to differentiate cards that have the same primary account number (PAN). 
Field 023 contains the Card Sequence Number in the range '000' to '099', right justified and left-padded with zeros. It is only used for transactions containing ICC System Data. For transactions containing ICC Data, the Card Sequence Number is mandated when the card product includes the Card Sequence Number in the criteria for uniquely defining a card. In this case, Field 023 must contain the Application PAN Sequence number (ICC tag 5F34), if present on the ICC. If ICC Tag 5F34 is not available (is not supplied by the card), Field 023 must be omitted.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  
                Java Field:  cardholderAccountNumber
             
            
                Status:  Active
                SQL Type:  varchar
                Java Type:  String
             
            
            
            
                
                    
                        
                        Credit card or bank account number of the cardholder.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CARDHOLDER_ACTIVATED_TERMINAL
                Java Field:  cardholderActivatedTerminal
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CARDHOLDER_ID
                Java Field:  cardholderId
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        First Data-assigned code that identifies the cardholder's location.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  CARDHOLDER_VERIFICATION_METHOD_RESULTS
                Java Field:  cardholderVerificationMethodResults
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the results of the last CVM preformed.                         
                     
                 
             
                    
                        
                Added On:  12/16/12
                SQL Column:  CASH_BACK_AMOUNT
                Java Field:  cashBackAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field contains amounts associated with the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                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:  04/06/15
                SQL Column:  CHIP_CONDITION_CODE
                Java Field:  chipConditionCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code that explains current chip condition.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CLEARING_COUNT
                Java Field:  clearingCount
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The total number of installments within an installment payment plan. This field is found on the Special Condition Record.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CLEARING_SEQUENCE
                Java Field:  clearingSequence
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The number of a given installment within an installment payment plan. This field is found on the Special Condition (S) Record.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  CRYPTOGRAM_AMOUNT
                Java Field:  cryptogramAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the amount of cryptogram and the actions to be performed by the terminal.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  CRYPTOGRAM_INFORMATION_DATA
                Java Field:  cryptogramInformationData
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the type of cryptogram and the actions to be performed by the terminal.                         
                     
                 
             
                    
                        
                Added On:  12/11/12
                SQL Column:  CUSTOMER_CODE
                Java Field:  customerCode
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For Visa the Customer Code/Customer Reference Identifier — Used by the customer to identify the purchase (e.g., the invoice number). 
For Visa this field must be 12 digits. 
For MasterCard and American Express the code that facilitates merchant/corporation communication and record keeping. 
For MasterCard this field must be 17 digits. 
For MasterCard Electronic Payment Transactions this value should represent the Invoice Number. 
Refer to Conditional Requirement Matrix for further detail.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CUSTOMER_SERVICE_NUMBER
                Java Field:  customerServiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/12/13
                SQL Column:  CUSTOMER_SERVICE800_NUMBER
                Java Field:  customerService800Number
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Customer service telephone number to be used to resolve questions or disputes. 
(Required for Reduced Interchange).                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CVC_ERROR
                Java Field:  cvcError
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space-fill in authorization request message.
CVC Incorrect Indicator. An indicator, provided by the Issuer in the authorization response, to identify the presence of an invalid card verification code (CVC). If there is an error, the Issuer will respond with the 1-byte CVC Error Code (Y).                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  CVV2_RESULT_CODE
                Java Field:  cvv2ResultCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The result code of CVV2 verification.
For DirectSolutions merchants (Tran code '8') this field would contain the CVV2 value.
                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  DAILY_RENTAL_RATE
                Java Field:  dailyRentalRate
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total rent amount per day.                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  DE22_DATA
                Java Field:  de22Data
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This record is submitted for MasterCard‘s DE22 program. It is required for merchants who can receive DE22 with their authorization. This record is optional for merchants who do not have the capability to receive DE22 with their authorization response.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  DEDICATED_FILE_NAME
                Java Field:  dedicatedFileName
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/12/13
                SQL Column:  DEPARTURE_DATE
                Java Field:  departureDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space filled; Reserved for future use.
Cardholder check-out date in the form MMDDYY. 
(Required for Reduced Interchange).                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  DESTINATION_COUNTRY
                Java Field:  destinationCountry
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The ISO assigned code of the country to which goods were shipped.
Optional for Visa and MasterCard. Not applicable for American Express.                         
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  DESTINATION_ZIP
                Java Field:  destinationZip
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The postal or ZIP code of the ―ship to‖ location. This is equal to the Ship from Postal/ZIP Code when the customer takes possession of the items at the merchant location.
Optional for Visa and MasterCard. Mandatory for American Express.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  DISCOUNT_AMOUNT
                Java Field:  discountAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of discount applied to the transaction by the merchant. Used by the merchant when a discount is given on the entire transaction rather than on unit prices. Typically shown as credit on a detailed invoice. Two (2) decimal places are implied.
Optional for Visa only. Not applicable for MasterCard or American Express.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  DISCOUNT_AMOUNT_INDICATOR
                Java Field:  discountAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of discount applied to the transaction by the merchant. Used by the merchant when a discount is given on the entire transaction rather than on unit prices. Typically shown as credit on a detailed invoice. Two (2) decimal places are implied.
Optional for Visa only. Not applicable for MasterCard or American Express.                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  DS_POS_DATA
                Java Field:  dsPosData
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Card Information Captured at the time of transaction.                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  DS_POS_ENTRY_MODE
                Java Field:  dsPosEntryMode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Consists of 2 byte PAN Entry mode and 1 byte PIN entry capability of the POS device.                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  DS_PROCESSING_CODE
                Java Field:  dsProcessingCode
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This code describes the effect of a Card Transaction on the Card Account. It must be the same as identified in the Authorization Request.
Note: If the Supplemental Discover (JCB (US Domestic only), and Diners) Cash Over XV06 Record is supplied, the first two bytes of Processing Code must be "09"                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  DS_STAN
                Java Field:  dsStan
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        System trace audit number (STAN).                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  DS_TRACK_DATA_CONDITION_CODE
                Java Field:  dsTrackDataConditionCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Card Track Data Submitted at the Time of Auth. (See page 9-84 for the expected values for this field)                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  DUTY_AMOUNT
                Java Field:  dutyAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total charges for any import/export duties included in the transaction. Two (2) decimal places are implied.
Optional for Visa and MasterCard. Not applicable for American Express.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  DUTY_AMOUNT_INDICATOR
                Java Field:  dutyAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicator used to reflect duty charged on sale.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  EC_SECURITY_LEVEL
                Java Field:  ecSecurityLevel
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Electronic Commerce Security Level.
Must be present if E record Cat indicator = 6                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  EMV_RECORD_TYPE
                Java Field:  emvRecordType
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/05/12
                SQL Column:  ENTRY_MODE
                Java Field:  entryMode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The POS Entry Mode provided to Discover (JCB (US Domestic only), and Diners) for the authorization
Bytes 1-2: Discover (JCB (US Domestic only), and Diners) POS Entry Mode
Byte 3: Discover (JCB (US Domestic only), and Diners) Pin Entry Capability
Byte 4: RFU (Always zero)
Note: Only the first 3 bytes are required for settlement processing                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH_FK
                Java Field:  firstDataNashvilleRetailFileBatch
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents a group of FirstData Nashville Capture Retail Transaction objects that are settled together as a group within a single file. 
During Generation Process, FirstData Nashville Retail File Batch is converted into a settlement file, which is then registered into File Store for further processing.                         
                     
                 
             
                    
                        
                Added On:  07/05/16
                SQL Column:  FIRST_DATA_NASHVILLE_RETAIL_ITEM_FK
                Java Field:  firstDataNashvilleRetailItems
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that reprents the list of FirstData Nashville retail items.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  FOLIO_NUMBER
                Java Field:  folioNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space filled; Reserved for future use.
Folio number assigned. 
(Required for Reduced Interchange). 
Must be left justified, and cannot contain all spaces or all zeroes.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  FREIGHT_AMOUNT
                Java Field:  freightAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total for freight or shipping and handling charges. Two decimal places are implied.
Optional for Visa and MasterCard. Not applicable for American Express.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  FREIGHT_AMOUNT_INDICATOR
                Java Field:  freightAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicator used to reflect if Freight amount is included.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  GIFT_SHOP_CHARGES
                Java Field:  giftShopCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        9(7) V99 Total amount of gift shop expenses. (Optional) Assume two decimal places for U.S. dollars. Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                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/02/12
                SQL Column:  INITIAL_AUTH_AMOUNT
                Java Field:  initialAuthAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field, which is required for Visa CPS transactions (tran code 5), must contain the amount indicated in the initial authorization request message. This field does not contain a fixed decimal location, since this is determined by the authorization currency code.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  INSURANCE_CHARGES
                Java Field:  insuranceCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The list of insurance charges amounts.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  INSURANCE_INDICATOR
                Java Field:  insuranceIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/06/15
                SQL Column:  ISSUER_APPLICATION_DATA1
                Java Field:  issuerApplicationData1
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to send proprietary application data to the issuer in an online transaction.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  ISSUER_APPLICATION_DATA2
                Java Field:  issuerApplicationData2
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to send proprietary application data to the issuer in an online transaction.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  ISSUER_AUTHENTICATION_DATA
                Java Field:  issuerAuthenticationData
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value contains data sent to the chip card for online issuer authentication.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  ISSUER_SCRIPT1_RESULTS
                Java Field:  issuerScript1Results
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to identify the results of the terminal script processing.                         
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LAUNDRY_AMOUNT
                Java Field:  laundryAmount
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of laundry and dry cleaning expenses. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  LOCAL_TAX_AMOUNT
                Java Field:  localTaxAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For Visa the amount of state or provincial tax included in the transaction amount. The tax amount must be within 0.1 % and 22% of the transaction amount. Two (2) decimal places are implied and size can be 12 bytes. 
For MasterCard the total amount of sales tax or VAT on the total purchase must be between 0.1% and 30 % of the total transaction amount; zeroes indicate that the card acceptor is capable of transmitting the tax amount and the tax amount is zero. Right justified and zero filled. Two (2) decimal places are implied and size can be 9 bytes maximum. 
For American Express the amount of tax calculated or entered for the transaction. Two (2) decimal places are implied and size can be 12 bytes. **Refer to Conditional Requirement Matrix for further detail.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  LOCAL_TAX_INDICATOR
                Java Field:  localTaxIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Mandatory for Visa and MasterCard.
For MasterCard — an indicator used to reflect sales tax capture and reporting.                        
                     
                 
             
                    
                        
                Added On:  12/02/12
                SQL Column:  LOCAL_TRANSACTION_TIME
                Java Field:  localTransactionTime
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant‘s local time when the transaction originated. Format HHMMSS. The time sent in this field should match the local time sent in the Authorization Request.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_ARRIVAL_DATE
                Java Field:  lodgingArrivalDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        MMDDYY (Gregorian) date of arrival.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_CHARGE_TYPE
                Java Field:  lodgingChargeType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This record supply the lodging information, required by American Express, for processing American Express transactions. There must be one "AL1" Record for every Detail Record representing an American Express lodging transaction.
1 - Lodging
2 - Restaurant
3 - Gift Shop
Note: Must be "1" for Econo-Lodging.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_DEPARTURE_DATE
                Java Field:  lodgingDepartureDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        MMDDYY (Gregorian) date of departure.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_DURATION_STAY
                Java Field:  lodgingDurationStay
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Optional - 2 digit field indicating the duration of stay.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_ROOM_RATE
                Java Field:  lodgingRoomRate
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        9(3) V99 Optional - 5 digit field indicating the room rate of the last night of stay. If room rate is greater than 999.99 then zero fill this field.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  LODGING_SPECIAL_PROGRAM
                Java Field:  lodgingSpecialProgram
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This record supply the lodging information, required by American Express, for processing American Express transactions. 
1 - If Lodging Charge Type field = 2 or 3, or Lodging Charge Type 1 and none of the other codes below apply.
2 - ASSURED RESERVATION - NO SHOW - If a customer fails to utilize a room, and the reservation is guaranteed, the customer is billed for one night of stay.
3 - CARDeposit - Procedure to bill a customer's advance deposit on their charge card.
Removed options 4 (delayed charge, 5- Express service, and 6- assured reservation (03-2007).                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MAGNETIC_STRIPE_STATUS
                Java Field:  magneticStripeStatus
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MARKET_SPECIFIC_AUTH_INDICATOR
                Java Field:  marketSpecificAuthIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This entry is used to indicate that market-specific authorization data was present in the authorization request to Visa‘s VIP system.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MARKET_SPECIFIC_DATE
                Java Field:  marketSpecificDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Market Specific Date Indicator.
                        
                     
                 
             
                    
                        
                Added On:  12/11/12
                SQL Column:  MASTER_CARD_TRANSACTION_CATEGORY_INDICATOR
                Java Field:  masterCardTransactionCategoryIndicator
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        03 = Healthcare expenses were substantiated real time against an Inventory Information Approval System (IIAS) during authorization.
                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  MAXIMUM_FREE_MILES
                Java Field:  maximumFreeMiles
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total mileage for the rent period.                        
                     
                 
             
                    
                        
                Added On:  11/05/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/05/12
                SQL Column:  MERCHANT_CATEGORY_CODE
                Java Field:  merchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code that identifies the type of business or services conducted by the service establishment. Also known as Merchant Category Code (MCC). It is used in the warning bulletin, authorization and settlement systems to identify the type of merchant (formerly SIC).
On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MERCHANT_PURCHASE_REFERENCE_IDENTIFIER
                Java Field:  merchantPurchaseReferenceIdentifier
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For Visa the Customer - used by the customer to identify the purchase (e.g., the invoice number). 
For Visa this field must be 12 digits. 
For MasterCard and American Express the code that facilitates merchant/corporation communication and record keeping. 
For MasterCard this field must be 17 digits. 
For MasterCard Electronic Payment Transactions this value should represent the Invoice Number. 
Refer to Conditional Requirement Matrix for further detail.                        
                     
                 
             
                    
                        
                Added On:  11/26/14
                SQL Column:  MERCHANT_TAX_ID
                Java Field:  merchantTaxId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Mandatory for MasterCard. Not applicable for Visa or American Express. The merchant‘s federal tax identification number.                         
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MERCHANT_ZIP
                Java Field:  merchantZip
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The merchant‗s postal/ZIP code must be left-justify and filled if less than 9 bytes.
This field is left justified, with trailing spaces.
Note: 
For US (United States): Left-justify and zero-fill.
For Non-US: Left-justify and space-fill.
Addresses may vary in length and can include alphanumeric character content. Some addresses do not contain postal codes. In this case, the ZIP code must be space filled.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  MERCHANT_ZIP_PURCHASE_CARD
                Java Field:  merchantZipPurchaseCard
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  08/12/13
                SQL Column:  MINI_BAR_CHARGES
                Java Field:  miniBarCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        9(7) V99 Total amount of bar/mini-bar charges. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  12/16/12
                SQL Column:  NETWORK_ID
                Java Field:  networkId
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Must match authorization response value.
                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  NETWORK_REFERENCE_ID
                Java Field:  networkReferenceId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Discover (JCB (US Domestic only), and Diners) refers to this as an alpha-numeric field, but it is always 15 digits. Send as numeric and do not alter (do not justify left or right).                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  ORDER_NUMBER
                Java Field:  orderNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used for direct marketing merchants only — order number assigned by the merchant and associated with the transaction.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  OTHER_AMOUNT
                Java Field:  otherAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate a secondary “Cashback” amount associated with the transaction.                         
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  OTHER_SERVICES_CHARGES
                Java Field:  otherServicesCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of other expenses incurred. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  OTHER_SERVICES_CODE
                Java Field:  otherServicesCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicator to explain the amount that is in the "other services charges" field. (Optional). Value defined by merchant. Use spaces when not provided.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PHONE_CHARGES
                Java Field:  phoneCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total charges for all calls. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  POS_DATA
                Java Field:  posData
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space-fill in authorization request message.
Only if the American Express Indicator on the authorization request message (0100) is an ―X‖, Amex CAPN POS Data field will be returned in the response (0110), otherwise zero-filled.
On a 0100 capture only transaction, value that corresponds to the transaction. Identifier received in 0110 message needs to be sent.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  POS_TERMINAL_CAPABILITY
                Java Field:  posTerminalCapability
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the POS terminal capabilities for obtaining the data stored on the card.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PROGRAM_CODE
                Java Field:  programCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to identify special circumstances, such as "no show". (Optional). Value defined by merchant. Use spaces when not provided.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  PROPERTY_TELEPHONE_NUMBER
                Java Field:  propertyTelephoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies specific property by its local phone number. Include area code, exchange, and number. 
(Required for Reduced Interchange). 
First 3 positions must be numeric                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  PURCHASE_ID_FORMAT
                Java Field:  purchaseIdFormat
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        For Visa the information in the field used by the merchant to identify the purchase (e.g., SKU number). 
For MasterCard the code that the cardholder supplied to the merchant. 
For American Express the customer reference number.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  RATE_PER_MILE
                Java Field:  ratePerMile
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total rent amount per mile.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RECEIPT_NO
                Java Field:  receiptNo
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        REQUIRED. 
Number provided on debit/EBT receipt.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  REFERENCE_NUMBER
                Java Field:  referenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space filled; Reserved for future use.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  RENTAL_CITY
                Java Field:  rentalCity
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City where the car rental starts.                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  RENTAL_DATE
                Java Field:  rentalDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the car rental starts.                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  RENTAL_RETURN_CITY
                Java Field:  rentalReturnCity
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City where the car is returned.                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  RENTAL_RETURN_DATE
                Java Field:  rentalReturnDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the car is returned.                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  RENTAL_RETURN_STATE_COUNTRY
                Java Field:  rentalReturnStateCountry
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State where the car is returned.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  RENTAL_STATE
                Java Field:  rentalState
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State where the car rental starts.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  RENTAL_TIME
                Java Field:  rentalTime
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Time when the car rental starts.                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  RENTER_NAME
                Java Field:  renterName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the person who rented the car.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  RESTAURANT_CHARGES
                Java Field:  restaurantCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of hotel restaurant or room service charges. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_FOOD_AMOUNT
                Java Field:  restaurantFoodAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions. 
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_ID
                Java Field:  restaurantId
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions. 
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_TIP_AMOUNT
                Java Field:  restaurantTipAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions. 
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  RESTAURANT_TIP_ID
                Java Field:  restaurantTipId
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions. 
There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  RETURN_COUNTRY_CODE
                Java Field:  returnCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country where the car is returned.                        
                     
                 
             
                    
                        
                Added On:  06/22/15
                SQL Column:  RETURN_LOCATION_ID
                Java Field:  returnLocationId
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identification code of the place where car was returned.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  RETURN_TIME
                Java Field:  returnTime
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Time when the car is returned.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  ROOM_RATE
                Java Field:  roomRate
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space filled; Reserved for future use.
Hotel daily room charge. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided. Required for MC Corp T+E 3 rate                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  SHIP_FROM_ZIP
                Java Field:  shipFromZip
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The postal or ZIP code of the location from which goods were shipped.
Optional for Visa and MasterCard. Mandatory for American Express.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  SPECIAL_CONDITION_INDICATOR
                Java Field:  specialConditionIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Formerly known as MOTO/ECI indicator.
The MOTO/ECI indicator of 1 is required for all Visa And MasterCard Mail/telephone transactions, regardless of the merchant‘s MCC.                        
                     
                 
             
                    
                        
                Added On:  10/05/17
                SQL Column:  SPEND_QUALIFIED_INDICATOR
                Java Field:  spendQualifiedIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/22/15
                SQL Column:  TAX_EXEMPT_INDICATOR
                Java Field:  taxExemptIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicator of the tax extempt.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TERMINAL_APPLICATION_VERSION_NUMBER
                Java Field:  terminalApplicationVersionNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The version number of the installed in the terminal application.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TERMINAL_CAPABILITY_PROFILE
                Java Field:  terminalCapabilityProfile
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the card data input, CVM, and security capabilities of the terminal.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TERMINAL_COUNTRY_CODE
                Java Field:  terminalCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field, which is found on the Descriptor (N) record must contain the three-position Terminal Country Code. This value is used to identify the country code where the terminal is located.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TERMINAL_SERIAL_NUMBER
                Java Field:  terminalSerialNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The unique serial number of the terminal. Provided by the creator.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TERMINAL_TRANSACTION_DATE
                Java Field:  terminalTransactionDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field, which is found on the Detail and Detail Acknowledgment records, contains the date that the transaction occurred. 
In the 40 & 80 Byte records, the Transaction Date is presented in MMDD format. For Visa Retail Electronic Payment Service (REPS) qualification, the Transaction Date must be within one calendar day of the Authorization Date.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TERMINAL_TYPE
                Java Field:  terminalType
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the environment of the terminal, its communication capability, and its operational control.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TERMINAL_VERIFICATION_RESULTS
                Java Field:  terminalVerificationResults
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value indicates the status of the different functions as seen from the terminal.                         
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TOTAL_AUTH_AMOUNT
                Java Field:  totalAuthAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to submit the Total Authorized Amount in 0400 reversal request message.
For Capture only transactions, this should reflect the Total Amount authorized.
For all other message types – Zero fill.                        
                     
                 
             
                    
                        
                Added On:  06/23/15
                SQL Column:  TOTAL_MILES
                Java Field:  totalMiles
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Rented car total mileage.                        
                     
                 
             
                    
                        
                Added On:  08/12/13
                SQL Column:  TOTAL_ROOM_TAX
                Java Field:  totalRoomTax
             
            
                Status:  Active
                SQL Type:  varchar(7)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Hotel daily tax. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided. Required for MC Corp T+E 3 rate.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TRANSACTION_AMOUNT
                Java Field:  transactionAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/06/15
                SQL Column:  TRANSACTION_CATEGORY_CODE
                Java Field:  transactionCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(11)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The category code of the processed transaction.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TRANSACTION_CODE
                Java Field:  transactionCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Numeric. Transaction code submitted for processing will be returned with each item.                         
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TRANSACTION_CURRENCY_CODE
                Java Field:  transactionCurrencyCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to indicate the currency code of the transaction according to the ISO 4217 standard.                         
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TRANSACTION_DATE
                Java Field:  transactionDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The date of transaction in format MMDD.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TRANSACTION_ERROR_EDIT_CODE
                Java Field:  transactionErrorEditCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space-fill in authorization request message. If there is an error, the Issuer will respond with the 1-byte Transaction Edit Error Code. MasterCard's BankNET system will provide track data validation and POS validation. If the track data contains an edit error, a single one-position alphabetic error code is provided.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  TRANSACTION_IDENTIFIER
                Java Field:  transactionIdentifier
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Terminal will send X‘20‘ (spaces) in initial authorization message.
Space-fill in authorization request message.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  TRANSACTION_SEQUENCE_COUNTER
                Java Field:  transactionSequenceCounter
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/06/15
                SQL Column:  TRANSACTION_TYPE
                Java Field:  transactionType
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The type of processed transaction.
First Data supports the following types of transactions: 
- Autorization only
- Authorization with Host Capture Settlement
- Capture only.
 
                 
             
                    
                        
                Added On:  12/11/12
                SQL Column:  UCAF_STATUS
                Java Field:  ucafStatus
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Zero or space fill if non e-commerce transaction.
0 - UCAF data collection not supported by merchant.
1 - UCAF data supported by merchant, but UCAF data was not populated.
2 - UCAF data is supported by merchant and UCAF data was populated.                        
                     
                 
             
                    
                        
                Added On:  04/06/15
                SQL Column:  UNPREDICTABLE_NUMBER
                Java Field:  unpredictableNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This value is used to provide variability and uniqueness to the generation of a cryptogram.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  VALIDATION_CODE
                Java Field:  validationCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Space-filled for initial authorization message. The Issuer response will be sent for incremental authorizations and reversals.
For Visa Transactions, a four-byte code assigned by Visa‘s Authorization System that is used later to determine the accuracy of the authorization data contained in the settlement record. If the authorization request qualifies for REPS and the transaction is approved, the Validation Code is included in the authorization response.                        
                     
                 
             
                    
                        
                Added On:  11/05/12
                SQL Column:  VISA_CARD_LEVEL_INDICATOR
                Java Field:  visaCardLevelIndicator
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Supported beginning with Spring release 2007 (04/13/2007), Enforced by Visa by 10/01/2007 for interchange compliance, for each Visa Sale transaction that was electronically authorized. The value to supply in this field is the value that is returned to the merchant in the authorization response message. Space fill for Visa Referral sales, Visa offline sales, All returns and all Non Visa transactions.                        
                     
                 
             
                    
                        
                Added On:  06/14/16
                SQL Column:  VISA_SERVICE_DEVELOPMENT
                Java Field:  visaServiceDevelopment
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String