Query 36959 G/L Accounts

PowerBI Reports, Microsoft.Finance.PowerBIReports

src/Apps/W1/PowerBIReports/App/Finance/APIs/GLAccounts.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.PowerBIReports;using Microsoft.Finance.GeneralLedger.Account;query 36959 "G/L Accounts"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to general ledger account master data including account numbers, names, types, income/balance classification, and hierarchy structure. Enables Power BI reports to build chart of accounts hierarchies, categorize financial data, and structure balance sheet and income statement reports.';    Caption = 'Power BI G/L Accounts';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'generalLedgerAccount';    EntitySetName = 'generalLedgerAccounts';    DataAccessIntent = ReadOnly;    elements    {        dataitem(GLAccount; "G/L Account")        {            column(accountNo; "No.")            {            }            column(accountName; Name)            {            }            column(accountType; "Account Type")            {            }            column(incomeBalance; "Income/Balance")            {            }            column(accountSubcategoryEntryNo; "Account Subcategory Entry No.")            {            }            column(indentation; Indentation)            {            }            column(totaling; Totaling)            {            }        }    }}