Table 5956 Resource Skill
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;}