{$page} 



Updated: 2009-09-16



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores the fixed Part-Product and Part-Modifier links.  This does not store links from selection lists (there are stored in the [[sql_structure_-_selectionlist_tableselectionlist_table|SelectionList Table]]).



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 12071 - Product-Part Link
    * 12072 - Modifier-Part Link



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| GoodsItemPartLink.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| GoodsItemPartLink.ConsumptionFormula || text ||  ||   ||
|| GoodsItemPartLink.ConsumptionUnitID || int ||  ||   ||
|| GoodsItemPartLink.Description || text ||  ||   ||
|| GoodsItemPartLink.GoodsItemClassTypeID || int ||  ||   ||
|| GoodsItemPartLink.GoodsItemID || int || ID of Product or Modifier || CustomerGoodsItem.ID ||
|| GoodsItemPartLink.ID || int || Primary Key Field ||  ||
|| GoodsItemPartLink.IncludeAlways || bit ||  ||   ||
|| GoodsItemPartLink.InclusionFormula || text ||  ||   ||
|| GoodsItemPartLink.IsActive || bit || Not Used for This Table ||   ||
|| GoodsItemPartLink.IsSystem || bit || Used to Mark Required Records ||   ||
|| GoodsItemPartLink.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| GoodsItemPartLink.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| GoodsItemPartLink.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| GoodsItemPartLink.Notes || text ||  ||   ||
|| GoodsItemPartLink.PartID || int || ID of Part || Part.ID ||
|| GoodsItemPartLink.SeqID || int ||  ||   ||
|| GoodsItemPartLink.StationClassTypeID || int ||  ||   ||
|| GoodsItemPartLink.StationID || int ||  ||   ||
|| GoodsItemPartLink.StationOverridden || bit ||  ||   ||
|| GoodsItemPartLink.StoreID || int || Not Used. ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]