---
title: "DepartmentWorkInProgressSettingsByDepartmentId (Bouw7)"
description: "itgen_bouw7_departmentworkinprogresssettingsbydepartmentid_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Department.DepartmentWorkInProgressSettingsByDepartmentId
original: https://documentation.invantive.eu/en/datamodels/exactonlinebouw/Bouw7.Department.DepartmentWorkInProgressSettingsByDepartmentId
updated: 2026-11-01T17:44:22Z
license: https://documentation.invantive.eu/en/
---

# DepartmentWorkInProgressSettingsByDepartmentId: Bouw7 itgen_bouw7_departmentworkinprogresssettingsbydepartmentid_plural

`read only` `REST`

- Catalog: `Bouw7`
- Schema: `Department`
- Label: itgen_bouw7_departmentworkinprogresssettingsbydepartmentid_plural

Returns a single department based on the given ID.
Returns a single department based on the given ID.

Can only retrieve data.

## Summary

Returns a single department based on the given ID.

## API Source

- Endpoint: `/organization/department/{department}`
- Operation: `get /organization/department/{department}`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `department` | `` | [x] |  |  |

## Table Columns

The columns of the table `DepartmentWorkInProgressSettingsByDepartmentId` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `branchId` | `int64` | itgen_bouw7_branchid | [ ] | writable, `branchId` | The ID of the linked branch. |
| `branch_code` | `varchar2` | Branch Code | [ ] | filters on the platform, writable, `::ancestor.branch.code` | The code for this branch |
| `branch_division_description` | `varchar2` | itgen_bouw7_branch_division_description | [ ] | filters on the platform, writable, `::ancestor.branch.division.description` | The description of the division. |
| `branch_division_exactDivisionId` | `varchar2` | itgen_bouw7_branch_division_exactdivisionid | [ ] | filters on the platform, writable, `::ancestor.branch.division.exactDivisionId` | The division ID of an Exact Online environment. |
| `branch_division_glAccountCode` | `varchar2` | itgen_bouw7_branch_division_glaccountcode | [ ] | filters on the platform, writable, `::ancestor.branch.division.glAccountCode` | A default general ledger account code to use for sales related items. |
| `branch_division_glAccountCodePurchase` | `varchar2` | itgen_bouw7_branch_division_glaccountcodepurchase | [ ] | filters on the platform, writable, `::ancestor.branch.division.glAccountCodePurchase` | A default general ledger account code to use for purchase related items. |
| `branch_division_id` | `int64` | itgen_bouw7_branch_division_id | [ ] | filters on the platform, writable, `::ancestor.branch.division.id` | The ID of the division. |
| `branch_division_journalCode` | `varchar2` | itgen_bouw7_branch_division_journalcode | [ ] | filters on the platform, writable, `::ancestor.branch.division.journalCode` | A default journal code to use for sales related items. |
| `branch_division_journalCodePurchase` | `varchar2` | itgen_bouw7_branch_division_journalcodepurchase | [ ] | filters on the platform, writable, `::ancestor.branch.division.journalCodePurchase` | A default journal code to use for purchase related items. |
| `branch_division_salesInvoiceNumberPrefix` | `varchar2(3)` | itgen_bouw7_branch_division_salesinvoicenumberprefix | [ ] | filters on the platform, writable, `::ancestor.branch.division.salesInvoiceNumberPrefix` | The prefix (3 digits) used to generate invoice number range per division. |
| `branch_id` | `int64` | Branch ID | [ ] | filters on the platform, writable, `::ancestor.branch.id` | The ID of the branch. |
| `branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable, `::ancestor.branch.name` | The name of this branch |
| `color` | `varchar2` | Colour | [ ] | filters on the platform, writable, `::ancestor.color` | Display color of the department |
| `costCenterHours` | `varchar2(255)` | itgen_bouw7_costcenterhours | [ ] | writable, `costCenterHours` | A cost center to use for hours related items. |
| `costCenterHoursDebit` | `varchar2(255)` | itgen_bouw7_costcenterhoursdebit | [ ] | writable, `costCenterHoursDebit` | A cost center to use for hours debit related items. |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `::ancestor.createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | filters on the platform, writable, `::ancestor.createdBy` | The user that created the entity. |
| `glAccountCodeHours` | `varchar2(255)` | itgen_bouw7_glaccountcodehours | [ ] | writable, `glAccountCodeHours` | A general ledger account code to use for hours related items. |
| `glAccountCodeHoursClosing` | `varchar2(255)` | itgen_bouw7_glaccountcodehoursclosing | [ ] | writable, `glAccountCodeHoursClosing` | A general ledger account code to use for hours closing related items. |
| `glAccountCodeHoursDebit` | `varchar2(255)` | itgen_bouw7_glaccountcodehoursdebit | [ ] | writable, `glAccountCodeHoursDebit` | A general ledger account code to use for hours debit related items. |
| `hasBranchSpecificAccess` | `char` | itgen_bouw7_hasbranchspecificaccess | [ ] | filters on the platform, writable, `::ancestor.hasBranchSpecificAccess` | Whether users within the department can only access items associated with one of the specified branches. |
| `id` | `int64` | ID | [ ] | writable, `id` | The ID of the work in progress settings. |
| `id_2` | `int64` | ID | [ ] | filters on the platform, writable, `::ancestor.id` | ID of the department. |
| `isActive` | `char` | Is Active | [ ] | filters on the platform, writable, `::ancestor.isActive` | Whether or not the department is active. |
| `isDataWithoutBranchAccessible` | `char` | itgen_bouw7_isdatawithoutbranchaccessible | [ ] | filters on the platform, writable, `::ancestor.isDataWithoutBranchAccessible` | Whether this branch can access data without a branch, this option is only used in combination with the hasBranchSpecificAccess=true. |
| `name` | `varchar2` | Name | [ ] | filters on the platform, writable, `::ancestor.name` | Name of the department. |
| `updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable, `::ancestor.updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | filters on the platform, writable, `::ancestor.updatedBy` | The user that last updated the entity. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Bouw7](/en/release-notes/drivers?driver=bouw7)

