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

# CustomerByNumber: Fortnox Customer by Number

`read only` `REST`

- Catalog: `Fortnox`
- Schema: `Customers`
- Label: Customer by Number

Retrieve a customer
You need to supply the unique customer number that was returned when the customer was created or retrieved from the list of customers.

Can only retrieve data.

## Summary

You need to supply the unique customer number that was returned when the customer was created or retrieved from the list of customers.

## API Source

- Endpoint: `/3/customers/{CustomerNumber}`
- Operation: `get /3/customers/{CustomerNumber}`

## 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 |
|---|---|:---:|---|---|
| `CustomerNumber` | `` | [x] |  | identifies the customer |
| `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 `CustomerByNumber` 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 |
|---|---|---|:---:|---|---|
| `Customer_Active` | `char` | Customer Active | [ ] | filters on the platform, writable, `Customer.Active` |  |
| `Customer_Address1` | `varchar2(1024)` | Customer Address 1 | [ ] | filters on the platform, writable, `Customer.Address1` |  |
| `Customer_Address2` | `varchar2(1024)` | Customer Address 2 | [ ] | filters on the platform, writable, `Customer.Address2` |  |
| `Customer_City` | `varchar2(1024)` | Customer City | [ ] | filters on the platform, writable, `Customer.City` |  |
| `Customer_Comments` | `varchar2(1024)` | Customer Comments | [ ] | filters on the platform, writable, `Customer.Comments` |  |
| `Customer_CostCenter` | `varchar2` | Customer Cost Centre | [ ] | filters on the platform, writable, `Customer.CostCenter` |  |
| `Customer_Country` | `varchar2` | Customer Country | [ ] | filters on the platform, writable, `Customer.Country` |  |
| `Customer_CountryCode` | `varchar2(2)` | Customer Country Code | [ ] | filters on the platform, writable, `Customer.CountryCode` |  |
| `Customer_Currency` | `varchar2(3)` | Customer Currency | [ ] | filters on the platform, writable, `Customer.Currency` |  |
| `Customer_CustomerNumber` | `varchar2(1024)` | Customer Customernumber | [ ] | filters on the platform, writable, `Customer.CustomerNumber` |  |
| `Customer_DefaultDeliveryTypes_Invoice` | `varchar2` | Customer Default Delivery Types Invoice | [ ] | filters on the platform, writable, `Customer.DefaultDeliveryTypes.Invoice` |  |
| `Customer_DefaultDeliveryTypes_Offer` | `varchar2` | Customer Default Delivery Types Offer | [ ] | filters on the platform, writable, `Customer.DefaultDeliveryTypes.Offer` |  |
| `Customer_DefaultDeliveryTypes_Order` | `varchar2` | Customer Default Delivery Types Order | [ ] | filters on the platform, writable, `Customer.DefaultDeliveryTypes.Order` |  |
| `Customer_DefaultTemplates_CashInvoice` | `varchar2` | Customer Default Templates Cash Invoice | [ ] | filters on the platform, writable, `Customer.DefaultTemplates.CashInvoice` |  |
| `Customer_DefaultTemplates_Invoice` | `varchar2` | Customer Default Templates Invoice | [ ] | filters on the platform, writable, `Customer.DefaultTemplates.Invoice` |  |
| `Customer_DefaultTemplates_Offer` | `varchar2` | Customer Default Templates Offer | [ ] | filters on the platform, writable, `Customer.DefaultTemplates.Offer` |  |
| `Customer_DefaultTemplates_Order` | `varchar2` | Customer Default Templates Order | [ ] | filters on the platform, writable, `Customer.DefaultTemplates.Order` |  |
| `Customer_DeliveryAddress1` | `varchar2(1024)` | Customer Delivery Address 1 | [ ] | filters on the platform, writable, `Customer.DeliveryAddress1` |  |
| `Customer_DeliveryAddress2` | `varchar2(1024)` | Customer Delivery Address 2 | [ ] | filters on the platform, writable, `Customer.DeliveryAddress2` |  |
| `Customer_DeliveryCity` | `varchar2(1024)` | Customer Delivery City | [ ] | filters on the platform, writable, `Customer.DeliveryCity` |  |
| `Customer_DeliveryCountry` | `varchar2(1024)` | Customer Delivery Country | [ ] | filters on the platform, writable, `Customer.DeliveryCountry` |  |
| `Customer_DeliveryCountryCode` | `varchar2(2)` | Customer Delivery Country Code | [ ] | filters on the platform, writable, `Customer.DeliveryCountryCode` |  |
| `Customer_DeliveryFax` | `varchar2(1024)` | Customer Delivery Fax | [ ] | filters on the platform, writable, `Customer.DeliveryFax` |  |
| `Customer_DeliveryName` | `varchar2(1024)` | Customer Delivery Name | [ ] | filters on the platform, writable, `Customer.DeliveryName` |  |
| `Customer_DeliveryPhone1` | `varchar2(1024)` | Customer Delivery Phone 1 | [ ] | filters on the platform, writable, `Customer.DeliveryPhone1` |  |
| `Customer_DeliveryPhone2` | `varchar2(1024)` | Customer Delivery Phone 2 | [ ] | filters on the platform, writable, `Customer.DeliveryPhone2` |  |
| `Customer_DeliveryZipCode` | `varchar2(10)` | Customer Delivery Zip Code | [ ] | filters on the platform, writable, `Customer.DeliveryZipCode` |  |
| `Customer_Email` | `varchar2(1024)` | Customer Email | [ ] | filters on the platform, writable, `Customer.Email` |  |
| `Customer_EmailInvoice` | `varchar2(1024)` | Customer Email Invoice | [ ] | filters on the platform, writable, `Customer.EmailInvoice` |  |
| `Customer_EmailInvoiceBCC` | `varchar2(1024)` | Customer Email Invoice Bcc | [ ] | filters on the platform, writable, `Customer.EmailInvoiceBCC` |  |
| `Customer_EmailInvoiceCC` | `varchar2(1024)` | Customer Email Invoice CC | [ ] | filters on the platform, writable, `Customer.EmailInvoiceCC` |  |
| `Customer_EmailOffer` | `varchar2(1024)` | Customer Email Offer | [ ] | filters on the platform, writable, `Customer.EmailOffer` |  |
| `Customer_EmailOfferBCC` | `varchar2(1024)` | Customer Email Offer Bcc | [ ] | filters on the platform, writable, `Customer.EmailOfferBCC` |  |
| `Customer_EmailOfferCC` | `varchar2(1024)` | Customer Email Offer CC | [ ] | filters on the platform, writable, `Customer.EmailOfferCC` |  |
| `Customer_EmailOrder` | `varchar2(1024)` | Customer Email Order | [ ] | filters on the platform, writable, `Customer.EmailOrder` |  |
| `Customer_EmailOrderBCC` | `varchar2(1024)` | Customer Email Order Bcc | [ ] | filters on the platform, writable, `Customer.EmailOrderBCC` |  |
| `Customer_EmailOrderCC` | `varchar2(1024)` | Customer Email Order CC | [ ] | filters on the platform, writable, `Customer.EmailOrderCC` |  |
| `Customer_ExternalReference` | `varchar2(1024)` | Customer External Reference | [ ] | filters on the platform, writable, `Customer.ExternalReference` |  |
| `Customer_Fax` | `varchar2(1024)` | Customer Fax | [ ] | filters on the platform, writable, `Customer.Fax` |  |
| `Customer_GLN` | `varchar2(13)` | Customer Gln | [ ] | filters on the platform, writable, `Customer.GLN` |  |
| `Customer_GLNDelivery` | `varchar2(13)` | Customer Gln Delivery | [ ] | filters on the platform, writable, `Customer.GLNDelivery` |  |
| `Customer_InvoiceAdministrationFee` | `varchar2` | Customer Invoice Administration Fee | [ ] | filters on the platform, writable, `Customer.InvoiceAdministrationFee` |  |
| `Customer_InvoiceDiscount` | `double` | Customer Invoice Discount | [ ] | filters on the platform, writable, `Customer.InvoiceDiscount` |  |
| `Customer_InvoiceFreight` | `varchar2` | Customer Invoice Freight | [ ] | filters on the platform, writable, `Customer.InvoiceFreight` |  |
| `Customer_InvoiceRemark` | `varchar2(1024)` | Customer Invoice Remark | [ ] | filters on the platform, writable, `Customer.InvoiceRemark` |  |
| `Customer_Name` | `varchar2(1024)` | Customer Name | [ ] | filters on the platform, writable, `Customer.Name` |  |
| `Customer_OrganisationNumber` | `varchar2` | Customer Organisation Number | [ ] | filters on the platform, writable, `Customer.OrganisationNumber` |  |
| `Customer_OurReference` | `varchar2(50)` | Customer Ourreference | [ ] | filters on the platform, writable, `Customer.OurReference` |  |
| `Customer_Phone1` | `varchar2(1024)` | Customer Phone 1 | [ ] | filters on the platform, writable, `Customer.Phone1` |  |
| `Customer_Phone2` | `varchar2(1024)` | Customer Phone 2 | [ ] | filters on the platform, writable, `Customer.Phone2` |  |
| `Customer_PriceList` | `varchar2` | Customer Pricelist | [ ] | filters on the platform, writable, `Customer.PriceList` |  |
| `Customer_Project` | `varchar2` | Customer Project | [ ] | filters on the platform, writable, `Customer.Project` |  |
| `Customer_SalesAccount` | `varchar2(4)` | Customer Sales Account | [ ] | filters on the platform, writable, `Customer.SalesAccount` |  |
| `Customer_ShowPriceVATIncluded` | `char` | Customer Show Price Vatincluded | [ ] | filters on the platform, writable, `Customer.ShowPriceVATIncluded` |  |
| `Customer_TermsOfDelivery` | `varchar2` | Customer Terms of Delivery | [ ] | filters on the platform, writable, `Customer.TermsOfDelivery` |  |
| `Customer_TermsOfPayment` | `varchar2` | Customer Terms of Payment | [ ] | filters on the platform, writable, `Customer.TermsOfPayment` |  |
| `Customer_Type` | `varchar2` | Customer Type | [ ] | filters on the platform, writable, `Customer.Type` |  |
| `Customer_VATNumber` | `varchar2` | Customer VAT Number | [ ] | filters on the platform, writable, `Customer.VATNumber` |  |
| `Customer_VATType` | `varchar2` | Customer VAT Type | [ ] | filters on the platform, writable, `Customer.VATType` |  |
| `Customer_VisitingAddress` | `varchar2(128)` | Customer Visiting Address | [ ] | filters on the platform, writable, `Customer.VisitingAddress` |  |
| `Customer_VisitingCity` | `varchar2(128)` | Customer Visiting City | [ ] | filters on the platform, writable, `Customer.VisitingCity` |  |
| `Customer_VisitingCountry` | `varchar2(128)` | Customer Visiting Country | [ ] | filters on the platform, writable, `Customer.VisitingCountry` |  |
| `Customer_VisitingCountryCode` | `varchar2(2)` | Customer Visiting Country Code | [ ] | filters on the platform, writable, `Customer.VisitingCountryCode` |  |
| `Customer_VisitingZipCode` | `varchar2(10)` | Customer Visiting Zip Code | [ ] | filters on the platform, writable, `Customer.VisitingZipCode` |  |
| `Customer_WWW` | `varchar2(128)` | Customer Www | [ ] | filters on the platform, writable, `Customer.WWW` |  |
| `Customer_WayOfDelivery` | `varchar2` | Customer Way of Delivery | [ ] | filters on the platform, writable, `Customer.WayOfDelivery` |  |
| `Customer_YourReference` | `varchar2(50)` | Customer Your Reference | [ ] | filters on the platform, writable, `Customer.YourReference` |  |
| `Customer_ZipCode` | `varchar2(10)` | Customer Zip Code | [ ] | filters on the platform, writable, `Customer.ZipCode` |  |
| `Customer__url` | `varchar2` | Customer URL | [ ] | filters on the platform, writable, `Customer.@url` |  |



## Release Notes

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

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

