CompanyDivisions
Get the divisions of a company.
View Specific Information
Select
- CompanyId supports the '=' operator.
SELECT * FROM CompanyDivisions SELECT * FROM CompanyDivisions WHERE CompanyId = '12345'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the division. |
| CompanyId [KEY] | String | The identifier of the parent company. |
| Name | String | The name of the division. |
| RootParentID | String | The identifier of the root parent company in the hierarchy. |
| ParentID | String | The identifier of the immediate parent in the hierarchy. |
| HasDivisions | Boolean | Indicates whether this division contains child divisions. |
| HierarchyLevel | Integer | The depth of this division in the company hierarchy. |
| Divisions | String | Child divisions nested under this division. |