invantive documentation
Invantive Support ForumsLog In / Sign Up

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
inventoryNumber ``
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_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) 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.
availableForShipment double itgen_vnet_availableforshipment filters on the platform, writable, availableForShipment 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.
baseUnit varchar2 Base Unit filters on the platform, writable, baseUnit The table > Base unit > The unit of measure (UoM) selected as the base unit for the stock items in the Stock items (IN202500) window.
dropShipForSO double Dropship FORSO filters on the platform, writable, dropShipForSO 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.
dropShipForSOPrepared double Dropship FORSO Prepared filters on the platform, writable, dropShipForSOPrepared 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.
dropShipForSOReceipts double Dropship FORSO Receipts filters on the platform, writable, dropShipForSOReceipts 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.
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
estimatedTotalCost double Estimated Total Cost filters on the platform, writable, estimatedTotalCost The table > Estimated total cost > The estimated total cost of the stock items available at the specified warehouse and location.
estimatedUnitCost double Estimated Unit Cost filters on the platform, writable, estimatedUnitCost 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.
inAssemblyDemand double In Assembly Demand filters on the platform, writable, inAssemblyDemand 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.
inAssemblySupply double In Assembly Supply filters on the platform, writable, inAssemblySupply The table > In assembly supply > The quantity of the stock items listed on unreleased kit assembly documents.
inIssues double In Issues filters on the platform, writable, inIssues The table > Inventory issues > The quantity of the stock items included in the inventory issue documents that have not yet been released.
inReceipts double In Receipts filters on the platform, writable, inReceipts The table > Invnetory receipts > The quantity of the stock items included in the inventory receipt documents that have not yet been released.
inTransit double Intransit filters on the platform, writable, inTransit 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_description varchar2 Inventory Description filters on the platform, writable, inventory.description Name of item/description
inventory_number varchar2 Inventory Number filters on the platform, writable, inventory.number Number of item
location_id int32 Location ID filters on the platform, writable, location.id Click the magnifier > The identifier
location_name varchar2 Location Name filters on the platform, writable, location.name Click the magnifier > The displayed name
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
notAvailable double Not Available filters on the platform, writable, notAvailable 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.
poReceipts double itgen_vnet_poreceipts filters on the platform, writable, poReceipts 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.
purchaseForSO double itgen_vnet_purchaseforso filters on the platform, writable, purchaseForSO The table > Purchase for sales order. > The quantity of the stock items listed on open purchase orders created for sales orders.
purchaseForSOPrepared double itgen_vnet_purchaseforsoprepared filters on the platform, writable, purchaseForSOPrepared 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.
purchaseForSOReceipts double itgen_vnet_purchaseforsoreceipts filters on the platform, writable, purchaseForSOReceipts 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.
purchaseOrders double itgen_vnet_purchaseorders filters on the platform, writable, purchaseOrders 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.
purchasePrepared double itgen_vnet_purchaseprepared filters on the platform, writable, purchasePrepared The table > Purchase prepared > The quantity of the stock items listed on purchase orders pending approval and on hold.
soAllocated double itgen_vnet_soallocated filters on the platform, writable, soAllocated The table > Sales order allocated > The quantity of stock items set aside according to sales orders.
soBackOrdered double itgen_vnet_sobackordered filters on the platform, writable, soBackOrdered The table > Back orders > The quantity of the stock items on sales orders with the Back order status.
soBooked double itgen_vnet_sobooked filters on the platform, writable, soBooked The table > Sales order booked > The quantity of the stock items booked according to sales orders.
soShipped double itgen_vnet_soshipped filters on the platform, writable, soShipped The table > Sales orders shipped > The quantity of the stock items shipped according to the confirmed shipments.
soToDropShip double itgen_vnet_sotodropship filters on the platform, writable, soToDropShip The table > Sales order to drop-ship > The quantity of the stock items included in open purchase orders created for drop-ship orders.
soToPurchase double itgen_vnet_sotopurchase filters on the platform, writable, soToPurchase The table > Sales order to purchase > The quantity of the stock items included in unreleased sales orders requiring creating purchase orders.
warehouse_description varchar2 Warehouse Description filters on the platform, writable, warehouse.description Click on the magnifier. > The description.
warehouse_id varchar2 Warehouse ID filters on the platform, writable, warehouse.id Click on the magnifier. > The identifier.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: