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.
- OTA Channel Manager
- Data model
The tables behind OTA Channel Manager
OTA Channel Manager 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
Stay work
Parties, Reservations and Units identify who is visiting, when and where.
Commercial records
Rate plans, folio charges and Payments describe planned rates and the guest account.
Service work
People and service tasks assign work to a named person and stay.
Outlet evidence
Channel mappings records restaurant or spa bookings linked to a reservation; availability syncs holds outlet charges linked to a reservation.
Access and reference
Users identifies signed-in people; exchange rates stores effective currency rates.
Every table, by feature
- Reservations3
- Guests and units3
- Rates and outlet bookings3
- Folio and payments4
- Service work4
- Operational review5
- Shared and settings2
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Parties
Guests, groups, companies and other booking parties.
- Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Parties
Guests, groups, companies and other booking parties.
- Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units
- Rate plans
Dated nightly rate plans by unit type with minimum stay rules.
- Channel mappings
Restaurant or spa bookings recorded against a reservation with outlet, start time and guest count.
Linked to Reservations - Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units
- Folio charges
Guest folio charges for a reservation, draft through posted or voided.
Linked to Reservations - Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Reservations - Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Availability syncs
Outlet charges recorded against a reservation with their amount, date and posting status.
Linked to Reservations
- Service tasks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Units, People, Reservations - People
Staff members who own and are assigned hospitality service work.
Linked to Users - Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units
- Reservations
Stay and resource bookings with arrival, departure, party size and nightly rate.
Linked to Parties, Units - Units
Bookable inventory: rooms, suites, venues, tables, treatment rooms and other resources.
- Folio charges
Guest folio charges for a reservation, draft through posted or voided.
Linked to Reservations - Payments
Guest payments received against a reservation, pending through confirmed or refunded.
Linked to Reservations - Service tasks
Housekeeping, maintenance and guest service work assigned to staff for a unit and reservation.
Linked to Units, People, Reservations
Keys and references
A reservation references its Guest and Unit. Charges, payments, outlet bookings and service tasks each reference the reservation. Service tasks also reference the unit and assigned person; a person references a user. Preserve these links during imports so a later shift can follow the same guest journey.
Migration order
- Bring in Users and People, then Parties and Units.
- Enter rate plans and review their effective dates.
- Import Reservations with their guest and unit links.
- Add outlet bookings, service tasks, charges and payments with reservation links.
- Reconcile states and inspect the first operating cycle.
Set up OTA Channel Manager your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.