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