Table 5069 Salutation Formula

// ------------------------------------------------------------------------------------------------
// 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.Setup;

using Microsoft.CRM.Contact;
using System.Globalization;

table 5069 "Salutation Formula"
{
    Caption = 'Salutation Formula';
    DataClassification = CustomerContent;

    fields
    {
        field(1; "Salutation Code"; Code[10])
        {
            Caption = 'Salutation Code';
            NotBlank = true;
            TableRelation = Salutation;
        }
        field(2; "Language Code"; Code[10])
        {
            Caption = 'Language Code';
            ToolTip = 'Specifies the language that is used when translating specified text on documents to foreign business partner, such as an item description on an order confirmation.';
            TableRelation = Language;
        }
        field(3; "Salutation Type"; Enum "Salutation Formula Salutation Type")
        {
            Caption = 'Salutation Type';
            ToolTip = 'Specifies whether the salutation is formal or informal. Make your selection by clicking the field.';
        }
        field(4; Salutation; Text[50])
        {
            Caption = 'Salutation';
            ToolTip = 'Specifies the salutation itself.';
        }
        field(5; "Name 1"; Enum "Salutation Formula Name")
        {
            Caption = 'Name 1';
            ToolTip = 'Specifies a salutation. The options are: Job Title, First Name, Middle Name, Surname, Initials and Company Name.';
        }
        field(6; "Name 2"; Enum "Salutation Formula Name")
        {
            Caption = 'Name 2';
            ToolTip = 'Specifies a salutation. The options are: Job Title, First Name, Middle Name, Surname, Initials and Company Name.';
        }
        field(7; "Name 3"; Enum "Salutation Formula Name")
        {
            Caption = 'Name 3';
            ToolTip = 'Specifies a salutation. The options are: Job Title, First Name, Middle Name, Surname, Initials and Company Name.';
        }
        field(8; "Name 4"; Enum "Salutation Formula Name")
        {
            Caption = 'Name 4';
            ToolTip = 'Specifies a salutation. The options are: Job Title, First Name, Middle Name, Surname, Initials and Company Name.';
        }
        field(9; "Name 5"; Enum "Salutation Formula Name")
        {
            Caption = 'Name 5';
            ToolTip = 'Specifies a salutation.';
        }
        field(10; "Contact No. Filter"; Code[20])
        {
            Caption = 'Contact No. Filter';
            FieldClass = FlowFilter;
            TableRelation = Contact;
        }
    }

    keys
    {
        key(Key1; "Salutation Code", "Language Code", "Salutation Type")
        {
            Clustered = true;
        }
    }

    fieldgroups
    {
    }

    procedure GetContactSalutation(): Text[260]
    var
        Cont: Record Contact;
    begin
        Cont.Get(GetFilter("Contact No. Filter"));
        exit(Cont.GetSalutation("Salutation Type", "Language Code"));
    end;
}