Currency Table

Currency stores a collection of currencies that can be used for money values.

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 table

Database Column

Details

CurrencyID

Type: integer. Key. Generated ID

Unique identifier for a currency.

CurrencyName

Type: text (max 256 characters)

Name of currency.

CurrencyResourceID

Type: text (max 64 characters). Nullable

The resource string containing the name of this currency to display on the user interface.

CurrencyCode

Type: text (max 32 characters). Key

Code assigned to 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). Nullable

Long format of the currency. This is a calculated field.

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). Nullable

Short format of the currency. This is a calculated field.

IsActive

Type: boolean. Key

Indicates whether this currency is enabled.

Comments

Type: text. Nullable

Operator comments about this currency.

Countries

Type: text (max 2048 characters). Nullable

A semicolon-separated list of the country codes for countries to which this currency is applicable.

ActivationDate

Type: datetime. Nullable

Date currency was enabled.

RetirementDate

Type: datetime. Nullable

Date that currency was retired.

UpdatedUser

Type: text (max 256 characters). Nullable

Operator who made the latest change to the currency record.

UpdatedDate

Type: datetime. Nullable

Date that the currency record was changed.