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