Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to link assembly child items to an assembly container (product).
Information on Table Data
- ClassTypeIDs Stores in Table:
- 12077 - Assembly Link
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| AssemblyLink.ChildClassTypeID | int | ClassType ID of the Child Product | (12000) | ||||
| AssemblyLink.ChildID | int | ID of Child Product | sql_structure_-_customergoodsitem_table.ID | ||||
| AssemblyLink.ClassTypeID | int | Identifier for the Type of Object | |||||
| AssemblyLink.ID | int | Primary Key for the Table | |||||
| AssemblyLink.InclusionFormula | text | This formula will determine if/when the child product will be included | |||||
| AssemblyLink.InclusionType | int | 0 Always Include 1 Show on list but do not automatically include 2 Include based on the inclusion formula | |||||
| AssemblyLink.IsActive | bit | Not Used for This Table | |||||
| AssemblyLink.IsSystem | bit | Used to Mark Required Records | |||||
| AssemblyLink.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
| AssemblyLink.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
| AssemblyLink.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| AssemblyLink.ParentClassTypeID | int | Assembly Parent Object Type Identifier | 12000 | ||||
| AssemblyLink.ParentID | int | ID of Category/Group Above | sql_structure_-_customergoodsitem_table.ID | ||||
| AssemblyLink.SeqID | int | Record modification count | |||||
| AssemblyLink.SortIndex | float | Relative sort order location in Assembly List | |||||
| AssemblyLink.StoreID | int | Not Used. |
Related Tables
sql_structure_-_customergoodsitem_table.ID
You could leave a comment if you were logged in.