The ARF_CURRENCY
table stores a list of currencies for reference. It uses the ISO 4217 codes. The provided currencies are:
Australian Dollar
Canadian Dollar
Yuan Renminbi
Japanese yen
Mexican Peso
Russian Ruble
Rand
Swiss Franc
Pound Sterling
US Dollar
Euro
No Currency
Column Name
Type
Length
Null Allowed
Description
ID
smallint
No
Identifier; primary key.
CURRENCY_NAME
varchar
254
No
Name of currency in the default language.
CURRENCY_NAME_EN
varchar
254
Yes
Name of currency in English.
ISO4217_ALPHA3
char
3
No
ISO 4217 three-letter alphabetic code for the currency.
ISO4217_NUM3
smallint
Yes
ISO 4217 three-number numeric code for the currency.
RECORD_START_DATE
timestamp
Yes
Date when the information in this warehouse record became effective
RECORD_END_DATE
timestamp
Yes
Date when the information in this warehouse record is no longer effective.