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 |
|---|---|---|---|---|
Customer |
`` | 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_ |
char |
Customer Active | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Address 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Address 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer City | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Comments | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Cost Centre | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Country | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Country Code | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Currency | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Customernumber | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Default Delivery Types Invoice | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Default Delivery Types Offer | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Default Delivery Types Order | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Default Templates Cash Invoice | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Default Templates Invoice | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Default Templates Offer | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Default Templates Order | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Address 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Address 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery City | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Country | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Country Code | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Fax | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Name | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Phone 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Phone 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Delivery Zip Code | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Invoice | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Invoice Bcc | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Invoice CC | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Offer | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Offer Bcc | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Offer CC | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Order | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Order Bcc | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Email Order CC | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer External Reference | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Fax | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Gln | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Gln Delivery | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Invoice Administration Fee | filters on the platform, writable, Customer. |
||
Customer_ |
double |
Customer Invoice Discount | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Invoice Freight | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Invoice Remark | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Name | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Organisation Number | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Ourreference | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Phone 1 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Phone 2 | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Pricelist | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Project | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Sales Account | filters on the platform, writable, Customer. |
||
Customer_ |
char |
Customer Show Price Vatincluded | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Terms of Delivery | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Terms of Payment | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Type | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer VAT Number | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer VAT Type | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Visiting Address | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Visiting City | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Visiting Country | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Visiting Country Code | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Visiting Zip Code | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Www | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Way of Delivery | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Your Reference | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer Zip Code | filters on the platform, writable, Customer. |
||
Customer_ |
varchar2 |
Customer URL | filters on the platform, writable, Customer. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: