Table 7132 Item Budget Name

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/ItemBudgetName.Table.al121 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 7132 "Item Budget Name"{    Caption = 'Item Budget Name';    LookupPageID = "Item Budget Names";    DataClassification = CustomerContent;    fields    {        field(1; "Analysis Area"; Enum "Analysis Area Type")        {            Caption = 'Analysis Area';        }        field(2; Name; Code[10])        {            Caption = 'Name';            ToolTip = 'Specifies the name of the item budget.';            NotBlank = true;        }        field(3; Description; Text[80])        {            Caption = 'Description';            ToolTip = 'Specifies a description of the item budget.';        }        field(4; Blocked; Boolean)        {            Caption = 'Blocked';            ToolTip = 'Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.';        }        field(5; "Budget Dimension 1 Code"; Code[20])        {            Caption = 'Budget Dimension 1 Code';            ToolTip = 'Specifies a dimension code for Item Budget Dimension 1.';            TableRelation = Dimension;            trigger OnValidate()            begin                if "Budget Dimension 1 Code" <> xRec."Budget Dimension 1 Code" then begin                    if Dim.CheckIfDimUsed("Budget Dimension 1 Code", Enum::"Dim Type Checked".FromInteger(17), Name, '', "Analysis Area".AsInteger()) then                        Error(Text000, Dim.GetCheckDimErr());                    Modify();                end;            end;        }        field(6; "Budget Dimension 2 Code"; Code[20])        {            Caption = 'Budget Dimension 2 Code';            ToolTip = 'Specifies a dimension code for Item Budget Dimension 2.';            TableRelation = Dimension;            trigger OnValidate()            begin                if "Budget Dimension 2 Code" <> xRec."Budget Dimension 2 Code" then begin                    if Dim.CheckIfDimUsed("Budget Dimension 2 Code", Enum::"Dim Type Checked".FromInteger(18), Name, '', "Analysis Area".AsInteger()) then                        Error(Text000, Dim.GetCheckDimErr());                    Modify();                end;            end;        }        field(7; "Budget Dimension 3 Code"; Code[20])        {            Caption = 'Budget Dimension 3 Code';            ToolTip = 'Specifies a dimension code for Item Budget Dimension 3.';            TableRelation = Dimension;            trigger OnValidate()            begin                if "Budget Dimension 3 Code" <> xRec."Budget Dimension 3 Code" then begin                    if Dim.CheckIfDimUsed("Budget Dimension 3 Code", Enum::"Dim Type Checked".FromInteger(19), Name, '', "Analysis Area".AsInteger()) then                        Error(Text000, Dim.GetCheckDimErr());                    Modify();                end;            end;        }    }    keys    {        key(Key1; "Analysis Area", Name)        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        ItemBudgetEntry: Record "Item Budget Entry";        ItemAnalysisViewBudgetEntry: Record "Item Analysis View Budg. Entry";    begin        ItemBudgetEntry.SetCurrentKey("Analysis Area", "Budget Name");        ItemBudgetEntry.SetRange("Analysis Area", "Analysis Area");        ItemBudgetEntry.SetRange("Budget Name", Name);        ItemBudgetEntry.DeleteAll(true);        ItemAnalysisViewBudgetEntry.SetRange("Analysis Area", "Analysis Area");        ItemAnalysisViewBudgetEntry.SetRange("Budget Name", Name);        ItemAnalysisViewBudgetEntry.DeleteAll();    end;    var        Dim: Record Dimension;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label '%1\You cannot use the same dimension twice in the same budget.';#pragma warning restore AA0470#pragma warning restore AA0074}