# QuotationAttachments: Bouw7 Quotation Attachments - Catalog: `Bouw7` - Schema: `Views` - Label: Quotation Attachments 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 `QuotationAttachments` 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. | | `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. | | `closingChance` | `int64` | Closing Chance | ☐ | The closing chance of this quotation. | | `commissionPercentage` | `varchar2` | Commission Percentage | ☐ | The commision percentage of this quotation. | | `commonQuotationAttachmentId` | `int64` | Common Quotation Attachment ID | ☐ | The ID of the linked common quotation attachment. | | `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` | `datetime` | Created at | ☐ | The creation time of the entity. | | `createdBy` | `varchar2` | Created by | ☐ | The user that created the entity. | | `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. | | `expectedClosingDate` | `datetime` | Expected Closing Date | ☐ | The expected closing date of this quotation. | | `filename` | `varchar2` | File Name | ☐ | The name of the file for the CommonQuotationAttachment. | | `fileUri` | `varchar2` | File URI | ☐ | The uri of the file for QuotationAttachment | | `fileVisibility` | `int64` | File Visibility | ☐ | The file visibility constant of the quotation attachment. | | `footer` | `varchar2` | Footer | ☐ | The footer of the quotation. | | `id_2` | `int64` | ID | ☐ | The ID of the quotation. | | `id` | `int64` | ID | ☐ | The ID of QuotationAttachment. | | `information` | `varchar2` | Information | ☐ | The information of the quotation. | | `isCalculation` | `char` | Is Calculation | ☐ | Whether the quotation is a calculation. | | `labourDayPrice` | `varchar2` | Labour Day Price | ☐ | The labour day price of this quotation. | | `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. | | `name` | `varchar2` | Name | ☐ | The name of QuotationAttachment. | | `note` | `varchar2` | Note | ☐ | The note of this quotation. | | `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. | | `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. | | `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. | | `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. | | `subject` | `varchar2`(255) | Subject | ☐ | The subject of the quotation. | | `updatedAt` | `datetime` | Updated At | ☐ | The last updated time of the entity. | | `updatedBy` | `varchar2` | Updated by | ☐ | The user that last updated the entity. |