ABC Code

The ABC classification code assigned to the SKU.

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

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.

Average Part Cost

The average cost of the part.

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

Carry Cost

The percentage of part value equaling the annual cost to hold that part in inventory, including the costs of depreciation, insurance, facilities, time value of money, etc.

Carry Cost Override

Carrying Cost entered by the user.

Critical

Yes indicates that the part is critical to the operation.

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.

Delay Until Date

When a SKU Reviewed or Part Reviewed action is performed on the Work Queue page or the Review Board container on the Interactive Planner Worksheet page, the record is hidden until this date. It is calculated as follows:

Demand Satisfaction Override

Demand Satisfaction entered by the user, which overrides the value entered by the system.

Description

The description of the part.

EOQ

Good Available In Future

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.

Issue Date

The date the Review Board record was issued.

Like Location

Used if the location is new and has no demand history. This similar location will be used to estimate demand for the location.

Like Part

Used if the part is new and has no demand history. This similar part will be used to estimate demand for the part.

Location Active

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

Location Custom (1-10)

Custom fields for locations derived from the IPCS_LOC_MASTER table.

Location Description (1-5)

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

Location Name

The name of the location.

Location Status

The status of the location.

Location Type

The type of location.

Magnitude

A numeric value that represents the urgency of the item being reviewed.

Need By Date

The expected out of stock date, considering both on-hand and on-order quantities. Assumes previous orders will arrive at their average lead time and that usage will be as forecasted.

Need By Date = Today + (30 * (On Order + In Repair + In Return - Backorder + On Hand Good - Allocated + Proc Req Amount + On Hand Bad) / Forecast)

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

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

The sum of the internal overhead costs involved in the acquisition of a part, including selecting vendors, generating purchase orders, paying the invoice, etc.

Order Cost Override

Reference Order Cost Override

Reference Order Cost Override Currency

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

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.

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 a part.

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 Name (1-5)

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

Part Number

The number of the part.

Part Serializable

Yes indicates that the part can have a serial number.

Part Type

The type of part. Used for segmentation.

Planner Code Name

The name of the planner who placed the order.

Planner Name

The name of the planner responsible for planning this part.

Priority

The priority order of the review type for the Review Board record, which is set in Review Subscriptions.

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

Repair Order Cost

The cost to process one repair order.

Repair Order Cost Override

Reference Repair Order Cost Override

Reference Repair Order Cost Override Currency

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

Repairable

Yes indicates that the part is repairable.

Replenish Order Cost Override

Reference Replenish Order Cost Override

Reference Replenishment Order Cost Override Currency

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

The sum of the internal overhead costs involved in the replenishment of a part.

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.

Review Comment

A note about the Review Board record.

Review Date

The date the Review Board record was generated.

Review Name

The name of the Review Board record, which corresponds to the Review Type number.

Review Note

The description of the Review Board record.

Review Type

A part/location exception defined on the Review Types page. The name of the review type describes the evaluation that is performed against each part/location record. If the evaluation is true, then that part/location appears on the Review Board.

Safety Stock

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.

Total Forecast Cost

The current slice's forecast multiplied by the part price. For example, if the forecast for the slice is 5.0 units and the price per unit is $10.00, the Total Forecast cost is $50.00.

Total Forecast Cost allows the items to be ranked by current forecast cost allowing you to see "big ticket" items first.

Unit of Measure

Indicates how Weight per Unit is measured (i.e., pounds, grams, liters, etc.).

Wash Rate Override

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

Weight Per Unit

The weight of one unit in the selected Unit of Measure (pounds, grams, liters, etc.).