InventoryAttributesByInventoryId: Visma.net Financials itgen_vnet_inventoryattributesbyinventoryid_plural
read only REST
- Catalog:
VismaNet - Schema:
Inventory - Label: itgen_vnet_inventoryattributesbyinventoryid_plural
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 |
|---|---|---|---|---|
inventory |
`` | Identifies the Inventory item |
Table Columns
The columns of the table InventoryAttributesByInventoryId 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. | |
account |
varchar2 |
itgen_vnet_accountinformation_cogsaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_cogsaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_cogsaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
char |
itgen_vnet_accountinformation_cogssubaccount_active | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_cogssubaccount_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
account |
varchar2 |
itgen_vnet_accountinformation_cogssubaccount_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_expenseaccrualaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseaccrualaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseaccrualaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_expenseeuaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseeuaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseeuaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_expenseimportaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseimportaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_expenseimportaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_expensenontaxableaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_expensenontaxableaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_expensenontaxableaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
char |
itgen_vnet_accountinformation_expensesubaccount_active | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_expensesubaccount_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
account |
varchar2 |
itgen_vnet_accountinformation_expensesubaccount_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
account |
varchar2 |
itgen_vnet_accountinformation_inventoryaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_inventoryaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_inventoryaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_salesaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_salesaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_salesaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_saleseuaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_saleseuaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_saleseuaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_salesexportaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_salesexportaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_salesexportaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_salesnontaxableaccount_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
account |
varchar2 |
itgen_vnet_accountinformation_salesnontaxableaccount_number | filters on the platform, writable, ::ancestor. |
Number of item | |
account |
varchar2 |
itgen_vnet_accountinformation_salesnontaxableaccount_type | filters on the platform, writable, ::ancestor. |
||
account |
char |
itgen_vnet_accountinformation_salessubaccount_active | filters on the platform, writable, ::ancestor. |
||
account |
varchar2 |
itgen_vnet_accountinformation_salessubaccount_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
account |
varchar2 |
itgen_vnet_accountinformation_salessubaccount_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
base |
varchar2 |
Base Unit | filters on the platform, writable, ::ancestor. |
Mandatory field: General information tab > Unit of measurement section > Base unit* > The UoM used as the base unit for this stock item. | |
body |
varchar2 |
itgen_vnet_body | filters on the platform, writable, ::ancestor. |
The top part > Body *> A brief description of the stock item. | |
cost |
double |
itgen_vnet_costpricestatistics_averagecost | filters on the platform, writable, ::ancestor. |
Cost price statistics section > Average cost > The average cost for the stock item. | |
cost |
double |
itgen_vnet_costpricestatistics_lastcost | filters on the platform, writable, ::ancestor. |
Cost price statistics section > Last cost > The last standard cost used for the stock item. | |
cost |
double |
itgen_vnet_costpricestatistics_maxcost | filters on the platform, writable, ::ancestor. |
Cost price statistics section > Max. cost > The maximum cost for the stock item. | |
cost |
double |
itgen_vnet_costpricestatistics_mincost | filters on the platform, writable, ::ancestor. |
Cost price statistics section > Min. cost > The minimum cost for the stock item. | |
current |
double |
itgen_vnet_currentcost | filters on the platform, writable, ::ancestor. |
Price/cost information tab > Standard cost section > Current cost > Read-only. This field displays the current standard cost for the stock item. | |
default |
varchar2 |
itgen_vnet_defaultissuefrom_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
default |
varchar2 |
itgen_vnet_defaultissuefrom_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
default |
double |
Default Price | filters on the platform, writable, ::ancestor. |
Price/cost information tab > Price management section > Default price > The price of the stock item. | |
default |
varchar2 |
itgen_vnet_defaultreceiptto_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
default |
varchar2 |
itgen_vnet_defaultreceiptto_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
default |
varchar2 |
itgen_vnet_defaultwarehouse_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
default |
varchar2 |
itgen_vnet_defaultwarehouse_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
description |
varchar2 |
Description | writable, description |
Attribute > The description of the attribute. | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
The top part > Description *> A brief description of the stock item. | |
effective |
datetime |
Effective Date | filters on the platform, writable, ::ancestor. |
Price/cost information tab > Standard cost section > Effective date > Read-only. This field shows the effective date for the current standard cost of the stock item. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
id |
varchar2 |
ID | writable, id |
||
intrastat_ |
varchar2 |
itgen_vnet_intrastat_cn8 | filters on the platform, writable, ::ancestor. |
Represents the 8 digit level Combine Nomenclature commodity code specific for the year for which the creating / actualizations Intrastat declarations is drafted. | |
intrastat_ |
varchar2 |
itgen_vnet_intrastat_countryoforigin | filters on the platform, writable, ::ancestor. |
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_ |
varchar2 |
itgen_vnet_intrastat_supplementarymeasureunit | filters on the platform, writable, ::ancestor. |
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. | |
inventory |
int32 |
Inventory ID | filters on the platform, writable, ::ancestor. |
The unique internal identifier of the item as is stored in the database. This Id is not visible in the window. | |
inventory |
varchar2 |
Inventory Number | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Item Id* > The unique alphanumeric identifier of the stock item. | |
item |
varchar2 |
Item Class Description | filters on the platform, writable, ::ancestor. |
The description. | |
item |
varchar2 |
Item Class Error Information | filters on the platform, writable, ::ancestor. |
||
item |
varchar2 |
Item Class ID | filters on the platform, writable, ::ancestor. |
The identifier. | |
item |
int64 |
Item Class Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
item |
int64 |
Item Class Metadata Total Count | filters on the platform, writable, ::ancestor. |
||
item |
varchar2 |
Item Class Type | filters on the platform, writable, ::ancestor. |
||
kit |
char |
itgen_vnet_kititem | filters on the platform, writable, ::ancestor. |
||
last |
double |
Last Cost | filters on the platform, writable, ::ancestor. |
Price/cost information tab > Standard cost section > Last cost > Read-only. This field showing the last standard cost defined for the stock item. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Information collected from system. | |
lot |
varchar2 |
itgen_vnet_lotserialclass_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
lot |
varchar2 |
itgen_vnet_lotserialclass_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
Icon Notes on top of the window > Pop-up window for providing any user-defined text connected to the inventory item. | |
packaging_ |
double |
itgen_vnet_packaging_baseitemvolume | filters on the platform, writable, ::ancestor. |
The volume of the Base Unit of the item. | |
packaging_ |
double |
itgen_vnet_packaging_baseitemweight | filters on the platform, writable, ::ancestor. |
The weight of the Base Unit of the item. | |
packaging_ |
varchar2 |
itgen_vnet_packaging_volumeuom | filters on the platform, writable, ::ancestor. |
The Unit of Measure used for the Volume of the item. | |
packaging_ |
varchar2 |
itgen_vnet_packaging_weightuom | filters on the platform, writable, ::ancestor. |
The Unit of Measure used for the Weight of the item. | |
pending |
double |
Pending Cost | filters on the platform, writable, ::ancestor. |
Price/cost information tab > Standard cost section > Pending cost > The pending standard cost for the stock item. | |
pending |
datetime |
Pending Cost Date | filters on the platform, writable, ::ancestor. |
Price/cost information tab > Standard cost section > Pending cost date > The date when the pending standard cost becomes effective. | |
posting |
varchar2 |
itgen_vnet_postingclass_description | filters on the platform, writable, ::ancestor. |
The description. | |
posting |
varchar2 |
itgen_vnet_postingclass_id | filters on the platform, writable, ::ancestor. |
The identifier. | |
posting |
int64 |
itgen_vnet_postingclass_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
posting |
int64 |
itgen_vnet_postingclass_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
price |
varchar2 |
itgen_vnet_priceclassid | filters on the platform, writable, ::ancestor. |
The Price/cost information tab > Price management section > Price class > The price class of the item. | |
price |
varchar2 |
Price Class Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
price |
varchar2 |
Price Class ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
price |
guid |
itgen_vnet_pricemanagerid | filters on the platform, writable, ::ancestor. |
The Price/cost information tab > Price management section > Price manager > The ID of the manager responsible for the product pricing. | |
price |
varchar2 |
itgen_vnet_pricemanager_id | filters on the platform, writable, ::ancestor. |
||
price |
varchar2 |
itgen_vnet_pricemanager_name | filters on the platform, writable, ::ancestor. |
||
price |
int32 |
itgen_vnet_priceworkgroupid | filters on the platform, writable, ::ancestor. |
The Price/cost information tab > Price management section > Price work group > The work group responsible for product pricing. Select the pricing work group for the stock item. | |
purchase |
varchar2 |
itgen_vnet_purchaseunit | filters on the platform, writable, ::ancestor. |
Mandatory field: General information tab > Unit of measurement section > Purchase unit *> The UoM to be used as the purchase unit for the stock item. | |
recommended |
double |
itgen_vnet_recommendedprice | filters on the platform, writable, ::ancestor. |
The Price/cost information tab > Price management section > List price > The manufacturer's suggested retail price (MSRP) of the stock item. | |
sales |
varchar2 |
Sales Unit | filters on the platform, writable, ::ancestor. |
Mandatory field: General information tab > Unit of measurement section > Sales unit *> The UoM to be used as the sales unit for the stock item. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
The top part > Item status > The status of the stock item. The alternatives are: Active, No sales, No purchases, No request, Inactive, Marked for deletion. | |
stock |
char |
Stock Item | filters on the platform, writable, ::ancestor. |
||
timestamp |
varchar2 |
Timestamp | filters on the platform, writable, ::ancestor. |
Timestamp of the inventory item record | |
type |
varchar2 |
Type | filters on the platform, writable, ::ancestor. |
General information tab > Item defaults section > Type > The type of stock item. | |
unspsc |
varchar2 |
itgen_vnet_unspsc | filters on the platform, writable, ::ancestor. |
General information tab > UNSPSC Code > The UNSPSC code for the stock item. | |
value |
varchar2 |
Value | writable, value |
Value > The value of the attribute. | |
vat |
varchar2 |
VAT Code Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
vat |
varchar2 |
VAT Code ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: