Stock mutations query

This query will only work in combination with the fuel module. The Stock mutations query will generate one row per stock mutation.

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

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

NO

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

SKU

Filters on the stock keeping unit, e.g. JET A1 or AVGAS. Multiple SKUs can be chosen for filtering. Note: If left blank, all SKUs will be shown.

NO

Stock location

Filters on the stock location, e.g. Jet Truck. Note: If used in conjunction with SKU filter, then ensure the stock location matches the SKU to show mutations.

NO

Start date / End date

Filters on the start and end of fuel tickets/mutations (Local time). Use Start and End dates together to create a date range of mutations.

YES (If ‘Entry period’ is blank)

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 a fuel tickets supplier.

NO

Aircraft registration

Filter by an order’s aircraft registration.

NO

Entry period

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

YES (If ‘Start date / End date’ is blank)

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

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Name

Description

Example

AffectsPhysicalStock

If the stock mutation has an effect on in stock amount. For example, credited orders and re-bills for fuel tickets.

TRUE

Aircraft registration ID

Order’s aircraft registration unique ID in GUID format.

8e7348cf-52e8-4058-afdb-eeb9e01c30f5

Aircraft type iata code

Order’s aircraft type IATA code

PL2

Aircraft type icao code

Order’s aircraft type ICAO code

PC12

Amount Airport fees

Airport fees amount charged. Products in the product tree with the custom value ‘Airport Fees custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Airport Fees custom value'.

0

Amount Airport fees in booked currency

Airport fees amount charged in booked currency. Products in the product tree with the custom value ‘Airport Fees custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Airport Fees custom value'.

0

Amount Duty tax

Duty Tax amount charged. Products in the product tree with the custom value ‘Duty Tax custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Duty Tax custom value'.

365.09

Amount Duty tax in booked currency

Duty Tax amount charged in booked currency. Products in the product tree with the custom value ‘Duty Tax custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Duty Tax custom value'.

365.09

Amount Fuel

Fuel basic amount charged. Products in the product tree with the custom value ‘Fuel Amount custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Fuel Amount custom value'.

357.33

Amount Fuel in booked currency

Fuel basic amount charged in booked currency. Products in the product tree with the custom value ‘Fuel Amount custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Fuel Amount custom value'.

357.33

Amount Labour fees

Labour amount charged. Products in the product tree with the custom value ‘Labour Fees custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Labour Fees custom value'.

0

Amount Labour fees in booked currency

Labour amount charged in booked currency. Products in the product tree with the custom value ‘Labour Fees custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Labour Fees custom value'.

0

Amount Throughput fees

Throughput amount charged. Products in the product tree with the custom value ‘Throughput Fees custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Throughput Fees custom value'.

0

Amount Throughput fees in booked currency

Throughput amount charged in booked currency. Products in the product tree with the custom value ‘Throughput Fees custom value’ are summed. See SKUs (Stock keeping units) (Administration) 'Throughput Fees custom value'.

0

Amount VAT

VAT amount charged for the stock mutation in the charged currency.

0

Amount VAT in booked currency

VAT amount charged for the stock mutation in the invoice booked currency.

0

Applied Exchange Rate

Currency exchange rate applied to the fuel ticket based upon the fuel ticket date. The exchange rate is the rate between the two currencies defined by ‘Booked currency code' and 'Charged currency code’. See Exchange rates (Administration).

1.315

Awarded reward program points

Amount of points awarded from connected reward program. See Reward programs (Administration).

10

Booked currency code

Currency code for booked currency.

CHF

Carrier Code

Operator’s carrier code.

JFA

Charged currency code

Currency code charged on order.

CHF

Debtor contact ID

Order’s debtor unique ID in GUID format.

42ee2976-913f-4f89-97c0-55738f02540e

Debtor Contact Number

Debtor’s: ‘Contact number’

3028997

Debtor display name

Debtor’s display name: ‘Organization name (Contact Number)’

JETFLY Aviation SA (3028997)

Debtor name

Debtor’s: ‘Organization name’.

JETFLY Aviation SA

Debtor short name

Debtor’s: ‘Short name (Contact Number)'

JETFLY LUXEMBOURG (3028997)

Debtors order number

Debtor’s order number on the order, for example, this can be the fuel release number.

708407-800000-49399 12/21

Density in Kg per Liter

Gross density in KG recorded on the fuel ticket.

0.804

Density unit code Kg Per Liter

Density unit code.

kg/ltr

Destination iata

Order’s destination station IATA code.

ZHK

