Table 99000773 Family

Base Application, Microsoft.Manufacturing.Family

src/Layers/W1/BaseApp/Manufacturing/Family/Family.Table.al93 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.Manufacturing.Family;using Microsoft.Manufacturing.Routing;table 99000773 Family{    Caption = 'Family';    DataCaptionFields = "No.", Description;    DrillDownPageID = "Family List";    LookupPageID = "Family List";    DataClassification = CustomerContent;    fields    {        field(1; "No."; Code[20])        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';            NotBlank = true;        }        field(10; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description for a product family.';            trigger OnValidate()            begin                "Search Name" := Description;            end;        }        field(11; "Description 2"; Text[50])        {            Caption = 'Description 2';            ToolTip = 'Specifies an additional description of the product family if there is not enough space in the Description field.';        }        field(12; "Search Name"; Code[100])        {            Caption = 'Search Name';            ToolTip = 'Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field.';        }        field(13; Blocked; Boolean)        {            Caption = 'Blocked';            ToolTip = 'Specifies that the family is blocked. This field is for information only and does not affect the posting in transactions.';        }        field(14; "Last Date Modified"; Date)        {            Caption = 'Last Date Modified';            ToolTip = 'Specifies when the standard data of this production family was last modified.';            Editable = false;        }        field(20; "Routing No."; Code[20])        {            Caption = 'Routing No.';            ToolTip = 'Specifies the number of the routing which is used for the production of the family.';            TableRelation = "Routing Header";        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Search Name")        {        }    }    fieldgroups    {    }    trigger OnDelete()    var        FamilyLine: Record "Family Line";    begin        FamilyLine.SetRange("Family No.", "No.");        FamilyLine.DeleteAll();    end;    trigger OnModify()    begin        "Last Date Modified" := Today;    end;}