I_Sitn2DemoFlight

Flights for Situation Demo | view: ISITN2DFLAP | Extraction: Not supported | Component: Situation handling: Situation Engine
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
SitnDemoEconomyClSoldAmount null
SitnDemoBusClSoldAmount null
SitnDemo1stClSoldAmount null
SitnDemoCurrentSoldAmount Airfare
SitnDemoMaxSoldAmount Airfare
SitnDemoSalesDiffAmount null
SitnDemoSlsDiffEconomyClAmount null
SitnDemoSalesDiffBusClAmount null
SitnDemoSalesDiff1stClAmount null
SitnDemoBusClPrice null
SitnDemo1stClPrice null
Column Name Description
Column Name Description
SitnDemoFlightDate Flight date
Column Name Description
SitnDemoCarrierRegion Region ID Show values
Column Name Description Domain name
SitnDemoFlightUniqueKey Unique Flight Key
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
SitnDemoLuggageWgtRatio null
SitnDemoLuggageWgtChtRatio null
SitnDemoOccupiedSeatsRatio null
SitnDemoOccupiedSeatsChtRatio null
SitnDemoSeatOccpcyEconomyRatio null
SitnDemoSeatsOccpcyBusClRatio null
SitnDemoSeatsOccpcy1stClRatio null
SitnDemoSalesRatio null
SitnDemoEconomyClSalesRatio null
SitnDemoBusClSalesRatio null
SitnDemo1stClSalesRatio null
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 I_SITN2DEMOFLIGHT.SITNDEMOCURRENCY == SCURX.CURRKEY