Query 36974 Requisition Lines
src/Apps/W1/PowerBIReports/App/Inventory/APIs/RequisitionLines.Query.al84 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.Requisition;query 36974 "Requisition Lines"{ Access = Internal; Caption = 'Power BI Requisition Lines'; QueryType = API; AboutText = 'Provides access to requisition worksheet lines including item numbers, replenishment systems, quantities, and planning dates. Enables Power BI reports to analyze planned supply from requisition worksheets and forecast inventory replenishment from planning activities.'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'requisitionLine'; EntitySetName = 'requisitionLines'; DataAccessIntent = ReadOnly; elements { dataitem(Requisition_Line; "Requisition Line") { DataItemTableFilter = Type = const(Item); column(worksheetTemplateName; "Worksheet Template Name") { } column(journalBatchName; "Journal Batch Name") { } column(planningLineOrigin; "Planning Line Origin") { } column(replenishmentSystem; "Replenishment System") { } column(itemNo; "No.") { } column(transferFromCode; "Transfer-from Code") { } column(locationCode; "Location Code") { } column(dueDate; "Due Date") { } column(startingDate; "Starting Date") { } column(orderDate; "Order Date") { } column(transferShipmentDate; "Transfer Shipment Date") { } column(quantityBase; "Quantity (Base)") { } column(dimensionSetID; "Dimension Set ID") { } column(qtyPerUnitOfMeasure; "Qty. per Unit of Measure") { } column(unitOfMeasureCode; "Unit of Measure Code") { } } }}