# QuotationCommonAttachmentsV2ByProjectId Returns the document with the project information filled in for a new quotation. Returns the document with the project information filled in for a new quotation. - Catalog: `Bouw7` - Schema: `Quotation` This is a read-only table function. 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. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `QuotationCommonAttachmentsV2ByProjectId`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `project` | `` | ☑ | | Project ID | ## Columns of Table Function The columns of the table function `QuotationCommonAttachmentsV2ByProjectId` 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. | | `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 common quotation attachment. | | `fileUri` | `varchar2` | File URI | ☐ | The uri of the file for the common 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 the common quotation attachment. | | `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`(256) | Name | ☐ | The name of the common quotation attachment. | | `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. | | `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. |