Support Entities

Product Price Formula Factor

Overview

This entity store the list of factors linked to a specific formula, these factor will be the only ones that can be used in the formula composition by using the formula factor ID.

 

Navigation

Purchasing ► Catalogue Item Price Projection ► Support Entities ► Product Price Formula Factor

 

Product Price Formula Factor screen Fields

Field

Description

Code

Unique identification number, automatically assigned by the system.

OriginIndicates how the Product Price Formula Factor is created in the system. Possible values are Manual and Data Import.
ActiveIndicates if the Product Price Formula Factor is active or not.
Factor typeReference to the factor that can be used in the formula composition.
Factor NameName of the Product Price Formula Factor.
Default Constant valueUsed to replace the default value coming from Formula Factor when Factor Type is "Constant".

Language

Language used for the saving the records.

Description

Description about the Product Price Formula Factor.

 

Product Price Type

Overview

This entity store the type of price that the system can produce; a list will be defined by the regions it will take into account for calculating Catalogue Item average prices.

 

Navigation

Purchasing ► Catalogue Item Price Projection ► Support Entities ► Product Price Type

 

Product Price Type Screen Fields and Tabs

Field

Description

Code

Unique value and automatically assigned by the system.

OriginIndicates how the Product Price Formula Factor is created in the system. Possible values are Manual and Data Import.

Language

Language used for the saving the records.

Name

Describes the Product Price list.

Active

Indicates if the Type of List is Active or not.

Regions

One or more region that is used to determine the Regions from where the OC will be taken to calculate average and historical prices of products for the list type.

 

Product Price Formula

Overview

This entity store the possible formulas use to generate the final projected prices of an item in a Product Price List.

 

Navigation

Purchasing ► Catalogue Item Price Projection ► Support Entities ► Product Price Formula

 

Product Price Formula Screen Fields and Tabs

Field

Description

Code

Unique value and automatically assigned by the system.

OriginIndicates how the Product Price Formula Factor is created in the system. Possible values are Manual and Data Import.
Is Used In CalculationIndicates if the formula was already used in a projection of prices, if so then this value should be set as “True”.
CompositionFormula composition including mathematical symbols and factors short names from Product Price Formula Factor.

Language

Language used for the descriptions.

Name

Name of the Product Price Formula.

Product Price Formula Factor

Zero or more factors to be used in the formula composition.

 

Inflation Product Factor

Overview

This entity stores the details of the inflation factor defined by the user for each Goods and services Category.

 

Navigation

Purchasing ► Catalogue Item Price Projection ► Support Entities ► Inflation Product Factor

 

Inflation Product Factor Screen Fields and Tabs

Field

Description

Code

Unique value and automatically assigned by the system.

Language

Language used for the descriptions.

Name

Name of the Inflation Product Factor.

Fiscal Year

Lookup to add Fiscal Year for the Inflation Product Factor.

Inflation Product Factor DetailsTab to enter Inflation Product Factor Details.

 

Inflation Product Factor Details

Overview

Details of the Inflation Product Factor are added from this tab.

 

Inflation Product Factor Tab Screen Fields

FieldDescription
Factor ValueValue to be applied to the factor.
Catalogue Item CategoryIndicates the level where to apply the inflation factor
Is Propagated ValuesIndicates if the current value for the category was propagated.
Fiscal YearsIndicates one or more fiscal years where the factor set can be applied for projection