The conversion data for all supported currencies is stored in the ARRFCURRCONVRATES table. The ARRFCURRCONVRATES 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 ARRFCURRCONVRATES 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. |
|
|
Copyright © 2013 CA.
All rights reserved.
|
|