Price Agreements query

You can download price agreements using the default ‘Price Agreements’ report.

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Fbo location

Filters by price agreements available to a FBO location. Single or multiple FBO locations can be selected.

YES

  • Valid on or after

  • Before date

Filter by date in LT of a price agreements' valid on or after and before date, use both filters to create a date range.

  • If both left blank, then all agreements will show for a FBO location.

  • If ‘Valid on or after’ is blank, then all agreements before the ‘Before date’ date will show.

  • If ‘Before date’ is blank, then all agreements after the ‘Valid on or after’ date will show.

NO

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Name

Description

Example

Aircraft registration

Aircraft registration the price agreement is filtered to. See 'Aircraft registration' field in price agreement.

OEINK

Calculation priority

The calculation priority for the price agreement. The lower the number, the higher the priority for calculation. If multiple agreements apply for the same product, the lowest calculation priority is used for pricing.

982

Child product

Child product code and product description the price agreement is filtered to. See ‘Child product’ field in price agreement.

If ‘Product code’ and ‘Description’ are matching, then product code is shown only.

HANDLING FERRY FLT DISCOUNT | Ferry Flight Discount

Child product code

Child product code the price agreement is filtered to. See ‘Child product’ field in price agreement.

HANDLING FERRY FLT DISCOUNT

Consider custom values from

Where custom values are considered from for the price agreement. See ‘Consider custom values from' field in price agreement. Used in conjunction with ‘Export code value’ or 'Custom value group’. Possible values:

  • Registration or else debtor

  • Trip support provider only

  • Operator only

  • Supplier only

Registration or else debtor

Currency code

Currency code the price agreement is filtered to. See 'Currency of the given price' field in price agreement. If blank FBO location currency or form of payment currency is used.

GBP

Custom value group

Custom value group the price agreement is filtered to. See ‘Custom value group’ field in price agreement.

All Noise CAT BER

Custom value group ID

Custom value group’s unique ID in GUID format.

0c19c883-2505-4799-b9f9-037865080579

Custom value ID

Custom value’s unique ID in GUID format.

18fa1cea-e63e-4b32-a760-df6e1e897a2e

Debtor email

The debtor’s ‘Email 1’ if the price agreement is filtered by debtor. See 'Debtor' field in price agreement.

occ@handling.com; scheduling@handling.com

Debtor name

The debtor’s ‘Organization name’ if the price agreement is filtered by debtor. See 'Debtor' field in price agreement.

Netjets Transportes Aéreos, S.A.

Debtor number

The debtor’s ‘Contact number’ if the price agreement is filtered by debtor. See 'Debtor' field in price agreement.

100875

Debtor shortest name

The debtor’s ‘Short name’ if the price agreement is filtered by debtor. See 'Debtor' field in price agreement.

NETJETS EU

Export code value

Custom value the price agreement is filtered to. See 'Custom value' field in price agreement.

Customer Pricing Agreement:Netjets Contract

Export value

Duplicates ‘Export code value’. See 'Custom value' field in price agreement.

Customer Pricing Agreement:Netjets Contract

Export value group

Duplicates 'Custom value group'. See ‘Custom value group’ field in price agreement.

All Noise CAT BER

FBO location

FBO location the price agreement is filtered to. See 'FBO location' field in price agreement.

If blank, see ‘FBO location group’.

BER

FBO location group

FBO location group the price agreement is filtered to. See 'FBO location group' field in price agreement.

If blank, see ‘FBO location’.

Berlin BER/TXL

FBO location group ID

FBO location group’s unique ID in GUID format.

c8b265d6-0136-41cb-94e5-7bb9b2331a52

Filters

List of filters (separated by comma) applied to the price agreement.

MTOW below=2001 kg, Consider custom values from=Registration or else debtor, Custom value group=All Noise CAT BER

Flight type group

Flight type price categories the price agreement is filtered to. See 'Flight type price category' field in price agreement, and Flight type price categories (Administration).

Scheduled

Follow sku duty tax

SKU duty tax the price agreement is filtered to. See 'SKU duty tax' field in price agreement.

