InventorySummaryByNumber: Visma.net Financials Inventory Summary by Number
read only REST
- Catalog:
VismaNet - Schema:
InventorySummary - Label: Inventory Summary by Number
Get a range of InventorySummary - ScreenId=IN401000
Can only retrieve data.
API Source
- Endpoint:
/v1/inventorysummary/{inventoryNumber} - Operation:
get /v1/inventorysummary/{inventoryNumber}
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 |
|---|---|---|---|---|
inventory |
`` | |||
location |
`` | |||
warehouse |
`` |
Table Columns
The columns of the table InventorySummaryByNumber 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. | |
available |
double |
Available | filters on the platform, writable, available |
The table > Available > The quantity of the stock items available at the specific warehouse and location. | |
available |
double |
itgen_vnet_availableforshipment | filters on the platform, writable, available |
The table > Available for shipment > The quantity of the stock items available at the specific warehouse and location calculated based on the quantity on hand with the quantities shipped and on shipping deducted. | |
base |
varchar2 |
Base Unit | filters on the platform, writable, base |
The table > Base unit > The unit of measure (UoM) selected as the base unit for the stock items in the Stock items (IN202500) window. | |
drop |
double |
Dropship FORSO | filters on the platform, writable, drop |
The table > Drop-ship for sales order > The quantity of the stock items listed on open drop-ship orders. This value is not included in the quantity available. | |
drop |
double |
Dropship FORSO Prepared | filters on the platform, writable, drop |
The table > Drop-ship for sales order, prepared > The quantity of the stock items listed on drop-ship sales orders with a status of On hold or Pending approval; this value is not included in the quantity available. | |
drop |
double |
Dropship FORSO Receipts | filters on the platform, writable, drop |
The table > Drop-ship for sales order, receipts > The quantity of the stock items listed on receipts for drop-ship sales orders; this value is not included in the quantity available. | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
estimated |
double |
Estimated Total Cost | filters on the platform, writable, estimated |
The table > Estimated total cost > The estimated total cost of the stock items available at the specified warehouse and location. | |
estimated |
double |
Estimated Unit Cost | filters on the platform, writable, estimated |
The table > Estimated unit cost > The estimated unit cost of the selected stock items. | |
expired |
double |
Expired | filters on the platform, writable, expired |
The table > Expired > The quantity of the stock items that has reached its expiration date. | |
in |
double |
In Assembly Demand | filters on the platform, writable, in |
The table > In assembly demand > The quantity of the stock items included in unreleased kit assembly documents as components or kits, depending on whether the item is a kit or a kit component. | |
in |
double |
In Assembly Supply | filters on the platform, writable, in |
The table > In assembly supply > The quantity of the stock items listed on unreleased kit assembly documents. | |
in |
double |
In Issues | filters on the platform, writable, in |
The table > Inventory issues > The quantity of the stock items included in the inventory issue documents that have not yet been released. | |
in |
double |
In Receipts | filters on the platform, writable, in |
The table > Invnetory receipts > The quantity of the stock items included in the inventory receipt documents that have not yet been released. | |
in |
double |
Intransit | filters on the platform, writable, in |
The table > In transit > The quantity of the stock items included as in transit quantities in the inventory transfer documents that have not yet been released. | |
inventory_ |
varchar2 |
Inventory Description | filters on the platform, writable, inventory. |
Name of item/description | |
inventory_ |
varchar2 |
Inventory Number | filters on the platform, writable, inventory. |
Number of item | |
location_ |
int32 |
Location ID | filters on the platform, writable, location. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | filters on the platform, writable, location. |
Click the magnifier > The displayed name | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
not |
double |
Not Available | filters on the platform, writable, not |
The table > Not available > The quantity of the stock items on locations for which the Include in qty. available option is not selected. | |
onHand |
double |
On Hand | filters on the platform, writable, onHand |
The table > On hand > The quantity of the stock items available on hand at the specified warehouse and location. | |
po |
double |
itgen_vnet_poreceipts | filters on the platform, writable, po |
The table > Purchase order receipts > The quantity of the stock items included in the purchase receipts that have not yet been released. To view the purchase receipts, open the Purchase receipts (PO302000) window. | |
purchase |
double |
itgen_vnet_purchaseforso | filters on the platform, writable, purchase |
The table > Purchase for sales order. > The quantity of the stock items listed on open purchase orders created for sales orders. | |
purchase |
double |
itgen_vnet_purchaseforsoprepared | filters on the platform, writable, purchase |
The table > Purchase for sales order prepared > The quantity of the stock items listed on purchase orders yet on hold or pending approval and created for back orders. | |
purchase |
double |
itgen_vnet_purchaseforsoreceipts | filters on the platform, writable, purchase |
The table > Purchase for sales order receipts > The quantity of the stock items listed on purchase receipts for orders that were created for sales orders. | |
purchase |
double |
itgen_vnet_purchaseorders | filters on the platform, writable, purchase |
The table > Purchase orders > The quantity of the stock items included in open purchase orders. To view the purchase orders, open the Purchase orders (PO301000) window. | |
purchase |
double |
itgen_vnet_purchaseprepared | filters on the platform, writable, purchase |
The table > Purchase prepared > The quantity of the stock items listed on purchase orders pending approval and on hold. | |
so |
double |
itgen_vnet_soallocated | filters on the platform, writable, so |
The table > Sales order allocated > The quantity of stock items set aside according to sales orders. | |
so |
double |
itgen_vnet_sobackordered | filters on the platform, writable, so |
The table > Back orders > The quantity of the stock items on sales orders with the Back order status. | |
so |
double |
itgen_vnet_sobooked | filters on the platform, writable, so |
The table > Sales order booked > The quantity of the stock items booked according to sales orders. | |
so |
double |
itgen_vnet_soshipped | filters on the platform, writable, so |
The table > Sales orders shipped > The quantity of the stock items shipped according to the confirmed shipments. | |
so |
double |
itgen_vnet_sotodropship | filters on the platform, writable, so |
The table > Sales order to drop-ship > The quantity of the stock items included in open purchase orders created for drop-ship orders. | |
so |
double |
itgen_vnet_sotopurchase | filters on the platform, writable, so |
The table > Sales order to purchase > The quantity of the stock items included in unreleased sales orders requiring creating purchase orders. | |
warehouse_ |
varchar2 |
Warehouse Description | filters on the platform, writable, warehouse. |
Click on the magnifier. > The description. | |
warehouse_ |
varchar2 |
Warehouse ID | filters on the platform, writable, warehouse. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: