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
IDsmallint
No
Identifier; primary key.
CURRENCY_NAMEvarchar
254
No
Name of currency in the default language.
CURRENCY_NAME_ENvarchar
254
Yes
Name of currency in English.
ISO4217_ALPHA3char
3
No
ISO 4217 three-letter alphabetic code for the currency.
ISO4217_NUM3smallint
Yes
ISO 4217 three-number numeric code for the currency.
RECORD_START_DATEtimestamp
Yes
Date when the information in this warehouse record became effective
RECORD_END_DATEtimestamp
Yes
Date when the information in this warehouse record is no longer effective.
