What is the currency conversion data that is used to compare Amount field values

Products

• CA Payment Security
• ARCOT ECOMMERCE

Issue/Introduction

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.

What is the currency conversion data that is used to compare Amount field values?

Environment

Risk Analytics

Resolution

Currency Conversion 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.

Additional Information

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.