Parts Order Statuses

The Parts Order Statuses dataset lists parts still on order for Work Orders, for tracking what is outstanding and when it is needed.

At a glance

Item Value
Picker heading Data Tables
One row is One part line on a Work Order
Presentations Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Heatmap
Default presentation Table
Default period None. This dataset has no Period.
Date basis None. A Heatmap uses Required Date (Work Order Due Date).
Default columns Work Order Number, Work Order Title, Asset Number, Department, Part Number, Supplier, Purchase Order Number, Requested Quantity, Ordered Quantity, Received Quantity, Outstanding Quantity, Status, Required Date, Expected Date, Asset Description
Group Modes Detail tables. Charts are Consolidated.
Drill-through Column Chart only

Measures

Measure Unit Aggregation Definition
Part order line count Lines Count Number of part lines on order.

Columns

Column Type Description
Work Order Number, Work Order Title Text The Work Order the part is for.
Work Order Due Date Date The Work Order's Due Date.
Part Number, Part Description Text The part.
Supplier Text The Purchase Order's supplier, or else the part's supplier.
Purchase Order Number Text The linked Purchase Order.
Requested Quantity, Ordered Quantity, Received Quantity, Outstanding Quantity Number How much was requested, ordered and received, and how much is still due.
Status Text The part line's order status.
Required Date, Expected Date Date When the part is needed and expected.
Department Text The Work Order's own department.
Asset Department Text The Asset's department.
Asset Number, Asset Description Text The Work Order's Asset.
Class, Group, Asset Type, Manufacturer Text The Asset's classification.
Asset Status, Criticality, Planning Type, Hire Status Text The Asset's details.
Project, Customer Text The Asset's Project and Customer.

Filters

Filter Choice Behaviour
Asset Number Multiple The Work Order's Asset.
Asset Department Multiple The Asset's department.
Class, Group, Asset Type, Manufacturer Multiple The Asset's classification.
Asset Status, Criticality, Planning Type Multiple The Asset's details.
Hire Status Yes, No, All Whether the Asset is on hire.
Project, Customer Multiple The Asset's Project and Customer.

Group By

Group By Groups by
By Asset The Work Order's Asset.
By Supplier The Purchase Order's supplier, or else the part's supplier.
By Department The Work Order's own department.
By Asset Department The Asset's department.
By Year The year of the Work Order's Due Date.
By Class, By Group, By Asset Type, By Manufacturer The Asset's classification.
By Planning Type, By Asset Status, By Criticality The Asset's details.
By Hire Status On Hire or Off Hire.
By Project, By Customer The Asset's Project and Customer.

Records with no value appear under Unknown.

Chart notes

  • Line and Area charts draw one point per group, because this dataset has no time periods.
  • A Heatmap places each line on its Required Date.
  • Series by, Compare and Compare with are not available.

Business rules

  • Only parts still on order appear. A line must be linked to a Purchase Order line, with status Backorder, Pending Approval, Approved or On Order.
  • The Event must still be pending. Lines appear only when the Work Order's Event has a Pending status.
  • There is no Period. The dataset shows what is on order now.

For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.