Table 5205 Employee Relative

Base Application, Microsoft.HumanResources.Employee

src/Layers/W1/BaseApp/HumanResources/Employee/EmployeeRelative.Table.al101 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.HumanResources.Employee;using Microsoft.HumanResources.Comment;using Microsoft.HumanResources.Setup;table 5205 "Employee Relative"{    Caption = 'Employee Relative';    DataCaptionFields = "Employee No.";    DrillDownPageID = "Employee Relatives";    LookupPageID = "Employee Relatives";    DataClassification = CustomerContent;    fields    {        field(1; "Employee No."; Code[20])        {            Caption = 'Employee No.';            NotBlank = true;            TableRelation = Employee;        }        field(2; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(3; "Relative Code"; Code[10])        {            Caption = 'Relative Code';            ToolTip = 'Specifies a relative code for the employee.';            TableRelation = Relative;        }        field(4; "First Name"; Text[30])        {            Caption = 'First Name';            ToolTip = 'Specifies the first name of the employee''s relative.';        }        field(5; "Middle Name"; Text[30])        {            Caption = 'Middle Name';            ToolTip = 'Specifies the middle name of the employee''s relative.';        }        field(6; "Last Name"; Text[30])        {            Caption = 'Last Name';            ToolTip = 'Specifies the last name of the employee''s relative.';        }        field(7; "Birth Date"; Date)        {            Caption = 'Birth Date';            ToolTip = 'Specifies the relative''s date of birth.';        }        field(8; "Phone No."; Text[30])        {            Caption = 'Phone No.';            ToolTip = 'Specifies the relative''s telephone number.';            ExtendedDatatype = PhoneNo;        }        field(9; "Relative's Employee No."; Code[20])        {            Caption = 'Relative''s Employee No.';            TableRelation = Employee;        }        field(10; Comment; Boolean)        {            CalcFormula = exist("Human Resource Comment Line" where("Table Name" = const("Employee Relative"),                                                                     "No." = field("Employee No."),                                                                     "Table Line No." = field("Line No.")));            Caption = 'Comment';            ToolTip = 'Specifies if a comment was entered for this entry.';            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "Employee No.", "Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        HRCommentLine: Record "Human Resource Comment Line";    begin        HRCommentLine.SetRange("Table Name", HRCommentLine."Table Name"::"Employee Relative");        HRCommentLine.SetRange("No.", "Employee No.");        HRCommentLine.DeleteAll();    end;}