Vendors

Columns

Name

Type

ReadOnly

References

Filterable

Sortable

Description

Id [KEY]

String

True

true

true

The Id of the vendor.

SyncToken

String

True

false

false

Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.

MetaData_CreateTime

Datetime

False

true

true

The time the record was created.

MetaData_LastUpdatedTime

Datetime

False

true

true

The time the record was last updated.

Title

String

False

false

false

Title of a person.

GivenName

String

False

true

true

Given name or first name of a person.

MiddleName

String

False

true

true

Middle name of the person.

FamilyName

String

False

true

true

Family name or last name of the person.

Suffix

String

False

false

true

Suffix of the name.

DisplayName

String

False

true

true

The name of the vendor, as displayed.

CompanyName

String

False

true

true

The name of the company associated with the vendor.

PrintOnCheckName

String

False

true

true

Name of the person or organization as printed on a check

Active

Boolean

False

true

false

This field sets whether the vendor is currently enabled for use by QuickBooks.

PrimaryPhone_FreeFormNumber

String

False

false

false

Primary phone number.

AlternatePhone_FreeFormNumber

String

False

false

false

Alternate phone number.

Mobile_FreeFormNumber

String

False

false

false

The mobile phone number.

Fax_FreeFormNumber

String

False

false

false

Fax number.

PrimaryEmailAddr_Address

String

False

false

false

Email address of the vendor.

WebAddr_URI

String

False

false

false

Website address.

BillAddr_Id

String

False

false

false

Id of the entity for the billing address, mainly used for modifying the address. This field is assigned by the data service.

BillAddr_Line1

String

False

false

false

First line of the address.

BillAddr_Line2

String

False

false

false

Second line of the address.

BillAddr_Line3

String

False

false

false

Third line of the address.

BillAddr_Line4

String

False

false

false

Fourth line of the address.

BillAddr_Line5

String

False

false

false

Fifth line of the address.

BillAddr_City

String

False

false

false

City name.

BillAddr_Country

String

False

false

false

Country name.

BillAddr_CountrySubDivisionCode

String

False

false

false

Region within a country. For example, the state name for the USA and the province name for Canada.

BillAddr_PostalCode

String

False

false

false

Postal code. For example, the zip code for the USA and Canada.

BillAddr_Lat

String

False

false

false

Latitude coordinate of the geocoded address.

BillAddr_Long

String

False

false

false

Longitude coordinate of the geocoded address.

OtherContactInfo_Type

String

False

false

false

The type of contact information.

OtherContactInfo_Telephone_FreeFormNumber

String

False

false

false

Telephone number information.

TaxIdentifier

String

False

false

false

Tax Id of the vendor.

TermRef

String

False

false

false

The Id of a term associated with the vendor.

TermRef_Name

String

True

false

false

A name that identifies a term associated with the vendor.

Balance

String

False

true

true

The amount the company owes to this vendor. For the create operation, this represents the opening balance or the unpaid amount for the vendor. When returned in response to the query request it represents the current open balance or unpaid amount for that vendor.

AcctNum

String

False

false

false

Name or number of the account associated with this vendor.

Vendor1099

Boolean

False

false

false

This field specifies that the vendor is an independent contractor who is given a 1099-MISC form at the end of the year. The 1099 vendor is paid with regular checks and taxes are not withheld on their behalf.

CurrencyRef

String

False

false

false

The Id of the currency used in all the business transactions created for or received from that vendor.

CurrencyRef_Name

String

True

false

false

The name of the currency used in all the business transactions created for or received from that vendor.

Last updated