Running stock query
The Running stock query is used to display the fuel stock mutations (uplifts, purchases, drains) over a specified period of time. Data included: ticket number, meter values, amount of fuel, and fuel stock.
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
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
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 |
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 |
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
| Uplift |
Sales row type name |
| 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 |
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 |