Data fields
Information for inventory items is displayed in these common fields
throughout Inventory Intelligence.
Note: You can use the personalization
action to add additional fields. For example, to add the location name, add the
InventoryLocation.Name business class.
General fields
This table shows fields that are available in all data grids:
| Field | Description |
|---|---|
| Status | The current status of the recommendation. Review, Approved, Skipped, or Sent. If the item does not currently have a recommendation, this field is blank. |
| Item | Unique ID of the item. |
| Description | Item description. |
| Sent to Item Location | Time stamp of the last time the record was sent to Item Location. |
| Removal Candidate | Items with less than three transaction days are considered candidates for removal. |
| Stock UOM | Unit of Measure by which an item is stocked. For example, case, each, package, box, roll. |
| In Scope | All items are in scope by default. An item can be set to out of scope in the menu. An item that is set to out of scope is not included in future recommendations. |
| Analysis Type | Type of simulation performed on an item.
|
| Reference Inventory Value | Inventory value for the item at this location sent from Reference at the start of the recommendations run. |
| Target Inventory Value | Inventory value for the item at this location if the recommendation or override is accepted. |
| Inventory Value Change | Difference between the reference and target inventory values. |
| Final Product Cost | Calculated cost for the item at this location. |
| First Record/Last Record and First Issue/Last Issue for perpetual items | The date of the first or last record in history for this item sent from your Reference to Inventory Intelligence. |
| Total Locations | Total number of locations the item is used. |
Perpetual item reorder point and maximum order fields
For each perpetual item, Inventory Intelligence makes recommendations for reorder point value (ROP) and maximum order value. This table shows fields that are available in the Reorder Point and Maximum Order sections of a data grid:
| Field | Reorder point | Maximum order |
|---|---|---|
| Reference | Reorder point from Item Location at the time the recommendation was made. | Maximum order from Item Location at the time the recommendation was made. |
| Recommended | Recommendation for reorder point value. This recommendation is reviewed and can be approved and sent to Item Location, skipped, or overridden. | Recommendation for maximum order value. This recommendation is reviewed and can be approved and sent to Item Location, skipped, or overridden. |
| Override | Specify an override value to send to Item Location. You can specify an Override ROP regardless of whether the item has
a recommendation. Click inside the Override column, then set a value and save. The
status changes to Review. Note: The
override value must be a positive integer.
|
Specify an override value to send to Item Location. You can specify an Override Max Order regardless of whether the
item has a recommendation. Click inside the Override column, then set a value and
save. The status changes to Review. Note: The override value must be a positive integer.
|
| Direction | Direction of the reorder point value by Increase, Decrease, or Other. | Direction of the maximum order value by Increase, Decrease, or Other. |
| Change | The difference of the recommendation ROP value from the reference ROP value. For example, a value of 10 indicates a recommended increase of 10 units; a value of -10 indicates a recommended decrease of 10 units | The difference of the recommendation max order value from the reference max order value. For example, a value of 10 indicates a recommended increase of 10 units; a value of -10 indicates a recommended decrease of 10 units |
| Abs % Change | The percentage change as an absolute value of the recommendation from the reference. For example, a value of 10% indicates the recommendation is either an increase or decrease of 10%. Refer to the Direction field for additional context. | The percentage change as an absolute value of the recommendation from the reference. For example, a value of 10% indicates the recommendation is either an increase or decrease of 10%. Refer to the Direction field for additional context. |
| Current | Reorder point from Item Location based on the most recent Daily Data run. | Maximum order from Item Location based on the most recent Daily Data run. |
Perpetual item KPI fields
This table shows fields that are available in the KPI section of a data grid and in the summary description of an item on theItem Details tab:
| Field | Description |
|---|---|
| Max Daily Issues | Maximum number of daily issues during the analysis window. |
| Avg Non-zero Issues | Average number of issues on days that had an issue. |
| Avg Daily Issues | Average number of issues per day. |
| Stockout Days | Number of days when an item was out of stock during the analysis window. |
| Stockout Events | Number of days when an item first went out of stock during the analysis window. |
| Turns | Number of times inventory is used during the relevant time period. This value is calculated as average daily issues divided by average stock on hand. |
| Avg SOH | Average stock on hand during the analysis window. |
| Simulated Avg SOH | Simulated average stock on hand during the analysis window. Shows the average stock on hand for the current analysis window when the reorder point is Recommended instead of Reference. |
| Avg Stock On Hand Percent Change | The percent difference between Simulated Avg SOH and Avg SOH. For example, for a Simulated Avg SOH with value of 12 and an Avg SOH with value of 10 is a difference of 20%. A Simulated Avg SOH with value of 9 and Avg SOH with value of 10 is a difference of -10%. |
| Avg Inventory Cost | Average inventory cost during analysis window. This value is calculated as the final product cost multiplied by the average stock on hand. |
| Simulated Avg Inventory Cost | Simulated average inventory cost during analysis window. Shows the average inventory cost when the reorder point is Recommended instead of Reference. This value is calculated as the final product cost multiplied by the average stock on hand. |
| Avg Inventory Cost Percent Change | The percent difference between Simulated Avg Inventory Cost and Avg Inventory Cost. For example, for a Simulated Avg Inventory Cost with value of 12 and an Avg Inventory Cost with value of 10 is a difference of 20%. A Simulated Avg Inventory Cost with value of 9 and an Avg Inventory Cost with value of 10, there is a difference of -10%. |
| Actual Service Level | Actual service level for current analysis window. |
| Simulated Service Level | Simulated service level for current analysis window. Shows the predicted service level with a reorder point of Recommended instead of Reference. |
| Service Level Change | This is the difference between a simulated and actual service level. The value is calculated as Simulated Service Level minus Actual Service Level. |
Par item general fields
This table shows general fields that are available in the data grid for par items:
| Field | Description |
|---|---|
| Par UOM | Par unit of measure. |
| Par Multiplier | Par unit of measure conversion factor. |
| Target Days Between Orders | For par items, recommended target frequency of placing orders or replenishments. For example, a value of 1 indicates a recommended order frequency of daily and a value of 7 indicates a recommended order frequency of weekly. |
| Par Level Daily | Reference recommended par level for daily replenishments. |
| Par Level Semiweekly | Reference recommended par level for replenishments twice per week. |
| Par Level Weekly | Reference recommended par level for weekly replenishments. |
Par level fields
For each par item, Inventory Intelligence makes recommendations for par level. This table shows fields that are available in the Par Level section of a data grid:
| Field | Description |
|---|---|
| Reference | Par level from Item Location at the time the recommendation was made. |
| Recommended | Recommendation for par level value. This recommendation is reviewed and can be approved and sent to Item Location, skipped, or overridden. |
| Override | Specify an override value to send to Item Location. You can specify an Override par level regardless of whether the
item has a recommendation. Click inside the Override column, then set a value and
save. The status changes to Review. Note: The override value must be a positive integer.
|
| Direction | Direction of the par level value by Increase, Decrease, or Other. |
| Change | The difference of the recommendation par level value from the reference par level value. For example, a value of 10 indicates a recommended increase of 10 units. A value of -10 indicates a recommended decrease of 10 units |
| Abs % Change | The percentage change as an absolute value of the recommendation from the reference. For example, a value of 10% indicates the recommendation is either an increase or decrease of 10%. Refer to the Direction field for additional context. |
| Current | Par level from Item Location based on the most recent Daily Data run. |
Par item KPI fields
This table shows fields that are available in the KPI section of a data grid and in the summary description of an item on the Par Item Details tab:
| Field | Description |
|---|---|
| Average Daily Demand | Average usage per day, including days with no usage, during the analysis window. |
| Max Daily Replenishments | Maximum number of daily replenishments during the analysis window. |
| Average Non Zero Demand | Average usage per day, excluding days with no usage, during the analysis window. |
| Transaction Days | Number of days with activity within the specified time period. |
| Avg Transaction Days Per Week | Activity per week is calculated as transaction days divided by total days, in the specified time period. |