Power BI Connector for QuickBooks

Build 23.0.8839

CompanyInfo

Query the company information from QuickBooks.

Columns

Name Type References Description
ID [KEY] String The employer identification number of the company.
Name String The company name.
Type String The type of company.
Address String Full address returned by QuickBooks.
Line1 String First line of the address.
Line2 String Second line of the address.
Line3 String Third line of the address.
Line4 String Fourth line of the address.
Line5 String Fifth line of the address.
City String City name for the address of the company.
State String State name for the address of the company.
PostalCode String Postal code for the address of the company.
Country String Country for the address of the company.
Note String Note for the address of the company.
Email String Company email address.
Phone String Company phone number.
Fax String Company fax number.
SSN String The SSN of the company.
Taxform String The tax form used by the company.
Website String Company website URL.
FirstMonthFiscal String The first month in the fiscal year for the company.
FirstMonthTax String The first month in the taxable year for the company.
LegalAddress String Full legal address of the company.
LegalCity String Legal city name for the company.
LegalCountry String Legal country name for the company.
LegalState String Legal state name for the company.
LegalZip String Legal zip code for the company.
LegalName String Legal company name.
ShippingAddress String Full shipping address returned by QuickBooks.
ShippingLine1 String First line of the shipping address.
ShippingLine2 String Second line of the shipping address.
ShippingLine3 String Third line of the shipping address.
ShippingLine4 String Fourth line of the shipping address.
ShippingLine5 String Fifth line of the shipping address.
ShippingCity String City name for the shipping address of the company.
ShippingState String State name for the shipping address of the company.
ShippingPostalCode String Postal code for the shipping address of the company.
ShippingCountry String Country for the shipping address of the company.
ShippingNote String Note for the shipping address of the company.
OpenedCompanyFile String The path to the currently opened company file in QuickBooks.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839