--- id: object/table/5090 type: object title: Table 5090 "Sales Cycle" summary: Table 5090 "Sales Cycle" in Base Application (Microsoft.CRM.Opportunity). 9 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: 3ee24b903001d7815c61598946d65d2a854d829fe817623fdf69e7b35ec7b2ae evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/CRM/Opportunity/SalesCycle.Table.al title: src/Layers/W1/BaseApp/CRM/Opportunity/SalesCycle.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/ad-hoc-analysis-finance - https://learn.microsoft.com/dynamics365/business-central/ad-hoc-analysis-inventory - https://learn.microsoft.com/dynamics365/business-central/ad-hoc-analysis-sales - https://learn.microsoft.com/dynamics365/business-central/sales-analytics-overview objects: [] features: [] topics: - topic/business-central/business-functionality/finance/financial-analytics - topic/business-central/business-functionality/inventory/inventory-analytics - topic/business-central/business-functionality/sales/sales-analytics localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 5090 name: Sales Cycle 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: 9 procedures: 0 events: 0 subscribers: 0 relations: out: 5 referenced_by: 10 pages: 3 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 5090 "Sales Cycle" > Table 5090 "Sales Cycle" in Base Application (Microsoft.CRM.Opportunity). 9 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/SalesCycle.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 5119 "Sales Cycles"](../page/5119.md) (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 | Code[10] | Specifies the code of the sales cycle. | NotBlank | | 2 | Description | Text[100] | Specifies the description of the sales cycle. | | | 3 | Probability Calculation | 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 | 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 | 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) | 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"](../page/5120.md) | 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) | 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"](../page/5120.md) | 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 | 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"](../page/5119.md) - Comment: CalcFormula [Table 5061 "Rlshp. Mgt. Comment Line"](../table/5061.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 10 fields in 10 objects relate to this table (TableRelation or CalcFormula). - [Table 13 "Salesperson/Purchaser"](../table/13.md): Sales Cycle Filter - [Table 5050 "Contact"](../table/5050.md): Sales Cycle Filter - [Table 5061 "Rlshp. Mgt. Comment Line"](../table/5061.md): No. - [Table 5071 "Campaign"](../table/5071.md): Sales Cycle Filter - [Table 5079 "Marketing Setup"](../table/5079.md): Default Sales Cycle Code - [Table 5091 "Sales Cycle Stage"](../table/5091.md): Sales Cycle Code - [Table 5092 "Opportunity"](../table/5092.md): Sales Cycle Code - [Table 5093 "Opportunity Entry"](../table/5093.md): Sales Cycle Code - [Table 5102 "RM Matrix Management"](../table/5102.md): Sales Cycle Filter - [Table 9063 "Relationship Mgmt. Cue"](../table/9063.md): Sales Cycles ## Pages and codeunits on this table - [Page 5119 "Sales Cycles"](../page/5119.md) (source table) - [Page 5120 "Sales Cycle Statistics"](../page/5120.md) (source table) - [Page 5175 "Sales Cycle Statistics FactBox"](../page/5175.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")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.