Sourced measures and KPIs
This table shows the measures that are sourced directly in Data Warehouse:
| 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 |
| Catch Weight Loss | Total variance in the catch weight for an item |
| 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 & Purch Qty | Manufactured quantity plus the purchased quantity |
| Mfd & Purch Value | Manufactured value plus the purchased value |
| Mfd & 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 |
| 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 |