Handling confirmation query

The handling confirmation report is typically generated in the order as an Order report. Generating the report manually is not recommended, use the Order filter with OrderID to ensure the correct order is generated.

Contents

Filters

This query returns a single order at the time, if the entered filter values return more than one order, an error message is displayed.

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

Filters on Administration. Single or multiple Administrations can be selected.

YES

Fbo location

Filters on FBO location. Single or multiple FBO locations can be selected.

NO

Handling station

Filter by Handling station. See Handling station (Glossary).

NO

Take Comms One Services

Filter to show Comms One services.

NO

  • Arrival or departure date time (UTC) on or after / Arrival or departure date time (UTC) before

  • Arrival or departure date time (LT) on or after / Arrival or departure date time (LT) before

Filter by date and time in UTC or LT of an order’s arrival or departure, use both on or after and before to create a data range. Note: ‘Arrival or departure date time’ UTC and LT filters cannot be used together.

For OTC’s the start/end date/times are considered if data provider settings IncludeOtcOrdersByStartDate or IncludeOtcOrdersByEndDate are set to 'TRUE'.

NO

Transaction date LT on or after / Transaction date LT before

Filter between order transaction on or after date and order transaction before date (last calculated date), use both on or after and before to create a data range.

NO

Invoice date on or after / Invoice date before

Filter between Invoice on or after date and Invoice before date, use both on or after and before to create a data range.

NO

  • Supplier invoice date on or after

  • Supplier invoice date before

Filter between Supplier invoice on or after date and before date, use both on or after and before to create a data range.

NO

  • Supplier invoice creation date (UTC) on or after / Supplier invoice creation date (UTC) before: 

  • Supplier invoice creation date (LT) on or after / Supplier invoice creation date (LT) before

Filter between Supplier invoice on or after creation date and before creation date, use both on or after and before to create a data range.

NO

Debtor or operator

Filter by contact present on an order’s debtor or operator field.

NO

Debtor

Filters on an order’s debtor contact.

NO

Operator

Filters on an order’s Operator contact.

NO

Debtor's order number

Filter on an order’s ‘Debtor’s order number’.

 

NO

Aircraft type

Filter by an order’s aircraft type.

NO

Supplier

Filter by orderline supplier.

NO

Aircraft registration

Filter by an order’s aircraft registration.

NO

Product

Filter by product code.

NO

Entry period

Filters on entry periods. See Entry periods (Back office).

NO

Order

Filters on the Order ID. The Order ID can be found in the Classic screens when on Order page, in the browser address bar after ‘Orderid=’, e.g.

NO

Invoice

Filters on the Invoice ID. The Invoice ID can be found in the Classic screen when on Invoice page, in the browser address bar after ‘Invoiceid=’, e.g.

NO

Entry

Filters on the Entry ID. The Entry ID can be found in the Classic screen when on entry page, in the browser address bar after ‘Entryid=’, e.g.

NO

Supplier invoice

Filter by supplier invoice number.

NO

Handling order

Filter by handling order.

NO

  • Service progress range start (LT) / Service progress range end before (LT)

  • Service progress range start (UTC) / Service progress range end before (UTC)

Filter between service progress start and before date, use both on or after and before to create a data range.

NO

Is cancelled

Filter to indicate if service is cancelled.

NO

Data provider settings

This query is based on the Services query, so all data provider setting available for the Services query is also available for Handling confirmation query.

Optional Settings

IsCancelled (bool, default = false)
This setting allows to display either confirmation or cancellation related information.

Columns

Column

Description

Example

Column

Description

Example

Aicraft type model name

Handling order’s aircraft type’s model name. See ‘Model name’ field in aircraft type.

340A / 340B

Aicraft type short name

Handling order’s aircraft type’s operational short name. See ‘Shortname’ field in aircraft type.

SAAB340

Aircraft type

Handling order’s aircraft type’s display name. See ‘Manufacturer', ‘Model name’, 'Shortname’ in aircraft type.

Format: Manufacturer Model Name (ShortName)

Saab 340A / 340B (SAAB340)

Aircraft type ICAO

Handling order’s aircraft type's ICAO code for the registration. See ‘ICAO code’ in aircraft type. See List of aircraft type designators.

SF34

Aoc number

AOC number, AOC expiry date and VAT payment details for the contact. See ‘AOC number', ‘AOC expiry’ fields in contact and 'VAT’ field in order.

