Query 36990 Prod. Order Routing Lines

PowerBI Reports, Microsoft.Manufacturing.PowerBIReports

src/Apps/W1/PowerBIReports/App/Manufacturing/APIs/ProdOrderRoutingLines.Query.al81 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 36990 "Prod. Order Routing Lines"{    Access = Internal;    Caption = 'Power BI Production Order Routing Lines';    QueryType = API;    AboutText = 'Provides access to production order routing line data including capacity needs, operation costs, setup/run/wait/move times, and scheduling dates. Enables Power BI reports to analyze routing efficiency, operation costs, and production scheduling performance.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'prodOrderRoutingLine';    EntitySetName = 'prodOrderRoutingLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(ProdOrderRoutingLine; "Prod. Order Routing Line")        {            column(routingStatus; "Routing Status") { }            column(status; Status) { }            column(prodOrderNo; "Prod. Order No.") { }            column(type; Type) { }            column(no; "No.") { }            column(description; Description) { }            column(locationCode; "Location Code") { }            column(expectedCapacityNeed; "Expected Capacity Need")            {                Method = Sum;            }            column(expectedOperationCostAmt; "Expected Operation Cost Amt.")            {                Method = Sum;            }            column(expectedCapacityOvhdCost; "Expected Capacity Ovhd. Cost")            {                Method = Sum;            }            column(endingDate; "Ending Date") { }            column(routingNo; "Routing No.") { }            column(routingReferenceNo; "Routing Reference No.") { }            column(operationNo; "Operation No.") { }            column(workCenterNo; "Work Center No.") { }            column(workCenterGroupCode; "Work Center Group Code") { }            column(routingLinkCode; "Routing Link Code") { }            column(setupTime; "Setup Time") { }            column(runTime; "Run Time") { }            column(waitTime; "Wait Time") { }            column(moveTime; "Move Time") { }            column(startingDateTime; "Starting Date-Time") { }            column(endingDateTime; "Ending Date-Time") { }            dataitem(Location; Location)            {                DataItemLink = Code = ProdOrderRoutingLine."Location Code";                column(locationName; Name) { }            }        }    }    trigger OnBeforeOpen()    var        PBIMgt: Codeunit "Manuf. Filter Helper";        DateFilterText: Text;    begin        DateFilterText := PBIMgt.GenerateManufacturingReportDateFilter();        if DateFilterText <> '' then            CurrQuery.SetFilter(endingDate, DateFilterText);    end;}