ISO_4217

Definition


The ISO_4217 table contains information about the ISO 4217 currencies

Technical Data


Schema Version 4.5.13
Partitioned No

Summary


The ISO_4217 table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
CODE PK_ISO_4217_CODE         
NUMERIC_CODE          
RATIO_FRACTION          
SMALLEST_UNIT_FRACTION          

Column Details


CODE

Definition The ISO 4217 currency unique code
Type NVARCHAR(3), NOT NULL
Primary Key PK_ISO_4217_CODE

NUMERIC_CODE

Definition The ISO 4217 currency numeric code
Type DECIMAL(3), NOT NULL

RATIO_FRACTION

Definition The unit of the whole part of this currency
Type DECIMAL(28), NOT NULL

SMALLEST_UNIT_FRACTION

Definition The smallest multiples of sub-unit in use for scriptural payment for this currency
Type DECIMAL(28), NOT NULL

Primary Key Details


PK_ISO_4217_CODE

Column(s) CODE
Tablespace CATALOG_INDX