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:

NameTypeDescription
SETCCURRCHAR (3) NOT NULLAlphabetic currency code as per ISO 4217. This is the primary key.
SETCCODEINTEGER NOT NULLNumeric currency code as per ISO 4217.
SETCEXPINTEGER NOT NULLExponent (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.
SETCNOTEVARCHAR (40)Customizable. This column is not translated. The translatable text describing the currency in this table is stored in the SETCURRDSC table.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SETCCURRPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1153SETCCURRDKOFFERCURRENCYCascade
F_136SETCCURRBUYERPOSETCCURRCascade
F_167SETCCURRCALRLOOKUPSETCCURRCascade
F_175SETCCURRCALSCALESETCCURRCascade
F_268SETCCURRCPPMNSETCCURRCascade
F_278SETCCURRCREDITLINESETCCURRCascade
F_284SETCCURRCURCONVERTTOCURRCascade
F_285SETCCURRCURCONVERTFROMCURRCascade
F_287SETCCURRCURCVLISTCOUNTERVALUECURRCascade
F_288SETCCURRCURCVLISTCURRSTRCascade
F_294SETCCURRCURFORMATSETCCURRCascade
F_295SETCCURRCURLISTCURRSTRCascade
F_3626SETCCURRINSRULEINSOPTCURRENCYCascade
F_377SETCCURRICTPRICESSETCCURRCascade
F_418SETCCURRLISTPRICECURRENCYCascade
F_422SETCCURRLPOPURAMTSETCCURRCascade
F_426SETCCURRMANIFESTSETCCURRCascade
F_473SETCCURROFFERPRICECURRENCYCascade
F_580SETCCURRPAYSUMMARYSETCCURRCascade
F_662SETCCURRRECEIPTSETCCURRCascade
F_667SETCCURRREFUNDMTHDSETCCURRCascade
F_678SETCCURRRFQPRODCURRENCYCascade
F_687SETCCURRRFQRSPPRODCURRENCYCascade
F_742SETCCURRSETCURRDSCSETCCURRCascade
F_789SETCCURRSTOREENTSETCCURRCascade
F_800SETCCURRSTORELANGSETCCURRCascade
F_869SETCCURRTRDDEPAMTSETCCURRCascade
F_875SETCCURRTRDPURAMTSETCCURRCascade
F_879SETCCURRTRDREFAMTSETCCURRCascade
F_898SETCCURRUSERSSETCCURRCascade