Running stock query

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

Note: Each stock location will have a ‘Start balance’ and ‘End balance’ showing the start and end stock based upon the ‘Start date' and ‘End date’.

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

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 (LT) / End date (LT)

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

NO

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Name

Description

Example

Aircraft registration

 

AffectsPhysicalStock

If the stock mutation has an effect on in stock amount. See ‘AffectsPhysicalStockExplanation’ if mutation has no effect on stock amount (FALSE).

TRUE

AffectsPhysicalStockExplanation

Displays the reason for this mutation not having any effect on the in stock level. For example, credited orders and re-bills for fuel tickets.

Credit has no effect on inventory

Debtor contact number

Order’s debtor ‘Contact number’.

100022

Debtor ID

Order’s debtor contact unique ID in GUID format.

e89f4d6f-28d5-45d9-a358-280ba7a11ca8

Debtor short name

Order’s debtor ‘Short name’.

SOCAR

Delta gross volume

Volume of fuel before any density/temperature conversions (Gross) for the fuel ticket.

-613

Delta net volume 

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

-616

Delta volume adjustment

Adjustment volume amount. Difference between Gross and Net volumes for the fuel ticket.

3

Delta weight

The weight of the fuel net volume.

-489

Density in Kg per L

Gross density in KG recorded on the fuel ticket.

0.789

Differential pressure in psi

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

1

End date LT

End date for the stock mutation (Local time).

16-Oct-20

End date time LT

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

16-Oct-20 16:35

End date time UTC

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

16-Oct-20 14:35

FBO

FBO short name for the fuel ticket.

GVA

Flow rate in liters per minute

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

100

Form of payment

The form of payment used on the order.

WORLD FUEL SERVICE Fuel Card

Fuelled by

Selected ‘Fuelled by’ user for the mutation.

Adam Marriott

In stock gross volume

In stock gross volume before any density/temperature conversions. Note: This will be blank if density/temperature conversions are used, see ‘In stock net volume

100000

In stock net volume

In stock net volume after all density/temperature conversions.

119062

In stock weight

In stock weight

94550.2

Is Backoffice approved

If the fuel ticket has been approved by the back office.

TRUE

Is throughput

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

TRUE

Meter end

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

83655019

Meter name

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

SATAM

Meter start

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

83654406

Mutation Type

  • 0 = Uplift

  • 1 = Purchase

  • 2 = Defuel

  • 3 = Transfer

Note: For excel reports (without RDL), the number values are converted to the text value.

Uplift

Order ID

The Order’s unique ID in GUID format.

54358a81-a40e-4457-afcf-d7d346f63a70

Order key

The Order key the mutation is on.

GVA-39731

Order state

The current Order state.

Front office file approved

Remarks

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

Inventory below 0

Row type

  • 0 = StockLocationHeader

  • 1 = PriorGaps (Warning about past gaps)

  • 2 = StockTakingDifference (Quantity difference due to stock taking)

  • = GapInMeterReadings

  • = StockMutation (Includes Uplifts, Purchases, Transfers, Defuel)

  • = StockTaking

  • = StartBalance

  • = EndBalance

Note: For excel reports (without RDL), the number values are converted to the text value.

StockMutation

Row type display name

Shows the display name for the ‘Row type’ column

  • StockLocationHeader = Stock location header

  • PriorGaps = Prior gaps

  • StockTakingDifference = Stock taking difference

  • GapInMeterReadings = Gap

  • StockMutation = Uplift, Purchase, Defuel or Transfer

  • StockTaking = Stock taking

  • StartBalance = Start balance

  • EndBalance = End balance

Uplift

Sales row type name

  • Delivery = For stock purchases to the FBO.

  • Throughput = For when the uplift is paid by one of the fuel suppliers.

  • Direct sale = A direct sale to the customer.

Throughput

SKU

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

JET A1

Source

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

142

Source meter name

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

SATAM

Start date LT

Start date for the stock mutation (Local time).

16-Oct-20

Start date time LT

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

16-Oct-20 16:35

Start date time UTC

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

16-Oct-20 14:35

Stock location

Stock location name for the mutation.

142

Stock mutation ID

The stock location’s unique ID in GUID format.

23347f76-d1e2-4d83-aa89-8efa6407f8a2

Target

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

FHMUT

Target meter name

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

SATAM

Temperature

Recorded temperature on the fuel ticket.

9

Temperature unit

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

  • C = Celsius centigrade

  • F = Fahrenheit

C

Ticket

The ticket number.

003999

Ticket URL

Direct link to the fuel ticket.

~/Orderline.aspx?orderlineid=0ef48dab-8732-4c49-b754-6dea3a7749b9

Volume unit

Volume unit of the stock mutation.

ltr

Weight unit

Weight unit of the stock mutation.

kg

Workflow state

The current workflow state for the fuel ticket.

Approved