Understanding Currency Conversion
This article provides an overview of currency conversion and describes the schema of the ARRFCURRCONVRATES table. It includes the following topics:
cara
This article provides an overview of currency conversion and describes the schema of the ARRFCURRCONVRATES table. It includes the following topics:
2
How Currency Conversion Works
See How is Currency Conversion Used to understand how RA performs currency conversion.
Currency Conversion Table
The conversion data for all supported currencies is stored in the
ARRFCURRCONVRATES
table. This table contains the currency conversion data that is used to compare Amount field values when the transaction currency and the base currency of the organization differ. The following table describes the columns in the table.Column
| Description
| Format
|
VERSION | Rate Version | Integer with a value of 1. |
CURR_FROM | The 3-digit ISO currency code for the transaction currency from which Amount is converted. | Integer with values between 0 and 1000. |
CURR_FROM_STR | The 3-character ISO currency code for the transaction currency from which Amount is converted. | String with exactly three characters. |
CURR_TO | The 3-digit ISO currency code for the currency to which Amount is converted. | Integer with values between 0 and 1000. |
CURR_TO_STR | The 3-character ISO currency code for the currency to which Amount is converted. | String with a maximum length of three characters. |
CONV_RATE | The rate of conversion between CURR_FROM and CURR_TO or CURR_FROM_STR and CURR_TO_STR. | Real number. |
DTCREATED | Date and time when the CONV_RATE value was created. | |
CURR_NAME_AND_NOTES | Additional notes. |
Guidelines for Using the ARRFCURRCONVRATES Table
Apply the following guidelines when you use the ARRFCURRCONVRATES table:
- By default, there is no data in the ARRFCURRCONVRATES table. You must populate this table with values after deploying RA.
- The currency conversion rates should be specified as the conversion value for one unit of the specified CURR_FROM or CURR_FROM_STR and CURR_TO or CURR_TO_STR.
- The conversion rates in the ARRFCURRCONVRATES table should be loaded with the CURR_TO or CURR_TO_STR as USD only.
- If a particular currency conversion is required, for example from EUR to JPY, then the Amount would be first converted from EUR to USD using the conversion rate from EUR to USD, and then the reverse of the USD to JPY conversion rate would be applied to get the Amount in JPY.