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.Documentation Index
Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
Use this file to discover all available pages before exploring further.
| 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 |