Details:Currency

TABLE DETAIL REFERENCE: Currency

(Canada VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ListID	12	VARCHAR	36	True	False	False	False	%s
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	64	True	True	True	True	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
CurrencyCode	12	VARCHAR	3	True	True	True	True	%s
CurrencyFormatThousandSeparator	12	VARCHAR	10	True	True	True	False	Comma Period Space Apostrophe
CurrencyFormatThousandSeparatorGrouping	12	VARCHAR	11	True	True	True	False	XX_XXX_XXX X_XX_XX_XXX
CurrencyFormatDecimalPlaces	12	VARCHAR	1	True	True	True	False	0 2
CurrencyFormatDecimalSeparator	12	VARCHAR	6	True	True	True	False	Period Comma
IsUserDefinedCurrency	-7	BIT	1	True	False	False	False	1 0 true false
ExchangeRate	3	DECIMAL	34	True	False	False	False	%6.8f
AsOfDate	9	DATE	6	True	False	False	False	CCCC-MM-DD

QODBC.com Tools for QuickBooks