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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | No_  | nvarchar(40) | ||||
| 3 | Team Code | nvarchar(20) | ||||
| 4 | Salesperson Code | nvarchar(40) | ||||
Key to join to the Salesperson_Purchaser table.Show/hide example querySELECT
[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_] | ||||||
| 5 | Campaign No_ | nvarchar(40) | ||||
| 6 | Contact No_ | nvarchar(40) | ||||
| 7 | Opportunity No_ | nvarchar(40) | ||||
Key to join to the Opportunity table.Show/hide example querySELECT
[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_] | ||||||
| 8 | Segment No_ | nvarchar(40) | ||||
| 9 | Type | int | ||||
| 10 | Date | datetime | ||||
| 11 | Status | int | ||||
| 12 | Priority | int | ||||
| 13 | Description | nvarchar(200) | ||||
| 14 | Closed | tinyint | ||||
| 15 | Date Closed | datetime | ||||
| 16 | No_ Series | nvarchar(40) | ||||
| 17 | Canceled | tinyint | ||||
| 18 | Contact Company No_ | nvarchar(40) | ||||
| 19 | Recurring | tinyint | ||||
| 20 | Recurring Date Interval | varchar(32) | ||||
| 21 | Calc_ Due Date From | int | ||||
| 22 | Start Time | datetime | ||||
| 23 | Duration | bigint | ||||
| 24 | Opportunity Entry No_ | int | ||||
| 25 | Last Date Modified | datetime | ||||
| 26 | Last Time Modified | datetime | ||||
| 27 | All Day Event | tinyint | ||||
| 28 | Location | nvarchar(200) | ||||
| 29 | Organizer To-do No_ | nvarchar(40) | ||||
| 30 | Interaction Template Code | nvarchar(20) | ||||
| 31 | Language Code | nvarchar(20) | ||||
Key to join to the Language table.Show/hide example querySELECT
[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] | ||||||
| 32 | Attachment No_ | int | ||||
| 33 | Subject | nvarchar(200) | ||||
| 34 | Unit Cost (LCY) | decimal(38,38) | ||||
| 35 | Unit Duration (Min_) | decimal(38,38) | ||||
| 36 | System To-do Type | int | ||||
| 37 | Completed By | nvarchar(40) | ||||
| 38 | Ending Date | datetime | ||||
| 39 | Ending Time | datetime | ||||
| 40 | Wizard Step | int | ||||
| 41 | Team To-do | tinyint | ||||
| 42 | Send on finish | tinyint | ||||
| 43 | Segment Description | nvarchar(200) | ||||
| 44 | Team Meeting Organizer | nvarchar(40) | ||||
| 45 | Activity Code | nvarchar(20) | ||||
| 46 | Wizard Contact Name | nvarchar(200) | ||||
| 47 | Wizard Campaign Description | nvarchar(200) | ||||
| 48 | Wizard Opportunity Description | nvarchar(200) | ||||
| 49 | $systemId | uniqueidentifier | ||||
| 50 | $systemCreatedAt | datetime | ||||
| 51 | $systemCreatedBy | uniqueidentifier | ||||
| 52 | $systemModifiedAt | datetime | ||||
| 53 | $systemModifiedBy | uniqueidentifier | ||||