R_Sitn2DemoFlight

Flights for Situation Demo | view: RSITN2DFLIGHT | TRAN | Extraction: Not supported | Component: Situation handling: Situation Engine
Tables used: SIT2_DEMO_FLIGHT
Column Name Description
SitnDemoCarrierID FK Airline Code
SitnDemoConnectionID FK Flight Connection Number
SitnDemoFlightDate Flight date
Column Name Description
💲 Local currency of airline (SitnDemoCurrency):
SitnDemoPrice Airfare
Column Name Description
Column Name Description
SitnDemoFlightDate Flight date
Column Name Description
Column Name Description Domain name
SitnDemoFlightUniqueKey Unique Flight Key
SitnDemoTitle Title for Demo Entities
SitnDemoFlightIsScheduled Flight Schedule Status
SitnDemoPlaneType Aircraft Type
SitnDemoSeatsMaxQty Maximum Capacity in Economy Class
SitnDemoSeatsOccupiedQty Occupied seats in economy class
SitnDemoSeatsMaxBusClQty Maximum Capacity in Business Class
SitnDemoSeatsOccupiedBusClQty Occupied seats in business class
SitnDemoSeatsMax1stClQty Maximum Capacity in First Class
SitnDemoSeatsOccupied1stClQty Occupied seats in first class
Master Data Relations Join Conditions
Airline Code
  • ?
  • Airline Code
Flight Connection Number
  • Flight Connection Number
  • ?
  • Airline Code
Other Relations | to Master Data Relations ↑ Join Conditions
Local currency of airline R_SITN2DEMOFLIGHT.SITNDEMOCURRENCY == SCURX.CURRKEY