Query 37020 Inv. Adj. Ent Order - PBI API
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") { } } }}