OrderByDocumentNumber: Fortnox Order by Document Number
read only REST
- Catalog:
Fortnox - Schema:
Orders - Label: Order by Document Number
Retrieve a single order
Can only retrieve data.
API Source
- Endpoint:
/3/orders/{DocumentNumber} - Operation:
get /3/orders/{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 |
|---|---|---|---|---|
Document |
`` | identifies the order | ||
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 OrderByDocumentNumber 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 |
|---|---|---|---|---|---|
Order_ |
varchar2 |
Order Address 1 | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Address 2 | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Administration Fee | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Administration Fee VAT | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Basis Tax Reduction | filters on the platform, writable, Order. |
||
Order_ |
char |
Order Cancelled | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order City | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Comments | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Contribution Percent | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Contribution Value | filters on the platform, writable, Order. |
||
Order_ |
char |
Order Copy Remarks | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Cost Centre | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Country | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Currency | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Currency Rate | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Currency Unit | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Customer Name | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Customernumber | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Delivery Address 1 | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Delivery Address 2 | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Delivery City | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Delivery Country | filters on the platform, writable, Order. |
||
Order_ |
datetime |
Order Delivery Date | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Delivery Name | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Delivery State | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Delivery Zip Code | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Document Number | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Email Information Email Address Bcc | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Email Information Email Address CC | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Email Information Email Address From | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Email Information Email Address To | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Email Information Email Body | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Email Information Email Subject | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order External Invoice Reference 1 | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order External Invoice Reference 2 | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Freight | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Freight VAT | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Gross | filters on the platform, writable, Order. |
||
Order_ |
char |
Order House Work | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Invoice Reference | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Language | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Net | filters on the platform, writable, Order. |
||
Order_ |
char |
Order Notcompleted | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Offer Reference | filters on the platform, writable, Order. |
||
Order_ |
datetime |
Order Date | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Type | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Organisation Number | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Ourreference | filters on the platform, writable, Order. |
||
Order_ |
datetime |
Order Outbound Date | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Phone 1 | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Phone 2 | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Pricelist | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Print Template | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Project | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Remarks | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Round Off | filters on the platform, writable, Order. |
||
Order_ |
char |
Order Sent | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Stock Point Code | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Stock Point ID | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Tax Reduction | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Tax Reduction Type | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Terms of Delivery | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Terms of Payment | filters on the platform, writable, Order. |
||
Order_ |
int32 |
Order Time Basis Reference | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Total | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Total to Pay | filters on the platform, writable, Order. |
||
Order_ |
double |
Order Total VAT | filters on the platform, writable, Order. |
||
Order_ |
char |
Order Vatincluded | filters on the platform, writable, Order. |
||
Order_ |
char |
Order Warehouse Ready | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Way of Delivery | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Your Order Number | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Your Reference | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order Zip Code | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order URL | filters on the platform, writable, Order. |
||
Order_ |
varchar2 |
Order URL Tax Reduction List | filters on the platform, writable, Order. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: