StockTakeLinesV2: Visma.net Financials Stock Take Lines
read only REST
- Catalog:
VismaNet - Schema:
StocktakeV2 - Label: Stock Take Lines
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 StockTakeLinesV2 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. | |
base |
varchar2 |
Base Unit | writable, base |
Stocktaking details tab > Base Unit > The base unit for the item. | |
book |
double |
Book Quantity | writable, book |
Stocktaking details tab > Book quantity > The book quantity of the item, which is calculated based on the system records. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The top part > Description > The description of the stocktaking. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
expiration |
datetime |
Expiration Date | writable, expiration |
Stocktaking details tab > Expiration date > The expiration date of the item with this specific lot or serial number. | |
ext |
double |
itgen_vnet_extvariancecost | writable, ext |
Stocktaking details tab > Variance cost > The difference between the extended cost calculated based on the book quantity and the extended cost calculated based on the physical quantity for the item. | |
freeze |
datetime |
itgen_vnet_freezedate | filters on the platform, writable, ::ancestor. |
The top part > Freeze date > An info field that shows the date when the stocktaking document was created. | |
inventory_ |
varchar2 |
Inventory Description | writable, inventory. |
Click on the magnifier. > The description. | |
inventory_ |
varchar2 |
itgen_vnet_inventory_id | writable, inventory. |
Click the magnifier > The displayed name | |
inventory_ |
int32 |
itgen_vnet_inventory_internalid | writable, inventory. |
Click the magnifier > The identifier | |
last |
datetime |
Last Modified | writable, last |
System generated information. | |
last |
datetime |
Last Modified Date/Time 2 | filters on the platform, writable, ::ancestor. |
System generated information. | |
line |
int32 |
itgen_vnet_linenbr | writable, line |
Stocktaking details tab > Line no. > The number of the line in the stocktaking document. | |
location_ |
varchar2 |
Location Description | writable, location. |
Click on the magnifier. > The description. | |
location_ |
varchar2 |
Location ID | writable, location. |
Click the magnifier > The displayed name | |
location_ |
int32 |
itgen_vnet_location_internalid | writable, location. |
Click the magnifier > The identifier | |
lot |
varchar2 |
itgen_vnet_lotserialnbr | writable, lot |
Stocktaking details tab > Lot/serial number > The lot or serial number of the item. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
number |
int32 |
itgen_vnet_numberoflines | filters on the platform, writable, ::ancestor. |
||
physical |
double |
itgen_vnet_physicalqty | filters on the platform, writable, ::ancestor. |
The top part > Total physical qty. > An info field showing the total actual quantity of all stock items listed in the document. | |
physical |
double |
itgen_vnet_physicalquantity | writable, physical |
Stocktaking details tab > Physical quantity > The physical quantity of the item as entered manually. | |
reason |
varchar2 |
Reason Code | writable, reason |
Stocktaking details tab > Reason code > The reason code for the item. | |
reference |
varchar2 |
Reference Number | filters on the platform, writable, ::ancestor. |
The top part > Ref. no. > The reference number of the stocktaking document to be reviewed. | |
status |
varchar2 |
Status | writable, status |
Stocktaking details tab > Status > The status of the line of the stocktaking document, which indicates whether the actual physical quantity has been specified for the line. | |
summary |
varchar2 |
itgen_vnet_summarystatus | filters on the platform, writable, ::ancestor. |
The top part > Status > An info field that shows the current status of this stocktaking document. | |
tagNbr |
int32 |
itgen_vnet_tagnbr | writable, tagNbr |
Stocktaking details tab > Tag no. > The tag number for the line item, which is the stock item with the properties specified in the line, such as location, subitem, and lot or serial number. | |
timestamp |
varchar2 |
Timestamp | filters on the platform, writable, ::ancestor. |
Timestamp of the stocktake record | |
unit |
double |
Unit Cost | writable, unit |
Stocktaking details tab > Unit cost > The last cost of the item’s base unit as approximation of its unit cost during the count. | |
variance |
double |
itgen_vnet_variancecost | filters on the platform, writable, ::ancestor. |
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, ::ancestor. |
The top part > Total variance qty. > An info field showing the total variance quantity for the document. | |
variance |
double |
itgen_vnet_variancequantity | writable, variance |
Stocktaking details tab > Variance quantity > The difference between the book quantity and the physical quantity for the line item. | |
warehouse_ |
varchar2 |
Warehouse Description | writable, warehouse. |
Click on the magnifier. > The description. | |
warehouse_ |
varchar2 |
Warehouse ID | writable, warehouse. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: