Class
Facilitates the management of QuickBooks Classes, including creating, updating, deleting, and querying classifications. Updates require QBXML Version 8.0 or higher.
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 assigned to the class in QuickBooks. | |
| Name | String | False | 100 |
The name of the class, used for categorization or tracking within QuickBooks. | |
| FullName | String | True | 1000 |
The full hierarchical name of the class, formatted as ParentName|ClassName if it has a parent. | |
| IsActive | Boolean | False |
Indicates whether the class is active and available for use in QuickBooks. | ||
| ParentRef_FullName | String | False |
The full name of the parent class, if applicable. Specify either ParentRef_FullName or ParentRef_ListId on INSERT/UPDATE operations, but not both. | ||
| ParentRef_ListId | String | False |
Class.ID | 255 |
The unique identifier of the parent class, if applicable. Specify either ParentRef_FullName or ParentRef_ListId on INSERT/UPDATE operations, but not both. |
| Sublevel | Integer | True |
The hierarchical level of the class, indicating how many parent classes it has. | ||
| EditSequence | String | True | 16 |
A unique string used for versioning, representing the revision of the class. | |
| TimeCreated | Datetime | True |
The timestamp of when this class was originally created in QuickBooks. | ||
| TimeModified | Datetime | True |
The timestamp of the last modification made to this class in QuickBooks. |