Table 1002 Job Task Dimension

Base Application, Microsoft.Projects.Project.Job

src/Layers/W1/BaseApp/Projects/Project/Job/JobTaskDimension.Table.al140 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.Projects.Project.Job;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;table 1002 "Job Task Dimension"{    Caption = 'Project Task Dimension';    DataClassification = CustomerContent;    fields    {        field(1; "Job No."; Code[20])        {            Caption = 'Project No.';            Editable = false;            NotBlank = true;            TableRelation = "Job Task"."Job No.";        }        field(2; "Job Task No."; Code[20])        {            Caption = 'Project Task No.';            NotBlank = true;            TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No."));        }        field(3; "Dimension Code"; Code[20])        {            Caption = 'Dimension Code';            ToolTip = 'Specifies the code for the dimension that the dimension value filter will be linked to. To select a dimension codes, which are set up in the Dimensions window, click the drop-down arrow in the field.';            TableRelation = Dimension.Code;            trigger OnValidate()            begin                if not DimMgt.CheckDim("Dimension Code") then                    Error(DimMgt.GetDimErr());                "Dimension Value Code" := '';            end;        }        field(4; "Dimension Value Code"; Code[20])        {            Caption = 'Dimension Value Code';            ToolTip = 'Specifies the code for the dimension value that the dimension value filter will be linked to. To select a value code, which are set up in the Dimensions window, choose the drop-down arrow in the field.';            TableRelation = "Dimension Value".Code where("Dimension Code" = field("Dimension Code"), Blocked = const(false));            trigger OnValidate()            begin                if not DimMgt.CheckDimValue("Dimension Code", "Dimension Value Code") then                    Error(DimMgt.GetDimErr());            end;        }        field(5; "Multiple Selection Action"; Option)        {            Caption = 'Multiple Selection Action';            OptionCaption = ' ,Change,Delete';            OptionMembers = " ",Change,Delete;        }    }    keys    {        key(Key1; "Job No.", "Job Task No.", "Dimension Code")        {            Clustered = true;        }        key(Key2; "Dimension Code")        {        }    }    fieldgroups    {    }    trigger OnDelete()    begin        UpdateGlobalDim('');    end;    trigger OnInsert()    begin        if "Dimension Value Code" = '' then            Error(Text001, TableCaption);        UpdateGlobalDim("Dimension Value Code");    end;    trigger OnModify()    begin        UpdateGlobalDim("Dimension Value Code");    end;    trigger OnRename()    var        IsHandled: Boolean;    begin        OnBeforeOnRename(Rec, IsHandled);        if IsHandled then            exit;        Error(Text000, TableCaption);    end;    var        DimMgt: Codeunit DimensionManagement;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'You cannot rename a %1.';        Text001: Label 'At least one dimension value code must have a value. Enter a value or delete the %1. ';#pragma warning restore AA0470#pragma warning restore AA0074    procedure UpdateGlobalDim(DimensionValue: Code[20])    var        JobTask: Record "Job Task";        GLSEtup: Record "General Ledger Setup";    begin        GLSEtup.Get();        if "Dimension Code" = GLSEtup."Global Dimension 1 Code" then begin            JobTask.Get("Job No.", "Job Task No.");            JobTask."Global Dimension 1 Code" := DimensionValue;            JobTask.Modify(true);        end else            if "Dimension Code" = GLSEtup."Global Dimension 2 Code" then begin                JobTask.Get("Job No.", "Job Task No.");                JobTask."Global Dimension 2 Code" := DimensionValue;                JobTask.Modify(true);            end;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeOnRename(var JobTaskDimension: Record "Job Task Dimension"; var IsHandled: Boolean)    begin    end;}