Skip to main content


Data Dictionary - Entity Table: Currency#

Table with currency names. This information is essential evaluate the currency exposure and also to define the Currency Risk and the Trade Currency. Best practice is to use ISO 4217 for standard currency codes. The type of currency code which is maintained in the table can be defined by the Currency_Identifier table. ISO 4217 maintaince 2 types of currency codes: alphabetic code and numeric code.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN2Contains the identifier of currency objects
NameVARCHAR(45)NULLEUR, 978Currency code as per ISO4217