Updated: 2009-09-16
Version: Control 4.4
Table Purpose, Usage, and Notes
This table stores the information about the product that is specific to a particular pricing plan (like the pricing). You may have multiple pricing plan entries for any product, but will always have a Default entry.
Since modifiers don't support different plicing plans, modifiers will have exactly one entry for each record in the CustomerGoodsItem table.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 12040 - Product Pricing Plan
- 12041 - Modifier Pricing Plan
- Default PricingPlanID 10
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| PricingPlan.AccountCodeID | int | GL Account Code for Income (only used for products) | GLAccount.ID | ||||
| PricingPlan.AccountCodeIDOV | bit | ||||||
| PricingPlan.BaseMinimum | text | ||||||
| PricingPlan.BuiltInDiscountFx | text | ||||||
| PricingPlan.BuiltInDiscountTemplate | text | ||||||
| PricingPlan.ClassTypeID | int | Identifier for the Type of Object | |||||
| PricingPlan.CommissionPlanID | int | ||||||
| PricingPlan.CostMultiplierType | int | ||||||
| PricingPlan.CustomerWebOutputTemplateID | int | ||||||
| PricingPlan.DefaultDiscountFx | text | ||||||
| PricingPlan.DefaultDiscountTemplate | text | ||||||
| PricingPlan.EmployeeWebOutputTemplateID | int | ||||||
| PricingPlan.EquipmentCostFormula | text | ||||||
| PricingPlan.ErrorFx | text | ||||||
| PricingPlan.EstimateTemplateID | int | ||||||
| PricingPlan.EvaluateOnSaveFormulas | text | ||||||
| PricingPlan.FamilyClassTypeID | int | ||||||
| PricingPlan.FamilyID | int | Pricing Family ID | |||||
| PricingPlan.FamilyStoreID | int | Not Used. | |||||
| PricingPlan.FormulaTemplateFields | text | ||||||
| PricingPlan.FreightFormula | text | ||||||
| PricingPlan.GLDepartmentID | int | ||||||
| PricingPlan.GLDepartmentIDOV | bit | ||||||
| PricingPlan.GoodsItemClassTypeID | int | ||||||
| PricingPlan.GoodsItemID | int | ID of Product or Modifier | sql_structure_-_customergoodsitem_table.ID | ||||
| PricingPlan.ID | int | ||||||
| PricingPlan.IncludeModifierCost | bit | ||||||
| PricingPlan.InvoiceTemplateID | int | Summary Product Layout ID | |||||
| PricingPlan.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| PricingPlan.IsSystem | bit | Used to Mark Required Records | |||||
| PricingPlan.LaborCostFormula | text | ||||||
| PricingPlan.MaterialCostFormula | text | ||||||
| PricingPlan.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
| PricingPlan.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
| PricingPlan.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| PricingPlan.Notes | text | ||||||
| PricingPlan.OtherCostFormula | text | ||||||
| PricingPlan.OutsourceCostFormula | text | ||||||
| PricingPlan.OverallDiscountTableID | int | ||||||
| PricingPlan.OverallMinimum | text | ||||||
| PricingPlan.OverheadFormula | text | ||||||
| PricingPlan.PerPieceMinimum | text | ||||||
| PricingPlan.PreDiscountFx | text | ||||||
| PricingPlan.PreDiscountTemplate | text | ||||||
| PricingPlan.PreDiscountType | int | ||||||
| PricingPlan.PricingPlanTypeID | int | ID of the Pricing Plan this applies to (10 default) | PricingElement.ID where ClassTypeID 12050 | ||||
| PricingPlan.PricingPlanTypeName | varchar(50) | Name of the Pricing Plan this applies to | |||||
| PricingPlan.QtyDiscountTableID | int | ||||||
| PricingPlan.RoundingFactor | decimal(18, 4) | ||||||
| PricingPlan.RoyaltyPlanID | int | ||||||
| PricingPlan.ScreenTemplateID | int | Pricing Form Layout ID | |||||
| PricingPlan.SeqID | int | ||||||
| PricingPlan.SetUpFormula | text | ||||||
| PricingPlan.StoreID | int | Not Used. | |||||
| PricingPlan.UnitPriceParameterClassTypeID | int | ||||||
| PricingPlan.UnitPriceParameterID | int | ||||||
| PricingPlan.UnitPriceVariableClassTypeID | int | ||||||
| PricingPlan.UnitPriceVariableID | int | ID of Unit Price Variable (only used for products) | Variable.ID | ||||
| PricingPlan.UnitPriceVariableStoreID | int | Not Used. | |||||
| PricingPlan.UseCustomPriceMethod | bit | ||||||
| PricingPlan.WarningFx | text | ||||||
| PricingPlan.WebInputTemplateID | int | ||||||
| PricingPlan.WorkOrderTemplateID | int | Detail Product Layout ID |
Related Tables
You could leave a comment if you were logged in.