The table contains information about the different national currencies. The currency alphabetic and numeric codes are derived from the ISO 4217 standard.
Column Description(s):
Column Name | Column Type | Description |
SETCCURR |
CHAR(3) NOT NULL |
Alphabetic currency code as per ISO 4217. This is the primary key. |
SETCCODE |
INTEGER NOT NULL |
Numeric currency code as per ISO 4217. |
SETCEXP |
INTEGER NOT NULL |
Exponent (power of 10). The exponential value by which a sub-unit of the currency (such as cents) is multiplied to get the main currency unit. For example, you would multiply the number of cents by 10 to the power -2 to get the number of dollars. |
SETCNOTE |
VARCHAR(40) |
Customizable. This column is not translated. The translatable text describing the currency in this table are stored in the SETCURRDSC table. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031310650 |
SETCCURR |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_136 |
SETCCURR |
BUYERPO |
SETCCURR |
Cascade |
F_167 |
SETCCURR |
CALRLOOKUP |
SETCCURR |
Cascade |
F_175 |
SETCCURR |
CALSCALE |
SETCCURR |
Cascade |
F_268 |
SETCCURR |
CPPMN |
SETCCURR |
Cascade |
F_278 |
SETCCURR |
CREDITLINE |
SETCCURR |
Cascade |
F_284 |
TOCURR |
CURCONVERT |
SETCCURR |
Cascade |
F_285 |
FROMCURR |
CURCONVERT |
SETCCURR |
Cascade |
F_287 |
COUNTERVALUECURR |
CURCVLIST |
SETCCURR |
Cascade |
F_288 |
CURRSTR |
CURCVLIST |
SETCCURR |
Cascade |
F_294 |
SETCCURR |
CURFORMAT |
SETCCURR |
Cascade |
F_295 |
CURRSTR |
CURLIST |
SETCCURR |
Cascade |
F_1153 |
CURRENCY |
DKOFFER |
SETCCURR |
Cascade |
F_377 |
SETCCURR |
ICTPRICES |
SETCCURR |
Cascade |
F_418 |
CURRENCY |
LISTPRICE |
SETCCURR |
Cascade |
F_422 |
SETCCURR |
LPOPURAMT |
SETCCURR |
Cascade |
F_426 |
SETCCURR |
MANIFEST |
SETCCURR |
Cascade |
F_473 |
CURRENCY |
OFFERPRICE |
SETCCURR |
Cascade |
F_580 |
SETCCURR |
PAYSUMMARY |
SETCCURR |
Cascade |
F_662 |
SETCCURR |
RECEIPT |
SETCCURR |
Cascade |
F_667 |
SETCCURR |
REFUNDMTHD |
SETCCURR |
Cascade |
F_678 |
CURRENCY |
RFQPROD |
SETCCURR |
Cascade |
F_687 |
CURRENCY |
RFQRSPPROD |
SETCCURR |
Cascade |
F_742 |
SETCCURR |
SETCURRDSC |
SETCCURR |
Cascade |
F_789 |
SETCCURR |
STOREENT |
SETCCURR |
Cascade |
F_800 |
SETCCURR |
STORELANG |
SETCCURR |
Cascade |
F_869 |
SETCCURR |
TRDDEPAMT |
SETCCURR |
Cascade |
F_875 |
SETCCURR |
TRDPURAMT |
SETCCURR |
Cascade |
F_879 |
SETCCURR |
TRDREFAMT |
SETCCURR |
Cascade |
F_898 |
SETCCURR |
USERS |
SETCCURR |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.