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.