Table 5052 Contact Alt. Addr. Date Range

Base Application, Microsoft.CRM.Contact

src/Layers/W1/BaseApp/CRM/Contact/ContactAltAddrDateRange.Table.al113 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.CRM.Contact;table 5052 "Contact Alt. Addr. Date Range"{    Caption = 'Contact Alt. Addr. Date Range';    DataClassification = CustomerContent;    fields    {        field(1; "Contact No."; Code[20])        {            Caption = 'Contact No.';            Editable = false;            TableRelation = Contact;        }        field(2; "Contact Alt. Address Code"; Code[10])        {            Caption = 'Contact Alt. Address Code';            ToolTip = 'Specifies the code of the contact alternate address to which the date range applies.';            TableRelation = "Contact Alt. Address".Code where("Contact No." = field("Contact No."));        }        field(3; "Starting Date"; Date)        {            Caption = 'Starting Date';            ToolTip = 'Specifies the date from which the alternate address is valid. There are certain rules for how dates should be entered.';            NotBlank = true;            trigger OnValidate()            var                ContAltAddrDateRange: Record "Contact Alt. Addr. Date Range";            begin                if ("Starting Date" > "Ending Date") and ("Ending Date" > 0D) then                    Error(Text000, FieldCaption("Starting Date"), FieldCaption("Ending Date"));                if ContAltAddrDateRange.Get("Contact No.", "Starting Date") then                    Error(Text001                      , "Starting Date", TableCaption(), Cont.TableCaption(), "Contact No.");            end;        }        field(4; "Ending Date"; Date)        {            Caption = 'Ending Date';            ToolTip = 'Specifies the last day on which the alternate address is valid. There are certain rules for how dates should be entered.';            trigger OnValidate()            begin                if ("Ending Date" < "Starting Date") and ("Ending Date" > 0D) then                    Error(Text002, FieldCaption("Ending Date"), FieldCaption("Starting Date"));            end;        }    }    keys    {        key(Key1; "Contact No.", "Starting Date")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        Contact: Record Contact;    begin        Contact.TouchContact("Contact No.");    end;    trigger OnInsert()    var        Contact: Record Contact;    begin        Contact.TouchContact("Contact No.");    end;    trigger OnModify()    var        Contact: Record Contact;    begin        Contact.TouchContact("Contact No.");    end;    trigger OnRename()    var        Contact: Record Contact;    begin        if xRec."Contact No." = "Contact No." then            Contact.TouchContact("Contact No.")        else begin            Contact.TouchContact("Contact No.");            Contact.TouchContact(xRec."Contact No.");        end;    end;    var        Cont: Record Contact;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label '%1 must be before %2.';        Text001: Label 'The starting date %1 already exists in a %2 for %3 %4.';        Text002: Label '%1 must be after %2.';#pragma warning restore AA0470#pragma warning restore AA0074}