SAIRPORT – master data table with name and time zone information for airports
SAPLANE – master data table with information about plane types, e. g. number of seats,
weight, tank capacity, and operating speed
SBOOK – fact table containing all flight bookings and their details like date of flight, flight
number, price, customer ID, and ID of the travel agency that sold the ticket.
SBUSPART – master data table with information about business partners
SCARR – master data table with some airline information (name, currency, URL)
SCURR – table with currency conversion factors
SCURX – per-currency number of decimals used to display currency values
SCUSTOM – master data table containing information about passengers
SDESSERT – master data table with information about the desserts available during flights
SFLIGHT - master data table containing per-flight information, e. g. date, price, plane type,
seats
SMACOURSE – master data table with information about the main courses available during
flights
SMEAL – master data table with information about the meals available during flights
SMEALT – master data table with information about the meals in various languages
SMENU – master data table with information about the available combinations of meals
SSTARTER – master data table with information about the main courses available during
flights
STICKET – fact table which contains information about the tickets issued at the airports
STRAVELAG – master data table containing information about travel agencies
No comments:
Post a Comment