IN
InventoryItemCommon
The DAC provides only common properties of the InventoryItem DAC
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
Descr | nvarchar | Description | - | |
Description:The description of the Inventory Item. | ||||
InventoryCD | nvarchar | Inventory ID | - | |
Description:Key field. The user-friendly unique identifier of the Inventory Item. The structure of the identifier is determined by the INVENTORY Segmented Key. | ||||
InventoryID | int | Inventory ID | - | |
Description:Database identity. The unique identifier of the Inventory Item. | ||||
IsTemplate | bit | - | ||
Description:When set to "true", indicates that the item is a template for other matrix items. Defaults to "false". | ||||
ItemClassID | int | - | ||
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) | - | ||
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""). | ||||
LotSerClassID | nvarchar(10) | - | ||
Description:The lot/serial class, to which the item is assigned. This field is relevant only if the Lot/Serial Tracking feature is enabled. Corresponds to the INLotSerClass.LotSerClassID field. | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:Indicates whether the record is selected for mass processing. | ||||
StkItem | bit | - | ||
Description:When set to "true", indicates that this item is a Stock Item. | ||||