First Data Rapid Connect Capture Retail Transaction                                                     UML
                                
         
     
    
    
    
    
        
            Added On:  11/10/14 
        
        
        
            Module:  UniCharge 
        
     
    
        
            Type:  Entity 
            Status:  Active 
        
        
                            Java Class:  FirstDataRapidConnectCaptureRetailTransaction 
                    
        
        
     
    
        
            
                
                    FirstData Rapid Connect specific low-level representation of Retail Transaction produced by 
Forward Transformation Process within 
Settlement Process.
During 
Generation Process, FirstData Rapid Connect 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/10/14
                SQL Column:  ACI
                Java Field:  aci
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A code used to request qualification in the Custom Payment Service (CPS) program as defined by Visa.  Upon evaluation, the code may be changed in the response message if provided by Visa.                         
                     
                 
             
                    
                        
                Added On:  02/11/15
                SQL Column:  ACKNOWLEDGMENT_CODE
                Java Field:  acknowledgmentCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Acknowledgment validation code.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ADJUSTED_AMOUNT
                Java Field:  adjustedAmount
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Amount charged in addition to the auto rental agreement after the auto was returned. 
If Adjusted Amount Indicator = Space, enter zeroes in this field. 
If Adjusted Amount Indicator not equal to space, this field must be greater than zero.
Assume two decimal places for U.S. dollars.
Applicable to STAR.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ADJUSTED_AMOUNT_INDICATOR
                Java Field:  adjustedAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to tell if any miscellaneous charges were incurred after the vehicle was returned.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  AMOUNT_OTHER
                Java Field:  amountOther
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Secondary amount associated with the transaction, representing a cash back amount. If there is no secondary amount, zero filled.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  APPLICATION_CRYPTOGRAM
                Java Field:  applicationCryptogram
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Cryptogram returned by the ICC in response to the GENERATE AC command. This field must be display hexadecimal.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  APPLICATION_EXPIRATION_DATE
                Java Field:  applicationExpirationDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Expiration date of the current application.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  APPLICATION_INTERCHANGE_PROFILE
                Java Field:  applicationInterchangeProfile
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A series of indicators that reflect the specific functions supported by the chip card account. For example, this field indicates whether cardholder verification is supported. This field must be display hexadecimal.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  APPLICATION_TRANSACTION_COUNTER
                Java Field:  applicationTransactionCounter
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the count of the transactions performed with the application. This field is incremented by 1 each time a transaction is initiated. This field must be display hexadecimal.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ARRIVAL_DATE
                Java Field:  arrivalDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date on which the Cardholder checked into the lodging facility.
Format MMDDYY                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  AUDIT_INDICATOR
                Java Field:  auditIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Audit adjustment indicator.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  AUTH_AMOUNT
                Java Field:  authAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Amount of the transaction inclusive of all additional amounts provided in the Additional Amounts Group or other amount fields, e.g. Tax Amount in Purchase Card L2 Group. 
It is submitted in the currency represented by the Transaction Currency field. The transaction amount returned in the response will be different than the amount submitted in the request for an approved partial authorization.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  AUTH_CURRENCY_CODE
                Java Field:  authCurrencyCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Numeric currency code of the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  AUTH_RESPONSE_CODE
                Java Field:  authResponseCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Response code that represents status of the transaction.  
