Table 5091 Sales Cycle Stage

Base Application, Microsoft.CRM.Opportunity

src/Layers/W1/BaseApp/CRM/Opportunity/SalesCycleStage.Table.al176 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.Opportunity;using Microsoft.CRM.Comment;using Microsoft.CRM.Task;table 5091 "Sales Cycle Stage"{    Caption = 'Sales Cycle Stage';    DataCaptionFields = "Sales Cycle Code", Stage, Description;    DataClassification = CustomerContent;    LookupPageID = "Sales Cycle Stages";    fields    {        field(1; "Sales Cycle Code"; Code[10])        {            Caption = 'Sales Cycle Code';            NotBlank = true;            TableRelation = "Sales Cycle";        }        field(2; Stage; Integer)        {            BlankZero = true;            Caption = 'Stage';            ToolTip = 'Specifies the number of the stage within the sales cycle.';            MinValue = 1;            NotBlank = true;        }        field(3; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the sales cycle stage.';        }        field(4; "Completed %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Completed %';            ToolTip = 'Specifies the percentage of the sales cycle that has been completed when the opportunity reaches this stage.';            DecimalPlaces = 0 : 0;            MaxValue = 100;            MinValue = 0;        }        field(5; "Activity Code"; Code[10])        {            Caption = 'Activity Code';            ToolTip = 'Specifies the code of the activity linked to this sales cycle stage (if there is one).';            TableRelation = Activity;        }        field(6; "Quote Required"; Boolean)        {            Caption = 'Quote Required';            ToolTip = 'Specifies that a quote is required at this stage before the opportunity can move to the next stage in the sales cycle.';        }        field(7; "Allow Skip"; Boolean)        {            Caption = 'Allow Skip';            ToolTip = 'Specifies that it is possible to skip this stage and move the opportunity to the next stage.';        }        field(8; Comment; Boolean)        {            CalcFormula = exist("Rlshp. Mgt. Comment Line" where("Table Name" = const("Sales Cycle Stage"),                                                                  "No." = field("Sales Cycle Code"),                                                                  "Sub No." = field(Stage)));            Caption = 'Comment';            ToolTip = 'Specifies that comments exist for this sales cycle stage.';            Editable = false;            FieldClass = FlowField;        }        field(9; "No. of Opportunities"; Integer)        {            CalcFormula = count("Opportunity Entry" where(Active = const(true),                                                           "Sales Cycle Code" = field("Sales Cycle Code"),                                                           "Sales Cycle Stage" = field(Stage),                                                           "Estimated Close Date" = field("Date Filter")));            Caption = 'No. of Opportunities';            ToolTip = 'Specifies the number of opportunities that are currently at this stage in the sales cycle. This field is not editable.';            Editable = false;            FieldClass = FlowField;        }        field(10; "Estimated Value (LCY)"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            CalcFormula = sum("Opportunity Entry"."Estimated Value (LCY)" where(Active = const(true),                                                                                 "Sales Cycle Code" = field("Sales Cycle Code"),                                                                                 "Sales Cycle Stage" = field(Stage),                                                                                 "Estimated Close Date" = field("Date Filter")));            Caption = 'Estimated Value (LCY)';            Editable = false;            FieldClass = FlowField;        }        field(11; "Calcd. Current Value (LCY)"; Decimal)        {            AutoFormatExpression = '';            AutoFormatType = 1;            CalcFormula = sum("Opportunity Entry"."Calcd. Current Value (LCY)" where(Active = const(true),                                                                                      "Sales Cycle Code" = field("Sales Cycle Code"),                                                                                      "Sales Cycle Stage" = field(Stage),                                                                                      "Estimated Close Date" = field("Date Filter")));            Caption = 'Calcd. Current Value (LCY)';            Editable = false;            FieldClass = FlowField;        }        field(12; "Average No. of Days"; Decimal)        {            AutoFormatType = 0;            CalcFormula = average("Opportunity Entry"."Days Open" where(Active = const(false),                                                                         "Sales Cycle Code" = field("Sales Cycle Code"),                                                                         "Sales Cycle Stage" = field(Stage),                                                                         "Estimated Close Date" = field("Date Filter")));            Caption = 'Average No. of Days';            ToolTip = 'Specifies the average number of days the opportunities have remained at this stage of the sales cycle. This field is not editable.';            DecimalPlaces = 0 : 2;            Editable = false;            FieldClass = FlowField;        }        field(13; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(14; "Date Formula"; DateFormula)        {            Caption = 'Date Formula';            ToolTip = 'Specifies how dates for planned activities are calculated when you run the Opportunity - Details report.';        }        field(15; "Chances of Success %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Chances of Success %';            ToolTip = 'Specifies the percentage of success that has been achieved when the opportunity reaches this stage.';            MaxValue = 100;            MinValue = 0;        }    }    keys    {        key(Key1; "Sales Cycle Code", Stage)        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        OppEntry: Record "Opportunity Entry";    begin        RMCommentLine.SetRange("Table Name", RMCommentLine."Table Name"::"Sales Cycle Stage");        RMCommentLine.SetRange("No.", "Sales Cycle Code");        RMCommentLine.SetRange("Sub No.", Stage);        RMCommentLine.DeleteAll();        OppEntry.SetRange(Active, true);        OppEntry.SetRange("Sales Cycle Code", "Sales Cycle Code");        OppEntry.SetRange("Sales Cycle Stage", Stage);        if not OppEntry.IsEmpty() then            Error(Text000);    end;    var        RMCommentLine: Record "Rlshp. Mgt. Comment Line";#pragma warning disable AA0074        Text000: Label 'You cannot delete a stage which has active entries.';#pragma warning restore AA0074}