Query 270 G/L Budget Entries
- App
- Base Application
- Namespace
- Microsoft.Finance.GeneralLedger.Budget
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
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")
{
}
}
}
}