Pricing Schema

Pricing schema is defined for a service (or package). The prices are defined according to the pricing period which shows the dates the schema is valid and the pricing domains.

A pricing period defines the active periods of the defined pricing schemas. There can be any number of pricing periods defined within one agreement. It also possible to clone a schema under a pricing period to another period easily.

Every pricing period contains at least one pricing domain and each pricing domain has a pricing schema attached to it. There can be any number of pricing domains defined under a pricing period. It is not mandatory to enter an apply condition for a default domain, but if there are basic common conditions where the prices differ accordingly, it is better to define them as pricing domain conditions than to repeat the same condition in every line of the pricing schema. Pricing domain is the first place when trying to find a price for a service (or package). The first apply condition satisfied at the domain level specifies the domain to be used and calculation uses the pricing schema of that domain.

Prices can be defined using nested IF sequences. To define a nested IF sequence, prev seq must point the seq for the containing IF.

A price is unit price * coefficient * service quantity in the service charge form. A unit conversion will take place if the unit in the service charge is not the same unit indicated here. A price can be given as royalty included/excluded and/or VAT (value added tax) included/excluded.

For formula parsing, the open source JEP mathematical expression parser is used. There are a plenty of predefined formula variables and functions. However, any information that is being tracked by Celebris can be added as a function or variable depending on its nature.

Variable	Description	Type
PAXarr	Arrival flight passenger count	Numeric
PAXdep	Departure flight passenger count	Numeric
PAXin	Inen yolcu sayisi	Numeric
PAXout	Outgoing passenger count	Numeric
PAXTransit	Number Of Transit Passengers	Numeric
PAXTransit	Number Of Transit Passengers	Numeric
PckHasTrf	True if Traffic service is given within this package.	Booelan
PckHasTrf	True if Traffic service is given within this package.	Booelan
BLOF	Blocks Off Time for the outgoing flights	Datetime
RoyLegs	Number of Legs, returns 2 for true one leg flights after flight merge	Numeric
RoyLegs	Number of Legs, returns 2 for true one leg flights after flight merge	Numeric
RoySvcTotQtyLT	Total Quantity of the services causing a Royalty in one SCF in Liters	Numeric
RoySvcTotQtyLT	Total Quantity of the services causing a Royalty in one SCF in Liters	Numeric
ScfHasExtrRmp	True if there are more than one RMP services defined in SCF	Booelan
ScfHasExtrRmp	True if there are more than one RMP services defined in SCF	Booelan
ScfHasExtrTrf	True if there are more than one TRF services defined in SCF	Booelan
ScfHasExtrTrf	True if there are more than one TRF services defined in SCF	Booelan
STA	Arrival Flight Scheduled Time of Arrival	Datetime
STD	Departure Flight Scheduled Time of Departure	Datetime
SvcQty	Service quantity	Numeric
SvcQty	Service quantity	Numeric
SvcTime15Min	Service time in 15 minutes	Numeric
SvcTime15Min	Service time in 15 minutes	Numeric
SvcTime15Min2Hr	Service time in 15 minutes in 2 hours range	Numeric
SvcTime15Min2Hr	Service time in 15 minutes in 2 hours range	Numeric
SvcTime30Min	Service time in 30 minutes	Numeric
SvcTime30Min	Service time in 30 minutes	Numeric
SvcTimeHr	Service time in hours	Numeric
SvcTimeHr	Service time in hours	Numeric
SvcTimeHr2Hr	Service time in hours in 2 hours range	Numeric
SvcTimeHr2Hr	Service time in hours in 2 hours range	Numeric
SvcTimeMin	Service time in minutes	Numeric
SvcTimeMin	Service time in minutes	Numeric
SvcTimeMin2Hr	Service time in minutes in 2 hours range	Numeric
SvcTimeMin2Hr	Service time in minutes in 2 hours range	Numeric
SvcTotQty	Total Quantity of the service in one SCF	Numeric
SvcTotQty	Total Quantity of the service in one SCF	Numeric
SvcTotQty2Hr	Total Quantity of the service in one SCF in 2 hours range	Numeric
SvcTotQty2Hr	Total Quantity of the service in one SCF in 2 hours range	Numeric
TotSvcQty	Total Quantity of the service in one SCF	Numeric
TotSvcQty	Total Quantity of the service in one SCF	Numeric
UnitPrice	Defined unit price for that pricing line	Numeric
UnitPrice	Defined unit price for that pricing line	Numeric
XLegs	Number of legs of landed(Always 2 for International Airlines)	Numeric
GroundTime	Ground Time (ATD - ATA)	Datetime
APClassA	is Airport class A	Booelan
APClassB	is Airport class B	Booelan
APClassC	is Airport class C	Booelan
atRemote	Airplane at Remote Position	Booelan
onJetway	Airplane on Jetway	Booelan
Turk	is Flight Type(Legacy Code Def) Turk	Booelan
Charter	is Flight Type(Legacy Code Def) Charter	Booelan
Cargo	is Flight Type(Legacy Code Def) Cargo	Booelan
Scheduled	is Flight Type(Legacy Code Def) Scheduled	Booelan
Domestic	is Flight Domestic	Booelan
PaxArr	total number of passengers on arrival flight	Numeric
PaxDep	total number of passengers on depature flight	Numeric
PaxArrC	total number of C Class passengers on arrival flight	Numeric
PaxDepC	total number of C Class passengers on departue flight	Numeric
PaxIn	number of Pax coming in out of the plane	Numeric
PaxOut	number of Pax going out on the plane	Numeric
AP	Airport Code	String
ArrOnJetWay	Arrival park position on Jet Way	Booelan
DepOnJetWay	Departure park position on Jet Way	Booelan
DepAtRemote	Departure park position at Remote Position	Booelan
ArrAtRemote	Arrival park position at Remote Position	Booelan
BLON	Blocks On Time for the incoming flight	Datetime
BaggWghtTon	Total baggage in + out weight Ceiled to Ton - same with BaggRoy	Numeric
BaggWghtTon	Total baggage in + out weight Ceiled to Ton - same with BaggRoy	Numeric
BillingCurrency	Billing Currency of the Service or Package	String
BillingCurrency	Billing Currency of the Service or Package	String
CargoArrKg	Cargo Arrival Total Weight in Kilograms	Numeric
CargoArrTon	Cargo Arrival Total Weight in Ceiled Tons	Numeric
CargoDepKg	Cargo Departure Total Weight in Kilograms	Numeric
CargoDepTon	Cargo Departure Total Weight in Ceiled Tons	Numeric
CargoInKg	Cargo In in Kg	Numeric
CargoOutKg	Cargo Out in Kg	Numeric
CargoRoy	Total cargo in + out weight for royalty calculations consideration	Numeric
CargoRoy	Total cargo in + out weight for royalty calculations consideration	Numeric
CargoWghtKg	Total cargo in + out weight in Kilograms	Numeric
CargoWghtTon	Total cargo weight for royalty calculations consideration	Numeric
CargoWghtTon	Total cargo weight for royalty calculations consideration	Numeric
CCommRate	Commission Rate from the Initial Agreement divided by 100	Numeric
CCommRate	Commission Rate from the Initial Agreement divided by 100	Numeric
CExtPrice	External Price Total For Commission	Numeric
CExtPrice	External Price Total For Commission	Numeric
ETA	Arrival Flight Estimated Time of Arrival	Datetime
ETD	Departure Flight Estimated Time of Departure	Datetime
ExtCompany	The External Company's Code that has given the service	String
ExtCompany	The External Company's Code that has given the service	String
ExtCurr	External Price Currency Cod	String
ExtCurr	External Price Currency Cod	String
ExtPrice	External Price	Numeric
ExtPrice	External Price	Numeric
FUELGalUK	Fuel Amount in UK Gallons	Numeric
FUELGalUK	Fuel Amount in UK Gallons	Numeric
FUELGalUS	Fuel Amount in US Gallons	Numeric
FUELGalUS	Fuel Amount in US Gallons	Numeric
FUELLt	Fuel Amount in Liters	Numeric
FUELLt	Fuel Amount in Liters	Numeric
InvCurrency	Invoice Currency	String
InvCurrency	Invoice Currency	String
IsArr	If the Landed has an arrival leg before merge operation	Numeric
IsBaggageFlight	True if flight load type includes baggage	Booelan
IsBaggageFlight	True if flight load type includes baggage	Booelan
IsCargoBULK	True if cargo is Bulk	Booelan
IsCargoBULK	True if cargo is Bulk	Booelan
IsCargoFlight	True if flight load type includes cargo	Booelan
IsCargoFlight	True if flight load type includes cargo	Booelan
IsCargoULD	True if cargo is ULD	Booelan
IsCargoULD	True if cargo is ULD	Booelan
IsCharter	True for charter flights	Booelan
IsCharter	True for charter flights	Booelan
IsCombiFlight	True if flight load type is combi(passenger & baggage)	Booelan
IsCombiFlight	True if flight load type is combi(passenger & baggage)	Booelan
IsDep	If the Landed has a departure leg before merge operation	Numeric
IsDHMIMainAirport	True if landed airport is one of DHMI main airports	Booelan
IsDHMIMainAirport	True if landed airport is one of DHMI main airports	Booelan
IsDomesticFlight	True if flight is domestic	Booelan
IsDomesticFlight	True if flight is domestic	Booelan
IsExternalSvc	Is the Service given by another company	Booelan
IsExternalSvc	Is the Service given by another company	Booelan
IsFerryFlight	True if flight load type is ferry	Booelan
IsFerryFlight	True if flight load type is ferry	Booelan
IsGeneralAviation	True if flight is general aviation	Booelan
IsGeneralAviation	True if flight is general aviation	Booelan
IsGroundSCF	True if service charge form type is ground (maintenance)	Booelan
IsGroundSCF	True if service charge form type is ground (maintenance)	Booelan
IsInternationalFlight	True if flight is international	Booelan
IsInternationalFlight	True if flight is international	Booelan
IsMilitaryFlight	True if flight is military	Booelan
IsMilitaryFlight	True if flight is military	Booelan
IsNormalSCF	True if service charge form type is regular (landed)	Booelan
IsNormalSCF	True if service charge form type is regular (landed)	Booelan
IsPassengerFlight	True if flight load type includes passenger	Booelan
IsPassengerFlight	True if flight load type includes passenger	Booelan
IsScheduled	True for scheduled flights	Booelan
IsScheduled	True for scheduled flights	Booelan
IsTechnical	Technical Landing	Booelan
IsTransit	True if the landing is transit	Booelan
IsTransit	True if the landing is transit	Booelan
LandingCntMonth	The Number of Landings for that Month	Numeric
LandingCntMonth	The Number of Landings for that Month	Numeric
LandingCntYear	The Number Of Yearly Landings (Start of year -	Numeric
LandingCntYear	The Number Of Yearly Landings (Start of year -	Numeric
Leg	later	Numeric
Legs	Number of legs of landed	Numeric
MTOW	Maximum take-off weight	Numeric
MTOW	Maximum take-off weight	Numeric
NumPAX	Number Of Passengers	Numeric
NumPAX	Number Of Passengers	Numeric
NumSeat	Number of seats (seat capacity)	Numeric
NumSeat	Number of seats (seat capacity)	Numeric
ACModel	Aircraft Model Code	String
ACModel	Aircraft Model Code	String
ACModelICAO	ICAO Code of the AirCraft Model	String
ACModelICAO	ICAO Code of the AirCraft Model	String
Airline	Airline Code	String
Airline	Airline Code	String
Airport	Landed Airport	String
Airport	Landed Airport	String
AirportOfArrival	Arrival Airport	String
AirportOfDeparture	Departure Airport	String
ATA	Arrival Flight Actual Time of Arrival	Datetime
ATD	Departure Flight Actual Time of Departure	Datetime
BaggArrKg	Baggage Arrival Total Weight in Kilograms	Numeric
BaggArrTon	Baggage Arrival Total Weight in Ceiled Tons	Numeric
BaggDepKg	Baggage Departure Total Weight in Kilograms	Numeric
BaggDepTon	Baggage Departure Total Weight in Ceiled Tons	Numeric
BaggInKg	Baggage In in KG	Numeric
BaggOutKg	Baggage Out in KG	Numeric
BaggRoy	Total baggage in + out weight Ceiled to Ton, for royalty calculations consideration	Numeric
BaggRoy	Total baggage in + out weight Ceiled to Ton, for royalty calculations consideration	Numeric
BaggWghtKg	Total baggage in + out weight in Kilograms	Numeric