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: 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Opportunity No. SearchOpportunity No.NormalCode20Opportunity 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_]
3Sales Cycle Code SearchSales Cycle CodeNormalCode10Sales Cycle Codenvarchar(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]
4Sales Cycle Stage SearchSales Cycle StageNormalInteger4Sales Cycle Stageint
5Contact No. SearchContact No.NormalCode20Contact 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_]
6Contact Company No. SearchContact Company No.NormalCode20Contact Company No_nvarchar(40)
7Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(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]
8Campaign No. SearchCampaign No.NormalCode20Campaign 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_]
9Date of Change SearchDate of ChangeNormalDate4Date of Changedatetime
10Active SearchActiveNormalBoolean4Activetinyint
11Date Closed SearchDate ClosedNormalDate4Date Closeddatetime
12Days Open SearchDays OpenNormalDecimal12Days Opendecimal(38,38)
13Action Taken SearchAction TakenNormalOption4Action Takenint
Available options are:
  • ” “
  • “Next”
  • “Previous”
  • “Updated”
  • “Jumped”
  • “Won”
  • “Lost”
14Estimated Value (LCY) SearchEstimated Value ($)NormalDecimal12Estimated Value (LCY)decimal(38,38)
15Calcd. Current Value (LCY) SearchCalcd. Current Value ($)NormalDecimal12Calcd_ Current Value (LCY)decimal(38,38)
16Completed % SearchCompleted %NormalDecimal12Completed _decimal(38,38)
17Chances of Success % SearchChances of Success %NormalDecimal12Chances of Success _decimal(38,38)
18Probability % SearchProbability %NormalDecimal12Probability _decimal(38,38)
19Close Opportunity Code SearchClose Opportunity CodeNormalCode10Close Opportunity Codenvarchar(20)
20Previous Sales Cycle Stage SearchPrevious Sales Cycle StageNormalInteger4Previous Sales Cycle Stageint
21Estimated Close Date SearchEstimated Close DateNormalDate4Estimated Close Datedatetime
9501Wizard Step SearchWizard StepNormalOption4Wizard Stepint
Available options are:
  • ” “
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
9502Cancel Old To Do SearchCancel Old TaskNormalBoolean4Cancel Old To Dotinyint
9503Action Type SearchAction TypeNormalOption4Action Typeint
Available options are:
  • ” “
  • “First”
  • “Next”
  • “Previous”
  • “Skip”
  • “Update”
  • “Jump”
9504Sales Cycle Stage Description SearchSales Cycle Stage DescriptionNormalText100Sales Cycle Stage Descriptionnvarchar(200)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Opportunity Entry].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Opportunity Entry table

Leave a Reply

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