Exchange rates
WRCurrencyRates
Valid as of version 8.0
The table provides all exchange rates defined in the projects.
Relations
| Field (WRCurrencyRates) | Field | Table / View |
|---|---|---|
FromCurrency |
UnitID |
|
ToCurrency |
UnitID |
Field description
| Field | Description |
|---|---|
CurrencyRateID |
primary key, int not null Internal ID of the exchange rate |
FromCurrency |
int, not null Source Currency The label of the currency can be identified via the value as UnitID in the WRUnits table. |
ToCurrency |
int, not null Target Currency The label of the currency can be identified via the value as UnitID in the WRUnits table. |
Rate |
decimal(28,9), not null Exchange rate from the source currency (FromCurrency) to the target currency (ToCurrency). |