Query 36997 Purch. Lines - Job Received
src/Apps/W1/PowerBIReports/App/Projects/APIs/PurchLinesJobReceived.Query.al68 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 36997 "Purch. Lines - Job Received"{ Access = Internal; QueryType = API; AboutText = 'Provides access to purchase order lines linked to projects that have been received but not yet invoiced. Enables Power BI reports to analyze project accruals, pending invoices, and goods-received-not-invoiced values by project and task.'; Caption = 'Power BI Received Not Invoiced PO Line'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'jobReceivedNotInvoicedPurchaseLine'; EntitySetName = 'jobReceivedNotInvoicedPurchaseLines'; DataAccessIntent = ReadOnly; elements { dataitem(receivedNotInvoicedPOLine; "Purchase Line") { DataItemTableFilter = "Document Type" = const(Order), "Job No." = filter(<> ''), "Qty. Rcd. Not Invoiced (Base)" = filter(> 0); column(documentType; "Document Type") { } column(documentNo; "Document No.") { } column(no; "No.") { } column(lineNo; "Line No.") { } column(type; Type) { } column(qtyRcdNotInvoicedBase; "Qty. Rcd. Not Invoiced (Base)") { } column(amtRcdNotInvoicedLCY; "Amt. Rcd. Not Invoiced (LCY)") { } column(jobNo; "Job No.") { } column(jobTaskNo; "Job Task No.") { } column(expectedReceiptDate; "Expected Receipt Date") { } column(dimensionSetID; "Dimension Set ID") { } column(description; Description) { } } }}