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

# DivisionById: Bouw7 Division by ID

`read only` `REST`

- Catalog: `Bouw7`
- Schema: `Organization`
- Label: Division by ID

Returns a single division based on the given ID.

Can only retrieve data.

## Summary

Returns a single division based on the given ID.

## API Source

- Endpoint: `/organization/division/{id}`
- Operation: `get /organization/division/{id}`

## 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 |
|---|---|:---:|---|---|
| `id` | `` | [x] |  |  |

## Table Columns

The columns of the table `DivisionById` 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 |
|---|---|---|:---:|---|---|
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `description` | The description of the division. |
| `exactDivisionId` | `varchar2` | Exact Division ID | [ ] | filters on the platform, writable, `exactDivisionId` | The division ID of an Exact Online environment. |
| `exactPaymentConditionPurchase` | `varchar2(255)` | Exact Payment Condition Purchase | [ ] | filters on the platform, writable, `exactPaymentConditionPurchase` | A default payment condition to use for purchase related items. |
| `exactPaymentConditionSales` | `varchar2(255)` | Exact Payment Condition Sales | [ ] | filters on the platform, writable, `exactPaymentConditionSales` | A default payment condition to use for sales related items. |
| `glAccountCode` | `varchar2` | General Ledger Account Code | [ ] | filters on the platform, writable, `glAccountCode` | A default general ledger account code to use for sales related items. |
| `glAccountCodePurchase` | `varchar2` | General Ledger Account Code Purchase | [ ] | filters on the platform, writable, `glAccountCodePurchase` | A default general ledger account code to use for purchase related items. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The ID of the division. |
| `journalCode` | `varchar2` | Journal Code | [ ] | filters on the platform, writable, `journalCode` | A default journal code to use for sales related items. |
| `journalCodePurchase` | `varchar2` | Journal Code Purchase | [ ] | filters on the platform, writable, `journalCodePurchase` | A default journal code to use for purchase related items. |
| `journalCodeWorkInProgress` | `varchar2` | Journal Code Work in Progress | [ ] | filters on the platform, writable, `journalCodeWorkInProgress` | A default journal code to use for work in progress related items. |
| `purchaseInvoiceImportBranch_code` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_code | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.code` | The code for this branch |
| `purchaseInvoiceImportBranch_division_description` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_division_description | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.description` | The description of the division. |
| `purchaseInvoiceImportBranch_division_exactDivisionId` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_division_exactdivisionid | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.exactDivisionId` | The division ID of an Exact Online environment. |
| `purchaseInvoiceImportBranch_division_glAccountCode` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_division_glaccountcode | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.glAccountCode` | A default general ledger account code to use for sales related items. |
| `purchaseInvoiceImportBranch_division_glAccountCodePurchase` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_division_glaccountcodepurchase | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.glAccountCodePurchase` | A default general ledger account code to use for purchase related items. |
| `purchaseInvoiceImportBranch_division_id` | `int64` | itgen_bouw7_purchaseinvoiceimportbranch_division_id | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.id` | The ID of the division. |
| `purchaseInvoiceImportBranch_division_journalCode` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_division_journalcode | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.journalCode` | A default journal code to use for sales related items. |
| `purchaseInvoiceImportBranch_division_journalCodePurchase` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_division_journalcodepurchase | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.journalCodePurchase` | A default journal code to use for purchase related items. |
| `purchaseInvoiceImportBranch_division_salesInvoiceNumberPrefix` | `varchar2(3)` | itgen_bouw7_purchaseinvoiceimportbranch_division_salesinvoicenumberprefix | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.division.salesInvoiceNumberPrefix` | The prefix (3 digits) used to generate invoice number range per division. |
| `purchaseInvoiceImportBranch_id` | `int64` | itgen_bouw7_purchaseinvoiceimportbranch_id | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.id` | The ID of the branch. |
| `purchaseInvoiceImportBranch_name` | `varchar2` | itgen_bouw7_purchaseinvoiceimportbranch_name | [ ] | filters on the platform, writable, `purchaseInvoiceImportBranch.name` | The name of this branch |
| `salesInvoiceNumberPrefix` | `varchar2(3)` | Sales Invoice Number Prefix | [ ] | filters on the platform, writable, `salesInvoiceNumberPrefix` | The prefix (3 digits) used to generate invoice number range per division. |
| `shouldImportForAllJournalsForPurchaseInvoice` | `char` | itgen_bouw7_shouldimportforalljournalsforpurchaseinvoice | [ ] | filters on the platform, writable, `shouldImportForAllJournalsForPurchaseInvoice` | Whether all journals are allowed when importing purchase invoices from Exact Online. |
| `workInProgressSettings_allowInvoiceLinesWithoutProject` | `char` | itgen_bouw7_workinprogresssettings_allowinvoicelineswithoutproject | [ ] | filters on the platform, writable, `workInProgressSettings.allowInvoiceLinesWithoutProject` | If invoice lines without project are allowed. |
| `workInProgressSettings_closingProjectStatus_closesProject` | `char` | itgen_bouw7_workinprogresssettings_closingprojectstatus_closesproject | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.closesProject` | Whether or not this status closes a project. |
| `workInProgressSettings_closingProjectStatus_createdAt` | `datetime` | itgen_bouw7_workinprogresssettings_closingprojectstatus_createdat | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.createdAt` | The creation time of the entity. |
| `workInProgressSettings_closingProjectStatus_createdBy` | `varchar2` | itgen_bouw7_workinprogresssettings_closingprojectstatus_createdby | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.createdBy` | The user that created the entity. |
| `workInProgressSettings_closingProjectStatus_id` | `int64` | itgen_bouw7_workinprogresssettings_closingprojectstatus_id | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.id` | The ID of the status. |
| `workInProgressSettings_closingProjectStatus_invoicesProject` | `char` | itgen_bouw7_workinprogresssettings_closingprojectstatus_invoicesproject | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.invoicesProject` | Whether or not this status invoices a project. |
| `workInProgressSettings_closingProjectStatus_name` | `varchar2` | itgen_bouw7_workinprogresssettings_closingprojectstatus_name | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.name` | The name of the status. |
| `workInProgressSettings_closingProjectStatus_plansProject` | `char` | itgen_bouw7_workinprogresssettings_closingprojectstatus_plansproject | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.plansProject` | Whether or not this status plans a project. |
| `workInProgressSettings_closingProjectStatus_updatedAt` | `datetime` | itgen_bouw7_workinprogresssettings_closingprojectstatus_updatedat | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.updatedAt` | The last updated time of the entity. |
| `workInProgressSettings_closingProjectStatus_updatedBy` | `varchar2` | itgen_bouw7_workinprogresssettings_closingprojectstatus_updatedby | [ ] | filters on the platform, writable, `workInProgressSettings.closingProjectStatus.updatedBy` | The user that last updated the entity. |
| `workInProgressSettings_costCenterEquipment` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterequipment | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterEquipment` | A cost center to use for equipment related items. |
| `workInProgressSettings_costCenterEquipmentDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterequipmentdebit | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterEquipmentDebit` | A cost center to use for equipment debit related items. |
| `workInProgressSettings_costCenterHours` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterhours | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterHours` | A cost center to use for hours related items. |
| `workInProgressSettings_costCenterHoursDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterhoursdebit | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterHoursDebit` | A cost center to use for hours debit related items. |
| `workInProgressSettings_costCenterMaterial` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcentermaterial | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterMaterial` | A cost center to use for material related items. |
| `workInProgressSettings_costCenterMaterialDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcentermaterialdebit | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterMaterialDebit` | A cost center to use for material debit related items. |
| `workInProgressSettings_costCenterPurchase` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterpurchase | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterPurchase` | A cost center to use for purchase related items. |
| `workInProgressSettings_costCenterPurchaseDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterpurchasedebit | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterPurchaseDebit` | A cost center to use for purchase debit related items. |
| `workInProgressSettings_costCenterSales` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcentersales | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterSales` | A cost center to use for sales related items. |
| `workInProgressSettings_costCenterSalesDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcentersalesdebit | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterSalesDebit` | A cost center to use for sales debit related items. |
| `workInProgressSettings_costCenterWaste` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterwaste | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterWaste` | A cost center to use for waste related items. |
| `workInProgressSettings_costCenterWasteDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_costcenterwastedebit | [ ] | filters on the platform, writable, `workInProgressSettings.costCenterWasteDebit` | A cost center to use for waste debit related items. |
| `workInProgressSettings_divisionId` | `int64` | itgen_bouw7_workinprogresssettings_divisionid | [ ] | filters on the platform, writable, `workInProgressSettings.divisionId` | The division ID that belongs to these settings. |
| `workInProgressSettings_glAccountCodeEquipment` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodeequipment | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeEquipment` | A general ledger account code to use for equipment related items. |
| `workInProgressSettings_glAccountCodeEquipmentClosing` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodeequipmentclosing | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeEquipmentClosing` | A general ledger account code to use for equipment closing related items. |
| `workInProgressSettings_glAccountCodeEquipmentDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodeequipmentdebit | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeEquipmentDebit` | A general ledger account code to use for equipment debit related items. |
| `workInProgressSettings_glAccountCodeHours` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodehours | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeHours` | A general ledger account code to use for hours related items. |
| `workInProgressSettings_glAccountCodeHoursClosing` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodehoursclosing | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeHoursClosing` | A general ledger account code to use for hours closing related items. |
| `workInProgressSettings_glAccountCodeHoursDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodehoursdebit | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeHoursDebit` | A general ledger account code to use for hours debit related items. |
| `workInProgressSettings_glAccountCodeMaterial` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodematerial | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeMaterial` | A general ledger account code to use for material related items. |
| `workInProgressSettings_glAccountCodeMaterialClosing` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodematerialclosing | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeMaterialClosing` | A general ledger account code to use for material closing related items. |
| `workInProgressSettings_glAccountCodeMaterialDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodematerialdebit | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeMaterialDebit` | A general ledger account code to use for material debit related items. |
| `workInProgressSettings_glAccountCodePurchase` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodepurchase | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodePurchase` | A general ledger account code to use for purchase related items. |
| `workInProgressSettings_glAccountCodePurchaseClosing` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodepurchaseclosing | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodePurchaseClosing` | A general ledger account code to use for purchase closing related items. |
| `workInProgressSettings_glAccountCodePurchaseDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodepurchasedebit | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodePurchaseDebit` | A general ledger account code to use for purchase debit related items. |
| `workInProgressSettings_glAccountCodeSales` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodesales | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeSales` | A general ledger account code to use for sales related items. |
| `workInProgressSettings_glAccountCodeSalesClosing` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodesalesclosing | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeSalesClosing` | A general ledger account code to use for sales closing related items. |
| `workInProgressSettings_glAccountCodeSalesDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodesalesdebit | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeSalesDebit` | A general ledger account code to use for sales debit related items. |
| `workInProgressSettings_glAccountCodeWaste` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodewaste | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeWaste` | A general ledger account code to use for waste related items. |
| `workInProgressSettings_glAccountCodeWasteClosing` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodewasteclosing | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeWasteClosing` | A general ledger account code to use for waste closing related items. |
| `workInProgressSettings_glAccountCodeWasteDebit` | `varchar2(255)` | itgen_bouw7_workinprogresssettings_glaccountcodewastedebit | [ ] | filters on the platform, writable, `workInProgressSettings.glAccountCodeWasteDebit` | A general ledger account code to use for waste debit related items. |
| `workInProgressSettings_id` | `int64` | itgen_bouw7_workinprogresssettings_id | [ ] | filters on the platform, writable, `workInProgressSettings.id` | The ID of the work in progress settings. |



## Release Notes

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

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