Note: If operator and debtor contacts differ and both have AOC, then the debtor’s AOC is shown.

Format: AOC number | AOC expiry | Pay VAT: VAT

LV-03 | 31-Dec-99
Pay VAT: Landside only and EC-reversed. 

Debtor city and country

Handling order’s debtor’s city and country name. See ‘City' and 'Country’ fields in debtor contact.

RIGA, Latvia

Debtor email

Handling order’s debtor’s email 1. See ‘Email 1 (Operations)' field in debtor contact.

ops@fbo.one

Debtor name

Handling order’s debtor’s organization name See ‘Organization name' field in debtor contact.

JSC RAF-AVIA

Debtor order number

Handling order’s operator’s request number and debtor’s order number. See ‘Operator’s request number' and ‘Debtor’s order number' fields in order.

Format: Operator’s request number | Debtor’s order number

12345 | 1234

Debtor phone fax

Handling order’s debtor’s phone 1 and fax. See ‘Phone 1' and 'Fax' fields in debtor contact.

Format: Phone 1 / Fax

+371 1234567 / -

DebtorOrderNoOnly

Handling order’s debtor’s order number. See ‘Debtor’s order number' field in order.

1234

Fuel type

Handling order’s aircraft type’s fuel type. See ‘Fuel type’ field in aircraft type.

Jet Fuel

Handling Id

The handling order’s unique ID in GUID format.

17b5d623-4bca-4daa-81d8-c1e78a2a789d

Handling station IATA

Handling order’s handling station’s IATA code. See ‘Arrival station' / ‘Departure station’ or 'Handle at' field for out based handlings. See also 'IATA code’ in station.

FBO

Handling station ICAO

Handling order’s handling station’s IATA code. See ‘Arrival station' / ‘Departure station’ or 'Handle at' field for out based handlings. See also 'ICAO code’ in station.

LSZH

HandlingCancellationHeader

Handling order’s cancellation header for sent cancellations. See 'HandlingCancellation-HeaderTitle' in Report settings or FBO location settings.

** CONFIRMATION OF CANCELLATION **

HandlingCancellationHeaderInformation

Handling order’s cancellation header information for sent cancellations. See 'HandlingCancellation-HeaderInformation' in Report settings or FBO location settings.

Dear Client,
We acknowledge receipt of your Handling Cancellation and look forward to working with you again in the near future.

HandlingConfirmationFooter

Handling order’s confirmation footer for sent confirmations. See 'HandlingConfirmation-Footer' in Report settings or FBO location settings.

FBO One | Passenger Terminal, Main Road TN16 3BH | Bromley | United Kingdom Callsign: Biggin Hill | Freq: 131.790 Phone: +44 (0) 1234 567890 | E-mail: fbo@fboone.com | Internet: fbo.one

HandlingConfirmationFooterInformation

Handling order’s confirmation footer information for sent confirmations. See 'HandlingConfirmation-FooterInformation' in Report settings or FBO location settings.

All services are performed under the terms and conditions as outlined by IATA STANDARD GROUND HANDLING AGREEMENT published January 2013.

HandlingConfirmationHeader

Handling order’s confirmation header for sent confirmations. See 'HandlingConfirmation-Header' in Report settings or FBO location settings.

Handling confirmation by FBO One Handling

HandlingConfirmationHeaderInformation

Handling order’s confirmation header information for sent confirmations. See 'HandlingConfirmation-HeaderInformation' in Report settings or FBO location settings.

Dear Client,

We thank you for your handling request. Please find below confirmation of your flight details as requested. Should this information be incorrect please let us know at your earliest convenience.

Inbound airport slot

Handling order’s inbound airport slot in the user’s displayed time. See ‘Airport slot' field in order’s arrival flight leg. See also ‘Slot ID', 'State' and 'External remarks’ fields in inbound slot product.

Format: Slot time (User’s displayed time) | Slot ID (State) External remarks

15:50 (LT) | LSZHASVW0047M0 (Confirmed) TestExt

Inbound airport slot date

Handling order’s inbound airport slot’s date in UTC. See ‘Airport slot' field in order’s arrival flight leg.

07-Jan-21

Inbound airport slot remarks

Handling order’s inbound airport slot’s remarks. See ‘External remarks’ field in inbound slot product.

