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

# ProjectById: Bouw7 Project by ID

`read only` `REST`

- Catalog: `Bouw7`
- Schema: `Project`
- Label: Project by ID

Returns a project associated with the given id.
Returns a project associated with the given id.

Can only retrieve data.

## Summary

Returns a project associated with the given id.

## API Source

- Endpoint: `/project/{project}`
- Operation: `get /project/{project}`

## 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 |
|---|---|:---:|---|---|
| `project` | `` | [x] |  | Project ID |

## Table Columns

The columns of the table `ProjectById` 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 |
|---|---|---|:---:|---|---|
| `additionalWork` | `varchar2` | Additional Work | [ ] | filters on the platform, writable, `additionalWork` | Additional work amount for the project. |
| `branch_code` | `varchar2` | Branch Code | [ ] | filters on the platform, writable, `branch.code` | The code for this branch |
| `branch_division_description` | `varchar2` | itgen_bouw7_branch_division_description | [ ] | filters on the platform, writable, `branch.division.description` | The description of the division. |
| `branch_division_exactDivisionId` | `varchar2` | itgen_bouw7_branch_division_exactdivisionid | [ ] | filters on the platform, writable, `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, `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, `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, `branch.division.id` | The ID of the division. |
| `branch_division_journalCode` | `varchar2` | itgen_bouw7_branch_division_journalcode | [ ] | filters on the platform, writable, `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, `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, `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, `branch.id` | The ID of the branch. |
| `branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable, `branch.name` | The name of this branch |
| `category_code` | `varchar2` | Category Code | [ ] | filters on the platform, writable, `category.code` | The code for the category. |
| `category_createdAt` | `datetime` | Category Created at | [ ] | filters on the platform, writable, `category.createdAt` | The creation time of the entity. |
| `category_createdBy` | `varchar2` | Category Created by | [ ] | filters on the platform, writable, `category.createdBy` | The user that created the entity. |
| `category_generalCostsPercentage` | `varchar2` | Category General Costs Percentage | [ ] | filters on the platform, writable, `category.generalCostsPercentage` | The general costs percentage for the category. |
| `category_grossProfitMargin` | `varchar2` | Category Gross Profit Margin | [ ] | filters on the platform, writable, `category.grossProfitMargin` | The gross profit margin for the category. |
| `category_id` | `int64` | Category ID | [ ] | filters on the platform, writable, `category.id` | The ID of the category. |
| `category_name` | `varchar2` | Category Name | [ ] | filters on the platform, writable, `category.name` | The name of the category. |
| `category_updatedAt` | `datetime` | Category Updated at | [ ] | filters on the platform, writable, `category.updatedAt` | The last updated time of the entity. |
| `category_updatedBy` | `varchar2` | Category Updated by | [ ] | filters on the platform, writable, `category.updatedBy` | The user that last updated the entity. |
| `city` | `varchar2` | City | [ ] | filters on the platform, writable, `city` | The city of the project. |
| `contactPerson_city` | `varchar2` | Contact Person City | [ ] | filters on the platform, writable, `contactPerson.city` | The contact person's city. |
| `contactPerson_createdAt` | `datetime` | Contact Person Created at | [ ] | filters on the platform, writable, `contactPerson.createdAt` | The creation time of the entity. |
| `contactPerson_createdBy` | `varchar2` | Contact Person Created by | [ ] | filters on the platform, writable, `contactPerson.createdBy` | The user that created the entity. |
| `contactPerson_email` | `varchar2` | Contact Person Email | [ ] | filters on the platform, writable, `contactPerson.email` | The contact person's email address. |
| `contactPerson_firstName` | `varchar2` | Contact Person First Name | [ ] | filters on the platform, writable, `contactPerson.firstName` | The contact person's first name. |
| `contactPerson_houseNumber` | `varchar2(50)` | Contact Person House Number | [ ] | filters on the platform, writable, `contactPerson.houseNumber` | The contact person's house number. |
| `contactPerson_id` | `int64` | Contact Person ID | [ ] | filters on the platform, writable, `contactPerson.id` | The ID of contact person. |
| `contactPerson_lastName` | `varchar2` | Contact Person Last Name | [ ] | filters on the platform, writable, `contactPerson.lastName` | The contact person's last name. |
| `contactPerson_phoneNumber` | `varchar2` | Contact Person Phone Number | [ ] | filters on the platform, writable, `contactPerson.phoneNumber` | The contact person's phone number. |
| `contactPerson_streetName` | `varchar2` | Contact Person Street Name | [ ] | filters on the platform, writable, `contactPerson.streetName` | The contact person's street name. |
| `contactPerson_updatedAt` | `datetime` | Contact Person Updated at | [ ] | filters on the platform, writable, `contactPerson.updatedAt` | The last updated time of the entity. |
| `contactPerson_updatedBy` | `varchar2` | Contact Person Updated by | [ ] | filters on the platform, writable, `contactPerson.updatedBy` | The user that last updated the entity. |
| `contactPerson_zipCode` | `varchar2` | Contact Person ZIP Code | [ ] | filters on the platform, writable, `contactPerson.zipCode` | The contact person's zip code. |
| `contact_contactType_id` | `int64` | Contact Contact Type ID | [ ] | filters on the platform, writable, `contact.contactType.id` | The ID of contact type. |
| `contact_contactType_name` | `varchar2` | Contact Contact Type Name | [ ] | filters on the platform, writable, `contact.contactType.name` | The name of contact type. |
| `contact_email` | `varchar2` | Contact Email | [ ] | filters on the platform, writable, `contact.email` | The email address. |
| `contact_id` | `int64` | Contact ID | [ ] | filters on the platform, writable, `contact.id` | ID of contact. |
| `contact_isVatShifted` | `char` | Contact Is VAT Shifted | [ ] | filters on the platform, writable, `contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable, `contact.name` | Name of contact. |
| `contact_phoneNumber` | `varchar2` | Contact Phone Number | [ ] | filters on the platform, writable, `contact.phoneNumber` | The phone number of the contact. |
| `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. |
| `deliveryDate` | `datetime` | Delivery Date | [ ] | filters on the platform, writable, `deliveryDate` | Delivery date for the project. |
| `division_description` | `varchar2` | Division Description | [ ] | filters on the platform, writable, `division.description` | The description of the division. |
| `division_exactDivisionId` | `varchar2` | Division Exact Division ID | [ ] | filters on the platform, writable, `division.exactDivisionId` | The division ID of an Exact Online environment. |
| `division_glAccountCode` | `varchar2` | Division General Ledger Account Code | [ ] | filters on the platform, writable, `division.glAccountCode` | A default 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 default 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. |
| `division_journalCode` | `varchar2` | Division Journal Code | [ ] | filters on the platform, writable, `division.journalCode` | A default journal code to use for sales related items. |
| `division_journalCodePurchase` | `varchar2` | Division Journal Code Purchase | [ ] | filters on the platform, writable, `division.journalCodePurchase` | A default journal code to use for purchase related items. |
| `division_salesInvoiceNumberPrefix` | `varchar2(3)` | Division Sales Invoice Number Prefix | [ ] | filters on the platform, writable, `division.salesInvoiceNumberPrefix` | The prefix (3 digits) used to generate invoice number range per division. |
| `endDate` | `datetime` | End Date | [ ] | filters on the platform, writable, `endDate` | End date for the project in ATOM format. |
| `executor_firstName` | `varchar2` | Executor First Name | [ ] | filters on the platform, writable, `executor.firstName` | First name of the employee. |
| `executor_id` | `int64` | Executor ID | [ ] | filters on the platform, writable, `executor.id` | ID of the employee. |
| `executor_lastName` | `varchar2` | Executor Last Name | [ ] | filters on the platform, writable, `executor.lastName` | Last name of the employee. |
| `extraWork` | `varchar2` | Extra Work | [ ] | filters on the platform, writable, `extraWork` | Extra work for the project. |
| `fixedPrice` | `varchar2` | Fixed Price | [ ] | filters on the platform, writable, `fixedPrice` | Fixed price for the project. |
| `fullProjectNumber` | `varchar2` | Full Project Number | [ ] | filters on the platform, writable, `fullProjectNumber` | The full project number including year. |
| `generalCostsAmount` | `varchar2` | General Costs Amount | [ ] | filters on the platform, writable, `generalCostsAmount` | General costs amount for the project. |
| `hasAfasAssociation` | `char` | itgen_bouw7_hasafasassociation | [ ] | filters on the platform, writable, `hasAfasAssociation` | Whether the project has an association with AFAS. |
| `hasMareonAssociation` | `char` | Has Mare on Association | [ ] | filters on the platform, writable, `hasMareonAssociation` | Whether or not the project has an association with Mareon. |
| `hasSecurityObjects` | `char` | itgen_bouw7_hassecurityobjects | [ ] | filters on the platform, writable, `hasSecurityObjects` | Whether the project is security coded with security objects. |
| `hasSubprojects` | `char` | itgen_bouw7_hassubprojects | [ ] | filters on the platform, writable, `hasSubprojects` | Whether the project has subprojects. |
| `hoursEstimate` | `varchar2` | Hours Estimate | [ ] | filters on the platform, writable, `hoursEstimate` | Estimated hours for the project. |
| `houseNumber` | `varchar2` | House Number | [ ] | filters on the platform, writable, `houseNumber` | The house number for the project. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The ID of the project. |
| `information` | `varchar2` | Information | [ ] | filters on the platform, writable, `information` | Information about the project. |
| `isBooked` | `char` | Is Booked | [ ] | filters on the platform, writable, `isBooked` | Whether or not the project has been booked to a bookkeeping system. |
| `isSecurityCoded` | `char` | Is Security Coded | [ ] | filters on the platform, writable, `isSecurityCoded` | Whether or not the project is security coded. |
| `loggedHours` | `varchar2` | Logged Hours | [ ] | filters on the platform, writable, `loggedHours` | The amount of hours logged for the project. |
| `maintenanceStatusCode` | `varchar2` | Maintenance Status Code | [ ] | filters on the platform, writable, `maintenanceStatusCode` | The maintenance status code for the project. |
| `name` | `varchar2` | Name | [ ] | filters on the platform, writable, `name` | The name of the project. |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable, `note` | Notes for the project. |
| `parentId` | `int64` | Parent ID | [ ] | filters on the platform, writable, `parentId` | The ID of the parent project if this project is a subproject. |
| `planItemCount` | `int64` | Plan Item Count | [ ] | filters on the platform, writable, `planItemCount` | The count of plan items associated with this project. |
| `planning` | `varchar2` | Planning | [ ] | filters on the platform, writable, `planning` | The planning for the project. |
| `profitAndRisk` | `varchar2` | Profit and Risk | [ ] | filters on the platform, writable, `profitAndRisk` | Profit and risk amount for the project. |
| `projectLeader_firstName` | `varchar2` | Project Leader First Name | [ ] | filters on the platform, writable, `projectLeader.firstName` | First name of the employee. |
| `projectLeader_id` | `int64` | Project Leader ID | [ ] | filters on the platform, writable, `projectLeader.id` | ID of the employee. |
| `projectLeader_lastName` | `varchar2` | Project Leader Last Name | [ ] | filters on the platform, writable, `projectLeader.lastName` | Last name of the employee. |
| `projectNumber` | `varchar2` | Project Number | [ ] | filters on the platform, writable, `projectNumber` | The project number. |
| `propertyAsset_city` | `varchar2` | Property Asset City | [ ] | filters on the platform, writable, `propertyAsset.city` | City of the PropertyAsset. |
| `propertyAsset_country` | `varchar2` | Property Asset Country | [ ] | filters on the platform, writable, `propertyAsset.country` | ISO 3166-1[alpha2] country code of the PropertyAsset. |
| `propertyAsset_description` | `varchar2` | Property Asset Description | [ ] | filters on the platform, writable, `propertyAsset.description` | Description for the PropertyAsset. |
| `propertyAsset_firstDeliveryDate` | `datetime` | Property Asset First Delivery Date | [ ] | filters on the platform, writable, `propertyAsset.firstDeliveryDate` | First delivery date of the PropertyAsset. |
| `propertyAsset_houseNumber` | `varchar2` | Property Asset House Number | [ ] | filters on the platform, writable, `propertyAsset.houseNumber` | House number (incl. addition) of the PropertyAsset. |
| `propertyAsset_id` | `int64` | Property Asset ID | [ ] | filters on the platform, writable, `propertyAsset.id` | ID of the PropertyAsset. |
| `propertyAsset_invoiceContact_email` | `varchar2` | Property Asset Invoice Contact Email | [ ] | filters on the platform, writable, `propertyAsset.invoiceContact.email` | The email address. |
| `propertyAsset_invoiceContact_id` | `int64` | Property Asset Invoice Contact ID | [ ] | filters on the platform, writable, `propertyAsset.invoiceContact.id` | ID of contact. |
| `propertyAsset_invoiceContact_isVatShifted` | `char` | itgen_bouw7_propertyasset_invoicecontact_isvatshifted | [ ] | filters on the platform, writable, `propertyAsset.invoiceContact.isVatShifted` | Whether VAT is shifted for the contact. |
| `propertyAsset_invoiceContact_name` | `varchar2` | Property Asset Invoice Contact Name | [ ] | filters on the platform, writable, `propertyAsset.invoiceContact.name` | Name of contact. |
| `propertyAsset_invoiceContact_phoneNumber` | `varchar2` | itgen_bouw7_propertyasset_invoicecontact_phonenumber | [ ] | filters on the platform, writable, `propertyAsset.invoiceContact.phoneNumber` | The phone number of the contact. |
| `propertyAsset_name` | `varchar2` | Property Asset Name | [ ] | filters on the platform, writable, `propertyAsset.name` | Name of the PropertyAsset. |
| `propertyAsset_number` | `varchar2` | Property Asset Number | [ ] | filters on the platform, writable, `propertyAsset.number` | Number for the PropertyAsset. |
| `propertyAsset_postcode` | `varchar2` | Property Asset Post Code | [ ] | filters on the platform, writable, `propertyAsset.postcode` | Postcode of the PropertyAsset. |
| `propertyAsset_projectNameAndNumber` | `varchar2` | Property Asset Project Name and Number | [ ] | filters on the platform, writable, `propertyAsset.projectNameAndNumber` | The name and number of the Project the PropertyAsset belongs to. |
| `propertyAsset_residentContact_email` | `varchar2` | Property Asset Resident Contact Email | [ ] | filters on the platform, writable, `propertyAsset.residentContact.email` | The email address. |
| `propertyAsset_residentContact_id` | `int64` | Property Asset Resident Contact ID | [ ] | filters on the platform, writable, `propertyAsset.residentContact.id` | ID of contact. |
| `propertyAsset_residentContact_isVatShifted` | `char` | itgen_bouw7_propertyasset_residentcontact_isvatshifted | [ ] | filters on the platform, writable, `propertyAsset.residentContact.isVatShifted` | Whether VAT is shifted for the contact. |
| `propertyAsset_residentContact_name` | `varchar2` | Property Asset Resident Contact Name | [ ] | filters on the platform, writable, `propertyAsset.residentContact.name` | Name of contact. |
| `propertyAsset_residentContact_phoneNumber` | `varchar2` | itgen_bouw7_propertyasset_residentcontact_phonenumber | [ ] | filters on the platform, writable, `propertyAsset.residentContact.phoneNumber` | The phone number of the contact. |
| `propertyAsset_secondDeliveryDate` | `datetime` | Property Asset Second Delivery Date | [ ] | filters on the platform, writable, `propertyAsset.secondDeliveryDate` | Second delivery date of the PropertyAsset. |
| `propertyAsset_streetName` | `varchar2` | Property Asset Street Name | [ ] | filters on the platform, writable, `propertyAsset.streetName` | Street name of the PropertyAsset. |
| `provisionalCosts` | `varchar2` | itgen_bouw7_provisionalcosts | [ ] | filters on the platform, writable, `provisionalCosts` | Provisional cost for the project. |
| `reference` | `varchar2` | Reference | [ ] | filters on the platform, writable, `reference` | A reference for this project. |
| `startDate` | `datetime` | Start Date | [ ] | filters on the platform, writable, `startDate` | Start date for the project in ATOM format. |
| `status_closesProject` | `char` | Status Closes Project | [ ] | filters on the platform, writable, `status.closesProject` | Whether or not this status closes a project. |
| `status_createdAt` | `datetime` | Status Created at | [ ] | filters on the platform, writable, `status.createdAt` | The creation time of the entity. |
| `status_createdBy` | `varchar2` | Status Created by | [ ] | filters on the platform, writable, `status.createdBy` | The user that created the entity. |
| `status_id` | `int64` | Status ID | [ ] | filters on the platform, writable, `status.id` | The ID of the status. |
| `status_invoicesProject` | `char` | Status Invoices Project | [ ] | filters on the platform, writable, `status.invoicesProject` | Whether or not this status invoices a project. |
| `status_name` | `varchar2` | Status Name | [ ] | filters on the platform, writable, `status.name` | The name of the status. |
| `status_plansProject` | `char` | Status Plans Project | [ ] | filters on the platform, writable, `status.plansProject` | Whether or not this status plans a project. |
| `status_updatedAt` | `datetime` | Status Updated at | [ ] | filters on the platform, writable, `status.updatedAt` | The last updated time of the entity. |
| `status_updatedBy` | `varchar2` | Status Updated by | [ ] | filters on the platform, writable, `status.updatedBy` | The user that last updated the entity. |
| `streetName` | `varchar2` | Street Name | [ ] | filters on the platform, writable, `streetName` | The street name for the project. |
| `type` | `int64` | Type | [ ] | filters on the platform, writable, `type` | The type of project. |
| `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. |
| `workAddress` | `varchar2` | Work Address | [ ] | filters on the platform, writable, `workAddress` | The work address for this project. |
| `workPlanner_firstName` | `varchar2` | Work Planner First Name | [ ] | filters on the platform, writable, `workPlanner.firstName` | First name of the employee. |
| `workPlanner_id` | `int64` | Work Planner ID | [ ] | filters on the platform, writable, `workPlanner.id` | ID of the employee. |
| `workPlanner_lastName` | `varchar2` | Work Planner Last Name | [ ] | filters on the platform, writable, `workPlanner.lastName` | Last name of the employee. |
| `zipCode` | `varchar2` | ZIP Code | [ ] | filters on the platform, writable, `zipCode` | The zip code for the project. |



## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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