invantive documentation
Invantive Support ForumsLog In / Sign Up

QuotationSentEmails: Bouw7 Quotation Sent Emails

read only

  • Catalog: Bouw7
  • Schema: Views
  • Label: Quotation Sent Emails

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 QuotationSentEmails 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.
bccRecipients varchar2 BCC Recipients writable The bcc recipient(s) of the mail, comma separated.
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.
ccRecipients varchar2 CC Recipients writable The cc recipient(s) of the mail, comma separated.
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 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 filters on the platform, writable The user that created the entity.
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.
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.
id int64 ID 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.
labourDayPrice varchar2 Labour Day Price filters on the platform, writable The labour day price of this quotation.
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.
mailDate datetime Mail Date writable The mail date of the mail.
mailSentAt varchar2 Mail Sent at filters on the platform, writable The date when the mail was sent.
mailType int64 Mail Type writable The mail type.
note varchar2 Note filters on the platform, writable The note of this quotation.
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.
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.
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.
recipient varchar2 Recipient writable The recipient of the mail.
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.
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.
subject varchar2(255) Subject filters on the platform, writable The subject of the quotation.
updatedAt datetime Updated At writable The last updated time of the entity.
updatedAt_2 datetime Updated at 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 filters on the platform, writable The user that last updated the entity.

Release Notes

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