Table 99000760 Calendar Absence Entry

Base Application, Microsoft.Manufacturing.Capacity

src/Layers/W1/BaseApp/Manufacturing/Capacity/CalendarAbsenceEntry.Table.al224 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.Capacity;using Microsoft.Manufacturing.MachineCenter;using Microsoft.Manufacturing.WorkCenter;table 99000760 "Calendar Absence Entry"{    Caption = 'Calendar Absence Entry';    DrillDownPageID = "Capacity Absence";    LookupPageID = "Capacity Absence";    DataClassification = CustomerContent;    fields    {        field(1; "Capacity Type"; Enum "Capacity Type")        {            Caption = 'Capacity Type';            Editable = false;        }        field(2; "No."; Code[20])        {            Caption = 'No.';            NotBlank = true;            TableRelation = if ("Capacity Type" = const("Work Center")) "Work Center"            else            if ("Capacity Type" = const("Machine Center")) "Machine Center";            trigger OnValidate()            begin                if "No." = '' then                    exit;                case "Capacity Type" of                    "Capacity Type"::"Work Center":                        begin                            Workcenter.Get("No.");                            Workcenter.TestField("Work Center Group Code");                            "Work Center No." := Workcenter."No.";                            "Work Center Group Code" := Workcenter."Work Center Group Code";                            Capacity := Workcenter.Capacity;                        end;                    "Capacity Type"::"Machine Center":                        begin                            Machinecenter.Get("No.");                            Machinecenter.TestField("Work Center No.");                            Workcenter.Get(Machinecenter."Work Center No.");                            Workcenter.TestField("Work Center Group Code");                            "Work Center No." := Workcenter."No.";                            "Work Center Group Code" := Workcenter."Work Center Group Code";                            Capacity := Machinecenter.Capacity;                        end;                end;            end;        }        field(4; Date; Date)        {            Caption = 'Date';            ToolTip = 'Specifies the date associated with this absence entry.';            NotBlank = true;            trigger OnValidate()            begin                UpdateDatetime();            end;        }        field(6; "Starting Time"; Time)        {            Caption = 'Starting Time';            ToolTip = 'Specifies the starting time of the absence entry.';            trigger OnValidate()            begin                if ("Ending Time" = 0T) or                   ("Ending Time" < "Starting Time")                then                    Validate("Ending Time", "Starting Time")            end;        }        field(7; "Ending Time"; Time)        {            Caption = 'Ending Time';            ToolTip = 'Specifies the ending time of the absence entry.';            trigger OnValidate()            begin                if "Ending Time" < "Starting Time" then                    Error(Text000, FieldCaption("Ending Time"), FieldCaption("Starting Time"));                UpdateDatetime();            end;        }        field(8; "Work Center No."; Code[20])        {            Caption = 'Work Center No.';            Editable = false;            TableRelation = "Work Center";        }        field(9; "Work Center Group Code"; Code[10])        {            Caption = 'Work Center Group Code';            Editable = false;            TableRelation = "Work Center Group";        }        field(21; Capacity; Decimal)        {            AutoFormatType = 0;            Caption = 'Capacity';            ToolTip = 'Specifies the capacity of the absence entry, which was planned for this work center or machine center.';            DecimalPlaces = 0 : 5;            MinValue = 0;            trigger OnValidate()            begin                if Capacity <> xRec.Capacity then begin                    CalAbsenceMgt.RemoveAbsence(xRec);                    Updated := false;                end;            end;        }        field(24; "Starting Date-Time"; DateTime)        {            Caption = 'Starting Date-Time';            ToolTip = 'Specifies the date and the starting time, which are combined in a format called "starting date-time".';            trigger OnValidate()            begin                "Starting Time" := DT2Time("Starting Date-Time");                Date := DT2Date("Starting Date-Time");                Validate("Starting Time");            end;        }        field(25; "Ending Date-Time"; DateTime)        {            Caption = 'Ending Date-Time';            ToolTip = 'Specifies the date and the ending time, which are combined in a format called "ending date-time".';            trigger OnValidate()            begin                "Ending Time" := DT2Time("Ending Date-Time");                Date := DT2Date("Ending Date-Time");                Validate("Ending Time");            end;        }        field(31; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description for the absence entry, for example, holiday or vacation"';        }        field(32; Updated; Boolean)        {            Caption = 'Updated';            ToolTip = 'Specifies the calendar has been updated with this absence entry.';            Editable = false;        }    }    keys    {        key(Key1; "Capacity Type", "No.", Date, "Starting Time", "Ending Time")        {            Clustered = true;        }        key(Key2; "Work Center No.")        {        }        key(Key3; "Capacity Type", "No.", Date, "Starting Date-Time", "Ending Date-Time")        {        }    }    fieldgroups    {    }    trigger OnDelete()    begin        CalAbsenceMgt.RemoveAbsence(Rec);    end;    trigger OnRename()    begin        CalAbsenceMgt.RemoveAbsence(xRec);        Updated := false;    end;    var        Workcenter: Record "Work Center";        Machinecenter: Record "Machine Center";        CalAbsenceMgt: Codeunit "Calendar Absence Management";#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label '%1 must be higher than %2.';#pragma warning restore AA0470#pragma warning restore AA0074    procedure Caption(): Text    begin        if "Capacity Type" = "Capacity Type"::"Machine Center" then begin            if not Machinecenter.Get(GetFilter("No.")) then                exit('');            exit(              StrSubstNo('%1 %2',                Machinecenter."No.", Machinecenter.Name));        end;        if not Workcenter.Get(GetFilter("No.")) then            exit('');        exit(          StrSubstNo('%1 %2',            Workcenter."No.", Workcenter.Name));    end;    local procedure UpdateDatetime()    begin        "Starting Date-Time" := CreateDateTime(Date, "Starting Time");        "Ending Date-Time" := CreateDateTime(Date, "Ending Time");    end;}