> ## 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.

# 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 |