Query 36978 Warehouse Activity Lines
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") { } } }}