Query 36988 Prod. Order Comp. - Manuf.
src/Apps/W1/PowerBIReports/App/Manufacturing/APIs/ProdOrderCompManuf.Query.al59 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 36988 "Prod. Order Comp. - Manuf."{ Access = Internal; Caption = 'Power BI Production Order Components'; QueryType = API; AboutText = 'Provides access to production order component data including expected and remaining quantities, costs, routing links, and due dates. Enables Power BI reports to analyze material requirements, component availability, and flushing method effectiveness for production planning.'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'manufacturingProdOrderComponent'; EntitySetName = 'manufacturingProdOrderComponents'; DataAccessIntent = ReadOnly; elements { dataitem(ProdOrderComponent; "Prod. Order Component") { column(prodOrderStatus; Status) { } column(prodOrderNo; "Prod. Order No.") { } column(prodOrderLineNo; "Prod. Order Line No.") { } column(itemNo; "Item No.") { } column(locationCode; "Location Code") { } column(expectedQtyBase; "Expected Qty. (Base)") { } column(remainingQtyBase; "Remaining Qty. (Base)") { } column(dueDate; "Due Date") { } column(routingLinkCode; "Routing Link Code") { } column(dimensionSetID; "Dimension Set ID") { } column(costAmount; "Cost Amount") { } dataitem(Location; Location) { DataItemLink = Code = ProdOrderComponent."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;}