Movements query

Contents:

Filters

To determine what orders will be shown by the query, filters can be applied in FBO One. The filters available for the orders query are shown in the screenshot below. Filters with an asterisk sign * are mandatory.

Filter

Description

Mandatory

Filter

Description

Mandatory

Fbo location

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

YES

Handling station

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

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 for the order’s arrival or departure movement, 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'.

YES

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

Aircraft registration

Filter by an order’s aircraft registration.

NO

Data provider settings

The following ‘Data provider settings’ can be set in Reports (Administration) for the query of a report. All settings must be separated by a semi-colon ';'. If not specified the default settings apply.

Setting

Type

Default

Description

Setting

Type

Default

Description

IncludeCancelledOrders

Boolean

FALSE

Movements of cancelled orders are by default not included in the report.

NOTE: This setting does not however apply to OTC Order types when Cancelled. These will be shown, regardless of the setting and default.
The following C# Filter expression may be added in order to exclude Cancelled OTC type orders:

C# Filter expression to exclude Cancelled OTC orders
1 2 3 4 5 6 7 8 9 10 11 12 ((Func<bool>)(() => { var statesExcluded = new System.Collections.Generic.List<string>(); statesExcluded.Add("otc order | cancelled"); string state = ((string)row["OrderState"]).ToLower(); bool showOrder = true; if (statesExcluded.IndexOf(state) >= 0) showOrder = false; return showOrder; } ))();

IncludeOrdersInStage

String

FrontAndBackOffice

Whether or not orders in a particular stage should be included in the report. If not specified, orders being in front or in back office stage will be included. Possible values:

  • Quote

  • FrontOffice

  • BackOffice

  • FrontAndBackOffice

ArrDep

String

BLANK

If set to A, only arrivals will be shown. If set to D, only departures. The special value 1 shows only the first movement of every order. In Excel you could use a VLOOKUP function to add the other half to it if needed. Possible values

  • A - Arrivals only

  • D - Departures only

balanceLinesAD

Boolean

FALSE

When set to TRUE, the report will compare the Arrivals and Departures and balance the rows so that the flights will be on lines according to the time of departure/arrival. When FALSE, there are e.g. departures at 8:00 on the same line as an arrival at 10:00 in the report. 

AddBlankLineAfterEachMovement

Boolean

FALSE

When set to TRUE, inserts at least 1 blank line after each movement to allow for writing space on the report. Not needed unless in combination with the MinimumNumberOfLinesPerHour, as otherwise it can be done by whitespace in the template.

MinimumNumberOfLinesPerHour

Integer

0

Setting this to a non-zero value will insert blank lines (just the time fields will be filled) so a fixed number of lines per hour is output. This can be used to create reports that have a fixed number of lines, with the actual movemens in a sensible position. Setting this to 4 for example, will create at least 1 line for every 15 minute period in an hour. If there are 4 or more movements in an hour, no extra lines will be created. You may want to use the 'AddBlankLineAfterEachMovement' as well, in order to make sure every movement has at least one blank line.

FirstBlankLineOnOrAfterHourUtc

Integer

6

In combination with the MinimumNumberOfLinesPerHour setting, this can prevent the creation of blank lines before say 0600 in the morning. FirstBlankLineOnOrAfterHourUtc=6

LastBlankLineBeforeHourUtc

Integer

23

In combination with the MinimumNumberOfLinesPerHour setting, this can prevent the creation of blank lines after say 2200. LastBlankLineBeforeHourUtc=22

OnlyActuals

Boolean

TRUE

If set to FALSE, not only actuals but also scheduled flights will be shown. A flight is considered actual if it has ATA set for an inbound flight or ATD set for an outbound flight.

OnlyIncludeMovementsVisibleInDailyFlightProgram

Boolean

FALSE

Setting this to TRUE hides movements that should not show up in the daily flight program (this is a workflow setting)

onlyMovementsOnOrAfterHourLt

Integer

0

This setting can be used to show only movements on or after a specific time.
It may only be used in combination with onlyMovementsBeforeHourLt if the two settings are used on separate sheets within an Excel Report. Inserting both settings within the same set of Data Provider settings results in an error when running the report.
These settings are only compatible with 'on the hour' times, in a 2-digit format.

For example: to show only movements after 2000LT the setting format would be onlyMovementsOnOrAfterHourLt=20 or to show movements after 0700 the setting format would be onlyMovementsOnOrAfterHourLt=07

onlyMovementsBeforeHourLt

Integer

25

This setting can be used to show only movements on or before a specific time. 
It may only be used in combination with onlyMovementsAfterHourLt if the two settings are used on separate sheets within an Excel Report. Inserting both settings within the same set of Data Provider settings results in an error when running the report.
These settings are only compatible with 'on the hour' times, in a 2-digit format. 

For example: to show only movements before 0600LT the setting format would be onlyMovementsBeforeHourLt=06 or to show movements before 2300 the setting format would be onlyMovementsBeforeHourLt=23

ReplaceCommas

Boolean

FALSE

Whether to replace commas inside the export values (custom values) themselves. The export values are shown as a comma separated list. Settings this to TRUE, guarantees commas inside export values don't interfere with this list.

ServicesToInclude

String

ALL

This option can be used to reduce the number of services shown in the serviceslist and remarks fields. Possible values:

  • ALL - All services

  • W - Only services with a workflow

  • S - Only services in the daily service summary

ShowCheckBoxesForServices

Boolean

FALSE

When TRUE, each service in the services list is prepended with a '[ ]' symbol, that can be used as a checkbox on a report.

extraDaysInFuture

Integer

0

This allows to add some days to the 'end' parameter. Useful for daily reports that should span more than the default single day.

IncludeOtcOrdersByStartDate 

Boolean

FALSE

When set to TRUE, it allows adding OTC orders which do not have flight legs into an order report based on the arrival/departure filter. The Arrival/Departure date filter will match on OTC order start time fields.

IncludeOtcOrdersByEndDate 

Boolean

FALSE

When set to TRUE, it allows adding OTC orders which do not have flight legs into a order report based on the arrival/departure filter. The Arrival/Departure date filter will match on OTC order end time fields.

Columns

Column

Description

Example

Column

Description

Example

Administration Name

The Administration name.

FBO One

AdministrationID

The Administration's unique ID in GUID format.

9bf6dcf7-ac35-46eb-8a5a-f60ec90ff9f3

Aircraft number of engines

The engine count for the aircraft registration’s aircraft type. See ‘Number of engines’ field in aircraft type.

2

Aircraft registration code

Registration code for the aircraft.

FRS88K

Aircraft registration code with dash

Registration code for the aircraft with country specific dash. See ‘Registration prefix’ field in Countries (Administration).

FRS88K

Aircraft registration ID

Aircraft registration’s unique ID in GUID format.

baadabec-664f-46d7-8d3d-07644702325e

Aircraft serial number

Aircraft registration’s serial number. See ‘Serial number’ field in aircraft registration.

 

Aircraft type ICAO

Aircraft type's ICAO code for the registration. See List of aircraft type designators.

C680

Aircraft type ID

Aircraft type’s unique ID in GUID format.

c8677661-b320-41b7-afcd-d7e909837031

Aircraft type short name

 

C680

AircraftRegistrationCountry

 

France

AircraftTypeIATA

 

 

Airport slot

 

 

Airport Slot Description

 

-

Airport Slot Remarks

 

 

AirportSlotLt

 

 

Airway slot

 

 

AirwaySlotLt

 

 

ArrDepActualDateTimeLt

 

01-Feb-18 12:04

ArrDepActualDateTimeUTC

 

01-Feb-18 12:04

ArrDepEstimatedDateTimeLT

 

01-Feb-18 12:05

ArrDepEstimatedDateTimeUTC

 

01-Feb-18 12:05

ArrDepScheduledDateTimeLT

 

01-Feb-18 12:15

ArrDepScheduledDateTimeUTC

 

01-Feb-18 12:15

Arrival is pending

 

FALSE

Arrival or Departure

 

A

Arrival time LT

 

12:04

Arrival time UTC

 

12:04

Arrival/Departure date LT

 

01-Feb-18

