FirstData Nashville Capture Retail Transaction UML


Added On:  11/05/12 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  FirstDataNashvilleCaptureRetailTransaction 
FirstData Nashville specific low-level representation of Retail Transaction produced by Forward Transformation Process within Settlement Process.
During Generation Process, FirstData Nashville specific interchange message is generated from this object for settlement. Consequently, all fields of the object are mapped into message segments/elements.
Available Fields:
Added On:  11/05/12
SQL Column:  ACI
Java Field:  aci
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Authorization Characteristics Indicator.

This field indicates the result of the Visa's evaluation of the authorization characteristics of a custom payment service transaction.
Added On:  01/02/13
SQL Column:  ACKNOWLEDGMENT_CODE
Java Field:  acknowledgmentCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Four (4) digit ACCEPT/HELD/REJECT Reason Code, that indicates whether FDMS accepted, held, or rejected the transaction or submission. This field is found on the Detail Acknowledgment and General Acknowledgment records.

Zeroes (signed) – the Debit/EBT acknowledgement records are a ‗receipt‘ that the records were received, not an indication if they were successfully processed through the debit system.
Added On:  06/23/15
SQL Column:  ADJUSTED_AMOUNT
Java Field:  adjustedAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Adjusted amount of the transaction.
Added On:  06/23/15
SQL Column:  ADJUSTED_AMOUNT_INDICATOR
Java Field:  adjustedAmountIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Indicator of the adjusted amount.
Added On:  04/06/15
SQL Column:  APPLICATION_CRYPTOGRAM
Java Field:  applicationCryptogram
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
This cryptogram value is returned by the Chip (ICC) in response to a “Generate AC” command. This value indicates the type of cryptogram and the actions to be performed by the terminal.
Added On:  04/06/15
SQL Column:  APPLICATION_EXPIRATION_DATE
Java Field:  applicationExpirationDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This value is used to identify the date after which the application expires.
Added On:  06/14/16
SQL Column:  APPLICATION_INTERCHANGE_PROFILE
Java Field:  applicationInterchangeProfile
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This value is used to indicate the capabilities of the card to support specific functions within the application.
Added On:  04/06/15
SQL Column:  APPLICATION_TRANSACTION_COUNTER
Java Field:  applicationTransactionCounter
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
This is an incrementing counter value that is managed by the application in the chip card.
Added On:  08/12/13
SQL Column:  ARRIVAL_DATE
Java Field:  arrivalDate
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Space filled; Reserved for future use.

Cardholder check-in date in the form MMDDYY.
(Required for Reduced Interchange).
Added On:  11/05/12
SQL Column:  AUTH_AMOUNT
Java Field:  authAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This record provides market-specific data elements for the Direct Marketing, Car Rental, Lodging, Purchase card (MC-Visa), Business to Business Industries, and Visa Bill payment, Visa Healthcare IIAS.
Added On:  11/05/12
SQL Column:  AUTH_RESPONSE_CODE
Java Field:  authResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Alphanumeric value assigned by the bank to a merchant sale or cash advance that has received specific approval. The code is used as proof that the transaction has been properly approved.

Response to the request message.
Added On:  11/05/12
SQL Column:  AUTHORIZATION_CODE
Java Field:  authorizationCode
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Mandatory for Capture only (Bit 31, value of 2) transactions.
Added On:  11/05/12
SQL Column:  AUTHORIZATION_DATE
Java Field:  authorizationDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Date of authorization.
Added On:  04/06/15
SQL Column:  AUTHORIZATION_RESPONSE_CODE
Java Field:  authorizationResponseCode
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value is generated by the authorization authority for an approved transaction.
Added On:  11/05/12
SQL Column:  AUTHORIZATION_SOURCE
Java Field:  authorizationSource
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.
Added On:  11/05/12
SQL Column:  AVS_RESPONSE
Java Field:  avsResponse
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Address Verification Response.

AVS response from auth — mandatory for Capture only (Bit 31, value of 2) transactions.
Added On:  11/05/12
SQL Column:  BANK_NET_DATE
Java Field:  bankNetDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Space-fill in the 0100 original authorization request message. The value received in the 0110 original authorization response, must be submitted in the 0100 incremental request & 0400 reversal message and capture only transaction request message. The Issuer will respond with the 4-byte BankNET Date (MMDD).
Added On:  11/05/12
SQL Column:  BANK_NET_REFERENCE_ID
Java Field:  bankNetReferenceId
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Space-fill in the 0100 original authorization request message. The value received in the 0110 original authorization response, must be submitted in the 0100 incremental request & 0400 reversal message and capture only transaction request message. The Issuer will respond with the 9-byte BankNET Reference.
Added On:  08/12/13
SQL Column:  BILLING_ADJUSTMENT_AMOUNT
Java Field:  billingAdjustmentAmount
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Total amount of charges added after departure. Must be greater than zero is field 8 is 'Y'. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
Added On:  08/12/13
SQL Column:  BILLING_ADJUSTMENT_INDICATOR
Java Field:  billingAdjustmentIndicator
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Tells whether additional charges were added after departure.

