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

# Quotations: Bouw7 Quotations

`popular` `read only` `REST`

- Catalog: `Bouw7`
- Schema: `Quotation`
- Label: Quotations

Returns a list of quotations associated with your organization.
Returns a list of quotations associated with your organization.

Can only retrieve data.

## Summary

Returns a list of quotations associated with your organization.

## API Source

- Endpoint: `/list/quotations`
- Operation: `get /list/quotations`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 66 |
| Full scan rows per minute | 215,000 |
| Point query rows per minute | 666 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `q` | `` | [ ] |  | A [Heimdall Query Language](https://heimdall.bouw7.nl/docs/query-language) string |

## Table Columns

The columns of the table `Quotations` 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 |
|---|---|---|:---:|---|---|
| `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 the branch. |
| `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 commission percentage of this quotation. |
| `contactPersonText` | `varchar2(255)` | Contact Person Text | [ ] | filters on the platform, writable, `contactPersonText` | The contact person text of the quotation. |
| `contactPerson_emailAddress` | `varchar2` | Contact Person Email Address | [ ] | filters on the platform, writable, `contactPerson.emailAddress` | The email address of the contact person. |
| `contactPerson_firstName` | `varchar2` | Contact Person First Name | [ ] | filters on the platform, writable, `contactPerson.firstName` | The first name of this contact person. |
| `contactPerson_id` | `int64` | Contact Person ID | [ ] | filters on the platform, writable, `contactPerson.id` | The ID of the contact person. |
| `contactPerson_lastName` | `varchar2(256)` | Contact Person Last Name | [ ] | filters on the platform, writable, `contactPerson.lastName` | The surname of the contact person. |
| `contactPerson_phoneNumber` | `varchar2(255)` | Contact Person Phone Number | [ ] | filters on the platform, writable, `contactPerson.phoneNumber` | The phone number of the contact person. |
| `contact_emailAddress` | `varchar2` | Contact Email Address | [ ] | filters on the platform, writable, `contact.emailAddress` | The email address of the contact. |
| `contact_id` | `int64` | Contact ID | [ ] | filters on the platform, writable, `contact.id` | The ID of the contact. |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable, `contact.name` | The name of this contact. |
| `contact_type` | `varchar2` | Contact Type | [ ] | filters on the platform, writable, `contact.type` | The type of this contact. |
| `contact_typeId` | `int64` | Contact Type ID | [ ] | filters on the platform, writable, `contact.typeId` | The type ID of this contact. |
| `createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable, `createdAt` | The creation date of the object in ATOM/ISO-8601 format |
| `createdBy_id` | `int64` | Created by ID | [ ] | filters on the platform, writable, `createdBy.id` | The ID of the user. |
| `createdBy_username` | `varchar2` | Created by User Name | [ ] | filters on the platform, writable, `createdBy.username` | The username of the user. |
| `employee_departmentId` | `int64` | Employee Department ID | [ ] | filters on the platform, writable, `employee.departmentId` | The ID of the department this employee is enrolled in. |
| `employee_exactSalaryFrequency` | `int64` | Employee Exact Salary Frequency | [ ] | filters on the platform, writable, `employee.exactSalaryFrequency` | The exact salary frequency of this employee. |
| `employee_firstName` | `varchar2` | Employee First Name | [ ] | filters on the platform, writable, `employee.firstName` | The given name of this employee. |
| `employee_id` | `int64` | Employee ID | [ ] | filters on the platform, writable, `employee.id` | The ID of the employee. |
| `employee_lastName` | `varchar2` | Employee Last Name | [ ] | filters on the platform, writable, `employee.lastName` | The family name of this employee. |
| `expectedClosingDate` | `datetime` | Expected Closing Date | [ ] | filters on the platform, writable, `expectedClosingDate` | The expected closing date of this quotation, represented in ATOM-format. |
| `id` | `int64` | ID | [ ] | filters on the platform, writable, `id` | The ID of the quotation. |
| `internalNote` | `varchar2` | Internal Note | [ ] | filters on the platform, writable, `internalNote` | The internal note for this quotation. |
| `language` | `varchar2` | Language | [ ] | filters on the platform, writable, `language` | The locale used by this quotation, e.g.: nl-NL. |
| `project_branchId` | `int64` | Project Branch ID | [ ] | filters on the platform, writable, `project.branchId` | The ID of the branch of this project. |
| `project_categoryId` | `int64` | Project Category ID | [ ] | filters on the platform, writable, `project.categoryId` | The ID of the category of this project. |
| `project_divisionId` | `int64` | Project Division ID | [ ] | filters on the platform, writable, `project.divisionId` | The ID of the division of this project. |
| `project_id` | `int64` | Project ID | [ ] | filters on the platform, writable, `project.id` | The ID of the project. |
| `project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable, `project.name` | The name of the project. |
| `project_number` | `varchar2` | Project Number | [ ] | filters on the platform, writable, `project.number` | The number of the project. |
| `project_status` | `varchar2` | Project Status | [ ] | filters on the platform, writable, `project.status` | The name of the current status of this project. |
| `project_statusId` | `int64` | Project Status ID | [ ] | filters on the platform, writable, `project.statusId` | The ID of the status of this project. |
| `quotationDate` | `datetime` | Quotation Date | [ ] | filters on the platform, writable, `quotationDate` | The date of the quotation, represented in ATOM-format. |
| `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` | The 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` | 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. |
| `subject` | `varchar2` | Subject | [ ] | filters on the platform, writable, `subject` | The subject of the quotation. |
| `subtotal` | `varchar2` | This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | [ ] | filters on the platform, writable, `subtotal` | The sum of all quotation line subtotals, excluding VAT. |
| `total` | `varchar2` | This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | [ ] | filters on the platform, writable, `total` | The sum of all quotation line subtotals, including VAT. |
| `updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable, `updatedAt` | The creation date of the object in ATOM/ISO-8601 format |
| `updatedBy_id` | `int64` | Updated by ID | [ ] | filters on the platform, writable, `updatedBy.id` | The ID of the user. |
| `updatedBy_username` | `varchar2` | Updated by User Name | [ ] | filters on the platform, writable, `updatedBy.username` | The username of the user. |



## Release Notes

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

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

