invantive documentation
Invantive Support ForumsLog In / Sign Up

InventoryReceiptTransfers_Lines: Visma.net Financials itgen_vnet_inventoryreceipttransfers_lines_plural

read only REST

  • Catalog: VismaNet
  • Schema: InventoryReceipt
  • Label: itgen_vnet_inventoryreceipttransfers_lines_plural

Get transfers available to receive in IN301000, including all remaining lines and allocations. Header totals belong to the original transfer. Availability is a snapshot.

Can only retrieve data.

API Source

  • Endpoint: /v1/inventoryReceipt/transfers
  • Operation: get /v1/inventoryReceipt/transfers

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
transferReferenceNumber `` Exact source transfer reference. Lines and allocations are always included.

Table Columns

The columns of the table InventoryReceiptTransfers_Lines 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.
baseQuantity double itgen_vnet_basequantity writable, baseQuantity Remaining receivable quantity in the inventory item's base UOM.
date datetime Date filters on the platform, writable, ::ancestor.date Transfer date.
description varchar2 Description writable, description Description of the source transfer line; the receipt line created from the transfer carries it.
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.description Transfer description.
documentType varchar2 Document Type filters on the platform, writable, ::ancestor.documentType Inventory document type; always Transfer for this endpoint.
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.errorInfo
externalReference varchar2 External Reference filters on the platform, writable, ::ancestor.externalReference External reference of the transfer.
inventoryItem_description varchar2 itgen_vnet_inventoryitem_description writable, inventoryItem.description Name of item/description
inventoryItem_number varchar2 itgen_vnet_inventoryitem_number writable, inventoryItem.number Number of item
location_countryId varchar2 Location Country ID writable, location.countryId Location*.
location_id varchar2 Location ID writable, location.id Click the magnifier > The identifier
location_name varchar2 Location Name writable, location.name Click the magnifier > The displayed name
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
note varchar2 Note writable, note Note of the source transfer line; omitted when the line has none.
postPeriod varchar2 Post Period filters on the platform, writable, ::ancestor.postPeriod Financial period of the transfer (YYYYMM).
quantity double Quantity writable, quantity Remaining receivable quantity in the source line UOM.
referenceNumber varchar2 Reference Number filters on the platform, writable, ::ancestor.referenceNumber Reference number of the transfer.
source varchar2 Source filters on the platform, writable, ::ancestor.source Originating module; always IN for this endpoint.
status varchar2 Status filters on the platform, writable, ::ancestor.status Document status; always Released for this endpoint.
subitem varchar2 itgen_vnet_subitem writable, subitem Subitem code when all allocations share one subitem; otherwise null.
timeStamp blob Timestamp filters on the platform, writable, ::ancestor.timeStamp Row version of the source transfer header.
totalAmount double Total Amount filters on the platform, writable, ::ancestor.totalAmount Original transfer total amount.
totalCost double itgen_vnet_totalcost filters on the platform, writable, ::ancestor.totalCost Original transfer total cost.
totalQuantity double Total Quantity filters on the platform, writable, ::ancestor.totalQuantity Original transfer total quantity, including already received quantities.
transferLineNumber int32 itgen_vnet_transferlinenumber writable, transferLineNumber Source transfer line number, not a receipt line number.
transferReferenceNumber varchar2 itgen_vnet_transferreferencenumber writable, transferReferenceNumber Reference number of the source transfer.
uom varchar2 Unit of Measure writable, uom Unit of measure of the source transfer line.
warehouse_description varchar2 Warehouse Description writable, warehouse.description Click on the magnifier. > The description.
warehouse_id varchar2 Warehouse ID 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: