Table 5413 Prod. Order Rtng Qlty Meas.
src/Layers/W1/BaseApp/Manufacturing/Document/ProdOrderRtngQltyMeas.Table.al151 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.Document;using Microsoft.Manufacturing.Routing;using Microsoft.Manufacturing.Setup;table 5413 "Prod. Order Rtng Qlty Meas."{ Caption = 'Prod. Order Rtng Qlty Meas.'; DataClassification = CustomerContent; fields { field(1; "Routing No."; Code[20]) { Caption = 'Routing No.'; NotBlank = true; TableRelation = "Routing Header"; } field(2; "Line No."; Integer) { Caption = 'Line No.'; } field(9; "Qlty Measure Code"; Code[10]) { Caption = 'Qlty Measure Code'; ToolTip = 'Specifies the quality measure code.'; TableRelation = "Quality Measure"; trigger OnValidate() begin if "Qlty Measure Code" = '' then exit; QltyMeasure.Get("Qlty Measure Code"); Description := QltyMeasure.Description; end; } field(10; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a description of the quality measure.'; } field(11; "Min. Value"; Decimal) { AutoFormatType = 0; Caption = 'Min. Value'; ToolTip = 'Specifies a minimum value, which is to be reached in the quality control.'; DecimalPlaces = 0 : 5; } field(12; "Max. Value"; Decimal) { AutoFormatType = 0; Caption = 'Max. Value'; ToolTip = 'Specifies the maximum value, which may be reached in the quality control.'; DecimalPlaces = 0 : 5; } field(13; "Mean Tolerance"; Decimal) { AutoFormatType = 0; Caption = 'Mean Tolerance'; ToolTip = 'Specifies the mean tolerance.'; DecimalPlaces = 0 : 5; } field(21; "Operation No."; Code[10]) { Caption = 'Operation No.'; NotBlank = true; TableRelation = "Prod. Order Routing Line"."Operation No." where(Status = field(Status), "Prod. Order No." = field("Prod. Order No."), "Routing No." = field("Routing No.")); } field(22; Status; Enum "Production Order Status") { Caption = 'Status'; } field(23; "Prod. Order No."; Code[20]) { Caption = 'Prod. Order No.'; NotBlank = true; TableRelation = "Production Order"."No." where(Status = field(Status)); } field(24; "Routing Reference No."; Integer) { Caption = 'Routing Reference No.'; TableRelation = "Prod. Order Routing Line"."Routing Reference No." where("Routing No." = field("Routing No."), "Operation No." = field("Operation No."), "Prod. Order No." = field("Prod. Order No."), Status = field(Status)); ValidateTableRelation = false; } } keys { key(Key1; Status, "Prod. Order No.", "Routing Reference No.", "Routing No.", "Operation No.", "Line No.") { Clustered = true; } } fieldgroups { } trigger OnDelete() begin if Status = Status::Finished then Error(Text000, Status, TableCaption); end; trigger OnInsert() begin if Status = Status::Finished then Error(Text000, Status, TableCaption); end; trigger OnModify() begin if Status = Status::Finished then Error(Text000, Status, TableCaption); end; var QltyMeasure: Record "Quality Measure";#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'A %1 %2 cannot be inserted, modified, or deleted.';#pragma warning restore AA0470#pragma warning restore AA0074 procedure Caption(): Text var ProdOrder: Record "Production Order"; begin if GetFilters = '' then exit(''); if not ProdOrder.Get(Status, "Prod. Order No.") then exit(''); exit( StrSubstNo('%1 %2 %3 %4', "Prod. Order No.", ProdOrder.Description, "Routing No.", "Operation No.")); end;}