These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Tour Operator Software
- Data model and import order
The tables behind Tour Operator Software
Tour Operator Software ships with 12 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 12
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Tour packages:
Tour packages. Packages built on the trip that delivers them.
Bookings:
Tour bookings, Parties. Customer bookings for a package and departure.
Trips and dispatch:
Trips, trip stops. Trips with vehicle, driver and ordered stops.
Fleet and drivers:
Vehicles, People, Users. Vehicles with capacity; staff linked to logins.
Trip completion and documents:
Delivery evidence, transport documents. Completion proof and trip paperwork.
Charges and settings:
Trip charges, exchange rates. Charge lines per trip and effective exchange rates.
Every table, by feature
- Tour packages2
- Bookings3
- Trips and dispatch4
- Fleet and drivers3
- Trip completion and documents4
- Charges and invoicing3
- Shared and settings1
- Tour packages
Sellable tour packages built on an operational trip record.
Linked to Trips - Trips
Planned and executed transport trips with customer, vehicle and driver.
Linked to Parties, Vehicles, People
- Tour bookings
Customer bookings against a tour package with departure and travelers.
Linked to Tour packages, Parties - Tour packages
Sellable tour packages built on an operational trip record.
Linked to Trips - Parties
Customers, carriers and providers the operator trades with.
- Trips
Planned and executed transport trips with customer, vehicle and driver.
Linked to Parties, Vehicles, People - Trip stops
Ordered stops on a trip with planned and actual arrival times.
Linked to Trips - Vehicles
Fleet vehicles available for tour and transfer operations.
- People
Staff and drivers who operate tours and transport for the operator.
Linked to Users
- Vehicles
Fleet vehicles available for tour and transfer operations.
- People
Staff and drivers who operate tours and transport for the operator.
Linked to Users - Users
Users
Linked to Users
- Delivery evidence
Proof of delivery captured at the end of a trip.
Linked to Trips - Trip stops
Ordered stops on a trip with planned and actual arrival times.
Linked to Trips - Transport documents
Trip paperwork such as manifests, permits and inspection records.
Linked to Trips, People - Trips
Planned and executed transport trips with customer, vehicle and driver.
Linked to Parties, Vehicles, People
- Trip charges
Charge lines raised against a trip for billing.
Linked to Trips - Trips
Planned and executed transport trips with customer, vehicle and driver.
Linked to Parties, Vehicles, People - Parties
Customers, carriers and providers the operator trades with.
Keys and references
Packages reference their trip; bookings reference package and customer. Trips reference customer, vehicle and driver; stops, evidence, documents and charges reference the trip. People reference their user account. Keep vehicle numbers and package names stable and import by them.
Migration order
- Load Users and People, then Vehicles.
- Load Parties for customers, carriers and providers.
- Load Trips that deliver your packages, then tour packages.
- Load upcoming tour bookings.
- Load open trips with their trip stops and trip charges, then reconcile and test permissions before go-live.
Set up Tour Operator Software your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.