Supply Planning > Workflow > Analyze > Interactive Planner Worksheet > Interactive Planner Worksheet (Plan) > Deployments > Deployments (Fields)
Deployments (Fields)
The following describes the fields that could appear depending on how it is configured.
Field
Description
ABC Code
The ABC classification code assigned to the SKU.
ASL Locked
Indicates if the record has been locked [indicated with a Locked symbol] or edited [indicated with an Edited symbol].
ASL Source
Indicates the method used to remove the part from the location's authorized stocking list. Valid options are:
• Blank (not removed)
• Manually
• AutoPilot
Allocated
The condition when a part is on hand but it is already committed to another requirement. This value is usually client-driven and is an aggregated value.
Allocated Original
The Allocated quantity from the host system.
Amount Custom 1-15
A custom field that a user can define for an amount on the stock_amount table page.
Annual Demand
The forecasted demand for the next twelve months including any scheduled or non-recurring adjustments. This is used in the calculation of the Economic Order Quantity.
Annual Forecast
The annual forecasted quantity for the part/location combination.
Average Daily Forecast
The average daily forecasted quantity.
Average Period Forecast
The average forecasted quantity for a period (weekly or monthly).
Backorder
The original backorder amount that came from the host system.
Backorder Original
The original backorder amount that came from the host system.
Bad Available In Future
Future returns of bad parts using NFF rates OR future amounts coming from down-chain parts on bad orders depending on how roll up flags (roll up good, roll up bad, or roll good as bad) are set. Calculated as In Return * (1 - NFF).
Balancing Order Received
The inbound balancing order quantities (Recommended + Approved) for the specified date range.
Balancing Order Sent
The outbound balancing order quantities (Recommended + Approved) for the specified date range.
Calculated Safety Stock
The Safety Stock quantity as calculated by the system.
Critical Shortage Amount
The difference between on hand inventory and Safety Stock.
(Safety Stock * Critical Threshold / 100) - (On Hand Good - Allocated)
Critically Short Review Note
The critically short review note.
Current Period Forecast
The forecasted quantity for the current period.
Days on Hand
This is calculated based on the GENERATE_OP_SL_OUTSTOCK_DAYS global setting.
• When the global setting is set to false, the Days On Hand value is calculated by Stock Levels process as
(On Hand New + On Hand Fixed)/ Average Daily Demand Rate)
• When the global setting is set to true, the Days on Hand value is calculated as follows:
◦ For customers using Stock Levels process, iplan will still calculate the Days On Hand value as:
(On Hand New + On Hand Fixed)/ Average Daily Demand Rate)
◦ For Time Phased pairs: Days on Hand is based on when the planned On-Hand Good goes below zero. It relies on the Planned On Hand Good goes below 0 review reason.
◦ For Trigger pairs, Days On Hand is calculated as:
(On Hand New + On Hand Fixed)/ Average Daily Demand Rate)
When Forecast is zero, then Days on Hand is displayed as a blank
• Where Average Daily Demand Rate is defined as:
◦ If level source is MEO/SIO (Inventory Optimization) then the Average Daily Demand Rate is equal to IPCS_STOCK_LEVEL.OptDailyDmdRate
◦ If level source is Levels then the Average Daily Demand Rate is equal to IPCS_STOCK_LEVEL.SLDemandPerDay
EOQ
The Economic Order Quantity (EOQ) is the optimum quantity of goods to be purchased at one time in order to minimize the cost of ordering and holding items in inventory. The two main variables in the Economic Order Quantity (EOQ) calculation are:
• Order Cost
• Carrying Cost (also known as Holding Cost)
At any order point (be it one piece or one thousand pieces), by adding the Carrying Cost per part with the Order Cost per part, you get the total cost of that part.
EOQ Override
The override value for the Economic Order Quantity.
Excess Date
The date when an excess condition begins.
Excess End Date
The date when a part is no longer in an excess condition.
Excess Recall Received
The inbound excess recall order quantities (Recommended + Approved) for the specified date range.
Excess Recall Sent
The outbound excess recall order quantities (Recommended + Approved) for the specified date range.
Excess Review Note
The in excess review note.
Future Sales Order
The future sales order quantity.
Good Available in Future
Future returns of good parts using NFF rates OR future amounts coming from down-chain parts on good orders depending on how roll up flags (roll up good, roll up bad, or roll good as bad) are set. Good Available in Future = In Return * NFF
In Repair
The number of parts that are currently being repaired. Also known as Repair WIP (Work in Process).
In Repair Bad
A client-driven value that typically represents the amount of material in repair that is not yet repaired.
In Repair Good
A client-driven value that typically represents the amount of material in repair that has been repaired.
In Return
The number of parts that are defective and returned for exchange or repair under a Return Material Authorization (RMA). In some cases, this is In Return Bad + In Return Good.
In Return Bad
A client-driven value that typically represents the amount of bad material returned for exchange or repair under a Return Material Authorization (RMA).
In Return Good
A client-driven value that typically represents the amount of good material returned for exchange under a Return Material Authorization (RMA).
Is On ASL
An indicator of whether the part is on the Authorised Stock List (ASL).
• Yes indicates that the part is on the ASL
• No indicates that the part is not on the ASL
Is Pooled
Indicates that the demand forecasts for the pairs within the group/region are consolidated into one demand forecast for the part at the pooling location.
On Hand Bad
The number of bad parts in stock at this location that are awaiting a repair order.
On Hand Excess
The amount of good stock on hand at a location that is above the currently defined Stock Max level for the SKU.
• For trigger-based planning, on day 1 the On Hand Excess shows the excess value of on hand based on actual inventory and stock maximum.
• For time-phased and trigger-based planning, all days after day 1 the On Hand Excess shows the excess value based on actual inventory and Safety Stock + EOQ.
On Hand Fixed
The available stock that has previously been repaired and cannot be legally sold as new.
On Hand Fixed Original
The value from the host system. This is the rolled-up value for On Hand Fixed.
On Hand Good
Available good stock.
On Hand New
The available stock that is in new condition and can legally be sold as new. For some customers this may include On Hand Fixed quantities.
On Hand New Original
The value from the host system. This is the rolled-up value for On Hand New.
On Order
The quantity expected at the location of a given part from a supplier.
Order Policy
A set of rules that govern how orders are recommended. The Order Policy is assigned to an Ordering Parameter, which is assigned to a part or SKU. These are the available order policy types.
• Time-Phased ROP (Introduced in the 12.2.1.0 release)
* 
Refer to the Order Policy glossary entry for more information.
Part Cost
The unit cost of the part.
Part Custom (3-20)
A custom field that a user can define for a part via the Parts page.
Part Name
The given name for the part.
* 
Fields Part Name 2 – Part Name 5 are additional name fields in support of multiple languages.
Part Number
The unique identifier of the part.
Pending ASL Source
An indicator of how the part was added or removed if the part is pending to be added to or removed from the ASL.
Pipeline Forecast
The forecasted demand during the lead time.
Pooling Location Name
The pooling location.
Procurement Order
The inbound procurement order quantities (Recommended + Approved) for the specified date range.
ROP
The specific inventory position level at which a Procurement or Replenishment order is triggered for the SKU.
• A ROP of -1 indicates that the SKU is not stocked.
• The ROP is aggregated for a single period on the Part Summary, Location Summary, and Scenario Summary pages.
• The ROP is calculated as a forecast weighted average over multiple time periods on the Part Budget Summary and Scenario Budget Summary pages.
• The ROP is for the Scenario on the Time Series container of the Stocking Policy page
Repair EOQ
The Economic Order Quantity (EOQ) for repairable parts.
Repair Max
The largest allowable repair stock.
* 
The Stock Maximum cannot exceed the Repair Stock Maximum.
The Repair Stock Maximum value is calculated depending on the condition:
Condition
Repair Stock Maximum Calculation
Repair, no procurement
Safety Stock + Repair Pipeline Forecast + Repair EOQ
Procurement and repair
Safety Stock + Repair Pipeline Forecast + Repair EOQ
Repair Order
The inbound and outbound repair order quantities (Recommended + Approved) for the specified date range.
Repair ROP
The point at which a repair order is triggered for the repairable part associated with the scenario. It is the amount of stock consumed between today and after an order placed today could arrive.
* 
The calculation of this field depends on the repair type global setting. Contact your PTC Account Representative for more information about adjusting this setting.
Replenishment Received
The inbound replenishment order quantities (Recommended + Approved) for the specified date range.
Replenishment Sent
The outbound replenishment order quantities (Recommended + Approved) for the specified date range.
Safety Stock
The stock held in excess of the requirements to buffer for uncertainty during lead time. Calculated as Round ( (ROP - Pipeline Forecast) / Customer Order Size)) * Customer Order Size
* 
If the Customer Order Size is fractional the result is rounded again
Safety Stock Override
The override value for the Safety Stock.
* 
Only integer values are accepted.
Shortage Date
The date when a critical shortage condition begins. Critical shortages occur when a part is understocked at a location. This means that the part stock level is below the Safety Stock multiplied by the Critical Shortage Threshold.
Shortage End Date
The date when the part stock level is expected to be above Safety Stock.
SKU Custom (1-15)
A custom field that a user can define for an SKU via the SKU page.
Stock Level Custom (1-5)
Custom levels that a user defines for a part/location on the Optimal Levels page.
Stock Maximum
The maximum inventory level that can be stocked for a SKU at any time. Calculated as ROP + Effective Order Quantity.
• A Stock Maximum of 0 indicates that the SKU is not stocked.
• The Stock Maximum is aggregated for a single period on the Part Summary, Location Summary, and Scenario Summary pages.
• The Stock Maximum is calculated as a forecast weighted average over multiple time periods on the Part Budget Summary and Scenario Budget Summary pages.
• The Stock Maximum is for the Scenario on the Time Series container of the Stocking Policy page
Time Phased Day 1 Replenishment Deficit
The sum of Day 1 replenishment deficit (Amount Requested - Recommended Quantity) from the time phased child locations.
Trigger Point Replenishment Deficit
The sum of the replenishment deficit (Amount Requested - Recommended Quantity) from the trigger point child locations.
Was this helpful?