Query 36964 Assembly Headers - Order

PowerBI Reports, Microsoft.Inventory.PowerBIReports

src/Apps/W1/PowerBIReports/App/Inventory/APIs/AssemblyHeadersOrder.Query.al62 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.Assembly.Document;query 36964 "Assembly Headers - Order"{    Access = Internal;    Caption = 'Power BI Assembly Headers';    QueryType = API;    AboutText = 'Provides access to assembly order header data including item numbers, quantities, remaining quantities, due dates, and status. Enables Power BI reports to track assembly order progress, analyze assembly-to-order demand, and monitor production scheduling for inventory planning.';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'assemblyHeader';    EntitySetName = 'assemblyHeaders';    DataAccessIntent = ReadOnly;    elements    {        dataitem(assemblyHeader; "Assembly Header")        {            DataItemTableFilter = "Document Type" = const(Order);            column(documentNo; "No.")            {            }            column(itemNo; "Item No.")            {            }            column(quantity; Quantity)            {                Method = Sum;            }            column(remainingQtyBase; "Remaining Quantity (Base)")            {                Method = Sum;            }            column(dueDate; "Due Date")            {            }            column(locationCode; "Location Code")            {            }            column(dimensionSetID; "Dimension Set ID")            {            }            column(status; Status)            {            }            column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure")            {            }            column(unitOfMeasureCode; "Unit of Measure Code")            {            }        }    }}