Query 270 G/L Budget Entries, source in 29

Source29

src/Layers/W1/BaseApp/Finance/GeneralLedger/Budget/GLBudgetEntries.Query.al49 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.Finance.GeneralLedger.Budget;

/// <summary>
/// Optimized query for high-performance access to G/L budget entry data with selective column projection.
/// Provides efficient data access for reporting, analysis, and integration scenarios requiring budget information.
/// </summary>
/// <remarks>
/// Performance: Optimized column selection reduces data transfer and improves query execution speed.
/// Use cases: Budget reporting, data integration, analytics platforms, and API-based access patterns.
/// Integration: Suitable for external reporting tools, data warehousing, and automated budget analysis workflows.
/// </remarks>
query 270 "G/L Budget Entries"
{
    Caption = 'G/L Budget Entries';

    elements
    {
        dataitem(G_L_Budget_Entry; "G/L Budget Entry")
        {
            column(Entry_No; "Entry No.")
            {
            }
            column(Budget_Name; "Budget Name")
            {
            }
            column(G_L_Account_No; "G/L Account No.")
            {
            }
            column(Business_Unit_Code; "Business Unit Code")
            {
            }
            column(Date; Date)
            {
            }
            column(Amount; Amount)
            {
            }
            column(Dimension_Set_ID; "Dimension Set ID")
            {
            }
        }
    }
}