invantive documentation
Invantive Support ForumsLog In / Sign Up

InventoryAttachments: Visma.net Financials Inventory Attachments

read only REST

  • Catalog: VismaNet
  • Schema: Inventory
  • Label: Inventory Attachments

Get a range of Inventory items - ScreenId=IN202000 and IN202500 Data for Inventory

Can only retrieve data.

Summary

Data for Inventory

API Source

  • Endpoint: /v1/inventory
  • Operation: get /v1/inventory

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
addCostPriceStatistics `` This filter can be used only for stock items, from the Price/cost information tab.
alternateID `` Applies for both Stock and Non-stock items. Some fields in this filter applies only for one of these.
attachmentLastModifiedDateTime `` System retrieved information for last modified date and time for attachment.
attachmentLastModifiedDateTimeCondition `` System retrieved information for state/condition for attachment.
attributes `` Attributes (additional information) connected to the entity. Examples: {{base}}/inventory?attributes={"AttributeID":"ValueID","AttributeID":"ValueID"} {{base}}/inventory?attributes={"AttributeID":"ValueID1,ValueID2"}
availabilityLastModifiedDateTime `` System retrieved information.
availabilityLastModifiedDateTimeCondition `` System retrieved information for state/condition.
createdDateTime `` This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
createdDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
description `` A brief description of the stock item from the Top part of the window.
expandAccountInformation `` Set to true to retrieve information about the account information connected to the item.
expandAttachment `` Set to true to retrieve information about the attachments connected to the item.
expandAttribute `` Set to true to retrieve the attribute descriptions used for the item.
expandCrossReference `` These expand fields are by default set to true, but will be changed in the future. Set to true to retrieve information about the cross-references (item ID and suppliers/customers ID for the item connected to the item.
expandInventoryUnits `` Set to true to retrieve information about the units of measure connected to the item.
expandNote `` Set to true to retrieve the note value connected to the item.
expandSalesCategories `` Set to true to retrieve details about the sales categories connected to the item.
expandSupplierDetails `` Set to true to retrieve details about the supplier connected to the item.
expandWarehouseDetail `` Set to true to retrieve information about the warehouse connected to the item.
greaterThanValue `` Greater than value. The item which is the object for this, varies from API to API.
inventoryNumber `` The Item ID.
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
salesCategory `` The Category ID for the sales category, found on the Attributes tab.
status `` The inventory item status (Values: Active, NoSales, NoPurchases, NoRequest, Inactive, MarkedForDeletion)

Table Columns

The columns of the table InventoryAttachments 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.
accountInformation_cogsAccount_description varchar2 itgen_vnet_accountinformation_cogsaccount_description filters on the platform, writable, ::ancestor.accountInformation.cogsAccount.description Name of item/description
accountInformation_cogsAccount_number varchar2 itgen_vnet_accountinformation_cogsaccount_number filters on the platform, writable, ::ancestor.accountInformation.cogsAccount.number Number of item
accountInformation_cogsAccount_type varchar2 itgen_vnet_accountinformation_cogsaccount_type filters on the platform, writable, ::ancestor.accountInformation.cogsAccount.type
accountInformation_cogsSubaccount_active char itgen_vnet_accountinformation_cogssubaccount_active filters on the platform, writable, ::ancestor.accountInformation.cogsSubaccount.active
accountInformation_cogsSubaccount_description varchar2 itgen_vnet_accountinformation_cogssubaccount_description filters on the platform, writable, ::ancestor.accountInformation.cogsSubaccount.description Click on the magnifier. > The description.
accountInformation_cogsSubaccount_id varchar2 itgen_vnet_accountinformation_cogssubaccount_id filters on the platform, writable, ::ancestor.accountInformation.cogsSubaccount.id Click on the magnifier. > The identifier.
accountInformation_expenseAccount_description varchar2 itgen_vnet_accountinformation_expenseaccount_description filters on the platform, writable, ::ancestor.accountInformation.expenseAccount.description Name of item/description
accountInformation_expenseAccount_number varchar2 itgen_vnet_accountinformation_expenseaccount_number filters on the platform, writable, ::ancestor.accountInformation.expenseAccount.number Number of item
accountInformation_expenseAccount_type varchar2 itgen_vnet_accountinformation_expenseaccount_type filters on the platform, writable, ::ancestor.accountInformation.expenseAccount.type
accountInformation_expenseAccrualAccount_description varchar2 itgen_vnet_accountinformation_expenseaccrualaccount_description filters on the platform, writable, ::ancestor.accountInformation.expenseAccrualAccount.description Name of item/description
accountInformation_expenseAccrualAccount_number varchar2 itgen_vnet_accountinformation_expenseaccrualaccount_number filters on the platform, writable, ::ancestor.accountInformation.expenseAccrualAccount.number Number of item
accountInformation_expenseAccrualAccount_type varchar2 itgen_vnet_accountinformation_expenseaccrualaccount_type filters on the platform, writable, ::ancestor.accountInformation.expenseAccrualAccount.type
accountInformation_expenseEuAccount_description varchar2 itgen_vnet_accountinformation_expenseeuaccount_description filters on the platform, writable, ::ancestor.accountInformation.expenseEuAccount.description Name of item/description
accountInformation_expenseEuAccount_number varchar2 itgen_vnet_accountinformation_expenseeuaccount_number filters on the platform, writable, ::ancestor.accountInformation.expenseEuAccount.number Number of item
accountInformation_expenseEuAccount_type varchar2 itgen_vnet_accountinformation_expenseeuaccount_type filters on the platform, writable, ::ancestor.accountInformation.expenseEuAccount.type
accountInformation_expenseImportAccount_description varchar2 itgen_vnet_accountinformation_expenseimportaccount_description filters on the platform, writable, ::ancestor.accountInformation.expenseImportAccount.description Name of item/description
accountInformation_expenseImportAccount_number varchar2 itgen_vnet_accountinformation_expenseimportaccount_number filters on the platform, writable, ::ancestor.accountInformation.expenseImportAccount.number Number of item
accountInformation_expenseImportAccount_type varchar2 itgen_vnet_accountinformation_expenseimportaccount_type filters on the platform, writable, ::ancestor.accountInformation.expenseImportAccount.type
accountInformation_expenseNonTaxableAccount_description varchar2 itgen_vnet_accountinformation_expensenontaxableaccount_description filters on the platform, writable, ::ancestor.accountInformation.expenseNonTaxableAccount.description Name of item/description
accountInformation_expenseNonTaxableAccount_number varchar2 itgen_vnet_accountinformation_expensenontaxableaccount_number filters on the platform, writable, ::ancestor.accountInformation.expenseNonTaxableAccount.number Number of item
accountInformation_expenseNonTaxableAccount_type varchar2 itgen_vnet_accountinformation_expensenontaxableaccount_type filters on the platform, writable, ::ancestor.accountInformation.expenseNonTaxableAccount.type
accountInformation_expenseSubaccount_active char itgen_vnet_accountinformation_expensesubaccount_active filters on the platform, writable, ::ancestor.accountInformation.expenseSubaccount.active
accountInformation_expenseSubaccount_description varchar2 itgen_vnet_accountinformation_expensesubaccount_description filters on the platform, writable, ::ancestor.accountInformation.expenseSubaccount.description Click on the magnifier. > The description.
accountInformation_expenseSubaccount_id varchar2 itgen_vnet_accountinformation_expensesubaccount_id filters on the platform, writable, ::ancestor.accountInformation.expenseSubaccount.id Click on the magnifier. > The identifier.
accountInformation_inventoryAccount_description varchar2 itgen_vnet_accountinformation_inventoryaccount_description filters on the platform, writable, ::ancestor.accountInformation.inventoryAccount.description Name of item/description
accountInformation_inventoryAccount_number varchar2 itgen_vnet_accountinformation_inventoryaccount_number filters on the platform, writable, ::ancestor.accountInformation.inventoryAccount.number Number of item
accountInformation_inventoryAccount_type varchar2 itgen_vnet_accountinformation_inventoryaccount_type filters on the platform, writable, ::ancestor.accountInformation.inventoryAccount.type
accountInformation_salesAccount_description varchar2 itgen_vnet_accountinformation_salesaccount_description filters on the platform, writable, ::ancestor.accountInformation.salesAccount.description Name of item/description
accountInformation_salesAccount_number varchar2 itgen_vnet_accountinformation_salesaccount_number filters on the platform, writable, ::ancestor.accountInformation.salesAccount.number Number of item
accountInformation_salesAccount_type varchar2 itgen_vnet_accountinformation_salesaccount_type filters on the platform, writable, ::ancestor.accountInformation.salesAccount.type
accountInformation_salesEuAccount_description varchar2 itgen_vnet_accountinformation_saleseuaccount_description filters on the platform, writable, ::ancestor.accountInformation.salesEuAccount.description Name of item/description
accountInformation_salesEuAccount_number varchar2 itgen_vnet_accountinformation_saleseuaccount_number filters on the platform, writable, ::ancestor.accountInformation.salesEuAccount.number Number of item
accountInformation_salesEuAccount_type varchar2 itgen_vnet_accountinformation_saleseuaccount_type filters on the platform, writable, ::ancestor.accountInformation.salesEuAccount.type
accountInformation_salesExportAccount_description varchar2 itgen_vnet_accountinformation_salesexportaccount_description filters on the platform, writable, ::ancestor.accountInformation.salesExportAccount.description Name of item/description
accountInformation_salesExportAccount_number varchar2 itgen_vnet_accountinformation_salesexportaccount_number filters on the platform, writable, ::ancestor.accountInformation.salesExportAccount.number Number of item
accountInformation_salesExportAccount_type varchar2 itgen_vnet_accountinformation_salesexportaccount_type filters on the platform, writable, ::ancestor.accountInformation.salesExportAccount.type
accountInformation_salesNonTaxableAccount_description varchar2 itgen_vnet_accountinformation_salesnontaxableaccount_description filters on the platform, writable, ::ancestor.accountInformation.salesNonTaxableAccount.description Name of item/description
accountInformation_salesNonTaxableAccount_number varchar2 itgen_vnet_accountinformation_salesnontaxableaccount_number filters on the platform, writable, ::ancestor.accountInformation.salesNonTaxableAccount.number Number of item
accountInformation_salesNonTaxableAccount_type varchar2 itgen_vnet_accountinformation_salesnontaxableaccount_type filters on the platform, writable, ::ancestor.accountInformation.salesNonTaxableAccount.type
accountInformation_salesSubaccount_active char itgen_vnet_accountinformation_salessubaccount_active filters on the platform, writable, ::ancestor.accountInformation.salesSubaccount.active
accountInformation_salesSubaccount_description varchar2 itgen_vnet_accountinformation_salessubaccount_description filters on the platform, writable, ::ancestor.accountInformation.salesSubaccount.description Click on the magnifier. > The description.
accountInformation_salesSubaccount_id varchar2 itgen_vnet_accountinformation_salessubaccount_id filters on the platform, writable, ::ancestor.accountInformation.salesSubaccount.id Click on the magnifier. > The identifier.
baseUnit varchar2 Base Unit filters on the platform, writable, ::ancestor.baseUnit 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.body The top part > Body *> A brief description of the stock item.
costPriceStatistics_averageCost double itgen_vnet_costpricestatistics_averagecost filters on the platform, writable, ::ancestor.costPriceStatistics.averageCost Cost price statistics section > Average cost > The average cost for the stock item.
costPriceStatistics_lastCost double itgen_vnet_costpricestatistics_lastcost filters on the platform, writable, ::ancestor.costPriceStatistics.lastCost Cost price statistics section > Last cost > The last standard cost used for the stock item.
costPriceStatistics_maxCost double itgen_vnet_costpricestatistics_maxcost filters on the platform, writable, ::ancestor.costPriceStatistics.maxCost Cost price statistics section > Max. cost > The maximum cost for the stock item.
costPriceStatistics_minCost double itgen_vnet_costpricestatistics_mincost filters on the platform, writable, ::ancestor.costPriceStatistics.minCost Cost price statistics section > Min. cost > The minimum cost for the stock item.
currentCost double itgen_vnet_currentcost filters on the platform, writable, ::ancestor.currentCost Price/cost information tab > Standard cost section > Current cost > 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, ::ancestor.defaultIssueFrom.description Click on the magnifier. > The description.
defaultIssueFrom_id varchar2 itgen_vnet_defaultissuefrom_id filters on the platform, writable, ::ancestor.defaultIssueFrom.id Click on the magnifier. > The identifier.
defaultPrice double Default Price filters on the platform, writable, ::ancestor.defaultPrice Price/cost information tab > Price management section > Default price > The price of the stock item.
defaultReceiptTo_description varchar2 itgen_vnet_defaultreceiptto_description filters on the platform, writable, ::ancestor.defaultReceiptTo.description Click on the magnifier. > The description.
defaultReceiptTo_id varchar2 itgen_vnet_defaultreceiptto_id filters on the platform, writable, ::ancestor.defaultReceiptTo.id Click on the magnifier. > The identifier.
defaultWarehouse_description varchar2 itgen_vnet_defaultwarehouse_description filters on the platform, writable, ::ancestor.defaultWarehouse.description Click on the magnifier. > The description.
defaultWarehouse_id varchar2 itgen_vnet_defaultwarehouse_id filters on the platform, writable, ::ancestor.defaultWarehouse.id Click on the magnifier. > The identifier.
description varchar2 Description filters on the platform, writable, ::ancestor.description The top part > Description *> A brief description of the stock item.
effectiveDate datetime Effective Date filters on the platform, writable, ::ancestor.effectiveDate 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.
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.errorInfo
id guid ID writable, id The ID of the attachment
intrastat_cN8 varchar2 itgen_vnet_intrastat_cn8 filters on the platform, writable, ::ancestor.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, ::ancestor.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, ::ancestor.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, ::ancestor.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, ::ancestor.inventoryNumber Mandatory field: The top part > Item Id* > The unique alphanumeric identifier of the stock item.
itemClass_description varchar2 Item Class Description filters on the platform, writable, ::ancestor.itemClass.description The description.
itemClass_errorInfo varchar2 Item Class Error Information filters on the platform, writable, ::ancestor.itemClass.errorInfo
itemClass_id varchar2 Item Class ID filters on the platform, writable, ::ancestor.itemClass.id The identifier.
itemClass_metadata_maxPageSize int64 Item Class Metadata Max Pagesize filters on the platform, writable, ::ancestor.itemClass.metadata.maxPageSize
itemClass_metadata_totalCount int64 Item Class Metadata Total Count filters on the platform, writable, ::ancestor.itemClass.metadata.totalCount
itemClass_type varchar2 Item Class Type filters on the platform, writable, ::ancestor.itemClass.type
kitItem char itgen_vnet_kititem filters on the platform, writable, ::ancestor.kitItem
lastCost double Last Cost filters on the platform, writable, ::ancestor.lastCost Price/cost information tab > Standard cost section > Last cost > Read-only. This field showing the last standard cost defined for the stock item.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.lastModifiedDateTime Information collected from system.
lotSerialClass_description varchar2 itgen_vnet_lotserialclass_description filters on the platform, writable, ::ancestor.lotSerialClass.description Click on the magnifier. > The description.
lotSerialClass_id varchar2 itgen_vnet_lotserialclass_id filters on the platform, writable, ::ancestor.lotSerialClass.id Click on the magnifier. > The identifier.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, ::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, ::ancestor.metadata.totalCount
name varchar2 Name writable, name The name of the attachment.
note varchar2 Note filters on the platform, writable, ::ancestor.note Icon Notes on top of the window > 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, ::ancestor.packaging.baseItemVolume The volume of the Base Unit of the item.
packaging_baseItemWeight double itgen_vnet_packaging_baseitemweight filters on the platform, writable, ::ancestor.packaging.baseItemWeight The weight of the Base Unit of the item.
packaging_volumeUOM varchar2 itgen_vnet_packaging_volumeuom filters on the platform, writable, ::ancestor.packaging.volumeUOM The Unit of Measure used for the Volume of the item.
packaging_weightUOM varchar2 itgen_vnet_packaging_weightuom filters on the platform, writable, ::ancestor.packaging.weightUOM The Unit of Measure used for the Weight of the item.
pendingCost double Pending Cost filters on the platform, writable, ::ancestor.pendingCost Price/cost information tab > Standard cost section > Pending cost > The pending standard cost for the stock item.
pendingCostDate datetime Pending Cost Date filters on the platform, writable, ::ancestor.pendingCostDate Price/cost information tab > Standard cost section > Pending cost date > The date when the pending standard cost becomes effective.
postingClass_description varchar2 itgen_vnet_postingclass_description filters on the platform, writable, ::ancestor.postingClass.description The description.
postingClass_id varchar2 itgen_vnet_postingclass_id filters on the platform, writable, ::ancestor.postingClass.id The identifier.
postingClass_metadata_maxPageSize int64 itgen_vnet_postingclass_metadata_maxpagesize filters on the platform, writable, ::ancestor.postingClass.metadata.maxPageSize
postingClass_metadata_totalCount int64 itgen_vnet_postingclass_metadata_totalcount filters on the platform, writable, ::ancestor.postingClass.metadata.totalCount
priceClassID varchar2 itgen_vnet_priceclassid filters on the platform, writable, ::ancestor.priceClassID The Price/cost information tab > Price management section > Price class > The price class of the item.
priceClass_description varchar2 Price Class Description filters on the platform, writable, ::ancestor.priceClass.description Click on the magnifier. > The description.
priceClass_id varchar2 Price Class ID filters on the platform, writable, ::ancestor.priceClass.id Click on the magnifier. > The identifier.
priceManagerID guid itgen_vnet_pricemanagerid filters on the platform, writable, ::ancestor.priceManagerID The Price/cost information tab > Price management section > Price manager > The ID of the manager responsible for the product pricing.
priceManager_id varchar2 itgen_vnet_pricemanager_id filters on the platform, writable, ::ancestor.priceManager.id
priceManager_name varchar2 itgen_vnet_pricemanager_name filters on the platform, writable, ::ancestor.priceManager.name
priceWorkgroupID int32 itgen_vnet_priceworkgroupid filters on the platform, writable, ::ancestor.priceWorkgroupID 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.
purchaseUnit varchar2 itgen_vnet_purchaseunit filters on the platform, writable, ::ancestor.purchaseUnit Mandatory field: General information tab > Unit of measurement section > Purchase unit *> The UoM to be used as the purchase unit for the stock item.
recommendedPrice double itgen_vnet_recommendedprice filters on the platform, writable, ::ancestor.recommendedPrice The Price/cost information tab > Price management section > List price > The manufacturer's suggested retail price (MSRP) of the stock item.
revision int32 Revision writable, revision The version of the attachment.
salesUnit varchar2 Sales Unit filters on the platform, writable, ::ancestor.salesUnit 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.status 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.
stockItem char Stock Item filters on the platform, writable, ::ancestor.stockItem
timestamp varchar2 Timestamp filters on the platform, writable, ::ancestor.timestamp Timestamp of the inventory item record
type varchar2 Type filters on the platform, writable, ::ancestor.type General information tab > Item defaults section > Type > The type of stock item.
unspsc varchar2 itgen_vnet_unspsc filters on the platform, writable, ::ancestor.unspsc General information tab > UNSPSC Code > The UNSPSC code for the stock item.
vatCode_description varchar2 VAT Code Description filters on the platform, writable, ::ancestor.vatCode.description Click on the magnifier. > The description.
vatCode_id varchar2 VAT Code ID filters on the platform, writable, ::ancestor.vatCode.id Click on the magnifier. > The identifier.

Release Notes

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