This table contains information about currency types.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
NAME
|
nvarchar(100)
|
false
|
|
The name of this Currency
|
|
ISO4217
|
nvarchar(3)
|
false
|
|
ISO4217 abbreviation
|
|
DECIMALDIGITS
|
tinyint
|
false
|
|
The number of digits after the decimal separator.
|
|
INACTIVE
|
bit
|
false
|
|
Denotes whether this currency is available for use.
|
|
CURRENCYSYMBOL
|
nvarchar(5)
|
false
|
|
The currency symbol for this record.
|
|
ROUNDINGTYPECODE
|
tinyint
|
false
|
|
The rounding method that this currency uses.
|
|
ROUNDINGTYPE
|
nvarchar(44) (Computed)
|
true
|
|
Provides a translation for the 'ROUNDINGTYPECODE' field.
|
|
ISORGANIZATIONCURRENCY
|
bit
|
false
|
|
Indicates whether or not this currency is the organization currency for the system.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
SYMBOLDISPLAYSETTINGCODE
|
tinyint
|
false
|
|
Indicates whether this currency's symbol should be displayed with amounts
|
|
SYMBOLDISPLAYSETTING
|
nvarchar(65) (Computed)
|
true
|
|
Provides a translation for the 'SYMBOLDISPLAYSETTINGCODE' field.
|
