Currency Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ListID 12 VARCHAR 36 True False False False %s 8.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 8.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 8.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 8.0 US, CA, UK
Name 12 VARCHAR 64 True True True True %s 8.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 8.0 US, CA, UK
CurrencyCode 12 VARCHAR 3 True True True True %s 8.0 US, CA, UK
CurrencyFormat_ThousandSeparator 12 VARCHAR 10 True True True False
Comma
Period
Space
Apostrophe
 8.0 US, CA, UK
CurrencyFormat_ThousandSeparatorGrouping 12 VARCHAR 10 True True True False
XX_XXX_XXX
X_XX_XX_XXX
 8.0 US, CA, UK
CurrencyFormat_DecimalPlaces 12 VARCHAR 1 True True True False
0
2
 8.0 US, CA, UK
CurrencyFormat_DecimalSeparator 12 VARCHAR 6 True True True False
Period
Comma
 8.0 US, CA, UK
IsUserDefinedCurrency -7 BIT 2 True False False False
1
0
true
false
 8.0 US, CA, UK
ExchangeRate 2 NUMERIC 18 True False False False %6.6f 8.0 US, CA, UK
AsOfDate 91 DATE 10 True False False False CCCC-MM-DD 8.0 US, CA, UK