Note:  If the message format is not valid then a reject-response message may be returned containing error data.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  AUTH_TIME
                Java Field:  authTime
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Transmission date and time of the transaction (in GMT/UTC).                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  AUTHORIZATION_CODE
                Java Field:  authorizationCode
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The value assigned by the authorizer and returned in the response to the authorization request.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  AUTHORIZATION_DATE
                Java Field:  authorizationDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date of the authorization.                        
                     
                 
             
                    
                        
                Added On:  04/11/16
                SQL Column:  AUTHORIZATION_SOURCE
                Java Field:  authorizationSource
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/10/14
                SQL Column:  AVS_RESPONSE
                Java Field:  avsResponse
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The result of checking the cardholder‘s postal code and any additional address information provided against the issuer‘s system of record.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  BANK_NET_DATE
                Java Field:  bankNetDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Data assigned by MasterCard, to every transaction that is processed through MasterCard‘s BankNet System. Consists of BankNet Date (MMDD).                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  BANK_NET_REFERENCE_ID
                Java Field:  bankNetReferenceId
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Data assigned by MasterCard, to every transaction that is processed through MasterCard‘s BankNet System. 
The following field rules are defined: 
- The BankNet Reference Data will be returned in authorization response messages, when available. 
- When submitting subsequent transactions the same BankNet Reference Data must be provided if returned in the authorization response. 
 
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  CAR_RENTAL_AGREEMENT_NUMBER
                Java Field:  carRentalAgreementNumber
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The car rental agency’s agreement (invoice) number supplied to the customer which will be used to trace any inquiries with regard to the transaction.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  
                Java Field:  cardExpirationDate
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Expiration date of the card used in the transaction.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  CARD_SEQUENCE_NUMBER
                Java Field:  cardSequenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Number assigned to a specific card when two or more cards are associated with a single account number. Right justified; zero filled.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  
                Java Field:  cardholderAccountNumber
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Account number of the card used in the transaction.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CARDHOLDER_ACTIVATED_TERMINAL
                Java Field:  cardholderActivatedTerminal
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier used to describe the type of terminal being used for the transaction. 
For MasterCard and Ecommerce only. PTS value.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CARDHOLDER_ID
                Java Field:  cardholderId
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The unique identification number of the cardholder.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  CARDHOLDER_NAME
                Java Field:  cardholderName
             
            
                Status:  Active
                SQL Type:  varchar(27)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the credit cardholder.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  CARDHOLDER_VERIFICATION_METHOD_RESULTS
                Java Field:  cardholderVerificationMethodResults
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Results of the payment card verification method.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CASH_BACK_AMOUNT
                Java Field:  cashBackAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Value for a single additional amount instance.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CHARGE_TRANSACTION_FK
                Java Field:  chargeTransaction
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
            
                
                    
                        
                        Reference to the entity that represents real-time financial transaction.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  CRYPTOGRAM_AMOUNT
                Java Field:  cryptogramAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the actual transaction amount used by the chip when calculating the cryptogram for the EMV transaction. This amount excludes any adjustments (e. g. tips) that were made to the transaction amount after completion of the original EMV transaction.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  CRYPTOGRAM_INFORMATION_DATA
                Java Field:  cryptogramInformationData
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Refer to the specification of the processor for more information.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CUSTOMER_CODE
                Java Field:  customerCode
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the customer in the system.                        
                     
                 
             
                    
                        
                Added On:  11/26/14
                SQL Column:  CUSTOMER_NAME
                Java Field:  customerName
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name assosiated with the customer.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CUSTOMER_SERVICE_NUMBER
                Java Field:  customerServiceNumber
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Phone number used to discuss any pocessing issues.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CVC_ERROR
                Java Field:  cvcError
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Error code that may be returned in response to the CCV data submitted at the time of authorization.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  CVV2_RESULT_CODE
                Java Field:  cvv2ResultCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Result code of the CCV verification.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  DAILY_RENTAL_RATE
                Java Field:  dailyRentalRate
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total rent amount per a day.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DE22_DATA
                Java Field:  de22Data
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Transaction specific data that may be returned in MasterCard response messages for auth transaction.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  DEDICATED_FILE_NAME
                Java Field:  dedicatedFileName
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies the name of the DF as described in ISO/IEC 7816-4. Left justified; space filled. If data not available, space filled. This field must be display hexadecimal.                          
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  DEPARTURE_DATE
                Java Field:  departureDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Departure date of the customer.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  DESTINATION_ADDRESS
                Java Field:  destinationAddress
             
            
                Status:  Active
                SQL Type:  varchar(27)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Address of the person receiving the purchased item.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  DESTINATION_CITY
                Java Field:  destinationCity
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City of the person receiving the item.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DESTINATION_COUNTRY
                Java Field:  destinationCountry
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the location the items in the purchase are being delivered to.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  DESTINATION_STATE
                Java Field:  destinationState
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State of the person receiving the item.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DESTINATION_ZIP
                Java Field:  destinationZip
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP (or postal) code of the location the item(s) in the purchase are being delivered to.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DISCOUNT_AMOUNT
                Java Field:  discountAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Discount amount for the purchase.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DISCOUNT_AMOUNT_INDICATOR
                Java Field:  discountAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the discount status of the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DS_POS_DATA
                Java Field:  dsPosData
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The specific POS capture conditions for the card information at the time of the transaction.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DS_POS_ENTRY_MODE
                Java Field:  dsPosEntryMode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The entry mode provided to Discover for the transaction.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DS_PROCESSING_CODE
                Java Field:  dsProcessingCode
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies the type of transaction sent to the card acceptor.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DS_STAN
                Java Field:  dsStan
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents a number assigned by the merchant to uniquely reference the transaction. Must be unique within a day per Merchant ID and Terminal ID.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DS_TRACK_DATA_CONDITION_CODE
                Java Field:  dsTrackDataConditionCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Magnetic stripe conditions and the vulnerability to fraud for Discover card transactions.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  DURATION
                Java Field:  duration
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/10/14
                SQL Column:  DUTY_AMOUNT
                Java Field:  dutyAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Duty amount for the purchase.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  DUTY_AMOUNT_INDICATOR
                Java Field:  dutyAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the duty status of the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  EC_SECURITY_LEVEL
                Java Field:  ecSecurityLevel
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An indicator provided by the merchant to identify the security level of an Ecommerce transaction. In the following description, the term 3-D Secure refers to authentication programs such as Verified by Visa, MasterCard SecureCode and American Express Safekey (AESK).                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  ENTRY_MODE
                Java Field:  entryMode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier used to indicate how the account number was entered on the transaction and the PIN entry capability of the POS.                         
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  EXTRA_CHARGE
                Java Field:  extraCharge
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Extra expenses of the customer.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  EXTRA_CHARGES_INDICATOR
                Java Field:  extraChargesIndicator
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Extra charges indicator of the customer.                        
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  EXTRA_MILE_CHARGE
                Java Field:  extraMileCharge
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Extra miles charges of the customer.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  FOLIO_NUMBER
                Java Field:  folioNumber
             
            
                Status:  Active
                SQL Type:  varchar(25)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Folio number assigned. (Required for Reduced Interchange).                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  FORM_FACTOR_INDICATOR
                Java Field:  formFactorIndicator
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to define Visa consumer device used in the transaction. For more information refer to the specification of the processor.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  FREIGHT_AMOUNT
                Java Field:  freightAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Freight amount included in the purchase.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  FREIGHT_AMOUNT_INDICATOR
                Java Field:  freightAmountIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the freight status of the transaction.                        
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  FUEL_CHARGE
                Java Field:  fuelCharge
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Fule expenses of the customer.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  GIFT_SHOP_CHARGES
                Java Field:  giftShopCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of gift shop expenses. (Optional) Assume two decimal places for U.S. dollars. 
Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  GUEST_NAME
                Java Field:  guestName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Spaces if not supplied.
This field is applicable to STAR.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                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:  11/10/14
                SQL Column:  INITIAL_AUTH_AMOUNT
                Java Field:  initialAuthAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Initial authorization transaction amount.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  INSURANCE_CHARGES
                Java Field:  insuranceCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Insurance expenses of the customer.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  INSURANCE_INDICATOR
                Java Field:  insuranceIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to tell if insurance was purchased by the customer.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ISSUER_APPLICATION_DATA
                Java Field:  issuerApplicationData
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains proprietary application data for transmission to the issuer in an online transaction. Display hexadecimal, left justified, space filled.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ISSUER_APPLICATION_DATA2
                Java Field:  issuerApplicationData2
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains proprietary application data for transmission to the issuer in an online transaction. Display hexadecimal, left justified, space filled.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ISSUER_AUTHENTICATION_DATA
                Java Field:  issuerAuthenticationData
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains data transmitted from the issuer to the card for issuer authentication. This field must be display hexadecimal.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ISSUER_SCRIPT1_RESULTS
                Java Field:  issuerScript1Results
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The issuer can send commands (‘issuer scripts’) to the card in the authorization response during online processing. The card ‘executes’ the commands and updates the card parameters. The card records the identifier of the commands and the success or failure of the updates in the Issuer Script 1 Results field. If data is unavailable, space filled.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ISSUER_SCRIPT1_RESULTS2
                Java Field:  issuerScript1Results2
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The issuer can send commands (‘issuer scripts’) to the card in the authorization response during online processing. The card ‘executes’ the commands and updates the card parameters. The card records the identifier of the commands and the success or failure of the updates in the Issuer Script 1 Results 2 field. If data is unavailable, space filled.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                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/10/14
                SQL Column:  LOCAL_TAX_AMOUNT
                Java Field:  localTaxAmount
             
            
                Status:  Active
                SQL Type:  varchar(13)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  11/10/14
                SQL Column:  LOCAL_TAX_INDICATOR
                Java Field:  localTaxIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the taxable status of the transaction.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  LOCAL_TRANSACTION_TIME
                Java Field:  localTransactionTime
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Local date and time when transaction was performed.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  LODGING_CHARGE_TYPE
                Java Field:  lodgingChargeType
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the lodging charge.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  LODGING_SPECIAL_PROGRAM
                Java Field:  lodgingSpecialProgram
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the lodging special program.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  MAGNETIC_STRIPE_STATUS
                Java Field:  magneticStripeStatus
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier used to indicate how the account number was entered on the transaction and the PIN entry capability of the POS. Refer to the specification of the provider for more information.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  MARKET_SPECIFIC_AUTH_INDICATOR
                Java Field:  marketSpecificAuthIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the industry for which the transaction data applies (i.e. healthcare, bill payment, etc.).                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  MARKET_SPECIFIC_DATE
                Java Field:  marketSpecificDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the order was placed.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  MASTER_CARD_TRANSACTION_CATEGORY_INDICATOR
                Java Field:  masterCardTransactionCategoryIndicator
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the industry for which the transaction data applies (i.e. healthcare, bill payment, etc.).                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  MAXIMUM_FREE_MILES
                Java Field:  maximumFreeMiles
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total free mileage for rent period.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                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/10/14
                SQL Column:  MERCHANT_CATEGORY_CODE
                Java Field:  merchantCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An industry standard four-digit number used to classify a business by the type of goods or services it provides.                          
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  MERCHANT_PURCHASE_REFERENCE_IDENTIFIER
                Java Field:  merchantPurchaseReferenceIdentifier
             
            
                Status:  Active
                SQL Type:  varchar(17)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Data used by the merchant or customer to identify the purchase. This can be a SKU, code, or reference number.                         
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  MERCHANT_TAX_ID
                Java Field:  merchantTaxId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Federal Tax ID number or Social Security Number for unincorporated business.                         
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  MERCHANT_URL_OR_EMAIL_ADDRESS
                Java Field:  merchantUrlOrEmailAddress
             
            
                Status:  Active
                SQL Type:  varchar(32)
                Java Type:  String
             
            
            
            
                
                    
                        
                        First byte cannot be space. Merchant does not have to include “www”. ‘.’ And ‘@’ Is allowed in name, example store.com, avoid use of other special characters.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  MERCHANT_ZIP
                Java Field:  merchantZip
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP (or postal) code of the merchant's address on the First Data merchant file.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  MERCHANT_ZIP_PURCHASE_CARD
                Java Field:  merchantZipPurchaseCard
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Merchant ZIP (or postal) code.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  MINI_BAR_CHARGES
                Java Field:  miniBarCharges
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Total amount of bar/mini-bar charges. (Optional). Assume two decimal places for U.S. dollars. 
Use zeroes when not provided.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  NETWORK_ID
                Java Field:  networkId
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies the Network ID as returned by the host, if available.                         
                     
                 
             
                    
                        
                Added On:  02/12/15
                SQL Column:  NETWORK_REFERENCE_ID
                Java Field:  networkReferenceId
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The Network Result Indicator (NRID) assigned by Discover.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  NO_SHOW_INDICATOR
                Java Field:  noShowIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        This field must be populated for Hotel & Lodging, and Car Rental transactions using STAR Signature Debit card. This field indicates whether the customer checked in or picked up car, according to the guaranteed reservation                        
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  ONE_WAY_DROP_OFF_CHARGES
                Java Field:  oneWayDropOffCharges
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/27/16
                SQL Column:  ORDER_DATE
                Java Field:  orderDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date the order was placed, format MMDDYY.
                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  ORDER_NUMBER
                Java Field:  orderNumber
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Number assigned by the merchant to uniquely reference an order.                         
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  ORIGINATING_ADDRESS
                Java Field:  originatingAddress
             
            
                Status:  Active
                SQL Type:  varchar(27)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Address of individual making the purchase.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  ORIGINATING_CITY
                Java Field:  originatingCity
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City of individual making the purchase.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  ORIGINATING_COUNTRY
                Java Field:  originatingCountry
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country of individual making the purchase.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  ORIGINATING_PHONE_NUMBER
                Java Field:  originatingPhoneNumber
             
            
                Status:  Active
                SQL Type:  varchar(16)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Phone number of individual making the purchase.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  ORIGINATING_STATE
                Java Field:  originatingState
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State of individual making the purchase.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  ORIGINATING_ZIP
                Java Field:  originatingZip
             
            
                Status:  Active
                SQL Type:  varchar(9)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP (or postal) code of individual making the purchase.                        
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  OTHER_CHARGES
                Java Field:  otherCharges
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Other expences of the customer.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                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/10/14
                SQL Column:  POS_DATA
                Java Field:  posData
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Differs for Discover, MasterCard and AmEx cards.
Discover:
The specific POS capture conditions for the card information at the time of the transaction. 
MasterCard:
Contains transaction specific data that may be returned in MasterCard response messages. For merchants that send settlement files directly to PTS, the values in this field would be sent in the XE02 PTS record for MasterCard transactions. 
AmEx:
Contains transaction specific data that is returned by American Express and required on subsequent transactions.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  POS_ENTRY_MODE_CHANGE
                Java Field:  posEntryModeChange
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies that POS entry mode was changed by the issuer.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  POS_TERMINAL_CAPABILITY
                Java Field:  posTerminalCapability
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier used to indicate the entry mode capability of the terminal.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  PREPAID_CARD_INDICATOR
                Java Field:  prepaidCardIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Payment type of the transaction.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  PROGRAM_CODE
                Java Field:  programCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Used to identify special circumstances, such as "frequent renter" or "no show". Value defined by merchant. (Optional). Space fill if not used. Cannot be all zeroes.
                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  PURCHASE_ID_FORMAT
                Java Field:  purchaseIdFormat
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier used to indicate the transaction condition at the POS. PTS value.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RATE_PER_MILE
                Java Field:  ratePerMile
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Rate of every mile for the customer.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  RECEIPT_NO
                Java Field:  receiptNo
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Contains the System Trace Audit Number (STAN) of the original transaction.                        
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  RECEIVER_NAME
                Java Field:  receiverName
             
            
                Status:  Active
                SQL Type:  varchar(27)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the person receiving the purchased item.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  REFERENCE_NUMBER
                Java Field:  referenceNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A value assigned by the merchant to uniquely reference a transaction and any subsequent related transactions.                        
                     
                 
             
                    
                        
                Added On:  05/20/16
                SQL Column:  RENTAL_ADDRESS
                Java Field:  rentalAddress
             
            
                Status:  Active
                SQL Type:  varchar(26)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/25/16
                SQL Column:  RENTAL_CITY
                Java Field:  rentalCity
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City where the car rental starts.                        
                     
                 
             
                    
                        
                Added On:  04/26/16
                SQL Column:  RENTAL_COUNTRY
                Java Field:  rentalCountry
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country where car was rented from.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RENTAL_DATE
                Java Field:  rentalDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the car rental starts.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RENTAL_RETURN_CITY
                Java Field:  rentalReturnCity
             
            
                Status:  Active
                SQL Type:  varchar(18)
                Java Type:  String
             
            
            
            
                
                    
                        
                        City where the auto was returned. (Required for Reduced Interchange). Cannot be all zeroes.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                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:  04/25/16
                SQL Column:  RENTAL_RETURN_STATE_COUNTRY
                Java Field:  rentalReturnStateCountry
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/25/16
                SQL Column:  RENTAL_STATE
                Java Field:  rentalState
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        State where the car was rented.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RENTAL_TIME
                Java Field:  rentalTime
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Car rental start time (format HHMM).                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RENTER_NAME
                Java Field:  renterName
             
            
                Status:  Active
                SQL Type:  varchar(20)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Name of the individual making the rental agreement.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                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.
