CData Python Connector for QuickBooks Online

Build 25.0.9454

CompanyInfo

Retrieves core company information such as legal name, address, industry type, fiscal year start, and contact details, which underpin company-wide settings in QuickBooks Online.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True False False

The identifier (Id) of the company. This Id uniquely identifies the company record within QuickBooks Online.

SyncToken String True False False

The version number that is assigned to the company object. The sync token locks the object for one application at a time, and QuickBooks Online increments it after each modification. An update or delete operation that uses an older sync token fails, ensuring that only the latest version of the object is maintained.

MetaData_CreateTime Datetime True False False

The date and time when the company record was originally created in QuickBooks Online. The CreateTime value provides a reference point for auditing and synchronization.

MetaData_LastUpdatedTime Datetime True False False

The date and time when the company record was last updated in QuickBooks Online. The LastUpdatedTime value helps track changes and identify the most recent version of the record.

CompanyName String True False False

The name of the company. This name appears in QuickBooks Online reports and on customer-facing documents.

LegalName String True False False

The legal name of the company. The name might differ from the CompanyName and is used for regulatory or tax purposes.

CompanyAddr_Id String False False False

The Id of the Intuit entity for the company address that is mainly used for modifying the address. This Id is assigned by the data service.

CompanyAddr_Line1 String False False False

The first line of the company address.

CompanyAddr_Line2 String False False False

The second line of the company address.

CompanyAddr_Line3 String False False False

The third line of the company address.

CompanyAddr_Line4 String False False False

The fourth line of the company address.

CompanyAddr_Line5 String False False False

The fifth line of the company address.

CompanyAddr_City String False False False

The city name in the company address.

CompanyAddr_Country String False False False

The country name in the company address.

CompanyAddr_CountrySubDivisionCode String False False False

The country region in the company address. This is the state name for the USA or the province name for Canada.

CompanyAddr_PostalCode String False False False

The postal code in the company address. This is the ZIP code for the USA and Canada.

CompanyAddr_Note String False False False

A note about the company address. This note can be used for internal comments or directions.

CompanyAddr_Lat String False False False

The latitude coordinate of the geocoded company address. The coordinate can be used for mapping or location-based reporting.

CompanyAddr_Long String False False False

The longitude coordinate of the geocoded company address. The coordinate can be used for mapping or location-based reporting.

CustomerCommunicationAddr_Id String False False False

The Id of the customer communication address that is assigned by the data service. The customer uses this address to contact the company, and this Id is also used to modify the address.

CustomerCommunicationAddr_Line1 String False False False

The first line of the customer communication address.

CustomerCommunicationAddr_Line2 String False False False

The second line of the customer communication address.

CustomerCommunicationAddr_Line3 String False False False

The third line of the customer communication address.

CustomerCommunicationAddr_Line4 String False False False

The fourth line of the customer communication address.

CustomerCommunicationAddr_Line5 String False False False

The fifth line of the customer communication address.

CustomerCommunicationAddr_City String False False False

The city name in the customer communication address.

CustomerCommunicationAddr_Country String False False False

The country name in the customer communication address.

CustomerCommunicationAddr_CountrySubDivisionCode String False False False

The country region in the customer communication address. This is the state name for the USA or the province name for Canada.

CustomerCommunicationAddr_PostalCode String False False False

The postal code in the customer communication address. This is the ZIP code for the USA and Canada.

CustomerCommunicationAddr_Note String False False False

An optional note that is associated with the customer communication address. This note can provide instructions or clarifications for customers when contacting the company.

CustomerCommunicationAddr_Lat String False False False

The latitude coordinate that is associated with the geocoded customer communication address.

CustomerCommunicationAddr_Long String False False False

The longitude coordinate that is associated with the geocoded customer communication address.

LegalAddr_Id String False False False

The unique Id of the company's legal address record. This address is used in official government and tax communications. The Id is system-assigned by the data service and is primarily used for updates.

LegalAddr_Line1 String False False False

The first line of the company's legal address, typically containing the street address or P.O. Box.

LegalAddr_Line2 String False False False

The second line of the company's legal address, often used for suite numbers, building names, or additional address details.

LegalAddr_Line3 String False False False

The third line of the company's legal address, available if additional information is required.

LegalAddr_Line4 String False False False

The fourth line of the company's legal address.

LegalAddr_Line5 String False False False

The fifth line of the company's legal address.

LegalAddr_City String False False False

The city portion of the company's legal address.

LegalAddr_Country String False False False

The country portion of the company's legal address.

LegalAddr_CountrySubDivisionCode String False False False

The regional subdivision of the country for the company's legal address. For example, this value is the state name for the USA and the province name for Canada.

LegalAddr_PostalCode String False False False

The postal code that is associated with the company's legal address. For example, this value is the ZIP code for the USA and the postal code for Canada.

LegalAddr_Note String False False False

An optional note that is associated with the company's legal address. This note can provide additional context or internal comments about the address.

LegalAddr_Lat String False False False

The latitude coordinate that is associated with the geocoded legal address.

LegalAddr_Long String False False False

The longitude coordinate that is associated with the geocoded legal address.

Email_Address String True False False

The default email address that is associated with the company record in QuickBooks Online. This address is the one most often used for customer communications.

PrimaryPhone_FreeFormNumber String True False False

The company's primary phone number in free-form entry format. This phone number is the default number that is displayed to customers and vendors.

EmployerId String True False False

The employer identification number (EIN) that uniquely identifies the company for tax reporting purposes. In the USA, the EIN is issued by the Internal Revenue Service (IRS).

Country String True False False

The country that is associated with the company file. This field drives region-specific financial calculations, compliance requirements, and localized QuickBooks features.

SupportedLanguages String True False False

A comma-separated list of languages that are supported by the company file. For readability, each value is separated by a comma and a space (for example, English, French, Spanish).

WebAddr_URI String True False False

The default company website address (URL) that is stored in the company profile.

CompanyStartDate Date True False False

The official start date of the company file in QuickBooks Online. This value is the same as the MetaData_CreateTime field and marks when the company record was first created.

FiscalYearStartMonth String True False False

The month that marks the beginning of the company's fiscal year for accounting and reporting purposes. For example, a company migh have a fiscal year starting in January or July.

NameValue String False False False

A set of key-value pairs that store additional company attributes or configuration settings. Each entry consists of a name and its corresponding value.

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