Navigation :
FXRATES
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 |