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 |
|---|---|---|---|---|
transfer |
`` | 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
base |
double |
itgen_vnet_basequantity | writable, base |
Remaining receivable quantity in the inventory item's base UOM. | |
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
Transfer date. | |
description |
varchar2 |
Description | writable, description |
Description of the source transfer line; the receipt line created from the transfer carries it. | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
Transfer description. | |
document |
varchar2 |
Document Type | filters on the platform, writable, ::ancestor. |
Inventory document type; always Transfer for this endpoint. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
external |
varchar2 |
External Reference | filters on the platform, writable, ::ancestor. |
External reference of the transfer. | |
inventory |
varchar2 |
itgen_vnet_inventoryitem_description | writable, inventory |
Name of item/description | |
inventory |
varchar2 |
itgen_vnet_inventoryitem_number | writable, inventory |
Number of item | |
location_ |
varchar2 |
Location Country ID | writable, location. |
Location*. | |
location_ |
varchar2 |
Location ID | writable, location. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | writable, location. |
Click the magnifier > The displayed name | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
note |
varchar2 |
Note | writable, note |
Note of the source transfer line; omitted when the line has none. | |
post |
varchar2 |
Post Period | filters on the platform, writable, ::ancestor. |
Financial period of the transfer (YYYYMM). | |
quantity |
double |
Quantity | writable, quantity |
Remaining receivable quantity in the source line UOM. | |
reference |
varchar2 |
Reference Number | filters on the platform, writable, ::ancestor. |
Reference number of the transfer. | |
source |
varchar2 |
Source | filters on the platform, writable, ::ancestor. |
Originating module; always IN for this endpoint. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
Document status; always Released for this endpoint. | |
subitem |
varchar2 |
itgen_vnet_subitem | writable, subitem |
Subitem code when all allocations share one subitem; otherwise null. | |
time |
blob |
Timestamp | filters on the platform, writable, ::ancestor. |
Row version of the source transfer header. | |
total |
double |
Total Amount | filters on the platform, writable, ::ancestor. |
Original transfer total amount. | |
total |
double |
itgen_vnet_totalcost | filters on the platform, writable, ::ancestor. |
Original transfer total cost. | |
total |
double |
Total Quantity | filters on the platform, writable, ::ancestor. |
Original transfer total quantity, including already received quantities. | |
transfer |
int32 |
itgen_vnet_transferlinenumber | writable, transfer |
Source transfer line number, not a receipt line number. | |
transfer |
varchar2 |
itgen_vnet_transferreferencenumber | writable, transfer |
Reference number of the source transfer. | |
uom |
varchar2 |
Unit of Measure | writable, uom |
Unit of measure of the source transfer line. | |
warehouse_ |
varchar2 |
Warehouse Description | writable, warehouse. |
Click on the magnifier. > The description. | |
warehouse_ |
varchar2 |
Warehouse ID | writable, warehouse. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: