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

# QuotationById: Bouw7 Quotation by ID

`read only` `REST`

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

Returns the document of an existing quotation.
Returns the document of the given quotation.

Can only retrieve data.

## Summary

Returns the document of the given quotation.

## API Source

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

## 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 |
|---|---|:---:|---|---|
| `quotation` | `` | [x] |  | Quotation ID |

## Table Columns

The columns of the table `QuotationById` 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 |
|---|---|---|:---:|---|---|
| `activitiesTitle` | `varchar2(255)` | Activities Title | [ ] | filters on the platform, writable, `activitiesTitle` | The activities title of the quotation. |
| `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 |
| `calculationLabourDayPrice` | `varchar2` | Calculation Labour Day Price | [ ] | filters on the platform, writable, `calculationLabourDayPrice` | The calculation labour day price of this quotation. |
| `closingChance` | `int64` | Closing Chance | [ ] | filters on the platform, writable, `closingChance` | The closing chance of this quotation. |
| `commissionPercentage` | `varchar2` | Commission Percentage | [ ] | filters on the platform, writable, `commissionPercentage` | The commision percentage of this quotation. |
| `conditions` | `varchar2` | Conditions | [ ] | filters on the platform, writable, `conditions` | The conditions of this quotation. |
| `contactPersonText` | `varchar2(255)` | Contact Person Text | [ ] | filters on the platform, writable, `contactPersonText` | The contact person text of the quotation. |
| `contactPerson_city` | `varchar2(255)` | 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(256)` | Contact Person Email | [ ] | filters on the platform, writable, `contactPerson.email` | The contact person's email address. |
| `contactPerson_firstName` | `varchar2(256)` | 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_jobTitle` | `varchar2(64)` | Contact Person Job Title | [ ] | filters on the platform, writable, `contactPerson.jobTitle` | The contact person's job title. |
| `contactPerson_lastName` | `varchar2(256)` | Contact Person Last Name | [ ] | filters on the platform, writable, `contactPerson.lastName` | The contact person's last name. |
| `contactPerson_phoneNumber` | `varchar2(255)` | Contact Person Phone Number | [ ] | filters on the platform, writable, `contactPerson.phoneNumber` | The contact person's phone number. |
| `contactPerson_salutation` | `varchar2(32)` | Contact Person Salutation | [ ] | filters on the platform, writable, `contactPerson.salutation` | The contact person's salutation. |
| `contactPerson_streetName` | `varchar2(255)` | 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(20)` | 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. |
| `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. |
| `disableQuotationLines` | `char` | Disable Quotation Lines | [ ] | filters on the platform, writable, `disableQuotationLines` | Whether the quotation lines are disabled. |
| `discount` | `int64` | Discount | [ ] | filters on the platform, writable, `discount` | The discount of this quotation. |
| `employee_firstName` | `varchar2` | Employee First Name | [ ] | filters on the platform, writable, `employee.firstName` | First name of the employee. |
| `employee_id` | `int64` | Employee ID | [ ] | filters on the platform, writable, `employee.id` | ID of the employee. |
| `employee_lastName` | `varchar2` | Employee Last Name | [ ] | filters on the platform, writable, `employee.lastName` | Last name of the employee. |
| `expectedClosingDate` | `datetime` | Expected Closing Date | [ ] | filters on the platform, writable, `expectedClosingDate` | The expected closing date of this quotation. |
| `footer` | `varchar2` | Footer | [ ] | filters on the platform, writable, `footer` | The footer of the quotation. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The ID of the quotation. |
| `information` | `varchar2` | Information | [ ] | filters on the platform, writable, `information` | The information of the quotation. |
| `isCalculation` | `char` | Is Calculation | [ ] | filters on the platform, writable, `isCalculation` | Whether the quotation is a calculation. |
| `labourDayPrice` | `varchar2` | Labour Day Price | [ ] | filters on the platform, writable, `labourDayPrice` | The labour day price of this quotation. |
| `language` | `varchar2` | Language | [ ] | filters on the platform, writable, `language` | The locale used by this quotation, e.g.: nl-NL. |
| `layout` | `varchar2` | Layout | [ ] | filters on the platform, writable, `layout` | The layout of the quotation. |
| `mailSentAt` | `varchar2` | Mail Sent at | [ ] | filters on the platform, writable, `mailSentAt` | The date when the mail was sent. |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable, `note` | The note of this quotation. |
| `overheads` | `varchar2` | Overheads | [ ] | filters on the platform, writable, `overheads` | The general costs of this quotation. |
| `overheadsVatTariff_effectiveFrom` | `varchar2` | itgen_bouw7_overheadsvattariff_effectivefrom | [ ] | filters on the platform, writable, `overheadsVatTariff.effectiveFrom` | The datetime in ATOM format since this VAT tariff is effective. |
| `overheadsVatTariff_id` | `int64` | Overheads VAT Tariff ID | [ ] | filters on the platform, writable, `overheadsVatTariff.id` | ID of the vat tariff. |
| `overheadsVatTariff_label` | `varchar2` | Overheads VAT tariff Label | [ ] | filters on the platform, writable, `overheadsVatTariff.label` | Display label of the VAT tariff. |
| `overheadsVatTariff_percentage` | `varchar2` | Overheads VAT Tariff Percentage | [ ] | filters on the platform, writable, `overheadsVatTariff.percentage` | The VAT percentage. |
| `profitAndRisk` | `varchar2` | Profit and Risk | [ ] | filters on the platform, writable, `profitAndRisk` | The profit and risk costs of this quotation. |
| `profitAndRiskVatTariff_effectiveFrom` | `varchar2` | itgen_bouw7_profitandriskvattariff_effectivefrom | [ ] | filters on the platform, writable, `profitAndRiskVatTariff.effectiveFrom` | The datetime in ATOM format since this VAT tariff is effective. |
| `profitAndRiskVatTariff_id` | `int64` | Profit and Risk VAT Tariff ID | [ ] | filters on the platform, writable, `profitAndRiskVatTariff.id` | ID of the vat tariff. |
| `profitAndRiskVatTariff_label` | `varchar2` | Profit and Risk VAT Tariff Label | [ ] | filters on the platform, writable, `profitAndRiskVatTariff.label` | Display label of the VAT tariff. |
| `profitAndRiskVatTariff_percentage` | `varchar2` | Profit and Risk VAT Tariff Percentage | [ ] | filters on the platform, writable, `profitAndRiskVatTariff.percentage` | The VAT percentage. |
| `project_branch_code` | `varchar2` | itgen_bouw7_project_branch_code | [ ] | filters on the platform, writable, `project.branch.code` | The code for this branch |
| `project_branch_id` | `int64` | itgen_bouw7_project_branch_id | [ ] | filters on the platform, writable, `project.branch.id` | The ID of the branch. |
| `project_branch_name` | `varchar2` | itgen_bouw7_project_branch_name | [ ] | filters on the platform, writable, `project.branch.name` | The name of this branch |
| `project_category_code` | `varchar2` | itgen_bouw7_project_category_code | [ ] | filters on the platform, writable, `project.category.code` | The code for the category. |
| `project_category_createdAt` | `datetime` | itgen_bouw7_project_category_createdat | [ ] | filters on the platform, writable, `project.category.createdAt` | The creation time of the entity. |
| `project_category_createdBy` | `varchar2` | itgen_bouw7_project_category_createdby | [ ] | filters on the platform, writable, `project.category.createdBy` | The user that created the entity. |
| `project_category_generalCostsOrProfit` | `varchar2` | itgen_bouw7_project_category_generalcostsorprofit | [ ] | filters on the platform, writable, `project.category.generalCostsOrProfit` | The general costs or profit for the category. |
| `project_category_generalCostsPercentage` | `varchar2` | itgen_bouw7_project_category_generalcostspercentage | [ ] | filters on the platform, writable, `project.category.generalCostsPercentage` | The general costs percentage for the category. |
| `project_category_grossProfitMargin` | `varchar2` | itgen_bouw7_project_category_grossprofitmargin | [ ] | filters on the platform, writable, `project.category.grossProfitMargin` | The gross profit margin for the category. |
| `project_category_id` | `int64` | itgen_bouw7_project_category_id | [ ] | filters on the platform, writable, `project.category.id` | The ID of the category. |
| `project_category_name` | `varchar2` | itgen_bouw7_project_category_name | [ ] | filters on the platform, writable, `project.category.name` | The name of the category. |
| `project_category_updatedAt` | `datetime` | itgen_bouw7_project_category_updatedat | [ ] | filters on the platform, writable, `project.category.updatedAt` | The last updated time of the entity. |
| `project_category_updatedBy` | `varchar2` | itgen_bouw7_project_category_updatedby | [ ] | filters on the platform, writable, `project.category.updatedBy` | The user that last updated the entity. |
| `project_city` | `varchar2` | Project City | [ ] | filters on the platform, writable, `project.city` | The city of the project. |
| `project_contact_email` | `varchar2` | Project Contact Email | [ ] | filters on the platform, writable, `project.contact.email` | The email address. |
| `project_contact_id` | `int64` | Project Contact ID | [ ] | filters on the platform, writable, `project.contact.id` | ID of contact. |
| `project_contact_isVatShifted` | `char` | itgen_bouw7_project_contact_isvatshifted | [ ] | filters on the platform, writable, `project.contact.isVatShifted` | Whether VAT is shifted for the contact. |
| `project_contact_name` | `varchar2` | Project Contact Name | [ ] | filters on the platform, writable, `project.contact.name` | Name of contact. |
| `project_contact_phoneNumber` | `varchar2` | itgen_bouw7_project_contact_phonenumber | [ ] | filters on the platform, writable, `project.contact.phoneNumber` | The phone number of the contact. |
| `project_createdAt` | `datetime` | Project Created at | [ ] | filters on the platform, writable, `project.createdAt` | The creation time of the entity. |
| `project_createdBy` | `varchar2` | Project Created by | [ ] | filters on the platform, writable, `project.createdBy` | The user that created the entity. |
| `project_deliveryDate` | `datetime` | Project Delivery Date | [ ] | filters on the platform, writable, `project.deliveryDate` | Delivery date for the project. |
| `project_endDate` | `datetime` | Project End Date | [ ] | filters on the platform, writable, `project.endDate` | End date for the project. |
| `project_fullProjectNumber` | `varchar2` | Project Full Project Number | [ ] | filters on the platform, writable, `project.fullProjectNumber` | The full project number including year. |
| `project_houseNumber` | `varchar2` | Project House Number | [ ] | filters on the platform, writable, `project.houseNumber` | The house number for the project. |
| `project_id` | `int64` | Project ID | [ ] | filters on the platform, writable, `project.id` | The ID of the project. |
| `project_information` | `varchar2` | Project Information | [ ] | filters on the platform, writable, `project.information` | The information of the project. |
| `project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable, `project.name` | The name of the project. |
| `project_projectNumber` | `varchar2` | Project  Project Number | [ ] | filters on the platform, writable, `project.projectNumber` | The project number. |
| `project_reference` | `varchar2` | Project Reference | [ ] | filters on the platform, writable, `project.reference` | The reference of the project. |
| `project_startDate` | `datetime` | Project Start Date | [ ] | filters on the platform, writable, `project.startDate` | Start date for the project. |
| `project_status_closesProject` | `char` | Project Status Closes Project | [ ] | filters on the platform, writable, `project.status.closesProject` | Whether or not this status closes a project. |
| `project_status_createdAt` | `datetime` | Project Status Created at | [ ] | filters on the platform, writable, `project.status.createdAt` | The creation time of the entity. |
| `project_status_createdBy` | `varchar2` | Project Status Created by | [ ] | filters on the platform, writable, `project.status.createdBy` | The user that created the entity. |
| `project_status_id` | `int64` | Project Status ID | [ ] | filters on the platform, writable, `project.status.id` | The ID of the status. |
| `project_status_invoicesProject` | `char` | Project Status Invoices Project | [ ] | filters on the platform, writable, `project.status.invoicesProject` | Whether or not this status invoices a project. |
| `project_status_name` | `varchar2` | Project Status Name | [ ] | filters on the platform, writable, `project.status.name` | The name of the status. |
| `project_status_plansProject` | `char` | Project Status Plans Project | [ ] | filters on the platform, writable, `project.status.plansProject` | Whether or not this status plans a project. |
| `project_status_updatedAt` | `datetime` | Project Status Updated at | [ ] | filters on the platform, writable, `project.status.updatedAt` | The last updated time of the entity. |
| `project_status_updatedBy` | `varchar2` | Project Status Updated by | [ ] | filters on the platform, writable, `project.status.updatedBy` | The user that last updated the entity. |
| `project_streetName` | `varchar2` | Project Street Name | [ ] | filters on the platform, writable, `project.streetName` | The street name for the project. |
| `project_updatedAt` | `datetime` | Project Updated at | [ ] | filters on the platform, writable, `project.updatedAt` | The last updated time of the entity. |
| `project_updatedBy` | `varchar2` | Project Updated by | [ ] | filters on the platform, writable, `project.updatedBy` | The user that last updated the entity. |
| `project_zipCode` | `varchar2` | Project ZIP Code | [ ] | filters on the platform, writable, `project.zipCode` | The zip code for the project. |
| `quotationDate` | `datetime` | Quotation Date | [ ] | filters on the platform, writable, `quotationDate` | The date of this quotation. |
| `quotationNumber` | `varchar2` | Quotation Number | [ ] | filters on the platform, writable, `quotationNumber` | The number of the quotation. |
| `quotationStatus_id` | `int64` | Quotation Status ID | [ ] | filters on the platform, writable, `quotationStatus.id` | ID of the quotation status. |
| `quotationStatus_name` | `varchar2` | Quotation Status Name | [ ] | filters on the platform, writable, `quotationStatus.name` | The name of the quotation status. |
| `reference` | `varchar2(255)` | Reference | [ ] | filters on the platform, writable, `reference` | The reference of the quotation. |
| `salutation` | `int64` | Salutation | [ ] | filters on the platform, writable, `salutation` | The salutation of this quotation. |
| `salutationText` | `varchar2(255)` | Salutation Text | [ ] | filters on the platform, writable, `salutationText` | The salutation text of the quotation. |
| `showOverheadsOnPdf` | `char` | Show Overheads on PDF | [ ] | filters on the platform, writable, `showOverheadsOnPdf` | Whether the general costs and profit and risk should be shown on the quotation PDF. |
| `showPricePerLine` | `char` | Show Price per Line | [ ] | filters on the platform, writable, `showPricePerLine` | Whether the price is shown per line. |
| `showSubtotalPerChapter` | `char` | Show Subtotal per Chapter | [ ] | filters on the platform, writable, `showSubtotalPerChapter` | Whether the subtotal is shown per chapter. |
| `showTotalPrice` | `char` | Show Total Price | [ ] | filters on the platform, writable, `showTotalPrice` | Whether the total price is shown on this quotation. |
| `subject` | `varchar2(255)` | Subject | [ ] | filters on the platform, writable, `subject` | The subject of the quotation. |
| `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. |



## Release Notes

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

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

