Query 36977 Transfer Lines
src/Apps/W1/PowerBIReports/App/Inventory/APIs/TransferLines.Query.al67 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Inventory.PowerBIReports;using Microsoft.Inventory.Transfer;query 36977 "Transfer Lines"{ Access = Internal; Caption = 'Power BI Qty. on Transfer Lines'; QueryType = API; AboutText = 'Provides access to transfer order line data including in-transit quantities, outstanding quantities, shipment and receipt dates, and location codes. Enables Power BI reports to track inventory in transit and analyze inter-location stock movements for logistics planning.'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'transferLine'; EntitySetName = 'transferLines'; DataAccessIntent = ReadOnly; elements { dataitem(transferLine; "Transfer Line") { DataItemTableFilter = "Derived From Line No." = const(0); column(documentNo; "Document No.") { } column(itemNo; "Item No.") { } column(inTransitLocationCode; "In-Transit Code") { } column(transferToLocationCode; "Transfer-to Code") { } column(transferFromLocationCode; "Transfer-from Code") { } column(qtyInTransitBase; "Qty. in Transit (Base)") { Method = Sum; } column(outstandingQtyBase; "Outstanding Qty. (Base)") { Method = Sum; } column(receiptDate; "Receipt Date") { } column(shipmentDate; "Shipment Date") { } column(dimensionSetID; "Dimension Set ID") { } column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure") { } column(unitOfMeasureCode; "Unit of Measure Code") { } } }}