Query 36990 Prod. Order Routing Lines
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;}