CurrencyRates
Retrieves currency exchange rates for specified dates and currency pairs, informing multi-currency postings and reports.
Columns
| Name | Type | Description |
| FromCurrency [KEY] | String | The currency from which the conversion is performed, used in the CurrencyRates table to denote the source currency in exchange rate calculations. |
| ToCurrency | String | The currency to which the conversion is applied, specifying the target currency in the CurrencyRates table for exchange rate purposes. |
| UserConversionType [KEY] | String | Indicates the method or approach used by the user to determine the conversion rate, stored in the CurrencyRates table for tracking custom conversions. |
| ConversionDate [KEY] | Date | The date when the conversion rate is effective, used to record historical rates and ensure accurate currency conversion based on the specified date. |
| ConversionRate | Decimal | The numerical value representing the rate at which one currency can be converted into another, essential for currency conversion calculations in the CurrencyRates table. |
| ConversionType [KEY] | String | Specifies the type of conversion, such as 'spot' or 'forward', indicating the nature of the exchange rate used in the CurrencyRates table. |
| CurrencyConversionType | String | Describes the classification of currency conversion, such as 'manual' or 'automatic', used for tracking how the conversion was applied in the CurrencyRates table. |
| EndDate | String | The end date of the currency rate validity period, marking when a particular conversion rate expires and helping to define the effective range for currency exchange rates. |
| Finder | String | The identifier or method used to search for or locate specific conversion rates within the system, typically used to filter rates in the CurrencyRates table. |
| LedgerName | String | The name of the ledger associated with the currency rates, used in the CurrencyRates table to ensure the correct ledger is linked to the exchange rate data. |
| MaxRollDays | String | The maximum number of days a conversion rate can be rolled over or extended, used to define the period during which a rate can remain valid without re-evaluation. |
| StartDate | String | The start date for the currency conversion rate, used to establish the beginning of the rate’s validity period and track historical exchange rates in the CurrencyRates table. |