Table 7335 Bin Template

Base Application, Microsoft.Warehouse.Structure

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;}