Query 261 G/L Entries, source in 29

Source29

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")
            {
            }
        }
    }
}