StockTakings2ByParameters: Fortnox itgen_fnx_stocktakings2byparameters_plural
read only REST
- Catalog:
Fortnox - Schema:
WarehouseStockTakings - Label: itgen_fnx_stocktakings2byparameters_plural
List stock takings
Sortable fields: id, name, date, responsible, state
Can only retrieve data.
Summary
Sortable fields:
id,
name,
date,
responsible,
state
API Source
- Endpoint:
/api/warehouse/stocktaking-v1 - Operation:
get /api/warehouse/stocktaking-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). | ||
itemId |
`` | Include only stock takings with the given item. | ||
lastmodified |
`` | Retrieves all records since the provided timestamp (does not work on every table). | ||
state |
`` | Include only stock takings with the given state. (Values: all, planning, started, completed, voided) | ||
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 StockTakings2ByParameters 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 |
|---|---|---|---|---|---|
cost |
varchar2 |
Cost Centre Code | filters on the platform, writable, ::ancestor. |
||
counted |
varchar2 |
Counted by | writable, counted |
||
current |
int32 |
Current Row No | writable, current |
||
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
||
has |
char |
Has Post Release Stock Changes | writable, has |
||
id |
varchar2 |
ID | writable, id |
||
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
||
itemId |
varchar2 |
Item ID | writable, itemId |
||
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
Project ID | filters on the platform, writable, ::ancestor. |
||
responsible |
varchar2 |
Responsible | filters on the platform, writable, ::ancestor. |
||
sort |
varchar2 |
Sort Params Primary Sort | filters on the platform, writable, ::ancestor. |
||
sort |
varchar2 |
Sort Params Primary Sort Order | filters on the platform, writable, ::ancestor. |
||
sort |
varchar2 |
Sort Params Secondary Sort | filters on the platform, writable, ::ancestor. |
||
sort |
varchar2 |
Sort Params Secondary Sort Order | filters on the platform, writable, ::ancestor. |
||
sorting |
int32 |
Sorting ID | filters on the platform, writable, ::ancestor. |
||
state |
varchar2 |
State | filters on the platform, writable, ::ancestor. |
||
stock |
guid |
Stock Location ID | writable, stock |
||
stock |
guid |
Stock Point ID | writable, stock |
||
stock |
decimal |
Stock Taken Quantity | writable, stock |
||
stock |
int64 |
Stock Taking ID | writable, stock |
||
stock |
varchar2 |
Stock Taking Rowid | writable, stock |
||
total |
decimal |
Total Quantity in Stock | writable, total |
||
using |
char |
Using Stockpoints | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: