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

# BranchById: Bouw7 Branch by ID

`read only` `REST`

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

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

Can only retrieve data.

## Summary

Returns a single branch based on the given ID.

## API Source

- Endpoint: `/organization/branch/{id}`
- Operation: `get /organization/branch/{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 `BranchById` 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 |
|---|---|---|:---:|---|---|
| `accountNumber` | `varchar2(255)` | Account Number | [ ] | filters on the platform, writable, `accountNumber` | Account number of the branch. |
| `address` | `varchar2(255)` | Address | [ ] | filters on the platform, writable, `address` | Address of the branch. |
| `afasAdministration` | `varchar2(255)` | AFAS Administration | [ ] | filters on the platform, writable, `afasAdministration` | Afas administration code of the branch. |
| `afasProjectLeader` | `varchar2(255)` | AFAS Project Leader | [ ] | filters on the platform, writable, `afasProjectLeader` | Afas project leader of the branch. |
| `city` | `varchar2(255)` | City | [ ] | filters on the platform, writable, `city` | City of the branch. |
| `cocNumber` | `varchar2(255)` | Chamber of Commerce Number | [ ] | filters on the platform, writable, `cocNumber` | The COC number. |
| `code` | `varchar2(255)` | Code | [ ] | filters on the platform, writable, `code` | The code of the branch. |
| `companyName` | `varchar2(255)` | Company Name | [ ] | filters on the platform, writable, `companyName` | The company name of the branch. |
| `countryCode` | `varchar2(2)` | Country Code | [ ] | filters on the platform, writable, `countryCode` | An ISO 3166-2 representation of the country. |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `createdAt` | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | filters on the platform, writable, `createdBy` | The user that created the entity. |
| `division_description` | `varchar2` | Division Description | [ ] | filters on the platform, writable, `division.description` | The description of the division this object is associated with. |
| `division_exactPaymentConditionPurchase` | `varchar2(255)` | itgen_bouw7_division_exactpaymentconditionpurchase | [ ] | filters on the platform, writable, `division.exactPaymentConditionPurchase` | A default payment condition to use for purchase related items. |
| `division_exactPaymentConditionSales` | `varchar2(255)` | itgen_bouw7_division_exactpaymentconditionsales | [ ] | filters on the platform, writable, `division.exactPaymentConditionSales` | A default payment condition to use for sales related items. |
| `division_glAccountCode` | `varchar2` | Division General Ledger Account Code | [ ] | filters on the platform, writable, `division.glAccountCode` | A general ledger account code to use for sales related items. |
| `division_glAccountCodePurchase` | `varchar2` | Division General Ledger Account Code Purchase | [ ] | filters on the platform, writable, `division.glAccountCodePurchase` | A general ledger account code to use for purchase related items. |
| `division_id` | `int64` | Division ID | [ ] | filters on the platform, writable, `division.id` | The ID of the division this object is associated with. |
| `division_journalCode` | `varchar2` | Division Journal Code | [ ] | filters on the platform, writable, `division.journalCode` | A journal code to use for sales related items. |
| `division_journalCodePurchase` | `varchar2` | Division Journal Code Purchase | [ ] | filters on the platform, writable, `division.journalCodePurchase` | A journal code to use for purchase related items. |
| `division_journalCodeWorkInProgress` | `varchar2` | itgen_bouw7_division_journalcodeworkinprogress | [ ] | filters on the platform, writable, `division.journalCodeWorkInProgress` | A default journal code to use for work in progress related items. |
| `division_workInProgressSettings_costCenterEquipment` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterequipment | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterEquipment` | A cost center to use for equipment related items. |
| `division_workInProgressSettings_costCenterEquipmentDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterequipmentdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterEquipmentDebit` | A cost center to use for equipment debit related items. |
| `division_workInProgressSettings_costCenterHours` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterhours | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterHours` | A cost center to use for hours related items. |
| `division_workInProgressSettings_costCenterHoursDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterhoursdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterHoursDebit` | A cost center to use for hours debit related items. |
| `division_workInProgressSettings_costCenterMaterial` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcentermaterial | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterMaterial` | A cost center to use for material related items. |
| `division_workInProgressSettings_costCenterMaterialDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcentermaterialdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterMaterialDebit` | A cost center to use for material debit related items. |
| `division_workInProgressSettings_costCenterPurchase` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterpurchase | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterPurchase` | A cost center to use for purchase related items. |
| `division_workInProgressSettings_costCenterPurchaseDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterpurchasedebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterPurchaseDebit` | A cost center to use for purchase debit related items. |
| `division_workInProgressSettings_costCenterSales` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcentersales | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterSales` | A cost center to use for sales related items. |
| `division_workInProgressSettings_costCenterSalesDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcentersalesdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterSalesDebit` | A cost center to use for sales debit related items. |
| `division_workInProgressSettings_costCenterWaste` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterwaste | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterWaste` | A cost center to use for waste related items. |
| `division_workInProgressSettings_costCenterWasteDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_costcenterwastedebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.costCenterWasteDebit` | A cost center to use for waste debit related items. |
| `division_workInProgressSettings_glAccountCodeEquipment` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodeequipment | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeEquipment` | A general ledger account code to use for equipment related items. |
| `division_workInProgressSettings_glAccountCodeEquipmentClosing` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodeequipmentclosing | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeEquipmentClosing` | A general ledger account code to use for equipment closing related items. |
| `division_workInProgressSettings_glAccountCodeEquipmentDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodeequipmentdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeEquipmentDebit` | A general ledger account code to use for equipment debit related items. |
| `division_workInProgressSettings_glAccountCodeHours` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodehours | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeHours` | A general ledger account code to use for hours related items. |
| `division_workInProgressSettings_glAccountCodeHoursClosing` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodehoursclosing | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeHoursClosing` | A general ledger account code to use for hours closing related items. |
| `division_workInProgressSettings_glAccountCodeHoursDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodehoursdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeHoursDebit` | A general ledger account code to use for hours debit related items. |
| `division_workInProgressSettings_glAccountCodeMaterial` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodematerial | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeMaterial` | A general ledger account code to use for material related items. |
| `division_workInProgressSettings_glAccountCodeMaterialClosing` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodematerialclosing | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeMaterialClosing` | A general ledger account code to use for material closing related items. |
| `division_workInProgressSettings_glAccountCodeMaterialDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodematerialdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeMaterialDebit` | A general ledger account code to use for material debit related items. |
| `division_workInProgressSettings_glAccountCodePurchase` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodepurchase | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodePurchase` | A general ledger account code to use for purchase related items. |
| `division_workInProgressSettings_glAccountCodePurchaseClosing` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodepurchaseclosing | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodePurchaseClosing` | A general ledger account code to use for purchase closing related items. |
| `division_workInProgressSettings_glAccountCodePurchaseDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodepurchasedebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodePurchaseDebit` | A general ledger account code to use for purchase debit related items. |
| `division_workInProgressSettings_glAccountCodeSales` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodesales | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeSales` | A general ledger account code to use for sales related items. |
| `division_workInProgressSettings_glAccountCodeSalesClosing` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodesalesclosing | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeSalesClosing` | A general ledger account code to use for sales closing related items. |
| `division_workInProgressSettings_glAccountCodeSalesDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodesalesdebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeSalesDebit` | A general ledger account code to use for sales debit related items. |
| `division_workInProgressSettings_glAccountCodeWaste` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodewaste | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeWaste` | A general ledger account code to use for waste related items. |
| `division_workInProgressSettings_glAccountCodeWasteClosing` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodewasteclosing | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeWasteClosing` | A general ledger account code to use for waste closing related items. |
| `division_workInProgressSettings_glAccountCodeWasteDebit` | `varchar2(255)` | itgen_bouw7_division_workinprogresssettings_glaccountcodewastedebit | [ ] | filters on the platform, writable, `division.workInProgressSettings.glAccountCodeWasteDebit` | A general ledger account code to use for waste debit related items. |
| `division_workInProgressSettings_id` | `int64` | itgen_bouw7_division_workinprogresssettings_id | [ ] | filters on the platform, writable, `division.workInProgressSettings.id` | The ID of the work in progress settings. |
| `email` | `varchar2(255)` | Email | [ ] | filters on the platform, writable, `email` | Email of the branch. |
| `file_createdAt` | `datetime` | File Created at | [ ] | filters on the platform, writable, `file.createdAt` | The creation time of the entity. |
| `file_createdBy` | `varchar2` | File Created by | [ ] | filters on the platform, writable, `file.createdBy` | The user that created the entity. |
| `file_extension` | `varchar2` | File Extension | [ ] | filters on the platform, writable, `file.extension` | The extension of the file. |
| `file_id` | `int64` | File ID | [ ] | filters on the platform, writable, `file.id` | The ID of this file |
| `file_modelId` | `int64` | File Model ID | [ ] | filters on the platform, writable, `file.modelId` | The ID of the associated type. |
| `file_modelType` | `varchar2` | File Model Type | [ ] | filters on the platform, writable, `file.modelType` | The category of the file. |
| `file_name` | `varchar2` | File Name | [ ] | filters on the platform, writable, `file.name` | The public name of the file. |
| `file_secureHash` | `varchar2` | itgen_bouw7_file_securehash | [ ] | filters on the platform, writable, `file.secureHash` | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. |
| `file_size` | `int64` | File Size | [ ] | filters on the platform, writable, `file.size` | The size of the file in bytes. |
| `file_updatedAt` | `datetime` | File Updated at | [ ] | filters on the platform, writable, `file.updatedAt` | The last updated time of the entity. |
| `file_updatedBy` | `varchar2` | File Updated by | [ ] | filters on the platform, writable, `file.updatedBy` | The user that last updated the entity. |
| `file_uri` | `varchar2` | File URI | [ ] | filters on the platform, writable, `file.uri` | The URI of the file, used to fetch the contents. |
| `gAccountPercentage` | `varchar2` | G-Account Percentage | [ ] | filters on the platform, writable, `gAccountPercentage` | The g account percentage of the branch. |
| `gAccountText` | `varchar2(255)` | G-Account Text | [ ] | filters on the platform, writable, `gAccountText` | The g account text of the branch. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | ID of the branch. |
| `invoiceFooter` | `varchar2` | Invoice Footer | [ ] | filters on the platform, writable, `invoiceFooter` | The invoice footer text. |
| `nAccountText` | `varchar2(255)` | N-Account Text | [ ] | filters on the platform, writable, `nAccountText` | The n account text of the branch. |
| `name` | `varchar2(255)` | Name | [ ] | filters on the platform, writable, `name` | Name of the branch. |
| `phoneNumber` | `varchar2(255)` | Phone Number | [ ] | filters on the platform, writable, `phoneNumber` | Phone number of the branch. |
| `updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable, `updatedAt` | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | filters on the platform, writable, `updatedBy` | The user that last updated the entity. |
| `useOrganizationInfo` | `char` | Use Organisation Info | [ ] | filters on the platform, writable, `useOrganizationInfo` | If organization information should be used instead of branch information. |
| `vatNumber` | `varchar2(255)` | VAT Number | [ ] | filters on the platform, writable, `vatNumber` | VAT number of the branch. |
| `wageComponentPercentage` | `varchar2` | Wage Component Percentage | [ ] | filters on the platform, writable, `wageComponentPercentage` | The wage component percentage of the branch. |
| `website` | `varchar2(255)` | Website | [ ] | filters on the platform, writable, `website` | The website of the branch. |
| `zipCode` | `varchar2(20)` | ZIP Code | [ ] | filters on the platform, writable, `zipCode` | ZIP code of the branch. |



## Release Notes

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

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

