IncomingGoodDocuments: Fortnox Incoming Good Documents
insert update REST
- Catalog:
Fortnox - Schema:
WarehouseIncomingGoods - Primary Keys:
id - Label: Incoming Good Documents
List Incoming Goods Documents
List incoming goods documents matching the given parameters.
Sortable fields:
id,
has_delivery_note,
delivery_note_id,
supplier_number,
date
Can retrieve data and change data using insert and update.
Summary
List incoming goods documents matching the given parameters.
Sortable fields:
id,
has_delivery_note,
delivery_note_id,
supplier_number,
date
API Source
- Endpoint:
/api/warehouse/incominggoods-v1 - Operation:
get /api/warehouse/incominggoods-v1
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 356 |
| Full scan rows per minute | 51,500 |
| Point query rows per minute | 168 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
completed |
`` | true to include only completed documents. false to include only non-completed documents. |
||
delivery |
`` | Include only documents where delivery-field contains the given text (case-insensitive). |
||
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). | ||
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). |
||
q |
`` | Include only documents where id or delivery-field contains the given text (case-insensitive). |
||
released |
`` | true to include only released documents. false to include only non-released documents. |
||
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). | ||
voided |
`` | true to include only voided documents. false to include only non-voided documents. |
Table Columns
The columns of the table IncomingGoodDocuments 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 |
|---|---|---|---|---|---|
completed |
char |
Completed | filters on the platform, writable, completed |
||
date |
datetime |
Date | filters on the platform, writable, date |
||
delivery |
varchar2 |
Delivery Note ID | filters on the platform, writable, delivery |
||
has |
char |
Has Delivery Note | filters on the platform, writable, has |
||
id |
int64 |
ID | filters on the platform, writable, id |
||
note |
varchar2 |
Note | filters on the platform, writable, note |
||
released |
char |
Released | filters on the platform, writable, released |
||
stock |
guid |
Stock Point ID | filters on the platform, writable, stock |
||
supplier |
varchar2 |
Supplier Name | filters on the platform, writable, supplier |
||
supplier |
varchar2 |
Supplier Number | filters on the platform, writable, supplier |
||
unmatched |
decimal |
Unmatched Value | filters on the platform, writable, unmatched |
||
voided |
char |
Voided | filters on the platform, writable, voided |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: