Query 3691 Production BOM & Line Details

Base Application, Microsoft.Manufacturing.ProductionBOM

src/Layers/W1/BaseApp/Manufacturing/ProductionBOM/ProductionBOMLineDetails.Query.al97 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.ProductionBOM;using Microsoft.Inventory.Item;query 3691 "Production BOM & Line Details"{    QueryType = Normal;    OrderBy = ascending(No_);    elements    {        dataitem(Production_BOM_Header; "Production BOM Header")        {            column(No_; "No.")            {            }            column(Status; Status)            {            }            column(Low_Level_Code; "Low-Level Code")            {            }            dataitem(Production_BOM_Line; "Production BOM Line")            {                DataItemLink = "Production BOM No." = Production_BOM_Header."No.";                SqlJoinType = InnerJoin;                column(Type; Type)                {                }                column(Child_No_; "No.")                {                }                column(Version_Code; "Version Code")                {                }                dataitem(ChildItem; Item)                {                    DataItemLink = "No." = Production_BOM_Line."No.";                    SqlJoinType = LeftOuterJoin;                    column(ChildItem_No_; "No.")                    {                    }                    column(ChildItem_Low_Level_Code; "Low-Level Code")                    {                    }                    dataitem(ChildBOM; "Production BOM Header")                    {                        DataItemLink = "No." = Production_BOM_Line."No.";                        SqlJoinType = LeftOuterJoin;                        column(ChildBOM_No_; "No.")                        {                        }                        column(ChildBOM_Low_Level_Code; "Low-Level Code")                        {                        }                        column(ChildBOM_Status; Status)                        {                        }                        dataitem(Production_BOM_Version; "Production BOM Version")                        {                            DataItemLink = "Production BOM No." = Production_BOM_Header."No.", "Version Code" = Production_BOM_Line."Version Code";                            SqlJoinType = LeftOuterJoin;                            column(BOM_Version_Code; "Version Code")                            {                            }                            column(BOM_Version_Status; Status)                            {                            }                            column(BOM_Version_StartingDate; "Starting Date")                            {                            }                        }                    }                }            }        }    }}