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 NOT NULL DEFAULT 0	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