Query 141 EU VAT Entries
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") { } } } }}