This reference guide provides a comprehensive list of all available Itineraries data fields in Report Builder, including column names and detailed descriptions of what each field contains. Use this article to understand which Itineraries 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.
Itineraries
| Column Name | What It Means |
| ControlID | Unique identifier for the control/VC |
| ItineraryID | Unique trip/reservation identifier |
| GuestID | Which guest made this booking |
| Confirmed | Is itinerary confirmed? (1 = Confirmed by operator, 0 = Pending) |
| Closed | Is itinerary paid in full? (1 = Fully paid/closed, 0 = Balance owing (Paid in database)) |
| TotalCost | Total amount for entire itinerary |
| TotalPaid | Total amount paid so far |
| TotalDue | Outstanding balance |
| SourceID | Internal source identifier |
| Source | How guest found you |
| SourceURL | Specific URL if online booking |
| Affiliate | Affiliate partner code |
| BookedBy | Name of person who made booking |
| BookingLocation | Where booking was made |
| MasterLocation | Master location reference |
| EventName | Event name (if event booking) |
| InternalNotes | Private staff notes |
| BookingMetaData | Technical metadata |
| AccountingSystemCode | Accounting software reference |