Query 37020 Inv. Adj. Ent Order - PBI API

PowerBI Reports, Microsoft.Manufacturing.PowerBIReports

src/Apps/W1/PowerBIReports/App/Manufacturing/APIs/InvAdjEntOrderPBIAPI.Query.al44 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.Costing;#if not CLEAN28#pragma warning disable AL0801#endifquery 37020 "Inv. Adj. Ent Order - PBI API"{    Access = Internal;    Caption = 'Power BI Inventory Adjustment Entry Order';    QueryType = API;    AboutText = 'Provides access to inventory adjustment entries for production orders including single-level cost breakdowns for materials, capacity, subcontracting, and overhead. Enables Power BI reports to analyze production order costing, cost component analysis, and manufacturing variance reporting.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'inventoryAdjustmentEntryOrder';    EntitySetName = 'inventoryAdjustmentEntryOrders';    DataAccessIntent = ReadOnly;    elements    {        dataitem(Inventory_Adjmt__Entry__Order_; "Inventory Adjmt. Entry (Order)")        {            DataItemTableFilter = "Order Type" = const("Production");            column(itemNo; "Item No.") { }            column(orderLineNo; "Order Line No.") { }            column(orderNo; "Order No.") { }            column(singleLevelMaterialCost; "Single-Level Material Cost") { }            column(singleLevelCapacityCost; "Single-Level Capacity Cost") { }            column(singleLevelSubcontrdCost; "Single-Level Subcontrd. Cost") { }            column(singleLevelCapOvhdCost; "Single-Level Cap. Ovhd Cost") { }            column(singleLevelMfgOvhdCost; "Single-Level Mfg. Ovhd Cost") { }            column(iSFinished; "Is Finished") { }            column(completelyInvoiced; "Completely Invoiced") { }            column(indirectCostPercent; "Indirect Cost %") { }            column(overheadRate; "Overhead Rate") { }        }    }}