To-do

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

Table Type: Company

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

Table Number: 5080

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 To-do can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Team Code]
   ,[Salesperson Code]
   ,[Campaign No_]
   ,[Contact No_]
   ,[Opportunity No_]
   ,[Segment No_]
   ,[Type]
   ,[Date]
   ,[Status]
   ,[Priority]
   ,[Description]
   ,[Closed]
   ,[Date Closed]
   ,[No_ Series]
   ,[Canceled]
   ,[Contact Company No_]
   ,[Recurring]
   ,[Recurring Date Interval]
   ,[Calc_ Due Date From]
   ,[Start Time]
   ,[Duration]
   ,[Opportunity Entry No_]
   ,[Last Date Modified]
   ,[Last Time Modified]
   ,[All Day Event]
   ,[Location]
   ,[Organizer To-do No_]
   ,[Interaction Template Code]
   ,[Language Code]
   ,[Attachment No_]
   ,[Subject]
   ,[Unit Cost (LCY)]
   ,[Unit Duration (Min_)]
   ,[System To-do Type]
   ,[Completed By]
   ,[Ending Date]
   ,[Ending Time]
   ,[Wizard Step]
   ,[Team To-do]
   ,[Send on finish]
   ,[Segment Description]
   ,[Team Meeting Organizer]
   ,[Activity Code]
   ,[Wizard Contact Name]
   ,[Wizard Campaign Description]
   ,[Wizard Opportunity Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [To-do].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [To-do].[Opportunity No_] = [Opportunity].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [To-do].[Language Code] = [Language].[Code]

Show/hide columns in To-do table

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

Show/hide example query

SELECT
       [To-do].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [To-do].[Salesperson Code] = [Salesperson_Purchaser].[No_]
5Campaign No_ Searchnvarchar(40)
6Contact No_ Searchnvarchar(40)
7Opportunity No_ Searchnvarchar(40)
Key to join to the Opportunity table.

Show/hide example query

SELECT
       [To-do].[Opportunity No_]
       ,[Opportunity].[No_]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
              ON
                     [To-do].[Opportunity No_] = [Opportunity].[No_]
8Segment No_ Searchnvarchar(40)
9Type Searchint
10Date Searchdatetime
11Status Searchint
12Priority Searchint
13Description Searchnvarchar(200)
14Closed Searchtinyint
15Date Closed Searchdatetime
16No_ Series Searchnvarchar(40)
17Canceled Searchtinyint
18Contact Company No_ Searchnvarchar(40)
19Recurring Searchtinyint
20Recurring Date Interval Searchvarchar(32)
21Calc_ Due Date From Searchint
22Start Time Searchdatetime
23Duration Searchbigint
24Opportunity Entry No_ Searchint
25Last Date Modified Searchdatetime
26Last Time Modified Searchdatetime
27All Day Event Searchtinyint
28Location Searchnvarchar(200)
29Organizer To-do No_ Searchnvarchar(40)
30Interaction Template Code Searchnvarchar(20)
31Language Code Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [To-do].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [To-do].[Language Code] = [Language].[Code]
32Attachment No_ Searchint
33Subject Searchnvarchar(200)
34Unit Cost (LCY) Searchdecimal(38,38)
35Unit Duration (Min_) Searchdecimal(38,38)
36System To-do Type Searchint
37Completed By Searchnvarchar(40)
38Ending Date Searchdatetime
39Ending Time Searchdatetime
40Wizard Step Searchint
41Team To-do Searchtinyint
42Send on finish Searchtinyint
43Segment Description Searchnvarchar(200)
44Team Meeting Organizer Searchnvarchar(40)
45Activity Code Searchnvarchar(20)
46Wizard Contact Name Searchnvarchar(200)
47Wizard Campaign Description Searchnvarchar(200)
48Wizard Opportunity Description Searchnvarchar(200)
49$systemId Searchuniqueidentifier
50$systemCreatedAt Searchdatetime
51$systemCreatedBy Searchuniqueidentifier
52$systemModifiedAt Searchdatetime
53$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from To-do table

Leave a Reply

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