ODBC Driver for QuickBooks

Build 24.0.9175

Vendors

Manages QuickBooks Vendors, supporting creation, updates, deletion, and queries for supplier relationship management.

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 record in QuickBooks.

Name String False 100

The vendor's name. This field is required when adding a new vendor record.

Salutation String False 15

A salutation for the vendor, such as Mr., Mrs., Ms., or Dr.

FirstName String False 25

The first name of the vendor or primary contact.

MiddleInitial String False 25

The middle initial of the vendor or primary contact.

LastName String False 25

The last name of the vendor or primary contact.

Company String False 50

The name of the vendor's company or organization.

Contact String False 1023

The name of the primary contact person for the vendor.

AccountNumber String False 99

The account number assigned to the vendor.

Type String False 1000

The type or category of the vendor, predefined in QuickBooks.

TypeId String False 255

The unique identifier for the vendor type or category, predefined in QuickBooks.

CreditLimit Double False

The credit limit assigned to the vendor.

TaxIdentity String False 20

The tax identification number for the vendor, used for IRS reporting.

SalesTaxCountry String False 100

The country responsible for collecting applicable sales taxes. Available in international versions of QuickBooks with QBXML Version 8.0 or higher.

AlternateContact String False 41

The name of an alternate contact for the vendor.

Phone String False 21

The primary telephone number of the vendor.

Fax String False 21

The fax number of the vendor.

AlternatePhone String False 21

An alternate telephone number for the vendor.

Email String False 1023

The vendor's email address.

Cc String False 1023

An additional email address for the vendor.

Notes String False 5000

Notes or additional information about the vendor.

Address String True

The complete address of the vendor as returned by QuickBooks.

Line1 String False 500

The first line of the vendor's address.

Line2 String False 500

The second line of the vendor's address.

Line3 String False 500

The third line of the vendor's address.

Line4 String False 500

The fourth line of the vendor's address.

Line5 String False 41

The fifth line of the vendor's address.

City String False 255

The city for the vendor's address.

State String False 255

The state for the vendor's address.

PostalCode String False 30

The postal or ZIP code for the vendor's address.

Country String False 255

The country for the vendor's address.

Note String False 41

A note associated with the vendor's address.

ShippingAddress String True

The complete shipping address for the vendor. Requires QBXML Version 11.0 or higher.

ShippingLine1 String False 500

The first line of the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingLine2 String False 500

The second line of the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingLine3 String False 500

The third line of the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingLine4 String False 500

The fourth line of the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingLine5 String False 41

The fifth line of the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingCity String False 255

The city for the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingState String False 255

The state for the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingPostalCode String False 30

The postal or ZIP code for the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingCountry String False 255

The country for the vendor's shipping address. Requires QBXML Version 11.0 or higher.

ShippingNote String False 41

A note associated with the vendor's shipping address. Requires QBXML Version 11.0 or higher.

Balance Double True

The open balance for this vendor.

Terms String False 100

The payment terms associated with this vendor, such as '2% 10 Net 60'. This field can be set during inserts but not updates.

TermsId String False 255

The unique identifier for the payment terms associated with this vendor.

EligibleFor1099 Boolean False

Indicates whether the vendor is eligible for 1099 reporting.

NameOnCheck String False 110

The name that appears on checks for this vendor.

CurrencyName String False 64

The name of the currency used for this vendor. Requires QBXML Version 8.0 or higher.

CurrencyId String False

Currency.ID

255

The unique identifier for the currency used for this vendor. Requires QBXML Version 8.0 or higher.

IsActive Boolean False

Indicates whether the vendor is active.

CustomFields String False

Custom fields returned from QuickBooks, formatted as XML for additional metadata.

EditSequence String True 16

An identifier used for versioning of this vendor record.

TimeModified Datetime True

The date and time when this vendor record was last modified, formatted as YYYY-MM-DD HH:MM:SS.

TimeCreated Datetime True

The date and time when this vendor record was created, formatted as YYYY-MM-DD HH:MM:SS.

PrefillAccountId1 String False

The unique identifier for the first prefill account associated with this vendor.

PrefillAccountName1 String False

The name of the first prefill account associated with this vendor.

PrefillAccountId2 String False

The unique identifier for the second prefill account associated with this vendor.

PrefillAccountName2 String False

The name of the second prefill account associated with this vendor.

PrefillAccountId3 String False

The unique identifier for the third prefill account associated with this vendor.

PrefillAccountName3 String False

The name of the third prefill account associated with this vendor.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175