SSIS Components for QuickBooks Online

Build 24.0.9060

Class

Create, update, delete, and query QuickBooks Classes.

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 class.

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.

Name String False True True

The name of the class.

SubClass Boolean True True True

This field indicates whether the class is a subclass or not.

ParentRef String False

Class.Id

False False

The Id of the parent record.

ParentRef_Name String True

Class.Name

False False

The Id of the parent record.

Active Boolean False True True

This field sets whether or not the class is active. Inactive classes may be hidden from display and excluded from financial transactions.

FullyQualifiedName String True True True

The fully qualified name of the class. The fully qualified name consists the topmost parent element followed by each subelement and separated by colons. For example: Parent:Account1:SubAccount1:SubAccount.

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