Table 5920 Fault/Resol. Cod. Relationship

Base Application, Microsoft.Service.Maintenance

src/Layers/W1/BaseApp/Service/Maintenance/FaultResolCodRelationship.Table.al112 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.Maintenance;using Microsoft.Service.Item;table 5920 "Fault/Resol. Cod. Relationship"{    Caption = 'Fault/Resol. Cod. Relationship';    DataClassification = CustomerContent;    fields    {        field(1; "Fault Code"; Code[10])        {            Caption = 'Fault Code';            ToolTip = 'Specifies the fault code.';            TableRelation = "Fault Code".Code where("Fault Area Code" = field("Fault Area Code"),                                                     "Symptom Code" = field("Symptom Code"));        }        field(2; "Symptom Code"; Code[10])        {            Caption = 'Symptom Code';            ToolTip = 'Specifies the symptom code.';            TableRelation = "Symptom Code";        }        field(3; "Fault Area Code"; Code[10])        {            Caption = 'Fault Area Code';            ToolTip = 'Specifies the fault area code.';            TableRelation = "Fault Area";        }        field(4; "Resolution Code"; Code[10])        {            Caption = 'Resolution Code';            ToolTip = 'Specifies the resolution code.';            TableRelation = "Resolution Code";            trigger OnValidate()            begin                if "Resolution Code" <> '' then begin                    ResolutionCode.Get("Resolution Code");                    Description := ResolutionCode.Description;                end else                    Description := '';            end;        }        field(5; Occurrences; Integer)        {            Caption = 'Occurrences';            ToolTip = 'Specifies the number of times the combination of fault code, symptom code, fault area, and resolution code occurs in the posted service lines.';            Editable = false;        }        field(6; Description; Text[80])        {            Caption = 'Description';            ToolTip = 'Specifies a description of the relationship between the fault code and the resolution code.';        }        field(7; "Service Item Group Code"; Code[10])        {            Caption = 'Service Item Group Code';            ToolTip = 'Specifies the code of the service item group linked to the relationship.';            TableRelation = "Service Item Group";        }        field(8; "Created Manually"; Boolean)        {            Caption = 'Created Manually';            Editable = false;        }    }    keys    {        key(Key1; "Fault Code", "Fault Area Code", "Symptom Code", "Resolution Code", "Service Item Group Code")        {            Clustered = true;        }        key(Key2; "Fault Code", Occurrences)        {        }        key(Key3; "Fault Area Code", Occurrences)        {        }        key(Key4; "Symptom Code", Occurrences)        {        }        key(Key5; "Service Item Group Code", "Fault Code", Occurrences)        {        }    }    fieldgroups    {    }    trigger OnInsert()    begin        "Created Manually" := true;    end;    trigger OnModify()    begin        "Created Manually" := true;    end;    var        ResolutionCode: Record "Resolution Code";}