search cancel

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

book

Article ID: 113490

calendar_today

Updated On:

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:

ColumnDescriptionFormat
VERSIONRate VersionInteger with a value of 1.
CURR_FROMThe 3-digit ISO currency code for the transaction currency from which Amount is converted.Integer with values between 0 and 1000.
CURR_FROM_STRThe 3-character ISO currency code for the transaction currency from which Amount is converted.String with exactly three characters.
CURR_TOThe 3-digit ISO currency code for the currency to which Amount is converted.Integer with values between 0 and 1000.
CURR_TO_STRThe 3-character ISO currency code for the currency to which Amount is converted.String with a maximum length of three characters.
CONV_RATEThe rate of conversion between CURR_FROM and CURR_TO or CURR_FROM_STR and CURR_TO_STR.Real number.
DTCREATEDDate and time when the CONV_RATE value was created. 
CURR_NAME_AND_NOTESAdditional 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.