SETCURR
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
Related reference
Calculation scale data model
Catalog entry data model
Currency data model
Member data model
Offers data model
Receipt data model
Store data model