Arrival/Departure date time LT

 

01-Feb-18 12:04

Arrival/Departure date time UTC

 

01-Feb-18 12:04

Arrival/Departure date UTC

 

01-Feb-18

Arrival/Departure is pending

 

FALSE

Arrival/Departure time LT

 

12:04

Arrival/Departure time UTC

 

12:04

Arrival/Departure year month LT

 

201802

Arrival/Departure year month UTC

 

201802

Arrival/Departure year week no. LT

 

5

Arrival/Departure year week no. UTC

 

5

Baggage pieces

 

 

Baggage weight

 

 

Billing Remark

 

 

Credit term days

 

30

Crew count

 

2

Crew count in

 

2

Crew count out

 

 

Crew names

 

Siegfried STEINER, Jochen Georg Haunreiter

Debtor Address 1

 

Perlacher Strasse 16

Debtor Address 2

 

 

Debtor AOC expire date

 

 

Debtor AOC number

 

 

Debtor carrier code

 

 

Debtor City

 

Gruenwald

Debtor Country

 

Germany (DE)

Debtor Country for VAT

 

Germany (DE)

Debtor Email 1

 

 

Debtor Email 2

 

 

Debtor Fax

 

 

Debtor ID

Debtor contact’s unique ID in GUID format.

06b84ff4-8d6f-4709-ae4c-89e1cc96570d

Debtor name

 

Tango VIP 13 (RST003)

Debtor Order No

 

 

Debtor Phone 1

 

0049 089 641601 0

Debtor shortest name

 

Tango VIP 13

Debtor State

 

 

Debtor VAT number

 

DE130209871

Debtor Website URL

 

 

Debtor Zip code

 

D-82031

DebtorAdministrationContactNo

 

 

DebtorContactContactNo

 

RST003

Debtors order number

 

 

De-ice category

 

 

Departure is pending

 

 

Departure time LT

 

 

Departure time UTC

 

 

Export values

 

Account System FOP Code: BILL GBP, ATC Flight Type: JT, EtaAtDestination: 14:11, Fuel On Arrival: Yes - Fuel On Arrival, Medical Flight Comments: ~~, Park Flat: Yes, PetFly Flight: 0

External remarks

 

 

Fbolocation short name

 

FBO

FbolocationID

The FBO location’s unique ID in GUID format.

4e72f72c-b4bb-479f-b376-cb232c9947b4

Flight leg ID

Flight leg’s unique ID in GUID format.

bf31e85c-6c3d-463d-8694-52613b9a8e64

Flight number

 

 

Flight rules

 

 

Flight type

 

Private

Flightnumber if not registration

 

 

FOP

 

BILL EUR

From/To country code

 

CH

From/To country is EU

 

FALSE

From/To country name

 

Switzerland

From/To IATA

 

ZRH

From/To ICAO

 

LSZH

From/To Is Domestic

 

INT

From/To is GenDec required

 

FALSE

From/To name

 

Zurich

From/To station ID

The Station’s unique ID in GUID format, for the flight leg.

d3cfc783-4134-4856-981e-bc0704d6963c

FromICAO

 

LSZH

Front office workflow

 

Handling Order

Handling category

 

Band I

Handling country code

 

GB

Handling country is EU

 

TRUE

Handling country name

 

United Kingdom

Handling IATA

 

BQH

Handling ICAO

 

EGKB

Handling Station Displayname

 

EGKB/BQH (Biggin Hill)

Handling station ID

The Handling Station’s unique ID in GUID format, for the flight leg.

5a944819-a699-4ddb-b2fb-e9229d0d0995

Handling station name

 

Biggin Hill

Hanger category

 

 

Internal remarks

 

 

Internal sort date time

 

01-Feb-18 12:04

Internal sort key

 

FBO-22685

Is actual

 

TRUE

Is arrival

 

1

Movement Message Contacts

 

BravoCat

MTOW kg

 

13744

MTOW ton

 

14

Noise category

 

 

Noise chapter

 

 

Non-transit pax count

 

1

Non-transit pax count in

 

1

Non-transit pax count out

 

 

Number of seats

 

8

