Table 5956 Resource Skill

Base Application, Microsoft.Service.Resources

src/Layers/W1/BaseApp/Service/Resources/ResourceSkill.Table.al105 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.Service.Resources;using Microsoft.Inventory.Item;using Microsoft.Projects.Resources.Resource;using Microsoft.Service.Item;using Microsoft.Service.Setup;table 5956 "Resource Skill"{    Caption = 'Resource Skill';    LookupPageID = "Resource Skills";    DataClassification = CustomerContent;    fields    {        field(1; Type; Enum "Resource Skill Type")        {            Caption = 'Type';            ToolTip = 'Specifies the skill type associated with the entry.';        }        field(2; "No."; Code[20])        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';            NotBlank = true;            TableRelation = if (Type = const(Resource)) Resource."No."            else            if (Type = const("Service Item Group")) "Service Item Group".Code            else            if (Type = const(Item)) Item."No."            else            if (Type = const("Service Item")) "Service Item"."No.";        }        field(3; "Skill Code"; Code[10])        {            Caption = 'Skill Code';            ToolTip = 'Specifies the code of the skill you want to assign.';            NotBlank = true;            TableRelation = "Skill Code";            trigger OnValidate()            var                ResSkill: Record "Resource Skill";                ResSkillMgt: Codeunit "Resource Skill Mgt.";            begin                if ("Skill Code" <> xRec."Skill Code") and                   (xRec."Skill Code" <> '') and                   (not ResSkill.Get(Type, "No.", "Skill Code"))                then                    if not ResSkillMgt.ChangeResSkill(Rec, xRec."Skill Code") then                        Error('');            end;        }        field(4; "Assigned From"; Enum "Resource Skill Assigned From")        {            Caption = 'Assigned From';            ToolTip = 'Specifies the object, such as item or service item group, from which the skill code was assigned.';        }        field(5; "Source Type"; Enum "Resource Skill Source Type")        {            Caption = 'Source Type';        }        field(6; "Source Code"; Code[20])        {            Caption = 'Source Code';        }    }    keys    {        key(Key1; Type, "No.", "Skill Code")        {            Clustered = true;        }        key(Key2; "Skill Code", Type, "No.")        {        }        key(Key3; "Assigned From")        {        }        key(Key4; "Source Type", "Source Code")        {        }        key(Key5; "Assigned From", "Source Type", "Source Code")        {        }    }    fieldgroups    {    }    trigger OnInsert()    var        ResSkillMgt: Codeunit "Resource Skill Mgt.";    begin        ResSkillMgt.AddResSkill(Rec);    end;}