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_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
You could leave a comment if you were logged in.