Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

The Movements query gives information on flight movements, usually one line per movement.

...

It can be used as the base of any kind of movement report

Contents:

Table of Contents
minLevel1
maxLevel7
excludeRelated pages:

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.

Expand
titleClick here to see filter example...
Image Added

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.

Info

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’.

Image Added

 

...

Optional settings

...

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.

Expand
titleClick here to show a data provider settings example...
Image Added

Setting

Type

Default

Description

IncludeCancelledOrders

Boolean

FALSE

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

Note

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

...

Code Block

...

((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

...

AddBlankLineAfterEachMovement (bool; default = false)
Setting this 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.

...

. 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

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

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.

Info

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. 

Info

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

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