Opportunity #5092

Other table in Microsoft Dynamics 365 Business Central. 43 fields, 15 records in Cronus demo.

43
Fields
15
Records
1
Primary key
14
FlowFields
9
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No..

All fields (43)

Opportunity — FIELDS
NO.FIELDTYPECLASSRELATION
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

Related tables (7)

Tables referenced by fields on the Opportunity table through TableRelation properties.

Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
Campaign
#5071 · Other · via Campaign No.
Contact
#5050 · Other · via Contact No., Contact Company No.
Sales Cycle
#5090 · Other · via Sales Cycle Code
No. Series
#308 · Other · via No. Series
Segment Header
#5076 · Other · via Segment No.