The ORTT table in SAP Business One stores information about the various Exchange ratesthat can be applied to the different currencies. It contains entries for each of the different exchange rates available in SAP Business One, as well as information on the Currenciesused in the various exchange rates. Specifically, the ORTT database contains data on the following fields:
- Date: The date for which the conversion rate applies.
- Source currency: The currency that is converted.
- Target currency: The currency into which the currency is converted.
- Exchange rate: The exchange rate from the source currency to the target currency.
- Valid from: The date from which the conversion rate is valid.
- Valid until: The date until which the conversion rate is valid.
- Last updated: The date when the conversion rate was last updated.
- Base rate: The base exchange rate used to calculate other exchange rates.
