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