StockTakes: Visma.net Financials Stock Takes
read only REST
- Catalog:
VismaNet - Schema:
StocktakeV2 - Label: Stock Takes
Get a range of stocktakes - ScreenId=IN305000 Request page size must be lower or equal to the allowed max page size which is returned as part of the metadata information. If requested page size is greater than allowed max page size, request will be limited to max page size.
Can only retrieve data.
API Source
- Endpoint:
/v2/stocktake - Operation:
get /v2/stocktake
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
end |
`` | Filter by by LineNumber LessEqual EndWithLine. | ||
expiration |
`` | Filter by ExpirationDateTime. | ||
expiration |
`` | Filter by ExpirationDateTimeCondition. | ||
freeze |
`` | Filter by FreezeDateTime. | ||
freeze |
`` | Filter by FreezeDateTimeCondition. | ||
inventory |
`` | Filter by Inventory. | ||
last |
`` | System generated value for last modification of transaction/record. Use format: YYYY-MM-DD HH:MM (date and time) to filter from date to present.. | ||
last |
`` | System retrieved information for state/condition. | ||
location |
`` | Filter by Location. | ||
lot |
`` | Filter by LotSerialNumber. | ||
start |
`` | Filter by LineNumber GreaterEqual StartWithLine. | ||
status |
`` | Filter by StocktakeLineStatus. (Values: NotEntered, Entered, Skipped) | ||
summary |
`` | Filter by SummaryStatus. (Values: Cancelled, Completed, Counting, Entering) | ||
warehouse |
`` | Filter by Warehouse. |
Table Columns
The columns of the table StockTakes 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 |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The top part > Description > The description of the stocktaking. | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
freeze |
datetime |
itgen_vnet_freezedate | filters on the platform, writable, freeze |
The top part > Freeze date > An info field that shows the date when the stocktaking document was created. | |
last |
datetime |
Last Modified | filters on the platform, writable, last |
System generated information. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
number |
int32 |
itgen_vnet_numberoflines | filters on the platform, writable, number |
||
physical |
double |
itgen_vnet_physicalqty | filters on the platform, writable, physical |
The top part > Total physical qty. > An info field showing the total actual quantity of all stock items listed in the document. | |
reference |
varchar2 |
Reference Number | filters on the platform, writable, reference |
The top part > Ref. no. > The reference number of the stocktaking document to be reviewed. | |
summary |
varchar2 |
itgen_vnet_summarystatus | filters on the platform, writable, summary |
The top part > Status > An info field that shows the current status of this stocktaking document. | |
timestamp |
varchar2 |
Timestamp | filters on the platform, writable, timestamp |
Timestamp of the stocktake record | |
variance |
double |
itgen_vnet_variancecost | filters on the platform, writable, variance |
The top part > Total variance cost > An info field showing the total variance cost for all stock items listed in the document. | |
variance |
double |
itgen_vnet_varianceqty | filters on the platform, writable, variance |
The top part > Total variance qty. > An info field showing the total variance quantity for the document. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: