invantive documentation
Invantive Support ForumsLog In / Sign Up

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 `` 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: