invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceSentEmailsByInvoiceId: Bouw7 Invoice Sent Emails by Invoice ID

read only REST

  • Catalog: Bouw7
  • Schema: Invoicing
  • Label: Invoice Sent Emails by Invoice ID

Returns the document of an existing invoice. Returns the document of a new invoice.

Can only retrieve data.

Summary

Returns the document of a new invoice.

API Source

  • Endpoint: /invoice/{invoice}
  • Operation: get /invoice/{invoice}

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.

Parameters

Name Data Type Required Default Documentation
invoice `` Invoice ID

Table Columns

The columns of the table InvoiceSentEmailsByInvoiceId 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
attachEquipmentList char Attach Equipment List filters on the platform, writable, ::ancestor.attachEquipmentList Whether to attach the material list attachment.
attachGarbageList char Attach Garbage List filters on the platform, writable, ::ancestor.attachGarbageList Whether to attach the waste list attachment.
attachMaterialList char Attach Material List filters on the platform, writable, ::ancestor.attachMaterialList Whether to attach the material list attachment.
attachRegister char Attach Register filters on the platform, writable, ::ancestor.attachRegister Whether to attach the register attachment.
bccRecipients varchar2 BCC Recipients writable, bccRecipients The bcc recipient(s) of the mail, comma separated.
branch_code varchar2(255) Branch Code filters on the platform, writable, ::ancestor.branch.code The code of the branch.
branch_division_description varchar2 itgen_bouw7_branch_division_description filters on the platform, writable, ::ancestor.branch.division.description The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable, ::ancestor.branch.division.exactDivisionId The division ID of an Exact Online environment.
branch_division_glAccountCode varchar2 itgen_bouw7_branch_division_glaccountcode filters on the platform, writable, ::ancestor.branch.division.glAccountCode 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, ::ancestor.branch.division.glAccountCodePurchase 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, ::ancestor.branch.division.id The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable, ::ancestor.branch.division.journalCode A default journal code to use for sales related items.
branch_division_journalCodePurchase varchar2 itgen_bouw7_branch_division_journalcodepurchase filters on the platform, writable, ::ancestor.branch.division.journalCodePurchase 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, ::ancestor.branch.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
branch_gAccountPercentage varchar2 Branch G-Account Percentage filters on the platform, writable, ::ancestor.branch.gAccountPercentage The g account percentage of the branch.
branch_gAccountText varchar2(255) Branch G-Account Text filters on the platform, writable, ::ancestor.branch.gAccountText The g account text of the branch.
branch_id int64 Branch ID filters on the platform, writable, ::ancestor.branch.id The ID of the branch.
branch_nAccountText varchar2(255) Branch N-Account Text filters on the platform, writable, ::ancestor.branch.nAccountText The n account text of the branch.
branch_name varchar2 Branch Name filters on the platform, writable, ::ancestor.branch.name The name of the branch.
branch_useOrganizationInfo char Branch Use Organisation Info filters on the platform, writable, ::ancestor.branch.useOrganizationInfo If organization information should be used instead of branch information.
branch_wageComponentPercentage varchar2 Branch Wage Component Percentage filters on the platform, writable, ::ancestor.branch.wageComponentPercentage The wage component percentage of the branch.
canBookToAfas char Can Book to AFAS filters on the platform, writable, ::ancestor.canBookToAfas Whether it is allowed to book to AFAS.
canBookToExact char Can Book to Exact filters on the platform, writable, ::ancestor.canBookToExact Whether it is allowed to book to Exact.
canBookToMareon char Can Book to Mareon filters on the platform, writable, ::ancestor.canBookToMareon Whether it is allowed to book to Mareon.
canBookToTwinfield char Can Book to Twinfield filters on the platform, writable, ::ancestor.canBookToTwinfield Whether it is allowed to book to Twinfield.
canUseCostCenter char Can Use Cost Centre filters on the platform, writable, ::ancestor.canUseCostCenter Whether the user can use cost center functionality.
ccRecipients varchar2 CC Recipients writable, ccRecipients The cc recipient(s) of the mail, comma separated.
contactPersonName varchar2 Contact Person Name filters on the platform, writable, ::ancestor.contactPersonName The name of the contact person for this invoice.
contactPerson_city varchar2(255) Contact Person City filters on the platform, writable, ::ancestor.contactPerson.city The contact person's city.
contactPerson_createdAt datetime Contact Person Created at filters on the platform, writable, ::ancestor.contactPerson.createdAt The creation time of the entity.
contactPerson_createdBy varchar2 Contact Person Created by filters on the platform, writable, ::ancestor.contactPerson.createdBy The user that created the entity.
contactPerson_email varchar2(256) Contact Person Email filters on the platform, writable, ::ancestor.contactPerson.email The contact person's email address.
contactPerson_firstName varchar2(256) Contact Person First Name filters on the platform, writable, ::ancestor.contactPerson.firstName The contact person's first name.
contactPerson_houseNumber varchar2(50) Contact Person House Number filters on the platform, writable, ::ancestor.contactPerson.houseNumber The contact person's house number.
contactPerson_id int64 Contact Person ID filters on the platform, writable, ::ancestor.contactPerson.id The ID of contact person.
contactPerson_jobTitle varchar2(64) Contact Person Job Title filters on the platform, writable, ::ancestor.contactPerson.jobTitle The contact person's job title.
contactPerson_lastName varchar2(256) Contact Person Last Name filters on the platform, writable, ::ancestor.contactPerson.lastName The contact person's last name.
contactPerson_phoneNumber varchar2(255) Contact Person Phone Number filters on the platform, writable, ::ancestor.contactPerson.phoneNumber The contact person's phone number.
contactPerson_salutation varchar2(32) Contact Person Salutation filters on the platform, writable, ::ancestor.contactPerson.salutation The contact person's salutation.
contactPerson_streetName varchar2(255) Contact Person Street Name filters on the platform, writable, ::ancestor.contactPerson.streetName The contact person's street name.
contactPerson_updatedAt datetime Contact Person Updated at filters on the platform, writable, ::ancestor.contactPerson.updatedAt The last updated time of the entity.
contactPerson_updatedBy varchar2 Contact Person Updated by filters on the platform, writable, ::ancestor.contactPerson.updatedBy The user that last updated the entity.
contactPerson_zipCode varchar2(20) Contact Person ZIP Code filters on the platform, writable, ::ancestor.contactPerson.zipCode The contact person's zip code.
contact_city varchar2 Contact City filters on the platform, writable, ::ancestor.contact.city The city of residence of the contact.
contact_cocNumber varchar2 Contact CoC Number filters on the platform, writable, ::ancestor.contact.cocNumber The chamber of commerce number of the contact.
contact_contactPersonName varchar2 Contact Contact Person Name filters on the platform, writable, ::ancestor.contact.contactPersonName The name of the contact person.
contact_contactType_id int64 Contact Contact Type ID filters on the platform, writable, ::ancestor.contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Contact Type Name filters on the platform, writable, ::ancestor.contact.contactType.name The name of contact type.
contact_country varchar2 Contact Country filters on the platform, writable, ::ancestor.contact.country The country of the contact.
contact_debtorNumber varchar2 Contact Debtor Number filters on the platform, writable, ::ancestor.contact.debtorNumber The debtor number of the contact.
contact_emailAddress varchar2 Contact Email Address filters on the platform, writable, ::ancestor.contact.emailAddress The email-address of the contact.
contact_expirationReminderDays int64 Contact Expiration Reminder Days filters on the platform, writable, ::ancestor.contact.expirationReminderDays The number of days before a reminder is sent.
contact_gAccountPercentage varchar2 Contact G-Account Percentage filters on the platform, writable, ::ancestor.contact.gAccountPercentage G-account percentage.
contact_gAccountText varchar2(255) Contact G-Account Text filters on the platform, writable, ::ancestor.contact.gAccountText G-account text.
contact_glnNumber varchar2(13) itgen_bouw7_contact_glnnumber filters on the platform, writable, ::ancestor.contact.glnNumber The Global Location Number.
contact_houseNumber varchar2 Contact House Number filters on the platform, writable, ::ancestor.contact.houseNumber The house- or building-number of the contact.
contact_iban varchar2 Contact IBAN filters on the platform, writable, ::ancestor.contact.iban The IBAN-account number of the contact.
contact_id int64 Contact ID filters on the platform, writable, ::ancestor.contact.id The ID of the contact.
contact_invoiceMail varchar2 itgen_bouw7_contact_invoicemail filters on the platform, writable, ::ancestor.contact.invoiceMail The invoice mail.
contact_invoiceUblVersion varchar2 Contact Invoice UBL Version filters on the platform, writable, ::ancestor.contact.invoiceUblVersion The preferred UBL invoice version for this contact.
contact_isVatShifted char Contact Is VAT Shifted filters on the platform, writable, ::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_nAccountText varchar2(255) Contact N-Account Text filters on the platform, writable, ::ancestor.contact.nAccountText N-account text.
contact_name varchar2 Contact Name filters on the platform, writable, ::ancestor.contact.name The name of the contact.
contact_phoneNumber varchar2 Contact Phone Number filters on the platform, writable, ::ancestor.contact.phoneNumber The phone number of the contact.
contact_streetName varchar2 Contact Street Name filters on the platform, writable, ::ancestor.contact.streetName The street name of the contact.
contact_vatNumber varchar2 Contact VAT Number filters on the platform, writable, ::ancestor.contact.vatNumber The VAT-number of the contact.
contact_wageComponentPercentage varchar2 Contact Wage Component Percentage filters on the platform, writable, ::ancestor.contact.wageComponentPercentage Wage component percentage.
contact_zipCode varchar2 Contact ZIP Code filters on the platform, writable, ::ancestor.contact.zipCode The zip-code of the contact.
createdAt datetime Created at writable, createdAt The creation time of the entity.
createdAt_2 datetime Created at filters on the platform, writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, createdBy The user that created the entity.
createdBy_2 varchar2 Created by filters on the platform, writable, ::ancestor.createdBy The user that created the entity.
date datetime Date filters on the platform, writable, ::ancestor.date The invoice date.
datePaid varchar2 Date Paid filters on the platform, writable, ::ancestor.datePaid The paid date.
debtorNumber varchar2 Debtor Number filters on the platform, writable, ::ancestor.debtorNumber The debtor number of the contact associated with this invoice.
description varchar2 Description filters on the platform, writable, ::ancestor.description The public description for this invoice.
displayWorkAddress char Display Work Address filters on the platform, writable, ::ancestor.displayWorkAddress Whether the work address is displayed on the invoice.
division_description varchar2 Division Description filters on the platform, writable, ::ancestor.division.description The description of the division.
division_exactDivisionId varchar2 Division Exact Division ID filters on the platform, writable, ::ancestor.division.exactDivisionId The division ID of an Exact Online environment.
division_glAccountCode varchar2 Division General Ledger Account Code filters on the platform, writable, ::ancestor.division.glAccountCode A default general ledger account code to use for sales related items.
division_glAccountCodePurchase varchar2 Division General Ledger Account Code Purchase filters on the platform, writable, ::ancestor.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
division_id int64 Division ID filters on the platform, writable, ::ancestor.division.id The ID of the division.
division_journalCode varchar2 Division Journal Code filters on the platform, writable, ::ancestor.division.journalCode A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Division Journal Code Purchase filters on the platform, writable, ::ancestor.division.journalCodePurchase A default journal code to use for purchase related items.
division_salesInvoiceNumberPrefix varchar2(3) Division Sales Invoice Number Prefix filters on the platform, writable, ::ancestor.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
dueDate datetime Due Date filters on the platform, writable, ::ancestor.dueDate The invoice due date.
endDate datetime End Date filters on the platform, writable, ::ancestor.endDate The end date of attached booking items in Y-m-d format.
exactFinancialPeriod_endDate datetime itgen_bouw7_exactfinancialperiod_enddate filters on the platform, writable, ::ancestor.exactFinancialPeriod.endDate The end date of the exact financial period in Y-m-d format.
exactFinancialPeriod_financialPeriod int64 itgen_bouw7_exactfinancialperiod_financialperiod filters on the platform, writable, ::ancestor.exactFinancialPeriod.financialPeriod The period of the exact financial period.
exactFinancialPeriod_financialYear int64 itgen_bouw7_exactfinancialperiod_financialyear filters on the platform, writable, ::ancestor.exactFinancialPeriod.financialYear The year of the exact financial period.
exactFinancialPeriod_id int64 itgen_bouw7_exactfinancialperiod_id filters on the platform, writable, ::ancestor.exactFinancialPeriod.id The ID of the exact financial period.
exactFinancialPeriod_startDate datetime itgen_bouw7_exactfinancialperiod_startdate filters on the platform, writable, ::ancestor.exactFinancialPeriod.startDate The start date of the exact financial period in Y-m-d format.
exactPaymentCondition varchar2(255) Exact Payment Condition filters on the platform, writable, ::ancestor.exactPaymentCondition The code of the Exact Online payment condition for this invoice.
gAccountAmount varchar2 G-Account Amount filters on the platform, writable, ::ancestor.gAccountAmount G-account amount.
gAccountPercentage varchar2 G-Account Percentage filters on the platform, writable, ::ancestor.gAccountPercentage G-account percentage.
gAccountText varchar2(255) G-Account Text filters on the platform, writable, ::ancestor.gAccountText G-account text.
id int64 ID filters on the platform, writable, ::ancestor.id The ID of the invoice. Must be omitted to create a new invoice.
includeCoverSheet char Include Cover Sheet filters on the platform, writable, ::ancestor.includeCoverSheet Whether to include a cover sheet to the invoice PDF.
internalNote varchar2 Internal Note filters on the platform, writable, ::ancestor.internalNote The internal note for this invoice.
invoiceNumber varchar2 Invoice Number filters on the platform, writable, ::ancestor.invoiceNumber The number of this invoice.
invoicedProjectStatusName varchar2 Invoiced Project Status Name filters on the platform, writable, ::ancestor.invoicedProjectStatusName The status name of the projects if the status is going to be changed when an invoice is saved.
isBooked char Is Booked filters on the platform, writable, ::ancestor.isBooked Whether the invoice is already booked.
isCollective char Is Collective filters on the platform, writable, ::ancestor.isCollective Whether the invoice is a collective invoice.
isCredit char Is Credit filters on the platform, writable, ::ancestor.isCredit Whether this invoice is a credit invoice.
isMareonBooked char Is Mareon Booked filters on the platform, writable, ::ancestor.isMareonBooked Whether the invoice is already booked in mareon.
isVatShifted char Is VAT Shifted filters on the platform, writable, ::ancestor.isVatShifted Whether VAT is shifted for the invoice.
language varchar2 Language filters on the platform, writable, ::ancestor.language The locale used by this invoice document, e.g.: nl-NL.
mailDate datetime Mail Date writable, mailDate The mail date of the mail.
mailType int64 Mail Type writable, mailType The mail type.
nAccountText varchar2(255) N-Account Text filters on the platform, writable, ::ancestor.nAccountText N-account text.
organization_city varchar2 Organisation City filters on the platform, writable, ::ancestor.organization.city The city of residence of the supplier.
organization_cocNumber varchar2 Organisation CoC Number filters on the platform, writable, ::ancestor.organization.cocNumber The chamber of commerce number of the supplier.
organization_country varchar2 Organisation Country filters on the platform, writable, ::ancestor.organization.country The country of the supplier.
organization_emailAddress varchar2 Organisation Email Address filters on the platform, writable, ::ancestor.organization.emailAddress The email-address of the supplier.
organization_expirationReminderDays int64 Organisation Expiration Reminder Days filters on the platform, writable, ::ancestor.organization.expirationReminderDays The number of days before a reminder is sent.
organization_gAccountPercentage varchar2 Organisation G-Account Percentage filters on the platform, writable, ::ancestor.organization.gAccountPercentage The g account percentage for the customer.
organization_gAccountText varchar2 Organisation G-Account Text filters on the platform, writable, ::ancestor.organization.gAccountText The g account text for the customer.
organization_houseNumber varchar2 Organisation House Number filters on the platform, writable, ::ancestor.organization.houseNumber The house- or building-number of the supplier.
organization_iban varchar2 Organisation IBAN filters on the platform, writable, ::ancestor.organization.iban The IBAN-account number of the supplier.
organization_logo_createdAt datetime Organisation Logo Created at filters on the platform, writable, ::ancestor.organization.logo.createdAt The creation time of the entity.
organization_logo_createdBy varchar2 Organisation Logo Created by filters on the platform, writable, ::ancestor.organization.logo.createdBy The user that created the entity.
organization_logo_extension varchar2 Organisation Logo Extension filters on the platform, writable, ::ancestor.organization.logo.extension The extension of the file.
organization_logo_id int64 Organisation Logo ID filters on the platform, writable, ::ancestor.organization.logo.id The ID of this file
organization_logo_modelId int64 Organisation Logo Model ID filters on the platform, writable, ::ancestor.organization.logo.modelId The ID of the associated type.
organization_logo_modelType varchar2 Organisation Logo Model Type filters on the platform, writable, ::ancestor.organization.logo.modelType The category of the file.
organization_logo_name varchar2 Organisation Logo Name filters on the platform, writable, ::ancestor.organization.logo.name The public name of the file.
organization_logo_secureHash varchar2 itgen_bouw7_organization_logo_securehash filters on the platform, writable, ::ancestor.organization.logo.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
organization_logo_size int64 Organisation Logo Size filters on the platform, writable, ::ancestor.organization.logo.size The size of the file in bytes.
organization_logo_updatedAt datetime Organisation Logo Updated at filters on the platform, writable, ::ancestor.organization.logo.updatedAt The last updated time of the entity.
organization_logo_updatedBy varchar2 Organisation Logo Updated by filters on the platform, writable, ::ancestor.organization.logo.updatedBy The user that last updated the entity.
organization_logo_uri varchar2 Organisation Logo URI filters on the platform, writable, ::ancestor.organization.logo.uri The URI of the file, used to fetch the contents.
organization_nAccountText varchar2 Organisation N-Account Text filters on the platform, writable, ::ancestor.organization.nAccountText The n account text for the customer.
organization_name varchar2 Organisation Name filters on the platform, writable, ::ancestor.organization.name The name of the supplier.
organization_phoneNumber varchar2 Organisation Phone Number filters on the platform, writable, ::ancestor.organization.phoneNumber The phone number of the supplier.
organization_shouldCopyProjectDescription char Organisation Should Copy Project Description filters on the platform, writable, ::ancestor.organization.shouldCopyProjectDescription Whether the project description should be copied.
organization_showProjectNameOnInvoicePdf char Organisation Show Project Name on Invoice PDF filters on the platform, writable, ::ancestor.organization.showProjectNameOnInvoicePdf Whether the project name will show on the invoice.
organization_showProjectNumberOnInvoice char Organisation Show Project Number on Invoice filters on the platform, writable, ::ancestor.organization.showProjectNumberOnInvoice Whether the project number will show on the invoice.
organization_streetName varchar2 Organisation Street Name filters on the platform, writable, ::ancestor.organization.streetName The street name of the supplier.
organization_vatNumber varchar2 Organisation VAT Number filters on the platform, writable, ::ancestor.organization.vatNumber The VAT-number of the supplier.
organization_wageComponentPercentage varchar2 Organisation Wage Component Percentage filters on the platform, writable, ::ancestor.organization.wageComponentPercentage The wage component percentage for the customer.
organization_websiteAddress varchar2 Organisation Website Address filters on the platform, writable, ::ancestor.organization.websiteAddress The website address of the supplier.
organization_zipCode varchar2 Organisation ZIP Code filters on the platform, writable, ::ancestor.organization.zipCode The zip-code of the supplier.
project_fullProjectNumber varchar2 Project Full Project Number filters on the platform, writable, ::ancestor.project.fullProjectNumber The full project number including year.
project_id int64 Project ID filters on the platform, writable, ::ancestor.project.id The ID of the project.
project_name varchar2 Project Name filters on the platform, writable, ::ancestor.project.name The name of the project.
project_reference varchar2 Project Reference filters on the platform, writable, ::ancestor.project.reference The reference of the project.
project_workAddress varchar2 Project Work Address filters on the platform, writable, ::ancestor.project.workAddress The work address of the project.
recipient varchar2 Recipient writable, recipient The recipient of the mail.
startDate datetime Start Date filters on the platform, writable, ::ancestor.startDate The start date of attached booking items in Y-m-d format.
status int64 Status filters on the platform, writable, ::ancestor.status The status of the invoice.
updatedAt datetime Updated At writable, updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at filters on the platform, writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by filters on the platform, writable, ::ancestor.updatedBy The user that last updated the entity.
vatShiftedValue varchar2(255) VAT Shifted Value filters on the platform, writable, ::ancestor.vatShiftedValue VAT is shifted value. Usually a VAT-number of the contact.
wageComponentAmount varchar2 Wage Component Amount filters on the platform, writable, ::ancestor.wageComponentAmount Wage component amount.
wageComponentPercentage varchar2 Wage Component Percentage filters on the platform, writable, ::ancestor.wageComponentPercentage Wage component percentage.
workAddress varchar2(255) Work Address filters on the platform, writable, ::ancestor.workAddress The work address of the invoice.

Release Notes

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