Table 224 Order Address

Base Application, Microsoft.Purchases.Vendor

src/Layers/W1/BaseApp/Purchases/Vendor/OrderAddress.Table.al274 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.Purchases.Vendor;using Microsoft.EServices.OnlineMap;using Microsoft.Foundation.Address;using System.Email;table 224 "Order Address"{    Caption = 'Order Address';    DataCaptionFields = "Vendor No.", Name, "Code";    LookupPageID = "Order Address List";    DataClassification = CustomerContent;    fields    {        field(1; "Vendor No."; Code[20])        {            Caption = 'Vendor No.';            NotBlank = true;            TableRelation = Vendor;        }        field(2; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies an order-from address code.';            NotBlank = true;        }        field(3; Name; Text[100])        {            Caption = 'Name';            ToolTip = 'Specifies the name of the company located at the address.';        }        field(4; "Name 2"; Text[50])        {            Caption = 'Name 2';            ToolTip = 'Specifies an additional part of the name.';        }        field(5; Address; Text[100])        {            Caption = 'Address';            ToolTip = 'Specifies the order address.';        }        field(6; "Address 2"; Text[50])        {            Caption = 'Address 2';            ToolTip = 'Specifies additional address information.';        }        field(7; City; Text[30])        {            Caption = 'City';            ToolTip = 'Specifies the city of the order address.';            TableRelation = if ("Country/Region Code" = const('')) "Post Code".City            else            if ("Country/Region Code" = filter(<> '')) "Post Code".City where("Country/Region Code" = field("Country/Region Code"));            ValidateTableRelation = false;            trigger OnLookup()            begin                OnBeforeLookupCity(Rec, PostCode);                LookupPostCode(Rec.FieldNo(City));            end;            trigger OnValidate()            var                IsHandled: Boolean;            begin                IsHandled := false;                OnBeforeValidateCity(Rec, PostCode, CurrFieldNo, IsHandled);                if not IsHandled then                    PostCode.ValidateCity(City, "Post Code", County, "Country/Region Code", (CurrFieldNo <> 0) and GuiAllowed);                OnAfterValidateCity(Rec, PostCode);            end;        }        field(8; Contact; Text[100])        {            Caption = 'Contact';            ToolTip = 'Specifies the name of the person you regularly contact when you do business with this vendor at this address.';        }        field(9; "Phone No."; Text[30])        {            Caption = 'Phone No.';            ToolTip = 'Specifies the telephone number that is associated with the order address.';            ExtendedDatatype = PhoneNo;        }        field(10; "Telex No."; Text[30])        {            Caption = 'Telex No.';        }        field(35; "Country/Region Code"; Code[10])        {            Caption = 'Country/Region Code';            ToolTip = 'Specifies the country/region of the address.';            TableRelation = "Country/Region";            trigger OnValidate()            begin                PostCode.CheckClearPostCodeCityCounty(City, "Post Code", County, "Country/Region Code", xRec."Country/Region Code");            end;        }        field(54; "Last Date Modified"; Date)        {            Caption = 'Last Date Modified';            ToolTip = 'Specifies when this order address was last modified.';            Editable = false;        }        field(84; "Fax No."; Text[30])        {            Caption = 'Fax No.';            ToolTip = 'Specifies the fax number associated with the address.';        }        field(85; "Telex Answer Back"; Text[20])        {            Caption = 'Telex Answer Back';        }        field(91; "Post Code"; Code[20])        {            Caption = 'Post Code';            ToolTip = 'Specifies the postal code.';            TableRelation = if ("Country/Region Code" = const('')) "Post Code"            else            if ("Country/Region Code" = filter(<> '')) "Post Code" where("Country/Region Code" = field("Country/Region Code"));            ValidateTableRelation = false;            trigger OnLookup()            begin                OnBeforeLookupPostCode(Rec, PostCode);                LookupPostCode(Rec.FieldNo("Post Code"));            end;            trigger OnValidate()            var                IsHandled: Boolean;            begin                IsHandled := false;                OnBeforeValidatePostCode(Rec, PostCode, CurrFieldNo, IsHandled);                if not IsHandled then                    PostCode.ValidatePostCode(City, "Post Code", County, "Country/Region Code", (CurrFieldNo <> 0) and GuiAllowed);                OnAfterValidatePostCode(Rec, PostCode);            end;        }        field(92; County; Text[30])        {            CaptionClass = '5,1,' + "Country/Region Code";            Caption = 'County';            ToolTip = 'Specifies the county of the address.';        }        field(102; "E-Mail"; Text[80])        {            Caption = 'Email';            ToolTip = 'Specifies the email address associated with the order address.';            ExtendedDatatype = EMail;            trigger OnValidate()            var                MailManagement: Codeunit "Mail Management";            begin                MailManagement.ValidateEmailAddressField("E-Mail");            end;        }#if not CLEAN27#pragma warning disable AS0086#endif        field(103; "Home Page"; Text[255])#if not CLEAN27#pragma warning restore AS0086#endif        {            Caption = 'Home Page';            ToolTip = 'Specifies the recipient''s web site.';            ExtendedDatatype = URL;        }    }    keys    {        key(Key1; "Vendor No.", "Code")        {            Clustered = true;        }    }    fieldgroups    {        fieldgroup(DropDown; "Code", Name, Address, City, "Post Code")        {        }    }    trigger OnInsert()    begin        Vend.Get("Vendor No.");        Name := Vend.Name;    end;    trigger OnModify()    begin        "Last Date Modified" := Today;    end;    trigger OnRename()    begin        "Last Date Modified" := Today;    end;    var#pragma warning disable AA0074        Text000: Label 'untitled';#pragma warning restore AA0074        Vend: Record Vendor;    protected var        PostCode: Record "Post Code";    procedure Caption(): Text    begin        if "Vendor No." = '' then            exit(Text000);        Vend.Get("Vendor No.");        exit(StrSubstNo('%1 %2 %3 %4', Vend."No.", Vend.Name, Code, Name));    end;    local procedure LookupPostCode(FieldNo: Integer)    begin        PostCode.LookupPostCode(City, "Post Code", County, "Country/Region Code");        OnAfterLookupPostCode(Rec, PostCode, FieldNo);    end;    procedure DisplayMap()    var        OnlineMapManagement: Codeunit "Online Map Management";    begin        OnlineMapManagement.MakeSelectionIfMapEnabled(Database::"Order Address", GetPosition());    end;    [IntegrationEvent(false, false)]    local procedure OnAfterLookupPostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code"; FieldNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateCity(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidatePostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeLookupCity(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidateCity(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeLookupPostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterValidatePostCode(var OrderAddress: Record "Order Address"; var PostCode: Record "Post Code");    begin    end;}