This reference guide provides a comprehensive list of all available Bookings data fields in Report Builder, including column names and detailed descriptions of what each field contains. Use this article to understand which Bookings 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.
Bookings
| Column Name | What It Means |
| ControlID | Which Visitor Centre/Park |
| BookingID | Unique booking item number |
| OperatorID | Which operator provides this service |
| ItineraryID | Groups bookings into one trip/reservation |
| BookingDate | When the reservation was mad |
| DueDate | When payment is due |
| ArrivalDate | Check-in or activity start date |
| DepartureDate | Check-out or activity end date |
| ExpiryDate | When voucher/booking expires |
| FollowUpDateAEST | When to follow up with guest |
| Cost | Total amount for this booking |
| CostNet | Net amount after agent commission |
| GST | Tax/GST amount |
| Outstanding | Amount still owed |
| Paid | Amount already paid |
| CommissionPercentage | Operator commission rate |
| CommissionPaid | Commission paid to operator |
| CommissionTaken | Commission kept by control/VC |
| ExpectedCommissionPaid | What should be paid to operator |
| ExpectedCommissionTaken | What should be kept by VC |
| AgentCommission | Commission owed to travel agent |
| AgentCommissionPercentage | Travel agent commission rate (Shown as a decimal) |
| PaxAdults | Number of adults |
| PaxChildren | Number of children |
| PaxInfants | Number of infants |
| PaxConcessions | Number of concession guests |
| PaxStudents | Number of students |
| PaxObservers | Number of observer (Non-participating guests) |
| PaxTotals | Total number of guests |
| PaxDescription | Readable pax breakdown |
| PaxNames | Names of all guests |
| Status | Current booking status |
| Cancelled | Is this booking cancelled? |
| Type | Type of booking |
| ShouldBe | Expected status based on dates |