Updated: 2010-04-30



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores the Part record for all part types.



Information on Table Data 
  * ClassTypeIDs Stores in Table: 
    * 12014 - Part



PartTypeID Enumerated Values
    * 0  Materials
    * 1  Labor
    * 2  Equipment
    * 3  Outsource
    * 4  Other
    * 5  Freight
    * 6  Location



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| Part.AccrueCosts || bit || 1  Accrue Costs for Financial, 0  Not. This field indicates whether real (1) or computed (0) costs are used. ||   ||
|| Part.AssetAccountClassTypeID || int ||   ||   ||
|| Part.AssetAccountID || int || ID of Accrual Asset Account if Accruing Costs || GLAccount.ID ||
|| Part.AssetAccountIDOV || bit ||   ||   ||
|| Part.BarCode || nvarchar(50) ||   ||   ||
|| Part.CategoryClassTypeID || int || ClassTypeID of Part Category. Always 12035. || PricingElement.ClassTypeID ||
|| Part.CategoryID || int || ID of Part Category || PricingElement.ID where ClassTypeID  12035 ||
|| Part.CategoryStoreID || int || Not Used. ||   ||
|| Part.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| Part.ComputedCostAccountClassTypeID || int ||   ||   ||
|| Part.ComputedCostAccountID || int ||   ||   ||
|| Part.CostMultiplier || text ||   ||   ||
|| Part.CostMultiplierType || int || 0  Use Default  Multiplier \\ 1  Use This Multiplier \\ 3  Use This Price ||   ||
|| Part.Description || text ||   ||   ||
|| Part.ExpenseAccountClassTypeID || int ||   ||   ||
|| Part.ExpenseAccountID || int || ID of Real or Computed Expense Account || GLAccount.ID ||
|| Part.ExpenseAccountIDOV || bit ||   ||   ||
|| Part.FixedCostMultiplier || text ||   ||   ||
|| Part.GLDepartmentClassTypeID || int ||   ||   ||
|| Part.GLDepartmentID || int ||   ||   ||
|| Part.GLDepartmentIDOV || bit ||   ||   ||
|| Part.Help || text ||   ||   ||
|| Part.ID || int || Primary Key Field ||   ||
|| Part.InstancesAllowed || int ||   ||   ||
|| Part.InstancesAllowedType || int ||   ||   ||
|| Part.internalNotes || text ||   ||   ||
|| Part.InventoryID || int || ID of Inventory Record || Inventory.ID ||
|| Part.InventoryUnitType || int ||   ||   ||
|| Part.IsActive || bit || Indicates if Enabled. 1Record is Active, 0Record is Not Active ||   ||
|| Part.IsSystem || bit || Used to Mark Required Records ||   ||
|| Part.ItemName || nvarchar(50) || Name of the Part ||   ||
|| Part.LastModifiedDate || datetime ||   ||   ||
|| Part.LocalTags || text ||   ||   ||
|| Part.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| Part.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| Part.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| Part.NotificationAddresses || text ||   ||   ||
|| Part.NotifyOtherContacts || bit ||   ||   ||
|| Part.PartType || int || Enumerated Type of this Part \\ 0  Materials \\ 1  Labor \\ 2  Equipment \\ 3  Outsource \\ 4  Other \\ 5  Freight \\ 6  Location ||   ||
|| Part.QuantityAvailable || float ||   ||   ||
|| Part.QuantityExpected || float ||   ||   ||
|| Part.QuantityOnHand || float ||   ||   ||
|| Part.QuantityOnOrder || float ||   ||   ||
|| Part.QuantityReserved || float ||   ||   ||
|| Part.RedNotificationPoint || float ||   ||   ||
|| Part.ReOrderPoint || float ||   ||   ||
|| Part.ReOrderQuantity || float ||   ||   ||
|| Part.RoundingFactor || float ||   ||   ||
|| Part.RoundingOption || int ||   ||   ||
|| Part.ScrapFactor || float ||   ||   ||
|| Part.SeqID || int ||   ||   ||
|| Part.ShowOnProductionSchedule || bit ||   ||   ||
|| Part.SKU || nvarchar(50) ||   ||   ||
|| Part.StationClassTypeID || int ||   ||   ||
|| Part.StationID || int || ID of the default Station for this Part || Station.ID ||
|| Part.StoreID || int || Not Used. ||   ||
|| Part.TrackCosts || bit || 1  Track Costs, 0  Not ||   ||
|| Part.TrackInventory || bit || 1  Track Inventory, 0  Not ||   ||
|| Part.UDFLayoutSettings || text ||   ||   ||
|| Part.UnitCost || float || The unit cost used in pricing calculations. For inventoried items, this always equals Inventory.AverageCost ||   ||
|| Part.UnitCostFormula || text ||   ||   ||
|| Part.UnitID || int ||   ||   ||
|| Part.UseCategoryDefaults || bit ||   ||   ||
|| Part.UseFixedCost || bit ||   ||   ||
|| Part.Vendor || varchar(40) ||   ||   ||
|| Part.VendorPartNumber || varchar(40) ||   ||   ||
|| Part.YellowNotificationPoint || float ||   ||   ||
|| Part.UDFXML || text || UDF values stored in an XML format. Only UDFs with values are included in the XML. \\ **Note: This field is available in Control versions 04.40.1004.3001 and later.** ||   ||
Related Tables