Query 37001 Purch. Lines - Item Received

PowerBI Reports, Microsoft.Purchases.PowerBIReports

src/Apps/W1/PowerBIReports/App/Purchasing/APIs/PurchLinesItemReceived.Query.al73 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.Purchases.PowerBIReports;using Microsoft.Purchases.Document;query 37001 "Purch. Lines - Item Received"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to purchase order lines for items received but not yet invoiced including quantities and amounts pending invoicing. Enables Power BI reports to analyze goods-received-not-invoiced accruals and pending vendor invoices.';    Caption = 'Power BI Received Not Invd. PO';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'itemReceivedNotInvoicedPurchaseLine';    EntitySetName = 'itemReceivedNotInvoicedPurchaseLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(purchaseHeader; "Purchase Header")        {            DataItemTableFilter = "Document Type" = const(Order);            column(purchaseOrderNo; "No.")            {            }            column(documentType; "Document Type")            {            }            column(vendorNo; "Pay-to Vendor No.")            {            }            column(orderDate; "Order Date")            {            }            column(purchaserCode; "Purchaser Code")            {            }            dataitem(purchaseLine; "Purchase Line")            {                DataItemLink = "Document Type" = purchaseHeader."Document Type", "Document No." = purchaseHeader."No.";                DataItemTableFilter = Type = const(Item), "Qty. Rcd. Not Invoiced (Base)" = filter(> 0);                column(purchaseLineDocumentType; "Document Type")                {                }                column(documentNo; "Document No.")                {                }                column(lineNo; "Line No.")                {                }                column(itemNo; "No.")                {                }                column(locationCode; "Location Code")                {                }                column(qtyRcdNotInvoicedBase; "Qty. Rcd. Not Invoiced (Base)")                {                }                column(amtRcdNotInvoicedLCY; "A. Rcd. Not Inv. Ex. VAT (LCY)")                {                }                column(dimensionSetID; "Dimension Set ID")                {                }            }        }    }}