Model: General Ledger - Specifications for Dimension Table: CURRENCY CODE

On this page you will find the specifications regarding the Model: General Ledger and Dimension Table: CURRENCY CODE.

Attributes

Attribute	Description (where applicable)
Company Code	Represents the natural parent COMPANY
Currency Code	Represents the CODE of the dimension, e.g. the currency code.
Currency Code Desc	Defined as CODE + ' - ' + DESCRIPTION
Currency Desc	Represents the DESCRIPTION for the currency code.
Company Code Desc	Defined as COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION
Conversion Factor	Represents the conversion factor (CONVERSION_FACTOR)  for the currency.
Inverted	Defines if the curency code by default supports rates in inverted quotation
EMU Currency From Date	That date from where the currency was converted to EUR

USED BY MODEL(S)

Model Name

CRM

General Ledger

Production Performance

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table	BI Access View	Referenced Information Source	Recommended Access Type
CURRENCY CODE	DIM_CURRENCY_CODE_BI	DIM_CURRENCY_CODE	On Line