Column Definitions

Menu > Workbench

There are a variety of different fields in the columns on the Workbench. Below are the definitions for each field. You can use this guide to determine which columns may be the most useful for your screen layout.

Field	Description
Part Number	The part number
Location	The location for the part
Description	A description of the part
Order Notes	Indicates the status of the last action taken on a supply order. See Order Notes.
Revision (Rev)	If you use revisions, the revision number/text for the part number. If you do not use revisions for your part numbers, this field will be blank.
Priority	The current priority planning status for the part.
Alert Status	For CIA alerts, this indicates the severity of the stock out. For MSA and PSO alerts, this is the severity of the alert and the date that the detected alert will occur.
Alert Type	The type of the alert on the part: Current Inventory, Material Synchronization, Projected Stock Out.
Availability Shortage	Flag that indicates that there is a shortage on a child part for this part. Only available for Make parts.
Planner	Planner code assigned to a part.
Auto Approve Recommended Orders	The Auto Approve feature will allow R+ Recommended Orders to be automatically accepted and sent to the Pending Orders Table. Auto Approve has to be set at a location level in the Site Administration Settings and also turned on at the part level to work.
Spike	Flag that indicates a demand spike has been detected for the part.
Issued Qty	An optional second inventory field that should only be used if you have two inventory fields in your ERP system that combine to create the "total" inventory. The Current Inventory in R+ is the sum of the Issued Qty and the On Hand quantities.
On Hand	The On Hand Inventory for the part. Most often used to store the inventory quantity received from your ERP system. Can be used with the Issued Qty.
Supply Orders	Total amount of open supply for this part.
Supply Order Follow Up By	Date on the most recently updated supply order note.
Supply Order Note	Note entered by planner on a supply order. Used to manage and track actions taken on alerts.
Demand Allocations	All qualified demand on the part for today. This includes all demand due today, past due, and any spikes in the future.
Targeted Inventory	Target Inventory level defined as Red Zone + Half Green Zone + Applicable CDAF
Inventory Planning	Planning Strategy acronym for the part: NB, the Buffer Profile, MM, RO, LTM
Buffer Profile	Buffer profile assigned to the part. Will be blank if the part is Non-buffered, Min-Max, or Replenish Override.
Inventory Method	Planning Strategy for the part: Non-Buffered, Replenished, Min-Max, Replenished Override, Lead Time Managed
% of Buffer	The Net Flow divided by the Top of Green, expressed as a percentage.
ToR	Top of Red; this is equal to the Total Red Zone
ToY	Top of Yellow; this is equal to Total Red Zone + Total Yellow Zone
ToG	Top of Green; this is equal to the Total Red Zone + Total Yellow Zone + Total Green Zone
Reorder Qty (From)	If the purchase and base/inventory units differ, this is the recommended reorder quantity in purchase order units.
Net Flow	Current Inventory + Supply - Qualified Demand
Reorder Qty (From) Units	If the purchase and base/inventory units differ, this is the Unit of Measure for Purchase Order Units. Optional.
Reorder Qty	The recommended reorder quantity. This field will be blank if there is no recommended reorder for the part. If the purchase and base/inventory units differ, this will also be the recommended reorder quantity in base units.
Unit Of Measure	The base inventory unit of measure (each, feet, etc).
Schedule Order Date	Day that the order will be placed. If the Net Flow is in the Yellow or Red Zones, this will be today unless there is a planning calendar, in which case this field will respect the planning calendar dates + Fixed Lead Time. This field will be blank if the Net Flow is in the Green or OtoG zones.
Request Date	Desired delivery date. Often will be the same as the Promise Date depending on the field mapping between R+ and your ERP. If using Goods Receipt Time, this is the desired ship-out/pick-up date.
Order Receipt Date	Delivery date for the supply order. If using the Goods Receipt Time, this will be Request Date/Promise Date + Goods Receipt Time. If not using GRT, this will be the same as the Request/Promise date.
RPlus Lead Time	For Make and Distributed parts, the sum of Effective Lead Times in the longest unbuffered leg of the BoM. For purchased parts, this is always equal to the Effective Lead Time.
Fixed Lead Time	Guidelines for determining this lead time are based on Part Type: Purchased Parts = Vendor Lead Time plus, optionally, the time to make it available for next use (include receiving, inspection, etc.); Distributed Parts = Shipping and Staging Lead Time; Make Parts = Manufacturing Lead Time.
Effective Lead Time	Fixed Lead Time + Goods Receipt Time
Goods Receipt Time	Time in days required to make the parts available for use after ship-out or delivery by the supplier. Can be incorporated into the Fixed Lead Time or separated into the Goods Receipt Time. Examples include transportation time or quality hold time.
Average Daily Usage	Average Daily Usage is the average of demand over the ADU Horizon in the Site Administration settings. ADU is calculated each day on a rolling time horizon. Calculated as Total Demand in the Horizon / Working Days in ADU Horizon. Holidays in the Location Calendar are excluded from the number of Working Days. This value can also be imported from your ERP system.
Forecasted Daily Usage	Forecasted Daily Usage is the average of future demand over the number of weeks in the FDU Horizon in the Site Administration settings. FDU is calculated each week on a rolling time horizon. Calculated as Total Forecasted Weekly Demand in the FDU Horizon / Working Days in FDU Horizon. The sum of Total Forecasted Demand always begins with the next week's value (not the current week's value). Holidays in the Location Calendar are excluded from the number of Working Days. This value can also be imported from your ERP system.
User Defined Fields 1-16	Columns set up in the Site Administration settings that can be mapped to source ERP data
Vendor	Vendor Name
Vendor ID	Vendor Number or Identifier
Notes	A note icon will appear in this column if there are notes in the Notes tab in Part Details.
Source ERP	Host ERP system where data originated. Only used if you are connecting multiple software systems to R+.
Days Until Yellow	Number of days until net flow will reach the yellow zone. Calculated by dividing the (Net Flow-ToY)/EDU. Will be 0 if the Net Flow is in the Yellow or Red Zones. Will be blank if the part is non-buffered. Available in 4.16+
On Hand - Demand Allocations	On Hand - Demand Allocations. This field can be used to see how much of the current inventory would be left after subtracting the demand allocations. Available in 4.16+
Net Flow - ToG	Net Flow - Top of Green. If there is a reason to reorder while Net Flow is still in the Green Zone, the absolute value of this field would be the reorder quantity. Available in 4.16+
Fixed Reorder Cycle	Indicates if this part is using the Fixed Reorder Cycle feature. This feature is only available to items on auto-approval. Available in 4.17+
Order Interval Days	Days between the next available request date. Will always be 1 unless there is a planning calendar assigned to the part. Available in 4.17+
Standard Deviation of Demand	This is the standard deviation of demand over the standard deviation horizon in the Site Administration. The standard deviation is calculated with the Total Qty of demand and the total number of work days based on the Default and Location, and/or Part calendars. Available in 4.17+