The database includes multiple user-defined tables for managing all aspects of the reservation process.
Selected tables can be updated via xml interfaces with suppliers.

XML Suppliers:

Database includes supplier definitions as well as cross-tables (translating between supplier and internal codes).
Dynamic update of database via background communications between database and supplier.

Local Suppliers:

Database includes supplier data as well as prices and policies (cancellations, etc.)

Special customization of website tables include: preferred products, preferred hotels, room arrangements, special remarks, search management and priorities, price ranges, locations and proximate locations.

• Agency Information
• Commissions
• Multiple price-lists allowing for specialized mark-ups for specific agencies or chains as well as time-periods
• Definitions for bookkeeping/financial management system
• Permissions and security for website

• Supplier information and policies
• Multiple price-lists allowing for specialized mark-ups for specific agencies or chains as well as time-periods
• Internal codes for supplier as used in suppliers website
• User-defined file input utility for input/update of supplier price lists
• Module for input and checking of supplier invoices against dockets
• Payment orders to suppliers including update of bookkeeping system

XML Suppliers workflow:

XML communications from suppliers collect data in real-time (prices, availability, remarks). Cross tables allow for translation from supplier codes to e-TOPS system codes.

• Reservation sent to supplier as xml request
• Supplier sends real-time response xml response
• If reservation status is OK, notification is automatically sent to the customer

If reservation status returns as “request”, an automatic scheduler continues to check with the supplier for a change of status. If the reservation status does change, the system automatically updates the new status. If the status is now OK, notification is automatically sent to the customer. If the status returned is SO (sold out), notification is not sent automatically, allowing the back office to handle the reservation.

Local Suppliers workflow:

• Suppliers price list input to system
• Reservations sent to supplier in accordance with supplier definitions: email, html, URL or fax. (html & URL options include automatic update of status upon receipt of OK from supplier)
• On change of reservation status to OK notification is sent automatically to the customer
• On change of status to SO (sold out), notification is not sent automatically, allowing the back office to handle the reservation.

• Hotel Information including: Name, address, rooms, facilities, contact, description, location
• Automatic input of hotel from supplier xml – with final approval and internal hotel code given by e-TOPS user
• Hotel pictures
• Link to google map (based on coordinates stored in database)
• Data can be updated through supplier xml and displayed in different languages, as provided by supplier
• Room arrangements available in hotel
• Price lists (local suppliers only) – managed per hotel/supplier and time period. Includes types of customers,  currency, room type, board arrangement, weekend days, cancellation policy, special conditions, valid dates, gross and net prices for weekdays and weekends, additional meals, additional services.
• Validity conditions for price list: includes minimum and maximum nights, bonus (free) nights, permitted check-in days
• Automatic price changes for range of hotels/suppliers/dates
• Date ranges of “closed-out” days for hotel
• Quick update of hotel data – for multiple price lists

Room Allocations

The system supports three types of allocations: allotment, free sale and commitment.

Free sale: requires immediate transmission of reservation to supplier

Allotment: bank of rooms allocated.  Report to supplier per reservation not required.  Reservations transmitted in bulk on release date.

Commitment: Commitment to purchase rooms, regardless of reservations.

Allotment definitions include release conditions.

Module includes Allotment Query displaying rooms allotted per hotel/supplier and range of dates.

Function for room release for range of hotels/suppliers and dates

Occupancy report for supplier

Occupancy report for back office (itemized or totals) per hotel/supplier/date range.

Flight Information: input and update of single flights or a series of flights including dates, weekdays available, flight number, route, airline, departure and arrival times.

Seat Control:

• Input, control and management of seats on flights
• Define quantities of seats per flight, cabin and class of service
• Supports nested classes
• Purchase seats from different suppliers per flight or group of flights
• Sell seats to different customers per flight or group of flights
• Overbooking definitions – per cabin
• Waiting list definitions – per class
• Transfer passengers between flights
• Passenger Lists

Flight Price Lists:

• Price Lists per supplier, flight and date range
• One way and round trip prices per passenger type
• Taxes per passenger type
• Fare Bases
• Validity per point of sale

Define additional services including: excursions, attractions, sight seeing, villas, transfers, car rentals and special services.

Price Lists for Other Services:

• Price lists per service and supplier
• General data including currency, type of item, date range, gross and net prices
• Car Rentals – supports upgrades and additions

Allocations for Other Services:

Optional definition of allocations for selected services per supplier, item type, item and date range.

Module supports multiple package types such as: Fly & Drive; Flight & Hotel; Fly, Drive and Sleep; Spa; Ski; Package Tour.

Package definitions include description, currency, status, type, currency exchange rates, destinations and remarks.

Modular definition utility allows unlimited combinations of flights, hotels and other services.  Supports functions for automatic calculation of gross price per service, based on algorithm from net price.

Flexible packages allow customer selection of hotel and or car rental from a pre-defined list.

Package Reservation

User-friendly query allows simple selection of package from range of packages available for selected dates and destinations.

Package reservation includes automatic notification to both suppliers and customers, documentation, billing and account tracking with supplier and customer.

Reservation Utilities:

Search for reservation by customer, status, destination, dates with entry to individual docket for update.

Manage reservations queues by status – for example, all dockets with status “sold out” or “request”.

Notification utility for sending messages to suppliers or customers for a selected group of reservations.

Invoice Builder

Builds invoices and automatically updates the bookkeeping system.

• Locate products by location
• Locate dockets: by dates, name, agency, type of service, service
• Price List Query
• Hotel allocations and reservations by date
• Agency Query
• Suppliers Query
• Incomplete Reservations (warning report)
• Sales reports with multiple sort, filter and aggregate functions
• Hotel Query by city or country
• Hotel Allocations by hotel or supplier for range of dates
• Passenger Lists
• Accounting reports for agencies
• Reservations per supplier
• Prices per hotel and supplier
• Reservations per agent

In addition to pre-structured reports, the system includes a built-in report generator, allowing myriad cut and sort features per docket, supplier, customer, product, etc.  Seamless transfer to excel, PDF file or email.  Create sales reports by agency, agent, chain, reservation clerk, source of reservation (Internet, xml, agency).  Purchase reports by supplier, product, destination.  Profitability reports per agency, supplier, service, product, etc.