Query 36996 Purch. Lines - Job Outstanding

PowerBI Reports, Microsoft.Projects.PowerBIReports

src/Apps/W1/PowerBIReports/App/Projects/APIs/PurchLinesJobOutstanding.Query.al65 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.Purchases.Document;query 36996 "Purch. Lines - Job Outstanding"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to outstanding purchase order lines linked to projects including quantities not yet received and outstanding amounts. Enables Power BI reports to analyze committed project costs and track purchase order delivery expectations.';    Caption = 'Power BI Outstanding PO Line';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'jobOutstandingPurchaseLine';    EntitySetName = 'jobOutstandingPurchaseLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(OutstandinguPOLine; "Purchase Line")        {            DataItemTableFilter = "Document Type" = filter(Order | Invoice),                                    "Job No." = filter(<> ''),                                    "Outstanding Qty. (Base)" = filter(> 0);            column(documentType; "Document Type")            {            }            column(documentNo; "Document No.")            {            }            column(no; "No.")            {            }            column(type; Type)            {            }            column(outstandingQtyBase; "Outstanding Qty. (Base)")            {            }            column(outstandingAmountLCY; "Outstanding Amount (LCY)")            {            }            column(jobNo; "Job No.")            {            }            column(jobTaskNo; "Job Task No.")            {            }            column(expectedReceiptDate; "Expected Receipt Date")            {            }            column(dimensionSetID; "Dimension Set ID")            {            }            column(description; Description)            {            }        }    }}