Opportunity 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: 0

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
   [timestamp]
   ,[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_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Opportunity Entry].[Opportunity No_] = [Opportunity].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Opportunity Entry].[Salesperson Code] = [Salesperson_Purchaser].[No_]

Show/hide columns in Opportunity Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Opportunity No_ Searchnvarchar(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_]
4Sales Cycle Code Searchnvarchar(20)
5Sales Cycle Stage Searchint
6Contact No_ Searchnvarchar(40)
7Contact Company No_ Searchnvarchar(40)
8Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Opportunity Entry].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
9Campaign No_ Searchnvarchar(40)
10Date of Change Searchdatetime
11Active Searchtinyint
12Date Closed Searchdatetime
13Days Open Searchdecimal(38,38)
14Action Taken Searchint
15Estimated Value (LCY) Searchdecimal(38,38)
16Calcd_ Current Value (LCY) Searchdecimal(38,38)
17Completed _ Searchdecimal(38,38)
18Chances of Success _ Searchdecimal(38,38)
19Probability _ Searchdecimal(38,38)
20Close Opportunity Code Searchnvarchar(20)
21Previous Sales Cycle Stage Searchint
22Estimated Close Date Searchdatetime
23Wizard Step Searchint
24Cancel Old To Do Searchtinyint
25Action Type Searchint
26Sales Cycle Stage Description Searchnvarchar(200)
27$systemId Searchuniqueidentifier
28$systemCreatedAt Searchdatetime
29$systemCreatedBy Searchuniqueidentifier
30$systemModifiedAt Searchdatetime
31$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Opportunity Entry table

Leave a Reply

Your email address will not be published. Required fields are marked *