This reference guide provides a comprehensive list of all available Booking Nights data fields in Report Builder, including column names and detailed descriptions of what each field contains. Use this article to understand which Booking Nights fields are available when building custom reports, what information each field represents, and how to select the right fields for your reporting needs. This resource helps you make informed decisions when configuring reports and ensures you're pulling the correct data.
Booking Nights
| Column Name | What It Means |
| BookingID | Unique booking reference number |
| ItineraryID | The itinerary/trip this booking belongs to |
| BookingDate | When the booking was created |
| ControlID | Which Visitor Centre/Park |
| OperatorID | Which accommodation operator |
| ProductID | Which room type was booked |
| ProductType | Type of product |
| UnitID | Specific unit/cabin/room number |
| ArrivalDate | Check-in date for the booking |
| DepartureDate | Check-out date for the booking |
| StayDate | THE SPECIFIC NIGHT (Each individual night- row per night) |
| Day | Day of month |
| Month | Month number |
| Year | Year |
| DayOfWeek | Day name |
| MonthOfYear | Month name |
| Adults | Number of adults on this booking |
| Children | Number of children on this booking |
| Infants | Number of infants on this booking |
| TotalPax | Total number of guests |
| TotalCost | Total booking cost (not per night) |
| NightCostEstimate | Estimated cost per night (TotalCost ÷ NumberOfNights) |
| NumberOfNights | Total nights in booking |
| AccountingSystemPurchaseOrderCode | Purchase order number |