Table 224 Order Address
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;}