SSIS Components for QuickBooks Online

Build 20.0.7587

Vendors

Create, update, delete, and query QuickBooks 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587