Entity currency

Details of entity currency

Name

currency

Code

iso4217

Parent

Logical Data Model 'RRE DDA PER BANK LDM'

Comment

Currency denomination of instruments, in accordance with the ISO’s 4217 standard.

Proposed definition:
Currency is a Unit Of Measure that qualifies the monetary value of goods or services.

For example, USD for United States dollar, GBP for British pound sterling, EUR for Euro.
Please note that precious metals can be considered currencies as well.

Parent Entity

<None>


List of attributes of the entity currency

Name

Code

Comment

Data Type

Domain

Mandatory

Primary Identifier

Foreign Identifier

ISO 4217 currency code

iso_4217_currency_cd

 

Characters (3)

ISO 4217 Currency

X

X

 

numeric code

numeric_cd

The numeric code of the currency

Characters (3)

code numeric 3

 

 

 

name

name

Name of the currency.

Variable multibyte (255)

medium sized string

 

 

 


List of relationships of the entity currency

Name

Code

Generate

Entity 2

Entity 1

Dependent Role

Entity 1 -> Entity 2 Role Cardinality

Entity 2 -> Entity 1 Role Cardinality

is denomination currency of

currency_is_denomination_currency_of_instrument

X

instrument

currency

 

0,n

1,1


List of identifiers of the entity currency

Name

Code

Parent

Primary Identifier

currency PK

currency_pk

Entity 'currency'

X