Query 36953 Items - PBI API

PowerBI Reports, Microsoft.PowerBIReports

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) { }            }        }    }}