Query 36993 Job Planning Lines

PowerBI Reports, Microsoft.Projects.PowerBIReports

src/Apps/W1/PowerBIReports/App/Projects/APIs/JobPlanningLines.Query.al71 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.Projects.PowerBIReports;using Microsoft.Projects.Project.Planning;query 36993 "Job Planning Lines"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to project planning line data including planned quantities, costs, prices, line types, and planning dates. Enables Power BI reports to analyze project budgets, resource planning, and schedule forecasts by task and line type.';    Caption = 'Power BI Project Planning Line';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'jobPlanningLine';    EntitySetName = 'jobPlanningLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(jobPlanningLine; "Job Planning Line")        {            column(jobNo; "Job No.")            {            }            column(jobTaskNo; "Job Task No.")            {            }            column(lineNo; "Line No.")            {            }            column(jobType; Type)            {            }            column(lineType; "Line Type")            {            }            column(no; "No.")            {            }            column(description; Description)            {            }            column(quantity; Quantity)            {            }            column(unitCostLCY; "Unit Cost (LCY)")            {            }            column(totalCostLCY; "Total Cost (LCY)")            {            }            column(unitPriceLCY; "Unit Price (LCY)")            {            }            column(lineAmountLCY; "Line Amount (LCY)")            {            }            column(totalPriceLCY; "Total Price (LCY)")            {            }            column(planningDate; "Planning Date")            {            }        }    }}