The Price Agreements query is used to export the price agreement data, showing each price agreement per row.
You can download price agreements using the default ‘Price Agreements’ report.
Contents
Filters
|
Filter |
Description |
Mandatory |
|---|---|---|
|
Fbo location |
Filters by price agreements available to a FBO location. Single or multiple FBO locations can be selected. |
YES |
|
Filter by date in LT of a price agreements' valid on or after and before date, use both filters to create a date range.
|
NO |
|
Debtor |
Filter by the debtor showing agreements that have the debtor as a 'Debtor' filter |
NO |
|
Aircraft registration |
Filter by aircraft registration showing agreements that have the aircraft registration as an 'Aircraft registration' filter |
NO |
|
Product |
Filter by Product showing agreements that have the Product as a 'Product' or 'Child product' filter |
NO |
|
Custom Property |
Filter by Custom Property showing agreements that have custom values of the selected property as a 'Custom value' filter |
NO |
Data provider settings
There are no data provider settings for this query.
Columns
|
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 |
|
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:
|
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 |
Comments
0 comments
Please sign in to leave a comment.