Table 411 IC Dimension
src/Layers/W1/BaseApp/Finance/Intercompany/Dimension/ICDimension.Table.al117 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.Intercompany.Dimension;using Microsoft.Finance.Dimension;/// <summary>/// Stores intercompany dimension definitions for cross-company dimension mapping and synchronization./// Enables consistent dimension structure across multiple intercompany partners./// </summary>table 411 "IC Dimension"{ Caption = 'IC Dimension'; DataCaptionFields = "Code", Name; LookupPageID = "IC Dimension List"; DataClassification = CustomerContent; fields { /// <summary> /// Unique code identifying the intercompany dimension. /// </summary> field(1; "Code"; Code[20]) { Caption = 'Code'; NotBlank = true; } /// <summary> /// Descriptive name for the intercompany dimension. /// </summary> field(2; Name; Text[30]) { Caption = 'Name'; } /// <summary> /// Indicates whether the intercompany dimension is blocked from use. /// </summary> field(3; Blocked; Boolean) { Caption = 'Blocked'; } /// <summary> /// Local dimension code that this intercompany dimension maps to for transaction processing. /// </summary> field(4; "Map-to Dimension Code"; Code[20]) { Caption = 'Map-to Dimension Code'; TableRelation = Dimension; trigger OnValidate() begin if "Map-to Dimension Code" <> xRec."Map-to Dimension Code" then begin ICDimensionValue.SetRange("Dimension Code", Code); ICDimensionValue.ModifyAll("Map-to Dimension Code", "Map-to Dimension Code"); ICDimensionValue.ModifyAll("Map-to Dimension Value Code", ''); end; end; } } keys { key(Key1; "Code") { Clustered = true; } } fieldgroups { fieldgroup(DropDown; "Code", Name, Blocked, "Map-to Dimension Code") { } } trigger OnDelete() var ICDimValue: Record "IC Dimension Value"; begin RemoveDimensionMappings(); ICDimValue.SetRange("Dimension Code", Code); ICDimValue.DeleteAll(); end; var ICDimensionValue: Record "IC Dimension Value"; local procedure RemoveDimensionMappings() var Dimension: Record Dimension; DimensionValue: Record "Dimension Value"; begin Dimension.SetRange("Map-to IC Dimension Code", Rec."Code"); if not Dimension.IsEmpty() then begin Dimension.FindSet(); repeat DimensionValue.SetRange("Dimension Code", Dimension.Code); if not DimensionValue.IsEmpty() then begin DimensionValue.FindSet(); repeat if DimensionValue."Map-to IC Dimension Code" <> '' then begin DimensionValue."Map-to IC Dimension Code" := ''; DimensionValue."Map-to IC Dimension Value Code" := ''; DimensionValue.Modify(); end; until DimensionValue.Next() = 0; end; Dimension."Map-to IC Dimension Code" := ''; Dimension.Modify(); until Dimension.Next() = 0; end; end;}