Power BI Connector for QuickBooks

Build 23.0.8839

Class

Create, update, delete, and query QuickBooks Classes. QuickBooks requires QBXML version 8.0 or higher for updates to a Class.

Table Specific Information

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available columns for the Class table are Id, Name, and IsActive. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax.

Insert

To insert a Class, specify the Name field.

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier of the class.

Name String False 100

The name of the class.

FullName String True 1000

The full name of the class in the form ParentName|ClassName.

IsActive Boolean False

Boolean determining if the class is active.

ParentRef_FullName String False

Full name of the parent for the class. You may specify only ParentRef_FullName or ParentRef_ListId on INSERT/UPDATE statements and not both.

ParentRef_ListId String False

Class.ID

255

Id for the parent of the class. You may specify only ParentRef_FullName or ParentRef_ListId on INSERT/UPDATE statements and not both.

Sublevel Integer True

How many parents the class has.

EditSequence String True 16

A string indicating the revision of the class.

TimeCreated Datetime True

The time the class was created.

TimeModified Datetime True

The last time the class was modified.

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