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

# QuotationChapterLines: Bouw7 Quotation Chapter Lines

`read only`

- Catalog: `Bouw7`
- Schema: `Views`
- Label: Quotation Chapter Lines

Can only retrieve data.

## 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.

## Table Columns

The columns of the table `QuotationChapterLines` 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 | The activities title of the quotation. |
| `additionalWork` | `char` | Additional Work | [ ] | writable | Whether the quotation line chapter has additional work. |
| `branch_code` | `varchar2` | Branch Code | [ ] | filters on the platform, writable | The code for this branch |
| `branch_division_description` | `varchar2` | itgen_bouw7_branch_division_description | [ ] | filters on the platform, writable | The description of the division. |
| `branch_division_exactDivisionId` | `varchar2` | itgen_bouw7_branch_division_exactdivisionid | [ ] | filters on the platform, writable | The division ID of an Exact Online environment. |
| `branch_division_glAccountCode` | `varchar2` | itgen_bouw7_branch_division_glaccountcode | [ ] | filters on the platform, writable | 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 | 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 | The ID of the division. |
| `branch_division_journalCode` | `varchar2` | itgen_bouw7_branch_division_journalcode | [ ] | filters on the platform, writable | A default journal code to use for sales related items. |
| `branch_division_journalCodePurchase` | `varchar2` | itgen_bouw7_branch_division_journalcodepurchase | [ ] | filters on the platform, writable | 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 | The prefix (3 digits) used to generate invoice number range per division. |
| `branch_id` | `int64` | Branch ID | [ ] | filters on the platform, writable | The ID of the branch. |
| `branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable | The name of this branch |
| `calculationLabourDayPrice` | `varchar2` | Calculation Labour Day Price | [ ] | filters on the platform, writable | The calculation labour day price of this quotation. |
| `calculationTotal` | `varchar2` | Calculation Total | [ ] | writable | The calculation total of the quotation line. |
| `closingChance` | `int64` | Closing Chance | [ ] | filters on the platform, writable | The closing chance of this quotation. |
| `commissionPercentage` | `varchar2` | Commission Percentage | [ ] | filters on the platform, writable | The commision percentage of this quotation. |
| `conditions` | `varchar2` | Conditions | [ ] | filters on the platform, writable | The conditions of this quotation. |
| `contactPersonText` | `varchar2(255)` | Contact Person Text | [ ] | filters on the platform, writable | The contact person text of the quotation. |
| `contactPerson_city` | `varchar2(255)` | Contact Person City | [ ] | filters on the platform, writable | The contact person's city. |
| `contactPerson_createdAt` | `datetime` | Contact Person Created at | [ ] | filters on the platform, writable | The creation time of the entity. |
| `contactPerson_createdBy` | `varchar2` | Contact Person Created by | [ ] | filters on the platform, writable | The user that created the entity. |
| `contactPerson_email` | `varchar2(256)` | Contact Person Email | [ ] | filters on the platform, writable | The contact person's email address. |
| `contactPerson_firstName` | `varchar2(256)` | Contact Person First Name | [ ] | filters on the platform, writable | The contact person's first name. |
| `contactPerson_houseNumber` | `varchar2(50)` | Contact Person House Number | [ ] | filters on the platform, writable | The contact person's house number. |
| `contactPerson_id` | `int64` | Contact Person ID | [ ] | filters on the platform, writable | The ID of contact person. |
| `contactPerson_jobTitle` | `varchar2(64)` | Contact Person Job Title | [ ] | filters on the platform, writable | The contact person's job title. |
| `contactPerson_lastName` | `varchar2(256)` | Contact Person Last Name | [ ] | filters on the platform, writable | The contact person's last name. |
| `contactPerson_phoneNumber` | `varchar2(255)` | Contact Person Phone Number | [ ] | filters on the platform, writable | The contact person's phone number. |
| `contactPerson_salutation` | `varchar2(32)` | Contact Person Salutation | [ ] | filters on the platform, writable | The contact person's salutation. |
| `contactPerson_streetName` | `varchar2(255)` | Contact Person Street Name | [ ] | filters on the platform, writable | The contact person's street name. |
| `contactPerson_updatedAt` | `datetime` | Contact Person Updated at | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `contactPerson_updatedBy` | `varchar2` | Contact Person Updated by | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `contactPerson_zipCode` | `varchar2(20)` | Contact Person ZIP Code | [ ] | filters on the platform, writable | The contact person's zip code. |
| `contact_contactType_id` | `int64` | Contact Contact Type ID | [ ] | filters on the platform, writable | The ID of contact type. |
| `contact_contactType_name` | `varchar2` | Contact Contact Type Name | [ ] | filters on the platform, writable | The name of contact type. |
| `contact_email` | `varchar2` | Contact Email | [ ] | filters on the platform, writable | The email address. |
| `contact_id` | `int64` | Contact ID | [ ] | filters on the platform, writable | ID of contact. |
| `contact_isVatShifted` | `char` | Contact Is VAT Shifted | [ ] | filters on the platform, writable | Whether VAT is shifted for the contact. |
| `contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable | Name of contact. |
| `contact_phoneNumber` | `varchar2` | Contact Phone Number | [ ] | filters on the platform, writable | The phone number of the contact. |
| `createdAt` | `datetime` | Created at | [ ] | writable | The creation time of the entity. |
| `createdAt_2` | `datetime` | Created at | [ ] | writable | The creation time of the entity. |
| `createdAt_3` | `datetime` | itgen_bouw7_createdat_3 | [ ] | filters on the platform, writable | The creation time of the entity. |
| `createdBy` | `varchar2` | Created by | [ ] | writable | The user that created the entity. |
| `createdBy_2` | `varchar2` | Created by | [ ] | writable | The user that created the entity. |
| `createdBy_3` | `varchar2` | itgen_bouw7_createdby_3 | [ ] | filters on the platform, writable | The user that created the entity. |
| `description` | `varchar2(255)` | Description | [ ] | writable | The description of the quotation line. |
| `descriptionLong` | `varchar2` | Description Long | [ ] | writable | The long description of the quotation line. |
| `disableQuotationLines` | `char` | Disable Quotation Lines | [ ] | filters on the platform, writable | Whether the quotation lines are disabled. |
| `discount` | `int64` | Discount | [ ] | filters on the platform, writable | The discount of this quotation. |
| `employee_firstName` | `varchar2` | Employee First Name | [ ] | filters on the platform, writable | First name of the employee. |
| `employee_id` | `int64` | Employee ID | [ ] | filters on the platform, writable | ID of the employee. |
| `employee_lastName` | `varchar2` | Employee Last Name | [ ] | filters on the platform, writable | Last name of the employee. |
| `equipmentTotal` | `varchar2` | Equipment Total | [ ] | writable | The equipment total of the quotation line. |
| `expectedClosingDate` | `datetime` | Expected Closing Date | [ ] | filters on the platform, writable | The expected closing date of this quotation. |
| `footer` | `varchar2` | Footer | [ ] | filters on the platform, writable | The footer of the quotation. |
| `garbageTotal` | `varchar2` | Garbage Total | [ ] | writable | The waste total of the quotation line. |
| `hasPrice` | `char` | Has Price | [ ] | writable | Whether the quotation line chapter has a price. |
| `id` | `int64` | ID | [ ] | writable | ID of the quotation line. |
| `id_2` | `int64` | ID | [ ] | writable | ID of the quotation line chapter. |
| `id_3` | `int64` | itgen_bouw7_id_3 | [ ] | filters on the platform, writable | The ID of the quotation. |
| `information` | `varchar2` | Information | [ ] | filters on the platform, writable | The information of the quotation. |
| `isCalculation` | `char` | Is Calculation | [ ] | filters on the platform, writable | Whether the quotation is a calculation. |
| `laborQuantity` | `varchar2` | Labor Quantity | [ ] | writable | The labour quantity of the quotation line. |
| `laborTotal` | `varchar2` | Labor Total | [ ] | writable | The labour total of the quotation line. |
| `labourDayPrice` | `varchar2` | Labour Day Price | [ ] | filters on the platform, writable | The labour day price of this quotation. |
| `labourDays` | `varchar2` | Labour Days | [ ] | writable | The labour days of the quotation line. |
| `language` | `varchar2` | Language | [ ] | filters on the platform, writable | The locale used by this quotation, e.g.: nl-NL. |
| `layout` | `varchar2` | Layout | [ ] | filters on the platform, writable | The layout of the quotation. |
| `mailSentAt` | `varchar2` | Mail Sent at | [ ] | filters on the platform, writable | The date when the mail was sent. |
| `materialDescription` | `varchar2` | Material Description | [ ] | writable | The material description of the quotation line. |
| `materialQuantity` | `varchar2` | Material Quantity | [ ] | writable | The material quantity of the quotation line. |
| `materialTotal` | `varchar2` | Material Total | [ ] | writable | The material total of the quotation line. |
| `materialUnitPrice` | `varchar2` | Material Unit Price | [ ] | writable | The material per unit price of the quotation line. |
| `name` | `varchar2` | Name | [ ] | writable | The name of this quotation line chapter. |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable | The note of this quotation. |
| `option` | `char` | Option | [ ] | writable | Whether the quotation line has an option. |
| `overheads` | `varchar2` | Overheads | [ ] | filters on the platform, writable | The general costs of this quotation. |
| `overheadsVatTariff_effectiveFrom` | `varchar2` | itgen_bouw7_overheadsvattariff_effectivefrom | [ ] | filters on the platform, writable | The datetime in ATOM format since this VAT tariff is effective. |
| `overheadsVatTariff_id` | `int64` | Overheads VAT Tariff ID | [ ] | filters on the platform, writable | ID of the vat tariff. |
| `overheadsVatTariff_label` | `varchar2` | Overheads VAT tariff Label | [ ] | filters on the platform, writable | Display label of the VAT tariff. |
| `overheadsVatTariff_percentage` | `varchar2` | Overheads VAT Tariff Percentage | [ ] | filters on the platform, writable | The VAT percentage. |
| `price` | `varchar2` | Price | [ ] | writable | The price of this quotation line. |
| `profitAndRisk` | `varchar2` | Profit and Risk | [ ] | filters on the platform, writable | The profit and risk costs of this quotation. |
| `profitAndRiskVatTariff_effectiveFrom` | `varchar2` | itgen_bouw7_profitandriskvattariff_effectivefrom | [ ] | filters on the platform, writable | 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 | ID of the vat tariff. |
| `profitAndRiskVatTariff_label` | `varchar2` | Profit and Risk VAT Tariff Label | [ ] | filters on the platform, writable | Display label of the VAT tariff. |
| `profitAndRiskVatTariff_percentage` | `varchar2` | Profit and Risk VAT Tariff Percentage | [ ] | filters on the platform, writable | The VAT percentage. |
| `project_branch_code` | `varchar2` | itgen_bouw7_project_branch_code | [ ] | filters on the platform, writable | The code for this branch |
| `project_branch_id` | `int64` | itgen_bouw7_project_branch_id | [ ] | filters on the platform, writable | The ID of the branch. |
| `project_branch_name` | `varchar2` | itgen_bouw7_project_branch_name | [ ] | filters on the platform, writable | The name of this branch |
| `project_category_code` | `varchar2` | itgen_bouw7_project_category_code | [ ] | filters on the platform, writable | The code for the category. |
| `project_category_createdAt` | `datetime` | itgen_bouw7_project_category_createdat | [ ] | filters on the platform, writable | The creation time of the entity. |
| `project_category_createdBy` | `varchar2` | itgen_bouw7_project_category_createdby | [ ] | filters on the platform, writable | The user that created the entity. |
| `project_category_generalCostsOrProfit` | `varchar2` | itgen_bouw7_project_category_generalcostsorprofit | [ ] | filters on the platform, writable | The general costs or profit for the category. |
| `project_category_generalCostsPercentage` | `varchar2` | itgen_bouw7_project_category_generalcostspercentage | [ ] | filters on the platform, writable | The general costs percentage for the category. |
| `project_category_grossProfitMargin` | `varchar2` | itgen_bouw7_project_category_grossprofitmargin | [ ] | filters on the platform, writable | The gross profit margin for the category. |
| `project_category_id` | `int64` | itgen_bouw7_project_category_id | [ ] | filters on the platform, writable | The ID of the category. |
| `project_category_name` | `varchar2` | itgen_bouw7_project_category_name | [ ] | filters on the platform, writable | The name of the category. |
| `project_category_updatedAt` | `datetime` | itgen_bouw7_project_category_updatedat | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `project_category_updatedBy` | `varchar2` | itgen_bouw7_project_category_updatedby | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `project_city` | `varchar2` | Project City | [ ] | filters on the platform, writable | The city of the project. |
| `project_contact_email` | `varchar2` | Project Contact Email | [ ] | filters on the platform, writable | The email address. |
| `project_contact_id` | `int64` | Project Contact ID | [ ] | filters on the platform, writable | ID of contact. |
| `project_contact_isVatShifted` | `char` | itgen_bouw7_project_contact_isvatshifted | [ ] | filters on the platform, writable | Whether VAT is shifted for the contact. |
| `project_contact_name` | `varchar2` | Project Contact Name | [ ] | filters on the platform, writable | Name of contact. |
| `project_contact_phoneNumber` | `varchar2` | itgen_bouw7_project_contact_phonenumber | [ ] | filters on the platform, writable | The phone number of the contact. |
| `project_createdAt` | `datetime` | Project Created at | [ ] | filters on the platform, writable | The creation time of the entity. |
| `project_createdBy` | `varchar2` | Project Created by | [ ] | filters on the platform, writable | The user that created the entity. |
| `project_deliveryDate` | `datetime` | Project Delivery Date | [ ] | filters on the platform, writable | Delivery date for the project. |
| `project_endDate` | `datetime` | Project End Date | [ ] | filters on the platform, writable | End date for the project. |
| `project_fullProjectNumber` | `varchar2` | Project Full Project Number | [ ] | filters on the platform, writable | The full project number including year. |
| `project_houseNumber` | `varchar2` | Project House Number | [ ] | filters on the platform, writable | The house number for the project. |
| `project_id` | `int64` | Project ID | [ ] | filters on the platform, writable | The ID of the project. |
| `project_information` | `varchar2` | Project Information | [ ] | filters on the platform, writable | The information of the project. |
| `project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable | The name of the project. |
| `project_projectNumber` | `varchar2` | Project  Project Number | [ ] | filters on the platform, writable | The project number. |
| `project_reference` | `varchar2` | Project Reference | [ ] | filters on the platform, writable | The reference of the project. |
| `project_startDate` | `datetime` | Project Start Date | [ ] | filters on the platform, writable | Start date for the project. |
| `project_status_closesProject` | `char` | Project Status Closes Project | [ ] | filters on the platform, writable | Whether or not this status closes a project. |
| `project_status_createdAt` | `datetime` | Project Status Created at | [ ] | filters on the platform, writable | The creation time of the entity. |
| `project_status_createdBy` | `varchar2` | Project Status Created by | [ ] | filters on the platform, writable | The user that created the entity. |
| `project_status_id` | `int64` | Project Status ID | [ ] | filters on the platform, writable | The ID of the status. |
| `project_status_invoicesProject` | `char` | Project Status Invoices Project | [ ] | filters on the platform, writable | Whether or not this status invoices a project. |
| `project_status_name` | `varchar2` | Project Status Name | [ ] | filters on the platform, writable | The name of the status. |
| `project_status_plansProject` | `char` | Project Status Plans Project | [ ] | filters on the platform, writable | Whether or not this status plans a project. |
| `project_status_updatedAt` | `datetime` | Project Status Updated at | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `project_status_updatedBy` | `varchar2` | Project Status Updated by | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `project_streetName` | `varchar2` | Project Street Name | [ ] | filters on the platform, writable | The street name for the project. |
| `project_updatedAt` | `datetime` | Project Updated at | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `project_updatedBy` | `varchar2` | Project Updated by | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `project_zipCode` | `varchar2` | Project ZIP Code | [ ] | filters on the platform, writable | The zip code for the project. |
| `purchaseOrderTotal` | `varchar2` | Purchase Order Total | [ ] | writable | The purchase order total of the quotation line. |
| `quantity` | `varchar2` | Quantity | [ ] | writable | The quantity of this quotation line. |
| `quotationDate` | `datetime` | Quotation Date | [ ] | filters on the platform, writable | The date of this quotation. |
| `quotationNumber` | `varchar2` | Quotation Number | [ ] | filters on the platform, writable | The number of the quotation. |
| `quotationStatus_id` | `int64` | Quotation Status ID | [ ] | filters on the platform, writable | ID of the quotation status. |
| `quotationStatus_name` | `varchar2` | Quotation Status Name | [ ] | filters on the platform, writable | The name of the quotation status. |
| `quotation_branch_id` | `int64` | Branch ID | [ ] | filters on the platform, writable | The ID of the branch. |
| `quotation_branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable | The name of the branch. |
| `quotation_closingChance` | `int64` | Closing Chance | [ ] | filters on the platform, writable | The closing chance of this quotation. |
| `quotation_commissionPercentage` | `varchar2` | Commission Percentage | [ ] | filters on the platform, writable | The commission percentage of this quotation. |
| `quotation_contactPersonText` | `varchar2(255)` | Contact Person Text | [ ] | filters on the platform, writable | The contact person text of the quotation. |
| `quotation_contactPerson_emailAddress` | `varchar2` | Contact Person Email Address | [ ] | filters on the platform, writable | The email address of the contact person. |
| `quotation_contactPerson_firstName` | `varchar2` | Contact Person First Name | [ ] | filters on the platform, writable | The first name of this contact person. |
| `quotation_contactPerson_id` | `int64` | Contact Person ID | [ ] | filters on the platform, writable | The ID of the contact person. |
| `quotation_contactPerson_lastName` | `varchar2(256)` | Contact Person Last Name | [ ] | filters on the platform, writable | The surname of the contact person. |
| `quotation_contactPerson_phoneNumber` | `varchar2(255)` | Contact Person Phone Number | [ ] | filters on the platform, writable | The phone number of the contact person. |
| `quotation_contact_emailAddress` | `varchar2` | Contact Email Address | [ ] | filters on the platform, writable | The email address of the contact. |
| `quotation_contact_id` | `int64` | Contact ID | [ ] | filters on the platform, writable | The ID of the contact. |
| `quotation_contact_name` | `varchar2` | Contact Name | [ ] | filters on the platform, writable | The name of this contact. |
| `quotation_contact_type` | `varchar2` | Contact Type | [ ] | filters on the platform, writable | The type of this contact. |
| `quotation_contact_typeId` | `int64` | Contact Type ID | [ ] | filters on the platform, writable | The type ID of this contact. |
| `quotation_createdAt` | `datetime` | Created at | [ ] | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format |
| `quotation_createdBy_id` | `int64` | Created by ID | [ ] | filters on the platform, writable | The ID of the user. |
| `quotation_createdBy_username` | `varchar2` | Created by User Name | [ ] | filters on the platform, writable | The username of the user. |
| `quotation_employee_departmentId` | `int64` | Employee Department ID | [ ] | filters on the platform, writable | The ID of the department this employee is enrolled in. |
| `quotation_employee_exactSalaryFrequency` | `int64` | Employee Exact Salary Frequency | [ ] | filters on the platform, writable | The exact salary frequency of this employee. |
| `quotation_employee_firstName` | `varchar2` | Employee First Name | [ ] | filters on the platform, writable | The given name of this employee. |
| `quotation_employee_id` | `int64` | Employee ID | [ ] | filters on the platform, writable | The ID of the employee. |
| `quotation_employee_lastName` | `varchar2` | Employee Last Name | [ ] | filters on the platform, writable | The family name of this employee. |
| `quotation_expectedClosingDate` | `datetime` | Expected Closing Date | [ ] | filters on the platform, writable | The expected closing date of this quotation, represented in ATOM-format. |
| `quotation_id` | `int64` | ID | [ ] | filters on the platform, writable | The ID of the quotation. |
| `quotation_internalNote` | `varchar2` | Internal Note | [ ] | filters on the platform, writable | The internal note for this quotation. |
| `quotation_language` | `varchar2` | Language | [ ] | filters on the platform, writable | The locale used by this quotation, e.g.: nl-NL. |
| `quotation_project_branchId` | `int64` | Project Branch ID | [ ] | filters on the platform, writable | The ID of the branch of this project. |
| `quotation_project_categoryId` | `int64` | Project Category ID | [ ] | filters on the platform, writable | The ID of the category of this project. |
| `quotation_project_divisionId` | `int64` | Project Division ID | [ ] | filters on the platform, writable | The ID of the division of this project. |
| `quotation_project_id` | `int64` | Project ID | [ ] | filters on the platform, writable | The ID of the project. |
| `quotation_project_name` | `varchar2` | Project Name | [ ] | filters on the platform, writable | The name of the project. |
| `quotation_project_number` | `varchar2` | Project Number | [ ] | filters on the platform, writable | The number of the project. |
| `quotation_project_status` | `varchar2` | Project Status | [ ] | filters on the platform, writable | The name of the current status of this project. |
| `quotation_project_statusId` | `int64` | Project Status ID | [ ] | filters on the platform, writable | The ID of the status of this project. |
| `quotation_quotationDate` | `datetime` | Quotation Date | [ ] | filters on the platform, writable | The date of the quotation, represented in ATOM-format. |
| `quotation_quotationNumber` | `varchar2` | Quotation Number | [ ] | filters on the platform, writable | The number of the quotation. |
| `quotation_quotationStatus_id` | `int64` | Quotation Status ID | [ ] | filters on the platform, writable | The ID of the quotation status. |
| `quotation_quotationStatus_name` | `varchar2` | Quotation Status Name | [ ] | filters on the platform, writable | The name of the quotation status. |
| `quotation_reference` | `varchar2` | Reference | [ ] | filters on the platform, writable | The reference of the quotation. |
| `quotation_salutation` | `int64` | Salutation | [ ] | filters on the platform, writable | The salutation of this quotation. |
| `quotation_salutationText` | `varchar2(255)` | Salutation Text | [ ] | filters on the platform, writable | The salutation text of the quotation. |
| `quotation_subject` | `varchar2` | Subject | [ ] | filters on the platform, writable | The subject of the quotation. |
| `quotation_subtotal` | `varchar2` | This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | [ ] | filters on the platform, writable | The sum of all quotation line subtotals, excluding VAT. |
| `quotation_total` | `varchar2` | This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | [ ] | filters on the platform, writable | The sum of all quotation line subtotals, including VAT. |
| `quotation_updatedAt` | `datetime` | Updated At | [ ] | filters on the platform, writable | The creation date of the object in ATOM/ISO-8601 format |
| `quotation_updatedBy_id` | `int64` | Updated by ID | [ ] | filters on the platform, writable | The ID of the user. |
| `quotation_updatedBy_username` | `varchar2` | Updated by User Name | [ ] | filters on the platform, writable | The username of the user. |
| `reference` | `varchar2(255)` | Reference | [ ] | filters on the platform, writable | The reference of the quotation. |
| `salutation` | `int64` | Salutation | [ ] | filters on the platform, writable | The salutation of this quotation. |
| `salutationText` | `varchar2(255)` | Salutation Text | [ ] | filters on the platform, writable | The salutation text of the quotation. |
| `shouldAddPageBreak` | `char` | Should add Page Break | [ ] | writable | Whether the quotation line should add a page break to the PDF. |
| `showOverheadsOnPdf` | `char` | Show Overheads on PDF | [ ] | filters on the platform, writable | 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 | Whether the price is shown per line. |
| `showSubtotalPerChapter` | `char` | Show Subtotal per Chapter | [ ] | filters on the platform, writable | Whether the subtotal is shown per chapter. |
| `showTotalPrice` | `char` | Show Total Price | [ ] | filters on the platform, writable | Whether the total price is shown on this quotation. |
| `sortIndex` | `int64` | Sort Index | [ ] | writable | The sort index of the quotation line. |
| `sortIndex_2` | `int64` | itgen_bouw7_sortindex_2 | [ ] | writable | The sort index of this quotation line chapter. |
| `subcontractingTotal` | `varchar2` | Sub Contracting Total | [ ] | writable | The subcontracting total of the quotation line. |
| `subject` | `varchar2(255)` | Subject | [ ] | filters on the platform, writable | The subject of the quotation. |
| `subtotal` | `varchar2` | Subtotal | [ ] | writable | The price of this quotation line. |
| `unit` | `varchar2` | Unit | [ ] | writable | The unit of the quotation line. |
| `updatedAt` | `datetime` | Updated At | [ ] | writable | The last updated time of the entity. |
| `updatedAt_2` | `datetime` | Updated at | [ ] | writable | The last updated time of the entity. |
| `updatedAt_3` | `datetime` | itgen_bouw7_updatedat_3 | [ ] | filters on the platform, writable | The last updated time of the entity. |
| `updatedBy` | `varchar2` | Updated by | [ ] | writable | The user that last updated the entity. |
| `updatedBy_2` | `varchar2` | Updated by | [ ] | writable | The user that last updated the entity. |
| `updatedBy_3` | `varchar2` | itgen_bouw7_updatedby_3 | [ ] | filters on the platform, writable | The user that last updated the entity. |
| `vatTariffPercentage` | `varchar2` | VAT Tariff Percentage | [ ] | writable | The vat tariff of this quotation line. |



## Release Notes

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

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