TestExt

Inbound airport slot workflow state

Handling order’s inbound airport slot’s remarks. See ‘State’ field in inbound slot product.

Confirmed

Inbound arrival time caption

Handling order’s most actual arrival time caption. See arrival flight leg of order. Possible values:

  • STA - Scheduled time of arrival

  • ETA - Estimated time of arrival

  • ATA - Actual time of arrival

ATA

Inbound arrival time formatted

Handling order’s most actual arrival time in user’s displayed time. See arrival flight leg of order. See also 'ShortDateTimeFormatString' in Application Settings (Administration) or FBO locations (Administration).

If the arrival flight leg is marked as pending then pending text will be shown instead of the date time. See ‘Pending time indicator’ field in FBO location.

31-Dec-20 17:53 (LT)

Inbound arrival time Lt

Handling order’s most actual arrival time in local time. See arrival flight leg of order.

17:53

Inbound arrival time Utc

Handling order’s most actual arrival time in UTC. See arrival flight leg of order.

16:53

Inbound crew count

Handling order’s arrival Crew count. See ‘Crew count' field in order’s arrival flight leg.

2

Inbound flight number

Handling order’s arrival flight number. See ‘Flight number' field in order’s arrival flight leg.

MTL727C

Inbound flight number and type

Handling order’s arrival flight number and flight . See ‘Flight number' and 'Flight type' fields in order’s arrival flight leg.

Format: Flight number | Flight type

MTL727C | Cargo

Inbound flight type

Handling order’s arrival flight type. See ‘Flight type' field in order’s arrival flight leg.

Cargo

Inbound from station codes

Handling order’s arrival origin station ICAO and IATA code. See ‘Origin' field in order’s arrival flight leg. See also ‘ICAO code’ and ‘IATA code’ fields in station.

Format: ICAO (IATA)

LFSB (MLH/BSL)

Inbound from station codes and gendec

Handling order’s arrival station ICAO, IATA codes and if a GENDEC is required. See ‘Origin' field in order’s arrival flight leg, ‘ICAO code’ and ‘IATA code’ fields in station. See also 'Stations requiring an inbound General Declaration' in FBO locations (Administration).

Format: ICAO (IATA) | Gendec requirement

LFSB (MLH/BSL) | Gendec required

Inbound from station country code

Handling order’s arrival origin station country code. See ‘Origin' field in order’s arrival flight leg. See also ‘Country' field in station and 'Unofficial 2 letter code’ field in Countries (Administration).

GB

Inbound from station country name

Handling order’s arrival origin station country name. See ‘Origin' field in order’s arrival flight leg. See also ‘Country' field in station and 'Description’ field in Countries (Administration).

United Kingdom

Inbound from station gendec

Indicates if the arrival station requires a GENDEC. See ‘Origin' field in order’s arrival flight leg. See also 'Stations requiring an inbound General Declaration' in FBO locations (Administration).

TRUE

Inbound from station name

Handling order’s arrival origin station country code. See ‘Origin' field in order’s arrival flight leg. See also ‘Station name' field in station.

Basel Mulhouse EuroAirport

Inbound from station name and country

Handling order’s arrival origin station country code. See ‘Origin' field in order’s arrival flight leg. See also ‘Station name', 'Place' ‘Country' fields in station, and 'Description’ field in Countries (Administration).

Format: Station Name Place Country

Basel Mulhouse EuroAirport Basel France

Inbound non transit pax count

Handling order’s arrival non-transit Pax count.

Pax count - Transit Pax count

0

Inbound pax count

Handling order’s arrival Pax count. See ‘Pax count' field in order’s arrival flight leg.

0

Inbound pax crew count formatted

Handling order’s arrival Pax count and Crew count. See ‘Pax count' field in order’s arrival flight leg.

Format: Pax Count | Crew Count

Pax 0 | Crew 2

Inbound transit pax count

Handling order’s arrival transit Pax count. See ‘Transit pax count' field in order’s arrival flight leg.

0

InboundAirportSlotLt

Handling order’s inbound airport slot in local time. See ‘Airport slot' field in order’s arrival flight leg. See also ‘Slot ID', 'State' and 'External remarks’ fields in inbound slot product.

Format: Slot time (LT) | Slot ID (State) External remarks

15:50 (LT) | LSZHASVW0047M0 (Confirmed) TestExt

