ProductionOrderRowNotes: Fortnox Production Order Row Notes
read only REST
- Catalog:
Fortnox - Schema:
WarehousePurchaseOrders - Label: Production Order Row Notes
List Purchase Orders
List purchase orders matching the given parameters.
Sortable fields: id, supplier_number, order_date, internal_reference, response_state, delivery_date
Can only retrieve data.
Summary
List purchase orders matching the given parameters.
Sortable fields:
id,
supplier_number,
order_date,
internal_reference,
response_state,
delivery_date
API Source
- Endpoint:
/api/warehouse/purchaseorders-v1 - Operation:
get /api/warehouse/purchaseorders-v1
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). | ||
internal |
`` | Include only documents where `internalReference' contains the given text (case-insensitive). | ||
itemId |
`` | Include only documents with the given itemId. |
||
lastmodified |
`` | Retrieves all records since the provided timestamp (does not work on every table). | ||
note |
`` | Include only documents where note-field contains the given text (case-insensitive). |
||
purchase |
`` | Include only documents with the given purchase (Values: WAREHOUSE, DROPSHIP) |
||
q |
`` | Include only documents where id or internal-field contains the given text (case-insensitive). |
||
state |
`` | Include only documents with the given purchase. (Values: NOT_SENT, SENT, SENT_NOT_REJECTED, DELAYED, RECEIVED, VOIDED, CURRENT, ALL) |
||
supplier |
`` | Include only documents with the given supplier. |
||
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 ProductionOrderRowNotes 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 |
|---|---|---|---|---|---|
back |
decimal |
Backorder Quantity | writable, ::ancestor. |
||
confirmation |
varchar2 |
Confirmation Email | filters on the platform, writable, ::ancestor. |
||
cost |
varchar2 |
Cost Centre Code | writable, ::ancestor. |
||
cost |
varchar2 |
Cost Centre Code 2 | filters on the platform, writable, ::ancestor. |
||
currency |
varchar2 |
Currency Code | writable, ::ancestor. |
||
currency |
varchar2 |
Currency Code 2 | filters on the platform, writable, ::ancestor. |
||
currency |
decimal |
Currency Rate | filters on the platform, writable, ::ancestor. |
||
currency |
int32 |
Currency Unit | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Customer ID | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Customer Name | filters on the platform, writable, ::ancestor. |
||
customer |
varchar2 |
Customer Number | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Address | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Address 2 | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery City | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Country Code | filters on the platform, writable, ::ancestor. |
||
delivery |
datetime |
Delivery Date | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Name | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Zip Code | filters on the platform, writable, ::ancestor. |
||
dropship |
char |
Dropship | filters on the platform, writable, ::ancestor. |
||
id |
guid |
ID | writable, ::ancestor. |
||
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
||
internal |
varchar2 |
Internal Reference | filters on the platform, writable, ::ancestor. |
||
is |
char |
Is Stock Item | writable, ::ancestor. |
||
item |
varchar2 |
Item Description | writable, ::ancestor. |
||
itemId |
varchar2 |
Item ID | writable, ::ancestor. |
||
item |
varchar2 |
Item Unit | writable, ::ancestor. |
||
language |
varchar2 |
Language Code | filters on the platform, writable, ::ancestor. |
||
manually |
char |
Manually Completed | filters on the platform, writable, ::ancestor. |
||
message |
varchar2 |
Message to Supplier | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
||
note_2 |
varchar2 |
Note 2 | filters on the platform, writable, ::ancestor. |
||
order |
datetime |
Order Date | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Order Value | filters on the platform, writable, ::ancestor. |
||
order |
decimal |
Order Value in SEK | filters on the platform, writable, ::ancestor. |
||
ordered |
decimal |
Ordered Quantity | writable, ::ancestor. |
||
our |
varchar2 |
Ourreference | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Outbound Document Reference ID | filters on the platform, writable, ::ancestor. |
||
outbound |
varchar2 |
Outbound Document Reference Type | filters on the platform, writable, ::ancestor. |
||
payment |
varchar2 |
Payment Terms Code | filters on the platform, writable, ::ancestor. |
||
price |
decimal |
Price | writable, ::ancestor. |
||
project |
varchar2 |
Project ID | writable, ::ancestor. |
||
project |
varchar2 |
Projectid 2 | filters on the platform, writable, ::ancestor. |
||
purchase |
int64 |
Purchase Order ID | writable, purchase |
||
purchase |
int64 |
Purchase Order ID 2 | writable, ::ancestor. |
||
purchase |
guid |
Purchase Order Rowid | writable, purchase |
||
purchase |
varchar2 |
Purchase Order State | filters on the platform, writable, ::ancestor. |
||
purchase |
varchar2 |
Purchase Type | filters on the platform, writable, ::ancestor. |
||
received |
decimal |
Received Quantity | writable, ::ancestor. |
||
remaining |
decimal |
Remaining Ordered Quantity | writable, ::ancestor. |
||
response |
varchar2 |
Response State | filters on the platform, writable, ::ancestor. |
||
rowNum |
int64 |
Row Number | writable, rowNum |
||
row |
int64 |
Row Number 2 | writable, ::ancestor. |
||
stock |
varchar2 |
Stock Location Code | writable, ::ancestor. |
||
stock |
guid |
Stock Location ID | writable, ::ancestor. |
||
stock |
varchar2 |
Stock Location Name | writable, ::ancestor. |
||
stock |
varchar2 |
Stock Point Code | writable, ::ancestor. |
||
stock |
varchar2 |
Stock Point Code 2 | filters on the platform, writable, ::ancestor. |
||
stock |
guid |
Stock Point ID | writable, ::ancestor. |
||
stock |
guid |
Stock Point ID 2 | filters on the platform, writable, ::ancestor. |
||
stock |
varchar2 |
Stock Point Name | writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier Address | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier Address 2 | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier City | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier Country Code | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier Email | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier Name | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier Number | filters on the platform, writable, ::ancestor. |
||
supplier |
varchar2 |
Supplier Postcode | filters on the platform, writable, ::ancestor. |
||
total |
decimal |
Total Received Quantity | filters on the platform, writable, ::ancestor. |
||
translated |
varchar2 |
Translated Response State | filters on the platform, writable, ::ancestor. |
||
voided |
char |
Voided | filters on the platform, writable, ::ancestor. |
||
your |
varchar2 |
Your Reference | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: