Pricing Schema

Top  Previous  Next

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.

 

agreement6

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.

 

Here is the list of some predefined context variables:

 

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