Query 58 Power BI GL Budgeted Amount

Base Application, Microsoft.Integration.PowerBI

src/Layers/W1/BaseApp/Integration/PowerBI/ReportingData/PowerBIGLBudgetedAmount.Query.al45 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.Integration.PowerBI;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;query 58 "Power BI GL Budgeted Amount"{    Caption = 'Power BI GL Budgeted Amount';    elements    {        dataitem(G_L_Account; "G/L Account")        {            column(GL_Account_No; "No.")            {            }            column(Name; Name)            {            }            column(Account_Type; "Account Type")            {                ColumnFilter = Account_Type = const(Posting);            }            column(Debit_Credit; "Debit/Credit")            {            }            dataitem(G_L_Budget_Entry; "G/L Budget Entry")            {                DataItemLink = "G/L Account No." = G_L_Account."No.";                column(Amount; Amount)                {                }                column(Date; Date)                {                }            }        }    }}