Query 141 EU VAT Entries

Base Application, Microsoft.Finance.VAT.Reporting

src/Layers/W1/BaseApp/Finance/VAT/Reporting/EUVATEntries.Query.al69 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.VAT.Reporting;using Microsoft.Finance.VAT.Ledger;using Microsoft.Foundation.Address;/// <summary>/// Data query for extracting VAT entry information for European Union sales reporting./// Filters VAT entries by sale type and provides access to base amounts, VAT amounts, and country information./// </summary>query 141 "EU VAT Entries"{    Caption = 'EU VAT Entries';    elements    {        dataitem(VAT_Entry; "VAT Entry")        {            DataItemTableFilter = Type = const(Sale);            column(Base; Base)            {            }            column(PostingDate; "Posting Date")            {            }            column(VATReportingDate; "VAT Reporting Date")            {            }            column(DocumentDate; "Document Date")            {            }            column(Type; Type)            {            }            column(EU_3_Party_Trade; "EU 3-Party Trade")            {            }            column(VAT_Registration_No; "VAT Registration No.")            {            }            column(EU_Service; "EU Service")            {            }            column(Entry_No; "Entry No.")            {            }            dataitem(Country_Region; "Country/Region")            {                DataItemLink = Code = VAT_Entry."Country/Region Code";                SqlJoinType = InnerJoin;                DataItemTableFilter = "EU Country/Region Code" = filter(<> '');                column(Name; Name)                {                }                column(EU_Country_Region_Code; "EU Country/Region Code")                {                }                column(CountryCode; "Code")                {                }            }        }    }}