Query 261 G/L Entries
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") { } } }}