Database Table: SETCURRDSC

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

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
The text description of the currency in the language identified by LANGUAGE_ID.
LANGUAGE_ID INTEGER
NOT NULL
Language 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.
SETCCURR CHARACTER (3)
NOT NULL
This is a currency code as per ISO 4217 standards. Foreign key that references column SETCCURR in the SETCURR table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035103950 SETCCURR, LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_742 SETCCURR SETCURR SETCCURR Cascade
F_743 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable