XM_CURRENCY_EXCHANGE_RATE
| Entity Name | XM_CURRENCY_EXCHANGE_RATE |
|---|---|
| Entity Type | Independent |
| Definition | This table contains currency exchange information that is used for single currency reporting. |
Attributes
| Attribute | Datatype | Width | Definition |
|---|---|---|---|
| FX_RATE_ID | Integer | 11 | UID |
| FROM_CURRENCY_CODE | Varchar | 3 | Exchange rate from this currency. |
| TO_CURRENCY_CODE | Varchar | 3 | Exchange rate to this currency. |
| FROM_VALID_DATE | DateTime | 21 | Exchange rate is valid from this date. |
| TO_VALID_DATE | DateTime | 21 | Exchange rate is valid up to this date. If null, rate is valid up to the current date. |
| FX_RATE | Float | 14 | The exchange rate. |
| CHANGE_TIMESTAMP | DateTime | 23 | |
| VariationID | Integer | 13 | |
| ACTIVE_STATUS | Varchar | 4 |