IncomingGoodDocumentLinesById: Fortnox Incoming Good Document Lines by ID
read only REST
- Catalog:
Fortnox - Schema:
WarehouseIncomingGoods - Label: Incoming Good Document Lines by ID
Get Incoming Goods document
Can only retrieve data.
API Source
- Endpoint:
/api/warehouse/incominggoods-v1/{id} - Operation:
get /api/warehouse/incominggoods-v1/{id}
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). | ||
id |
`` | Incoming goods document id. | ||
ignore |
`` | This Supplier Invoice id will be excluded when calculating the takenQuantity. | ||
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 IncomingGoodDocumentLinesById 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, back |
||
batch |
varchar2 |
Batch | writable, batch |
||
completed |
char |
Completed | filters on the platform, writable, ::ancestor. |
||
cost |
varchar2 |
Cost Centre Code | writable, cost |
||
cost |
varchar2 |
Cost Centre Code 2 | filters on the platform, writable, ::ancestor. |
||
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
||
delivery |
varchar2 |
Delivery Note ID | filters on the platform, writable, ::ancestor. |
||
direct |
decimal |
Direct Cost | writable, direct |
||
has |
char |
Has Delivery Note | filters on the platform, writable, ::ancestor. |
||
id |
guid |
ID | writable, id |
||
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
||
invoiced |
decimal |
Invoiced Quantity | writable, invoiced |
||
is |
char |
Is Stock Item | writable, is |
||
item |
varchar2 |
Item Description | writable, item |
||
itemId |
varchar2 |
Item ID | writable, itemId |
||
item |
varchar2 |
Item Unit | writable, item |
||
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
||
ordered |
decimal |
Ordered Quantity | writable, ordered |
||
project |
varchar2 |
Project ID | writable, project |
||
project |
varchar2 |
Projectid 2 | filters on the platform, writable, ::ancestor. |
||
purchase |
int64 |
Purchase Order ID | writable, purchase |
||
purchase |
guid |
Purchase Order Rowid | writable, purchase |
||
received |
decimal |
Received Quantity | writable, received |
||
released |
char |
Released | filters on the platform, writable, ::ancestor. |
||
remaining |
decimal |
Remaining Ordered Quantity | writable, remaining |
||
row |
int32 |
Row Order | writable, row |
||
stock |
varchar2 |
Stock Location Code | writable, stock |
||
stock |
guid |
Stock Location ID | writable, stock |
||
stock |
varchar2 |
Stock Location Name | writable, stock |
||
stock |
varchar2 |
Stock Point Code | writable, stock |
||
stock |
varchar2 |
Stock Point Code 2 | filters on the platform, writable, ::ancestor. |
||
stock |
guid |
Stock Point ID | writable, stock |
||
stock |
guid |
Stock Point ID 2 | filters on the platform, writable, ::ancestor. |
||
stock |
varchar2 |
Stock Point Name | writable, stock |
||
stock |
varchar2 |
Stock Point Name 2 | 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. |
||
taken |
decimal |
Taken Quantity | writable, taken |
||
voided |
char |
Voided | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: