Columns Available in the Inventory Window

Items may be stored in multiple lots, in multiple locations, and in various grades and states for each. Depending on your system configuration, storage entities may store multiple items and/or multiple lots of one item. Each inventory record reflects the storage of some quantity of a unique combination of item, lot number, storage entity, item grade, and item state.

A brief description of the columns available for display in the Inventory window follows:

Date In

The most recent date/time that a quantity of this item/lot/grade/state was received by this entity.

Date Out

The most recent date/time that the last quantity of this item/lot/grade/state was removed from storage in this entity.

Entity

The description of the entity in which this inventory quantity is stored.

Entity ID

The database ID of the entity in which this inventory quantity is stored.

Entity Name

The name of the entity in which this inventory quantity is stored.

Expiry Date

The expiration date for this inventory quantity.

Item Class Descr

The description of the item class for this inventory quantity. Defined on the General tab of an item node in the Items window.

Item Class ID

The item class ID for this inventory quantity. Defined on the General tab of an item node in the Items window.

Item Description

The description of the item for this inventory quantity. Defined on the General tab of an item node in the Items window.

Item Grade

The database ID of the item grade assigned to this inventory quantity.

Item Grade Desc

The description of the item grade assigned to this inventory quantity.

Item ID

The ID of the item for this inventory quantity. Defined on the General tab of an item node in the Items window.

Item Status

The database ID of the item status assigned to this inventory quantity.

Item Status Description

The description of the item status assigned to this inventory quantity.

Item_Inv Spare 1-6

The optional, user-defined fields for this inventory quantity.

Location Status

The storage status of the entity used for this inventory quantity. Set automatically by MES or by users in the Physical Entities module in MES Client, the Storage Entity Status window of MES Supervisor, or the Storage tab of MES Operator.

• Used: The entity is currently being used for storage, of some quantity greater than 0 of an item.

• Available: The entity is available for storage; it is completely empty. Each entity’s definition in MES Client determines whether or not inventory records for 0 quantities are displayed in the Inventory window.

• Dirty: If an entity’s definition in MES Client allows for Dirty status, the entity’s status is automatically changed to Dirty when the last item is removed from it. A Dirty entity is empty but may not be used for storage; a user must change the status to Available on the Storage Entity Status window or on the Storage tab of MES Operator.

Lot

The lot number (a user-defined string) assigned to this inventory quantity.

Operation ID

The ID of the operation during which this inventory quantity was produced. Supplied by MES Operator.

Quantity Left

The quantity of this item/lot/grade/state combination currently stored at this entity.

Quantity Left ERP

The inventory quantity of this item/lot/grade/state combination that has been reported to ERP.

Sequence No

The position number of the job in which this inventory quantity was produced (value may be greater than 0 when multiple jobs are defined within a single operation).

Units

The unit of measured used by the product of this job. Defined on the General tab of an item node in the Items window.

Work Order ID

The ID of the work order for which this inventory quantity was produced. Supplied by MES Operator.

Attributes that have been associated with items and/or lots and defined in MES Client as available to the Inventory window will also appear as available column headings. When selected, the columns will appear for every inventory record, but values will appear only as defined elsewhere.