InboundAirportSlotUtc

Handling order’s inbound airport slot in UTC. See ‘Airport slot' field in order’s arrival flight leg. See also ‘Slot ID', 'State' and 'External remarks’ fields in inbound slot product.

Format: Slot time (UTC) | Slot ID (State) External remarks

14:50 (UTC) | LSZHASVW0047M0 (Confirmed) TestExt

InboundArrivalTimeFormattedLt

Handling order’s most actual arrival time in local time formatted. See arrival flight leg of order. See also 'ShortDateTimeFormatString' in Application Settings (Administration) or FBO locations (Administration).

If the arrival flight leg is marked as pending then pending text will be shown instead of the date time. See ‘Pending time indicator’ field in FBO location.

31-Dec-20 17:53 (LT)

InboundArrivalTimeFormattedUtc

Handling order’s most actual arrival time in UTC formatted. See arrival flight leg of order. See also 'ShortDateTimeFormatString' in Application Settings (Administration) or FBO locations (Administration).

If the arrival flight leg is marked as pending then pending text will be shown instead of the date time. See ‘Pending time indicator’ field in FBO location.

31-Dec-20 16:53 (UTC)

InboundOriginSystemId

Origin system ID for the imported inbound flight leg using Stonefield FIDS. See StonefieldConfiguration.

RX020005072019103639A

InboundOriginSystemIdLastSeenAtUtc

Most recent inbound flight leg import time using Stonefield FIDS. See StonefieldConfiguration.

05-Jul-19

InboundOriginSystemLastRow

JSON import data for inbound flight leg from Stonefield FIDS. See StonefieldConfiguration.

{"Registration":"ZZ336","Aircraft":"A330","Callsign":"RRR748","ADEP":"EGVN","ADES":"EGKB","From_To":"EGVN", "EdmATD_ATA_Date":"2019-07-05T00:00:00Z", "ATD_ATA":"1221", "EdmSignificant_Date":"2019-07-05T00:00:00Z", "Significant_Time":"1221", "Category":"A", "Touch_and_Gos":"0", "Parking":"BH APR", "POB":"1", "Notes":"TWR / DAY STOP / 0 PAX", "ID":"RX020005072019103639A", "Approaches":"  "}

InboundOriginSystemNotes

Imported inbound flight leg system notes from Stonefield FIDS. See StonefieldConfiguration.

TWR / DAY STOP / 0 PAX

Is home based operator

Indicates if the order is a home based operator. This is defined by if the departure time is before the arrival time.

FALSE

Is order cancelled

Indicates if the order is in a cancelled state.

FALSE

Logo image

Shows the logo defined in FBO location. See 'Confirmation logo' field in FBO locations (Administration).

Max pax

Handling order’s aircraft registration seat count from either the aircraft registration ‘Specific seats' field or aircraft type’s ‘Default seats’ field. Outputted as number format.

12

Max pax formatted

Handling order’s aircraft registration seat count from either the aircraft registration ‘Specific seats' field or aircraft type’s ‘Default seats’ field. Outputted as text format.

12

Mtow formatted

Handling order’s aircraft registration maximum take off weight, and the format used for the Aircraft Administration. See either ‘Specific MTOW' field in aircraft registration or ‘Default MTOW’ field in aircraft type. See also 'Use US weights and measures’ field in Aircraft administrations (Administration).

13155 kg

Mtow in tons

Handling order’s aircraft registration maximum take off weight. See either ‘Specific MTOW' field in aircraft registration or ‘Default MTOW’ field in aircraft type.

Note: MTOW is rounded up to next ton.

14

Noise chapter

This column is no longer used. See Noise chapters (Administration).

 

Operator city and country

Handling order’s operator’s city and country name. See ‘City' and 'Country’ fields in operator contact.

RIGA, Latvia

Operator email

Handling order’s operator’s email 1. See ‘Email 1 (Operations)' field in operator contact.

ops@fbo.one

Operator name

Handling order’s operator’s organization name See ‘Organization name' field in operator contact.

JSC RAF-AVIA

Operator phone fax

Handling order’s operator’s phone 1 and fax. See ‘Phone 1' and 'Fax' fields in opeartor contact.

Format: Phone 1 / Fax

+371 1234567 / -

Order and trip number

Handling order’s order key and trip number. See ‘Trip number’ field in order. See also 'Shows tripnumber' field in FBO locations (Administration).

Format: Order Key | Trip: Trip number

LSZH-243064 | Trip: 123123

Order Id

The order’s unique ID in GUID format.

75e48246-4b13-4a36-a13b-c8cf4a21de96

Order line Id

The orderline’s unique ID in GUID format.

09f870a3-34cd-4b0c-8589-8a1dc42a78fc

Order remarks

Handling order’s external remarks. See 'External remarks' field in order.

TestExt

Order title1

Handling order’s aircraft registration, flight numbers and current parking position. See ‘Aircraft registration', ‘Flight number’ and 'Parking position’ fields in order.

Format: Registration - Inbound Flight number/Outbound Flight number (Parking position)

YLRAG - MTL727C/MTL728P (B14)

Order title2

Handling order’s arrival and departure time in user’s displayed time.

  • If flight leg is pending without date time then ‘Pending time indicator' will show for flight leg.

  • If pending with date time then a '?’ will show at the end of the time.

Format: Most actual arrival date time / Most actual departure date time (Time indicator)

31 Dec 17:53 / 01 Jan 12:47 (LT)

OrderTitle2Lt

Handling order’s arrival and departure time in local time with flight leg indicator.

  • If flight leg is pending without date time then ‘Pending time indicator' will show for flight leg.

  • If pending with date time then a '?’ will show at the end of the time.

Format: Flight leg indicator: Most actual arrival date time / Flight leg indicator: Most actual departure date time (LT)

ARR: 31 Dec 17:53 / DEP: 01 Jan 12:47 (LT)

OrderTitle2Utc

Handling order’s arrival and departure time in UTC with flight leg indicator.

  • If flight leg is pending without date time then ‘Pending time indicator' will show for flight leg.

  • If pending with date time then a '?’ will show at the end of the time.

Format: Flight leg indicator: Most actual arrival date time / Flight leg indicator: Most actual departure date time (UTC)

ARR: 31 Dec 16:53 / DEP: 01 Jan 11:47 (UTC)

Outbound airport slot

Handling order’s outbound airport slot in the user’s displayed time. See ‘Airport slot' field in order’s departure flight leg. See also ‘Slot ID', 'State' and 'External remarks’ fields in outbound slot product.

Format: Slot time (User’s displayed time) | Slot ID (State) External remarks

16:20 (LT) | LSZHDSVW0047M0 (Confirmed)

Outbound airport slot date

Handling order’s outbound airport slot’s date in UTC. See ‘Airport slot' field in order’s departure flight leg.

 

Outbound airport slot remarks

Handling order’s outbound airport slot’s remarks. See ‘External remarks’ field in outbound slot product.

07-Jan-21

Outbound airport slot workflow state

Handling order’s inbound airport slot’s remarks. See ‘State’ field in outbound slot product.

Confirmed

Outbound crew count

Handling order’s departure Crew count. See ‘Crew count' field in order’s departure flight leg.

2

Outbound departure time caption

Handling order’s most actual departure time caption. See departure flight leg of order. Possible values:

  • STD - Scheduled time of departure

  • ETD - Estimated time of departure

  • ATD - Actual time of departure

ATA

Outbound departure time formatted

Handling order’s most actual departure time in user’s displayed time. See departure flight leg of order. See also 'ShortDateTimeFormatString' in Application Settings (Administration) or FBO locations (Administration).

If the departure flight leg is marked as pending then pending text will be shown instead of the date time. See ‘Pending time indicator’ field in FBO location.

1-Jan-21 12:47 (LT)

Outbound departure time Lt

Handling order’s most actual departure time in local time. See departure flight leg of order.

12:47

Outbound departure time Utc

Handling order’s most actual departure time in UTC. See departure flight leg of order.

11:47

Outbound flight number

Handling order’s departure flight number. See ‘Flight number' field in order’s departure flight leg.

MTL728P

Outbound flight number and type

Handling order’s departure flight number and flight . See ‘Flight number' and 'Flight type' fields in order’s departure flight leg.

Format: Flight number | Flight type

MTL728P | Cargo

Outbound flightType

Handling order’s departure flight type. See ‘Flight type' field in order’s departure flight leg.

Cargo

Outbound non transit pax count

Handling order’s departure non-transit Pax count.