Destination icao

Order’s destination station ICAO code.

LSGK

Destination name

Order’s destination station name ‘ICAO/IATA(NAME)’.

LSGK/ZHK (SAANEN)

Differential pressure in psi

Differential pressure in psi defined in the fuel ticket. See Stock locations (Administration) meters.

1

Duty ROX diff

 

0

Duty to be claimed in booked currency

 

0

Duty to be paid in booked currency

 

0

End date LT

End date for the stock mutation (Local time).

01-Jan-20

End date time LT

End date and time for the stock mutation (Local time).

01-Jan-20 08:20

End date time UTC

End date and time for the stock mutation (UTC).

01-Jan-20 07:20

Entry ID

Entry unique ID in GUID format.

8dc2b4e3-d1a8-4a2e-9167-325c28794cef

Entry number

Entry number for the invoice the stock mutation is on. See Entries (Back office).

233

Entry period number and year

Entry period number and year for the stock mutation. See Entry periods (Back office).

9-2019

External remarks

External remarks on the fuel ticket.

Fuel card used.

Fbo location short name

FBO short name for the fuel ticket.

GVA

Flight

Order’s flight numbers (Inbound flight number/Outbound flight number) the stock mutation is on.

JFA101/JFA102

Flow rate in liters per minute

Flow rate in liters defined in the fuel ticket. See Stock locations (Administration) meters.

100

Form of payment

The form of payment used on the order.

BILL MONTHLY CHF

Fuel ticket debtor order number

Displays the fuel tickets debtor order number.

123122

Fuelled by contact display name

Selected ‘Fuelled by’ user for the mutation.

Adam Marriott

FuelType

SKU fuel type for the stock mutation.

Jet Fuel

Handling station IATA code

Order’s handling station IATA code.

GVA

Handling station ICAO code

Order’s handling station ICAO code.

LSGG

Handling station name

Order’s handling station name ‘ICAO/IATA(NAME)’.

GENEVA COINTRIN

Inbound flight number

Order’s inbound flight number.

JFA101

InternalRemarks

Internal remarks on the fuel ticket.

Fuel with fuel release only.

Invoice ID

Invoice unique ID in GUID format.

71eec7b8-ca84-4905-8e14-5177e07fdb49

Invoice number

Invoice number for this stock mutation.

852

Is duty tax charged

If duty tax products have been charged for the fuel ticket. See SKU excise taxes (Administration).

TRUE

Is excise applicable

If SKU excise taxes are marked as ‘Yes’ for the fuel ticket. See SKU excise taxes (Administration).

TRUE

Is form of payment carnet

If the form of payment for the order is carnet. See Forms of payment (Administration).

FALSE

Is form of payment on account

If the form of payment for the order is on account (has credit). See Forms of payment (Administration).

TRUE

Is on primary order

Indicates if the stock mutation is on a primary or a secondary/split order.

  • TRUE = Primary order e.g. FBO-100

  • FALSE = Secondary/Split order e.g. FBO-100-2

TRUE

Is prist added

If prist (anti-icing agent) has been ticked for the fuel ticket as added.

FALSE

Is throughput

If the stock mutation is a throughput sale (uplift is paid by one of the fuel suppliers).

FALSE

Liter

Gross fuel volume in liters.

477

Margin in booked currency

 

 

Meter end value

Meter end count for the stock location, for this mutation.

87080706

Meter name

The name of the meter. See Stock locations (Administration).

SATAM

Meter start value

Meter start count for the stock location, for this mutation.

87080229

MTOW in US Pounds

Order’s aircraft MTOW in US pounds.

10450

MTOW kg

Order’s aircraft MTOW in kg.

4740

MTOW ton

Order’s aircraft MTOW in ton (rounded up).

5

Net liter

Volume of fuel in liters after any density/temperature conversions (Net) for the fuel ticket.

483

Net USG

Volume of fuel in USG after any density/temperature conversions (Net) for the fuel ticket.

128

Net volume

Volume of fuel after any density/temperature conversions (Net) for the fuel ticket. See Table Conversions (Administration).

483

NetDensityInKgPerLiter

Net density in kg for the ticket based upon density and temperature conversion factor. See Table Conversions (Administration).

(Density in Kg per Liter * Conversion factor).

0.794

Operator contact ID

Order’s operator unique ID in GUID format.

42ee2976-913f-4f89-97c0-55738f02540e

Operator display name

Order’s operator’s display name: ‘Organization name’.

JETFLY Aviation SA

Operator short name

Order’s operator’s: ‘Contact number’.

