Table 7153 Item Analysis View Filter

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/ItemAnalysisViewFilter.Table.al111 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.Inventory.Analysis;using Microsoft.Finance.Dimension;table 7153 "Item Analysis View Filter"{    Caption = 'Item Analysis View Filter';    LookupPageID = "Item Analysis View Filter";    DataClassification = CustomerContent;    fields    {        field(1; "Analysis Area"; Enum "Analysis Area Type")        {            Caption = 'Analysis Area';        }        field(2; "Analysis View Code"; Code[10])        {            Caption = 'Analysis View Code';            NotBlank = true;            TableRelation = "Item Analysis View".Code where("Analysis Area" = field("Analysis Area"),                                                             Code = field("Analysis View Code"));        }        field(3; "Dimension Code"; Code[20])        {            Caption = 'Dimension Code';            ToolTip = 'Specifies a dimension code that the dimension value filter will be linked to.';            NotBlank = true;            TableRelation = Dimension;        }        field(4; "Dimension Value Filter"; Code[250])        {            Caption = 'Dimension Value Filter';            ToolTip = 'Specifies the dimension value that the analysis view is based on.';            TableRelation = "Dimension Value".Code where("Dimension Code" = field("Dimension Code"));            ValidateTableRelation = false;        }    }    keys    {        key(Key1; "Analysis Area", "Analysis View Code", "Dimension Code")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        ItemAnalysisView: Record "Item Analysis View";        ItemAnalysisViewFilter: Record "Item Analysis View Filter";    begin        ItemAnalysisView.Get("Analysis Area", "Analysis View Code");        ItemAnalysisView.TestField(Blocked, false);        ItemAnalysisView.ValidateDelete(ItemAnalysisViewFilter.FieldCaption("Dimension Code"));        ItemAnalysisView.ItemAnalysisViewReset();        ItemAnalysisView.Modify();    end;    trigger OnInsert()    begin        ValidateModifyFilter();    end;    trigger OnModify()    begin        ValidateModifyFilter();    end;    trigger OnRename()    begin        Error(Text000, TableCaption);    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'You cannot rename an %1.';#pragma warning restore AA0470#pragma warning restore AA0074    local procedure ValidateModifyFilter()    var        ItemAnalysisView: Record "Item Analysis View";        ItemAnalysisViewFilter: Record "Item Analysis View Filter";    begin        ItemAnalysisView.Get("Analysis Area", "Analysis View Code");        ItemAnalysisView.TestField(Blocked, false);        if (ItemAnalysisView."Last Entry No." <> 0) and (xRec."Dimension Code" <> "Dimension Code") then begin            ItemAnalysisView.ValidateDelete(ItemAnalysisViewFilter.FieldCaption("Dimension Code"));            ItemAnalysisView.ItemAnalysisViewReset();            "Dimension Value Filter" := '';            ItemAnalysisView.Modify();        end;        if (ItemAnalysisView."Last Entry No." <> 0) and (xRec."Dimension Value Filter" <> "Dimension Value Filter") then begin            ItemAnalysisView.ValidateDelete(ItemAnalysisViewFilter.FieldCaption("Dimension Value Filter"));            ItemAnalysisView.ItemAnalysisViewReset();            ItemAnalysisView.Modify();        end;    end;}