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