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. | |
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. |