Report Summary
Data table and CSV export of the component data of itineraries. It exposes the analytics raw data of components (i.e., travel services of itineraries) of booked, cancelled, and requested itineraries. Components of itineraries in planning (status "Open") are excluded and never exposed by this report.
Data Update Frequency
Daily, between 2am and 6am CET
Note that the data provided in this view is not live data, but consolidated and normalized data that is synced daily from the application's database into the data warehouse and then processed by the data pipeline. As a result, the most recent data changes may not yet be available in the data exposed here.
Report Details
General
COMPONENT_ID: the technical ID Of the component.
COMPONENT_STATUS: the status of the component. This is a normalized status. States of connected supply is mapped to a set of Nezasa's defined states. When the itinerary is not booked yet, the status might be empty.
COMPONENT_TYPE_SIMPLIFIED: the component type.
IS_ADHOC_COMPONENT_YESNO: 'yes' if it is an ad-hoc component, 'no' otherwise.
PRODUCT_NAME: the product name. For transports, it may be derived from th start/end location.
PRODUCT_REF_ID: the product ref ID. Please note that for connected supply, this may be a technical long string because not all connected supplier provide a unique product ID TripBuilder can use.
SERVICE_CATEGORY: the selected price category.
INSTANTIATED_AT: when the component was created from the source (be it inventory, or checked in the supplier system).
START_DATE/TIME: the start date/time of the component.
END_DATE/TIME: the end date/time of the component.
Location
START_LOCATION_STREET: the street of the start location. In case of airports, it is the airport name and IATA code.
START_LOCATION_POSTAL_CODE: the postal code of the start location.
START_LOCATION_CITY: the city of the start location.
START_LOCATION_COUNTRY_CODE: the 2-letter ISO country code of the start location.
END_LOCATION_STREET: the street of the start location. In case of airports, it is the airport name and IATA code.
END_LOCATION_POSTAL_CODE: the postal code of the start location.
END_LOCATION_CITY: the city of the start location.
END_LOCATION_COUNTRY_CODE: the 2-letter ISO country code of the start location
Remark "Location": not all component types have location information. E.g., base services, generic ad-hoc components, or upsell items don't have it. Furthermore, some components might only have only a start location which represents the "main location" in that case, e.g., accommodations.
Flight-Specific Columns
AIRLINE_CARRIER_CODE: carrier code of the first flight segment.
AIRLINE_TRANSPORT_NUMBER: flight number of the first segment.
AIRLINE_OPERATING_CARRIER_CODE: carrier code of the operating carrier of the first flight segment.
AIRLINE_OPERATING_TRANSPORT_NUMBER: flight number of the operating carrier of the first flight segment.
Pricing
USER_SALES_PRICE_CURRENCY: the user's sales price currency.
USER_SALES_PRICE_AMOUNT: the amount of the sales price in the user's sales price currency.
SALES_PRICE_CURRENCY: the sales price currency (before conversion into the user's buying currency).
SALES_PRICE_AMOUNT: the sales price amount (before conversion into the user's buying currency).
NET_PRICE_CURRENCY: the net price currency.
NET_PRICE_AMOUNT: the net price amount.
COMMISSION_VALUE_CURRENCY: the currency of the commission.
COMMISSION_VALUE_AMOUNT: the travel agency commission amount for component-level booking commissions. Cancellation commissions and itinerary-level commission are not supported. Note: the field is only populated for bookings created from Jan 30, 2025 onwards.
SUPPLIER_CANCELLATION_FEE_AMOUNT: the cancellation fee amount as returned by the connected supply system. Empty for inventory components
SUPPLIER_CANCELLATION_FEE_CURRENCY: the cancellation fee currency as returned by the connected supply system. Empty for inventory components
CANCELLATION_POLICY_LABEL: possible values are "Free Cancellation", "Partially Refundable", "Non-Refundable", or no value in case no label could been derived (e.g., due to missing cancellation policy details). The label is in reference to the booking date of the component. The field is currently only supported for accommodation components.
Supply
SUPPLIER_COMPONENT_STATUS: the status of the component as provided by the connected supplier.
SUPPLIER_CONFIRMATION_NUMBER: the component's confirmation number as provided by the supplier.
SUPPLIER_SOURCE: the supplier system.
SUPPLIER_NAME: the supplier name (might be the sub-supplier in case of connected supply).
SUPPLIER_FULLNAME: a concatenation of supplier system and name.
Itinerary
ITINERARY_REF_ID: the reference ID of the component's itinerary.
ITINERARY_STATUS: the (technical) status of the component's itinerary.
ITINERARY_STATUS_SIMPLIFIED: a simpler version of the itinerary status which maps all states to more high-level states (Open, BookingCompleted, Cancelled, Deleted, BookingRequested).
Tour Operator, Distribution Channel, Travel Agency
TOUR_OPERATOR_COMPANY_REF_ID: the reference ID of the tour operator (equals to the reference ID of the TripBuilder instance).
DISTRIBUTION_CHANNEL_REF_ID: the reference ID of the distribution channel of the component's itinerary.
TRAVEL_AGENCY_REF_ID: the reference ID of the travel agency of the component's itinerary.
TRAVEL_AGENCY_SHORT_NAME: the name of the travel agency of the component's itinerary.
TRAVEL_AGENCY_COOPERATIVE_NAME: the name of the cooperative the travel agency belongs to.
TRAVEL_AGENT_FIRST_NAME: the travel agent's first name of the component's itinerary.
TRAVEL_AGENT_LAST_NAME: the travel agent's last name of the components's itinerary.
Change History
2026-02-24: Added airline_* fields to cover for the (operating) carrier code and flight number.
2026-02-13: Added new field CANCELLATION_POLICY_LABEL which classifies the cancellation policy (if known) in reference to the booking date as non-refundable, partially refundable, or free cancellation. The field is currently only supported for accommodation components.
2025-12-17: Resolved an issue causing ad-hoc activities/hotels/transports not being listed.
2025-12-17: Added filters for Itinerary ID and component product name.
2025-05-26: Added start/end time.
2025-05-01: Various refinements based on first tests.
2025-02-19: Added the sales price in the user's buying currency.
2025-01-31: Added agency commission (fields COMMISSION_*). Note: the field is only populated for bookings created from Jan 30, 2025 onwards.
2025-01-28: Added instead START_LOCATION_* and END_LOCATION_*, and removed LOCATION_*.
2025-01-25: Added documentation per column (see this documentation tab).
2025-01-25: Added travel agent cooperative, supplier name for inventory managed suppliers, cancellation fees for connected supply.
2025-01-25: Added simplified itinerary status and simplified component type.
2025-01-24: Added travel agent first and last name, as well as travel agency short name.
2025-01-13: Published initial draft.