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