JET A1 - RTMJ | Duty tax RTMJ

Follow sku price component

SKU price component the price agreement is filtered to. See 'SKU price component' field in price agreement.

JET A1 - RTMJ | Posted-Airfield Price

Form of payment

Form of payment the price agreement is filtered to. See 'Form of payment' field in price agreement.

BILL EUR

Form of payment group

Form of payment group the price agreement is filtered to. See 'Form of payment group' field in price agreement, and Form of payment groups (Administration).

Exempt from administration fee

Handling category

Handling category the price agreement is filtered to. See 'Handling category' field in price agreement.

0-10T

Handling category group

Handling category group the price agreement is filtered to. See 'Handling category group' field in price agreement, and Handling category groups (Administration).

0-100T

Handling category group ID

Handling category group’s unique ID in GUID format.

01f2c12f-b013-4b1f-9f17-e2e6f88abb8a

Handling order ID

Handling order’s unique ID in GUID format.

40089a89-8562-42ea-8f1f-172ce2456465

Handling station group

Handling station group the price agreement is filtered to. See 'Handling station group' field in price agreement, and Station groups (Administration).

Berlin

Max amount

Maximum price amount the price agreement is filtered to. See 'Maximum amount' field in price agreement.

20

Min amount

Minimum price amount the price agreement is filtered to. See 'Maximum amount' field in price agreement.

5

Movement type

Movement type the price agreement is filtered to. See 'Movement type' field in price agreement. Possible values:

  • Arrival only

  • Both Arrival and Departure

  • Departure only

  • Either Arrival or Departure

  • Service date

  • Short stop

Either Arrival or Departure

MTOW below in Kg

MTOW below in KG the price agreement is filtered to. See 'MTOW below' field in price agreement.

2001

MTOW below in US Pounds

MTOW below in US pounds the price agreement is filtered to. See 'MTOW below' field in price agreement.

4411

MTOW equal to or above in Kg

MTOW equal to or above in KG the price agreement is filtered to. See 'MTOW equal to or above' field in price agreement.

2001

MTOW equal to or above in US Pounds

MTOW equal to or above in US pounds the price agreement is filtered to. See 'MTOW equal to or above' field in price agreement.

4411

Peak category value

Peak category value the price agreement is filtered to. See 'Peak category value' field in price agreement.

Peak Noise BER/TXL 22:00 to 22:59

Percentage

Percentage amount for the price agreement. See 'Percentage' field in price agreement.

200

Price

Price amount for the price agreement. See 'Price' field in price agreement.

5

Product

Product code and product description the price agreement is filtered to. See ‘Product’ field in price agreement.

If ‘Product code’ and ‘Description’ are matching, then product code is shown only.

ADDNL STAFF | Additional Staff

Product code

Product code the price agreement is filtered to. See 'Product' field in price agreement.

ADDNL STAFF

Quantity below

Quantity below the price agreement is filtered to. See 'Quantity' field in price agreement.

2

Remarks

Remarks added to the price agreement. See 'Remarks' field in price agreement.

Between 22.00 and 22.59 local time 100%+

Station group

Station group the price agreement is filtered to. See 'Station group (arr/dep)' field in price agreement, and Station groups (Administration).

EU & Iceland, Norway, Switzerland

Supplier name

Supplier name the price agreement is filtered to. See 'Supplier' field in price agreement.

AeroGround Berlin GmbH (BER)

Template variable below

Template variable below the price agreement is filtered to. See 'Template variable below' field in price agreement.

240

Template variable name

Template variable name the price agreement is filtered to. See 'Template variable name' field in price agreement.

Custom-Ground Time (mins)

Unit code

Unit the price agreement uses for pricing. See 'Unit of measure for the given unit price' field in price agreement.

hour

Valid from LT

Date the price agreement is valid from. See 'Valid from' field in price agreement.

If blank, the agreement is valid any time before the ‘Valid before’ date.

15-Jun-20

Valid until date

Date the price agreement is valid to. See 'Valid before' field in price agreement.

01-Nov-20