Currency

The following syntax is used to generate a statement for each exported Currency Table.

CREATE CURRENCY identifier.name 
   [DESC //description//] 
   [DECPL dec]
   [PIVOT year]
   [SHOW {EURO | ISO | USER}] 
   [ISOEDIT {Y|N}] 
   [RATES ( fromdate todate
   [ (fromcurrfromdesc' tocurrtodesc' rate) ]
   [ (fromcurrfromdesc' tocurrtodesc' rate) ] )]
   [TYPEn ( [ (code currency) ]
   [ (code currency) ] )] ;

Keywords

The keywords correspond to values that can be specified for a Currency Table. For more information, see Using the Currency Editor.

CURRENCY
Specify the name of the Currency Definition.
identifier.name
The two-part name of the Currency Definition name.
DESC
Describe the content or purpose of the Currency Definition.
//description//
The 1 to 40 character description of the Currency Definition, delimited by double slashes.

General

DECPL
Enter the number of decimal places for the value when triangulation is performed.
dec
Specify a value between 3 and 6.
PIVOT
Enter the value to determine the pivot year.
year
The value (00 to 99) that determines the appropriate century for two-digit years.
SHOW
Option to display currency codes on the Currency Editor selection lists available from the Rates tab.
EURO
Show a list of all European Community currency codes and user-defined codes on the Rates tab.
ISO
Show a list of all ISO and user-defined currency codes on the Rates tab.
USER
Show a list of all user-defined currency codes on the Rates tab.
ISOEDIT
Specify whether to permit the editing the ISO currency descriptions on the Rates tab.
Y
Allow editing of ISO description.
N
Disallow editing of ISO description.

Rate

RATES
Option to specify parameters for the currency rate.
Y
Allow editing of ISO description.
RATE
Follow this keyword with parameters for the currency rate.
fromdate
From date MM/DD/YYYY
todate
To date MM/DD/YYYY
Note: Calendar is the same as fromdate.
fromcurr
Source currency code (3 characters)
fromdesc'
Source currency code description, enclosed in single or double quotation marks.
tocurr
Target currency code (3 characters)
todesc'
Target currency code description, enclosed in single or double quotation marks.
rate
Conversion rate (n.n) for the “from” and “to” currency codes.

Type

TYPEn
Specify up to 4 lookup tables for currency codes. Type Table: Table 1, Table 2, Table 3, or Table 4
code
Code to represent a currency type as it appears in the Type Table.
currency
Currency code (3 characters)