JETFLY LUXEMBOURG

Order ID

The Order’s unique ID in GUID format.

a1b508e7-7306-43d1-a4b1-44e143b320a8

Order key

The Order key the mutation is on.

GVA-32734

Order state

The current Order state.

Invoiced

Origin iata

Order’s origin station IATA code.

BQH

Origin icao

Order’s origin station ICAO code.

EGKB

Origin name

Order’s origin station name ‘ICAO/IATA(NAME)’.

EGKB/BQH(Biggin Hill)

Other revenues in booked currency

 

 

Outbound flight number

Order’s outbound flight number.

JFA102

Parking position name

Current parking position for the order.

E2

Pay VAT

If VAT for the fuel products are not 0.00 and therefore have been charged.

FALSE

Prist amount

Prist amount if added in displayed unit.

5

Prist liters

Prist amount if added converted to liters.

15

Product code

Header product code for the fuel ticket.

JET A1 UPLIFT GVA

Purchase amount in booked currency

 

 

Registration code

Order’s aircraft registration code.

LXJFQ

Remarks

Remarks for the stock mutation, including internal remarks, back office remarks and stock warnings.

Inventory below 0

Reward account holder display name

 

A.Marriott

Reward account holder email

 

adam@amsterdamsoftware.com

Reward account holder first name

 

Adam

Reward account holder last name

 

Marriott

Reward program

 

Sky Miles

Reward program account number

 

1647521664

Reward program costs in booked currency

 

 

Sale amount in booked currency

 

 

Service ID

The orderline’s (fuel product) unique ID in GUID format.

ac50d264-21f7-4ded-b2f3-b2eda040ef42

Service state

The current workflow state for the fuel ticket.

Approved

Sku

SKU name. See SKUs (Stock keeping units) (Administration).

JET A1

Source meter name

Source stock location meter name. See Stock locations (Administration).

SATAM

Source stock location name

Stock location source for fuel. E.g. Fuel truck.

396

Start date LT

Start date for the stock mutation (Local time).

01-Jan-20

Start date time LT

Start date and time for the stock mutation (Local time).

######

Start date time UTC

Start date and time for the stock mutation (UTC).

######

Stock mutation ID

The stock location’s unique ID in GUID format.

96f56edb-f4e2-4303-9319-c092e52f45b4

Stock mutation type code

Stock mutation type code (first letter of type name)

  • U = Uplift

  • D = Defuel

  • P = Purchase

  • T = Transfer

U

Stock mutation type name

Stock mutation type name describing type of mutation.

  • Uplift

  • Defuel

  • Purchase

  • Transfer

Uplift

Supplier Contact ID

Supplier contact for the fuel ticket’s unique ID in GUID format.

42ee2976-913f-4f89-97c0-55738f02540e

Supplier Contact Number

Supplier contact for the fuel ticket: ‘Contact number’

3028997

Supplier Display Name

Supplier contact for the fuel ticket display name: ‘Organization name (Contact Number)’

JETFLY Aviation SA (3028997)

Supplier Name

Supplier contact for the fuel ticket: ‘Organization name’.

JETFLY Aviation SA

Supplier Short Name

Supplier contact for the fuel ticket: ‘Short name (Contact Number)'

JETFLY LUXEMBOURG (3028997)

Target meter name

Target stock location meter name. See Stock locations (Administration).

 

Target stock location name

Target stock location for fuel, where the fuel is transferred to. This can be an aircraft registration or other stock location.

 

Temperature

Recorded temperature on the fuel ticket.

1

Temperature unit

Temperature unit defined in the SKUs (Stock keeping units) (Administration).

  • C = Celsius centigrade

  • F = Fahrenheit

C

Ticket number

The ticket number.

859

Ticket number with group

 

 

Total amount incl VAT

Total charged amount including VAT in charged currency.

722.42

Total amount incl VAT in booked currency

Total charged amount including VAT in booked currency.

722.42

Total profit in booked currency

 

 

USG

US gallon amount for the mutation. (Liter to US Gallon = 3.785412)

126

Volume

Gross fuel volume in SKU unit. See SKUs (Stock keeping units) (Administration) 'Unit of volume'.

477

VolumeUnit

Volume unit used for the stock mutation. See Units (Administration).

ltr

Weight

Weight in SKU unit using ‘Default density in Kg per liter’ defined in SKUs (Stock keeping units) (Administration).

(Net Volume * Default density in kg/liter).

384

WeightUnit

Weight unit used for the stock mutation. See Units (Administration).

kg