The FX_RATE_MARKET_DATA table contains all the FX Rates. It is an isolated table and not part of any cube facts.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 | Default Value1 | Description |
|---|---|---|---|---|
| AS_OF_DATE | DATE | Y | Timestamp (at close of business) for the data. | |
| MARKET_DATA_SET | STRING | Y | String defining the market data set. | |
| BASE_CCY | STRING | Y | The left side of the currency pair. | |
| COUNTER_CCY | STRING | Y | The right side of the currency pair. | |
| QUOTE | DOUBLE | Y | Forex rate between the two currencies. |
Unique Key
| Columns |
|---|
| AS_OF_DATE |
| MARKET_DATA_SET |
| BASE_CCY |
| COUNTER_CCY |
- If the default value is marked as empty, it means that the default value is ‘null’ for nullable fields, and that a value needs to be explicitly set for non-nullable fields. ↩︎