Opportunity Entry #5093

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

The Opportunity Entry table (ID 5093) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 30 fields, with a primary key of Entry No.. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

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.	FIELD	TYPE	CLASS	RELATION
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.