Departments
Create, update, delete, and query QuickBooks Departments.
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 department. | |
| 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 department. | |
| SubDepartment | Boolean | True | False | False |
This field specifies whether the department is a subdepartment. | |
| ParentRef | String | False |
Departments.Id | False | False |
The Id of the parent class entity. |
| ParentRef_Name | String | True |
Departments.Name | False | False |
The name of the parent class entity. |
| FullyQualifiedName | String | True | False | False |
The fully qualified name of the department. The fully qualified name consists the topmost parent element followed by each subelement and separated by colons. For example: Parent:Account1:SubAccount1:SubAccount2. | |
| Active | Boolean | False | False | False |
This field indicates whether or not the department is active. Inactive records are hidden from most display purposes and financial transactions. |