Query 36981 Whse. Journal Lines - To Bin

PowerBI Reports, Microsoft.Inventory.PowerBIReports

src/Apps/W1/PowerBIReports/App/Inventory/APIs/WhseJournalLinesToBin.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 36981 "Whse. Journal Lines - To Bin"{    Access = Internal;    Caption = 'Power BI To Bin Warehouse Journal Lines';    QueryType = API;    AboutText = 'Provides access to warehouse journal lines with destination bin information including item quantities, bin codes, zones, and tracking numbers. Enables Power BI reports to analyze pending warehouse movements to destination bins for warehouse planning and reconciliation.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'toBinWarehouseJournalLine';    EntitySetName = 'toBinWarehouseJournalLines';    DataAccessIntent = ReadOnly;    elements    {        dataitem(warehouseJournalLine; "Warehouse Journal Line")        {            column(toBinCode; "To 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(toZoneCode; "To Zone Code")            {            }            column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure")            {            }            column(unitOfMeasureCode; "Unit of Measure Code")            {            }        }    }}