Table 5069 Salutation Formula
src/Layers/W1/BaseApp/CRM/Setup/SalutationFormula.Table.al93 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.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;}