Model: Cash Planning - Specifications for Dimension Table: ACCOUNTING CURRENCY

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

Attributes

Attribute	Description (where applicable)
Company Code	Represents the Company Code of the company where the accounting currency is used.
Conversion Factor	Represents the number of foreign currency units for which an exchange rate has been entered
Currency Code	Represents the Currency Code using three capital letters
Currency Code Desc	Built as CURRENCY CODE + '-' + Currency Name
EMU Currency From Date	Represents the EMU_CURRENCY_FROM_DATE, i.e. that date from where the currency was converted to EUR
ID	Built as COMPANY CODE + '^' + CURRENCY CODE
Inverted	If set to true inverted currency rate quotations is be used for the currency.

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
ACCOUNTING CURRENCY	DIM_CURRENCY_CODE_TM	DIM_CURRENCY_CODE_BI	DIM_CURRENCY_CODE	On Line