Query 5502 Tax Groups For Tax Areas
src/Layers/W1/BaseApp/Finance/SalesTax/TaxGroupsForTaxAreas.Query.al42 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.SalesTax;/// <summary>/// Queries tax groups associated with tax areas through jurisdiction mappings./// Provides a cross-reference of available tax group codes for specific tax areas./// </summary>query 5502 "Tax Groups For Tax Areas"{ Caption = 'Tax Groups For Tax Areas'; elements { dataitem(Tax_Area; "Tax Area") { column(Tax_Area_Code; "Code") { } dataitem(Tax_Area_Line; "Tax Area Line") { DataItemLink = "Tax Area" = Tax_Area.Code; SqlJoinType = InnerJoin; column(Tax_Jurisdiction_Code; "Tax Jurisdiction Code") { } dataitem(Tax_Detail; "Tax Detail") { DataItemLink = "Tax Jurisdiction Code" = Tax_Area_Line."Tax Jurisdiction Code"; SqlJoinType = InnerJoin; column(Tax_Group_Code; "Tax Group Code") { } } } } }}