Status

Indicates whether the best fit recommendation is approved or not.

Allocated

Allocated Original

Client-driven value usually meaning that a part is on hand but already committed to another requirement.

Allocated Original is the value from the host system, and Allocated is the rolled up value.

Amount Custom (1-10)

Custom fields for amounts derived from the IPCS_STOCK_AMOUNT table.

Annual Demand

Actual forecasted demand for the next year including any scheduled or non-recurring adjustments used in calculating the Economic Order Quantity.

Annual Value

Annual Demand * Part Cost

Approved

Indicates whether or not the recommended forecast is approve.

Backorder

Backorder Original

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).

Calculated Repair Max

Internal field storing the Repair Stock Maximum quantity as calculated by the system. This can be different from Repair Max if the Repair Max Override value is entered.

Calculated Repair ROP

Internal field storing the Repair ROP as calculated by the system. This can be different than ROP if the ROP Override value is entered.

Calculated ROP

Internal field storing the ROP as calculated by Servigistics. This can be different than ROP if the ROP Override value is entered.

Calculated Safety Stock

Internal field storing the Safety Stock quantity as calculated by the system. This can be different from Safety Stock if a Safety Stock Override value is entered.

Calculated Stock Max

Internal field storing the Stock Maximum quantity as calculated by Servigistics. This can be different from Stock Max if the Stock Max Override value is entered.

Carry Cost Override

The override amount if the Carrying Cost recommendation has been overridden somewhere in Servigistics.

Composite Error

Composite error.

Current Forecast Method/ID

Method used to generate current forecasted data.

Current MAD

MAD using current forecasted data.

Current MAPE

MAPE using current forecasted data.

Current RMSE

RMSE using current forecasted data.

Cushion Time

The difference in days between the Need By Date and the Expected Date. A negative Cushion Time means you will need stock before you are scheduled to receive it.

Cushion Time = Need By Date - Expected Date

Custom Level (1-5)

Custom fields for levels derived from the IPCS_STOCK_LEVEL table.

Days On Hand

This is calculated based on the GENERATE_OP_SL_OUTSTOCK_DAYS global setting.

Demand Satisfaction Override

The override amount if the Demand Satisfaction recommendation has been overridden somewhere in Servigistics.

Effective Composite Error

Current Composite Error.

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:

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.

Expected Date

The date an order is expected to be received if the procurement order is placed today.

Expected Date = Today's Date + Pipeline Length

Forecast Method/ID

Forecast method identified as best fit candidate.

Forecast Stream

Stream used for Best Fit Analysis (Install, Promotional, Exceptional, or Normal).

Forecast Stream ID

System-generated ID assigned to the forecast stream used for Best Fit Analysis.

Good 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).

In Repair

In Repair Original

Client-driven value - usually means the number of parts actually in process - also known as Repair WIP (Work in Process).

In Repair Original is the value from the host system, and In Repair is the rolled up value.

In Repair Bad

In Repair Bad Original

Client-driven value - usually means material in repair and not yet repaired.

In Repair Bad Original is the value from the host system, and In Repair Bad is the rolled up value.

In Repair Good

In Repair Good Original

Client-driven value - usually means material still in repair but already repaired.

In Repair Good Original is the value from the host system, and In Repair Good is the rolled up value.

In Return

In Return Original

Client-driven value - usually means bad material returned for exchange or repair under an RMA (Return Material Authorization). In some cases this is the sum of In Return Bad and In Return Good.

In Return Original is the value from the host system, and In Return is the rolled up value.

In Return Bad

In Return Bad Original

Client-driven value - usually means bad material returned for exchange or repair under an RMA (Return Material Authorization).

In Return Bad Original is the value from the host system, and In Return Bad is the rolled up value.

In Return Good

In Return Good Original

Client-driven value - usually means good material returned for exchange under an RMA (Return Material Authorization).

In Return Good Original is the value from the host system, and In Return Good is the rolled up value.

Is ASL Item

Yes indicates that the part is on the Authorized Stock List; No indicates that the part is NOT on the Authorized Stock List.

Last Order Date

The date of the last order for the selected part at the location.

Last Order Quantity

The quantity of the last order for the selected part at the location.

Location

The name of the location.

Location Active

Yes indicates that the location is active and is to be included in planning.

Location Critical

Yes indicates that the location is critical. Used for segmentation.

Location Custom (1-10)

Custom fields for locations derived from the IPCS_LOC_MASTER table.

Location Description (1-5)

The description of the location for the order recommendation. Note that more than one field is provided to use for different languages.

Location ID

System-driven integer identification number for the location related to the order recommendation.

Location Type

The type of location (for example, Sales Market) for the order recommendation.

Lot Size

The smallest available order quantity multiple for a given part.

MAD

Current Mean Absolute Deviation, which is a statistical measure of fit (only calculated with new period).

MAPE

Current MAPE, only calculated with new period.

Measure of Effectiveness Used

The measure of effectiveness used to calculate the optimal levels for the SKU.

Minimum Order Quantity

The least quantity of this part that may be ordered at a time.

Need By Date

The expected backorder count at the stocking location.

Networks

A set of related locations, defined on the Networks page. Networks allow balancing of excess quantities of On Hand stock to be limited to the selected Locations that are within the Network. Locations outside of the Network are not balanced.

On Hand Bad

On Hand Bad Original

The number of bad parts in stock at this location that are awaiting a repair order. Separate stock from In Repair, for which a repair order is in progress.

On Hand Bad Original is the value from the host system, and On Hand Bad is the rolled up value.

On Hand Fixed

On Hand Fixed Original

Client-driven value - usually means available stock that has previously been repaired (for the purposes of identifying stock that cannot legally be resold as new).

On Hand Fixed Original is the value from the host system, and On Hand Fixed is the rolled up value.

On Hand Good

The sum of On Hand New and On Hand Fixed.

On Hand New

On Hand New Original

Available stock that can be legally sold as new. For some customers, this may include On Hand Fixed quantities.

On Hand New Original is the value from the host system, and On Hand New is the rolled up value.

On Order

On Order Original

Client-driven value - usually means the quantity expected at the location of a given part from a supplier.

On Order Original is the value from the host system, and On Order is the rolled up value.

Order Cost

Reference Order Cost

Reference Order Cost Currency

Order Cost is the cost to order the part in your local currency.

Reference Order Cost/Currency is the Order Cost in the reference value/currency.

Click here for more information about local and reference currency.

Order Cost Override

Reference Order Cost Override

Reference Order Cost Override Currency/ID

Order Cost Override is the override amount in your local currency if the Order Cost recommendation has been overridden somewhere in Servigistics.

Reference Order Cost Override/Currency is the Order Cost Override in the reference value/currency.

Click here for more information about local and reference currency.

Out of Stock Date

The date when On Hand Good will be zero at the current demand rate.

Out Of Stock Date = Today + (30 * (On Hand Good) / Forecast)

Part Active

Yes indicates that the part is active and is to be included in planning.

Part Cost

Reference Cost

Reference Cost Currency

Part Cost is the amount paid to acquire the part in your local currency.

Reference Cost/Currency is the Part Cost in the reference value/currency.

Click here for more information about local and reference currency.

Part Critical

Yes indicates that the part is critical. Used for segmentation.

Part Custom (1-20)

Custom fields for parts derived from the IPCS_PART_MASTER table.

Part Description

The description of the part.

Part Family

The family to which a part belongs (such as hard drive, monitor, etc.). Used for segmentation.

Part ID

The ID of the part for the order recommendation.

Part Name (1-5)

The name of the part for the order recommendation. Note that more than one field is provided to use for different languages.

Part Number

The number of the part for the order recommendation.

Part Repairable

Yes indicates that the part is repairable.

Part Serializable

Yes indicates that the part can have a serial number.

Part Type

The type of part. Used for segmentation.

Planner Code

The Planner Code assigned to the part.

Planner Name

The user name of the planner assigned to the part.

Procurement Length

The length of the Procurement pipeline - the number of days it takes to get new parts to field locations from central locations.

Procurement Length Override

The override amount the Procurement Length recommendation has been overridden somewhere in Servigistics.

Procurement Requested Amount

Procurement Requested Original

The quantity of a part requested for procurement.

Procurement Requested Original is the value from the host system, and Procurement Requested Amount is the rolled up value.

Procurement SD Override

The override amount the Procurement Standard Deviation recommendation has been overridden somewhere in Servigistics.

Re-Order Point

The specific inventory position level at which a Procurement or Replenishment order is triggered for the SKU.

Region

The geographic area to which a location is assigned. Regions are defined on the Regions page and can be used for aggregation and other configurations such as segmentation.

Repair Cost

