Details:Vendor

TABLE DETAIL REFERENCE: Vendor

(UK VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
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	41	True	True	True	True	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
IsTaxAgency	-7	BIT	1	True	True	True	False	1 0 true false
CompanyName	12	VARCHAR	41	True	True	True	False	%s
Salutation	12	VARCHAR	15	True	True	True	False	%s
FirstName	12	VARCHAR	25	True	True	True	False	%s
MiddleName	12	VARCHAR	5	True	True	True	False	%s
LastName	12	VARCHAR	25	True	True	True	False	%s
VendorAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
VendorAddressAddr5	12	VARCHAR	41	True	True	True	False	%s
VendorAddressCity	12	VARCHAR	31	True	True	True	False	%s
VendorAddressState	12	VARCHAR	21	True	True	True	False	%s
VendorAddressProvince	12	VARCHAR	21	True	True	True	False	%s
VendorAddressCounty	12	VARCHAR	21	True	True	True	False	%s
VendorAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
VendorAddressCountry	12	VARCHAR	31	True	True	True	False	%s
VendorAddressNote	12	VARCHAR	41	True	True	True	False	%s
VendorAddressBlockAddr1	12	VARCHAR	41	True	False	False	False	%s
VendorAddressBlockAddr2	12	VARCHAR	41	True	False	False	False	%s
VendorAddressBlockAddr3	12	VARCHAR	41	True	False	False	False	%s
VendorAddressBlockAddr4	12	VARCHAR	41	True	False	False	False	%s
VendorAddressBlockAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	False	False	False	%s
ShipAddressAddr5	12	VARCHAR	41	True	False	False	False	%s
ShipAddressCity	12	VARCHAR	31	True	False	False	False	%s
ShipAddressState	12	VARCHAR	21	True	False	False	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	False	False	False	%s
ShipAddressCountry	12	VARCHAR	31	True	False	False	False	%s
ShipAddressNote	12	VARCHAR	41	True	False	False	False	%s
Phone	12	VARCHAR	21	True	True	True	False	%s
AltPhone	12	VARCHAR	21	True	True	True	False	%s
Fax	12	VARCHAR	21	True	True	True	False	%s
Email	12	VARCHAR	1023	True	True	True	False	%s
Cc	12	VARCHAR	1023	True	True	True	False	%s
Contact	12	VARCHAR	41	True	True	True	False	%s
AltContact	12	VARCHAR	41	True	True	True	False	%s
NameOnCheck	12	VARCHAR	41	True	True	True	False	%s
AccountNumber	12	VARCHAR	99	True	True	True	False	%s
Notes	12	VARCHAR	4095	True	True	True	False	%s
VendorTypeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorTypeRefFullName	12	VARCHAR	159	True	True	True	False	%s	Yes
TermsRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TermsRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
CreditLimit	3	DECIMAL	15	True	True	True	False	%10.2f
VendorTaxIdent	12	VARCHAR	15	True	True	True	False	%s
IsVendorEligibleFor1099	-7	BIT	1	True	True	True	False	1 0 true false
IsVendorEligibleForT4A	-7	BIT	1	True	True	True	False	1 0 true false
OpenBalance	3	DECIMAL	15	True	False	True	False	%10.2f
OpenBalanceDate	9	DATE	6	True	False	True	False	CCCC-MM-DD
Balance	3	DECIMAL	15	True	False	False	False	%10.2f
BillingRateRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
BillingRateRefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
PrefillAccount1RefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PrefillAccount1RefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
PrefillAccount2RefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PrefillAccount2RefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
PrefillAccount3RefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PrefillAccount3RefFullName	12	VARCHAR	31	True	True	True	False	%s	Yes
ExternalGUID	12	VARCHAR	40	True	False	True	False	{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
BusinessNumber	12	VARCHAR	99	True	False	False	False	%s
SalesTaxCodeRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	False	True	False	%s	Yes
SalesTaxCountry	12	VARCHAR	100	True	True	True	False	%s
IsSalesTaxAgency	-7	BIT	1	True	True	True	False	1 0 true false
SalesTaxReturnRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
SalesTaxReturnRefFullName	12	VARCHAR	159	True	False	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	64	True	True	True	False	%s	Yes
CustomFieldAlan	12	VARCHAR	30	True	True	True	False	%s
CustomFieldB00630	12	VARCHAR	30	True	True	True	False	%s

QODBC.com Tools for QuickBooks