Enhanced Data Report - Lodging
Introduction
The Enhanced Data Report – Lodging provides enriched lodging transaction data derived from card scheme clearing records. The dataset includes additional Level 2 and Level 3 data elements related to lodging transactions, such as property and stay-related information.
This page describes the structure and field-level specifications of the Lodging Enhanced Data Report.
File repository path: Enhanced Data/Lodging/Daily
File name pattern: Enhanced_Data_Report_Lodging_YYYY-MM-DD.csv.csv
Report frequency: Daily
📘 NOTE
The presence of Enhanced Data (Level 2 and Level 3), data elements is dependent on the merchant submitting this information to the card scheme. Consequently, data may not be available for all transactions, and not every settlement record will contain Level 2 or Level 3 fields.
Transaction Report
| Field | Description | Mandatory/Conditional |
|---|---|---|
| community | The name of the community to which the client belongs, as configured in Nium. | Mandatory |
| client | The name of the client, as configured in Nium. | Mandatory |
| transactionId | A unique transaction identifier that can be used to link to the settlement transactions provided in other reports | Mandatory |
| transactionDate | System defined inked to original Settleent transaction I n ISO 8601 in Format as: yyyy-MM-dd'T'HH:mm:sssZ | Mandatory |
| scheme | Payment network that can be either of VISA, Mastercard, Discover, UATP | Mandatory |
| transactionType | Describes the transaction type. PURCHASE, MERCHANT REFUND, PURCHASE REFUND | Mandatory |
| customerCode | Customer account identifier. Supported Schemes: Mastercard. | Optional |
| destinationCountry | Country of hotel property. Supported Schemes: Mastercard. | Optional |
| bookingDate | The date the booking was made. Supported Schemes: Mastercard. ISO 8601 format: YYYY-MM-DD | Optional |
| folioNumber | Contains the hotel internal invoice or billing ID reference number. Supported Schemes: Mastercard, Discover. | Optional |
| hotelName | Property name. Supported Schemes: Mastercard. | Optional |
| guestName | Name of Guest for the Hotel stay. Supported Schemes: Discover. | Optional |
| tollFreeNumber | Contains the hotel service phone number used to resolve stays questions and disputes. Supported Schemes: Mastercard. | Optional |
| propertyPhoneNumber | Identifies specific lodging property location by its local phone number. Supported Schemes: Mastercard. | Optional |
| lodgingNoShowIndicator | An indicator that the cardholder is being billed for a reserved room that was not actually rented (AKA a “no-show” charge). Supported Schemes: VISA. | Optional |
| checkInDate | The date the customer checked into the hotel, or in the case of a no-show or an advance lodging, the scheduled arrival date. Supported Schemes: Mastercard, VISA, Discover. ISO 8601 format: YYYY-MM-DD | Optional |
| checkOutDate | Departure date for the Hotel Booking. Supported Schemes: Mastercard, Discover. ISO 8601 format: YYYY-MM-DD. | Optional |
| roomType | Type Of Room. Supported Schemes: Discover. | Optional |
| roomNights | Number of nights being billed. Supported Schemes: Mastercard, VISA. | Optional |
| dailyRoomRate | Daily rate being charged for the room. Supported Schemes: VISA, Discover. | Optional |
| totalRoomAmount | Total Room Amount for the Number of Room Nights. Supported Schemes: Mastercard. | Optional |
| totalRoomTax | Total room tax being billed. Supported Schemes: Mastercard, VISA, Discover. | Optional |
| totalTaxCollectedIndictor | Reflects total sales tax capture and reporting information such as whether sales tax was included in the amount or if services were not taxable. Supported Schemes: Mastercard. | Optional |
| taxExemptIndicator | Provides the indicator noting whether the services were tax-exempt or tax was not collected Supported Schemes: Mastercard. | Optional |
| prePaidExpenses | Any prepaid expenses being billed. Supported Schemes: VISA, Discover. | Optional |
| foodBeverageCharges | All food and beverage charges. Supported Schemes: Mastercard, VISA, Discover. | Optional |
| folioCashAdvances | Any Folio cash advances being billed. Supported Schemes: VISA, Discover. | Optional |
| lodgingExtraCharges | This field may be used to indicate the type of additional charges added to a customer's bill after check-out. Supported Schemes: VISA. | Optional |
| discountAmount | Contains the discount. Supported Schemes: Mastercard. | Optional |
| discountIndicator | Contains the type of discount. Supported Schemes: Mastercard. | Optional |