Query 36972 Prod. Order Lines - Invt.
src/Apps/W1/PowerBIReports/App/Inventory/APIs/ProdOrderLinesInvt.Query.al64 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.Manufacturing.Document;#if not CLEAN28#pragma warning disable AL0801#endifquery 36972 "Prod. Order Lines - Invt."{ Access = Internal; Caption = 'Power BI Qty. on Production Orders'; QueryType = API; AboutText = 'Provides access to production order line data including item numbers, remaining quantities, due dates, and starting dates for planned to released orders. Enables Power BI reports to analyze production output schedules and forecast inventory receipts from manufacturing.'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'inventoryProdOrderLine'; EntitySetName = 'inventoryProdOrderLines'; DataAccessIntent = ReadOnly; elements { dataitem(prodOrderLine; "Prod. Order Line") { DataItemTableFilter = Status = filter(Planned .. Released); column(status; Status) { } column(documentNo; "Prod. Order No.") { } column(itemNo; "Item No.") { } column(locationCode; "Location Code") { } column(remainingQtyBase; "Remaining Qty. (Base)") { Method = Sum; } column(dueDate; "Due Date") { } column(startingDate; "Starting Date") { } column(dimensionSetID; "Dimension Set ID") { } column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure") { } column(unitOfMeasureCode; "Unit of Measure Code") { } } }}