Database Table: SETCURR

The table contains information about the different national currencies. The currency alphabetic and numeric codes are derived from the ISO 4217 standard.

Column Name Column Type Column Description
SETCCODE INTEGER
NOT NULL
Numeric currency code as per ISO 4217.
SETCCURR CHARACTER (3)
NOT NULL
Alphabetic currency code as per ISO 4217. This is the primary key.
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)
NULL
Customizable. This column is not translated. The translatable text describing the currency in this table are stored in the SETCURRDSC table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035103640 SETCCURR Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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 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_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