StockTakesByReferenceNumber: Visma.net Financials Stock Takes by Reference Number
read only REST
- Catalog:
VismaNet - Schema:
StocktakeV2 - Label: Stock Takes by Reference Number
Get a specific
Can only retrieve data.
API Source
- Endpoint:
/v2/stocktake/{referenceNumber} - Operation:
get /v2/stocktake/{referenceNumber}
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 |
|---|---|---|---|---|
reference |
`` | Identifies the Stocktake |
Table Columns
The columns of the table StockTakesByReferenceNumber 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: