Table 5083 Team

Base Application, Microsoft.CRM.Team

src/Layers/W1/BaseApp/CRM/Team/Team.Table.al126 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.Team;using Microsoft.CRM.Campaign;using Microsoft.CRM.Contact;using Microsoft.CRM.Task;table 5083 Team{    Caption = 'Team';    DataCaptionFields = "Code", Name;    DataClassification = CustomerContent;    DrillDownPageID = Teams;    LookupPageID = Teams;    fields    {        field(1; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies the code for the team.';            NotBlank = true;        }        field(2; Name; Text[50])        {            Caption = 'Name';            ToolTip = 'Specifies the name of the team.';        }        field(3; "Next Task Date"; Date)        {            CalcFormula = min("To-do".Date where("Team Code" = field(Code),                                                  Closed = const(false)));            Caption = 'Next Task Date';            ToolTip = 'Specifies the date of the next task involving the team.';            Editable = false;            FieldClass = FlowField;        }        field(4; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(5; "Contact Filter"; Code[20])        {            Caption = 'Contact Filter';            FieldClass = FlowFilter;            TableRelation = Contact;        }        field(6; "Contact Company Filter"; Code[20])        {            Caption = 'Contact Company Filter';            FieldClass = FlowFilter;            TableRelation = Contact where(Type = const(Company));        }        field(7; "Task Status Filter"; Enum "Task Status")        {            Caption = 'Task Status Filter';            FieldClass = FlowFilter;        }        field(8; "Task Closed Filter"; Boolean)        {            Caption = 'Task Closed Filter';            FieldClass = FlowFilter;        }        field(9; "Priority Filter"; Option)        {            Caption = 'Priority Filter';            FieldClass = FlowFilter;            OptionCaption = 'Low,Normal,High';            OptionMembers = Low,Normal,High;        }        field(11; "Salesperson Filter"; Code[20])        {            Caption = 'Salesperson Filter';            FieldClass = FlowFilter;            TableRelation = "Salesperson/Purchaser";        }        field(12; "Campaign Filter"; Code[20])        {            Caption = 'Campaign Filter';            FieldClass = FlowFilter;            TableRelation = Campaign;        }        field(13; "Task Entry Exists"; Boolean)        {            CalcFormula = exist("To-do" where("Team Code" = field(Code),                                               "Contact No." = field("Contact Filter"),                                               "Contact Company No." = field("Contact Company Filter"),                                               "Salesperson Code" = field("Salesperson Filter"),                                               "Campaign No." = field("Campaign Filter"),                                               Status = field("Task Status Filter"),                                               Closed = field("Task Closed Filter"),                                               Priority = field("Priority Filter"),                                               Date = field("Date Filter")));            Caption = 'Task Entry Exists';            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        TeamSalesperson: Record "Team Salesperson";    begin        TeamSalesperson.Reset();        TeamSalesperson.SetRange("Team Code", Code);        TeamSalesperson.DeleteAll();    end;}