Opportunity

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

Table Type: Company

Table Name: Opportunity
Database Table Name: CRONUS UK Ltd_$Opportunity$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 can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Description]
   ,[Salesperson Code]
   ,[Campaign No_]
   ,[Contact No_]
   ,[Contact Company No_]
   ,[Sales Cycle Code]
   ,[Sales Document No_]
   ,[Creation Date]
   ,[Status]
   ,[Priority]
   ,[Closed]
   ,[Date Closed]
   ,[No_ Series]
   ,[Segment No_]
   ,[Sales Document Type]
   ,[Coupled to CRM]
   ,[Wizard Step]
   ,[Activate First Stage]
   ,[Segment Description]
   ,[Wizard Estimated Value (LCY)]
   ,[Wizard Chances of Success _]
   ,[Wizard Estimated Closing Date]
   ,[Wizard Contact Name]
   ,[Wizard Campaign Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Opportunity$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Opportunity].[Salesperson Code] = [Salesperson_Purchaser].[No_]

Show/hide columns in Opportunity table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Opportunity].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Opportunity].[Salesperson Code] = [Salesperson_Purchaser].[No_]
5Campaign No_ Searchnvarchar(40)
6Contact No_ Searchnvarchar(40)
7Contact Company No_ Searchnvarchar(40)
8Sales Cycle Code Searchnvarchar(20)
9Sales Document No_ Searchnvarchar(40)
10Creation Date Searchdatetime
11Status Searchint
12Priority Searchint
13Closed Searchtinyint
14Date Closed Searchdatetime
15No_ Series Searchnvarchar(40)
16Segment No_ Searchnvarchar(40)
17Sales Document Type Searchint
18Coupled to CRM Searchtinyint
19Wizard Step Searchint
20Activate First Stage Searchtinyint
21Segment Description Searchnvarchar(200)
22Wizard Estimated Value (LCY) Searchdecimal(38,38)
23Wizard Chances of Success _ Searchdecimal(38,38)
24Wizard Estimated Closing Date Searchdatetime
25Wizard Contact Name Searchnvarchar(200)
26Wizard Campaign Description Searchnvarchar(200)
27$systemId Searchuniqueidentifier
28$systemCreatedAt Searchdatetime
29$systemCreatedBy Searchuniqueidentifier
30$systemModifiedAt Searchdatetime
31$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Opportunity table

Show/hide tables related to Opportunity table

Leave a Reply

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