Table 5772 Registered Whse. Activity Hdr.
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;}