Gravity
Search
K

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
Terms.Id
false
false
The Id of a term associated with the vendor.
TermRef_Name
String
True
Terms.Name
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.