Table 5063 Interaction Group

Base Application, Microsoft.CRM.Interaction

src/Layers/W1/BaseApp/CRM/Interaction/InteractionGroup.Table.al81 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.Interaction;table 5063 "Interaction Group"{    Caption = 'Interaction Group';    DataCaptionFields = "Code", Description;    DataClassification = CustomerContent;    LookupPageID = "Interaction Groups";    fields    {        field(1; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies the code for the interaction group.';            NotBlank = true;        }        field(2; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the interaction group.';        }        field(3; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(4; "No. of Interactions"; Integer)        {            CalcFormula = count("Interaction Log Entry" where("Interaction Group Code" = field(Code),                                                               Canceled = const(false),                                                               Date = field("Date Filter"),                                                               Postponed = const(false)));            Caption = 'No. of Interactions';            ToolTip = 'Specifies the number of interactions that have been created using this interaction group. This field is not editable.';            Editable = false;            FieldClass = FlowField;        }        field(5; "Cost (LCY)"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            CalcFormula = sum("Interaction Log Entry"."Cost (LCY)" where("Interaction Group Code" = field(Code),                                                                          Canceled = const(false),                                                                          Date = field("Date Filter"),                                                                          Postponed = const(false)));            Caption = 'Cost (LCY)';            Editable = false;            FieldClass = FlowField;        }        field(6; "Duration (Min.)"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Interaction Log Entry"."Duration (Min.)" where("Interaction Group Code" = field(Code),                                                                               Canceled = const(false),                                                                               Date = field("Date Filter"),                                                                               Postponed = const(false)));            Caption = 'Duration (Min.)';            DecimalPlaces = 0 : 0;            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }    }    fieldgroups    {    }}