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.
Available Fields:
Added On:  11/10/14
SQL Column:  ACI
Java Field:  aci
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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
Attributes:
Acknowledgment validation code.
Added On:  04/25/16
SQL Column:  ADJUSTED_AMOUNT
Java Field:  adjustedAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Audit adjustment indicator.
Added On:  11/10/14
SQL Column:  AUTH_AMOUNT
Java Field:  authAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Source of authorization.
Added On:  11/10/14
SQL Column:  AVS_RESPONSE
Java Field:  avsResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Transient
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
Attributes:
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
Attributes: Transient
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
References Charge Transaction
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Car rental period.
Added On:  11/10/14
SQL Column:  DUTY_AMOUNT
Java Field:  dutyAmount
Status:  Active
SQL Type:  varchar(13)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Identifier / Primary Key
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Amount of the local tax.
Added On:  11/10/14
SQL Column:  LOCAL_TAX_INDICATOR
Java Field:  localTaxIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes: Required
Code of Merchant Account to which instance of this object is attributed to.
Depending on the context, Merchant Account Code field may contain either merchant code or merchant account code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.
Added On:  11/10/14
SQL Column:  MERCHANT_CATEGORY_CODE
Java Field:  merchantCategoryCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  04/27/16
SQL Column:  ORDER_DATE
Java Field:  orderDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  04/25/16
SQL Column:  RENTAL_CITY
Java Field:  rentalCity
Status:  Active
SQL Type:  varchar(18)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
MasterCard field.
Added On:  04/25/16
SQL Column:  RENTAL_STATE
Java Field:  rentalState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Amount of the tip.
Added On:  04/25/16
SQL Column:  RESTAURANT_TIP_ID
Java Field:  restaurantTipId
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Added On:  04/25/16
SQL Column:  
Java Field:  serviceCode
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Type of the transaction.
Added On:  04/27/16
SQL Column:  TRANSACTION_TYPE_CODE
Java Field:  transactionTypeCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
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
Attributes:
Transaction condition at the POS.