Query 36989 Prod. Order Lines - Manuf.

PowerBI Reports, Microsoft.Manufacturing.PowerBIReports

src/Apps/W1/PowerBIReports/App/Manufacturing/APIs/ProdOrderLinesManuf.Query.al71 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.Manufacturing.PowerBIReports;using Microsoft.Inventory.Location;using Microsoft.Manufacturing.Document;#if not CLEAN28#pragma warning disable AL0801#endifquery 36989 "Prod. Order Lines - Manuf."{    Access = Internal;    Caption = 'Power BI Production Order Lines';    QueryType = API;    AboutText = 'Provides access to production order line data including quantities, finished quantities, due dates, routings, and cost parameters. Enables Power BI reports to analyze production order progress, output tracking, and manufacturing performance metrics.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'manufacturingProdOrderLines';    EntitySetName = 'manufacturingProdOrderLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(ProdOrderLine; "Prod. Order Line")        {            column(prodOrderStatus; Status) { }            column(prodOrderNo; "Prod. Order No.") { }            column(prodOrderLineNo; "Line No.") { }            column(itemNo; "Item No.") { }            column(locationCode; "Location Code") { }            column(quantityBase; "Quantity (Base)")            {                Method = Sum;            }            column(remainingQtyBase; "Remaining Qty. (Base)")            {                Method = Sum;            }            column(dueDate; "Due Date") { }            column(routingNo; "Routing No.") { }            column(routingReferenceNo; "Routing Reference No.") { }            column(routingType; "Routing Type") { }            column(dimensionSetID; "Dimension Set ID") { }            column(finishedQtyBase; "Finished Qty. (Base)") { }            column(scrapPrc; "Scrap %") { }            column(overheadRate; "Overhead Rate") { }            column(planningLevelCode; "Planning Level Code") { }            column(indirectCostPercent; "Indirect Cost %") { }            dataitem(Location; Location)            {                DataItemLink = Code = ProdOrderLine."Location Code";                column(locationName; Name) { }            }        }    }    trigger OnBeforeOpen()    var        PBIMgt: Codeunit "Manuf. Filter Helper";        DateFilterText: Text;    begin        DateFilterText := PBIMgt.GenerateManufacturingReportDateFilter();        if DateFilterText <> '' then            CurrQuery.SetFilter(dueDate, DateFilterText);    end;}