---
title: "InvoiceByDocumentNumber (Fortnox)"
description: "Invoice by Document Number"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.Invoices.InvoiceByDocumentNumber
original: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.Invoices.InvoiceByDocumentNumber
updated: 2026-11-01T16:13:15Z
license: https://documentation.invantive.eu/en/
---

# InvoiceByDocumentNumber: Fortnox Invoice by Document Number

`read only` `REST`

- Catalog: `Fortnox`
- Schema: `Invoices`
- Label: Invoice by Document Number

Retrieve a single invoice

Can only retrieve data.

## API Source

- Endpoint: `/3/invoices/{DocumentNumber}`
- Operation: `get /3/invoices/{DocumentNumber}`

## 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` | `` | [x] |  | 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 `InvoiceByDocumentNumber` 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:

- [Fortnox](/en/release-notes/drivers?driver=fortnox)