Pax count - Transit Pax count

0

Outbound pax count

Handling order’s departure Pax count. See ‘Pax count' field in order’s departure flight leg.

0

Outbound pax crew count formatted

Handling order’s departure Pax count and Crew count. See ‘Pax count' field in order’s departure flight leg.

Format: Pax Count | Crew Count

Pax 0 | Crew 2

Outbound to station codes

Handling order’s departure origin station ICAO and IATA code. See ‘Destination' field in order’s departure flight leg. See also ‘ICAO code’ and ‘IATA code’ fields in station.

Format: ICAO (IATA)

EGGP (LPL)

Outbound to station codes and gendec

Handling order’s departure station ICAO, IATA codes and if a GENDEC is required. See ‘Destination' field in order’s departure flight leg, ‘ICAO code’ and ‘IATA code’ fields in station. See also 'Stations requiring an outbound General Declaration' in FBO locations (Administration).

Format: ICAO (IATA) | Gendec requirement

EGGP (LPL) | Gendec required

Outbound to station country code

Handling order’s departure origin station country code. See ‘Destination' field in order’s departure flight leg. See also ‘Country' field in station and 'Unofficial 2 letter code’ field in Countries (Administration).

GB

Outbound to station country name

Handling order’s departure origin station country name. See ‘Destination' field in order’s departure flight leg. See also ‘Country' field in station and 'Description’ field in Countries (Administration).

United Kingdom

Outbound to station gendec

Indicates if the departure station requires a GENDEC. See ‘Destination' field in order’s departure flight leg. See also 'Stations requiring an outbound General Declaration' in FBO locations (Administration).

TRUE

Outbound to station name

Handling order’s departure origin station country code. See ‘Destination' field in order’s departure flight leg. See also ‘Station name' field in station.

Liverpool

Outbound to station name and country

Handling order’s departure origin station country code. See ‘Destination' field in order’s departure flight leg. See also ‘Station name', 'Place' ‘Country' fields in station, and 'Description’ field in Countries (Administration).

Format: Station Name Place Country

Liverpool Liverpool United Kingdom

Outbound transit pax count

Handling order’s departure transit Pax count. See ‘Transit pax count' field in order’s departure flight leg.

0

OutboundAirportSlotLt

Handling order’s outbound airport slot in local time. See ‘Airport slot' field in order’s departure flight leg. See also ‘Slot ID', 'State' and 'External remarks’ fields in outbound slot product.

Format: Slot time (LT) | Slot ID (State) External remarks

16:20 (LT) | LSZHDSVW0047M0 (Confirmed)

OutboundAirportSlotUtc

Handling order’s outbound airport slot in UTC. See ‘Airport slot' field in order’s departure flight leg. See also ‘Slot ID', 'State' and 'External remarks’ fields in outbound slot product.

Format: Slot time (UTC) | Slot ID (State) External remarks

15:20 (UTC) | LSZHDSVW0047M0 (Confirmed)

OutboundDepartureTimeFormattedLt

Handling order’s most actual departure time in local time formatted. See departure flight leg of order. See also 'ShortDateTimeFormatString' in Application Settings (Administration) or FBO locations (Administration).

If the arrival flight leg is marked as pending then pending text will be shown instead of the date time. See ‘Pending time indicator’ field in FBO location.

7-Jan-21 16:35 (LT)

OutboundDepartureTimeFormattedUtc

Handling order’s most actual departure time in UTC formatted. See departure flight leg of order. See also 'ShortDateTimeFormatString' in Application Settings (Administration) or FBO locations (Administration).

If the arrival flight leg is marked as pending then pending text will be shown instead of the date time. See ‘Pending time indicator’ field in FBO location.

7-Jan-21 15:35 (UTC)

OutboundOriginSystemId

Origin system ID for the imported outbound flight leg using Stonefield FIDS. See StonefieldConfiguration.

RX000422112020012117D

OutboundOriginSystemIdLastSeenAtUtc

Most recent outbound flight leg import time using Stonefield FIDS. See StonefieldConfiguration.

22-Nov-20

OutboundOriginSystemLastRow

JSON import data for outbound flight leg from Stonefield FIDS. See StonefieldConfiguration.

