Table 5920 Fault/Resol. Cod. Relationship
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";}