Query 36953 Items - PBI API
src/Apps/W1/PowerBIReports/App/Core/APIs/ItemsPBIAPI.Query.al57 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.PowerBIReports;using Microsoft.Inventory.Item;#if not CLEAN28#pragma warning disable AL0801#endifquery 36953 "Items - PBI API"{ Access = Internal; Caption = 'Power BI Items'; QueryType = API; AboutText = 'Provides access to item master data including descriptions, unit costs, posting groups, production BOMs, routings, and rolled-up cost components. Enables Power BI reports to analyze product catalogs, manufacturing costs, and inventory valuations for comprehensive item-based analytics and reporting.'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'item'; EntitySetName = 'items'; DataAccessIntent = ReadOnly; elements { dataitem(Item; Item) { column(itemNo; "No.") { } column(itemDescription; Description) { } column(baseUnitofMeasure; "Base Unit of Measure") { } column(unitCost; "Unit Cost") { } column(inventoryPostingGroup; "Inventory Posting Group") { } column(routingNo; "Routing No.") { } column(productionBomNo; "Production BOM No.") { } column(replenishmentSystem; "Replenishment System") { } column(singleLevelCapOvhdCost; "Single-Level Cap. Ovhd Cost") { } column(singleLevelCapacityCost; "Single-Level Capacity Cost") { } column(singleLevelMaterialCost; "Single-Level Material Cost") { } column(singleLevelMfgOvhdCost; "Single-Level Mfg. Ovhd Cost") { } column(singleLevelSubcontrdCost; "Single-Level Subcontrd. Cost") { } column(singleLvlMatNonInvtCost; "Single-Lvl Mat. Non-Invt. Cost") { } column(rolledUpCapOverheadCost; "Rolled-up Cap. Overhead Cost") { } column(rolledUpCapacityCost; "Rolled-up Capacity Cost") { } column(rolledUpMatNonInvtCost; "Rolled-up Mat. Non-Invt. Cost") { } column(rolledUpMaterialCost; "Rolled-up Material Cost") { } column(rolledUpMfgOvhdCost; "Rolled-up Mfg. Ovhd Cost") { } column(rolledUpSubcontractedCost; "Rolled-up Subcontracted Cost") { } column(scrapPrc; "Scrap %") { } dataitem(ItemCategory; "Item Category") { DataItemLink = Code = Item."Item Category Code"; column(itemCategoryCode; Code) { } column(itemCategoryDescription; Description) { } } } }}