Table 351 Dimension Value Combination

Base Application, Microsoft.Finance.Dimension

src/Layers/W1/BaseApp/Finance/Dimension/DimensionValueCombination.Table.al76 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.Dimension;/// <summary>/// Stores blocked dimension value combinations to prevent invalid dimension pairings./// Defines restrictions between specific dimension values to enforce business rules and compliance requirements./// </summary>/// <remarks>/// Used by dimension validation to prevent incompatible dimension value combinations during posting./// Supports business rule enforcement where certain department and project combinations are not allowed./// Integrates with dimension management validation to block restricted dimension combinations across all transactions./// </remarks>table 351 "Dimension Value Combination"{    Caption = 'Dimension Value Combination';    DataClassification = CustomerContent;    fields    {        /// <summary>        /// First dimension code in the blocked combination pair.        /// </summary>        field(1; "Dimension 1 Code"; Code[20])        {            Caption = 'Dimension 1 Code';            NotBlank = true;            TableRelation = Dimension.Code;        }        /// <summary>        /// First dimension value code that forms part of the blocked combination.        /// </summary>        field(2; "Dimension 1 Value Code"; Code[20])        {            Caption = 'Dimension 1 Value Code';            NotBlank = true;            TableRelation = "Dimension Value".Code where("Dimension Code" = field("Dimension 1 Code"),                                                         Blocked = const(false));        }        /// <summary>        /// Second dimension code in the blocked combination pair.        /// </summary>        field(3; "Dimension 2 Code"; Code[20])        {            Caption = 'Dimension 2 Code';            NotBlank = true;            TableRelation = Dimension.Code;        }        /// <summary>        /// Second dimension value code that forms part of the blocked combination.        /// </summary>        field(4; "Dimension 2 Value Code"; Code[20])        {            Caption = 'Dimension 2 Value Code';            NotBlank = true;            TableRelation = "Dimension Value".Code where("Dimension Code" = field("Dimension 2 Code"),                                                         Blocked = const(false));        }    }    keys    {        key(Key1; "Dimension 1 Code", "Dimension 1 Value Code", "Dimension 2 Code", "Dimension 2 Value Code")        {            Clustered = true;        }    }    fieldgroups    {    }}