# PurchaseReceiptV2Transfers_Lines 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_Lines`. 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_Lines` 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. | | `baseQuantity` | `double` | | ☐ | Remaining receivable quantity in the inventory item's base UOM. | | `date` | `datetime` | Date | ☐ | Date of the inventory transfer. | | `description_2` | `varchar2` | Description 2 | ☐ | Description of the inventory transfer. | | `description` | `varchar2` | Description | ☐ | Description of the source transfer line; PO302000 copies it onto the receipt line (transactionDescription on create). | | `errorInfo` | `varchar2` | Error Message | ☐ | | | `fromWarehouse_description` | `varchar2` | | ☐ | Click on the magnifier. > The description. | | `fromWarehouse_id` | `varchar2` | | ☐ | Click on the magnifier. > The identifier. | | `inventoryItem_description` | `varchar2` | | ☐ | Name of item/description | | `inventoryItem_number` | `varchar2` | | ☐ | Number of item | | `location_countryId` | `varchar2` | Location Country ID | ☐ | Location*. | | `location_id` | `varchar2` | Location ID | ☐ | Click the magnifier > The identifier | | `location_name` | `varchar2` | Location Name | ☐ | Click the magnifier > The displayed name | | `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | ☐ | | | `metadata_totalCount` | `int64` | Total Count | ☐ | | | `note` | `varchar2` | Note | ☐ | Note of the source transfer line; omitted when the line has none. PO302000 does not copy it onto the receipt line. | | `orderLineNbr` | `int32` | | ☐ | Transfer order line number; use it as transferOrderLineNbr when creating the receipt line. | | `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. | | `quantity` | `double` | Quantity | ☐ | Remaining receivable quantity in the source line UOM. | | `salesOrderLineCustomDateTimeUTC1` | `datetime` | | ☐ | A free custom column of type DateTime - in UTC timezone. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomDec1` | `double` | | ☐ | A free custom column of type decimal with max 4 decimals. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomDec2` | `double` | | ☐ | A free custom column of type decimal with max 4 decimals. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomInt1` | `int32` | | ☐ | A free custom column of type int. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomInt2` | `int32` | | ☐ | A free custom column of type int. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomStr1` | `varchar2` | | ☐ | A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomStr2` | `varchar2` | | ☐ | A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomStr3` | `varchar2` | | ☐ | A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomStr4` | `varchar2` | | ☐ | A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `salesOrderLineCustomStr5` | `varchar2` | | ☐ | A free custom column of type string with max length 100. Read from the transfer order line; present only with includeCustomFreeFields=true. | | `shipmentLineCustomDateTimeUTC1` | `datetime` | | ☐ | A free custom column of type DateTime - in UTC timezone. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | | `shipmentLineCustomDec1` | `double` | | ☐ | 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. | | `shipmentLineCustomDec2` | `double` | | ☐ | 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. | | `shipmentLineCustomInt1` | `int32` | | ☐ | A free custom column of type int. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | | `shipmentLineCustomInt2` | `int32` | | ☐ | A free custom column of type int. Read from the shipment line of the transfer order; present only with includeCustomFreeFields=true. | | `shipmentLineCustomStr1` | `varchar2` | | ☐ | 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. | | `shipmentLineCustomStr2` | `varchar2` | | ☐ | 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. | | `shipmentLineCustomStr3` | `varchar2` | | ☐ | 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. | | `shipmentLineCustomStr4` | `varchar2` | | ☐ | 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. | | `shipmentLineCustomStr5` | `varchar2` | | ☐ | 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. | | `shipmentLineNbr` | `int32` | | ☐ | Shipment line number. | | `shipmentNbr` | `varchar2` | | ☐ | Confirmed shipment number that moved the stock into transit. | | `subitem` | `varchar2` | | ☐ | Subitem code when all allocations share one subitem; otherwise omitted. | | `toWarehouse_description` | `varchar2` | To Warehouse Description | ☐ | Click on the magnifier. > The description. | | `toWarehouse_id` | `varchar2` | To Warehouse ID | ☐ | Click on the magnifier. > The identifier. | | `transferLineNbr` | `int32` | | ☐ | Line number on the inventory transfer, not a receipt line number. | | `transferNbr_2` | `varchar2` | | ☐ | Reference number of the released inventory transfer created by the shipment. | | `transferNbr` | `varchar2` | | ☐ | Reference number of the inventory transfer holding the transit stock. | | `uom` | `varchar2` | Unit of Measure | ☐ | Unit of measure of the source transfer line. | | `warehouse_description` | `varchar2` | Warehouse Description | ☐ | Click on the magnifier. > The description. | | `warehouse_id` | `varchar2` | Warehouse ID | ☐ | Click on the magnifier. > The identifier. |