AM
InventoryItemMRP
Projection of InventoryItem for MRP only data required during the MRPEngine process.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMLowLevel | int | Low Level | - | |
Description:Non UI field - keeps items lowest bom level value used in calculations | ||||
BaseUnit | nvarchar(6) | Base Unit | - | |
Description:The Unit of Measure used as the base unit for the Inventory Item. Defaults to the Base Unit associated with the Item Class. Corresponds to the INUnit.FromUnit field. | ||||
DefaultSubItemID | int | Default Subitem | - | |
Description:The default Subitem for this item, which is used when there are no subitems or when specifying subitems is not important. This field is relevant only if the Inventory Subitems feature is enabled. Corresponds to the INSubItem.SubItemID field. | ||||
InventoryID | int | Inventory ID | - | |
Description:Database identity. The unique identifier of the Inventory Item. | ||||
ItemClassID | int | Item Class | - | |
Description:The identifier of the Item Class, to which the Inventory Item belongs. Item Classes provide default settings for items, which belong to them, and are used to group items. Corresponds to the INItemClass.ItemClassID field. | ||||
ItemStatus | char(2) | Item Status | - | |
Description:The status of the Inventory Item. Possible values are: ""AC"" - Active (can be used in inventory operations, such as issues and receipts), ""NS"" - No Sales (cannot be sold), ""NP"" - No Purchases (cannot be purchased), ""NR"" - No Request (cannot be used on requisition requests), ""IN"" - Inactive, ""DE"" - Marked for Deletion. Defaults to Active (""AC""). | ||||
PlanningMethod | char(1) | Planning Method | - | |
Description:Planning method - Decide which planning method applicable for the stock item. | ||||
StkItem | bit | Stock Item | - | |
Description:When set to "true", indicates that this item is a Stock Item. | ||||