FXRATES - Atoti Hub

The FXRATES table contains all the FX Rates. It is an isolated table and not part of any cube facts. FX Rates are looked up via the default implementation of IFXRates API.

Column Name	Type	Not Null	Description
AS_OF_DATE	DATE	Y	Timestamp (at close of business) for the data.
BASE_CCY	STRING	Y	The left side of the currency pair.
COUNTER_CCY	STRING	Y	The right side of the currency pair.
FX_RATE	DOUBLE	Y	Forex rate between the two currencies.

Unique Key

Columns
AS_OF_DATE
BASE_CCY
COUNTER_CCY

DESK_DESCRIPTION

LEGAL_ENTITY_ATTRIBUTES

⌘I

​Unique Key

Unique Key