This field is applicable to STAR.
                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RESTAURANT_FOOD_AMOUNT
                Java Field:  restaurantFoodAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Amount of money for the restaurant food.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RESTAURANT_TIP_AMOUNT
                Java Field:  restaurantTipAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/25/16
                SQL Column:  RESTAURANT_TIP_ID
                Java Field:  restaurantTipId
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique identifier of a person to receive the tip.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  RETURN_COUNTRY_CODE
                Java Field:  returnCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the country where the car is returned.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                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:  04/25/16
                SQL Column:  RETURN_TIME
                Java Field:  returnTime
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Time when the car is returned (format HHMM).                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  ROOM_RATE
                Java Field:  roomRate
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the room rate of the last night of stay.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  SAFE_KEY_ELECTRONIC_COMMERCE_INDICATOR
                Java Field:  safeKeyElectronicCommerceIndicator
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/25/16
                SQL Column:  
                Java Field:  serviceCode
             
            
                Status:  Active
                SQL Type:  
                Java Type:  String
             
            
            
            
                
                    
                        
                        Service code is mandatory for all merchants who do not authorize with First Data but directly settle through First Data. This field is mandatory for all non-keyed transactions and critical for chargeback resolution related to chip liability shift.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  SHIP_FROM_ZIP
                Java Field:  shipFromZip
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        ZIP (or postal) code the item(s) in the purchase are to be shipped from.                         
                     
                 
             
                    
                        
                Added On:  04/27/16
                SQL Column:  SHIPPING_HANDLING_FEE
                Java Field:  shippingHandlingFee
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Fee charged for the shipping/ handling of the shipped items.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  SPECIAL_CONDITION_INDICATOR
                Java Field:  specialConditionIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        An identifier used to indicate the type of bill payment transaction.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TAX_EXEMPT_INDICATOR
                Java Field:  taxExemptIndicator
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates if rental is tax exempt.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TERMINAL_APPLICATION_VERSION_NUMBER
                Java Field:  terminalApplicationVersionNumber
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Version number of the terminal application.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TERMINAL_CAPABILITY_PROFILE
                Java Field:  terminalCapabilityProfile
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Indicates the card data input, the Cardholder Verification Method (CVM) and the security supported by the terminal. This field must be display hexadecimal.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TERMINAL_COUNTRY_CODE
                Java Field:  terminalCountryCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Country code of the terminal.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TERMINAL_SERIAL_NUMBER
                Java Field:  terminalSerialNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Unique serial number of the terminal.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TERMINAL_TRANSACTION_DATE
                Java Field:  terminalTransactionDate
             
            
                Status:  Active
                SQL Type:  varchar(6)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date when the transaction was processed in the terminal.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TERMINAL_TYPE
                Java Field:  terminalType
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of the terminal to be used for the transaction.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TERMINAL_VERIFICATION_RESULTS
                Java Field:  terminalVerificationResults
             
            
                Status:  Active
                SQL Type:  varchar(10)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Results of terminal verification.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TIP_AMOUNT
                Java Field:  tipAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Dollar and cents tip amount (implied decimal).                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  TOTAL_AUTH_AMOUNT
                Java Field:  totalAuthAmount
             
            
                Status:  Active
                SQL Type:  varchar(12)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Single additional amount instance.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TOTAL_MILES
                Java Field:  totalMiles
             
            
                Status:  Active
                SQL Type:  varchar(5)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Rented car total mileage.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                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.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  TRANSACTION_AMOUNT
                Java Field:  transactionAmount
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the amount of the transaction inclusive of all additional amounts provided in the Additional Amounts group or other amount fields, e.g. Tax Amount in Purchase Card L2 Group. It is submitted in the currency represented by the Transaction Currency field.  The transaction amount returned in the response will be different than the amount submitted in the request for an approved partial authorization.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TRANSACTION_CATEGORY_CODE
                Java Field:  transactionCategoryCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Category code of the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  TRANSACTION_CODE
                Java Field:  transactionCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the initial transaction. Provided by the processor.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TRANSACTION_CURRENCY_CODE
                Java Field:  transactionCurrencyCode
             
            
                Status:  Active
                SQL Type:  varchar(3)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the currency used in the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  TRANSACTION_DATE
                Java Field:  transactionDate
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Date and time when the transaction was performed.                          
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  TRANSACTION_ERROR_EDIT_CODE
                Java Field:  transactionErrorEditCode
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Error encountered with the track data provided in the authorization request message.                         
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  TRANSACTION_IDENTIFIER
                Java Field:  transactionIdentifier
             
            
                Status:  Active
                SQL Type:  varchar(15)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents a unique value up to 20 digits assigned by Visa, used to identify and link all related transactions for authorization and settlement through Visa. Contains transaction identifier and validation code. 
