Currency_DIM Table
Currency_DIM
is a dimension table storing latest currency exchange rates.
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
CurrencyID
|
Type: integer. Key Primary key of the currency. |
CurrencyCode
|
Type: text (max 32 characters). Key Code assigned to the currency. |
LongPrefix
|
Type: text (max 32 characters) Long prefix to display in front of the money value. |
LongSuffix
|
Type: text (max 32 characters) Long suffix to display after the money value. |
LongFormat
|
Type: text (max 80 characters) Long format of the currency. |
ShortPrefix
|
Type: text (max 32 characters) Short prefix to display in front of the money value. |
ShortSuffix
|
Type: text (max 32 characters) Short suffix to display after the money value. |
ShortFormat
|
Type: text (max 80 characters) Short format of the currency. |
Currency_en
|
Type: text (max 1000 characters) Currency name in English. |
Currency_de
|
Type: text (max 1000 characters) Currency name in German. |
Currency_fr
|
Type: text (max 1000 characters) Currency name in French. |
Currency_ja
|
Type: text (max 1000 characters) Currency name in Japanese. |