invantive documentation
Invantive Support ForumsLog In / Sign Up

InventoryCrossReferencesByInventoryNumber3: Visma.net Financials Inventory Cross-references by Inventory Number

read only REST

  • Catalog: VismaNet
  • Schema: Inventory
  • Label: Inventory Cross-references by Inventory Number

Get a range of cross-reference for a specific inventory

Can only retrieve data.

API Source

  • Endpoint: /v1/inventory/{inventoryNumber}/crossReferences
  • Operation: get /v1/inventory/{inventoryNumber}/crossReferences

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 ``

Table Columns

The columns of the table InventoryCrossReferencesByInventoryNumber3 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.
alternateID varchar2 Alternate ID filters on the platform, writable, alternateID Mandatory field: Alternate ID > The alternate ID of the stock item (under the specified item ID) as used by the supplier or customer.
alternateType varchar2 Alternate Type filters on the platform, writable, alternateType Alternate type > The type of alternate codification used for the item if applicable.
bAccount_internalId int32 itgen_vnet_baccount_internalid filters on the platform, writable, bAccount.internalId
bAccount_name varchar2 itgen_vnet_baccount_name filters on the platform, writable, bAccount.name The name of the particular destination of the selected type.
bAccount_number varchar2 itgen_vnet_baccount_number filters on the platform, writable, bAccount.number The identifier of the particular destination of the selected type.
description varchar2 Description filters on the platform, writable, description Description > Any comments applicable to the specified cross-reference.
isDefault char Is Default filters on the platform, writable, isDefault Default > Indicates whether this cross-reference is marked as the default one.
timestamp varchar2 Timestamp filters on the platform, writable, timestamp Timestamp of the inventory item the crossreference belongs to
uom varchar2 Unit of Measure filters on the platform, writable, uom UoM > The unit of measure used for this component.

Release Notes

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