Query 36968 Item Ledger Entries - PBI API

PowerBI Reports, Microsoft.Inventory.PowerBIReports

src/Apps/W1/PowerBIReports/App/Inventory/APIs/ItemLedgerEntriesPBIAPI.Query.al94 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.Inventory.PowerBIReports;using Microsoft.Inventory.Ledger;query 36968 "Item Ledger Entries - PBI API"{    Access = Internal;    Caption = 'Power BI Item Ledger Entries';    QueryType = API;    AboutText = 'Provides access to item ledger entries including entry types, quantities, costs, locations, serial and lot numbers, and posting dates. Enables Power BI reports to analyze inventory movements, track stock levels, and perform inventory valuation and turnover analysis.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'itemLedgerEntry';    EntitySetName = 'itemLedgerEntries';    DataAccessIntent = ReadOnly;    elements    {        dataitem(itemLedgerEntry; "Item Ledger Entry")        {            column(entryNo; "Entry No.")            {            }            column(entryType; "Entry Type")            {            }            column(sourceType; "Source Type")            {            }            column(sourceNo; "Source No.")            {            }            column(documentNo; "Document No.")            {            }            column(documentType; "Document Type")            {            }            column(postingDate; "Posting Date")            {            }            column(itemNo; "Item No.")            {            }            column(locationCode; "Location Code")            {            }            column(serialNo; "Serial No.")            {            }            column(expirationDate; "Expiration Date")            {            }            column(lotNo; "Lot No.")            {            }            column(quantity; Quantity)            {            }            column(unitOfMeasureCode; "Unit of Measure Code")            {            }            column(remainingQuantity; "Remaining Quantity")            {            }            column(costAmountActual; "Cost Amount (Actual)")            {            }            column(salesAmountActual; "Sales Amount (Actual)")            {            }            column(dimensionSetID; "Dimension Set ID")            {            }            column(open; Open)            {            }            column(positive; Positive)            {            }            column(invoicedQuantity; "Invoiced Quantity")            {            }            column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure")            {            }        }    }}