Updated: 2009-10-14
Version: Control 4.4
Table Purpose, Usage, and Notes
This table stores the links between products and modifiers.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 12070 - Product/Modifier Link
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||||||||||
| ProdModLink.AltDependentListName | varchar(40) | Specifies the name of the dependent list. UseAlternateList and UseAltList must be set true for this to be used. Used only in modifiers with the DefaultEntryOption of DropDown (2). | |||||||||||||
| ProdModLink.AltListParamClassTypeID | int | The ClassTypeID of the variable that the dependent list is pulled from. This should always be 14505. UseAlternateList and UseAltList must be set true for this to be used. Used only in modifiers with the DefaultEntryOption of DropDown (2). | |||||||||||||
| ProdModLink.AltListParamID | int | Specifies the ID of the variable that the dependent list is pulled from. UseAlternateList and UseAltList must be set true for this to be used. Used only in modifiers with the DefaultEntryOption of DropDown (2). | sql_structure_-_variable_table.ID | ||||||||||||
| ProdModLink.AltListParamStoreID | int | Not Used. | |||||||||||||
| ProdModLink.ClassTypeID | int | Identifier for the Type of Object | |||||||||||||
| ProdModLink.DefaultPart2ConsumptionFx | text | Not Used. | |||||||||||||
| ProdModLink.DefaultPartConsumptionFx | text | Not Used. | |||||||||||||
| ProdModLink.DefaultValue | text | The default value of the modifier. UseDefault must be set to Value (2) and UseFormula must be set to False for this to be used. | |||||||||||||
| ProdModLink.DisplayFormula | text | Not Used. | |||||||||||||
| ProdModLink.Formula | text | The formula used to compute the default value of the modifier. UseDefault must be set to Value (2) and UseFormula must be set to True for this to be used. | |||||||||||||
| ProdModLink.ID | int | Primary Key Field | |||||||||||||
| ProdModLink.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||||||||||
| ProdModLink.IsDisplayed | int | Not Used. | |||||||||||||
| ProdModLink.IsSystem | bit | Used to Mark Required Records | |||||||||||||
| ProdModLink.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||||||||||
| ProdModLink.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||||||||||
| ProdModLink.ModifiedDate | datetime | DateTime this Record was last modified | |||||||||||||
| ProdModLink.ModifierID | int | The ID of the Modifier. | sql_structure_-_customergoodsitem_table.ID | ||||||||||||
| ProdModLink.PartConsumptionFormulas | text | XML containing part consumption formulas. Used only in modifiers with the DefaultEntryOption of DropDown (2). | |||||||||||||
| ProdModLink.PartConsumptionUnitIDs | text | XML containing part consumption unit IDs. Used only in modifiers with the DefaultEntryOption of DropDown (2). | sql_structure_-_systemunit_table.ID | ||||||||||||
| ProdModLink.ProductClassTypeID | int | The ClassTypeID of the product. This should always be 12000. | |||||||||||||
| ProdModLink.ProductID | int | The ID of the Product. | sql_structure_-_customergoodsitem_table.ID | ||||||||||||
| ProdModLink.SelectionListID | int | Specifies the ID of the selection list. UseAlternateList must be set true for this to be used. Used only in modifiers with the DefaultEntryOption of DropDown (2). | | ProdModLink.SeqID | int | ||||||||||
| ProdModLink.ShowInGrid | bit | Specifies whether the modifier is shown in the modifier grid in order entry. | |||||||||||||
| ProdModLink.StationClassTypeID | int | Not Used. | |||||||||||||
| ProdModLink.StationID | int | Not Used. | |||||||||||||
| ProdModLink.StoreID | int | Not Used. | |||||||||||||
| ProdModLink.UseAlternateList | bit | Specifies whether to use the selection list from the modifier, or the one specified in this ProdModLink. | |||||||||||||
| ProdModLink.UseAltList | bit | Specifies whether the selection list is a dependent list. UseAlternateList must be set true for this to be used. Used only in modifiers with the DefaultEntryOption of DropDown (2). | |||||||||||||
| ProdModLink.UseDefault | int | Specifies whether to set a default value or not. 0 - No default value and a value is not required. 1 - No default value and a value is required. 2 - Has a default value. | |||||||||||||
| ProdModLink.UseFormula | bit | Specifies whether the default value is pulled from the DefaultValue field or the Formula field. If true, then use Formula, otherwise use DefaultValue. UseDefault must be set to Value (2) | |||||||||||||
Related Tables
sql_structure_-_variable_table
sql_structure_-_customergoodsitem_table
sql_structure_-_customergoodsitem_table
sql_structure_-_systemunit_table
You could leave a comment if you were logged in.