PurchaseReceiptV2Transfers_LinesAllocations: Visma.net Financials itgen_vnet_purchasereceiptv2transfers_linesallocations_plural
read only REST
- Catalog:
VismaNet - Schema:
PurchaseReceiptV2 - Label: itgen_vnet_purchasereceiptv2transfers_linesallocations_plural
Get the transfer orders and shipments that can be received as a Transfer Receipt - ScreenId=PO302000, Add Transfer. One candidate is one transfer order within one confirmed shipment with stock still in transit; the same order can be listed with several shipments. Set expandLines=true to include the lines PO302000 would add, with remaining quantities, lot/serial allocations, line description and note (default false); add includeCustomFreeFields=true to read the custom free fields of the transfer order line and of its shipment line onto each line. Availability is a snapshot.
Can only retrieve data.
API Source
- Endpoint:
/v2/PurchaseReceipt/transfers - Operation:
get /v2/PurchaseReceipt/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 |
|---|---|---|---|---|
expand |
`` | Include the lines PO302000 would add for each candidate, with remaining quantities and lot/serial allocations. Default false: only headers are returned and the lines property is omitted. | ||
from |
`` | Exact code of the shipping warehouse (the transfer order's source warehouse). | ||
include |
`` | Include the custom free fields of the transfer order line (salesOrderLineCustomStr1..5, salesOrderLineCustomDec1..2, salesOrderLineCustomInt1..2, salesOrderLineCustomDateTimeUTC1) and of its shipment line (shipmentLineCustomStr1..5, shipmentLineCustomDec1..2, shipmentLineCustomInt1..2, shipmentLineCustomDateTimeUTC1) on each expanded line. Default false. Only meaningful together with expandLines=true. | ||
order |
`` | Exact transfer order number. | ||
order |
`` | Transfer order type. Candidates always originate from transfer-behaviour order types, for example TransferOrder. (Values: CreditNote, DebitNote, Invoice, QuoteOrder, RMAOrder, SalesOrder, StandardOrder, TransferOrder) | ||
shipment |
`` | Exact shipment number. One order can be listed with several shipments; this narrows the result to one of them. | ||
to |
`` | Exact code of the receiving warehouse (the warehouse of the Transfer Receipt to create). |
Table Columns
The columns of the table PurchaseReceiptV2Transfers_LinesAllocations 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, ::ancestor. |
Remaining receivable quantity in the inventory item's base UOM. | |
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
Date of the inventory transfer. | |
description |
varchar2 |
Description | writable, ::ancestor. |
Description of the source transfer line; PO302000 copies it onto the receipt line (transactionDescription on create). | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
Description of the inventory transfer. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
expiration |
datetime |
Expiration Date | writable, expiration |
Expiration date of the lot/serial: the source transfer line date when it has one, otherwise the item lot date; omitted when neither applies. | |
from |
varchar2 |
itgen_vnet_fromwarehouse_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
from |
varchar2 |
itgen_vnet_fromwarehouse_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
inventory |
varchar2 |
itgen_vnet_inventoryitem_description | writable, ::ancestor. |
Name of item/description | |
inventory |
varchar2 |
itgen_vnet_inventoryitem_number | writable, ::ancestor. |
Number of item | |
location_ |
varchar2 |
Location Country ID | writable, location. |
Location*. | |
location_ |
varchar2 |
Location Country ID 2 | writable, ::ancestor. |
Location*. | |
location_ |
varchar2 |
Location ID | writable, location. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location ID 2 | writable, ::ancestor. |
Click the magnifier > The identifier | |
location_ |
varchar2 |
Location Name | writable, location. |
Click the magnifier > The displayed name | |
location_ |
varchar2 |
Location Name 2 | writable, ::ancestor. |
Click the magnifier > The displayed name | |
lot |
varchar2 |
Lot Serial Number | writable, lot |
Lot/serial number of the allocated stock; omitted for items without lot/serial tracking. | |
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, ::ancestor. |
Note of the source transfer line; omitted when the line has none. PO302000 does not copy it onto the receipt line. | |
order |
int32 |
itgen_vnet_orderlinenbr | writable, ::ancestor. |
Transfer order line number; use it as transferOrderLineNbr when creating the receipt line. | |
order |
varchar2 |
Order Number | filters on the platform, writable, ::ancestor. |
Transfer order number; use it as transferOrderNbr when creating the receipt line. | |
order |
varchar2 |
Order Type | filters on the platform, writable, ::ancestor. |
Transfer order type; use it as transferOrderType when creating the receipt line. | |
quantity |
double |
Quantity | writable, quantity |
Remaining receivable quantity of this allocation, in the inventory item's base UOM. | |
quantity_ |
double |
itgen_vnet_quantity_2 | writable, ::ancestor. |
Remaining receivable quantity in the source line UOM. | |
sales |
datetime |
itgen_vnet_salesorderlinecustomdatetimeutc1 | writable, ::ancestor. |
A free custom column of type DateTime - in UTC timezone. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
double |
itgen_vnet_salesorderlinecustomdec1 | writable, ::ancestor. |
A free custom column of type decimal with max 4 decimals. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
double |
itgen_vnet_salesorderlinecustomdec2 | writable, ::ancestor. |
A free custom column of type decimal with max 4 decimals. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
int32 |
itgen_vnet_salesorderlinecustomint1 | writable, ::ancestor. |
A free custom column of type int. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
int32 |
itgen_vnet_salesorderlinecustomint2 | writable, ::ancestor. |
A free custom column of type int. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
varchar2 |
itgen_vnet_salesorderlinecustomstr1 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
varchar2 |
itgen_vnet_salesorderlinecustomstr2 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
varchar2 |
itgen_vnet_salesorderlinecustomstr3 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
varchar2 |
itgen_vnet_salesorderlinecustomstr4 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
sales |
varchar2 |
itgen_vnet_salesorderlinecustomstr5 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | |
shipment |
datetime |
itgen_vnet_shipmentlinecustomdatetimeutc1 | writable, ::ancestor. |
A free custom column of type DateTime - in UTC timezone. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
double |
itgen_vnet_shipmentlinecustomdec1 | writable, ::ancestor. |
A free custom column of type decimal with max 4 decimals. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
double |
itgen_vnet_shipmentlinecustomdec2 | writable, ::ancestor. |
A free custom column of type decimal with max 4 decimals. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
int32 |
itgen_vnet_shipmentlinecustomint1 | writable, ::ancestor. |
A free custom column of type int. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
int32 |
itgen_vnet_shipmentlinecustomint2 | writable, ::ancestor. |
A free custom column of type int. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
varchar2 |
itgen_vnet_shipmentlinecustomstr1 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
varchar2 |
itgen_vnet_shipmentlinecustomstr2 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
varchar2 |
itgen_vnet_shipmentlinecustomstr3 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
varchar2 |
itgen_vnet_shipmentlinecustomstr4 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
varchar2 |
itgen_vnet_shipmentlinecustomstr5 | writable, ::ancestor. |
A free custom column of type string with max length 100. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | |
shipment |
int32 |
itgen_vnet_shipmentlinenbr | writable, ::ancestor. |
Shipment line number. | |
shipment |
varchar2 |
itgen_vnet_shipmentnbr | filters on the platform, writable, ::ancestor. |
Confirmed shipment number that moved the stock into transit. | |
subitem |
varchar2 |
itgen_vnet_subitem | writable, subitem |
Subitem code of the allocated stock; omitted when the item has no subitems. | |
subitem_ |
varchar2 |
itgen_vnet_subitem_2 | writable, ::ancestor. |
Subitem code when all allocations share one subitem; otherwise omitted. | |
to |
varchar2 |
To Warehouse Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
to |
varchar2 |
To Warehouse ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
transfer |
int32 |
itgen_vnet_transferlinenbr | writable, ::ancestor. |
Line number on the inventory transfer, not a receipt line number. | |
transfer |
varchar2 |
itgen_vnet_transfernbr | writable, ::ancestor. |
Reference number of the inventory transfer holding the transit stock. | |
transfer |
varchar2 |
itgen_vnet_transfernbr_2 | filters on the platform, writable, ::ancestor. |
Reference number of the released inventory transfer created by the shipment. | |
uom |
varchar2 |
Unit of Measure | writable, uom |
Inventory base UOM, as used by receipt allocations. | |
uom_2 |
varchar2 |
itgen_vnet_uom_2 | writable, ::ancestor. |
Unit of measure of the source transfer line. | |
warehouse_ |
varchar2 |
Warehouse Description | writable, ::ancestor. |
Click on the magnifier. > The description. | |
warehouse_ |
varchar2 |
Warehouse ID | writable, ::ancestor. |
Click on the magnifier. > The identifier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: