Model: Cash Planning - Specifications for Dimension Table: CURRENCY

On this page you will find the specifications regarding the Model: Cash Planning and Dimension Table: CURRENCY.

Attributes

Attribute	Description (where applicable)
Company Code	Company code
Conversion Factor	Represents the conversion factor (CONVERSION_FACTOR)  for the currency.
Currency Code	Represents the CODE of the dimension, e.g. the currency code.
Currency Code Desc	Represents the Currency Code Description
EMU Currency From Date	Represents the EMU_CURRENCY_FROM_DATE, i.e. that date from where the currency was converted to EUR.
ID	Currency ID, company ID and Currency code
Inverted	Represents INVERTED "flag", i.e. if the curency code by default supports rates in inverted quotation.

USED BY MODEL(S)

Model Name

Cash Planning

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
CURRENCY	DIM_CURRENCY_CODE_TM	DIM_CURRENCY_CODE_BI	DIM_CURRENCY_CODE	On Line