IN
INRelatedInventory
Represents Related Items for stock- and non-stock- items. The records of this type are created and edited through the Realetd Items tab in the Stock Items (IN202500) form (which corresponds to the InventoryItemMaint graph) and the Non-Stock Items (IN202000) form (which corresponds to the NonStockItemMaint graph) screens. The cache of this type in the graphs is active if one or both of the following features are enabled: FeaturesSet.relatedItems and FeaturesSet.commerceIntegration.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AcceptedMLSuggestion | bit | Accepted ML Suggestion | - | |
Description:No description available | ||||
BaseQty | decimal | - | ||
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByPossibleRelatedItem | bit | - | ||
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
DescNonexistent in DB | string | Description | - | |
Description:No description available | ||||
EffectiveDate | datetime | Effective Date | - | |
Description:No description available | ||||
ExpirationDate | datetime | Expiration Date | - | |
Description:No description available | ||||
Interchangeable | bit | Customer Approval Not Needed | - | |
Description:No description available | ||||
InventoryID | int | InventoryItem | ||
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineID | int | - | ||
Description:No description available | ||||
MLScore | decimal | - | ||
Description:No description available | ||||
MLScorePercentNonexistent in DB | decimal? | Relevance Score (%) | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
Qty | decimal | Quantity | - | |
Description:No description available | ||||
Rank | int | Rank | - | |
Description:No description available | ||||
RelatedInventoryID | int | Inventory ID | InventoryItem | |
Description:No description available | ||||
Relation | char(5) | Relation | - | |
Description:No description available | ||||
Required | bit | Required | - | |
Description:No description available | ||||
Tag | char(4) | Tag | - | |
Description:No description available | ||||
UOM | nvarchar(6) | UOM | INUnit | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||