Opportunity Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables OOpportunity Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5093

Table Type: Company

Table Name: Opportunity Entry
Database Table Name: CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5093

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Opportunity Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[Opportunity No_]
   ,[Sales Cycle Code]
   ,[Sales Cycle Stage]
   ,[Contact No_]
   ,[Contact Company No_]
   ,[Salesperson Code]
   ,[Campaign No_]
   ,[Date of Change]
   ,[Active]
   ,[Date Closed]
   ,[Days Open]
   ,[Action Taken]
   ,[Estimated Value (LCY)]
   ,[Calcd_ Current Value (LCY)]
   ,[Completed _]
   ,[Chances of Success _]
   ,[Probability _]
   ,[Close Opportunity Code]
   ,[Previous Sales Cycle Stage]
   ,[Estimated Close Date]
   ,[Wizard Step]
   ,[Cancel Old To Do]
   ,[Action Type]
   ,[Sales Cycle Stage Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle]
      ON
         [Opportunity Entry].[Sales Cycle Code] = [Sales Cycle].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Opportunity Entry].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Opportunity Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Opportunity Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Opportunity Entry table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Opportunity No.	Opportunity No.	Normal	Code	20	Opportunity No_	nvarchar(40)
	Key to join to the Opportunity table. Show/hide example query SELECT [Opportunity Entry].[Opportunity No_] ,[Opportunity].[No_] FROM [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry] LEFT JOIN [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity] ON [Opportunity Entry].[Opportunity No_] = [Opportunity].[No_]
3	Sales Cycle Code	Sales Cycle Code	Normal	Code	10	Sales Cycle Code	nvarchar(20)
	Key to join to the Sales Cycle table. Show/hide example query SELECT [Opportunity Entry].[Sales Cycle Code] ,[Sales Cycle].[Code] FROM [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry] LEFT JOIN [CRONUS UK Ltd_$Sales Cycle$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cycle] ON [Opportunity Entry].[Sales Cycle Code] = [Sales Cycle].[Code]
4	Sales Cycle Stage	Sales Cycle Stage	Normal	Integer	4	Sales Cycle Stage	int
5	Contact No.	Contact No.	Normal	Code	20	Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Opportunity Entry].[Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Opportunity Entry].[Contact No_] = [Contact].[No_]
6	Contact Company No.	Contact Company No.	Normal	Code	20	Contact Company No_	nvarchar(40)
7	Salesperson Code	Salesperson Code	Normal	Code	20	Salesperson Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Opportunity Entry].[Salesperson Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [Opportunity Entry].[Salesperson Code] = [Salesperson/Purchaser].[Code]
8	Campaign No.	Campaign No.	Normal	Code	20	Campaign No_	nvarchar(40)
	Key to join to the Campaign table. Show/hide example query SELECT [Opportunity Entry].[Campaign No_] ,[Campaign].[No_] FROM [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry] LEFT JOIN [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign] ON [Opportunity Entry].[Campaign No_] = [Campaign].[No_]
9	Date of Change	Date of Change	Normal	Date	4	Date of Change	datetime
10	Active	Active	Normal	Boolean	4	Active	tinyint
11	Date Closed	Date Closed	Normal	Date	4	Date Closed	datetime
12	Days Open	Days Open	Normal	Decimal	12	Days Open	decimal(38,38)
13	Action Taken	Action Taken	Normal	Option	4	Action Taken	int
	Available options are: ” “ “Next” “Previous” “Updated” “Jumped” “Won” “Lost”
14	Estimated Value (LCY)	Estimated Value ($)	Normal	Decimal	12	Estimated Value (LCY)	decimal(38,38)
15	Calcd. Current Value (LCY)	Calcd. Current Value ($)	Normal	Decimal	12	Calcd_ Current Value (LCY)	decimal(38,38)
16	Completed %	Completed %	Normal	Decimal	12	Completed _	decimal(38,38)
17	Chances of Success %	Chances of Success %	Normal	Decimal	12	Chances of Success _	decimal(38,38)
18	Probability %	Probability %	Normal	Decimal	12	Probability _	decimal(38,38)
19	Close Opportunity Code	Close Opportunity Code	Normal	Code	10	Close Opportunity Code	nvarchar(20)
20	Previous Sales Cycle Stage	Previous Sales Cycle Stage	Normal	Integer	4	Previous Sales Cycle Stage	int
21	Estimated Close Date	Estimated Close Date	Normal	Date	4	Estimated Close Date	datetime
9501	Wizard Step	Wizard Step	Normal	Option	4	Wizard Step	int
	Available options are: ” “ “1” “2” “3” “4” “5” “6”
9502	Cancel Old To Do	Cancel Old Task	Normal	Boolean	4	Cancel Old To Do	tinyint
9503	Action Type	Action Type	Normal	Option	4	Action Type	int
	Available options are: ” “ “First” “Next” “Previous” “Skip” “Update” “Jump”
9504	Sales Cycle Stage Description	Sales Cycle Stage Description	Normal	Text	100	Sales Cycle Stage Description	nvarchar(200)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Opportunity Entry].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry] LEFT JOIN [User] AS [User] ON [Opportunity Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Opportunity Entry table

Dynamics 365 BC Table Reference Tables Company Tables OOpportunity Entry

Leave a Reply Cancel reply