---
id: object/table/5091
type: object
title: Table 5091 "Sales Cycle Stage"
summary: Table 5091 "Sales Cycle Stage" in Base Application (Microsoft.CRM.Opportunity). 15 fields. Present since at least BC23, still in BC30, changed in BC24, BC27-28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 5a4d45e6a9adfe8a68eb6337ece0cefd33ca16231df895b49afb00a6ac91968a
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/CRM/Opportunity/SalesCycleStage.Table.al
    title: src/Layers/W1/BaseApp/CRM/Opportunity/SalesCycleStage.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 5091
name: Sales Cycle Stage
namespace: Microsoft.CRM.Opportunity
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "27"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 15
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 8
  referenced_by: 7
  pages: 3
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 5091 "Sales Cycle Stage"

> Table 5091 "Sales Cycle Stage" in Base Application (Microsoft.CRM.Opportunity). 15 fields. Present since at least BC23, still in BC30, changed in BC24, BC27-28.

Base Application · Microsoft.CRM.Opportunity · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/CRM/Opportunity/SalesCycleStage.Table.al) · 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"](../table/5090.md) (Sales Cycle); NotBlank |
| 2 | Stage | Integer | Specifies the number of the stage within the sales cycle. | NotBlank |
| 3 | Description | Text[100] | Specifies the description of the sales cycle stage. |  |
| 4 | Completed % | Decimal | Specifies the percentage of the sales cycle that has been completed when the opportunity reaches this stage. |  |
| 5 | Activity Code | Code[10] | Specifies the code of the activity linked to this sales cycle stage (if there is one). | TableRelation [Table 5081 "Activity"](../table/5081.md) |
| 6 | Quote Required | 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 | Boolean | Specifies that it is possible to skip this stage and move the opportunity to the next stage. |  |
| 8 | Comment | 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 | 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) | Decimal | Specifies the estimated value of all the open opportunities that are at this stage of the sales cycle. This field is not editable. <small>via [Page 5122 "Sales Cycle Stage Statistics"](../page/5122.md)</small> | 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) | 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. <small>via [Page 5122 "Sales Cycle Stage Statistics"](../page/5122.md)</small> | 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 | 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 | DateFormula | Specifies how dates for planned activities are calculated when you run the Opportunity - Details report. |  |
| 15 | Chances of Success % | 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"](../page/5121.md)
- Comment: CalcFormula [Table 5061 "Rlshp. Mgt. Comment Line"](../table/5061.md)
- Activity Code: TableRelation [Table 5081 "Activity"](../table/5081.md)
- Sales Cycle Code: TableRelation [Table 5090 "Sales Cycle"](../table/5090.md)
- Average No. of Days: CalcFormula [Table 5093 "Opportunity Entry"](../table/5093.md)
- Calcd. Current Value (LCY): CalcFormula [Table 5093 "Opportunity Entry"](../table/5093.md)
- Estimated Value (LCY): CalcFormula [Table 5093 "Opportunity Entry"](../table/5093.md)
- No. of Opportunities: CalcFormula [Table 5093 "Opportunity Entry"](../table/5093.md)

## Referenced by

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

- [Table 5093 "Opportunity Entry"](../table/5093.md): Previous Sales Cycle Stage, Sales Cycle Stage
- [Table 13 "Salesperson/Purchaser"](../table/13.md): Sales Cycle Stage Filter
- [Table 5050 "Contact"](../table/5050.md): Sales Cycle Stage Filter
- [Table 5061 "Rlshp. Mgt. Comment Line"](../table/5061.md): Sub No.
- [Table 5071 "Campaign"](../table/5071.md): Sales Cycle Stage Filter
- [Table 5102 "RM Matrix Management"](../table/5102.md): Sales Cycle Stage Filter

## Pages and codeunits on this table

- [Page 37082 "Sales Cycle Stage - PBI API"](../page/37082.md) (source table)
- [Page 5121 "Sales Cycle Stages"](../page/5121.md) (source table)
- [Page 5122 "Sales Cycle Stage Statistics"](../page/5122.md) (source table)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC27-28

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## 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.