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

# ContractTemplateByTemplateNumber: Fortnox Contract Template by Template Number

`read only` `REST`

- Catalog: `Fortnox`
- Schema: `ContractTemplates`
- Label: Contract Template by Template Number

Retrieve a single contract template

Can only retrieve data.

## API Source

- Endpoint: `/3/contracttemplates/{TemplateNumber}`
- Operation: `get /3/contracttemplates/{TemplateNumber}`

## 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 |
|---|---|:---:|---|---|
| `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). |
| `TemplateNumber` | `` | [x] |  | identifies the contract template |
| `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 `ContractTemplateByTemplateNumber` 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 |
|---|---|---|:---:|---|---|
| `ContractTemplate_AdministrationFee` | `double` | Contract Template Administration Fee | [ ] | filters on the platform, writable, `ContractTemplate.AdministrationFee` |  |
| `ContractTemplate_Continuous` | `char` | Contract Template Continuous | [ ] | filters on the platform, writable, `ContractTemplate.Continuous` |  |
| `ContractTemplate_ContractLength` | `int32` | Contract Template Contract Length | [ ] | filters on the platform, writable, `ContractTemplate.ContractLength` |  |
| `ContractTemplate_Freight` | `double` | Contract Template Freight | [ ] | filters on the platform, writable, `ContractTemplate.Freight` |  |
| `ContractTemplate_InvoiceInterval` | `int32` | Contract Template Invoice Interval | [ ] | filters on the platform, writable, `ContractTemplate.InvoiceInterval` |  |
| `ContractTemplate_OurReference` | `varchar2(25)` | Contract Template Ourreference | [ ] | filters on the platform, writable, `ContractTemplate.OurReference` |  |
| `ContractTemplate_PrintTemplate` | `varchar2` | Contract Template Print Template | [ ] | filters on the platform, writable, `ContractTemplate.PrintTemplate` |  |
| `ContractTemplate_Remarks` | `varchar2(1024)` | Contract Template Remarks | [ ] | filters on the platform, writable, `ContractTemplate.Remarks` |  |
| `ContractTemplate_TemplateName` | `varchar2(1024)` | Contract Template Name | [ ] | filters on the platform, writable, `ContractTemplate.TemplateName` |  |
| `ContractTemplate_TemplateNumber` | `int32` | Contract Template Number | [ ] | filters on the platform, writable, `ContractTemplate.TemplateNumber` |  |
| `ContractTemplate_TermsOfDelivery` | `varchar2` | Contract Template Terms of Delivery | [ ] | filters on the platform, writable, `ContractTemplate.TermsOfDelivery` |  |
| `ContractTemplate_TermsOfPayment` | `varchar2` | Contract Template Terms of Payment | [ ] | filters on the platform, writable, `ContractTemplate.TermsOfPayment` |  |
| `ContractTemplate_WayOfDelivery` | `varchar2` | Contract Template Way of Delivery | [ ] | filters on the platform, writable, `ContractTemplate.WayOfDelivery` |  |
| `ContractTemplate__url` | `varchar2` | Contract Template URL | [ ] | filters on the platform, writable, `ContractTemplate.@url` |  |



## Release Notes

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

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