" " - No additional charges added.
"Y" - Additional charges added.
Added On:  06/22/15
SQL Column:  CAR_RENTAL_AGREEMENT_NUMBER
Java Field:  carRentalAgreementNumber
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Car rental agreement number.
Added On:  04/06/15
SQL Column:  
Java Field:  cardExpirationDate
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
The expiration date of the card. (MMYY)
Added On:  04/06/15
SQL Column:  CARD_SEQUENCE_NUMBER
Java Field:  cardSequenceNumber
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
The Card Sequence Number is a number used to differentiate cards that have the same primary account number (PAN).

Field 023 contains the Card Sequence Number in the range '000' to '099', right justified and left-padded with zeros. It is only used for transactions containing ICC System Data. For transactions containing ICC Data, the Card Sequence Number is mandated when the card product includes the Card Sequence Number in the criteria for uniquely defining a card. In this case, Field 023 must contain the Application PAN Sequence number (ICC tag 5F34), if present on the ICC. If ICC Tag 5F34 is not available (is not supplied by the card), Field 023 must be omitted.
Added On:  04/06/15
SQL Column:  
Java Field:  cardholderAccountNumber
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Credit card or bank account number of the cardholder.
Added On:  11/05/12
SQL Column:  CARDHOLDER_ACTIVATED_TERMINAL
Java Field:  cardholderActivatedTerminal
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.
Added On:  11/05/12
SQL Column:  CARDHOLDER_ID
Java Field:  cardholderId
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
First Data-assigned code that identifies the cardholder's location.
Added On:  04/06/15
SQL Column:  CARDHOLDER_VERIFICATION_METHOD_RESULTS
Java Field:  cardholderVerificationMethodResults
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
This value is used to indicate the results of the last CVM preformed.
Added On:  12/16/12
SQL Column:  CASH_BACK_AMOUNT
Java Field:  cashBackAmount
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
This field contains amounts associated with the transaction.
Added On:  11/05/12
SQL Column:  CHARGE_TRANSACTION_FK
Java Field:  chargeTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Charge Transaction
Attributes:
Reference to the entity that represents real-time financial transaction.
Added On:  04/06/15
SQL Column:  CHIP_CONDITION_CODE
Java Field:  chipConditionCode
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Code that explains current chip condition.
Added On:  11/05/12
SQL Column:  CLEARING_COUNT
Java Field:  clearingCount
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The total number of installments within an installment payment plan. This field is found on the Special Condition Record.
Added On:  11/05/12
SQL Column:  CLEARING_SEQUENCE
Java Field:  clearingSequence
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
The number of a given installment within an installment payment plan. This field is found on the Special Condition (S) Record.
Added On:  04/06/15
SQL Column:  CRYPTOGRAM_AMOUNT
Java Field:  cryptogramAmount
Status:  Active
SQL Type:  varchar(12)
Java Type:  String
Attributes:
This value indicates the amount of cryptogram and the actions to be performed by the terminal.
Added On:  04/06/15
SQL Column:  CRYPTOGRAM_INFORMATION_DATA
Java Field:  cryptogramInformationData
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
This value indicates the type of cryptogram and the actions to be performed by the terminal.
Added On:  12/11/12
SQL Column:  CUSTOMER_CODE
Java Field:  customerCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
For Visa the Customer Code/Customer Reference Identifier — Used by the customer to identify the purchase (e.g., the invoice number).
For Visa this field must be 12 digits.

