SETCURRDSC

This table stores the text descriptions for each of the currency in the SETCURR table in each of the supported language.

Column Descriptions:

NameTypeDescription
SETCCURRCHAR (3) NOT NULLThis is a currency code as per ISO 4217 standards. Foreign key that references column SETCCURR in the SETCURR table.
LANGUAGE_IDINTEGER NOT NULLLanguage ID of the Language. Foreign key that references the LANGUAGE_ID column in the Language table. For a list of language components, see the LANGUAGE table.
DESCRIPTIONVARCHAR (254)The text description of the currency in the language identified by LANGUAGE_ID.
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>SETCCURR+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_742SETCCURRSETCURRSETCCURRCascade
F_743LANGUAGE_IDLANGUAGELANGUAGE_IDCascade