Operator Address 1

 

Perlacher Strasse 16

Operator Address 2

 

 

Operator AOC expire date

 

 

Operator AOC number

 

 

Operator carrier code

 

 

Operator City

 

Gruenwald

Operator Country

 

Germany (DE)

Operator Country for VAT

 

Germany (DE)

Operator Email 1

 

 

Operator Email 2

 

 

Operator Fax

 

 

Operator ID

The Operator contact’s unique ID in GUID format.

06b84ff4-8d6f-4709-ae4c-89e1cc96570d

Operator name

 

Tango VIP 13

Operator Phone 1

 

0049 089 641601 0

Operator shortest name

 

Tango VIP 13

Operator State

 

 

Operator VAT number

 

DE130209871

Operator Website URL

 

 

Operator Zip code

 

D-82031

OperatorAdministrationContactNo

 

 

OperatorContactContactNo

 

RST003

Operators handling order number

 

 

Order ID

The Order’s unique ID in GUID format.

49b251c1-fcbd-4f21-a51a-25cd38561dad

Order key

 

FBO-22685

Order state

 

Accounting | Invoiced

Order URL

 

 

OriginSystemId

Origin system ID for the imported flight leg.

 

OriginSystemIdLastSeenAtUtc

Most recent flight leg import time.

 

OriginSystemLastRow

JSON import data for flight leg.

 

OriginSystemNotes

Imported flight leg system notes.

 

OtcEndDateTimeLt

 

 

OtcEndDateTimeUtc

 

 

OtcStartDateTimeLt

 

 

OtcStartDateTimeUtc

 

 

Parking position

 

 

Pax count

 

1

Pax count in

 

1

Pax count out

 

 

Pax crew count

 

3

Pax crew count in

 

3

Pax crew count out

 

 

Pax names

 

 

Pilot names

 

Siegfried STEINER

PlanBoard messages full

 

 

PlanBoard messages short

 

 

Primary order number

 

22685

QRCode

 

 

Quick turn

 

TRUE

Receipt Number

 

 

Registration and flight number

 

FRS88K

Registration and flightnumber if not registration

 

FRS88K

Second In Command names

 

Jochen Georg Haunreiter

Services Internal Remarks

 

 

Services list

 

PAX TPT (EXECUTIVE), PAX TPT PRICE, GAR/GENDEC, CAT 4 - FIRE UPGRADE

Services Remarks

 

PAX TPT (EXECUTIVE): BQH - BROMLEY SOUTH

Services states

 

PAX TPT (EXECUTIVE): Completed, PAX TPT PRICE: Price Entered, GAR/GENDEC: Sent to BC and SB, CAT 4 - FIRE UPGRADE: Completed

Services suppliers

 

PAX TPT (EXECUTIVE): Limo, GAR/GENDEC: Foxtrot Aero 12, CAT 4 - FIRE UPGRADE: Lima Aero 12

Task list

 

PAX TPT (EXECUTIVE) on FBO-22685, PAX TPT PRICE on FBO-22685, GAR/GENDEC on FBO-22685, CAT 4 - FIRE UPGRADE on FBO-22685

ToICAO

 

 

Transit pax count

 

 

Transit pax count in

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

0

Transit pax count out

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

0

Trip Number

 

 

Trip Support Provider Address 1

 

111 Industrial Ave

Trip Support Provider Address 2

 

Teterboro Airport

Trip Support Provider City

 

Teterboro

Trip Support Provider Country

 

United States (US)

Trip Support Provider Email 1

 

ops@bravocat.com

Trip Support Provider Email 2

 

accounts@bravocat.com

Trip Support Provider Fax

 

+001 555 111 113

Trip Support Provider ID

Trip support provider contact’s unique ID in GUID format.

e800e52d-47ac-4c63-a914-000afad2bfef

Trip Support Provider name

 

BravoCat

Trip Support Provider Phone 1

 

+001 555 111 111

Trip Support Provider shortest name

 

BravoCat

Trip Support Provider State

 

NJ

Trip Support Provider Website URL

 

bravocat.com

Trip Support Provider Zip code

 

07608

See also:

Services query

Orders query