Table 5744 Transfer Shipment Header

Base Application, Microsoft.Inventory.Transfer

src/Layers/W1/BaseApp/Inventory/Transfer/TransferShipmentHeader.Table.al408 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.Inventory.Transfer;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Address;using Microsoft.Foundation.Navigate;using Microsoft.Foundation.NoSeries;using Microsoft.Foundation.Reporting;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Comment;using Microsoft.Inventory.Intrastat;using Microsoft.Inventory.Location;using Microsoft.Inventory.Tracking;using Microsoft.Utilities;table 5744 "Transfer Shipment Header"{    Caption = 'Transfer Shipment Header';    DataCaptionFields = "No.";    LookupPageID = "Posted Transfer Shipments";    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; "Transfer-from Code"; Code[10])        {            Caption = 'Transfer-from Code';            ToolTip = 'Specifies the code of the location that items are transferred from.';            TableRelation = Location where("Use As In-Transit" = const(false));        }        field(3; "Transfer-from Name"; Text[100])        {            Caption = 'Transfer-from Name';            ToolTip = 'Specifies the name of the sender at the location that the items are transferred from.';        }        field(4; "Transfer-from Name 2"; Text[50])        {            Caption = 'Transfer-from Name 2';            ToolTip = 'Specifies an additional part of the name of the sender at the location that the items are transferred from.';        }        field(5; "Transfer-from Address"; Text[100])        {            Caption = 'Transfer-from Address';            ToolTip = 'Specifies the address of the location that the items are transferred from.';        }        field(6; "Transfer-from Address 2"; Text[50])        {            Caption = 'Transfer-from Address 2';            ToolTip = 'Specifies an additional part of the address of the location that items are transferred from.';        }        field(7; "Transfer-from Post Code"; Code[20])        {            Caption = 'Transfer-from Post Code';            ToolTip = 'Specifies the postal code of the location that the items are transferred from.';            TableRelation = "Post Code";            ValidateTableRelation = false;        }        field(8; "Transfer-from City"; Text[30])        {            Caption = 'Transfer-from City';            ToolTip = 'Specifies the city of the location that the items are transferred from.';            TableRelation = "Post Code".City;            ValidateTableRelation = false;        }        field(9; "Transfer-from County"; Text[30])        {            CaptionClass = '5,7,' + "Trsf.-from Country/Region Code";            Caption = 'Transfer-from County';        }        field(10; "Trsf.-from Country/Region Code"; Code[10])        {            Caption = 'Trsf.-from Country/Region Code';            TableRelation = "Country/Region";        }        field(11; "Transfer-to Code"; Code[10])        {            Caption = 'Transfer-to Code';            ToolTip = 'Specifies the code of the location that the items are transferred to.';            TableRelation = Location where("Use As In-Transit" = const(false));        }        field(12; "Transfer-to Name"; Text[100])        {            Caption = 'Transfer-to Name';            ToolTip = 'Specifies the name of the recipient at the location that the items are transferred to.';        }        field(13; "Transfer-to Name 2"; Text[50])        {            Caption = 'Transfer-to Name 2';            ToolTip = 'Specifies an additional part of the name of the recipient at the location that the items are transferred to.';        }        field(14; "Transfer-to Address"; Text[100])        {            Caption = 'Transfer-to Address';            ToolTip = 'Specifies the address of the location that the items are transferred to.';        }        field(15; "Transfer-to Address 2"; Text[50])        {            Caption = 'Transfer-to Address 2';            ToolTip = 'Specifies an additional part of the address of the location that items are transferred to.';        }        field(16; "Transfer-to Post Code"; Code[20])        {            Caption = 'Transfer-to Post Code';            TableRelation = "Post Code";            ValidateTableRelation = false;        }        field(17; "Transfer-to City"; Text[30])        {            Caption = 'Transfer-to City';            ToolTip = 'Specifies the city of the location that items are transferred to.';            TableRelation = "Post Code".City;            ValidateTableRelation = false;        }        field(18; "Transfer-to County"; Text[30])        {            CaptionClass = '5,8,' + "Trsf.-to Country/Region Code";            Caption = 'Transfer-to County';        }        field(19; "Trsf.-to Country/Region Code"; Code[10])        {            Caption = 'Trsf.-to Country/Region Code';            TableRelation = "Country/Region";        }        field(20; "Transfer Order Date"; Date)        {            Caption = 'Transfer Order Date';            ToolTip = 'Specifies the date when the transfer order was created.';        }        field(21; "Posting Date"; Date)        {            Caption = 'Posting Date';            ToolTip = 'Specifies the posting date for this document.';        }        field(22; Comment; Boolean)        {            CalcFormula = exist("Inventory Comment Line" where("Document Type" = const("Posted Transfer Shipment"),                                                                "No." = field("No.")));            Caption = 'Comment';            Editable = false;            FieldClass = FlowField;        }        field(23; "Shortcut Dimension 1 Code"; Code[20])        {            CaptionClass = '1,2,1';            Caption = 'Shortcut Dimension 1 Code';            ToolTip = 'Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1));        }        field(24; "Shortcut Dimension 2 Code"; Code[20])        {            CaptionClass = '1,2,2';            Caption = 'Shortcut Dimension 2 Code';            ToolTip = 'Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2));        }        field(25; "Transfer Order No."; Code[20])        {            Caption = 'Transfer Order No.';            ToolTip = 'Specifies the number of the related transfer order.';            TableRelation = "Transfer Header";            ValidateTableRelation = false;        }        field(26; "No. Series"; Code[20])        {            Caption = 'No. Series';            TableRelation = "No. Series";        }        field(27; "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(28; "Receipt Date"; Date)        {            Caption = 'Receipt Date';            ToolTip = 'Specifies the receipt date of the transfer order.';        }        field(29; "In-Transit Code"; Code[10])        {            Caption = 'In-Transit Code';            ToolTip = 'Specifies the in-transit code for the transfer order, such as a shipping agent.';            TableRelation = Location.Code where("Use As In-Transit" = const(true));        }        field(30; "Transfer-from Contact"; Text[100])        {            Caption = 'Transfer-from Contact';            ToolTip = 'Specifies the name of the contact person at the location that the items are transferred from.';        }        field(31; "Transfer-to Contact"; Text[100])        {            Caption = 'Transfer-to Contact';            ToolTip = 'Specifies the name of the contact person at the location that items are transferred to.';        }        field(32; "External Document No."; Code[35])        {            Caption = 'External Document No.';        }        field(33; "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(34; "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(35; "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(47; "Transaction Type"; Code[10])        {            Caption = 'Transaction Type';            ToolTip = 'Specifies the type of transaction that the document represents, for the purpose of reporting to INTRASTAT.';            TableRelation = "Transaction Type";        }        field(48; "Transport Method"; Code[10])        {            Caption = 'Transport Method';            ToolTip = 'Specifies the transport method, for the purpose of reporting to INTRASTAT.';            TableRelation = "Transport Method";        }        field(49; "Partner VAT ID"; Code[20])        {            Caption = 'Partner VAT ID';            ToolTip = 'Specifies the counter party''s VAT number.';        }        field(59; "Entry/Exit Point"; Code[10])        {            Caption = 'Entry/Exit Point';            ToolTip = 'Specifies the code of either the port of entry at which the items passed into your country/region, or the port of exit.';            TableRelation = "Entry/Exit Point";        }        field(63; "Area"; Code[10])        {            Caption = 'Area';            ToolTip = 'Specifies the area of the customer or vendor, for the purpose of reporting to INTRASTAT.';            TableRelation = Area;        }        field(64; "Transaction Specification"; Code[10])        {            Caption = 'Transaction Specification';            ToolTip = 'Specifies a specification of the document''s transaction, for the purpose of reporting to INTRASTAT.';            TableRelation = "Transaction Specification";        }        field(70; "Direct Transfer"; Boolean)        {            Caption = 'Direct Transfer';            ToolTip = 'Specifies that the transfer does not use an in-transit location.';        }        field(480; "Dimension Set ID"; Integer)        {            Caption = 'Dimension Set ID';            Editable = false;            TableRelation = "Dimension Set Entry";            trigger OnLookup()            begin                Rec.ShowDimensions();            end;        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Posting Date")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", "Transfer-from Code", "Transfer-to Code", "Posting Date", "Transfer Order Date")        {        }    }    trigger OnDelete()    var        InvtCommentLine: Record "Inventory Comment Line";        TransShptLine: Record "Transfer Shipment Line";        MoveEntries: Codeunit MoveEntries;    begin        TransShptLine.SetRange("Document No.", "No.");        if TransShptLine.Find('-') then            repeat                TransShptLine.Delete();            until TransShptLine.Next() = 0;        InvtCommentLine.SetRange("Document Type", InvtCommentLine."Document Type"::"Posted Transfer Shipment");        InvtCommentLine.SetRange("No.", "No.");        InvtCommentLine.DeleteAll();        ItemTrackingMgt.DeleteItemEntryRelation(          DATABASE::"Transfer Shipment Line", 0, "No.", '', 0, 0, true);        MoveEntries.MoveDocRelatedEntries(DATABASE::"Transfer Shipment Header", "No.");    end;    var        DimMgt: Codeunit DimensionManagement;        ItemTrackingMgt: Codeunit "Item Tracking Management";    procedure Navigate()    var        NavigatePage: Page Navigate;    begin        NavigatePage.SetDoc("Posting Date", "No.");        NavigatePage.SetRec(Rec);        NavigatePage.Run();    end;    procedure PrintRecords(ShowRequestForm: Boolean)    var        ReportSelection: Record "Report Selections";        TransShptHeader: Record "Transfer Shipment Header";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePrintRecords(Rec, ShowRequestForm, IsHandled);        if IsHandled then            exit;        TransShptHeader.Copy(Rec);        ReportSelection.PrintWithDialogForCust(ReportSelection.Usage::Inv2, TransShptHeader, ShowRequestForm, 0);    end;    procedure ShowDimensions()    begin        DimMgt.ShowDimensionSet("Dimension Set ID", StrSubstNo('%1 %2', TableCaption(), "No."));    end;    procedure CopyFromTransferHeader(TransHeader: Record "Transfer Header")    begin        "Transfer-from Code" := TransHeader."Transfer-from Code";        "Transfer-from Name" := TransHeader."Transfer-from Name";        "Transfer-from Name 2" := TransHeader."Transfer-from Name 2";        "Transfer-from Address" := TransHeader."Transfer-from Address";        "Transfer-from Address 2" := TransHeader."Transfer-from Address 2";        "Transfer-from Post Code" := TransHeader."Transfer-from Post Code";        "Transfer-from City" := TransHeader."Transfer-from City";        "Transfer-from County" := TransHeader."Transfer-from County";        "Trsf.-from Country/Region Code" := TransHeader."Trsf.-from Country/Region Code";        "Transfer-from Contact" := TransHeader."Transfer-from Contact";        "Transfer-to Code" := TransHeader."Transfer-to Code";        "Transfer-to Name" := TransHeader."Transfer-to Name";        "Transfer-to Name 2" := TransHeader."Transfer-to Name 2";        "Transfer-to Address" := TransHeader."Transfer-to Address";        "Transfer-to Address 2" := TransHeader."Transfer-to Address 2";        "Transfer-to Post Code" := TransHeader."Transfer-to Post Code";        "Transfer-to City" := TransHeader."Transfer-to City";        "Transfer-to County" := TransHeader."Transfer-to County";        "Trsf.-to Country/Region Code" := TransHeader."Trsf.-to Country/Region Code";        "Transfer-to Contact" := TransHeader."Transfer-to Contact";        "Transfer Order Date" := TransHeader."Posting Date";        "Posting Date" := TransHeader."Posting Date";        "Shipment Date" := TransHeader."Shipment Date";        "Receipt Date" := TransHeader."Receipt Date";        "Shortcut Dimension 1 Code" := TransHeader."Shortcut Dimension 1 Code";        "Shortcut Dimension 2 Code" := TransHeader."Shortcut Dimension 2 Code";        "Dimension Set ID" := TransHeader."Dimension Set ID";        "Transfer Order No." := TransHeader."No.";        "External Document No." := TransHeader."External Document No.";        "In-Transit Code" := TransHeader."In-Transit Code";        "Shipping Agent Code" := TransHeader."Shipping Agent Code";        "Shipping Agent Service Code" := TransHeader."Shipping Agent Service Code";        "Shipment Method Code" := TransHeader."Shipment Method Code";        "Transaction Type" := TransHeader."Transaction Type";        "Transport Method" := TransHeader."Transport Method";        "Partner VAT ID" := TransHeader."Partner VAT ID";        "Entry/Exit Point" := TransHeader."Entry/Exit Point";        Area := TransHeader.Area;        "Transaction Specification" := TransHeader."Transaction Specification";        "Direct Transfer" := TransHeader."Direct Transfer";        OnAfterCopyFromTransferHeader(Rec, TransHeader);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCopyFromTransferHeader(var TransferShipmentHeader: Record "Transfer Shipment Header"; TransferHeader: Record "Transfer Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePrintRecords(var TransShptHeader: Record "Transfer Shipment Header"; ShowRequestPage: Boolean; var IsHandled: Boolean)    begin    end;}