# InvoiceEmailInvoiceLinesByDocumentNumber: Fortnox Invoice Email Invoice Lines 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. ## Documentation You can use the properties in the EmailInformation to customize the e-mail message on each invoice. - Catalog: `Fortnox` - Schema: `Invoices` - Label: Invoice Email Invoice Lines by Document Number This is a read-only table function. The Fortnox API may not support changing the data or the Invantive UniversalSQL driver for Fortnox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Fortnox API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `InvoiceEmailInvoiceLinesByDocumentNumber`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | 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). | ## Columns of Table Function The columns of the table function `InvoiceEmailInvoiceLinesByDocumentNumber` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountNumber` | `int32` | Account Number | ☐ | | | `AccountingMethod` | `varchar2` | Accounting Method | ☐ | | | `Address1` | `varchar2` | Address Line 1 | ☐ | | | `Address2` | `varchar2` | Address Line 2 | ☐ | | | `AdministrationFeeVAT` | `double` | Administration Fee VAT | ☐ | | | `AdministrationFee` | `double` | Administration Fee | ☐ | | | `ArticleNumber` | `varchar2` | Article Number | ☐ | | | `Balance` | `double` | Balance | ☐ | | | `BasisTaxReduction` | `double` | Basis Tax Reduction | ☐ | | | `Booked` | `char` | Booked | ☐ | | | `Cancelled` | `char` | Cancelled | ☐ | | | `City` | `varchar2(1024)` | City | ☐ | | | `Comments` | `varchar2(1024)` | Comments | ☐ | | | `ContractReference` | `int32` | Contract Reference | ☐ | | | `ContributionPercent_2` | `double` | Contribution Percent 2 | ☐ | | | `ContributionPercent` | `varchar2` | Contribution Percent | ☐ | | | `ContributionValue_2` | `double` | Contribution Value 2 | ☐ | | | `ContributionValue` | `varchar2` | Contribution Value | ☐ | | | `CostCenter_2` | `varchar2` | Cost Centre 2 | ☐ | | | `CostCenter` | `varchar2` | Cost Centre | ☐ | | | `Country` | `varchar2` | Country | ☐ | | | `CreditInvoiceReference` | `varchar2` | Credit Invoice Reference | ☐ | | | `Credit` | `varchar2` | Credit | ☐ | | | `CurrencyRate` | `double` | Currency Rate | ☐ | | | `CurrencyUnit` | `int32` | Currency Unit | ☐ | | | `Currency` | `varchar2` | Currency | ☐ | | | `CustomerName` | `varchar2` | Customer Name | ☐ | | | `CustomerNumber` | `varchar2` | Customer Number | ☐ | | | `DeliveredQuantity` | `varchar2` | Delivered Quantity | ☐ | | | `DeliveryAddress1` | `varchar2(1024)` | Delivery Address 1 | ☐ | | | `DeliveryAddress2` | `varchar2(1024)` | Delivery Address 2 | ☐ | | | `DeliveryCity` | `varchar2(1024)` | Delivery City | ☐ | | | `DeliveryCountry` | `varchar2` | Delivery Country | ☐ | | | `DeliveryDate` | `datetime` | Delivery Date | ☐ | | | `DeliveryName` | `varchar2(1024)` | Delivery Name | ☐ | | | `DeliveryZipCode` | `varchar2(1024)` | Delivery Zip Code | ☐ | | | `Description` | `varchar2(255)` | Description | ☐ | | | `DiscountType` | `varchar2` | Discount Type | ☐ | | | `Discount` | `double` | Discount | ☐ | | | `DocumentNumber` | `varchar2` | Document Number | ☐ | | | `DueDate` | `datetime` | Due Date | ☐ | | | `EDIInformation_EDIGlobalLocationNumberDelivery` | `varchar2(13)` | EDI Information EDI Global Location Number Delivery | ☐ | | | `EDIInformation_EDIGlobalLocationNumber` | `varchar2(13)` | EDI Information EDI Global Location Number | ☐ | | | `EDIInformation_EDIInvoiceExtra1` | `varchar2` | EDI Information EDI Invoice Extra 1 | ☐ | | | `EDIInformation_EDIInvoiceExtra2` | `varchar2` | EDI Information EDI Invoice Extra 2 | ☐ | | | `EDIInformation_EDIOurElectronicReference` | `varchar2` | EDI Information EDI Our Electronic Reference | ☐ | | | `EDIInformation_EDIStatus` | `varchar2` | EDI Information EDI Status | ☐ | | | `EDIInformation_EDIYourElectronicReference` | `varchar2` | EDI Information EDI Your Electronic Reference | ☐ | | | `EUQuarterlyReport` | `char` | EU Quarterly Report | ☐ | | | `EmailInformation_EmailAddressBCC` | `varchar2` | Email Information Email Address Bcc | ☐ | | | `EmailInformation_EmailAddressCC` | `varchar2` | Email Information Email Address CC | ☐ | | | `EmailInformation_EmailAddressFrom` | `varchar2` | Email Information Email Address From | ☐ | | | `EmailInformation_EmailAddressTo` | `varchar2` | Email Information Email Address To | ☐ | | | `EmailInformation_EmailBody` | `varchar2(20000)` | Email Information Email Body | ☐ | | | `EmailInformation_EmailSubject` | `varchar2(100)` | Email Information Email Subject | ☐ | | | `ExternalInvoiceReference1` | `varchar2(80)` | External Invoice Reference 1 | ☐ | | | `ExternalInvoiceReference2` | `varchar2(80)` | External Invoice Reference 2 | ☐ | | | `FinalPayDate` | `datetime` | Final Pay Date | ☐ | | | `FreightVAT` | `double` | Freight VAT | ☐ | | | `Freight` | `double` | Freight | ☐ | | | `Gross` | `double` | Gross | ☐ | | | `HouseWorkHoursToReport` | `int32` | House Work Hours to Report | ☐ | | | `HouseWorkType` | `varchar2` | House Worktype | ☐ | | | `HouseWork_2` | `char` | House Work 2 | ☐ | | | `HouseWork` | `char` | House Work | ☐ | | | `InvoiceDate` | `datetime` | Invoice Date | ☐ | | | `InvoicePeriodEnd` | `datetime` | Invoice Period End | ☐ | | | `InvoicePeriodReference` | `varchar2` | Invoice Period Reference | ☐ | | | `InvoicePeriodStart` | `datetime` | Invoice Period Start | ☐ | | | `InvoiceType` | `varchar2` | Invoice Type | ☐ | | | `Language` | `varchar2` | Language | ☐ | | | `LastRemindDate` | `datetime` | Last Remind Date | ☐ | | | `Net` | `double` | Net | ☐ | | | `NotCompleted` | `char` | Notcompleted | ☐ | | | `NoxFinans` | `char` | Nox Finans | ☐ | | | `OCR` | `varchar2` | Ocr | ☐ | | | `OfferReference` | `varchar2` | Offer Reference | ☐ | | | `OrderReference` | `varchar2` | Order Reference | ☐ | | | `OrganisationNumber` | `varchar2` | Organisation Number | ☐ | | | `OurReference` | `varchar2(50)` | Ourreference | ☐ | | | `OutboundDate` | `datetime` | Outbound Date | ☐ | | | `PaymentWay` | `varchar2` | Payment Way | ☐ | | | `Phone1` | `varchar2(1024)` | Phone 1 | ☐ | | | `Phone2` | `varchar2(1024)` | Phone 2 | ☐ | | | `PriceExcludingVAT` | `double` | Price excluding VAT | ☐ | | | `PriceList` | `varchar2` | Price List | ☐ | | | `Price` | `double` | Price | ☐ | | | `PrintTemplate` | `varchar2` | Print Template | ☐ | | | `Project_2` | `varchar2` | Project 2 | ☐ | | | `Project` | `varchar2` | Project | ☐ | | | `Remarks` | `varchar2(1024)` | Remarks | ☐ | | | `Reminders` | `int32` | Reminders | ☐ | | | `RoundOff` | `double` | Round Off | ☐ | | | `RowId` | `int32` | Row ID | ☐ | | | `Sent` | `char` | Sent | ☐ | | | `StockPointCode` | `varchar2` | Stock Point Code | ☐ | | | `TaxReductionType` | `varchar2` | Tax Reduction Type | ☐ | | | `TaxReduction` | `int32` | Tax Reduction | ☐ | | | `TermsOfDelivery` | `varchar2` | Terms of Delivery | ☐ | | | `TermsOfPayment` | `varchar2` | Terms of Payment | ☐ | | | `TimeBasisReference` | `int32` | Time Basis Reference | ☐ | | | `TotalExcludingVAT` | `double` | Total Excluding VAT | ☐ | | | `TotalToPay` | `double` | Total to Pay | ☐ | | | `TotalVAT` | `double` | Total VAT | ☐ | | | `Total_2` | `double` | Total 2 | ☐ | | | `Total` | `double` | Total | ☐ | | | `Unit` | `varchar2` | Unit | ☐ | | | `VATCode` | `varchar2` | VAT Code | ☐ | | | `VATIncluded` | `char` | Vatincluded | ☐ | | | `VAT` | `int32` | VAT | ☐ | | | `VoucherNumber` | `int32` | Voucher Number | ☐ | | | `VoucherSeries` | `varchar2` | Voucher Series | ☐ | | | `VoucherYear` | `int32` | Voucher Year | ☐ | | | `WarehouseReady` | `char` | Warehouse Ready | ☐ | | | `WayOfDelivery` | `varchar2` | Way of Delivery | ☐ | | | `YourOrderNumber` | `varchar2(75)` | Your Order Number | ☐ | | | `YourReference` | `varchar2(50)` | Your Reference | ☐ | | | `ZipCode` | `varchar2(1024)` | ZIP Code | ☐ | | | `c_urlTaxReductionList` | `varchar2` | URL Tax Reduction List | ☐ | | | `c_url` | `varchar2` | Call URL | ☐ | |