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
The following filters support server-side execution. Other filters are executed client-side.
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. |