IN
INSubItem
Represents a Subitem (or subitem code). Subitems allow to track different variations of a product under one InventoryItem. Subitems are available only if the Inventory Subitems feature is enabled. The records of this type are created and edited through the Subitems (IN205000) form (which corresponds to the INSubItemMaint graph).
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Descr | nvarchar(60) | - | ||
Description:The description of the Subitem. | ||||
GroupMask | varbinary | - | ||
Description:The group mask showing which restriction groups the Subitem belongs to. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
SubItemCD | nvarchar(30) | Subitem ID | - | |
Description:Key field. Unique user-friendly identifier of the Subitem. The structure of the identifier is defined by the INSUBITEM Segmented Key and usually reflects the important properties associated with the item. | ||||
SubItemID | int | Subitem ID | - | |
Description:Database identity. Unique identifier of the Subitem. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||