Abbreviations

There are some abbreviations widely used in Pricefx world, see Common Abbreviations.

Calculation Logic

This is one of the key terms within Pricefx and is used throughout the application. In many areas of the application we can create logics which perform (price) calculations or logics that enrich data in the Datamart. A calculation logic can be compared to a formula in Excel or an ‘user exit’ in SAP.

Customer Extension

Customer extensions (CX) are attributes of customers that do not have a strict one-to-one relationship with a customer: the attributes can be changed over the time or a customer can have multiple attributes of the same type. Customer extensions accommodate these attributes.

Datamart

Datamart (DM) is a data table, with data coming generally from one or more Data Sources (it is possible to make a Datamart without a Data Source). This data set can then be enriched:

• with data from other joined data sources (through related matching columns); Datamart is then a combination of joined data sources
• or with data from 99584273 on the fly (not stored in DB)
• or with columns, whose values are calculated by a logic (via a Calculation Data Load; these are stored in DB).

Excel Client

The Excel Client allows you to:

• Manipulate your Pricefx data (customers, product extensions, users etc.) using MS Excel.
• Modify the metadata of the table columns (take special care when doing this).

The Excel Client can be accessed from the Master Data menu.

Limitations:

• The Excel Client is only suitable for smaller data sets, up to about 25,000 lines.
  
• Attributes in JSON format cannot be uploaded or downloaded using Excel Client.
• Company Parameters tables with JSON Table Type and JSON2 Value Type cannot be updated using Excel Client.
• When authenticating via Excel Client, the JWT token is stored in the downloaded XLSM file. This poses a security risk. To prevent injecting JWT token to the Excel file, set the application property doNotInjectJWTInEC to true. This however means that the user will have to log in when using Excel Client.

Live Price Grid

A Live Price Grid (LPG) is used when you need to handle a large number of products with rapidly changing prices, e.g. in an e-shop. In LPG prices are recalculated every day or even several times a day – this is a direct contrast to Price Lists which are calculated only once (see a detailed comparison of price grids and price lists).

Price List

In the Price Lists section you can create and manage the price lists. A price list is a set of products with a calculated price – the result price. The result price is calculated based on a calculation logic. Price lists are valid for a longer time period – in contrast to the Live Price Grids which are recalculated quite often (see a detailed comparison of price lists and price grids).

Pricing Method

The method we use to price a product, for example a margin price or competitive price. There is a defined set of methods which can be selected to price a part.

Company Parameter

Company Parameters define the rules, tables or values used for the price calculation. During price calculation, based on the calculation logic, values from the tables and rules are used (via the VLookup command). For example, if you use a volume discount in your price calculation, you need to set up and maintain a Company Parameter table with volume breaks and discount values. Usually this data is maintained manually in Pricefx.

Product Extension

Product Extensions (PX) are attributes of products that do not have a strict one-to-one relationship with a product: the attribute can change over time or a product can have multiple attributes of the same type. Product extensions accommodate these attributes. Product extensions can be used in price calculations. Product extensions can be classified by category.