Currency_DIM Table

Currency_DIM is a dimension table storing latest currency exchange rates.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database 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.
Table 1. Database columns for Currency_DIM table

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.