{$page} 



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_tablecustomergoodsitem|CustomerGoodsItem]].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_tablecustomergoodsitem|CustomerGoodsItem]].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_tablecustomergoodsitem|CustomerGoodsItem]].ID



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]