Opportunity Entry #5093

Other table in Microsoft Dynamics 365 Business Central. 30 fields, 35 records in Cronus demo.

30
Fields
35
Records
1
Primary key
0
FlowFields
10
Relations
Open in Data Explorer →

Primary key

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

All fields (30)

Opportunity Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Opportunity No. Code Normal → Opportunity #5092
3 Sales Cycle Code Code Normal → Sales Cycle #5090
4 Sales Cycle Stage Integer Normal → Sales Cycle Stage #5091
5 Contact No. Code Normal → Contact #5050
6 Contact Company No. Code Normal → Contact #5050
7 Salesperson Code Code Normal → Salesperson/Purchaser #13
8 Campaign No. Code Normal → Campaign #5071
9 Date of Change Date Normal
10 Active Boolean Normal
11 Date Closed Date Normal
12 Days Open Decimal Normal
13 Action Taken Option Normal
14 Estimated Value (LCY) Decimal Normal
15 Calcd. Current Value (LCY) Decimal Normal
16 Completed % Decimal Normal
17 Chances of Success % Decimal Normal
18 Probability % Decimal Normal
19 Close Opportunity Code Code Normal
20 Previous Sales Cycle Stage Integer Normal → Sales Cycle Stage #5091
21 Estimated Close Date Date Normal
9501 Wizard Step Option Normal
9502 Cancel Old Task Boolean Normal
9503 Action Type Option Normal
9504 Sales Cycle Stage 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 Entry table through TableRelation properties.

Opportunity
#5092 · Other · via Opportunity No.
Sales Cycle
#5090 · Other · via Sales Cycle Code
Sales Cycle Stage
#5091 · Other · via Sales Cycle Stage, Previous Sales Cycle Stage
Contact
#5050 · Other · via Contact No., Contact Company No.
Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
Campaign
#5071 · Other · via Campaign No.