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

# ContractByDocumentNumber: Fortnox Contract by Document Number

`read only` `REST`

- Catalog: `Fortnox`
- Schema: `Contracts`
- Label: Contract by Document Number

Retrieve a single contract

Can only retrieve data.

## API Source

- Endpoint: `/3/contracts/{DocumentNumber}`
- Operation: `get /3/contracts/{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 contract |
| `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 `ContractByDocumentNumber` 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 |
|---|---|---|:---:|---|---|
| `Contract_Active` | `char` | Contract Active | [ ] | filters on the platform, writable, `Contract.Active` |  |
| `Contract_AdministrationFee` | `double` | Contract Administration Fee | [ ] | filters on the platform, writable, `Contract.AdministrationFee` |  |
| `Contract_BasisTaxReduction` | `double` | Contract Basis Tax Reduction | [ ] | filters on the platform, writable, `Contract.BasisTaxReduction` |  |
| `Contract_Comments` | `varchar2(1024)` | Contract Comments | [ ] | filters on the platform, writable, `Contract.Comments` |  |
| `Contract_Continuous` | `char` | Contract Continuous | [ ] | filters on the platform, writable, `Contract.Continuous` |  |
| `Contract_ContractDate` | `datetime` | Contract Date | [ ] | filters on the platform, writable, `Contract.ContractDate` |  |
| `Contract_ContractLength` | `int32` | Contract Length | [ ] | filters on the platform, writable, `Contract.ContractLength` |  |
| `Contract_ContributionPercent` | `double` | Contract Contribution Percent | [ ] | filters on the platform, writable, `Contract.ContributionPercent` |  |
| `Contract_ContributionValue` | `double` | Contract Contribution Value | [ ] | filters on the platform, writable, `Contract.ContributionValue` |  |
| `Contract_CostCenter` | `varchar2` | Contract Cost Centre | [ ] | filters on the platform, writable, `Contract.CostCenter` |  |
| `Contract_Currency` | `varchar2` | Contract Currency | [ ] | filters on the platform, writable, `Contract.Currency` |  |
| `Contract_CustomerName` | `varchar2` | Contract Customer Name | [ ] | filters on the platform, writable, `Contract.CustomerName` |  |
| `Contract_CustomerNumber` | `varchar2` | Contract Customernumber | [ ] | filters on the platform, writable, `Contract.CustomerNumber` |  |
| `Contract_DocumentNumber` | `varchar2` | Contract Document Number | [ ] | filters on the platform, writable, `Contract.DocumentNumber` |  |
| `Contract_EmailInformation_EmailAddressBCC` | `varchar2` | Contract Email Information Email Address Bcc | [ ] | filters on the platform, writable, `Contract.EmailInformation.EmailAddressBCC` |  |
| `Contract_EmailInformation_EmailAddressCC` | `varchar2` | Contract Email Information Email Address CC | [ ] | filters on the platform, writable, `Contract.EmailInformation.EmailAddressCC` |  |
| `Contract_EmailInformation_EmailAddressFrom` | `varchar2` | Contract Email Information Email Address From | [ ] | filters on the platform, writable, `Contract.EmailInformation.EmailAddressFrom` |  |
| `Contract_EmailInformation_EmailAddressTo` | `varchar2` | Contract Email Information Email Address To | [ ] | filters on the platform, writable, `Contract.EmailInformation.EmailAddressTo` |  |
| `Contract_EmailInformation_EmailBody` | `varchar2` | Contract Email Information Email Body | [ ] | filters on the platform, writable, `Contract.EmailInformation.EmailBody` |  |
| `Contract_EmailInformation_EmailSubject` | `varchar2` | Contract Email Information Email Subject | [ ] | filters on the platform, writable, `Contract.EmailInformation.EmailSubject` |  |
| `Contract_ExternalInvoiceReference1` | `varchar2` | Contract External Invoice Reference 1 | [ ] | filters on the platform, writable, `Contract.ExternalInvoiceReference1` |  |
| `Contract_ExternalInvoiceReference2` | `varchar2` | Contract External Invoice Reference 2 | [ ] | filters on the platform, writable, `Contract.ExternalInvoiceReference2` |  |
| `Contract_Freight` | `double` | Contract Freight | [ ] | filters on the platform, writable, `Contract.Freight` |  |
| `Contract_Gross` | `double` | Contract Gross | [ ] | filters on the platform, writable, `Contract.Gross` |  |
| `Contract_HouseWork` | `char` | Contract House Work | [ ] | filters on the platform, writable, `Contract.HouseWork` |  |
| `Contract_InvoiceDiscount` | `double` | Contract Invoice Discount | [ ] | filters on the platform, writable, `Contract.InvoiceDiscount` |  |
| `Contract_InvoiceInterval` | `int32` | Contract Invoice Interval | [ ] | filters on the platform, writable, `Contract.InvoiceInterval` |  |
| `Contract_InvoicesRemaining` | `varchar2` | Contract Invoices Remaining | [ ] | filters on the platform, writable, `Contract.InvoicesRemaining` |  |
| `Contract_Language` | `varchar2` | Contract Language | [ ] | filters on the platform, writable, `Contract.Language` |  |
| `Contract_LastInvoiceDate` | `varchar2` | Contract Last Invoice Date | [ ] | filters on the platform, writable, `Contract.LastInvoiceDate` |  |
| `Contract_Net` | `double` | Contract Net | [ ] | filters on the platform, writable, `Contract.Net` |  |
| `Contract_OurReference` | `varchar2(25)` | Contract Ourreference | [ ] | filters on the platform, writable, `Contract.OurReference` |  |
| `Contract_PeriodEnd` | `datetime` | Contract Period End | [ ] | filters on the platform, writable, `Contract.PeriodEnd` |  |
| `Contract_PeriodStart` | `datetime` | Contract Period Start | [ ] | filters on the platform, writable, `Contract.PeriodStart` |  |
| `Contract_PriceList` | `varchar2` | Contract Pricelist | [ ] | filters on the platform, writable, `Contract.PriceList` |  |
| `Contract_PrintTemplate` | `varchar2` | Contract Print Template | [ ] | filters on the platform, writable, `Contract.PrintTemplate` |  |
| `Contract_Project` | `varchar2` | Contract Project | [ ] | filters on the platform, writable, `Contract.Project` |  |
| `Contract_Remarks` | `varchar2(1024)` | Contract Remarks | [ ] | filters on the platform, writable, `Contract.Remarks` |  |
| `Contract_RoundOff` | `double` | Contract Round Off | [ ] | filters on the platform, writable, `Contract.RoundOff` |  |
| `Contract_TaxReduction` | `double` | Contract Tax Reduction | [ ] | filters on the platform, writable, `Contract.TaxReduction` |  |
| `Contract_TaxReductionType` | `varchar2` | Contract Tax Reduction Type | [ ] | filters on the platform, writable, `Contract.TaxReductionType` |  |
| `Contract_TemplateName` | `varchar2` | Contract Template Name | [ ] | filters on the platform, writable, `Contract.TemplateName` |  |
| `Contract_TemplateNumber` | `int32` | Contract Template Number | [ ] | filters on the platform, writable, `Contract.TemplateNumber` |  |
| `Contract_TermsOfDelivery` | `varchar2` | Contract Terms of Delivery | [ ] | filters on the platform, writable, `Contract.TermsOfDelivery` |  |
| `Contract_TermsOfPayment` | `varchar2` | Contract Terms of Payment | [ ] | filters on the platform, writable, `Contract.TermsOfPayment` |  |
| `Contract_Total` | `double` | Contract Total | [ ] | filters on the platform, writable, `Contract.Total` |  |
| `Contract_TotalToPay` | `double` | Contract Total to Pay | [ ] | filters on the platform, writable, `Contract.TotalToPay` |  |
| `Contract_TotalVAT` | `double` | Contract Total VAT | [ ] | filters on the platform, writable, `Contract.TotalVAT` |  |
| `Contract_VatIncluded` | `char` | Contract Vatincluded | [ ] | filters on the platform, writable, `Contract.VatIncluded` |  |
| `Contract_WayOfDelivery` | `varchar2` | Contract Way of Delivery | [ ] | filters on the platform, writable, `Contract.WayOfDelivery` |  |
| `Contract_YourOrderNumber` | `varchar2(75)` | Contract Your Order Number | [ ] | filters on the platform, writable, `Contract.YourOrderNumber` |  |
| `Contract_YourReference` | `varchar2` | Contract Your Reference | [ ] | filters on the platform, writable, `Contract.YourReference` |  |
| `Contract__url` | `varchar2` | Contract URL | [ ] | filters on the platform, writable, `Contract.@url` |  |
| `Contract__urlTaxReductionList` | `varchar2` | Contract URL Tax Reduction List | [ ] | filters on the platform, writable, `Contract.@urlTaxReductionList` |  |



## Release Notes

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

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

