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

# QuotationCommonAttachmentsByQuotationId: Bouw7 Quotation Common Attachments by Quotation ID

`read only` `REST`

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

