Skip to main content

Vendors - DB Format

The Quickbooks Vendors provides information about vendors or suppliers involved in business transactions. It includes details such as vendor names, contact information, and associated attributes.

Add this job

Data

Sample Data

Open in new tab -

Data headers

HeaderDescription
BalanceCurrent balance associated with the vendor.
Vendor1099Indicates if the vendor is eligible for 1099 reporting (true/false).
DomainDomain information related to the vendor.
SparseIndicates if the vendor is sparse (true/false).
SyncTokenToken for synchronization purposes.
CompanyNameName of the vendor's company.
DisplayNameDisplay name of the vendor.
PrintOnCheckNameName used when printing checks for the vendor.
ActiveIndicates if the vendor is active (true/false).
BillAddr_Line1Line 1 of the billing address for the vendor.
BillAddr_Line2Line 2 of the billing address for the vendor.
BillAddr_CityCity of the billing address for the vendor.
BillAddr_CountryCountry of the billing address for the vendor.
BillAddr_CountrySubDivisionCodeCountry subdivision code for the billing address.
BillAddr_PostalCodePostal code of the billing address for the vendor.
CurrencyRef_valueValue of the currency reference.
CurrencyRef_nameName of the currency reference.
MetaData_CreateTimeTimestamp indicating the creation time.
MetaData_LastUpdatedTimeTimestamp indicating the last update time.
AlternatePhone_FreeFormNumberAlternate phone number of the vendor.
BillAddr_IdIdentifier for the billing address.
IdUnique identifier for the vendor.