Note: The last 4 characters represent validation code and all the characters before that represent transaction ID.                        
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TRANSACTION_SEQUENCE_COUNTER
                Java Field:  transactionSequenceCounter
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Counter maintained by the terminal that is incremented by one for each transaction. Should consist of between 4 and 8 decimal digits, left justified and right padded with spaces.                          
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  TRANSACTION_TYPE
                Java Field:  transactionType
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  04/27/16
                SQL Column:  TRANSACTION_TYPE_CODE
                Java Field:  transactionTypeCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Code of the transaction type.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  UCAF_STATUS
                Java Field:  ucafStatus
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Identifies whether the merchant supports MasterCard UCAF (secure code) data collection.                         
                     
                 
             
                    
                        
                Added On:  04/25/16
                SQL Column:  UNPREDICTABLE_NUMBER
                Java Field:  unpredictableNumber
             
            
                Status:  Active
                SQL Type:  varchar(8)
                Java Type:  String
             
            
            
            
                
                    
                        
                        The number used in the generation of the cryptogram for chip transactions. It provides variability and uniqueness to the cryptogram. This field must be display hexadecimal.                          
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  VALIDATION_CODE
                Java Field:  validationCode
             
            
                Status:  Active
                SQL Type:  varchar(4)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Represents the last 4 characters after transaction ID code. Assigned by Visa.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  VISA_CARD_LEVEL_INDICATOR
                Java Field:  visaCardLevelIndicator
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        A value returned by Visa, to designate the type of card product used to process the transaction.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  VISA_POS_CONDITION_CODE
                Java Field:  visaPosConditionCode
             
            
                Status:  Active
                SQL Type:  varchar(2)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Condition of the transaction at the POS.                        
                     
                 
             
                    
                        
                Added On:  11/10/14
                SQL Column:  VISA_SERVICE_DEVELOPMENT
                Java Field:  visaServiceDevelopment
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Transaction condition at the POS.