{$page}

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

See Also

You could leave a comment if you were logged in.