{"Registration":"ZZ336", "Aircraft":"A330", "Callsign":"RRR748", "ADEP":"EGKB", "ADES":"EGVN", "From_To":"EGKB", "EdmATD_ATA_Date":"2020-11-22T00:00:00Z", "ATD_ATA":"1146", "EdmSignificant_Date":"2020-11-22T00:00:00Z", "Significant_Time":"1146", "Category":"D", "Touch_and_Gos":"0", "Parking":"BH APR M", "POB":"1","Notes":"TWR DEP / CREW", "ID":"RX000422112020012117D", "Approaches":"  "}

OutboundOriginSystemNotes

Imported outbound flight leg system notes from Stonefield FIDS. See StonefieldConfiguration.

TWR DEP / CREW

Payment form

Handling order’s form of payment and credit term. See ‘Form of payment for amount due' field in order and ‘Credit term in days’ field in debtor’s contract.

Format: Form of payment (term: Credit term in days (Date payment is due))

BILL EUR (term: 14 days (15-Jan-21))

Product code

Handling order’s orderline product code. See ‘Product code’ field in product.

CREW TRAPO TO/FROM HOTEL

Product description

Handling order’s orderline product description. See ‘Description (on invoice)’ field in product.

Crew Transportation to/from Hotel

Product Id

The product's unique ID in GUID format.

fcbbf64a-11ee-4374-8872-5467b54bb221

QRCode

Allows generating a QR code using data from other columns, see How to add a QR code to a report.

Example shown:

  • Settings: MultipleValuesSeparator=" | "

  • Columns: Order title1, OrderTitle2Utc, Handling station ICAO, Payment form

Quantity

Handling order’s orderline quantity. See ‘Quantity’ field in orderline. Outputted as number format.

1

Quantity formatted

Handling order’s orderline quantity. See ‘Quantity’ field in orderline. Outputted as text format.

1.000000000000

Registration

Handling order’s aircraft registration display name. See ‘Aircraft registration’ field in order and ‘Model type’ field in aircraft type.

Format: Registration code (Model name)

YLRAG (SAAB340)

Service delivery datetime formatted

Handling order’s orderline service date time in local time and UTC with time indicators. See ‘Delivery date/time’ field in orderline.

Format: Service date LT / Service date UTC

31-Dec-20 18:15LT / 31-Dec-20 17:15UTC

Service delivery datetime formatted Lt

Handling order’s orderline service date time in local time with time indicator. See ‘Delivery date/time’ field in orderline.

31-Dec-20 18:15LT

Service delivery datetime formatted Utc

Handling order’s orderline service date time in UTC with time indicator. See ‘Delivery date/time’ field in orderline.

31-Dec-20 17:15UTC

Service delivery datetime Lt

Handling order’s orderline service date time in local time. See ‘Delivery date/time’ field in orderline.

31-Dec-20 18:15

Service delivery datetime Utc

Handling order’s orderline service date time in UTC. See ‘Delivery date/time’ field in orderline.

31-Dec-20 17:15

Service remarks

Handling order’s orderline service date time in UTC and local time, and orderline external remarks. See ‘Delivery date/time’ and 'External remarks (to customers)' fields in orderline.

Format: Service date time (UTC) | Service date time (LT) | External remarks

31-Dec-20 17:15 (UTC) | 31-Dec-20 18:15 (LT) | Transport inbound crew to Leonardo Hotel 

Service supplier name

Handling order’s orderline supplier. See ‘Supplier field in orderline.

CAS Cologne Aviation Service GmbH

ServiceRemarksLt

Handling order’s orderline service date time in local time, and orderline external remarks. See ‘Delivery date/time’ and 'External remarks (to customers)' fields in orderline.

Format: Service date time (LT) | External remarks

31-Dec-20 18:15 (LT) | Transport inbound crew to Leonardo Hotel 

ServiceRemarksUtc

Handling order’s orderline service date time in UTC, and orderline external remarks. See ‘Delivery date/time’ and 'External remarks (to customers)' fields in orderline.

Format: Service date time (UTC) | External remarks

31-Dec-20 17:15 (UTC) | Transport inbound crew to Leonardo Hotel 

Unit code

Handling order’s orderline unit code. See ‘Unit code’ field in product.

item

Unit price

Handling order’s orderline unit price. See ‘Unit price field in orderline.

25

Unit price currency code

Handling order’s orderline unit price currency code. See ‘Unit price currency fields in orderline.

EUR