Query 2901 Item With Locations

Base Application, Microsoft.Manufacturing.Forecast

src/Layers/W1/BaseApp/Inventory/Forecast/ItemWithLocations.Query.al39 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.Manufacturing.Forecast;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;query 2901 "Item With Locations"{    QueryType = Normal;    ReadState = ReadUncommitted;    DataAccessIntent = ReadOnly;    elements    {        dataitem(Item; Item)        {            column(No_; "No.")            { }            column(Description; Description)            { }            column(Type; Type)            { }            dataitem(Item_Location; Location)            {                SqlJoinType = CrossJoin;                column(LocationCode; Code)                { }                column(LocationName; Name)                { }                column(Use_As_In_Transit; "Use As In-Transit")                { }            }        }    }}