Power BI Connector for QuickBooks Online

Build 22.0.8678

CompanyInfo

Retrieve information about the QuickBooks company.

Columns

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

The Id of the company.

SyncToken String True False False

Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.

MetaData_CreateTime Datetime True False False

The time the record was created.

MetaData_LastUpdatedTime Datetime True False False

The time the record was last updated.

CompanyName String True False False

The name of the company.

LegalName String True False False

The legal name of the company.

CompanyAddr_Id String False False False

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

CompanyAddr_Line1 String False False False

The first line of the address.

CompanyAddr_Line2 String False False False

The second line of the address.

CompanyAddr_Line3 String False False False

The third line of the address.

CompanyAddr_Line4 String False False False

The fourth line of the address.

CompanyAddr_Line5 String False False False

The fifth line of the address.

CompanyAddr_City String False False False

The city name.

CompanyAddr_Country String False False False

The country name.

CompanyAddr_CountrySubDivisionCode String False False False

The country region. The state name for the USA or the province name for Canada.

CompanyAddr_PostalCode String False False False

The postal code. The zip code for the USA and Canada.

CompanyAddr_Note String False False False

A note for the customer.

CompanyAddr_Lat String False False False

The latitude coordinate of the geocoded address.

CompanyAddr_Long String False False False

The longitude coordinate of the geocoded address.

CustomerCommunicationAddr_Id String False False False

The Id of the customer communication address. This field is assigned by the data service. The customer will use this address to contact the company. This field is also used to modify the address.

CustomerCommunicationAddr_Line1 String False False False

The first line of the address.

CustomerCommunicationAddr_Line2 String False False False

The second line of the address.

CustomerCommunicationAddr_Line3 String False False False

The third line of the address.

CustomerCommunicationAddr_Line4 String False False False

The fourth line of the address.

CustomerCommunicationAddr_Line5 String False False False

The fifth line of the address.

CustomerCommunicationAddr_City String False False False

The city name.

CustomerCommunicationAddr_Country String False False False

The country name.

CustomerCommunicationAddr_CountrySubDivisionCode String False False False

The country region. The state name for the USA or the province name for Canada.

CustomerCommunicationAddr_PostalCode String False False False

The postal code. The zip code for the USA and Canada.

CustomerCommunicationAddr_Note String False False False

The note for the customer.

CustomerCommunicationAddr_Lat String False False False

The latitude coordinate of the geocoded address.

CustomerCommunicationAddr_Long String False False False

The longitude coordinate of the geocoded address.

LegalAddr_Id String False False False

The Id of the company address used in government communications. This field is assigned by the data service and mainly used for modifying the address.

LegalAddr_Line1 String False False False

The first line of the address.

LegalAddr_Line2 String False False False

The second line of the address.

LegalAddr_Line3 String False False False

The third line of the address.

LegalAddr_Line4 String False False False

The fourth line of the address.

LegalAddr_Line5 String False False False

The fifth line of the address.

LegalAddr_City String False False False

The city name.

LegalAddr_Country String False False False

The country name.

LegalAddr_CountrySubDivisionCode String False False False

The region within a country. For example, the state name for the USA or the province name for Canada.

LegalAddr_PostalCode String False False False

The postal code. The zip code for the USA and Canada.

LegalAddr_Note String False False False

The note for the customer.

LegalAddr_Lat String False False False

The latitude coordinate of the geocoded address.

LegalAddr_Long String False False False

The longitude coordinate of the geocoded address.

Email_Address String True False False

The default email address.

PrimaryPhone_FreeFormNumber String True False False

The primary phone number.

EmployerId String True False False

The employer identifier (EIN).

Country String True False False

The country that the company belongs to. This field is used for financial calculations.

SupportedLanguages String True False False

A comma-separated list of languages supported by the company.

WebAddr_URI String True False False

The default company website.

CompanyStartDate Date True False False

The date when the company file was created. This field and Metadata_CreateTime contain the same value.

FiscalYearStartMonth String True False False

The start month of fiscal year.

NameValue String False False False

The name/value pairs of the element.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8678