GL_DAILY_RATES

General LedgerUsed in 10 subject areas1 reporting columns

General Ledger (GL).

Primary key: FROM_CURRENCY, TO_CURRENCY, CONVERSION_DATE, CONVERSION_TYPE

Columns

Column	Key	In reports	Description (inferred)
CONVERSION_DATE	PK	○	Conversion date.
CONVERSION_RATE		●	Conversion rate.
CONVERSION_TYPE	PK	○	Type of conversion.
FROM_CURRENCY	PK	○	From currency.
TO_CURRENCY	PK	○	To currency.

Change a column here and these are the reports that move with it — the blast radius for any change to GL_DAILY_RATES.

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for GL_DAILY_RATES?

We ship parameterized SQL, BICC config, and dbt models you own.