WebSphere Commerce 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 Descriptions
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 is stored in the SETCURRDSC table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235249430 SETCCURR Primary Key

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 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