invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceEmailByDocumentNumber: Fortnox Invoice Email by Document Number

read only REST

  • Catalog: Fortnox
  • Schema: Invoices
  • Label: Invoice Email by Document Number

Send an invoice as email You can use the properties in the EmailInformation to customize the e-mail message on each invoice.

Can only retrieve data.

Summary

You can use the properties in the EmailInformation to customize the e-mail message on each invoice.

API Source

  • Endpoint: /3/invoices/{DocumentNumber}/email
  • Operation: get /3/invoices/{DocumentNumber}/email

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
DocumentNumber `` identifies the invoice
financialyear `` Selects what financial year that should be used (does not work on every table).
financialyeardate `` Selects by date, what financial year that should be used (does not work on every table).
fromdate `` Defines a selection based on a start date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
todate `` Defines a selection based on an end date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Table Columns

The columns of the table InvoiceEmailByDocumentNumber 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
Invoice_AccountingMethod varchar2 Invoice Accounting Method filters on the platform, writable, Invoice.AccountingMethod
Invoice_Address1 varchar2 Invoice Address 1 filters on the platform, writable, Invoice.Address1
Invoice_Address2 varchar2 Invoice Address 2 filters on the platform, writable, Invoice.Address2
Invoice_AdministrationFee double Invoice Administration Fee filters on the platform, writable, Invoice.AdministrationFee
Invoice_AdministrationFeeVAT double Invoice Administration Fee VAT filters on the platform, writable, Invoice.AdministrationFeeVAT
Invoice_Balance double Invoice Balance filters on the platform, writable, Invoice.Balance
Invoice_BasisTaxReduction double Invoice Basis Tax Reduction filters on the platform, writable, Invoice.BasisTaxReduction
Invoice_Booked char Invoice Booked filters on the platform, writable, Invoice.Booked
Invoice_Cancelled char Invoice Cancelled filters on the platform, writable, Invoice.Cancelled
Invoice_City varchar2(1024) Invoice City filters on the platform, writable, Invoice.City
Invoice_Comments varchar2(1024) Invoice Comments filters on the platform, writable, Invoice.Comments
Invoice_ContractReference int32 Invoice Contract Reference filters on the platform, writable, Invoice.ContractReference
Invoice_ContributionPercent double Invoice Contribution Percent filters on the platform, writable, Invoice.ContributionPercent
Invoice_ContributionValue double Invoice Contribution Value filters on the platform, writable, Invoice.ContributionValue
Invoice_CostCenter varchar2 Invoice Cost Centre filters on the platform, writable, Invoice.CostCenter
Invoice_Country varchar2 Invoice Country filters on the platform, writable, Invoice.Country
Invoice_Credit varchar2 Invoice Credit filters on the platform, writable, Invoice.Credit
Invoice_CreditInvoiceReference varchar2 Invoice Credit Invoice Reference filters on the platform, writable, Invoice.CreditInvoiceReference
Invoice_Currency varchar2 Invoice Currency filters on the platform, writable, Invoice.Currency
Invoice_CurrencyRate double Invoice Currency Rate filters on the platform, writable, Invoice.CurrencyRate
Invoice_CurrencyUnit int32 Invoice Currency Unit filters on the platform, writable, Invoice.CurrencyUnit
Invoice_CustomerName varchar2 Invoice Customer Name filters on the platform, writable, Invoice.CustomerName
Invoice_CustomerNumber varchar2 Invoice Customernumber filters on the platform, writable, Invoice.CustomerNumber
Invoice_DeliveryAddress1 varchar2(1024) Invoice Delivery Address 1 filters on the platform, writable, Invoice.DeliveryAddress1
Invoice_DeliveryAddress2 varchar2(1024) Invoice Delivery Address 2 filters on the platform, writable, Invoice.DeliveryAddress2
Invoice_DeliveryCity varchar2(1024) Invoice Delivery City filters on the platform, writable, Invoice.DeliveryCity
Invoice_DeliveryCountry varchar2 Invoice Delivery Country filters on the platform, writable, Invoice.DeliveryCountry
Invoice_DeliveryDate datetime Invoice Delivery Date filters on the platform, writable, Invoice.DeliveryDate
Invoice_DeliveryName varchar2(1024) Invoice Delivery Name filters on the platform, writable, Invoice.DeliveryName
Invoice_DeliveryZipCode varchar2(1024) Invoice Delivery Zip Code filters on the platform, writable, Invoice.DeliveryZipCode
Invoice_DocumentNumber varchar2 Invoice Document Number filters on the platform, writable, Invoice.DocumentNumber
Invoice_DueDate datetime Invoice Duedate filters on the platform, writable, Invoice.DueDate
Invoice_EDIInformation_EDIGlobalLocationNumber varchar2(13) Invoice EDI Information EDI Global Location Number filters on the platform, writable, Invoice.EDIInformation.EDIGlobalLocationNumber
Invoice_EDIInformation_EDIGlobalLocationNumberDelivery varchar2(13) Invoice EDI Information EDI Global Location Number Delivery filters on the platform, writable, Invoice.EDIInformation.EDIGlobalLocationNumberDelivery
Invoice_EDIInformation_EDIInvoiceExtra1 varchar2 Invoice EDI Information EDI Invoice Extra 1 filters on the platform, writable, Invoice.EDIInformation.EDIInvoiceExtra1
Invoice_EDIInformation_EDIInvoiceExtra2 varchar2 Invoice EDI Information EDI Invoice Extra 2 filters on the platform, writable, Invoice.EDIInformation.EDIInvoiceExtra2
Invoice_EDIInformation_EDIOurElectronicReference varchar2 Invoice EDI Information EDI Our Electronic Reference filters on the platform, writable, Invoice.EDIInformation.EDIOurElectronicReference
Invoice_EDIInformation_EDIStatus varchar2 Invoice EDI Information EDI Status filters on the platform, writable, Invoice.EDIInformation.EDIStatus
Invoice_EDIInformation_EDIYourElectronicReference varchar2 Invoice EDI Information EDI Your Electronic Reference filters on the platform, writable, Invoice.EDIInformation.EDIYourElectronicReference
Invoice_EUQuarterlyReport char Invoice EU Quarterly Report filters on the platform, writable, Invoice.EUQuarterlyReport
Invoice_EmailInformation_EmailAddressBCC varchar2 Invoice Email Information Email Address Bcc filters on the platform, writable, Invoice.EmailInformation.EmailAddressBCC
Invoice_EmailInformation_EmailAddressCC varchar2 Invoice Email Information Email Address CC filters on the platform, writable, Invoice.EmailInformation.EmailAddressCC
Invoice_EmailInformation_EmailAddressFrom varchar2 Invoice Email Information Email Address From filters on the platform, writable, Invoice.EmailInformation.EmailAddressFrom
Invoice_EmailInformation_EmailAddressTo varchar2 Invoice Email Information Email Address To filters on the platform, writable, Invoice.EmailInformation.EmailAddressTo
Invoice_EmailInformation_EmailBody varchar2(20000) Invoice Email Information Email Body filters on the platform, writable, Invoice.EmailInformation.EmailBody
Invoice_EmailInformation_EmailSubject varchar2(100) Invoice Email Information Email Subject filters on the platform, writable, Invoice.EmailInformation.EmailSubject
Invoice_ExternalInvoiceReference1 varchar2(80) Invoice External Invoice Reference 1 filters on the platform, writable, Invoice.ExternalInvoiceReference1
Invoice_ExternalInvoiceReference2 varchar2(80) Invoice External Invoice Reference 2 filters on the platform, writable, Invoice.ExternalInvoiceReference2
Invoice_FinalPayDate datetime Invoice Final Pay Date filters on the platform, writable, Invoice.FinalPayDate
Invoice_Freight double Invoice Freight filters on the platform, writable, Invoice.Freight
Invoice_FreightVAT double Invoice Freight VAT filters on the platform, writable, Invoice.FreightVAT
Invoice_Gross double Invoice Gross filters on the platform, writable, Invoice.Gross
Invoice_HouseWork char Invoice House Work filters on the platform, writable, Invoice.HouseWork
Invoice_InvoiceDate datetime Invoice Date filters on the platform, writable, Invoice.InvoiceDate
Invoice_InvoicePeriodEnd datetime Invoice Period End filters on the platform, writable, Invoice.InvoicePeriodEnd
Invoice_InvoicePeriodReference varchar2 Invoice Period Reference filters on the platform, writable, Invoice.InvoicePeriodReference
Invoice_InvoicePeriodStart datetime Invoice Period Start filters on the platform, writable, Invoice.InvoicePeriodStart
Invoice_InvoiceType varchar2 Invoice Type filters on the platform, writable, Invoice.InvoiceType
Invoice_Language varchar2 Invoice Language filters on the platform, writable, Invoice.Language
Invoice_LastRemindDate datetime Invoice Last Remind Date filters on the platform, writable, Invoice.LastRemindDate
Invoice_Net double Invoice Net filters on the platform, writable, Invoice.Net
Invoice_NotCompleted char Invoice Notcompleted filters on the platform, writable, Invoice.NotCompleted
Invoice_NoxFinans char Invoice Nox Finans filters on the platform, writable, Invoice.NoxFinans
Invoice_OCR varchar2 Invoice Ocr filters on the platform, writable, Invoice.OCR
Invoice_OfferReference varchar2 Invoice Offer Reference filters on the platform, writable, Invoice.OfferReference
Invoice_OrderReference varchar2 Invoice Order Reference filters on the platform, writable, Invoice.OrderReference
Invoice_OrganisationNumber varchar2 Invoice Organisation Number filters on the platform, writable, Invoice.OrganisationNumber
Invoice_OurReference varchar2(50) Invoice Ourreference filters on the platform, writable, Invoice.OurReference
Invoice_OutboundDate datetime Invoice Outbound Date filters on the platform, writable, Invoice.OutboundDate
Invoice_PaymentWay varchar2 Invoice Payment Way filters on the platform, writable, Invoice.PaymentWay
Invoice_Phone1 varchar2(1024) Invoice Phone 1 filters on the platform, writable, Invoice.Phone1
Invoice_Phone2 varchar2(1024) Invoice Phone 2 filters on the platform, writable, Invoice.Phone2
Invoice_PriceList varchar2 Invoice Pricelist filters on the platform, writable, Invoice.PriceList
Invoice_PrintTemplate varchar2 Invoice Print Template filters on the platform, writable, Invoice.PrintTemplate
Invoice_Project varchar2 Invoice Project filters on the platform, writable, Invoice.Project
Invoice_Remarks varchar2(1024) Invoice Remarks filters on the platform, writable, Invoice.Remarks
Invoice_Reminders int32 Invoice Reminders filters on the platform, writable, Invoice.Reminders
Invoice_RoundOff double Invoice Round Off filters on the platform, writable, Invoice.RoundOff
Invoice_Sent char Invoice Sent filters on the platform, writable, Invoice.Sent
Invoice_TaxReduction int32 Invoice Tax Reduction filters on the platform, writable, Invoice.TaxReduction
Invoice_TaxReductionType varchar2 Invoice Tax Reduction Type filters on the platform, writable, Invoice.TaxReductionType
Invoice_TermsOfDelivery varchar2 Invoice Terms of Delivery filters on the platform, writable, Invoice.TermsOfDelivery
Invoice_TermsOfPayment varchar2 Invoice Terms of Payment filters on the platform, writable, Invoice.TermsOfPayment
Invoice_TimeBasisReference int32 Invoice Time Basis Reference filters on the platform, writable, Invoice.TimeBasisReference
Invoice_Total double Invoice Total filters on the platform, writable, Invoice.Total
Invoice_TotalToPay double Invoice Total to Pay filters on the platform, writable, Invoice.TotalToPay
Invoice_TotalVAT double Invoice Total VAT filters on the platform, writable, Invoice.TotalVAT
Invoice_VATIncluded char Invoice Vatincluded filters on the platform, writable, Invoice.VATIncluded
Invoice_VoucherNumber int32 Invoice Voucher Number filters on the platform, writable, Invoice.VoucherNumber
Invoice_VoucherSeries varchar2 Invoice Voucher Series filters on the platform, writable, Invoice.VoucherSeries
Invoice_VoucherYear int32 Invoice Voucher Year filters on the platform, writable, Invoice.VoucherYear
Invoice_WarehouseReady char Invoice Warehouse Ready filters on the platform, writable, Invoice.WarehouseReady
Invoice_WayOfDelivery varchar2 Invoice Way of Delivery filters on the platform, writable, Invoice.WayOfDelivery
Invoice_YourOrderNumber varchar2(75) Invoice Your Order Number filters on the platform, writable, Invoice.YourOrderNumber
Invoice_YourReference varchar2(50) Invoice Your Reference filters on the platform, writable, Invoice.YourReference
Invoice_ZipCode varchar2(1024) Invoice ZIP Code filters on the platform, writable, Invoice.ZipCode
Invoice__url varchar2 Invoice URL filters on the platform, writable, Invoice.@url
Invoice__urlTaxReductionList varchar2 Invoice URL Tax Reduction List filters on the platform, writable, Invoice.@urlTaxReductionList

Release Notes

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