CData Python Connector for QuickBooks

Build 24.0.9175

CompanyInfo

Queries detailed company information stored in QuickBooks, including company name, address, and settings.

Columns

Name Type References Description
ID [KEY] String The employer identification number (EIN) of the company, used for tax and identification purposes.
Name String The name of the company as registered in QuickBooks.
Type String The type or classification of the company, such as Corporation or Sole Proprietorship.
Address String The complete address of the company as recorded in QuickBooks.
Line1 String The first line of the company's address.
Line2 String The second line of the company's address.
Line3 String The third line of the company's address.
Line4 String The fourth line of the company's address.
Line5 String The fifth line of the company's address.
City String The city name in the company's address.
State String The state name in the company's address.
PostalCode String The postal code in the company's address.
Country String The country name in the company's address.
Note String A note or additional information related to the company's address.
Email String The email address associated with the company.
Phone String The company's primary phone number.
Fax String The company's fax number.
SSN String The Social Security Number (SSN) of the company, if applicable.
Taxform String The tax form used by the company, such as Form 1120 or Schedule C.
Website String The URL of the company's official website.
FirstMonthFiscal String The first month of the company's fiscal year.
FirstMonthTax String The first month of the company's taxable year.
LegalAddress String The full legal address of the company.
LegalCity String The city in the company's legal address.
LegalCountry String The country in the company's legal address.
LegalState String The state in the company's legal address.
LegalZip String The zip code in the company's legal address.
LegalName String The legal name of the company as registered.
ShippingAddress String The full shipping address of the company as recorded in QuickBooks.
ShippingLine1 String The first line of the company's shipping address.
ShippingLine2 String The second line of the company's shipping address.
ShippingLine3 String The third line of the company's shipping address.
ShippingLine4 String The fourth line of the company's shipping address.
ShippingLine5 String The fifth line of the company's shipping address.
ShippingCity String The city in the company's shipping address.
ShippingState String The state in the company's shipping address.
ShippingPostalCode String The postal code in the company's shipping address.
ShippingCountry String The country in the company's shipping address.
ShippingNote String A note or additional information related to the company's shipping address.
OpenedCompanyFile String The full file path of the currently opened company file in QuickBooks.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175