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.

Approved Balance

[only applicable for trigger-based planning]

The approved inventory position at the beginning of the day - essentially the input inventory.

Approved Repair Balance

[only applicable for trigger-based planning]

The approved repair inventory position at the beginning of the day - essentially the input repair inventory.

ASL Source

Indicates the method used to remove the part from the location's authorized stocking list. Valid options are:

AutoPilot Job Name

The name of the AutoPilot job that generated the procurement recommendation.

AutoPilot Run Date

The run date of the AutoPilot job that generated the procurement recommendation.

AutoPilot Segment Name

The name of the AutoPilot segment that triggered the procurement recommendation.

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 Max quantity as calculated by Servigistics. This can be different from Repair Max if a Repair Max Override value is entered.

Calculated Repair ROP

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

Calculated ROP

Internal field storing the ROP as calculated by Servigistics. This can be different than ROP if a 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 Max quantity as calculated by Servigistics. This can be different from Stock Max if a Stock Max Override value is entered.

Carry Cost Override

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

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.

EOQ

Excess Amount

The quantity of part stock above the Excess Threshold. This includes all on hand stock as well as on order, in repair, and in return stock.

Excess Amount applies only to trigger point-planned pairs; it has no relevance for time-phased planning.

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 Threshold

This value is set using AutoPilot Parameters and is posted to the Excess Action page to alert users of an excess level.

The percentage over the Stock Maximum to which inventory levels must rise before this SKU is considered an excess condition for review reasons and exceptions. For example, you may not wish to declare excess in a segment of cheaper parts, until inventory rises to an Excess Threshold of 150% of Stock Maximum. This setting only affects the creation of review reasons and exceptions, and does not change the definition of excess or excess limit

Excess Value

The value of part stock above the Excess Threshold.

Expected Date

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

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.

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.

Location Active

Yes indicates that the location is active and is to be included in planning; No indicates that then the location is not active.

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. Note that more than one field is provided to use for different languages.

Location ID

System-driven integer identification number for the location.

Location Name

The name of the location.

Location Type

The type of location.

Lot Size

The smallest available order quantity multiple for a given part.

Measure of Effectiveness Used

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

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. Calculated as 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 Excess

The amount of good stock on hand at a location that is above the currently defined Stock Max level for the SKU.

On Hand Excess Value

On Hand Excess is expressed in units; On Hand Excess Value is expressed in currency (Units * Part Cost).

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

Reference Order Cost

Reference Order Cost Currency

Order Cost is the cost to place a procurement order for the part.

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 if the Order Cost recommendation has been overridden 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

The type of ordering policy to use: trigger point or time phased.

Click here for more information about these ordering policies

Out Of Stock Date

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

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

Parent Location ID

System-driven integer identification number for the parent location.

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

System-driven internal integer identification number for the part.

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 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 if the Procurement Length recommendation has been overridden somewhere in Servigistics.

Procurement SD Override

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

Re-Order Point

Recommended Balance

[only applicable for trigger-based planning]

The recommended inventory position at the beginning of the day. This might be different from the Approved Balance in case of trigger walk since the recommended modifications to input orders will potentially change the inventory position to which Order Plan recommends an order.

Recommended Balancing In

[only applicable for trigger-based planning]

Recommended balance transfers coming in - ordered today at source.

Click the linked value to go to list of recommendations.

Recommended Balancing Out

[only applicable for trigger-based planning]

Recommended balance transfers going out today.

Click the linked value to go to list of recommendations.

Recommended Repair Balance

The recommended repair inventory position at the beginning of the day.

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.

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 Length

The average number of days required to repair or scrap this part and forward it back to the stocking location.

Repair Length Override

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

Repair Max

Repair Max Override

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

Repair Order Cost Override

Reference Repair Order Cost Override

Reference Repair Order Cost Override Currency/ID

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

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

Click here for more information about local and reference currency.

Repair ROP

Repair ROP.

Repair ROP Override

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

Repair SD Override

The override amount if 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 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 Length

The average number of days required to replenish this part to another location within the field service network.

Replenishment Length Override

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

Replenishment Requested Amount

A field stored in Stock Amount.

Replenishment SD Override

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

Return Length

The average number of days required to return this part to a repair center.

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.

ROP Override

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

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.

Stock Maximum

Stock Maximum Override

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

Unit of Measure

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

Weight Per Unit

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