SETCURR
The table contains information about the different national currencies. The currency alphabetic and numeric codes are derived from the ISO 4217 standard.
Column Descriptions:
| Name | 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 is stored in the SETCURRDSC table. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented. |
Indexes:
| Name | Column Names | Type |
|---|---|---|
| <SYSTEM-GENERATED> | SETCCURR | Primary Key |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
|---|---|---|---|---|
| F_1153 | SETCCURR | DKOFFER | CURRENCY | Cascade |
| 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 | SETCCURR | CURCONVERT | TOCURR | Cascade |
| F_285 | SETCCURR | CURCONVERT | FROMCURR | Cascade |
| F_287 | SETCCURR | CURCVLIST | COUNTERVALUECURR | Cascade |
| F_288 | SETCCURR | CURCVLIST | CURRSTR | Cascade |
| F_294 | SETCCURR | CURFORMAT | SETCCURR | Cascade |
| F_295 | SETCCURR | CURLIST | CURRSTR | Cascade |
| F_3626 | SETCCURR | INSRULEINSOPT | CURRENCY | Cascade |
| F_377 | SETCCURR | ICTPRICES | SETCCURR | Cascade |
| F_418 | SETCCURR | LISTPRICE | CURRENCY | Cascade |
| F_422 | SETCCURR | LPOPURAMT | SETCCURR | Cascade |
| F_426 | SETCCURR | MANIFEST | SETCCURR | Cascade |
| F_473 | SETCCURR | OFFERPRICE | CURRENCY | Cascade |
| F_580 | SETCCURR | PAYSUMMARY | SETCCURR | Cascade |
| F_662 | SETCCURR | RECEIPT | SETCCURR | Cascade |
| F_667 | SETCCURR | REFUNDMTHD | SETCCURR | Cascade |
| F_678 | SETCCURR | RFQPROD | CURRENCY | Cascade |
| F_687 | SETCCURR | RFQRSPPROD | CURRENCY | 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 |