QuotationSentEmails: Bouw7 Offerte Verzonden E-mails |
Catalogus: Bouw7
Schema: Views
Label: Offerte Verzonden E-mails
Dit is een alleen-lezen view. De Bouw7 API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Bouw7 ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Bouw7-API.
View Kolommen
De kolommen van de view QuotationSentEmails worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
activitiesTitle |
string(255) |
Activiteitentitel |
☐ |
The activities title of the quotation. |
bccRecipients |
string |
BCC-ontvangers |
☐ |
The bcc recipient(s) of the mail, comma separated. |
branch_code |
string |
Vestigingscode |
☐ |
The code for this branch |
branch_division_description |
string |
{res:itgen_bouw7_branch_division_description} |
☐ |
The description of the division. |
branch_division_exactDivisionId |
string |
{res:itgen_bouw7_branch_division_exactdivisionid} |
☐ |
The division ID of an Exact Online environment. |
branch_division_glAccountCode |
string |
{res:itgen_bouw7_branch_division_glaccountcode} |
☐ |
A default general ledger account code to use for sales related items. |
branch_division_glAccountCodePurchase |
string |
{res:itgen_bouw7_branch_division_glaccountcodepurchase} |
☐ |
A default general ledger account code to use for purchase related items. |
branch_division_id |
int64 |
{res:itgen_bouw7_branch_division_id} |
☐ |
The ID of the division. |
branch_division_journalCode |
string |
{res:itgen_bouw7_branch_division_journalcode} |
☐ |
A default journal code to use for sales related items. |
branch_division_journalCodePurchase |
string |
{res:itgen_bouw7_branch_division_journalcodepurchase} |
☐ |
A default journal code to use for purchase related items. |
branch_division_salesInvoiceNumberPrefix |
string(3) |
{res:itgen_bouw7_branch_division_salesinvoicenumberprefix} |
☐ |
The prefix (3 digits) used to generate invoice number range per division. |
branch_id |
int64 |
Vestiging-ID |
☐ |
The ID of the branch. |
branch_name |
string |
Filiaalnaam |
☐ |
The name of this branch |
calculationLabourDayPrice |
string |
Berekening Arbeidsdagprijs |
☐ |
The calculation labour day price of this quotation. |
ccRecipients |
string |
CC-ontvangers |
☐ |
The cc recipient(s) of the mail, comma separated. |
closingChance |
int64 |
Sluitingskans |
☐ |
The closing chance of this quotation. |
commissionPercentage |
string |
Commissie Percentage |
☐ |
The commision percentage of this quotation. |
conditions |
string |
Voorwaarden |
☐ |
The conditions of this quotation. |
contact_contactType_id |
int64 |
Contact Soort ID |
☐ |
The ID of contact type. |
contact_contactType_name |
string |
Contact Soort Naam |
☐ |
The name of contact type. |
contact_email |
string |
Contact E-mail |
☐ |
The email address. |
contact_id |
int64 |
Contactpersoon ID |
☐ |
ID of contact. |
contact_isVatShifted |
boolean |
Contact is BTW Verlegd |
☐ |
Whether VAT is shifted for the contact. |
contact_name |
string |
Contactpersoon Naam |
☐ |
Name of contact. |
contact_phoneNumber |
string |
Contact Telefoonnummer |
☐ |
The phone number of the contact. |
contactPerson_city |
string(255) |
Contactpersoon Stad |
☐ |
The contact person's city. |
contactPerson_createdAt |
datetime |
Contactpersoon Aangemaakt op |
☐ |
The creation time of the entity. |
contactPerson_createdBy |
string |
Contactpersoon Aangemaakt door |
☐ |
The user that created the entity. |
contactPerson_email |
string(256) |
Contactpersoon E-mail |
☐ |
The contact person's email address. |
contactPerson_firstName |
string(256) |
Contactpersoon Voornaam |
☐ |
The contact person's first name. |
contactPerson_houseNumber |
string(50) |
Contactpersoon Huisnummer |
☐ |
The contact person's house number. |
contactPerson_id |
int64 |
Contactpersoon ID |
☐ |
The ID of contact person. |
contactPerson_jobTitle |
string(64) |
Contactpersoon Functietitel |
☐ |
The contact person's job title. |
contactPerson_lastName |
string(256) |
Contactpersoon Achternaam |
☐ |
The contact person's last name. |
contactPerson_phoneNumber |
string(255) |
Contactpersoon Telefoonnummer |
☐ |
The contact person's phone number. |
contactPerson_salutation |
string(32) |
Contactpersoon Aanhef |
☐ |
The contact person's salutation. |
contactPerson_streetName |
string(255) |
Contactpersoon Straatnaam |
☐ |
The contact person's street name. |
contactPerson_updatedAt |
datetime |
Contactpersoon Bijgewerkt op |
☐ |
The last updated time of the entity. |
contactPerson_updatedBy |
string |
Contactpersoon Bijgewerkt door |
☐ |
The user that last updated the entity. |
contactPerson_zipCode |
string(20) |
Contactpersoon Postcode |
☐ |
The contact person's zip code. |
contactPersonText |
string(255) |
Contactpersoon Tekst |
☐ |
The contact person text of the quotation. |
createdAt_2 |
datetime |
Aangemaakt op |
☐ |
The creation time of the entity. |
createdAt |
datetime |
Aangemaakt op |
☐ |
The creation time of the entity. |
createdBy_2 |
string |
Gemaakt door |
☐ |
The user that created the entity. |
createdBy |
string |
Gemaakt door |
☐ |
The user that created the entity. |
disableQuotationLines |
boolean |
Offerteregels Uitschakelen |
☐ |
Whether the quotation lines are disabled. |
discount |
int64 |
Korting |
☐ |
The discount of this quotation. |
employee_firstName |
string |
Medewerker Voornaam |
☐ |
First name of the employee. |
employee_id |
int64 |
Werknemer ID |
☐ |
ID of the employee. |
employee_lastName |
string |
Medewerker Achternaam |
☐ |
Last name of the employee. |
expectedClosingDate |
datetime |
Verwachte sluitingsdatum |
☐ |
The expected closing date of this quotation. |
footer |
string |
Voettekst |
☐ |
The footer of the quotation. |
id |
int64 |
ID |
☐ |
The ID of the quotation. |
information |
string |
Informatie |
☐ |
The information of the quotation. |
isCalculation |
boolean |
Is Berekening |
☐ |
Whether the quotation is a calculation. |
labourDayPrice |
string |
Arbeidsdag Prijs |
☐ |
The labour day price of this quotation. |
language |
string |
Taal |
☐ |
The locale used by this quotation, e.g.: nl-NL. |
layout |
string |
Lay-out |
☐ |
The layout of the quotation. |
mailDate |
datetime |
Maildatum |
☐ |
The mail date of the mail. |
mailSentAt |
string |
Mail Verstuurd op |
☐ |
The date when the mail was sent. |
mailType |
int64 |
Mailsoort |
☐ |
The mail type. |
note |
string |
Notitie |
☐ |
The note of this quotation. |
overheads |
string |
Overheads |
☐ |
The general costs of this quotation. |
overheadsVatTariff_effectiveFrom |
string |
{res:itgen_bouw7_overheadsvattariff_effectivefrom} |
☐ |
The datetime in ATOM format since this VAT tariff is effective. |
overheadsVatTariff_id |
int64 |
Overheadkosten BTW Tarief-ID |
☐ |
ID of the vat tariff. |
overheadsVatTariff_label |
string |
Overhead BTW-tarief Label |
☐ |
Display label of the VAT tariff. |
overheadsVatTariff_percentage |
string |
Overheadkosten BTW Tariefpercentage |
☐ |
The VAT percentage. |
profitAndRisk |
string |
Winst en Risico |
☐ |
The profit and risk costs of this quotation. |
profitAndRiskVatTariff_effectiveFrom |
string |
{res:itgen_bouw7_profitandriskvattariff_effectivefrom} |
☐ |
The datetime in ATOM format since this VAT tariff is effective. |
profitAndRiskVatTariff_id |
int64 |
Winst en Risico BTW Tarief-ID |
☐ |
ID of the vat tariff. |
profitAndRiskVatTariff_label |
string |
Winst en Risico BTW-tarief Label |
☐ |
Display label of the VAT tariff. |
profitAndRiskVatTariff_percentage |
string |
Winst en Risico BTW-tariefpercentage |
☐ |
The VAT percentage. |
project_branch_code |
string |
{res:itgen_bouw7_project_branch_code} |
☐ |
The code for this branch |
project_branch_id |
int64 |
{res:itgen_bouw7_project_branch_id} |
☐ |
The ID of the branch. |
project_branch_name |
string |
{res:itgen_bouw7_project_branch_name} |
☐ |
The name of this branch |
project_category_code |
string |
{res:itgen_bouw7_project_category_code} |
☐ |
The code for the category. |
project_category_createdAt |
datetime |
{res:itgen_bouw7_project_category_createdat} |
☐ |
The creation time of the entity. |
project_category_createdBy |
string |
{res:itgen_bouw7_project_category_createdby} |
☐ |
The user that created the entity. |
project_category_generalCostsOrProfit |
string |
{res:itgen_bouw7_project_category_generalcostsorprofit} |
☐ |
The general costs or profit for the category. |
project_category_generalCostsPercentage |
string |
{res:itgen_bouw7_project_category_generalcostspercentage} |
☐ |
The general costs percentage for the category. |
project_category_grossProfitMargin |
string |
{res:itgen_bouw7_project_category_grossprofitmargin} |
☐ |
The gross profit margin for the category. |
project_category_id |
int64 |
{res:itgen_bouw7_project_category_id} |
☐ |
The ID of the category. |
project_category_name |
string |
{res:itgen_bouw7_project_category_name} |
☐ |
The name of the category. |
project_category_updatedAt |
datetime |
{res:itgen_bouw7_project_category_updatedat} |
☐ |
The last updated time of the entity. |
project_category_updatedBy |
string |
{res:itgen_bouw7_project_category_updatedby} |
☐ |
The user that last updated the entity. |
project_city |
string |
Project Stad |
☐ |
The city of the project. |
project_contact_email |
string |
Projectcontactpersoon E-mail |
☐ |
The email address. |
project_contact_id |
int64 |
Projectcontactpersoon-ID |
☐ |
ID of contact. |
project_contact_isVatShifted |
boolean |
{res:itgen_bouw7_project_contact_isvatshifted} |
☐ |
Whether VAT is shifted for the contact. |
project_contact_name |
string |
Project Contactnaam |
☐ |
Name of contact. |
project_contact_phoneNumber |
string |
{res:itgen_bouw7_project_contact_phonenumber} |
☐ |
The phone number of the contact. |
project_createdAt |
datetime |
Project Gemaakt op |
☐ |
The creation time of the entity. |
project_createdBy |
string |
Project Gemaakt door |
☐ |
The user that created the entity. |
project_deliveryDate |
datetime |
Project Opleverdatum |
☐ |
Delivery date for the project. |
project_endDate |
datetime |
Project Einddatum |
☐ |
End date for the project. |
project_fullProjectNumber |
string |
Volledig Projectnummer |
☐ |
The full project number including year. |
project_houseNumber |
string |
Project Huisnummer |
☐ |
The house number for the project. |
project_id |
int64 |
Project ID |
☐ |
The ID of the project. |
project_information |
string |
Projectgegevens |
☐ |
The information of the project. |
project_name |
string |
Projectnaam |
☐ |
The name of the project. |
project_projectNumber |
string |
Projectnummer |
☐ |
The project number. |
project_reference |
string |
Projectreferentie |
☐ |
The reference of the project. |
project_startDate |
datetime |
Project Startdatum |
☐ |
Start date for the project. |
project_status_closesProject |
boolean |
Projectstatus Sluit Project af |
☐ |
Whether or not this status closes a project. |
project_status_createdAt |
datetime |
Projectstatus Gemaakt op |
☐ |
The creation time of the entity. |
project_status_createdBy |
string |
Projectstatus Gemaakt door |
☐ |
The user that created the entity. |
project_status_id |
int64 |
Projectstatus-ID |
☐ |
The ID of the status. |
project_status_invoicesProject |
boolean |
Projectstatus Projectfacturen |
☐ |
Whether or not this status invoices a project. |
project_status_name |
string |
Projectstatusnaam |
☐ |
The name of the status. |
project_status_plansProject |
boolean |
Projectstatus Plannen Project |
☐ |
Whether or not this status plans a project. |
project_status_updatedAt |
datetime |
Projectstatus Bijgewerkt op |
☐ |
The last updated time of the entity. |
project_status_updatedBy |
string |
Projectstatus Bijgewerkt door |
☐ |
The user that last updated the entity. |
project_streetName |
string |
Projectstraatnaam |
☐ |
The street name for the project. |
project_updatedAt |
datetime |
Project Bijgewerkt op |
☐ |
The last updated time of the entity. |
project_updatedBy |
string |
Project Bijgewerkt door |
☐ |
The user that last updated the entity. |
project_zipCode |
string |
Project Postcode |
☐ |
The zip code for the project. |
quotation_branch_id |
int64 |
Vestiging-ID |
☐ |
The ID of the branch. |
quotation_branch_name |
string |
Filiaalnaam |
☐ |
The name of the branch. |
quotation_closingChance |
int64 |
Sluitingskans |
☐ |
The closing chance of this quotation. |
quotation_commissionPercentage |
string |
Commissie Percentage |
☐ |
The commission percentage of this quotation. |
quotation_contact_emailAddress |
string |
Contactpersoon E-mailadres |
☐ |
The email address of the contact. |
quotation_contact_id |
int64 |
Contactpersoon ID |
☐ |
The ID of the contact. |
quotation_contact_name |
string |
Contactpersoon Naam |
☐ |
The name of this contact. |
quotation_contact_type |
string |
Contactsoort |
☐ |
The type of this contact. |
quotation_contact_typeId |
int64 |
Contactsoort-ID |
☐ |
The type ID of this contact. |
quotation_contactPerson_emailAddress |
string |
Contactpersoon E-mailadres |
☐ |
The email address of the contact person. |
quotation_contactPerson_firstName |
string |
Contactpersoon Voornaam |
☐ |
The first name of this contact person. |
quotation_contactPerson_id |
int64 |
Contactpersoon ID |
☐ |
The ID of the contact person. |
quotation_contactPerson_lastName |
string(256) |
Contactpersoon Achternaam |
☐ |
The surname of the contact person. |
quotation_contactPerson_phoneNumber |
string(255) |
Contactpersoon Telefoonnummer |
☐ |
The phone number of the contact person. |
quotation_contactPersonText |
string(255) |
Contactpersoon Tekst |
☐ |
The contact person text of the quotation. |
quotation_createdAt |
datetime |
Aangemaakt op |
☐ |
The creation date of the object in ATOM/ISO-8601 format |
quotation_createdBy_id |
int64 |
Gemaakt door ID |
☐ |
The ID of the user. |
quotation_createdBy_username |
string |
Aangemaakt door Gebruikersnaam |
☐ |
The username of the user. |
quotation_employee_departmentId |
int64 |
Medewerker Afdelings-ID |
☐ |
The ID of the department this employee is enrolled in. |
quotation_employee_exactSalaryFrequency |
int64 |
Medewerker Exact Salarisfrequentie |
☐ |
The exact salary frequency of this employee. |
quotation_employee_firstName |
string |
Medewerker Voornaam |
☐ |
The given name of this employee. |
quotation_employee_id |
int64 |
Werknemer ID |
☐ |
The ID of the employee. |
quotation_employee_lastName |
string |
Medewerker Achternaam |
☐ |
The family name of this employee. |
quotation_expectedClosingDate |
datetime |
Verwachte sluitingsdatum |
☐ |
The expected closing date of this quotation, represented in ATOM-format. |
quotation_id |
int64 |
ID |
☐ |
The ID of the quotation. |
quotation_internalNote |
string |
Interne Notitie |
☐ |
The internal note for this quotation. |
quotation_language |
string |
Taal |
☐ |
The locale used by this quotation, e.g.: nl-NL. |
quotation_project_branchId |
int64 |
Project Filiaal-ID |
☐ |
The ID of the branch of this project. |
quotation_project_categoryId |
int64 |
Projectcategorie-ID |
☐ |
The ID of the category of this project. |
quotation_project_divisionId |
int64 |
Projectadministratie-ID |
☐ |
The ID of the division of this project. |
quotation_project_id |
int64 |
Project ID |
☐ |
The ID of the project. |
quotation_project_name |
string |
Projectnaam |
☐ |
The name of the project. |
quotation_project_number |
string |
Projectnummer |
☐ |
The number of the project. |
quotation_project_status |
string |
Projectstatus |
☐ |
The name of the current status of this project. |
quotation_project_statusId |
int64 |
Projectstatus-ID |
☐ |
The ID of the status of this project. |
quotation_quotationDate |
datetime |
Offertedatum |
☐ |
The date of the quotation, represented in ATOM-format. |
quotation_quotationNumber |
string |
Offertenummer |
☐ |
The number of the quotation. |
quotation_quotationStatus_id |
int64 |
Offertestatus-ID |
☐ |
The ID of the quotation status. |
quotation_quotationStatus_name |
string |
Offertestatus Naam |
☐ |
The name of the quotation status. |
quotation_reference |
string |
Referentie |
☐ |
The reference of the quotation. |
quotation_salutation |
int64 |
Begroeting |
☐ |
The salutation of this quotation. |
quotation_salutationText |
string(255) |
Aanhef Tekst |
☐ |
The salutation text of the quotation. |
quotation_subject |
string |
Onderwerp |
☐ |
The subject of the quotation. |
quotation_subtotal |
string |
Subtotaal |
☐ |
The sum of all quotation line subtotals, excluding VAT. |
quotation_total |
string |
Totaal |
☐ |
The sum of all quotation line subtotals, including VAT. |
quotation_updatedAt |
datetime |
Bijgewerkt op |
☐ |
The creation date of the object in ATOM/ISO-8601 format |
quotation_updatedBy_id |
int64 |
Bijgewerkt door ID |
☐ |
The ID of the user. |
quotation_updatedBy_username |
string |
Bijgewerkt door Gebruikersnaam |
☐ |
The username of the user. |
quotationDate |
datetime |
Offertedatum |
☐ |
The date of this quotation. |
quotationNumber |
string |
Offertenummer |
☐ |
The number of the quotation. |
quotationStatus_id |
int64 |
Offertestatus-ID |
☐ |
ID of the quotation status. |
quotationStatus_name |
string |
Offertestatus Naam |
☐ |
The name of the quotation status. |
recipient |
string |
Ontvanger |
☐ |
The recipient of the mail. |
reference |
string(255) |
Referentie |
☐ |
The reference of the quotation. |
salutation |
int64 |
Begroeting |
☐ |
The salutation of this quotation. |
salutationText |
string(255) |
Aanhef Tekst |
☐ |
The salutation text of the quotation. |
showOverheadsOnPdf |
boolean |
Toon Overheadkosten op PDF |
☐ |
Whether the general costs and profit and risk should be shown on the quotation PDF. |
showPricePerLine |
boolean |
Toon Prijs per Regel |
☐ |
Whether the price is shown per line. |
showSubtotalPerChapter |
boolean |
Toon Subtotaal per Hoofdstuk |
☐ |
Whether the subtotal is shown per chapter. |
showTotalPrice |
boolean |
Toon Totale Prijs |
☐ |
Whether the total price is shown on this quotation. |
subject |
string(255) |
Onderwerp |
☐ |
The subject of the quotation. |
updatedAt_2 |
datetime |
Bijgewerkt op |
☐ |
The last updated time of the entity. |
updatedAt |
datetime |
Bijgewerkt op |
☐ |
The last updated time of the entity. |
updatedBy_2 |
string |
Bijgewerkt door |
☐ |
The user that last updated the entity. |
updatedBy |
string |
Bijgewerkt door |
☐ |
The user that last updated the entity. |
30-06-2025 16:22 Versie 24.1.116-BETA+5455