The following data model changes have been made in support of VBT requirements for Planner 2.0 and Booking 2.0. These data model changes were made in advance in order to allow VBT to start their data importing without having to wait for front end.


Price entity

  • Include Price
    • 1:x relationship between price and price
    • Purpose:  Users have the ability to select multiple prices to be grouped together for a single display in the booking in the Base Price Options step. When the price is booked, all services associated to the booked price and to the included prices are included in the booking, the itinerary, and actuals.  
  • Transfer Date
    • Integer
    • Purpose: Users have the ability to associate a date to the price. The value entered will be used in the RightRez Booking Engine logic for matching booked flights to booked transfers   
  • Transfer Airport
    • Text
    • Purpose: Users have the ability to associate a 3 character airport code to the price. The value entered will be used in the RightRez Booking Engine logic for matching booked flights to booked transfers   
  • Bundle on Invoice
    • Boolean
    • Purpose: Users have the ability to bundle the air city price amount with an air package price amount

Price Rate

  • Primary Gateway
    • Boolean
  • Airport
    • Lookup to Airports
  • Base Cost
    • Currency