Power BI Connector for QuickBooks

Build 23.0.8839

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839