Currency Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ListID12VARCHAR36TrueFalseFalseFalse%s8.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ8.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ8.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s8.0US, CA, UK
Name12VARCHAR64TrueTrueTrueTrue%s8.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
8.0US, CA, UK
CurrencyCode12VARCHAR3TrueTrueTrueTrue%s8.0US, CA, UK
CurrencyFormat_ThousandSeparator12VARCHAR10TrueTrueTrueFalse
Comma
Period
Space
Apostrophe
8.0US, CA, UK
CurrencyFormat_ThousandSeparatorGrouping12VARCHAR10TrueTrueTrueFalse
XX_XXX_XXX
X_XX_XX_XXX
8.0US, CA, UK
CurrencyFormat_DecimalPlaces12VARCHAR1TrueTrueTrueFalse
0
2
8.0US, CA, UK
CurrencyFormat_DecimalSeparator12VARCHAR6TrueTrueTrueFalse
Period
Comma
8.0US, CA, UK
IsUserDefinedCurrency-7BIT2TrueFalseFalseFalse
1
0
true
false
8.0US, CA, UK
ExchangeRate2NUMERIC18TrueFalseFalseFalse%6.6f8.0US, CA, UK
AsOfDate91DATE10TrueFalseFalseFalseCCCC-MM-DD8.0US, CA, UK