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 |
|---|---|---|---|---|
Document |
`` | 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_ |
varchar2 |
Invoice Accounting Method | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Address 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Address 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Administration Fee | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Administration Fee VAT | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Balance | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Basis Tax Reduction | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice Booked | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice Cancelled | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice City | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Comments | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Invoice Contract Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Contribution Percent | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Contribution Value | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Cost Centre | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Country | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Credit | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Credit Invoice Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Currency | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Currency Rate | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Invoice Currency Unit | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Customer Name | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Customernumber | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Delivery Address 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Delivery Address 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Delivery City | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Delivery Country | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Delivery Date | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Delivery Name | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Delivery Zip Code | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Document Number | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Duedate | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice EDI Information EDI Global Location Number | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice EDI Information EDI Global Location Number Delivery | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice EDI Information EDI Invoice Extra 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice EDI Information EDI Invoice Extra 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice EDI Information EDI Our Electronic Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice EDI Information EDI Status | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice EDI Information EDI Your Electronic Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice EU Quarterly Report | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Email Information Email Address Bcc | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Email Information Email Address CC | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Email Information Email Address From | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Email Information Email Address To | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Email Information Email Body | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Email Information Email Subject | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice External Invoice Reference 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice External Invoice Reference 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Final Pay Date | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Freight | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Freight VAT | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Gross | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice House Work | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Date | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Period End | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Period Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Period Start | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Type | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Language | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Last Remind Date | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Net | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice Notcompleted | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice Nox Finans | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Ocr | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Offer Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Order Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Organisation Number | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Ourreference | filters on the platform, writable, Invoice. |
||
Invoice_ |
datetime |
Invoice Outbound Date | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Payment Way | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Phone 1 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Phone 2 | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Pricelist | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Print Template | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Project | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Remarks | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Invoice Reminders | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Round Off | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice Sent | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Invoice Tax Reduction | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Tax Reduction Type | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Terms of Delivery | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Terms of Payment | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Invoice Time Basis Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Total | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Total to Pay | filters on the platform, writable, Invoice. |
||
Invoice_ |
double |
Invoice Total VAT | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice Vatincluded | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Invoice Voucher Number | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Voucher Series | filters on the platform, writable, Invoice. |
||
Invoice_ |
int32 |
Invoice Voucher Year | filters on the platform, writable, Invoice. |
||
Invoice_ |
char |
Invoice Warehouse Ready | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Way of Delivery | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Your Order Number | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice Your Reference | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice ZIP Code | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice URL | filters on the platform, writable, Invoice. |
||
Invoice_ |
varchar2 |
Invoice URL Tax Reduction List | filters on the platform, writable, Invoice. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: