Departments
Holds department or location records that are used to track income, expenses, and profitability by business unit or physical location.
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 |
Specifies the unique identifier (Id) of the department. | |
| SyncToken | String | True | False | False |
Specifies the version number that is used to lock the department object for use by one application at a time. When an application modifies an object, its sync token is incremented. Attempts to modify an object with an older sync token fail. | |
| MetaData_CreateTime | Datetime | True | True | True |
Specifies the date and time when the department record was created in the source domain. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
Specifies the date and time when the department record was last updated in the source domain. | |
| Name | String | False | True | True |
Specifies the name of the department. | |
| SubDepartment | Boolean | True | False | False |
Indicates whether the department is a subdepartment. | |
| ParentRef | String | False |
Departments.Id | False | False |
Specifies the unique Id of the parent class entity for the department. |
| ParentRef_Name | String | True |
Departments.Name | False | False |
Specifies the name of the parent class entity for the department. |
| FullyQualifiedName | String | True | False | False |
Specifies the fully qualified name of the department. The fully qualified name consists of the topmost parent element followed by each subelement separated by colons. For example: Parent:Account1:SubAccount1:SubAccount2. | |
| Active | Boolean | False | False | False |
Indicates whether the department is active. Inactive records are hidden from most display purposes and financial transactions. |