Table 7322 Posted Whse. Shipment Header

Base Application, Microsoft.Warehouse.History

src/Layers/W1/BaseApp/Warehouse/History/PostedWhseShipmentHeader.Table.al272 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.History;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Location;using Microsoft.Warehouse.Comment;using Microsoft.Warehouse.Journal;using Microsoft.Warehouse.Setup;using Microsoft.Warehouse.Structure;table 7322 "Posted Whse. Shipment Header"{    Caption = 'Posted Whse. Shipment Header';    LookupPageID = "Posted Whse. Shipment List";    Permissions = TableData "Posted Whse. Shipment Line" = rd;    DataClassification = CustomerContent;    fields    {        field(1; "No."; Code[20])        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';        }        field(2; "Location Code"; Code[10])        {            Caption = 'Location Code';            ToolTip = 'Specifies the code of the location from which the items were shipped.';            TableRelation = Location where("Use As In-Transit" = const(false));        }        field(3; "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(4; "Assignment Date"; Date)        {            Caption = 'Assignment Date';            ToolTip = 'Specifies the date when the user was assigned the activity.';            Editable = false;        }        field(5; "Assignment Time"; Time)        {            Caption = 'Assignment Time';            ToolTip = 'Specifies the time when the user was assigned the activity.';            Editable = false;        }        field(7; "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.';            TableRelation = "No. Series";        }        field(11; Comment; Boolean)        {            CalcFormula = exist("Warehouse Comment Line" where("Table Name" = const("Posted Whse. Shipment"),                                                                Type = const(" "),                                                                "No." = field("No.")));            Caption = 'Comment';            Editable = false;            FieldClass = FlowField;        }        field(12; "Bin Code"; Code[20])        {            Caption = 'Bin Code';            ToolTip = 'Specifies the bin where the items are picked or put away.';            TableRelation = if ("Zone Code" = filter('')) Bin.Code where("Location Code" = field("Location Code"))            else            if ("Zone Code" = filter(<> '')) Bin.Code where("Location Code" = field("Location Code"),                                                                               "Zone Code" = field("Zone Code"));        }        field(13; "Zone Code"; Code[10])        {            Caption = 'Zone Code';            ToolTip = 'Specifies the code of the zone on this posted shipment header.';            TableRelation = Zone.Code where("Location Code" = field("Location Code"));        }        field(39; "Posting Date"; Date)        {            Caption = 'Posting Date';            ToolTip = 'Specifies the posting date of the posted warehouse shipment.';        }        field(40; "Shipment Date"; Date)        {            Caption = 'Shipment Date';            ToolTip = 'Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time.';        }        field(41; "Shipping Agent Code"; Code[10])        {            AccessByPermission = TableData "Shipping Agent Services" = R;            Caption = 'Shipping Agent Code';            ToolTip = 'Specifies the code for the shipping agent who is transporting the items.';            TableRelation = "Shipping Agent";        }        field(42; "Shipping Agent Service Code"; Code[10])        {            Caption = 'Shipping Agent Service Code';            ToolTip = 'Specifies the code for the service, such as a one-day delivery, that is offered by the shipping agent.';            TableRelation = "Shipping Agent Services".Code where("Shipping Agent Code" = field("Shipping Agent Code"));        }        field(43; "Shipment Method Code"; Code[10])        {            Caption = 'Shipment Method Code';            ToolTip = 'Specifies the delivery conditions of the related shipment, such as free on board (FOB).';            TableRelation = "Shipment Method";        }        field(45; "Whse. Shipment No."; Code[20])        {            Caption = 'Whse. Shipment No.';            ToolTip = 'Specifies the number of the warehouse shipment that the posted warehouse shipment originates from.';        }        field(48; "External Document No."; Code[35])        {            Caption = 'External Document No.';            ToolTip = 'Specifies a document number that refers to the customer''s or vendor''s numbering system.';        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Location Code")        {        }        key(Key3; "Whse. Shipment No.")        {        }        key(Key4; "Posting Date")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", "Location Code", "Posting Date")        {        }    }    trigger OnDelete()    var        PostedWhseShptLine: Record "Posted Whse. Shipment Line";        WhseCommentLine: Record "Warehouse Comment Line";    begin        PostedWhseShptLine.SetRange("No.", "No.");        PostedWhseShptLine.DeleteAll();        WhseCommentLine.SetRange("Table Name", WhseCommentLine."Table Name"::"Posted Whse. Shipment");        WhseCommentLine.SetRange(Type, WhseCommentLine.Type::" ");        WhseCommentLine.SetRange("No.", "No.");        WhseCommentLine.DeleteAll();    end;    trigger OnInsert()    var        NoSeries: Codeunit "No. Series";        IsHandled: Boolean;    begin        WhseSetup.Get();        if "No." = '' then begin            IsHandled := false;            OnInsertOnBeforeTestWhseShipmentNos(WhseSetup, IsHandled);            if not IsHandled then                WhseSetup.TestField("Posted Whse. Shipment Nos.");                "No. Series" := WhseSetup."Posted Whse. Shipment Nos.";                if NoSeries.AreRelated("No. Series", xRec."No. Series") then                    "No. Series" := xRec."No. Series";                "No." := NoSeries.GetNextNo("No. Series", "Posting Date");        end;    end;    var        WhseSetup: Record "Warehouse Setup";    procedure LookupPostedWhseShptHeader(var PostedWhseShptHeader: Record "Posted Whse. Shipment Header")    begin        Commit();        if UserId <> '' then begin            PostedWhseShptHeader.FilterGroup := 2;            PostedWhseShptHeader.SetRange("Location Code");        end;        if PAGE.RunModal(0, PostedWhseShptHeader) = ACTION::LookupOK then;        if UserId <> '' then begin            PostedWhseShptHeader.FilterGroup := 2;            PostedWhseShptHeader.SetRange("Location Code", PostedWhseShptHeader."Location Code");            PostedWhseShptHeader.FilterGroup := 0;        end;    end;    procedure FindFirstAllowedRec(Which: Text[1024]): Boolean    var        PostedWhseShptHeader: Record "Posted Whse. Shipment Header";        WMSManagement: Codeunit "WMS Management";    begin        if Find(Which) then begin            PostedWhseShptHeader := Rec;            while true do begin                if WMSManagement.LocationIsAllowedToView("Location Code") then                    exit(true);                if Next(1) = 0 then begin                    Rec := PostedWhseShptHeader;                    if Find(Which) then                        while true do begin                            if WMSManagement.LocationIsAllowedToView("Location Code") then                                exit(true);                            if Next(-1) = 0 then                                exit(false);                        end;                end;            end;        end;        exit(false);    end;    procedure FindNextAllowedRec(Steps: Integer): Integer    var        PostedWhseShptHeader: Record "Posted Whse. Shipment Header";        WMSManagement: Codeunit "WMS Management";        RealSteps: Integer;        NextSteps: Integer;    begin        RealSteps := 0;        if Steps <> 0 then begin            PostedWhseShptHeader := Rec;            repeat                NextSteps := Next(Steps / Abs(Steps));                if WMSManagement.LocationIsAllowedToView("Location Code") then begin                    RealSteps := RealSteps + NextSteps;                    PostedWhseShptHeader := Rec;                end;            until (NextSteps = 0) or (RealSteps = Steps);            Rec := PostedWhseShptHeader;            if not Find() then;        end;        exit(RealSteps);    end;    procedure ErrorIfUserIsNotWhseEmployee()    var        WMSManagement: Codeunit "WMS Management";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeErrorIfUserIsNotWhseEmployee("Location Code", IsHandled);        if IsHandled then            exit;        WMSManagement.CheckUserIsWhseEmployee();    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeErrorIfUserIsNotWhseEmployee(LocationCode: Code[10]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnInsertOnBeforeTestWhseShipmentNos(WarehouseSetup: Record "Warehouse Setup"; var IsHandled: Boolean)    begin    end;}