Query 5502 Tax Groups For Tax Areas

Base Application, Microsoft.Finance.SalesTax

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