Reference Repair Cost

Reference Repair Cost Currency

Repair Cost is the cost to repair a part in your local currency. (Used in calculating Repair EOQ.)

Reference Repair Cost/Currency is the Repair Cost in the reference value/currency.

Click here for more information about local and reference currency.

Repair EOQ

The Repair Economic Order Quantity for repairable parts.

Repair Length Override

The override amount if the Repair Length recommendation has been overridden somewhere in Servigistics.

Repair Max

The largest allowable repair stock.

The Repair Stock Maximum value is calculated depending on the condition:

Repair Max Override

The override amount the Repair Maximum recommendation has been overridden somewhere in Servigistics.

Repair Order Cost

Reference Repair Order Cost

Reference Repair Order Cost Currency

The cost to process one repair order.

Reference Repair Order Cost/Currency is the Repair Order Cost in the reference value/currency.

Click here for more information about local and reference currency

Repair Order Cost Override

Reference Repair Order Cost Override

Reference Repair Order Cost Override Currency/ID

Repair Order Cost Override is the override amount in your local currency if the Repair Order Cost recommendation has been overridden somewhere in Servigistics.

Reference Repair Order Cost Override/Currency is the Repair Order Cost Override in the reference value/currency.

Click here for more information about local and reference currency.

Repair Requested Amount

Repair Requested Original

The quantity requested for repair.

Repair Requested Original is the value from the host system, and Repair Requested Amount is the rolled up value.

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.

Repair ROP Override

The override amount the Repair ROP recommendation has been overridden somewhere in Servigistics.

Repair SD Override

The override amount the Repair Standard Deviation recommendation has been overridden somewhere in Servigistics.

Repair Wash Rate

Repair recommendation quantities are factored by the Repair Wash Rate (which is a percentage). For example, if the Repair Wash Rate = 10% and 10 good units are required to meet demand, then 11 units of on hand bad will be required and assumed used on the assumption that one unit will wash out during the repair process.

Repair Wash Rate Override

The override amount if the Repair Wash Rate recommendation has been overridden somewhere in Servigistics.

Replenish Order Cost Override

Reference Replenishment Order Cost Override

Reference Replenishment Order Cost Override Currency/ID

Replenish Order Cost Override is the override amount in your local currency if the Replenishment Order Cost recommendation has been overridden somewhere in Servigistics.

Reference Replenishment Order Cost Override/Currency is the Replenish Order Cost Override in the reference value/currency.

Click here for more information about local and reference currency.

Replenishment Order Cost

Reference Replenishment Order Cost

Reference Replenishment Order Cost Currency

Replenishment Order Cost is the cost to replenish the part in your local currency.

Reference Replenishment Order Cost/Currency is the Replenishment O rder Cost in the reference value/currency.

Click here for more information about local and reference currency.

Replenishment Requested Amount

Replenish Requested Original

The quantity requested for replenishment.

Replenish Requested Original is the value from the host system, and Replenishment Requested Amount is the rolled up value.

Replenishment Length Override

The override amount if the Replenishment Length recommendation has been overridden somewhere in Servigistics.

Replenishment SD Override

The override amount if the Replenishment Standard Deviation recommendation has been overridden somewhere in Servigistics.

Return Length Override

The override amount if the Return Length recommendation has been overridden somewhere in Servigistics.

Return SD Override

The override amount if the Return Standard Deviation recommendation has been overridden somewhere in Servigistics.

Return Wash Rate

Return Wash Rate is a factor (percentage) used to forecast returns. Forecasted returns are normally used in time-phased planning to project on hand bad quantities. It is normally calculated as: Forecast * (1 - Return Wash Rate)

Return Wash Rate Override

The override amount if the Return Wash Rate recommendation has been overridden somewhere in Servigistics.

RMSE

Current Root Mean Square Error, which is a statistical measure of fit (only calculated with new period).

ROP Override

The override amount if the ROP recommendation has been overridden somewhere in Servigistics.

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

Safety Stock Override

The override amount if the Safety Stock recommendation has been overridden somewhere in Servigistics.

SKU Custom (1-15)

Custom fields for SKUs derived from the IPCS_SKU table.

Stock Maximum

The maximum inventory level that can be stocked for a SKU at any time. Calculated as ROP + Effective Order Quantity.

Stock Maximum Override

The override amount if the Stock Maximum recommendation has been overridden somewhere in Servigistics.