Query 261 G/L Entries

Base Application, Microsoft.Finance.GeneralLedger.Ledger

src/Layers/W1/BaseApp/Finance/GeneralLedger/Ledger/GLEntries.Query.al118 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.Ledger;/// <summary>/// Query object providing structured access to G/L entry data for reporting and analysis./// Exposes key G/L entry fields in a query format for efficient data retrieval and aggregation./// </summary>/// <remarks>/// Data source: G/L Entry table. Includes entry numbers, account details, posting information, amounts, and dimensions./// Used for external data access, reporting tools, and business intelligence integration./// Supports filtering and aggregation of G/L entry data through query interface./// </remarks>query 261 "G/L Entries"{    Caption = 'G/L Entries';    elements    {        dataitem(G_L_Entry; "G/L Entry")        {            column(Entry_No; "Entry No.")            {            }            column(Transaction_No; "Transaction No.")            {            }            column(G_L_Account_No; "G/L Account No.")            {            }            column(Posting_Date; "Posting Date")            {            }            column(Document_Date; "Document Date")            {            }            column(Document_Type; "Document Type")            {            }            column(Document_No; "Document No.")            {            }            column(Source_Code; "Source Code")            {            }            column(Job_No; "Job No.")            {            }            column(Business_Unit_Code; "Business Unit Code")            {            }            column(Reason_Code; "Reason Code")            {            }            column(Gen_Posting_Type; "Gen. Posting Type")            {            }            column(Gen_Bus_Posting_Group; "Gen. Bus. Posting Group")            {            }            column(Gen_Prod_Posting_Group; "Gen. Prod. Posting Group")            {            }            column(Tax_Area_Code; "Tax Area Code")            {            }            column(Tax_Liable; "Tax Liable")            {            }            column(Tax_Group_Code; "Tax Group Code")            {            }            column(Use_Tax; "Use Tax")            {            }            column(VAT_Bus_Posting_Group; "VAT Bus. Posting Group")            {            }            column(VAT_Prod_Posting_Group; "VAT Prod. Posting Group")            {            }            column(IC_Partner_Code; "IC Partner Code")            {            }            column(Amount; Amount)            {            }            column(Debit_Amount; "Debit Amount")            {            }            column(Credit_Amount; "Credit Amount")            {            }            column(VAT_Amount; "VAT Amount")            {            }            column(Additional_Currency_Amount; "Additional-Currency Amount")            {            }            column(Add_Currency_Debit_Amount; "Add.-Currency Debit Amount")            {            }            column(Add_Currency_Credit_Amount; "Add.-Currency Credit Amount")            {            }            column(Dimension_Set_ID; "Dimension Set ID")            {            }            column(G_L_Account_Name; "G/L Account Name")            {            }        }    }}