For MasterCard and American Express the code that facilitates merchant/corporation communication and record keeping.
For MasterCard this field must be 17 digits.
For MasterCard Electronic Payment Transactions this value should represent the Invoice Number.

  • Refer to Conditional Requirement Matrix for further detail.
  • Added On:  11/05/12
    SQL Column:  CUSTOMER_SERVICE_NUMBER
    Java Field:  customerServiceNumber
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    Customer Service Phone.
    Added On:  08/12/13
    SQL Column:  CUSTOMER_SERVICE800_NUMBER
    Java Field:  customerService800Number
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    Customer service telephone number to be used to resolve questions or disputes.
    (Required for Reduced Interchange).
    Added On:  11/05/12
    SQL Column:  CVC_ERROR
    Java Field:  cvcError
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Space-fill in authorization request message.

    CVC Incorrect Indicator. An indicator, provided by the Issuer in the authorization response, to identify the presence of an invalid card verification code (CVC). If there is an error, the Issuer will respond with the 1-byte CVC Error Code (Y).
    Added On:  11/05/12
    SQL Column:  CVV2_RESULT_CODE
    Java Field:  cvv2ResultCode
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    The result code of CVV2 verification.
    For DirectSolutions merchants (Tran code '8') this field would contain the CVV2 value.
    Added On:  06/22/15
    SQL Column:  DAILY_RENTAL_RATE
    Java Field:  dailyRentalRate
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    Total rent amount per day.
    Added On:  12/02/12
    SQL Column:  DE22_DATA
    Java Field:  de22Data
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    This record is submitted for MasterCard‘s DE22 program. It is required for merchants who can receive DE22 with their authorization. This record is optional for merchants who do not have the capability to receive DE22 with their authorization response.
    Added On:  04/06/15
    SQL Column:  DEDICATED_FILE_NAME
    Java Field:  dedicatedFileName
    Status:  Active
    SQL Type:  varchar(32)
    Java Type:  String
    Attributes:
    Dedicated file name.
    Added On:  08/12/13
    SQL Column:  DEPARTURE_DATE
    Java Field:  departureDate
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Space filled; Reserved for future use.

    Cardholder check-out date in the form MMDDYY.
    (Required for Reduced Interchange).
    Added On:  11/05/12
    SQL Column:  DESTINATION_COUNTRY
    Java Field:  destinationCountry
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    The ISO assigned code of the country to which goods were shipped.
    Optional for Visa and MasterCard. Not applicable for American Express.
    Added On:  11/05/12
    SQL Column:  DESTINATION_ZIP
    Java Field:  destinationZip
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    The postal or ZIP code of the ―ship to‖ location. This is equal to the Ship from Postal/ZIP Code when the customer takes possession of the items at the merchant location.

    Optional for Visa and MasterCard. Mandatory for American Express.
    Added On:  11/05/12
    SQL Column:  DISCOUNT_AMOUNT
    Java Field:  discountAmount
    Status:  Active
    SQL Type:  varchar(13)
    Java Type:  String
    Attributes:
    Total amount of discount applied to the transaction by the merchant. Used by the merchant when a discount is given on the entire transaction rather than on unit prices. Typically shown as credit on a detailed invoice. Two (2) decimal places are implied.

    Optional for Visa only. Not applicable for MasterCard or American Express.
    Added On:  11/05/12
    SQL Column:  DISCOUNT_AMOUNT_INDICATOR
    Java Field:  discountAmountIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Total amount of discount applied to the transaction by the merchant. Used by the merchant when a discount is given on the entire transaction rather than on unit prices. Typically shown as credit on a detailed invoice. Two (2) decimal places are implied.

    Optional for Visa only. Not applicable for MasterCard or American Express.
    Added On:  12/02/12
    SQL Column:  DS_POS_DATA
    Java Field:  dsPosData
    Status:  Active
    SQL Type:  varchar(13)
    Java Type:  String
    Attributes:
    Card Information Captured at the time of transaction.
    Added On:  12/02/12
    SQL Column:  DS_POS_ENTRY_MODE
    Java Field:  dsPosEntryMode
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    Consists of 2 byte PAN Entry mode and 1 byte PIN entry capability of the POS device.
    Added On:  12/02/12
    SQL Column:  DS_PROCESSING_CODE
    Java Field:  dsProcessingCode
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    This code describes the effect of a Card Transaction on the Card Account. It must be the same as identified in the Authorization Request.

    Note: If the Supplemental Discover (JCB (US Domestic only), and Diners) Cash Over XV06 Record is supplied, the first two bytes of Processing Code must be "09"
    Added On:  12/02/12
    SQL Column:  DS_STAN
    Java Field:  dsStan
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    System trace audit number (STAN).
    Added On:  12/02/12
    SQL Column:  DS_TRACK_DATA_CONDITION_CODE
    Java Field:  dsTrackDataConditionCode
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    Card Track Data Submitted at the Time of Auth. (See page 9-84 for the expected values for this field)
    Added On:  11/05/12
    SQL Column:  DUTY_AMOUNT
    Java Field:  dutyAmount
    Status:  Active
    SQL Type:  varchar(13)
    Java Type:  String
    Attributes:
    Total charges for any import/export duties included in the transaction. Two (2) decimal places are implied.

    Optional for Visa and MasterCard. Not applicable for American Express.
    Added On:  11/05/12
    SQL Column:  DUTY_AMOUNT_INDICATOR
    Java Field:  dutyAmountIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicator used to reflect duty charged on sale.
    Added On:  11/05/12
    SQL Column:  EC_SECURITY_LEVEL
    Java Field:  ecSecurityLevel
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    Electronic Commerce Security Level.

    Must be present if E record Cat indicator = 6
    Added On:  04/06/15
    SQL Column:  EMV_RECORD_TYPE
    Java Field:  emvRecordType
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    Type of EMV record.
    Added On:  11/05/12
    SQL Column:  ENTRY_MODE
    Java Field:  entryMode
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    The POS Entry Mode provided to Discover (JCB (US Domestic only), and Diners) for the authorization

    Bytes 1-2: Discover (JCB (US Domestic only), and Diners) POS Entry Mode

    Byte 3: Discover (JCB (US Domestic only), and Diners) Pin Entry Capability

    Byte 4: RFU (Always zero)
    Note: Only the first 3 bytes are required for settlement processing
    Added On:  11/05/12
    SQL Column:  FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH_FK
    Java Field:  firstDataNashvilleRetailFileBatch
    Status:  Active
    SQL Type:  bigint(20)
    Java Type:  Long
    Attributes:
    Reference to the entity that represents a group of FirstData Nashville Capture Retail Transaction objects that are settled together as a group within a single file.

    During Generation Process, FirstData Nashville Retail File Batch is converted into a settlement file, which is then registered into File Store for further processing.
    Added On:  07/05/16
    SQL Column:  FIRST_DATA_NASHVILLE_RETAIL_ITEM_FK
    Java Field:  firstDataNashvilleRetailItems
    Status:  Active
    SQL Type:  bigint(20)
    Java Type:  Long
    Attributes:
    Reference to the entity that reprents the list of FirstData Nashville retail items.
    Added On:  08/12/13
    SQL Column:  FOLIO_NUMBER
    Java Field:  folioNumber
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    Space filled; Reserved for future use.

    Folio number assigned.
    (Required for Reduced Interchange).
    Must be left justified, and cannot contain all spaces or all zeroes.
    Added On:  11/05/12
    SQL Column:  FREIGHT_AMOUNT
    Java Field:  freightAmount
    Status:  Active
    SQL Type:  varchar(13)
    Java Type:  String
    Attributes:
    Total for freight or shipping and handling charges. Two decimal places are implied.

    Optional for Visa and MasterCard. Not applicable for American Express.
    Added On:  11/05/12
    SQL Column:  FREIGHT_AMOUNT_INDICATOR
    Java Field:  freightAmountIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicator used to reflect if Freight amount is included.
    Added On:  08/12/13
    SQL Column:  GIFT_SHOP_CHARGES
    Java Field:  giftShopCharges
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    9(7) V99 Total amount of gift shop expenses. (Optional) Assume two decimal places for U.S. dollars. Use zeroes when not provided.
    Added On:  11/05/12
    SQL Column:  ID
    Java Field:  id
    Status:  Active
    SQL Type:  bigint(20)
    Java Type:  Long
    Identifier / Primary Key
    Attributes: Unique, Required, CreateOnly, ReadOnly
    Identifier of the object used for references; auto-incremented integer value.
    Added On:  12/02/12
    SQL Column:  INITIAL_AUTH_AMOUNT
    Java Field:  initialAuthAmount
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    This field, which is required for Visa CPS transactions (tran code 5), must contain the amount indicated in the initial authorization request message. This field does not contain a fixed decimal location, since this is determined by the authorization currency code.
    Added On:  06/23/15
    SQL Column:  INSURANCE_CHARGES
    Java Field:  insuranceCharges
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    The list of insurance charges amounts.
    Added On:  06/23/15
    SQL Column:  INSURANCE_INDICATOR
    Java Field:  insuranceIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Insurance indicator.
    Added On:  04/06/15
    SQL Column:  ISSUER_APPLICATION_DATA1
    Java Field:  issuerApplicationData1
    Status:  Active
    SQL Type:  varchar(32)
    Java Type:  String
    Attributes:
    This value is used to send proprietary application data to the issuer in an online transaction.
    Added On:  04/06/15
    SQL Column:  ISSUER_APPLICATION_DATA2
    Java Field:  issuerApplicationData2
    Status:  Active
    SQL Type:  varchar(32)
    Java Type:  String
    Attributes:
    This value is used to send proprietary application data to the issuer in an online transaction.
    Added On:  04/06/15
    SQL Column:  ISSUER_AUTHENTICATION_DATA
    Java Field:  issuerAuthenticationData
    Status:  Active
    SQL Type:  varchar(32)
    Java Type:  String
    Attributes:
    This value contains data sent to the chip card for online issuer authentication.
    Added On:  04/06/15
    SQL Column:  ISSUER_SCRIPT1_RESULTS
    Java Field:  issuerScript1Results
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    This value is used to identify the results of the terminal script processing.
    Added On:  08/12/13
    SQL Column:  LAUNDRY_AMOUNT
    Java Field:  laundryAmount
    Status:  Active
    SQL Type:  varchar(7)
    Java Type:  String
    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/05/12
    SQL Column:  LOCAL_TAX_AMOUNT
    Java Field:  localTaxAmount
    Status:  Active
    SQL Type:  varchar(13)
    Java Type:  String
    Attributes:
    For Visa the amount of state or provincial tax included in the transaction amount. The tax amount must be within 0.1 % and 22% of the transaction amount. Two (2) decimal places are implied and size can be 12 bytes.

    For MasterCard the total amount of sales tax or VAT on the total purchase must be between 0.1% and 30 % of the total transaction amount; zeroes indicate that the card acceptor is capable of transmitting the tax amount and the tax amount is zero. Right justified and zero filled. Two (2) decimal places are implied and size can be 9 bytes maximum.

    For American Express the amount of tax calculated or entered for the transaction. Two (2) decimal places are implied and size can be 12 bytes. **Refer to Conditional Requirement Matrix for further detail.
    Added On:  11/05/12
    SQL Column:  LOCAL_TAX_INDICATOR
    Java Field:  localTaxIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Mandatory for Visa and MasterCard.
    For MasterCard — an indicator used to reflect sales tax capture and reporting.
    Added On:  12/02/12
    SQL Column:  LOCAL_TRANSACTION_TIME
    Java Field:  localTransactionTime
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Merchant‘s local time when the transaction originated. Format HHMMSS. The time sent in this field should match the local time sent in the Authorization Request.
    Added On:  08/12/13
    SQL Column:  LODGING_ARRIVAL_DATE
    Java Field:  lodgingArrivalDate
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    MMDDYY (Gregorian) date of arrival.
    Added On:  08/12/13
    SQL Column:  LODGING_CHARGE_TYPE
    Java Field:  lodgingChargeType
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    This record supply the lodging information, required by American Express, for processing American Express transactions. There must be one "AL1" Record for every Detail Record representing an American Express lodging transaction.

    1 - Lodging
    2 - Restaurant
    3 - Gift Shop

    Note: Must be "1" for Econo-Lodging.
    Added On:  08/12/13
    SQL Column:  LODGING_DEPARTURE_DATE
    Java Field:  lodgingDepartureDate
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    MMDDYY (Gregorian) date of departure.
    Added On:  08/12/13
    SQL Column:  LODGING_DURATION_STAY
    Java Field:  lodgingDurationStay
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    Optional - 2 digit field indicating the duration of stay.
    Added On:  08/12/13
    SQL Column:  LODGING_ROOM_RATE
    Java Field:  lodgingRoomRate
    Status:  Active
    SQL Type:  varchar(5)
    Java Type:  String
    Attributes:
    9(3) V99 Optional - 5 digit field indicating the room rate of the last night of stay. If room rate is greater than 999.99 then zero fill this field.
    Added On:  08/12/13
    SQL Column:  LODGING_SPECIAL_PROGRAM
    Java Field:  lodgingSpecialProgram
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    This record supply the lodging information, required by American Express, for processing American Express transactions.

    1 - If Lodging Charge Type field = 2 or 3, or Lodging Charge Type 1 and none of the other codes below apply.
    2 - ASSURED RESERVATION - NO SHOW - If a customer fails to utilize a room, and the reservation is guaranteed, the customer is billed for one night of stay.
    3 - CARDeposit - Procedure to bill a customer's advance deposit on their charge card.

    Removed options 4 (delayed charge, 5- Express service, and 6- assured reservation (03-2007).
    Added On:  11/05/12
    SQL Column:  MAGNETIC_STRIPE_STATUS
    Java Field:  magneticStripeStatus
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    This field provide the additional data element necessary to meet the requirements for Visa CPS and MasterCard Merit programs.
    Added On:  11/05/12
    SQL Column:  MARKET_SPECIFIC_AUTH_INDICATOR
    Java Field:  marketSpecificAuthIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    This entry is used to indicate that market-specific authorization data was present in the authorization request to Visa‘s VIP system.
    Added On:  11/05/12
    SQL Column:  MARKET_SPECIFIC_DATE
    Java Field:  marketSpecificDate
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    The Market Specific Date Indicator.
    Added On:  12/11/12
    SQL Column:  MASTER_CARD_TRANSACTION_CATEGORY_INDICATOR
    Java Field:  masterCardTransactionCategoryIndicator
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    03 = Healthcare expenses were substantiated real time against an Inventory Information Approval System (IIAS) during authorization.
    Added On:  06/23/15
    SQL Column:  MAXIMUM_FREE_MILES
    Java Field:  maximumFreeMiles
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    Total mileage for the rent period.
    Added On:  11/05/12
    SQL Column:  MERCHANT_ACCOUNT_CODE
    Java Field:  merchantAccountCode
    Status:  Active
    SQL Type:  int(11)
    Java Type:  Integer
    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/05/12
    SQL Column:  MERCHANT_CATEGORY_CODE
    Java Field:  merchantCategoryCode
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    A code that identifies the type of business or services conducted by the service establishment. Also known as Merchant Category Code (MCC). It is used in the warning bulletin, authorization and settlement systems to identify the type of merchant (formerly SIC).

    On a 0400 (Debit/EBT) reversal message, this field must match the original 0200 (Debit/EBT) request.
    Added On:  11/05/12
    SQL Column:  MERCHANT_PURCHASE_REFERENCE_IDENTIFIER
    Java Field:  merchantPurchaseReferenceIdentifier
    Status:  Active
    SQL Type:  varchar(17)
    Java Type:  String
    Attributes:
    For Visa the Customer - used by the customer to identify the purchase (e.g., the invoice number).
    For Visa this field must be 12 digits.
    For MasterCard and American Express the code that facilitates merchant/corporation communication and record keeping.
    For MasterCard this field must be 17 digits.
    For MasterCard Electronic Payment Transactions this value should represent the Invoice Number.

  • Refer to Conditional Requirement Matrix for further detail.
  • Added On:  11/26/14
    SQL Column:  MERCHANT_TAX_ID
    Java Field:  merchantTaxId
    Status:  Active
    SQL Type:  varchar(15)
    Java Type:  String
    Attributes:
    Mandatory for MasterCard. Not applicable for Visa or American Express. The merchant‘s federal tax identification number.
    Added On:  11/05/12
    SQL Column:  MERCHANT_ZIP
    Java Field:  merchantZip
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    The merchant‗s postal/ZIP code must be left-justify and filled if less than 9 bytes.
    This field is left justified, with trailing spaces.

    Note:
    For US (United States): Left-justify and zero-fill.

    For Non-US: Left-justify and space-fill.

    Addresses may vary in length and can include alphanumeric character content. Some addresses do not contain postal codes. In this case, the ZIP code must be space filled.
    Added On:  11/05/12
    SQL Column:  MERCHANT_ZIP_PURCHASE_CARD
    Java Field:  merchantZipPurchaseCard
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    Added On:  08/12/13
    SQL Column:  MINI_BAR_CHARGES
    Java Field:  miniBarCharges
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    9(7) V99 Total amount of bar/mini-bar charges. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
    Added On:  12/16/12
    SQL Column:  NETWORK_ID
    Java Field:  networkId
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Must match authorization response value.
    Added On:  11/05/12
    SQL Column:  NETWORK_REFERENCE_ID
    Java Field:  networkReferenceId
    Status:  Active
    SQL Type:  varchar(15)
    Java Type:  String
    Attributes:
    Discover (JCB (US Domestic only), and Diners) refers to this as an alpha-numeric field, but it is always 15 digits. Send as numeric and do not alter (do not justify left or right).
    Added On:  11/05/12
    SQL Column:  ORDER_NUMBER
    Java Field:  orderNumber
    Status:  Active
    SQL Type:  varchar(15)
    Java Type:  String
    Attributes:
    Used for direct marketing merchants only — order number assigned by the merchant and associated with the transaction.
    Added On:  04/06/15
    SQL Column:  OTHER_AMOUNT
    Java Field:  otherAmount
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    This value is used to indicate a secondary “Cashback” amount associated with the transaction.
    Added On:  08/12/13
    SQL Column:  OTHER_SERVICES_CHARGES
    Java Field:  otherServicesCharges
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    Total amount of other expenses incurred. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
    Added On:  08/12/13
    SQL Column:  OTHER_SERVICES_CODE
    Java Field:  otherServicesCode
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    Indicator to explain the amount that is in the "other services charges" field. (Optional). Value defined by merchant. Use spaces when not provided.
    Added On:  08/12/13
    SQL Column:  PHONE_CHARGES
    Java Field:  phoneCharges
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    Total charges for all calls. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
    Added On:  11/05/12
    SQL Column:  POS_DATA
    Java Field:  posData
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    Space-fill in authorization request message.

    Only if the American Express Indicator on the authorization request message (0100) is an ―X‖, Amex CAPN POS Data field will be returned in the response (0110), otherwise zero-filled.

    On a 0100 capture only transaction, value that corresponds to the transaction. Identifier received in 0110 message needs to be sent.
    Added On:  11/05/12
    SQL Column:  POS_TERMINAL_CAPABILITY
    Java Field:  posTerminalCapability
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicates the POS terminal capabilities for obtaining the data stored on the card.
    Added On:  08/12/13
    SQL Column:  PROGRAM_CODE
    Java Field:  programCode
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    Used to identify special circumstances, such as "no show". (Optional). Value defined by merchant. Use spaces when not provided.
    Added On:  08/12/13
    SQL Column:  PROPERTY_TELEPHONE_NUMBER
    Java Field:  propertyTelephoneNumber
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    Identifies specific property by its local phone number. Include area code, exchange, and number.

    (Required for Reduced Interchange).
    First 3 positions must be numeric
    Added On:  11/05/12
    SQL Column:  PURCHASE_ID_FORMAT
    Java Field:  purchaseIdFormat
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    For Visa the information in the field used by the merchant to identify the purchase (e.g., SKU number).
    For MasterCard the code that the cardholder supplied to the merchant.
    For American Express the customer reference number.
    Added On:  06/23/15
    SQL Column:  RATE_PER_MILE
    Java Field:  ratePerMile
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Total rent amount per mile.
    Added On:  11/05/12
    SQL Column:  RECEIPT_NO
    Java Field:  receiptNo
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    REQUIRED.
    Number provided on debit/EBT receipt.
    Added On:  11/05/12
    SQL Column:  REFERENCE_NUMBER
    Java Field:  referenceNumber
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    Space filled; Reserved for future use.
    Added On:  06/23/15
    SQL Column:  RENTAL_CITY
    Java Field:  rentalCity
    Status:  Active
    SQL Type:  varchar(18)
    Java Type:  String
    Attributes:
    City where the car rental starts.
    Added On:  06/22/15
    SQL Column:  RENTAL_DATE
    Java Field:  rentalDate
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Date when the car rental starts.
    Added On:  06/22/15
    SQL Column:  RENTAL_RETURN_CITY
    Java Field:  rentalReturnCity
    Status:  Active
    SQL Type:  varchar(18)
    Java Type:  String
    Attributes:
    City where the car is returned.
    Added On:  06/22/15
    SQL Column:  RENTAL_RETURN_DATE
    Java Field:  rentalReturnDate
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    Date when the car is returned.
    Added On:  06/22/15
    SQL Column:  RENTAL_RETURN_STATE_COUNTRY
    Java Field:  rentalReturnStateCountry
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    State where the car is returned.
    Added On:  06/23/15
    SQL Column:  RENTAL_STATE
    Java Field:  rentalState
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    State where the car rental starts.
    Added On:  06/23/15
    SQL Column:  RENTAL_TIME
    Java Field:  rentalTime
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    Time when the car rental starts.
    Added On:  06/22/15
    SQL Column:  RENTER_NAME
    Java Field:  renterName
    Status:  Active
    SQL Type:  varchar(20)
    Java Type:  String
    Attributes:
    Name of the person who rented the car.
    Added On:  08/12/13
    SQL Column:  RESTAURANT_CHARGES
    Java Field:  restaurantCharges
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    Total amount of hotel restaurant or room service charges. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided.
    Added On:  11/05/12
    SQL Column:  RESTAURANT_FOOD_AMOUNT
    Java Field:  restaurantFoodAmount
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
    There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
    Added On:  11/05/12
    SQL Column:  RESTAURANT_ID
    Java Field:  restaurantId
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
    There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
    Added On:  11/05/12
    SQL Column:  RESTAURANT_TIP_AMOUNT
    Java Field:  restaurantTipAmount
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
    There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
    Added On:  11/05/12
    SQL Column:  RESTAURANT_TIP_ID
    Java Field:  restaurantTipId
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    Field contains the records supply restaurant charge information, required by American Express, for processing American Express transactions.
    There must be one "OR1" Record for every Detail Record representing an American Express restaurant transaction.
    Added On:  06/23/15
    SQL Column:  RETURN_COUNTRY_CODE
    Java Field:  returnCountryCode
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    Country where the car is returned.
    Added On:  06/22/15
    SQL Column:  RETURN_LOCATION_ID
    Java Field:  returnLocationId
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    Identification code of the place where car was returned.
    Added On:  06/23/15
    SQL Column:  RETURN_TIME
    Java Field:  returnTime
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    Time when the car is returned.
    Added On:  08/12/13
    SQL Column:  ROOM_RATE
    Java Field:  roomRate
    Status:  Active
    SQL Type:  varchar(9)
    Java Type:  String
    Attributes:
    Space filled; Reserved for future use.

    Hotel daily room charge. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided. Required for MC Corp T+E 3 rate
    Added On:  11/05/12
    SQL Column:  SHIP_FROM_ZIP
    Java Field:  shipFromZip
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    The postal or ZIP code of the location from which goods were shipped.

    Optional for Visa and MasterCard. Mandatory for American Express.
    Added On:  11/05/12
    SQL Column:  SPECIAL_CONDITION_INDICATOR
    Java Field:  specialConditionIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Formerly known as MOTO/ECI indicator.

    The MOTO/ECI indicator of 1 is required for all Visa And MasterCard Mail/telephone transactions, regardless of the merchant‘s MCC.
    Added On:  10/05/17
    SQL Column:  SPEND_QUALIFIED_INDICATOR
    Java Field:  spendQualifiedIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Added On:  06/22/15
    SQL Column:  TAX_EXEMPT_INDICATOR
    Java Field:  taxExemptIndicator
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Indicator of the tax extempt.
    Added On:  04/06/15
    SQL Column:  TERMINAL_APPLICATION_VERSION_NUMBER
    Java Field:  terminalApplicationVersionNumber
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    The version number of the installed in the terminal application.
    Added On:  04/06/15
    SQL Column:  TERMINAL_CAPABILITY_PROFILE
    Java Field:  terminalCapabilityProfile
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    This value indicates the card data input, CVM, and security capabilities of the terminal.
    Added On:  04/06/15
    SQL Column:  TERMINAL_COUNTRY_CODE
    Java Field:  terminalCountryCode
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    This field, which is found on the Descriptor (N) record must contain the three-position Terminal Country Code. This value is used to identify the country code where the terminal is located.
    Added On:  04/06/15
    SQL Column:  TERMINAL_SERIAL_NUMBER
    Java Field:  terminalSerialNumber
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    The unique serial number of the terminal. Provided by the creator.
    Added On:  04/06/15
    SQL Column:  TERMINAL_TRANSACTION_DATE
    Java Field:  terminalTransactionDate
    Status:  Active
    SQL Type:  varchar(6)
    Java Type:  String
    Attributes:
    This field, which is found on the Detail and Detail Acknowledgment records, contains the date that the transaction occurred.

    In the 40 & 80 Byte records, the Transaction Date is presented in MMDD format. For Visa Retail Electronic Payment Service (REPS) qualification, the Transaction Date must be within one calendar day of the Authorization Date.
    Added On:  04/06/15
    SQL Column:  TERMINAL_TYPE
    Java Field:  terminalType
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    This value is used to indicate the environment of the terminal, its communication capability, and its operational control.
    Added On:  04/06/15
    SQL Column:  TERMINAL_VERIFICATION_RESULTS
    Java Field:  terminalVerificationResults
    Status:  Active
    SQL Type:  varchar(10)
    Java Type:  String
    Attributes:
    This value indicates the status of the different functions as seen from the terminal.
    Added On:  11/05/12
    SQL Column:  TOTAL_AUTH_AMOUNT
    Java Field:  totalAuthAmount
    Status:  Active
    SQL Type:  varchar(12)
    Java Type:  String
    Attributes:
    Used to submit the Total Authorized Amount in 0400 reversal request message.

    For Capture only transactions, this should reflect the Total Amount authorized.

    For all other message types – Zero fill.
    Added On:  06/23/15
    SQL Column:  TOTAL_MILES
    Java Field:  totalMiles
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    Rented car total mileage.
    Added On:  08/12/13
    SQL Column:  TOTAL_ROOM_TAX
    Java Field:  totalRoomTax
    Status:  Active
    SQL Type:  varchar(7)
    Java Type:  String
    Attributes:
    Hotel daily tax. (Optional). Assume two decimal places for U.S. dollars. Use zeroes when not provided. Required for MC Corp T+E 3 rate.
    Added On:  11/05/12
    SQL Column:  TRANSACTION_AMOUNT
    Java Field:  transactionAmount
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    Amount of transaction.
    Added On:  04/06/15
    SQL Column:  TRANSACTION_CATEGORY_CODE
    Java Field:  transactionCategoryCode
    Status:  Active
    SQL Type:  varchar(11)
    Java Type:  String
    Attributes:
    The category code of the processed transaction.
    Added On:  11/05/12
    SQL Column:  TRANSACTION_CODE
    Java Field:  transactionCode
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Numeric. Transaction code submitted for processing will be returned with each item.
    Added On:  04/06/15
    SQL Column:  TRANSACTION_CURRENCY_CODE
    Java Field:  transactionCurrencyCode
    Status:  Active
    SQL Type:  varchar(3)
    Java Type:  String
    Attributes:
    This value is used to indicate the currency code of the transaction according to the ISO 4217 standard.
    Added On:  11/05/12
    SQL Column:  TRANSACTION_DATE
    Java Field:  transactionDate
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    The date of transaction in format MMDD.
    Added On:  11/05/12
    SQL Column:  TRANSACTION_ERROR_EDIT_CODE
    Java Field:  transactionErrorEditCode
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Space-fill in authorization request message. If there is an error, the Issuer will respond with the 1-byte Transaction Edit Error Code. MasterCard's BankNET system will provide track data validation and POS validation. If the track data contains an edit error, a single one-position alphabetic error code is provided.
    Added On:  11/05/12
    SQL Column:  TRANSACTION_IDENTIFIER
    Java Field:  transactionIdentifier
    Status:  Active
    SQL Type:  varchar(15)
    Java Type:  String
    Attributes:
    Terminal will send X‘20‘ (spaces) in initial authorization message.
    Space-fill in authorization request message.
    Added On:  04/06/15
    SQL Column:  TRANSACTION_SEQUENCE_COUNTER
    Java Field:  transactionSequenceCounter
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    Added On:  04/06/15
    SQL Column:  TRANSACTION_TYPE
    Java Field:  transactionType
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    The type of processed transaction.

    First Data supports the following types of transactions:
    • Autorization only
    • Authorization with Host Capture Settlement
    • Capture only.
    Added On:  12/11/12
    SQL Column:  UCAF_STATUS
    Java Field:  ucafStatus
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes:
    Zero or space fill if non e-commerce transaction.

    0 - UCAF data collection not supported by merchant.
    1 - UCAF data supported by merchant, but UCAF data was not populated.
    2 - UCAF data is supported by merchant and UCAF data was populated.
    Added On:  04/06/15
    SQL Column:  UNPREDICTABLE_NUMBER
    Java Field:  unpredictableNumber
    Status:  Active
    SQL Type:  varchar(8)
    Java Type:  String
    Attributes:
    This value is used to provide variability and uniqueness to the generation of a cryptogram.
    Added On:  11/05/12
    SQL Column:  VALIDATION_CODE
    Java Field:  validationCode
    Status:  Active
    SQL Type:  varchar(4)
    Java Type:  String
    Attributes:
    Space-filled for initial authorization message. The Issuer response will be sent for incremental authorizations and reversals.

    For Visa Transactions, a four-byte code assigned by Visa‘s Authorization System that is used later to determine the accuracy of the authorization data contained in the settlement record. If the authorization request qualifies for REPS and the transaction is approved, the Validation Code is included in the authorization response.
    Added On:  11/05/12
    SQL Column:  VISA_CARD_LEVEL_INDICATOR
    Java Field:  visaCardLevelIndicator
    Status:  Active
    SQL Type:  varchar(2)
    Java Type:  String
    Attributes:
    Supported beginning with Spring release 2007 (04/13/2007), Enforced by Visa by 10/01/2007 for interchange compliance, for each Visa Sale transaction that was electronically authorized. The value to supply in this field is the value that is returned to the merchant in the authorization response message. Space fill for Visa Referral sales, Visa offline sales, All returns and all Non Visa transactions.
    Added On:  06/14/16
    SQL Column:  VISA_SERVICE_DEVELOPMENT
    Java Field:  visaServiceDevelopment
    Status:  Active
    SQL Type:  varchar(1)
    Java Type:  String
    Attributes: