Currency Table
Currency
stores a collection of currencies that can be used for money values.
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. 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. |