TABLE DETAIL REFERENCE: Currency
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 64TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CurrencyCode12 VARCHAR 3TrueTrueTrueTrue%s
CurrencyFormatThousandSeparator12 VARCHAR 10TrueTrueTrueFalse
Comma
Period
Space
Apostrophe
CurrencyFormatThousandSeparatorGrouping12 VARCHAR 11TrueTrueTrueFalse
XX_XXX_XXX
X_XX_XX_XXX
CurrencyFormatDecimalPlaces12 VARCHAR 1TrueTrueTrueFalse
0
2
CurrencyFormatDecimalSeparator12 VARCHAR 6TrueTrueTrueFalse
Period
Comma
IsUserDefinedCurrency-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ExchangeRate3 DECIMAL 15TrueFalseFalseFalse%6.8f
AsOfDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD