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.