Updated: 2009-06-19
Version: Control 4.4
Table Purpose, Usage, and Notes
This table stores the header record and default values for Selection Lists.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 1601 - Selection List
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
SelectionList.AutoSort | bit | ||||||
SelectionList.AutoSortType | int | ||||||
SelectionList.BlankCostFormula | text | ||||||
SelectionList.BlankCostFormulaType | int | ||||||
SelectionList.BlankDependentLinksXML | text | ||||||
SelectionList.BlankFilters | text | ||||||
SelectionList.BlankImageLinks | text | ||||||
SelectionList.BlankItemColor | int | ||||||
SelectionList.BlankListCost | float | ||||||
SelectionList.BlankListValue | float | ||||||
SelectionList.BlankPart2ClassTypeID | int | ||||||
SelectionList.BlankPart2ConsumptionFx | text | ||||||
SelectionList.BlankPart2Description | text | ||||||
SelectionList.BlankPart2ID | int | ||||||
SelectionList.BlankPart2StoreID | int | Not Used. | |||||
SelectionList.BlankPartClassTypeID | int | ||||||
SelectionList.BlankPartConsumptionFx | text | ||||||
SelectionList.BlankPartDescription | text | ||||||
SelectionList.BlankPartID | int | ||||||
SelectionList.BlankPartLinksXML | text | ||||||
SelectionList.BlankPartStoreID | int | Not Used. | |||||
SelectionList.BlankPriceFormula | text | ||||||
SelectionList.BlankPriceFormulaType | int | ||||||
SelectionList.BlankProperties | text | ||||||
SelectionList.BlankSecondaryListBlank | nvarchar(40) | ||||||
SelectionList.BlankSecondaryListClassTypeID | int | ||||||
SelectionList.BlankSecondaryListID | int | ||||||
SelectionList.BlankSecondaryListStoreID | int | Not Used. | |||||
SelectionList.BlankUseDefaultPart | bit | ||||||
SelectionList.BlankUseDefaultPart2 | bit | ||||||
SelectionList.CategoryID | int | ||||||
SelectionList.ClassTypeID | int | Identifier for the Type of Object | |||||
SelectionList.DefaultCostFormula | text | ||||||
SelectionList.DefaultCostFormulaType | int | ||||||
SelectionList.DefaultDependentLinksXML | text | ||||||
SelectionList.DefaultFilters | text | ||||||
SelectionList.DefaultImageLinks | text | ||||||
SelectionList.DefaultItemColor | int | ||||||
SelectionList.DefaultListCost | float | ||||||
SelectionList.DefaultListValue | decimal(18, 4) | ||||||
SelectionList.DefaultPart2ClassTypeID | int | ||||||
SelectionList.DefaultPart2ConsumptionFx | text | ||||||
SelectionList.DefaultPart2Description | text | ||||||
SelectionList.DefaultPart2ID | int | ||||||
SelectionList.DefaultPart2StoreID | int | Not Used. | |||||
SelectionList.DefaultPartClassTypeID | int | ||||||
SelectionList.DefaultPartConsumptionFx | text | ||||||
SelectionList.DefaultPartDescription | text | ||||||
SelectionList.DefaultPartID | int | ||||||
SelectionList.DefaultPartLinksXML | text | ||||||
SelectionList.DefaultPartStoreID | int | Not Used. | |||||
SelectionList.DefaultPriceFormula | text | ||||||
SelectionList.DefaultPriceFormulaType | int | ||||||
SelectionList.DefaultProperties | text | ||||||
SelectionList.DefaultSecondaryListClassTypeID | int | ||||||
SelectionList.DefaultSecondaryListDefault | nvarchar(40) | ||||||
SelectionList.DefaultSecondaryListID | int | ||||||
SelectionList.DefaultSecondaryListStoreID | int | Not Used. | |||||
SelectionList.Format | int | ||||||
SelectionList.ID | int | Primary Key for the Table | |||||
SelectionList.IncludeNewListItem | bit | ||||||
SelectionList.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
SelectionList.IsSystem | bit | Used to Mark Required Records | |||||
SelectionList.ListName | nvarchar(25) | ||||||
SelectionList.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
SelectionList.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
SelectionList.ModifiedDate | datetime | DateTime this Record was last modified | |||||
SelectionList.SeqID | int | ||||||
SelectionList.StoreID | int | Not Used. |
Related Tables
You could leave a comment if you were logged in.