Table 5772 Registered Whse. Activity Hdr.
- App
- Base Application
- Namespace
- Microsoft.Warehouse.Activity.History
- Versions
- 17-28
Fields, 12Keys, 4Procedures, 2
Versions171819202122232425262728
Source29
Source in 29
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;
}