Vendors

Create, update, delete, and query QuickBooks Vendors.

Table Specific Information

This table has a Custom Fields column. See the Custom Fields page for more information.

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or = comparison. The available columns for the Vendors table are Id, TimeModified, Balance, and Name. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Balance may be used with the >=, <=, or = conditions but cannot be used to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM Vendors WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND Name LIKE '%12345%'

Insert

To add a Vendor, specify the Name column.

Columns


Name	Type	ReadOnly	References	ColumnSize	Description
ID [KEY]	String	True		255	The unique identifier of the Vendor.
Name	String	False		100	The vendor's name. This is required to have a value when inserting.
Salutation	String	False		15	A salutation, such as Mr., Mrs., etc.
FirstName	String	False		25	A first name.
MiddleInitial	String	False		25	The middle initial.
LastName	String	False		25	A last name.
Company	String	False		50	The vendor's company name.
Contact	String	False		1023	The contact's name.
AccountNumber	String	False		99	The account number for this vendor.
Type	String	False		1000	The type of vendor, predefined in QuickBooks.
TypeId	String	False		255	The type of vendor, predefined in QuickBooks.
CreditLimit	Double	False			The credit limit for this vendor.
TaxIdentity	String	False		20	String that identifies the vendor to the IRS.
SalesTaxCountry	String	False		100	Identifies the country collecting applicable sales taxes. Only available in international editons of QuickBooks. QBXML version must be set to 8.0 or higher to use this field.
AlternateContact	String	False		41	The alternate contact's name.
Phone	String	False		21	The vendor's telephone number.
Fax	String	False		21	The vendor's fax number.
AlternatePhone	String	False		21	The vendor's alternate telephone number.
Email	String	False		1023	The vendor's email address.
Cc	String	False		1023	An additional email adress for a vendor.
Notes	String	False		5000	Notes on this vendor.
Address	String	True			Full address returned by QuickBooks.
Line1	String	False		500	First line of the address.
Line2	String	False		500	Second line of the address.
Line3	String	False		500	Third line of the address.
Line4	String	False		500	Fourth line of the address.
Line5	String	False		41	Fifth line of the address.
City	String	False		255	City name for the address of the vendor.
State	String	False		255	State name for the address of the vendor.
PostalCode	String	False		30	Postal code for the address of the vendor.
Country	String	False		255	Country for the address of the vendor.
Note	String	False		41	Note for the address of the vendor.
ShippingAddress	String	True			Full shipping address returned by QuickBooks. Requires QBXML Version 11.0 or higher.
ShippingLine1	String	False		500	First line of the shipping address. Requires QBXML Version 11.0 or higher.
ShippingLine2	String	False		500	Second line of the shipping address. Requires QBXML Version 11.0 or higher.
ShippingLine3	String	False		500	Third line of the shipping address. Requires QBXML Version 11.0 or higher.
ShippingLine4	String	False		500	Fourth line of the shipping address. Requires QBXML Version 11.0 or higher.
ShippingLine5	String	False		41	Fifth line of the shipping address. Requires QBXML Version 11.0 or higher.
ShippingCity	String	False		255	City name for the shipping address of the vendor. Requires QBXML Version 11.0 or higher.
ShippingState	String	False		255	State name for the shipping address of the vendor. Requires QBXML Version 11.0 or higher.
ShippingPostalCode	String	False		30	Postal code for the shipping address of the vendor. Requires QBXML Version 11.0 or higher.
ShippingCountry	String	False		255	Country for the shipping address of the vendor. Requires QBXML Version 11.0 or higher.
ShippingNote	String	False		41	Note for the shipping address of the vendor. Requires QBXML Version 11.0 or higher.
Balance	Double	True			Open balance for this vendor.
Terms	String	False		100	A reference to terms of payment for this vendor. A typical example might be '2% 10 Net 60'. This field can be set in inserts but not in updates.
TermsId	String	False		255	A reference to terms of payment for this vendor.
EligibleFor1099	Boolean	False			Whether this vendor is eligible for 1099.
NameOnCheck	String	False		110	The name to be printed on checks.
CurrencyName	String	False		64	Name of the currency code used for this vendor. QBXML version must be set to 8.0 or higher to use this field.
CurrencyId	String	False	Currency.ID	255	Id of the currency code used for this vendor. QBXML version must be set to 8.0 or higher to use this field.
IsActive	Boolean	False			Whether or not the vendor is active.
CustomFields	String	False			Custom fields returned from QuickBooks and formatted into XML.
EditSequence	String	True		16	An identifier for this copy of the object.
TimeModified	Datetime	True			When the vendor was last modified.
TimeCreated	Datetime	True			When the vendor was created.
PrefillAccountId1	String	False			Id of an Account Prefill defined for this vendor.
PrefillAccountName1	String	False			Name of an Account Prefill defined for this vendor.
PrefillAccountId2	String	False			Id of an Account Prefill defined for this vendor.
PrefillAccountName2	String	False			Name of an Account Prefill defined for this vendor.
PrefillAccountId3	String	False			Id of an Account Prefill defined for this vendor.
PrefillAccountName3	String	False			Name of an Account Prefill defined for this vendor.

Power BI Connector for QuickBooks

Vendors

Table Specific Information

Select

Insert

Columns