JDBC Driver for QuickBooks Online

Build 25.0.9434

Class

Stores QuickBooks Classes that are used to categorize transactions across multiple business segments or projects, supporting more granular reporting and profit/loss tracking.

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 identifier (Id) of the class. This Id uniquely identifies the class record within QuickBooks Online.

SyncToken String True False False

The version number that is assigned to the class 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 True True

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

MetaData_LastUpdatedTime Datetime True True True

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

Name String False True True

The name of the class. This name allows users to identify and select the correct class in QuickBooks Online.

SubClass Boolean True True True

Indicates whether the class is a subclass. The SubClass field shows whether the class is nested under another class for reporting or organizational purposes.

ParentRef String False

Class.Id

False False

The Id of the parent record that is associated with this class. This Id links the class to its parent class in the hierarchy.

ParentRef_Name String True

Class.Name

False False

The name of the parent record that is associated with this class. This name is the human-readable counterpart to the ParentRef Id.

Active Boolean False True True

Indicates whether the class is active. Inactive classes might be hidden from display and excluded from financial transactions.

FullyQualifiedName String True True True

The fully qualified name of the class. This name consists of the topmost parent element followed by each subelement separated by colons (for example, Parent:Account1:SubAccount1:SubAccount). This field shows the full hierarchy of the class.

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