Report Summary
Data table and CSV export of the travel agency data. The report provides the core dataset of travel agencies, including basic identifiers, company association, cooperative affiliation, and external reference details.
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
TRAVEL_AGENCY_REF_ID: the reference ID for the travel agency, used for integrations and referencing in related systems.
SHORT_NAME: the usual short name of the travel agency.
LEGAL_NAME: the official legal name of the travel agency.
IS_REFERRER: indicates if the agency serves as a referring agency (1 for "true", 0 for "false").
IS_ACTIVE: denotes whether the travel agency is active (1 for "true", 0 for "false").
COOPERATIVE_NAME: the name of the travel agent cooperative the agency belongs to, if any.
EXTERNAL_REFERENCES: a comma-separated list of external system references associated with the agency, such as "Excel:12341334, Midoco:1a2b3c".
Company & Channel
COMPANY_REF_ID: the reference ID of the tour operator company associated with the travel agency.
DISTRIBUTION_CHANNEL_REF_ID: the ID of the distribution channel that the agency is part of.
Record Info
CREATED: the timestamp when the travel agency record was created.
MODIFIED: the timestamp when the travel agency record was last modified.
Change History
2025-05-26: Initial version.