Table 7335 Bin Template
src/Layers/W1/BaseApp/Warehouse/Structure/BinTemplate.Table.al180 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.Structure;using Microsoft.Inventory.Location;using Microsoft.Warehouse.Setup;table 7335 "Bin Template"{ Caption = 'Bin Template'; DataCaptionFields = "Code", Description; LookupPageID = "Bin Templates"; ReplicateData = true; DataClassification = CustomerContent; fields { field(1; "Code"; Code[20]) { Caption = 'Code'; ToolTip = 'Specifies a code for the bin template.'; NotBlank = true; } field(2; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies a description for the bin creation template.'; } field(4; "Location Code"; Code[10]) { Caption = 'Location Code'; ToolTip = 'Specifies the location code that will apply to all the bins set up with this bin template.'; NotBlank = true; TableRelation = Location where("Bin Mandatory" = const(true)); } field(5; "Bin Description"; Text[50]) { Caption = 'Bin Description'; ToolTip = 'Specifies a description of the bins that are set up using the bin template.'; } field(6; "Zone Code"; Code[10]) { Caption = 'Zone Code'; ToolTip = 'Specifies the code of the zone where the bins created by this template are located.'; TableRelation = Zone.Code where("Location Code" = field("Location Code")); trigger OnValidate() begin SetUpNewLine(); end; } field(10; "Bin Type Code"; Code[10]) { Caption = 'Bin Type Code'; ToolTip = 'Specifies a bin type code that will be copied to all bins created using the template.'; TableRelation = "Bin Type"; } field(11; "Warehouse Class Code"; Code[10]) { Caption = 'Warehouse Class Code'; ToolTip = 'Specifies a warehouse class code that will be copied to all bins created using the template.'; TableRelation = "Warehouse Class"; } field(12; "Block Movement"; Option) { Caption = 'Block Movement'; ToolTip = 'Specifies how the movement of a particular item, or bin content, into or out of this bin, is blocked.'; OptionCaption = ' ,Inbound,Outbound,All'; OptionMembers = " ",Inbound,Outbound,All; } field(20; "Special Equipment Code"; Code[10]) { Caption = 'Special Equipment Code'; ToolTip = 'Specifies a special equipment code that will be copied to all bins created using the template.'; TableRelation = "Special Equipment"; } field(21; "Bin Ranking"; Integer) { Caption = 'Bin Ranking'; ToolTip = 'Specifies the bin ranking that will be copied to all bins created using the template.'; } field(22; "Maximum Cubage"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Maximum Cubage'; ToolTip = 'Specifies the maximum cubage that will be copied to all bins that are created using the template.'; DecimalPlaces = 0 : 5; MinValue = 0; } field(23; "Maximum Weight"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Maximum Weight'; ToolTip = 'Specifies the maximum weight that will be copied to all bins that are created using the template.'; DecimalPlaces = 0 : 5; MinValue = 0; } field(24; Dedicated; Boolean) { Caption = 'Dedicated'; } } keys { key(Key1; "Code") { Clustered = true; } } fieldgroups { } trigger OnInsert() begin GetLocation("Location Code"); if Location."Directed Put-away and Pick" then TestField("Zone Code"); end; trigger OnModify() begin GetLocation("Location Code"); if Location."Directed Put-away and Pick" then TestField("Zone Code"); end; var Location: Record Location; Zone: Record Zone; procedure SetUpNewLine() var IsHandled: Boolean; begin IsHandled := false; OnBeforeSetUpNewLine(Rec, IsHandled); if IsHandled then exit; GetLocation("Location Code"); if Rec."Zone Code" <> '' then begin GetZone("Location Code", "Zone Code"); "Bin Type Code" := Zone."Bin Type Code"; "Warehouse Class Code" := Zone."Warehouse Class Code"; "Special Equipment Code" := Zone."Special Equipment Code"; "Bin Ranking" := Zone."Zone Ranking"; end; end; local procedure GetZone(LocationCode: Code[10]; ZoneCode: Code[10]) begin TestField("Location Code"); if Location."Directed Put-away and Pick" then TestField("Zone Code"); if (Zone."Location Code" <> LocationCode) or (Zone.Code <> ZoneCode) then Zone.Get("Location Code", "Zone Code"); end; local procedure GetLocation(LocationCode: Code[10]) begin if Location.Code <> LocationCode then Location.Get(LocationCode); end; [IntegrationEvent(false, false)] local procedure OnBeforeSetUpNewLine(BinTemplate: Record "Bin Template"; var IsHandled: Boolean) begin end;}