Glossary (Price Setting)

This glossary summarizes various terms used in Price Setting Accelerator.

Core Terms

Term	Description

Term

Description

Pricing Levels
Price Setting Levels
Pricing Structure
Dependency Structure
Dependency Configuration

You can calculate product prices on more levels, e.g. 1) Global 2) Regions 3) Countries 4) Shop.

The prices on lower levels can depend on prices from higher levels, i.e. the lower level price can be derived from the higher level price.

Prices for various Pricing Levels are then calculated in separate price grids/lists.

The various pricing levels and their dependencies are also referred to as Price Setting Levels, Pricing Structure, Dependency Structure, or Dependency Configuration.

The word “Dependency” is sometimes used in the meaning of “Level”, e.g. in the term “Dependency Mapping”.

Product Segmentation
Segmented Product Portfolio
Product Attribute Hierarchy

The various pricing factors (e.g. margin uplift in the Cost+ method) can depend not only on the Pricing Levels, but also on a combination of several product attributes, e.g. Industry, Business Unit, Product Group.

Those product attributes are not necessarily hierarchical, but for the definition of the pricing factors it is very useful (and needed) to have them in certain order.

A certain combination of values of those product attributes is known as a product segment. The product segment can be either very narrow (e.g. products with industry A, business unit B, product group C), but also more broad (e.g. products with industry A, business unit “any”, product group “any”).

Dependency Mapping

Technique how to find data relevant for certain Pricing Level (Dependency).

Data for different Levels can be stored either in separate tables, for example: a separate table for each country (this is called “Table”), or together in a single table where one field is dedicated to distinguishing which row belongs to each Level (this is called “Lookup”), or together in a single table without any differentiation to which level each row belong (this is called “None”).

Additional Terms

Terms	Description
Actual Price Lookup	Lookup for the current product price which is fetched based on the configuration.
Adjusted Price Corridor	Deviation between the global adjusted price and the final list price
Allow Manual Price Override	Defines whether the ManualPrice and ManualPriceReason elements should be visible.
Allow Manual Strategy Override	Defines whether the PriceSelector element should be visible.
Base Currency	Currency of the price list/grid.
Base Strategies	Ordered list of base strategies that precede normal price strategies. Base Strategies are usually defined on a more generic level to have some basic pricing rules across the complete product portfolio. They are used, for example, to make promotions override the standard strategy configuration.
Calculated Prices	Calculated prices for every defined strategy.
Changes From Monitor	If isPLCMTarget is true, it contains ResultMatrix describing to the user why this element was added to the price grid. Currently supported only for Global LPGs.
Competition Data	Data about competitors' pricing, read from the PCOMP table.
Cost	Cost of the product, read from the PX configured in the "PriceSettingConfig" PP. If not found, null is returned.
Country	Country for which the current calculation runs. If Global mode is used, the country will be "Global". If Headquarter mode is used, a value configured in the "PriceSettingConfig" PP will be used. Otherwise, the country has to be selected from a drop-down list in a given PL/LPG configuration. A list of available countries will be created dynamically based on the "CountryInformation" PP.
Country Adjustment	Percentage by which global prices will be multiplied to obtain local prices.
Country Lookup	Row from the "CountryInformation" PP.
Discount	Percentage discount applied when calculating the transition from a gross to net price.
Discount Group	Discount group for a specific product in a specific country.
Exceptions	Message with exceptions (if any). The value will be: Price Exception: <value> Strategy Exception: <value> Price Exception: <value> (+1) – if both exceptions are present
Exceptions Manager	Interface used for managing exceptions / manual overrides and making them allowed. Exceptions/Allowance logic is implemented here.
Exchange Rate	Exchange rate between global and current local currencies.
Final List Price	Value copied from used list price. This is the price before applying a discount.
Final Price	Used list price in case of a gross calculation; net price in case of a gross/net calculation.
Forecast Data	Cached map with forecast data for every product. It is calculated based on the PP configuration.
Global Adjusted Price	Final price from the global price list, adjusted with the country adjustment.
Global Calculated Item	Calculation result for the product on the global level.
Global Currency	Currency of the headquarter country or global price list. The data is loaded from the "CountryInformation" PP.
Global Decision	Decision extracted from a Global Calculated Item. It can be a strategy name, an exception table type message or a manual reason.
Global Level Adjusted Prices	Prices from the global price list, adjusted with the country adjustment.
Global Min Price	Minimum price read from a PX checked against final price. (coming soon)
Global Price	Price from the global calculation result extracted from a Global Calculated Item, after applying exchange rates.
Last Year Sales Volume	Volume from last year.
Last Year Turnover	Turnover from last year.
List Price Corridor	Deviation between the global price and final list price
Lookup Keys	Keys in the format Map<String, List<String>> where the key is a dimension and a List is a sorted list of keys (dimensions) for hierarchical lookups. Currently, only the Product dimension is supported.
Manual Price	Empty field acting as an input field for the user. Fill it with an override price if necessary. Its visibility depends on the configuration in Exceptions Manager. This value pops up automatically if there is an ExceptionsTable price exception.
Manual Price Reason	Empty field acting as an input field for the user. Fill it with a reason why a price has been overridden. Its visibility depends on the configuration in ExceptionsManager. If there is an ExceptionsTable price exception, the value is "Price Exception".
Margin	Margin calculated based on the final price and product cost.
MinimumMargin	Minimum margin for a specific product checked against “Margin”.
Net Price	Used list price with a discount applied.
Net Price Level	Indicates if a net price will be calculated.
OverrideRemover	Used for clearing manual/table overrides/exceptions when the default strategy does not allow it.
Pop Up Data	Calculates margin values for a popup data input.
Price Decision	Reason for a given price. ManualPriceReason if the price was overridden; a pricing strategy from Price Selector otherwise. If there was an ExceptionsTable exception, the value is "ExceptionTable - <exception type>".
Prices	PopUpData formatted into a user friendly MatrixResult.
Price Selector	Combo box with calculated prices and their strategies. Users can override a default strategy here.
Prices Summary	Generates data for a popup and price selector. It also collects prices from the global price list and applies a country adjustment to it.
Price Strategies	Ordered list of possible pricing strategies for the current product, read from the "StrategySelection" PP.
Sales Volume Forecast	Volume forecast for the upcoming period with values taken from the specific strategy set on the PriceSettingConfig PP.
Sales Volume YTD	Volume from this year.
Strategy Selection Entry	Lookup result from the "StrategySelection" PP. It is only in the country price list because only there more than one element can utilize this result.
Transaction Data	Cached map with transaction data for every product. It is split into the last year and year to date results.
Turnover Forecast	Turnover forecast for the upcoming period with values taken from the specific strategy set on the PriceSettingConfig PP.
Turnover YTD	Turnover from this year.
Used List Price	Value selected in PriceSelector or inserted in ManualPrice.
Warnings	User friendly table showing all warnings which occurred during the calculation.