Reference > Database > WebSphere Commerce database tables > S
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 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 SQL100520030428060 SETCCURR Primary Key
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 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_3626 CURRENCY INSRULEINSOPT 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
- Calculation scale data model
- Payment summary data model
- Receipt data model
- Store data model
- Product Advisor data model
- Member data model
- Offers data model
- Catalog entry data model
- Currency data model
- E-coupon data model
_vcc_freeselect_bottom_