Table 5072 Campaign Entry

Base Application, Microsoft.CRM.Campaign

src/Layers/W1/BaseApp/CRM/Campaign/CampaignEntry.Table.al188 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.Campaign;using Microsoft.CRM.Interaction;using Microsoft.CRM.Segment;using Microsoft.CRM.Team;using System.Security.AccessControl;table 5072 "Campaign Entry"{    Caption = 'Campaign Entry';    DataCaptionFields = "Campaign No.";    DataClassification = CustomerContent;    DrillDownPageID = "Campaign Entries";    LookupPageID = "Campaign Entries";    fields    {        field(1; "Entry No."; Integer)        {            Caption = 'Entry No.';            ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.';        }        field(2; "Campaign No."; Code[20])        {            Caption = 'Campaign No.';            TableRelation = Campaign;        }        field(3; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the campaign entry.';        }        field(4; Date; Date)        {            Caption = 'Date';            ToolTip = 'Specifies the date the campaign entry was recorded. The field is not editable.';        }        field(5; "User ID"; Code[50])        {            Caption = 'User ID';            DataClassification = EndUserIdentifiableInformation;            Editable = false;            TableRelation = User."User Name";        }        field(6; "Segment No."; Code[20])        {            Caption = 'Segment No.';            TableRelation = "Segment Header";        }        field(7; Canceled; Boolean)        {            BlankZero = true;            Caption = 'Canceled';            ToolTip = 'Specifies that the entry has been canceled.';        }        field(8; "No. of Interactions"; Integer)        {            CalcFormula = count("Interaction Log Entry" where("Campaign No." = field("Campaign No."),                                                               "Campaign Entry No." = field("Entry No."),                                                               Canceled = field(Canceled)));            Caption = 'No. of Interactions';            ToolTip = 'Specifies the number of interactions created as part of the campaign entry. The field is not editable.';            Editable = false;            FieldClass = FlowField;        }        field(10; "Cost (LCY)"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            CalcFormula = sum("Interaction Log Entry"."Cost (LCY)" where("Campaign No." = field("Campaign No."),                                                                          "Campaign Entry No." = field("Entry No."),                                                                          Canceled = field(Canceled)));            Caption = 'Cost (LCY)';            Editable = false;            FieldClass = FlowField;        }        field(11; "Duration (Min.)"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Interaction Log Entry"."Duration (Min.)" where("Campaign No." = field("Campaign No."),                                                                               "Campaign Entry No." = field("Entry No."),                                                                               Canceled = field(Canceled)));            Caption = 'Duration (Min.)';            DecimalPlaces = 0 : 0;            Editable = false;            FieldClass = FlowField;        }        field(12; "Salesperson Code"; Code[20])        {            Caption = 'Salesperson Code';            TableRelation = "Salesperson/Purchaser";        }        field(13; "Register No."; Integer)        {            Caption = 'Register No.';            TableRelation = "Logged Segment";        }        field(14; "Document Type"; Enum "Interaction Log Entry Document Type")        {            Caption = 'Document Type';        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; "Campaign No.", Date, "Document Type")        {        }        key(Key3; "Register No.")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "Entry No.", "Campaign No.", Description, Date, "Document Type")        {        }    }    trigger OnDelete()    var        InteractLogEntry: Record "Interaction Log Entry";    begin        InteractLogEntry.SetCurrentKey("Campaign No.", "Campaign Entry No.");        InteractLogEntry.SetRange("Campaign No.", "Campaign No.");        InteractLogEntry.SetRange("Campaign Entry No.", "Entry No.");        InteractLogEntry.DeleteAll();    end;    var#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label '%1 %2 is marked %3.\Do you wish to remove the checkmark?';        Text002: Label 'Do you wish to mark %1 %2 as %3?';#pragma warning restore AA0470#pragma warning restore AA0074    procedure CopyFromSegment(SegLine: Record "Segment Line")    begin        "Campaign No." := SegLine."Campaign No.";        Date := SegLine.Date;        "Segment No." := SegLine."Segment No.";        "Salesperson Code" := SegLine."Salesperson Code";        "User ID" := UserId();        "Document Type" := SegLine."Document Type";    end;    procedure ToggleCanceledCheckmark()    var        MasterCanceledCheckmark: Boolean;    begin        if ConfirmToggleCanceledCheckmark() then begin            MasterCanceledCheckmark := not Canceled;            SetCanceledCheckmark(MasterCanceledCheckmark);        end;    end;    procedure SetCanceledCheckmark(CanceledCheckmark: Boolean)    var        InteractLogEntry: Record "Interaction Log Entry";    begin        Canceled := CanceledCheckmark;        Modify();        InteractLogEntry.SetCurrentKey("Campaign No.", "Campaign Entry No.");        InteractLogEntry.SetRange("Campaign No.", "Campaign No.");        InteractLogEntry.SetRange("Campaign Entry No.", "Entry No.");        InteractLogEntry.ModifyAll(Canceled, Canceled);    end;    local procedure ConfirmToggleCanceledCheckmark(): Boolean    begin        if Canceled then            exit(Confirm(Text000, true, TableCaption(), "Entry No.", FieldCaption(Canceled)));        exit(Confirm(Text002, true, TableCaption(), "Entry No.", FieldCaption(Canceled)));    end;}