# PurchaseReceiptV2Transfers 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. - Catalog: `VismaNet` - Schema: `PurchaseReceiptV2` This is a read-only table function. The Visma.net Financials API may not support changing the data or the Invantive UniversalSQL driver for Visma.net Financials does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Visma.net Financials API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `PurchaseReceiptV2Transfers`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `expandLines` | `` | ☐ | | 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. | | `fromWarehouse` | `` | ☐ | | Exact code of the shipping warehouse (the transfer order's source warehouse). | | `includeCustomFreeFields` | `` | ☐ | | 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. | | `orderNbr` | `` | ☐ | | Exact transfer order number. | | `orderType` | `` | ☐ | | Transfer order type. Candidates always originate from transfer-behaviour order types, for example TransferOrder. (Values: CreditNote, DebitNote, Invoice, QuoteOrder, RMAOrder, SalesOrder, StandardOrder, TransferOrder) | | `shipmentNbr` | `` | ☐ | | Exact shipment number. One order can be listed with several shipments; this narrows the result to one of them. | | `toWarehouse` | `` | ☐ | | Exact code of the receiving warehouse (the warehouse of the Transfer Receipt to create). | ## Columns of Table Function The columns of the table function `PurchaseReceiptV2Transfers` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `COMPANY_CODE` | `varchar2(30)` | Company Code | ☑ | Partition code, segmenting the data. | | `COMPANY_NAME` | `varchar2(240)` | Company Name | ☑ | Name of the partition. | | `date` | `datetime` | Date | ☐ | Date of the inventory transfer. | | `description` | `varchar2` | Description | ☐ | Description of the inventory transfer. | | `errorInfo` | `varchar2` | Error Message | ☐ | | | `fromWarehouse_description` | `varchar2` | | ☐ | Click on the magnifier. > The description. | | `fromWarehouse_id` | `varchar2` | | ☐ | Click on the magnifier. > The identifier. | | `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | ☐ | | | `metadata_totalCount` | `int64` | Total Count | ☐ | | | `orderNbr` | `varchar2` | Order Number | ☐ | Transfer order number; use it as transferOrderNbr when creating the receipt line. | | `orderType` | `varchar2` | Order Type | ☐ | Transfer order type; use it as transferOrderType when creating the receipt line. | | `shipmentNbr` | `varchar2` | | ☐ | Confirmed shipment number that moved the stock into transit. | | `toWarehouse_description` | `varchar2` | To Warehouse Description | ☐ | Click on the magnifier. > The description. | | `toWarehouse_id` | `varchar2` | To Warehouse ID | ☐ | Click on the magnifier. > The identifier. | | `transferNbr` | `varchar2` | | ☐ | Reference number of the released inventory transfer created by the shipment. |