Details:PriceLevel

TABLE DETAIL REFERENCE: PriceLevel

(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	31	True	True	True	True	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
PriceLevelType	12	VARCHAR	15	True	False	False	False	FixedPercentage PerItem
PriceLevelFixedPercentage	3	DECIMAL	18	True	True	True	False	%10.5f

QODBC.com Tools for QuickBooks