---
title: "InventoryById (Visma.net Financials)"
description: "Inventory by ID"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.Inventory.InventoryById
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.Inventory.InventoryById
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# InventoryById: Visma.net Financials Inventory by ID

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `Inventory`
- Label: Inventory by ID

Get a specific Inventory item by its internal ID

Can only retrieve data.

## API Source

- Endpoint: `/v1/inventory/internal/{inventoryId}`
- Operation: `get /v1/inventory/internal/{inventoryId}`

## 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 |
|---|---|:---:|---|---|
| `inventoryId` | `` | [x] |  | Identifies the Inventory item |

## Table Columns

The columns of the table `InventoryById` 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 | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `accountInformation_cogsAccount_description` | `varchar2` | itgen_vnet_accountinformation_cogsaccount_description | [ ] | filters on the platform, writable, `accountInformation.cogsAccount.description` | Name of item/description |
| `accountInformation_cogsAccount_number` | `varchar2` | itgen_vnet_accountinformation_cogsaccount_number | [ ] | filters on the platform, writable, `accountInformation.cogsAccount.number` | Number of item |
| `accountInformation_cogsAccount_type` | `varchar2` | itgen_vnet_accountinformation_cogsaccount_type | [ ] | filters on the platform, writable, `accountInformation.cogsAccount.type` |  |
| `accountInformation_cogsSubaccount_active` | `char` | itgen_vnet_accountinformation_cogssubaccount_active | [ ] | filters on the platform, writable, `accountInformation.cogsSubaccount.active` |  |
| `accountInformation_cogsSubaccount_description` | `varchar2` | itgen_vnet_accountinformation_cogssubaccount_description | [ ] | filters on the platform, writable, `accountInformation.cogsSubaccount.description` | Click on the magnifier. &gt; The description. |
| `accountInformation_cogsSubaccount_id` | `varchar2` | itgen_vnet_accountinformation_cogssubaccount_id | [ ] | filters on the platform, writable, `accountInformation.cogsSubaccount.id` | Click on the magnifier. &gt; The identifier. |
| `accountInformation_expenseAccount_description` | `varchar2` | itgen_vnet_accountinformation_expenseaccount_description | [ ] | filters on the platform, writable, `accountInformation.expenseAccount.description` | Name of item/description |
| `accountInformation_expenseAccount_number` | `varchar2` | itgen_vnet_accountinformation_expenseaccount_number | [ ] | filters on the platform, writable, `accountInformation.expenseAccount.number` | Number of item |
| `accountInformation_expenseAccount_type` | `varchar2` | itgen_vnet_accountinformation_expenseaccount_type | [ ] | filters on the platform, writable, `accountInformation.expenseAccount.type` |  |
| `accountInformation_expenseAccrualAccount_description` | `varchar2` | itgen_vnet_accountinformation_expenseaccrualaccount_description | [ ] | filters on the platform, writable, `accountInformation.expenseAccrualAccount.description` | Name of item/description |
| `accountInformation_expenseAccrualAccount_number` | `varchar2` | itgen_vnet_accountinformation_expenseaccrualaccount_number | [ ] | filters on the platform, writable, `accountInformation.expenseAccrualAccount.number` | Number of item |
| `accountInformation_expenseAccrualAccount_type` | `varchar2` | itgen_vnet_accountinformation_expenseaccrualaccount_type | [ ] | filters on the platform, writable, `accountInformation.expenseAccrualAccount.type` |  |
| `accountInformation_expenseEuAccount_description` | `varchar2` | itgen_vnet_accountinformation_expenseeuaccount_description | [ ] | filters on the platform, writable, `accountInformation.expenseEuAccount.description` | Name of item/description |
| `accountInformation_expenseEuAccount_number` | `varchar2` | itgen_vnet_accountinformation_expenseeuaccount_number | [ ] | filters on the platform, writable, `accountInformation.expenseEuAccount.number` | Number of item |
| `accountInformation_expenseEuAccount_type` | `varchar2` | itgen_vnet_accountinformation_expenseeuaccount_type | [ ] | filters on the platform, writable, `accountInformation.expenseEuAccount.type` |  |
| `accountInformation_expenseImportAccount_description` | `varchar2` | itgen_vnet_accountinformation_expenseimportaccount_description | [ ] | filters on the platform, writable, `accountInformation.expenseImportAccount.description` | Name of item/description |
| `accountInformation_expenseImportAccount_number` | `varchar2` | itgen_vnet_accountinformation_expenseimportaccount_number | [ ] | filters on the platform, writable, `accountInformation.expenseImportAccount.number` | Number of item |
| `accountInformation_expenseImportAccount_type` | `varchar2` | itgen_vnet_accountinformation_expenseimportaccount_type | [ ] | filters on the platform, writable, `accountInformation.expenseImportAccount.type` |  |
| `accountInformation_expenseNonTaxableAccount_description` | `varchar2` | itgen_vnet_accountinformation_expensenontaxableaccount_description | [ ] | filters on the platform, writable, `accountInformation.expenseNonTaxableAccount.description` | Name of item/description |
| `accountInformation_expenseNonTaxableAccount_number` | `varchar2` | itgen_vnet_accountinformation_expensenontaxableaccount_number | [ ] | filters on the platform, writable, `accountInformation.expenseNonTaxableAccount.number` | Number of item |
| `accountInformation_expenseNonTaxableAccount_type` | `varchar2` | itgen_vnet_accountinformation_expensenontaxableaccount_type | [ ] | filters on the platform, writable, `accountInformation.expenseNonTaxableAccount.type` |  |
| `accountInformation_expenseSubaccount_active` | `char` | itgen_vnet_accountinformation_expensesubaccount_active | [ ] | filters on the platform, writable, `accountInformation.expenseSubaccount.active` |  |
| `accountInformation_expenseSubaccount_description` | `varchar2` | itgen_vnet_accountinformation_expensesubaccount_description | [ ] | filters on the platform, writable, `accountInformation.expenseSubaccount.description` | Click on the magnifier. &gt; The description. |
| `accountInformation_expenseSubaccount_id` | `varchar2` | itgen_vnet_accountinformation_expensesubaccount_id | [ ] | filters on the platform, writable, `accountInformation.expenseSubaccount.id` | Click on the magnifier. &gt; The identifier. |
| `accountInformation_inventoryAccount_description` | `varchar2` | itgen_vnet_accountinformation_inventoryaccount_description | [ ] | filters on the platform, writable, `accountInformation.inventoryAccount.description` | Name of item/description |
| `accountInformation_inventoryAccount_number` | `varchar2` | itgen_vnet_accountinformation_inventoryaccount_number | [ ] | filters on the platform, writable, `accountInformation.inventoryAccount.number` | Number of item |
| `accountInformation_inventoryAccount_type` | `varchar2` | itgen_vnet_accountinformation_inventoryaccount_type | [ ] | filters on the platform, writable, `accountInformation.inventoryAccount.type` |  |
| `accountInformation_salesAccount_description` | `varchar2` | itgen_vnet_accountinformation_salesaccount_description | [ ] | filters on the platform, writable, `accountInformation.salesAccount.description` | Name of item/description |
| `accountInformation_salesAccount_number` | `varchar2` | itgen_vnet_accountinformation_salesaccount_number | [ ] | filters on the platform, writable, `accountInformation.salesAccount.number` | Number of item |
| `accountInformation_salesAccount_type` | `varchar2` | itgen_vnet_accountinformation_salesaccount_type | [ ] | filters on the platform, writable, `accountInformation.salesAccount.type` |  |
| `accountInformation_salesEuAccount_description` | `varchar2` | itgen_vnet_accountinformation_saleseuaccount_description | [ ] | filters on the platform, writable, `accountInformation.salesEuAccount.description` | Name of item/description |
| `accountInformation_salesEuAccount_number` | `varchar2` | itgen_vnet_accountinformation_saleseuaccount_number | [ ] | filters on the platform, writable, `accountInformation.salesEuAccount.number` | Number of item |
| `accountInformation_salesEuAccount_type` | `varchar2` | itgen_vnet_accountinformation_saleseuaccount_type | [ ] | filters on the platform, writable, `accountInformation.salesEuAccount.type` |  |
| `accountInformation_salesExportAccount_description` | `varchar2` | itgen_vnet_accountinformation_salesexportaccount_description | [ ] | filters on the platform, writable, `accountInformation.salesExportAccount.description` | Name of item/description |
| `accountInformation_salesExportAccount_number` | `varchar2` | itgen_vnet_accountinformation_salesexportaccount_number | [ ] | filters on the platform, writable, `accountInformation.salesExportAccount.number` | Number of item |
| `accountInformation_salesExportAccount_type` | `varchar2` | itgen_vnet_accountinformation_salesexportaccount_type | [ ] | filters on the platform, writable, `accountInformation.salesExportAccount.type` |  |
| `accountInformation_salesNonTaxableAccount_description` | `varchar2` | itgen_vnet_accountinformation_salesnontaxableaccount_description | [ ] | filters on the platform, writable, `accountInformation.salesNonTaxableAccount.description` | Name of item/description |
| `accountInformation_salesNonTaxableAccount_number` | `varchar2` | itgen_vnet_accountinformation_salesnontaxableaccount_number | [ ] | filters on the platform, writable, `accountInformation.salesNonTaxableAccount.number` | Number of item |
| `accountInformation_salesNonTaxableAccount_type` | `varchar2` | itgen_vnet_accountinformation_salesnontaxableaccount_type | [ ] | filters on the platform, writable, `accountInformation.salesNonTaxableAccount.type` |  |
| `accountInformation_salesSubaccount_active` | `char` | itgen_vnet_accountinformation_salessubaccount_active | [ ] | filters on the platform, writable, `accountInformation.salesSubaccount.active` |  |
| `accountInformation_salesSubaccount_description` | `varchar2` | itgen_vnet_accountinformation_salessubaccount_description | [ ] | filters on the platform, writable, `accountInformation.salesSubaccount.description` | Click on the magnifier. &gt; The description. |
| `accountInformation_salesSubaccount_id` | `varchar2` | itgen_vnet_accountinformation_salessubaccount_id | [ ] | filters on the platform, writable, `accountInformation.salesSubaccount.id` | Click on the magnifier. &gt; The identifier. |
| `baseUnit` | `varchar2` | Base Unit | [ ] | filters on the platform, writable, `baseUnit` | Mandatory field: General information tab &gt; Unit of measurement section &gt; Base unit* &gt; The UoM used as the base unit for this stock item. |
| `body` | `varchar2` | itgen_vnet_body | [ ] | filters on the platform, writable, `body` | The top part &gt; Body *&gt; A brief description of the stock item. |
| `costPriceStatistics_averageCost` | `double` | itgen_vnet_costpricestatistics_averagecost | [ ] | filters on the platform, writable, `costPriceStatistics.averageCost` | Cost price statistics section &gt; Average cost &gt; The average cost for the stock item. |
| `costPriceStatistics_lastCost` | `double` | itgen_vnet_costpricestatistics_lastcost | [ ] | filters on the platform, writable, `costPriceStatistics.lastCost` | Cost price statistics section &gt; Last cost &gt; The last standard cost used for the stock item. |
| `costPriceStatistics_maxCost` | `double` | itgen_vnet_costpricestatistics_maxcost | [ ] | filters on the platform, writable, `costPriceStatistics.maxCost` | Cost price statistics section &gt; Max. cost &gt; The maximum cost for the stock item. |
| `costPriceStatistics_minCost` | `double` | itgen_vnet_costpricestatistics_mincost | [ ] | filters on the platform, writable, `costPriceStatistics.minCost` | Cost price statistics section &gt; Min. cost &gt; The minimum cost for the stock item. |
| `currentCost` | `double` | itgen_vnet_currentcost | [ ] | filters on the platform, writable, `currentCost` | Price/cost information tab &gt; Standard cost section &gt; Current cost &gt; Read-only. This field displays the current standard cost for the stock item. |
| `defaultIssueFrom_description` | `varchar2` | itgen_vnet_defaultissuefrom_description | [ ] | filters on the platform, writable, `defaultIssueFrom.description` | Click on the magnifier. &gt; The description. |
| `defaultIssueFrom_id` | `varchar2` | itgen_vnet_defaultissuefrom_id | [ ] | filters on the platform, writable, `defaultIssueFrom.id` | Click on the magnifier. &gt; The identifier. |
| `defaultPrice` | `double` | Default Price | [ ] | filters on the platform, writable, `defaultPrice` | Price/cost information tab &gt; Price management section &gt; Default price &gt; The price of the stock item. |
| `defaultReceiptTo_description` | `varchar2` | itgen_vnet_defaultreceiptto_description | [ ] | filters on the platform, writable, `defaultReceiptTo.description` | Click on the magnifier. &gt; The description. |
| `defaultReceiptTo_id` | `varchar2` | itgen_vnet_defaultreceiptto_id | [ ] | filters on the platform, writable, `defaultReceiptTo.id` | Click on the magnifier. &gt; The identifier. |
| `defaultWarehouse_description` | `varchar2` | itgen_vnet_defaultwarehouse_description | [ ] | filters on the platform, writable, `defaultWarehouse.description` | Click on the magnifier. &gt; The description. |
| `defaultWarehouse_id` | `varchar2` | itgen_vnet_defaultwarehouse_id | [ ] | filters on the platform, writable, `defaultWarehouse.id` | Click on the magnifier. &gt; The identifier. |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `description` | The top part &gt; Description *&gt; A brief description of the stock item. |
| `effectiveDate` | `datetime` | Effective Date | [ ] | filters on the platform, writable, `effectiveDate` | Price/cost information tab &gt; Standard cost section &gt; Effective date &gt; Read-only. This field shows the effective date for the current standard cost of the stock item. |
| `errorInfo` | `varchar2` | Error Message | [ ] | filters on the platform, writable, `errorInfo` |  |
| `intrastat_cN8` | `varchar2` | itgen_vnet_intrastat_cn8 | [ ] | filters on the platform, writable, `intrastat.cN8` | Represents the 8 digit level Combine Nomenclature commodity code specific for the year for which the creating / actualizations Intrastat declarations is drafted. |
| `intrastat_countryOfOrigin` | `varchar2` | itgen_vnet_intrastat_countryoforigin | [ ] | filters on the platform, writable, `intrastat.countryOfOrigin` | The country of origin of the commodity will be selected, that country where the good has been produced or had the last substantial transformation. |
| `intrastat_supplementaryMeasureUnit` | `varchar2` | itgen_vnet_intrastat_supplementarymeasureunit | [ ] | filters on the platform, writable, `intrastat.supplementaryMeasureUnit` | The requirement for Supplementary Measure Units applies only to certain classes of goods(NC8 Positions) that may be expressed from quantitative point of view in other measurement units but kilo also. |
| `inventoryId` | `int32` | Inventory ID | [ ] | filters on the platform, writable, `inventoryId` | The unique internal identifier of the  item as is stored in the database. This Id is not visible in the window. |
| `inventoryNumber` | `varchar2` | Inventory Number | [ ] | filters on the platform, writable, `inventoryNumber` | Mandatory field: The top part &gt; Item Id* &gt; The unique alphanumeric identifier of the stock item. |
| `itemClass_description` | `varchar2` | Item Class Description | [ ] | filters on the platform, writable, `itemClass.description` | The description. |
| `itemClass_errorInfo` | `varchar2` | Item Class Error Information | [ ] | filters on the platform, writable, `itemClass.errorInfo` |  |
| `itemClass_id` | `varchar2` | Item Class ID | [ ] | filters on the platform, writable, `itemClass.id` | The identifier. |
| `itemClass_metadata_maxPageSize` | `int64` | Item Class Metadata Max Pagesize | [ ] | filters on the platform, writable, `itemClass.metadata.maxPageSize` |  |
| `itemClass_metadata_totalCount` | `int64` | Item Class Metadata Total Count | [ ] | filters on the platform, writable, `itemClass.metadata.totalCount` |  |
| `itemClass_type` | `varchar2` | Item Class Type | [ ] | filters on the platform, writable, `itemClass.type` |  |
| `kitItem` | `char` | itgen_vnet_kititem | [ ] | filters on the platform, writable, `kitItem` |  |
| `lastCost` | `double` | Last Cost | [ ] | filters on the platform, writable, `lastCost` | Price/cost information tab &gt; Standard cost section &gt; Last cost &gt; Read-only. This field showing the last standard cost defined for the stock item. |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `lastModifiedDateTime` | Information collected from system. |
| `lotSerialClass_description` | `varchar2` | itgen_vnet_lotserialclass_description | [ ] | filters on the platform, writable, `lotSerialClass.description` | Click on the magnifier. &gt; The description. |
| `lotSerialClass_id` | `varchar2` | itgen_vnet_lotserialclass_id | [ ] | filters on the platform, writable, `lotSerialClass.id` | Click on the magnifier. &gt; The identifier. |
| `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` |  |
| `note` | `varchar2` | Note | [ ] | filters on the platform, writable, `note` | Icon Notes on top of the window &gt; Pop-up window for providing any user-defined text connected to the inventory item. |
| `packaging_baseItemVolume` | `double` | itgen_vnet_packaging_baseitemvolume | [ ] | filters on the platform, writable, `packaging.baseItemVolume` | The volume of the <see cref="!:BaseUnit">Base Unit</see> of the item. |
| `packaging_baseItemWeight` | `double` | itgen_vnet_packaging_baseitemweight | [ ] | filters on the platform, writable, `packaging.baseItemWeight` | The weight of the <see cref="!:BaseUnit">Base Unit</see> of the item. |
| `packaging_volumeUOM` | `varchar2` | itgen_vnet_packaging_volumeuom | [ ] | filters on the platform, writable, `packaging.volumeUOM` | The <see cref="!:INUnit">Unit of Measure</see> used for the <see cref="P:Visma.net.ERP.Web.Api.Model.V1.IN.PackagingDto.BaseItemVolume">Volume</see> of the item. |
| `packaging_weightUOM` | `varchar2` | itgen_vnet_packaging_weightuom | [ ] | filters on the platform, writable, `packaging.weightUOM` | The <see cref="!:INUnit">Unit of Measure</see> used for the <see cref="P:Visma.net.ERP.Web.Api.Model.V1.IN.PackagingDto.BaseItemWeight">Weight</see> of the item. |
| `pendingCost` | `double` | Pending Cost | [ ] | filters on the platform, writable, `pendingCost` | Price/cost information tab &gt; Standard cost section &gt; Pending cost &gt; The pending standard cost for the stock item. |
| `pendingCostDate` | `datetime` | Pending Cost Date | [ ] | filters on the platform, writable, `pendingCostDate` | Price/cost information tab &gt; Standard cost section &gt; Pending cost date &gt; The date when the pending standard cost becomes effective. |
| `postingClass_description` | `varchar2` | itgen_vnet_postingclass_description | [ ] | filters on the platform, writable, `postingClass.description` | The description. |
| `postingClass_id` | `varchar2` | itgen_vnet_postingclass_id | [ ] | filters on the platform, writable, `postingClass.id` | The identifier. |
| `postingClass_metadata_maxPageSize` | `int64` | itgen_vnet_postingclass_metadata_maxpagesize | [ ] | filters on the platform, writable, `postingClass.metadata.maxPageSize` |  |
| `postingClass_metadata_totalCount` | `int64` | itgen_vnet_postingclass_metadata_totalcount | [ ] | filters on the platform, writable, `postingClass.metadata.totalCount` |  |
| `priceClassID` | `varchar2` | itgen_vnet_priceclassid | [ ] | filters on the platform, writable, `priceClassID` | The Price/cost information tab &gt; Price management section &gt; Price class &gt; The price class of the item. |
| `priceClass_description` | `varchar2` | Price Class Description | [ ] | filters on the platform, writable, `priceClass.description` | Click on the magnifier. &gt; The description. |
| `priceClass_id` | `varchar2` | Price Class ID | [ ] | filters on the platform, writable, `priceClass.id` | Click on the magnifier. &gt; The identifier. |
| `priceManagerID` | `guid` | itgen_vnet_pricemanagerid | [ ] | filters on the platform, writable, `priceManagerID` | The Price/cost information tab &gt; Price management section &gt; Price manager &gt; The ID of the manager responsible for the product pricing. |
| `priceManager_id` | `varchar2` | itgen_vnet_pricemanager_id | [ ] | filters on the platform, writable, `priceManager.id` |  |
| `priceManager_name` | `varchar2` | itgen_vnet_pricemanager_name | [ ] | filters on the platform, writable, `priceManager.name` |  |
| `priceWorkgroupID` | `int32` | itgen_vnet_priceworkgroupid | [ ] | filters on the platform, writable, `priceWorkgroupID` | The Price/cost information tab &gt; Price management section &gt; Price work group &gt; The work group responsible for product pricing. Select the pricing work group for the stock item. |
| `purchaseUnit` | `varchar2` | itgen_vnet_purchaseunit | [ ] | filters on the platform, writable, `purchaseUnit` | Mandatory field: General information tab &gt; Unit of measurement section &gt; Purchase unit *&gt; The UoM to be used as the purchase unit for the stock item. |
| `recommendedPrice` | `double` | itgen_vnet_recommendedprice | [ ] | filters on the platform, writable, `recommendedPrice` | The Price/cost information tab &gt; Price management section &gt; List price &gt; The manufacturer's suggested retail price (MSRP) of the stock item. |
| `salesUnit` | `varchar2` | Sales Unit | [ ] | filters on the platform, writable, `salesUnit` | Mandatory field: General information tab &gt; Unit of measurement section &gt; Sales unit *&gt; The UoM to be used as the sales unit for the stock item. |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `status` | The top part &gt; Item status &gt; The status of the stock item. The alternatives are: Active, No sales, No purchases, No request, Inactive, Marked for deletion. |
| `stockItem` | `char` | Stock Item | [ ] | filters on the platform, writable, `stockItem` |  |
| `timestamp` | `varchar2` | Timestamp | [ ] | filters on the platform, writable, `timestamp` | Timestamp of the inventory item record |
| `type` | `varchar2` | Type | [ ] | filters on the platform, writable, `type` | General information tab &gt; Item defaults section &gt; Type &gt; The type of stock item. |
| `unspsc` | `varchar2` | itgen_vnet_unspsc | [ ] | filters on the platform, writable, `unspsc` | General information tab &gt; UNSPSC Code &gt; The UNSPSC code for the stock item. |
| `vatCode_description` | `varchar2` | VAT Code Description | [ ] | filters on the platform, writable, `vatCode.description` | Click on the magnifier. &gt; The description. |
| `vatCode_id` | `varchar2` | VAT Code ID | [ ] | filters on the platform, writable, `vatCode.id` | Click on the magnifier. &gt; The identifier. |



## Release Notes

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

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

