Query 36980 Whse. Journal Lines - From Bin

PowerBI Reports, Microsoft.Inventory.PowerBIReports

src/Apps/W1/PowerBIReports/App/Inventory/APIs/WhseJournalLinesFromBin.Query.al57 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.Warehouse.Journal;query 36980 "Whse. Journal Lines - From Bin"{    Access = Internal;    Caption = 'Power BI From Bin Warehouse Journal Lines';    QueryType = API;    AboutText = 'Provides access to warehouse journal lines with source bin information including item quantities, bin codes, zones, and tracking numbers. Enables Power BI reports to analyze pending warehouse movements from source bins for warehouse planning and reconciliation.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'fromBinWarehouseJournalLine';    EntitySetName = 'fromBinWarehouseJournalLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(warehouseJournalLine; "Warehouse Journal Line")        {            column(fromBinCode; "From Bin Code")            {            }            column(itemNo; "Item No.")            {            }            column(locationCode; "Location Code")            {            }            column(qtyBase; "Qty. (Absolute, Base)")            {                Method = Sum;            }            column(lotNo; "Lot No.")            {            }            column(serialNo; "Serial No.")            {            }            column(fromZoneCode; "From Zone Code")            {            }            column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure")            {            }            column(unitOfMeasureCode; "Unit of Measure Code")            {            }        }    }}