Table 7327 Whse. Worksheet Name
src/Layers/W1/BaseApp/Warehouse/Worksheet/WhseWorksheetName.Table.al128 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.Worksheet;using Microsoft.Inventory.Location;using Microsoft.Warehouse.Journal;table 7327 "Whse. Worksheet Name"{ Caption = 'Whse. Worksheet Name'; DataCaptionFields = Name, Description, "Location Code"; LookupPageID = "Worksheet Names List"; DataClassification = CustomerContent; fields { field(1; "Worksheet Template Name"; Code[10]) { Caption = 'Worksheet Template Name'; TableRelation = "Whse. Worksheet Template"; } field(2; Name; Code[10]) { Caption = 'Name'; ToolTip = 'Specifies the name you enter for the worksheet.'; NotBlank = true; } field(3; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the location code of the warehouse the worksheet should be used for.'; TableRelation = Location; } field(4; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies the description for the worksheet.'; } field(21; "Template Type"; Enum "Warehouse Worksheet Template Type") { CalcFormula = lookup("Whse. Worksheet Template".Type where(Name = field("Worksheet Template Name"))); Caption = 'Template Type'; Editable = false; FieldClass = FlowField; } } keys { key(Key1; "Worksheet Template Name", Name, "Location Code") { Clustered = true; } } fieldgroups { } trigger OnDelete() var WhseWkshLine: Record "Whse. Worksheet Line"; begin WhseWkshLine.SetRange("Worksheet Template Name", "Worksheet Template Name"); WhseWkshLine.SetRange(Name, Name); WhseWkshLine.SetRange("Location Code", "Location Code"); WhseWkshLine.DeleteAll(true); end; trigger OnInsert() begin TestWMSLocation(); end; trigger OnModify() begin TestWMSLocation(); end; trigger OnRename() var WhseWkshLine: Record "Whse. Worksheet Line"; begin TestWMSLocation(); WhseWkshLine.SetRange("Worksheet Template Name", xRec."Worksheet Template Name"); WhseWkshLine.SetRange(Name, xRec.Name); WhseWkshLine.SetRange("Location Code", xRec."Location Code"); while WhseWkshLine.FindFirst() do WhseWkshLine.Rename("Worksheet Template Name", Name, "Location Code", WhseWkshLine."Line No."); end; var Location: Record Location; WhseWkshTemplate: Record "Whse. Worksheet Template"; procedure SetupNewName() var WMSMgt: Codeunit "WMS Management"; begin if UserId <> '' then GetLocation(WMSMgt.GetDefaultLocation()); "Location Code" := Location.Code; end; local procedure GetLocation(LocationCode: Code[10]) begin if LocationCode = '' then Location.Init() else if Location.Code <> LocationCode then Location.Get(LocationCode); end; local procedure TestWMSLocation() begin WhseWkshTemplate.Get("Worksheet Template Name"); if WhseWkshTemplate.Type = WhseWkshTemplate.Type::Movement then begin TestField("Location Code"); GetLocation("Location Code"); Location.TestField("Bin Mandatory"); end; end;}