{$page} 



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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]