Query 36977 Transfer Lines

PowerBI Reports, Microsoft.Inventory.PowerBIReports

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")            {            }        }    }}