Query 36978 Warehouse Activity Lines

PowerBI Reports, Microsoft.Inventory.PowerBIReports

src/Apps/W1/PowerBIReports/App/Inventory/APIs/WarehouseActivityLines.Query.al63 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.Warehouse.Activity;query 36978 "Warehouse Activity Lines"{    Access = Internal;    Caption = 'Power BI Warehouse Activity Lines';    QueryType = API;    AboutText = 'Provides access to warehouse activity lines for take and place actions including quantities, bins, items, and tracking information. Enables Power BI reports to analyze warehouse pick and put-away activities, workload distribution, and operational efficiency metrics.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'warehouseActivityLine';    EntitySetName = 'warehouseActivityLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(warehouseActivityLine; "Warehouse Activity Line")        {            DataItemTableFilter = "Action Type" = filter('Take|Place');            column(actionType; "Action Type")            {            }            column(assembleToOrder; "Assemble to Order")            {            }            column(atoComponent; "ATO Component")            {            }            column(binCode; "Bin Code")            {            }            column(itemNo; "Item No.")            {            }            column(locationCode; "Location Code")            {            }            column(qtyBase; "Qty. (Base)")            {                Method = Sum;            }            column(lotNo; "Lot No.")            {            }            column(serialNo; "Serial No.")            {            }            column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure")            {            }            column(unitOfMeasureCode; "Unit of Measure Code")            {            }        }    }}