Table 5772 Registered Whse. Activity Hdr.

Base Application, Microsoft.Warehouse.Activity.History

src/Layers/W1/BaseApp/Warehouse/Activity/History/RegisteredWhseActivityHdr.Table.al160 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.Warehouse.Activity.History;using Microsoft.Foundation.NoSeries;using Microsoft.Inventory.Location;using Microsoft.Warehouse.Activity;using Microsoft.Warehouse.Comment;using Microsoft.Warehouse.Journal;using Microsoft.Warehouse.Setup;table 5772 "Registered Whse. Activity Hdr."{    Caption = 'Registered Whse. Activity Hdr.';    LookupPageID = "Registered Whse. Activity List";    Permissions = TableData "Registered Whse. Activity Line" = rimd;    DataClassification = CustomerContent;    fields    {        field(1; Type; Enum "Warehouse Activity Type")        {            Caption = 'Type';            ToolTip = 'Specifies the type of activity that the warehouse performed on the lines attached to the header, such as put-away, pick or movement.';        }        field(2; "No."; Code[20])        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';        }        field(3; "Location Code"; Code[10])        {            Caption = 'Location Code';            ToolTip = 'Specifies the code of the location in which the registered warehouse activity occurred.';            NotBlank = true;            TableRelation = Location;        }        field(4; "Assigned User ID"; Code[50])        {            Caption = 'Assigned User ID';            ToolTip = 'Specifies the ID of the user who is responsible for the document.';            DataClassification = EndUserIdentifiableInformation;            TableRelation = "Warehouse Employee" where("Location Code" = field("Location Code"));        }        field(5; "Assignment Date"; Date)        {            Caption = 'Assignment Date';            ToolTip = 'Specifies the date when the user was assigned the activity.';        }        field(6; "Assignment Time"; Time)        {            Caption = 'Assignment Time';            ToolTip = 'Specifies the time when the user was assigned the activity.';        }        field(7; "Sorting Method"; Enum "Whse. Activity Sorting Method")        {            Caption = 'Sorting Method';            ToolTip = 'Specifies the method by which the lines were sorted on the warehouse header, such as by item, or bin code.';        }        field(8; "Registering Date"; Date)        {            Caption = 'Registering Date';            ToolTip = 'Specifies the date the line is registered.';        }        field(9; "No. Series"; Code[20])        {            Caption = 'No. Series';            ToolTip = 'Specifies the number series from which entry or record numbers are assigned to new entries or records.';            Editable = false;            TableRelation = "No. Series";        }        field(10; Comment; Boolean)        {            CalcFormula = exist("Warehouse Comment Line" where("Table Name" = const("Rgstrd. Whse. Activity Header"),                                                                Type = field(Type),                                                                "No." = field("No.")));            Caption = 'Comment';            Editable = false;            FieldClass = FlowField;        }        field(11; "Whse. Activity No."; Code[20])        {            Caption = 'Whse. Activity No.';            ToolTip = 'Specifies the warehouse activity number from which the activity was registered.';        }        field(12; "No. Printed"; Integer)        {            Caption = 'No. Printed';            ToolTip = 'Specifies how many times the document has been printed.';            Editable = false;        }    }    keys    {        key(Key1; Type, "No.")        {            Clustered = true;        }        key(Key2; "No.", Type)        {        }        key(Key3; "Whse. Activity No.")        {        }        key(Key4; "Location Code")        {        }    }    fieldgroups    {    }    trigger OnDelete()    var        RgstrdWhseActivLine: Record "Registered Whse. Activity Line";        WhseCommentLine: Record "Warehouse Comment Line";    begin        RgstrdWhseActivLine.SetRange("Activity Type", Type);        RgstrdWhseActivLine.SetRange("No.", "No.");        RgstrdWhseActivLine.DeleteAll();        WhseCommentLine.SetRange("Table Name", WhseCommentLine."Table Name"::"Rgstrd. Whse. Activity Header");        WhseCommentLine.SetRange(Type, Type);        WhseCommentLine.SetRange("No.", "No.");        WhseCommentLine.DeleteAll();    end;    procedure SetWhseLocationFilter()    var        WmsManagement: Codeunit "WMS Management";    begin        if UserId <> '' then begin            FilterGroup := 2;            SetRange("Location Code", WmsManagement.GetAllowedLocation("Location Code"));            FilterGroup := 0;        end;    end;    procedure LookupRegisteredActivityHeader(var CurrentLocationCode: Code[10]; var RegisteredWhseActivHeader: Record "Registered Whse. Activity Hdr.")    begin        Commit();        if UserId <> '' then begin            RegisteredWhseActivHeader.FilterGroup := 2;            RegisteredWhseActivHeader.SetRange("Location Code");        end;        if PAGE.RunModal(0, RegisteredWhseActivHeader) = ACTION::LookupOK then;        if UserId <> '' then begin            RegisteredWhseActivHeader.FilterGroup := 2;            RegisteredWhseActivHeader.SetRange("Location Code", RegisteredWhseActivHeader."Location Code");            RegisteredWhseActivHeader.FilterGroup := 0;        end;        CurrentLocationCode := RegisteredWhseActivHeader."Location Code";    end;}