Stock Transaction Statistics sourced measures and KPIs
This table shows the Stock Transaction Statistics measures that are sourced directly in Data Warehouse.
Most measures have Avg, Max, Min, and Sum aggregations. For cases where this does not apply, the available aggregations are indicated in this table:
| Measure | Description |
|---|---|
| Annual Usage Qty | A running year's usage of an item based on historical item statistics |
| Annual Usage Value | Annual usage quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Annual Usage Weight | Annual usage quantity multiplied by the net weight |
| Avg OHB Qty | Simulated average on-hand balance in MMS220 |
| Avg OHB Value | Average on-hand balance multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Avg OHB Weight | Average on-hand balance multiplied by the net weight |
| Budgeted Qty | Budgeted quantity to be used during the period |
| Budgeted Value | Budgeted quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Budgeted Weight | Budgeted quantity multiplied by the net weight |
| Cross Docked Qty | Quantity that was cross-docked in a warehouse |
| Cross Docked Value | Cross-docked quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Cross Docked Weight | Cross-docked quantity multiplied by the net weight |
| Forecasted Qty | Forecasted quantity for each item/family item |
| Forecasted Value | Forecasted quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Forecasted Weight | Forecasted quantity multiplied by the net weight |
| Manufactured Qty | Internally manufactured quantity in basic unit of measure |
| Manufactured Value | Manufactured quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Manufactured Weight | Manufactured quantity multiplied by the net weight |
| Mfd and Purch Qty | Manufactured quantity plus the purchased quantity |
| Mfd and Purch Value | Manufactured value plus the purchased value |
| Mfd and Purch Weight | Manufactured weight plus the purchased weight |
| Neg Phys Inv Qty | Total of all negative physical inventory differences in basic unit of measure |
| Neg Phys Inv Value | Negative physical inventory variance quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Neg Phys Inv Weight | Negative physical inventory variance quantity multiplied by the net weight |
| Neg Reclass Qty | Quantity that has been reclassified to another item |
| Neg Reclass Value | Negative reclassification quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Neg Reclass Weight | Negative reclassification quantity multiplied by the net weight |
| Neg Transfer Qty | Quantity distributed/transferred to other warehouses in basic unit of measure |
| Neg Transfer Value | Negative transfer quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Neg Transfer Weight | Negative transfer quantity multiplied by the net weight |
| No. of Cross Docks | Number of cross-dockings that have been performed |
| No. of Issues | Number of physical movement of items from a stocking location |
| No. of Phys Inv | Number of occasions when physical inventory was done |
| No. of Planned Orders | Number of planned orders for the item |
| No. of Receipts | Number of receipt reportings that have been performed |
| No. of Records | Number of stock transaction statistics records Aggregation: Sum |
| No. of Rej Phys Inv | Number of physical inventory occasions where discrepancies beyond the tolerance limits had to be accepted |
| No. of Returns | Number of times that the item has been subject to stock returns |
| No. of Verified Failures | Number of verified failures of an item |
| Non Rep Usage Qty | Quantity not affecting other usage statistics in basic unit of measure |
| Non Rep Usage Value | Non-representative quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Non Rep Usage Weight | Non-representative quantity multiplied by the net weight |
| Opt Stat Field Qty | Optional quantity of a user-defined item statistics field |
| Opt Stat Field Value | Optional statistics field quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Opt Stat Field Weight | Optional statistics field quantity multiplied by the net weight |
| Planned Qty | Planned quantity in basic unit of measure |
| Planned Value | Planned quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Planned Weight | Planned quantity multiplied by the net weight |
| Pos Phys Inv Qty | Total of all positive physical inventory differences in basic unit of measure |
| Pos Phys Inv Value | Positive physical inventory variance quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Pos Phys Inv Weight | Positive physical inventory variance quantity multiplied by the net weight |
| Pos Reclass Qty | Quantity that has been reclassified from one item to another |
| Pos Reclass Value | Positive reclassification quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Pos Reclass Weight | Positive reclassification quantity multiplied by the net weight |
| Pos Transfer Qty | Quantity distributed/transferred to the current warehouse from other warehouses |
| Pos Transfer Value | Positive transfer quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Pos Transfer Weight | Positive transfer quantity multiplied by the net weight |
| Purchased Qty | Purchased quantity in basic unit of measure |
| Purchased Value | Purchased quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Purchased Weight | Purchased quantity multiplied by the net weight |
| Requested Qty | Requested quantity from customer order lines |
| Requested Value | Requested quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Requested Weight | Requested quantity multiplied by the net weight |
| Scrapped Qty | Total scrapped quantity in manufacturing unit of measure |
| Scrapped Value | Scrapped quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Scrapped Weight | Scrapped quantity multiplied by the net weight |
| Sold Qty | Sold quantity in basic unit of measure |
| Sold Value | Sold quantity multiplied by the standard or average cost in the division currency relative to inventory accounting method |
| Sold Weight | Sold quantity multiplied by the net weight |
| Used Qty | Used quantity in basic unit of measure |
| Used Value | Used quantity multiplied by the standard or average cost relative to inventory accounting method in the division currency |
| Used Weight | Used quantity multiplied by the net weight |