Table 5091 "Sales Cycle Stage"

Base Application · Microsoft.CRM.Opportunity · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Sales Cycle Stage
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Sales Cycle Code	Code[10]	—	TableRelation Table 5090 “Sales Cycle” (Sales Cycle); NotBlank
2	Stage Δ BC28	Integer	Specifies the number of the stage within the sales cycle.	NotBlank
3	Description Δ BC28	Text[100]	Specifies the description of the sales cycle stage.
4	Completed % Δ BC27 Δ BC28	Decimal	Specifies the percentage of the sales cycle that has been completed when the opportunity reaches this stage.
5	Activity Code Δ BC28	Code[10]	Specifies the code of the activity linked to this sales cycle stage (if there is one).	TableRelation Table 5081 “Activity”
6	Quote Required Δ BC28	Boolean	Specifies that a quote is required at this stage before the opportunity can move to the next stage in the sales cycle.
7	Allow Skip Δ BC28	Boolean	Specifies that it is possible to skip this stage and move the opportunity to the next stage.
8	Comment Δ BC28	Boolean	Specifies that comments exist for this sales cycle stage.	FlowField: exist(“Rlshp. Mgt. Comment Line” where(“Table Name” = const(“Sales Cycle Stage”), “No.” = field(“Sales Cycle Code”), “Sub No.” = field(Stage))); not editable
9	No. of Opportunities Δ BC28	Integer	Specifies the number of opportunities that are currently at this stage in the sales cycle. This field is not editable.	FlowField: 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”))); not editable
10	Estimated Value (LCY) Δ BC27	Decimal	Specifies the estimated value of all the open opportunities that are at this stage of the sales cycle. This field is not editable. via Page 5122 “Sales Cycle Stage Statistics”	FlowField: 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”))); not editable
11	Calcd. Current Value (LCY) Δ BC27	Decimal	Specifies the calculated current value of all the open opportunities that are at this stage in the sales cycle. This field is not editable. via Page 5122 “Sales Cycle Stage Statistics”	FlowField: 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”))); not editable
12	Average No. of Days Δ BC24 Δ BC27 Δ BC28	Decimal	Specifies the average number of days the opportunities have remained at this stage of the sales cycle. This field is not editable.	FlowField: 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”))); not editable
13	Date Filter	Date	—	FlowFilter
14	Date Formula Δ BC28	DateFormula	Specifies how dates for planned activities are calculated when you run the Opportunity - Details report.
15	Chances of Success % Δ BC27 Δ BC28	Decimal	Specifies the percentage of success that has been achieved when the opportunity reaches this stage.

Keys

Key1: Sales Cycle Code, Stage (clustered)

Triggers

OnDelete

Relations

lookup page Page 5121 “Sales Cycle Stages”
Comment: CalcFormula Table 5061 “Rlshp. Mgt. Comment Line”
Activity Code: TableRelation Table 5081 “Activity”
Sales Cycle Code: TableRelation Table 5090 “Sales Cycle”
Average No. of Days: CalcFormula Table 5093 “Opportunity Entry”
Calcd. Current Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
Estimated Value (LCY): CalcFormula Table 5093 “Opportunity Entry”
No. of Opportunities: CalcFormula Table 5093 “Opportunity Entry”

Referenced by

7 fields in 6 objects relate to this table (TableRelation or CalcFormula).

Table 5093 “Opportunity Entry”: Previous Sales Cycle Stage, Sales Cycle Stage
Table 13 “Salesperson/Purchaser”: Sales Cycle Stage Filter
Table 5050 “Contact”: Sales Cycle Stage Filter
Table 5061 “Rlshp. Mgt. Comment Line”: Sub No.
Table 5071 “Campaign”: Sales Cycle Stage Filter
Table 5102 “RM Matrix Management”: Sales Cycle Stage Filter

Pages and codeunits on this table

Page 37082 “Sales Cycle Stage - PBI API” (source table)
Page 5121 “Sales Cycle Stages” (source table)
Page 5122 “Sales Cycle Stage Statistics” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Sales Cycle Stage"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.