Other table in Microsoft Dynamics 365 Business Central. 43 fields, 15 records in Cronus demo.
The Opportunity table (ID 5092) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 43 fields, with a primary key of No., and includes 14 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | No. PK | Code | Normal | |
| 2 | Description | Text | Normal | |
| 3 | Salesperson Code | Code | Normal | → Salesperson/Purchaser #13 |
| 4 | Campaign No. | Code | Normal | → Campaign #5071 |
| 5 | Contact No. | Code | Normal | → Contact #5050 |
| 6 | Contact Company No. | Code | Normal | → Contact #5050 |
| 7 | Sales Cycle Code | Code | Normal | → Sales Cycle #5090 |
| 8 | Sales Document No. | Code | Normal | |
| 9 | Creation Date | Date | Normal | |
| 10 | Status | Option | Normal | |
| 11 | Priority | Option | Normal | |
| 12 | Closed | Boolean | Normal | |
| 13 | Date Closed | Date | Normal | |
| 15 | No. Series | Code | Normal | → No. Series #308 |
| 16 | Comment ⚡ FLOW | Boolean | FlowField | |
| 17 | Current Sales Cycle Stage ⚡ FLOW | Integer | FlowField | |
| 18 | Estimated Value (LCY) ⚡ FLOW | Decimal | FlowField | |
| 19 | Probability % ⚡ FLOW | Decimal | FlowField | |
| 20 | Calcd. Current Value (LCY) ⚡ FLOW | Decimal | FlowField | |
| 21 | Chances of Success % ⚡ FLOW | Decimal | FlowField | |
| 22 | Completed % ⚡ FLOW | Decimal | FlowField | |
| 23 | Contact Name ⚡ FLOW | Text | FlowField | |
| 24 | Contact Company Name ⚡ FLOW | Text | FlowField | |
| 25 | Salesperson Name ⚡ FLOW | Text | FlowField | |
| 26 | Campaign Description ⚡ FLOW | Text | FlowField | |
| 27 | Segment No. | Code | Normal | → Segment Header #5076 |
| 28 | Estimated Closing Date ⚡ FLOW | Date | FlowField | |
| 29 | Sales Document Type | Option | Normal | |
| 30 | No. of Interactions ⚡ FLOW | Integer | FlowField | |
| 721 | Coupled to Dynamics 365 Sales ⚡ FLOW | Boolean | FlowField | |
| 9501 | Wizard Step | Option | Normal | |
| 9502 | Activate First Stage | Boolean | Normal | |
| 9503 | Segment Description | Text | Normal | |
| 9504 | Wizard Estimated Value (LCY) | Decimal | Normal | |
| 9505 | Wizard Chances of Success % | Decimal | Normal | |
| 9506 | Wizard Estimated Closing Date | Date | Normal | |
| 9507 | Wizard Contact Name | Text | Normal | |
| 9508 | Wizard Campaign Description | Text | Normal | |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |
Tables referenced by fields on the Opportunity table through TableRelation properties.