Skip to main content

Currency Identifier Type

Data Dictionary - Entity Table: Currency_Identifier_Type#

Defines the possible Currency Identifier types.
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, NN12PrimaryKey-ID (auto creates)Contains the currency identifier types
IdentifierVARCHAR(45)NULLAlphabetic, NumericIdentifier type based on ISO 4217