Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is …
Information on Table Data
- ClassTypeIDs Stores in Table:
- 10300 - Transaction Part
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| TransPart.ActualCost | float | ||||||
| TransPart.ActualCostOverridden | bit | ||||||
| TransPart.ActualOverridden | bit | ||||||
| TransPart.ActualPrice | float | ||||||
| TransPart.ActualPriceOverridden | bit | ||||||
| TransPart.ActualValue | float | ||||||
| TransPart.CalculatedCost | float | ||||||
| TransPart.CalculatedValue | float | ||||||
| TransPart.ClassTypeID | int | Identifier for the Type of Object | |||||
| TransPart.CostMultiplier | text | ||||||
| TransPart.CostMultiplierType | int | ||||||
| TransPart.EstimatedCost | float | ||||||
| TransPart.EstimatedCostOverridden | bit | ||||||
| TransPart.EstimatedOverridden | bit | ||||||
| TransPart.EstimatedPrice | float | ||||||
| TransPart.EstimatedValue | float | ||||||
| TransPart.FixedCostMultiplier | text | ||||||
| TransPart.GoodsItemClassTypeID | int | ||||||
| TransPart.GoodsItemCode | nvarchar(35) | Part Name (text) for this TransPart | |||||
| TransPart.GoodsItemID | int | ID of Part for this TransPart | |||||
| TransPart.ID | int | Primary Key for the Table | |||||
| TransPart.Include | bit | ||||||
| TransPart.IncludeCalculated | bit | ||||||
| TransPart.IncludeOverridden | bit | ||||||
| TransPart.InternalNotes | ntext | ||||||
| TransPart.InventoryClassTypeID | int | ||||||
| TransPart.InventoryID | int | ||||||
| TransPart.IsActive | bit | Not Used for This Table | |||||
| TransPart.IsAttachedToVTrans | bit | ||||||
| TransPart.IsAutomatic | bit | ||||||
| TransPart.IsPart2 | bit | ||||||
| TransPart.IsSystem | bit | Used to Mark Required Records | |||||
| TransPart.LineItemNumber | nvarchar(15) | ||||||
| TransPart.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| TransPart.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| TransPart.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| TransPart.ParameterClassTypeID | int | ||||||
| TransPart.ParameterID | int | ||||||
| TransPart.ParameterStoreID | int | Not Used. | |||||
| TransPart.ParentClassTypeID | int | ||||||
| TransPart.ParentID | int | ID of Category/Group Above | |||||
| TransPart.PartClassTypeID | int | ||||||
| TransPart.PartCode | nvarchar(25) | ||||||
| TransPart.PartID | int | ||||||
| TransPart.PartIndex | float | ||||||
| TransPart.PartLinkClassTypeID | int | ||||||
| TransPart.PartLinkID | int | ||||||
| TransPart.ReferenceNumber | int | ||||||
| TransPart.SeqID | int | ||||||
| TransPart.SortOrder | int | ||||||
| TransPart.StationClassTypeID | int | ||||||
| TransPart.StationID | int | ||||||
| TransPart.StationOverridden | bit | ||||||
| TransPart.StoreID | int | Not Used. | |||||
| TransPart.SuggestedPrice | float | ||||||
| TransPart.TransDetailClassTypeID | int | ||||||
| TransPart.TransDetailID | int | ||||||
| TransPart.TransHeaderClassTypeID | int | ||||||
| TransPart.TransHeaderID | int | ||||||
| TransPart.TransModClassTypeID | int | ||||||
| TransPart.TransModID | int | ||||||
| TransPart.UnitID | int | ||||||
| TransPart.UnitText | nvarchar(25) | ||||||
| TransPart.VariableClassTypeID | int | ||||||
| TransPart.VariableID | int | ||||||
| TransPart.VariableStoreID | int | Not Used. | |||||
| TransPart.Vendor | varchar(40) | ||||||
| TransPart.VendorPartNumber | varchar(40) |
Related Tables
You could leave a comment if you were logged in.