Power BI Connector for QuickBooks Online

Build 24.0.9062

CompanyCurrency

Create, update, delete, and query QuickBooks CompanyCurrency. Applicable only for those companies that enable multicurrency, a companycurrency object defines a currency that is active in the QuickBooks Online company. One or more companycurrency objects are active based on the company's multicurrency business requirements and correspond to the list displayed by the Currency Center in the QuickBooks Online UI.

Table Specific Information

Select

All filterable columns support the following operators:

  • =
  • !=
  • >=
  • <=
  • >
  • <
  • IN
  • LIKE
  • CONTAINS

The driver processes other filters client-side within the driver.

Columns

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

The Id of the currency object.

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

The time the record was created.

MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

Code String False True True

A three letter string representing the ISO 4217 code for the currency.

Name String False False True

The fullName of the Currrency object.

Active Boolean False True False

This field sets whether or not the currency is active. Inactive accounts cannot be posted to and are excluded from search results, although references to them are preserved.

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