Table 5090 "Sales Cycle"

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

Learn documents this table through its pages: Page 5119 “Sales Cycles” (4 Learn pages).

Properties

Property	Value
Caption	Sales Cycle
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	Code Δ BC28	Code[10]	Specifies the code of the sales cycle.	NotBlank
2	Description Δ BC28	Text[100]	Specifies the description of the sales cycle.
3	Probability Calculation Δ BC28	Option	Specifies the method to use to calculate the probability of opportunities completing the sales cycle. There are four options:	OptionCaption: Multiply,Add,Chances of Success %,Completed %
4	Blocked Δ BC28	Boolean	Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.
5	No. of Opportunities Δ BC24 Δ BC28	Integer	Specifies the number of opportunities that you have created using the sales cycle. This field is not editable.	FlowField: count(“Opportunity Entry” where(Active = const(true), “Sales Cycle Code” = field(Code), “Action Taken” = filter(<> Won & <> Lost), “Estimated Close Date” = field(“Date Filter”))); not editable
6	Estimated Value (LCY) Δ BC24 Δ BC27	Decimal	Specifies the estimated value of all the open opportunities that you have assigned to the sales cycle. This field is not editable. via Page 5120 “Sales Cycle Statistics”	FlowField: sum(“Opportunity Entry”.“Estimated Value (LCY)” where(Active = const(true), “Sales Cycle Code” = field(Code), “Action Taken” = filter(<> Won & <> Lost), “Estimated Close Date” = field(“Date Filter”))); not editable
7	Calcd. Current Value (LCY) Δ BC24 Δ BC27	Decimal	Specifies the calculated current value of all the open opportunities that you have assigned to the sales cycle. This field is not editable. via Page 5120 “Sales Cycle Statistics”	FlowField: sum(“Opportunity Entry”.“Calcd. Current Value (LCY)” where(Active = const(true), “Sales Cycle Code” = field(Code), “Action Taken” = filter(<> Won & <> Lost), “Estimated Close Date” = field(“Date Filter”))); not editable
8	Comment Δ BC24 Δ BC28	Boolean	Specifies that you have assigned comments to the sales cycle.	FlowField: exist(“Rlshp. Mgt. Comment Line” where(“Table Name” = const(“Sales Cycle”), “No.” = field(Code), “Sub No.” = const(0))); not editable
9	Date Filter	Date	—	FlowFilter

Keys

Key1: Code (clustered)

Triggers

OnDelete

Relations

lookup page Page 5119 “Sales Cycles”
Comment: CalcFormula Table 5061 “Rlshp. Mgt. Comment Line”
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

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

Table 13 “Salesperson/Purchaser”: Sales Cycle Filter
Table 5050 “Contact”: Sales Cycle Filter
Table 5061 “Rlshp. Mgt. Comment Line”: No.
Table 5071 “Campaign”: Sales Cycle Filter
Table 5079 “Marketing Setup”: Default Sales Cycle Code
Table 5091 “Sales Cycle Stage”: Sales Cycle Code
Table 5092 “Opportunity”: Sales Cycle Code
Table 5093 “Opportunity Entry”: Sales Cycle Code
Table 5102 “RM Matrix Management”: Sales Cycle Filter
Table 9063 “Relationship Mgmt. Cue”: Sales Cycles

Pages and codeunits on this table

Page 5119 “Sales Cycles” (source table)
Page 5120 “Sales Cycle Statistics” (source table)
Page 5175 “Sales Cycle Statistics FactBox” (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"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 19 connected objects and pages