Details:Vendor

TABLE DETAIL REFERENCE: Vendor

(POS 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
AccountNumber	12	VARCHAR	99	True	True	True	False	%s
City	12	VARCHAR	31	True	True	True	False	%s
CompanyName	12	VARCHAR	48	True	True	True	False	%s
Country	12	VARCHAR	31	True	True	True	False	%s
EMail	12	VARCHAR	99	True	True	True	False	%s
FirstName	12	VARCHAR	30	True	True	True	False	%s
IsInactive	-7	BIT	1	True	True	True	False	1 0 true false
LastName	12	VARCHAR	30	True	True	True	False	%s
Notes	12	VARCHAR	245	True	True	True	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
Phone2	12	VARCHAR	21	True	True	True	False	%s
Phone3	12	VARCHAR	21	True	True	True	False	%s
Phone4	12	VARCHAR	21	True	True	True	False	%s
PostalCode	12	VARCHAR	13	True	True	True	False	%s
Salutation	12	VARCHAR	15	True	True	True	False	%s
State	12	VARCHAR	21	True	True	True	False	%s
StoreExchangeStatus	12	VARCHAR	12	True	True	False	False	Modified Sent Acknowledged
Street	12	VARCHAR	41	True	True	True	False	%s
Terms	12	VARCHAR	200	True	False	False	False	%s
TermsDiscount	3	DECIMAL	13	True	True	True	False	%8.2f
TermsDiscountDays	4	INTEGER	4	True	True	True	False	%11.0f
TermsNetDays	4	INTEGER	4	True	True	True	False	%11.0f
VendorCode	12	VARCHAR	3	True	True	True	False	%s
CustomFieldOther	12	VARCHAR	30	True	False	False	False	%s
CustomFieldAccountingContact	12	VARCHAR	30	True	True	True	False	%s
CustomFieldAccountingEmail	12	VARCHAR	30	True	True	True	False	%s
CustomFieldAccountingPhone	12	VARCHAR	30	True	True	True	False	%s
CustomFieldBrand	12	VARCHAR	30	True	True	True	False	%s

QODBC.com Tools for QuickBooks