Table 7301 Warehouse Employee

Base Application, Microsoft.Warehouse.Setup

src/Layers/W1/BaseApp/Warehouse/Setup/WarehouseEmployee.Table.al126 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.Setup;using Microsoft.Inventory.Location;using Microsoft.Warehouse.ADCS;using System.Security.AccessControl;using System.Security.User;table 7301 "Warehouse Employee"{    Caption = 'Warehouse Employee';    LookupPageID = "Warehouse Employee List";    ReplicateData = true;    DataClassification = CustomerContent;    fields    {        field(1; "User ID"; Code[50])        {            Caption = 'User ID';            ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.';            DataClassification = EndUserIdentifiableInformation;            TableRelation = User."User Name";            ValidateTableRelation = false;            trigger OnValidate()            var                UserSelection: Codeunit "User Selection";            begin                UserSelection.ValidateUserName("User ID");            end;        }        field(2; "Location Code"; Code[10])        {            Caption = 'Location Code';            ToolTip = 'Specifies the code of the location in which the employee works.';            TableRelation = Location;        }        field(4; Default; Boolean)        {            Caption = 'Default';            ToolTip = 'Specifies that the location code that is defined as the default location for this employee''s activities.';        }        field(7710; "ADCS User"; Code[50])        {            Caption = 'ADCS User';            ToolTip = 'Specifies the ADCS user name of a warehouse employee.';            DataClassification = EndUserIdentifiableInformation;            TableRelation = "ADCS User".Name;            trigger OnValidate()            var                WarehouseEmployee: Record "Warehouse Employee";            begin                if ("ADCS User" <> xRec."ADCS User") and ("ADCS User" <> '') then begin                    WarehouseEmployee.SetRange("ADCS User", "ADCS User");                    if not WarehouseEmployee.IsEmpty() then                        Error(Text001);                end;            end;        }    }    keys    {        key(Key1; "User ID", "Location Code")        {            Clustered = true;        }        key(Key2; Default)        {        }        key(Key3; "Location Code")        {        }    }    fieldgroups    {    }    trigger OnInsert()    begin        if Default then            CheckDefault();    end;    trigger OnModify()    begin        if Default then            CheckDefault();    end;    var#pragma warning disable AA0074        Text000: Label 'You can only have one default location per user ID.';        Text001: Label 'You can only assign an ADCS user name once.';#pragma warning restore AA0074    local procedure CheckDefault()    var        WhseEmployee: Record "Warehouse Employee";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckDefault(Rec, IsHandled);        if IsHandled then            exit;        WhseEmployee.SetRange(Default, true);        WhseEmployee.SetRange("User ID", "User ID");        WhseEmployee.SetFilter("Location Code", '<>%1', "Location Code");        if not WhseEmployee.IsEmpty() then            Error(Text000);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckDefault(var WarehouseEmployee: Record "Warehouse Employee"; var IsHandled: Boolean)    begin    end;}