Updated: 2009-06-19



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is primarily used to store simple //pricing related// elements with a name, description, and Active indicator. This is most commonly used for groups or simple lists. Non-pricing related items are stored in the Element tables



Information on Table Data 
  * ClassTypeIDs Stores in Table: 
    * 1600 - Selection List Category
    * 12020 - Product Category
    * 12030 - Modifier Category
    * 12035 - Part Category
    * 12050 - Pricing Plan Type
    * 12075 - Part Instace
    * 12100 - Pricing Family
    * 12700 - Warehouse Name
    * 14045 - Pricing Table Category
    * 14500 - Variable Category
    * 15001 - Input Template Category
    * 15011 - Output Template Category
    * 30100 - Course Section Type



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| PricingElement.ClassTypeID || int || Indicates the Type of Object ||   ||
|| PricingElement.ComputedCostClassTypeID || int ||   ||   ||
|| PricingElement.ComputedCostID || int ||   ||   ||
|| PricingElement.DefaultAccrueCosts || bit ||   ||   ||
|| PricingElement.DefaultIncomeIDOV || bit ||   ||   ||
|| PricingElement.DefaultTrackCosts || bit ||   ||   ||
|| PricingElement.DefaultTrackInventory || bit ||   ||   ||
|| PricingElement.Description || nvarchar(50) || Description of the Element's Use ||   ||
|| PricingElement.ElementName || nvarchar(50) || Name of the Element ||   ||
|| PricingElement.EndDate || datetime ||   ||   ||
|| PricingElement.ExpenseClassTypeID || int ||   ||   ||
|| PricingElement.ExpenseID || int ||   ||   ||
|| PricingElement.ExpenseIDOV || bit ||   ||   ||
|| PricingElement.FamilyClassTypeID || int ||   ||   ||
|| PricingElement.FamilyID || int ||   ||   ||
|| PricingElement.FamilyStoreID || int || Not Used. ||   ||
|| PricingElement.GLDepartmentClassTypeID || int ||   ||   ||
|| PricingElement.GLDepartmentID || int ||   ||   ||
|| PricingElement.GLDepartmentIDOV || bit ||   ||   ||
|| PricingElement.ID || int || Primary Key Field ||   ||
|| PricingElement.IncomeClassTypeID || int ||   ||   ||
|| PricingElement.IncomeID || int ||   ||   ||
|| PricingElement.IncomeStoreID || int || Not Used. ||   ||
|| PricingElement.IsActive || bit || Indicates if Enabled. 1Record is Active, 0Record is Not Active ||   ||
|| PricingElement.IsSystem || bit || Used to Mark Required Records ||   ||
|| PricingElement.ItemPrefix || varchar(25) ||   ||   ||
|| PricingElement.LinkClassTypeID || int || ClassTypeID of Linked Item (if applicable) ||   ||
|| PricingElement.LinkID || int || ID of Linked Item (if applicable) ||   ||
|| PricingElement.LinkStoreID || int || Not Used. ||   ||
|| PricingElement.LocalTags || text ||   ||   ||
|| PricingElement.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| PricingElement.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| PricingElement.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| PricingElement.ParentClassTypeID || int || ClassTypeID of Category/Group above, usually the same as your own ClassTypeID ||   ||
|| PricingElement.ParentID || int || ID of Category/Group Above ||   ||
|| PricingElement.ParentStoreID || int || Not Used. ||   ||
|| PricingElement.PartType || int ||   ||   ||
|| PricingElement.SeqID || int ||   ||   ||
|| PricingElement.SortIndex || float || Index for Sorting (if applicable) ||   ||
|| PricingElement.StartDate || datetime ||   ||   ||
|| PricingElement.StoreID || int || Not Used. ||   ||
|| PricingElement.UDFLayoutSettings || text ||   ||   ||
|| PricingElement.UseCategoryDefaults || bit ||   ||   ||
Related Tables