Updated: 2009-09-16
Version: Control 4.4
Table Purpose, Usage, and Notes
This table contains the rows of the selection list.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 1602 - Selection List Item
Much of the data about options selection list columns is stored in XML format. Originally these were hard-coded with 1 or 2 dedicated fields (like PartID and Part2ID), but in order to support more dynamic capabilities these fields were replaced with an XML encoded value (like Part…XML). The old fields are still present, but not used except for old data that has not been upgraded.
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| SelectionListItem.ClassTypeID | int | Identifier for the Type of Object | |||||
| SelectionListItem.CostFormula | text | ||||||
| SelectionListItem.CostFormulaType | int | ||||||
| SelectionListItem.CostValue | float | ||||||
| SelectionListItem.DependentLinksXML | text | ||||||
| SelectionListItem.DynamicLinkClassTypeID | int | ||||||
| SelectionListItem.DynamicLinkID | int | ID of Part Category for Dynamic Selection Lists | |||||
| SelectionListItem.ID | int | Primary Key Field | |||||
| SelectionListItem.IsActive | bit | Not Used for This Table | |||||
| SelectionListItem.IsSystem | bit | Used to Mark Required Records | |||||
| SelectionListItem.ItemColor | int | ||||||
| SelectionListItem.ItemFilters | text | ||||||
| SelectionListItem.ItemImageLinks | text | ||||||
| SelectionListItem.ItemProperties | text | ||||||
| SelectionListItem.ItemText | nvarchar(70) | Item Name | |||||
| SelectionListItem.ListValue | decimal(18, 4) | ||||||
| SelectionListItem.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| SelectionListItem.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| SelectionListItem.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| SelectionListItem.Part2ClassTypeID | int | ||||||
| SelectionListItem.Part2ConsumptionFx | text | ||||||
| SelectionListItem.Part2Description | text | ||||||
| SelectionListItem.Part2ID | int | Used? | |||||
| SelectionListItem.Part2StoreID | int | Not Used. | |||||
| SelectionListItem.PartClassTypeID | int | ||||||
| SelectionListItem.PartConsumptionFx | text | ||||||
| SelectionListItem.PartDescription | text | ||||||
| SelectionListItem.PartID | int | Used? | |||||
| SelectionListItem.PartLinksXML | text | ||||||
| SelectionListItem.PartStoreID | int | Not Used. | |||||
| SelectionListItem.PriceFormula | text | ||||||
| SelectionListItem.PriceFormulaType | int | ||||||
| SelectionListItem.SecondaryListClassTypeID | int | ||||||
| SelectionListItem.SecondaryListDefault | nvarchar(40) | ||||||
| SelectionListItem.SecondaryListID | int | Used? | |||||
| SelectionListItem.SecondaryListStoreID | int | Not Used. | |||||
| SelectionListItem.SelectionListID | int | ID of Selection List Contained in | SelectionList.ID | ||||
| SelectionListItem.SeqID | int | ||||||
| SelectionListItem.SortIndex | int | ||||||
| SelectionListItem.StoreID | int | Not Used. | |||||
| SelectionListItem.UseDefaultPart | bit | ||||||
| SelectionListItem.UseDefaultPart2 | bit |
Related Tables
You could leave a comment if you were logged in.