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
   [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_)]
   ,[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_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
      ON
         [To-do].[Team Code] = [Team].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [To-do].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
      ON
         [To-do].[Interaction Template Code] = [Interaction Template].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [To-do].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [To-do].[Completed By] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [To-do].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Activity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Activity]
      ON
         [To-do].[Activity Code] = [Activity].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [To-do].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [To-do].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in To-do table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Team Code SearchTeam CodeNormalCode10Team Codenvarchar(20)
Key to join to the Team table.

Show/hide example query

SELECT
       [To-do].[Team Code]
       ,[Team].[Code]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Team$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Team]
              ON
                     [To-do].[Team Code] = [Team].[Code]
3Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [To-do].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
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].[Code]
4Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
       [To-do].[Campaign No_]
       ,[Campaign].[No_]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
              ON
                     [To-do].[Campaign No_] = [Campaign].[No_]
5Contact No. SearchContact No.NormalCode20Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [To-do].[Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [To-do].[Contact No_] = [Contact].[No_]
6Opportunity No. SearchOpportunity No.NormalCode20Opportunity No_nvarchar(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_]
7Segment No. SearchSegment No.NormalCode20Segment No_nvarchar(40)
Key to join to the Segment Header table.

Show/hide example query

SELECT
       [To-do].[Segment No_]
       ,[Segment Header].[No_]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Segment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Segment Header]
              ON
                     [To-do].[Segment No_] = [Segment Header].[No_]
8Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Meeting”
  • “Phone Call”
9Date SearchDateNormalDate4Datedatetime
10Status SearchStatusNormalOption4Statusint
Available options are:
  • “Not Started”
  • “In Progress”
  • “Completed”
  • “Waiting”
  • “Postponed”
11Priority SearchPriorityNormalOption4Priorityint
Available options are:
  • “Low”
  • “Normal”
  • “High”
12Description SearchDescriptionNormalText100Descriptionnvarchar(200)
13Closed SearchClosedNormalBoolean4Closedtinyint
14Date Closed SearchDate ClosedNormalDate4Date Closeddatetime
15No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [To-do].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [To-do].[No_ Series] = [No. Series].[Code]
16Comment SearchCommentFlowFieldBoolean4
17Canceled SearchCanceledNormalBoolean4Canceledtinyint
18Contact Name SearchContact NameFlowFieldText100
19Team Name SearchTeam NameFlowFieldText50
20Salesperson Name SearchSalesperson NameFlowFieldText50
21Campaign Description SearchCampaign DescriptionFlowFieldText100
22Contact Company No. SearchContact Company No.NormalCode20Contact Company No_nvarchar(40)
23Contact Company Name SearchContact Company NameFlowFieldText100
24Recurring SearchRecurringNormalBoolean4Recurringtinyint
25Recurring Date Interval SearchRecurring Date IntervalNormalDateFormula32Recurring Date Intervalvarchar(32)
26Calc. Due Date From SearchCalc. Due Date FromNormalOption4Calc_ Due Date Fromint
Available options are:
  • ” “
  • “Due Date”
  • “Closing Date”
27Opportunity Description SearchOpportunity DescriptionFlowFieldText100
28Start Time SearchStart TimeNormalTime4Start Timedatetime
29Duration SearchDurationNormalDuration8Durationbigint
31Opportunity Entry No. SearchOpportunity Entry No.NormalInteger4Opportunity Entry No_int
Key to join to the Opportunity Entry table.

Show/hide example query

SELECT
       [To-do].[Opportunity Entry No_]
       ,[Opportunity Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Opportunity Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity Entry]
              ON
                     [To-do].[Opportunity Entry No_] = [Opportunity Entry].[Entry No_]
32Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
33Last Time Modified SearchLast Time ModifiedNormalTime4Last Time Modifieddatetime
34All Day Event SearchAll Day EventNormalBoolean4All Day Eventtinyint
35Location SearchLocationNormalText100Locationnvarchar(200)
36Organizer To-do No. SearchOrganizer Task No.NormalCode20Organizer To-do No_nvarchar(40)
37Interaction Template Code SearchInteraction Template CodeNormalCode10Interaction Template Codenvarchar(20)
Key to join to the Interaction Template table.

Show/hide example query

SELECT
       [To-do].[Interaction Template Code]
       ,[Interaction Template].[Code]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Interaction Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Interaction Template]
              ON
                     [To-do].[Interaction Template Code] = [Interaction Template].[Code]
38Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
39Attachment No. SearchAttachment No.NormalInteger4Attachment No_int
Key to join to the Attachment table.

Show/hide example query

SELECT
       [To-do].[Attachment No_]
       ,[Attachment].[No_]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Attachment$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Attachment]
              ON
                     [To-do].[Attachment No_] = [Attachment].[No_]
40Subject SearchSubjectNormalText100Subjectnvarchar(200)
41Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
42Unit Duration (Min.) SearchUnit Duration (Min.)NormalDecimal12Unit Duration (Min_)decimal(38,38)
43No. of Attendees SearchNo. of AttendeesFlowFieldInteger4
44Attendees Accepted No. SearchAttendees Accepted No.FlowFieldInteger4
45System To-do Type SearchSystem Task TypeNormalOption4
46Completed By SearchCompleted ByNormalCode20Completed Bynvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [To-do].[Completed By]
       ,[Salesperson/Purchaser].[Code]
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].[Completed By] = [Salesperson/Purchaser].[Code]
47Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [To-do].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [To-do].[Ending Date] = [Inventory Period].[Ending Date]
48Ending Time SearchEnding TimeNormalTime4Ending Timedatetime
9501Wizard Step SearchWizard StepNormalOption4Wizard Stepint
Available options are:
  • ” “
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
9504Team To-do SearchTeam TaskNormalBoolean4Team To-dotinyint
9505Send on finish SearchSend on finishNormalBoolean4Send on finishtinyint
9506Segment Description SearchSegment DescriptionNormalText100Segment Descriptionnvarchar(200)
9507Team Meeting Organizer SearchTeam Meeting OrganizerNormalCode20Team Meeting Organizernvarchar(40)
9508Activity Code SearchActivity CodeNormalCode10Activity Codenvarchar(20)
Key to join to the Activity table.

Show/hide example query

SELECT
       [To-do].[Activity Code]
       ,[Activity].[Code]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [CRONUS UK Ltd_$Activity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Activity]
              ON
                     [To-do].[Activity Code] = [Activity].[Code]
9509Wizard Contact Name SearchWizard Contact NameNormalText100Wizard Contact Namenvarchar(200)
9510Wizard Campaign Description SearchWizard Campaign DescriptionNormalText100Wizard Campaign Descriptionnvarchar(200)
9511Wizard Opportunity Description SearchWizard Opportunity DescriptionNormalText100Wizard Opportunity 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
       [To-do].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [User] AS [User]
              ON
                     [To-do].[$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
       [To-do].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$To-do$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [To-do]
LEFT JOIN
       [User] AS [User]
              ON
                     [To-do].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from To-do table

Leave a Reply

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