User Task – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables UUser Task

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

Table Type: Company

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

Table Number: 1170

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 User Task can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[Title]
   ,[Created By]
   ,[Created DateTime]
   ,[Assigned To]
   ,[Completed By]
   ,[Completed DateTime]
   ,[Due DateTime]
   ,[Percent Complete]
   ,[Start DateTime]
   ,[Priority]
   ,[Description]
   ,[Object Type]
   ,[Object ID]
   ,[Parent ID]
   ,[User Task Group Assigned To]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task]
LEFT JOIN
   [User] AS [User]
      ON
         [User Task].[Created By] = [User].[User Name]
LEFT JOIN
   [User] AS [User]
      ON
         [User Task].[Assigned To] = [User].[User Security ID]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [User Task].[Completed By] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction]
      ON
         [User Task].[Parent Id] = [Shpfy Order Transaction].[Shopify Transaction Id]
LEFT JOIN
   [CRONUS UK Ltd_$User Task Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task Group]
      ON
         [User Task].[User Task Group Assigned To] = [User Task Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [User Task].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [User Task].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in User Task table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	Integer	4	ID	int
2	Title	Subject	Normal	Text	250	Title	nvarchar(500)
3	Created By	Created By	Normal	GUID	16	Created By	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [User Task].[Created By] ,[User].[User Name] FROM [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task] LEFT JOIN [User] AS [User] ON [User Task].[Created By] = [User].[User Name]
4	Created DateTime	Created Date	Normal	DateTime	8	Created DateTime	datetime
5	Assigned To	Assigned To	Normal	GUID	16	Assigned To	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [User Task].[Assigned To] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task] LEFT JOIN [User] AS [User] ON [User Task].[Assigned To] = [User].[User Security ID]
7	Completed By	Completed By	Normal	GUID	16	Completed By	uniqueidentifier
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [User Task].[Completed By] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [User Task].[Completed By] = [Salesperson/Purchaser].[Code]
8	Completed DateTime	Completed Date	Normal	DateTime	8	Completed DateTime	datetime
9	Due DateTime	Due Date	Normal	DateTime	8	Due DateTime	datetime
10	Percent Complete	% Complete	Normal	Integer	4	Percent Complete	int
11	Start DateTime	Start Date	Normal	DateTime	8	Start DateTime	datetime
12	Priority	Priority	Normal	Option	4	Priority	int
	Available options are: “” “Low” “Normal” “High”
13	Description	Description	Normal	BLOB	8	Description	image
14	Created By User Name	User Created By	FlowField	Code	50
15	Assigned To User Name	User Assigned To	FlowField	Code	50
16	Completed By User Name	User Completed By	FlowField	Code	50
17	Object Type	Link Task To	Normal	Option	4	Object Type	int
	Available options are: “” “Report” “Page”
18	Object ID	Object ID	Normal	Integer	4	Object ID	int
19	Parent ID	Parent ID	Normal	Integer	4	Parent ID	int
	Key to join to the Shpfy Order Transaction table. Show/hide example query SELECT [User Task].[Parent ID] ,[Shpfy Order Transaction].[Shopify Transaction Id] FROM [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task] LEFT JOIN [CRONUS UK Ltd_$Shpfy Order Transaction$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Order Transaction] ON [User Task].[Parent ID] = [Shpfy Order Transaction].[Shopify Transaction Id]
20	User Task Group Assigned To	User Task Group Assigned To	Normal	Code	20	User Task Group Assigned To	nvarchar(40)
	Key to join to the User Task Group table. Show/hide example query SELECT [User Task].[User Task Group Assigned To] ,[User Task Group].[Code] FROM [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task] LEFT JOIN [CRONUS UK Ltd_$User Task Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task Group] ON [User Task].[User Task Group Assigned To] = [User Task Group].[Code]
21	ShouldShowPendingTasks	ShouldShowPendingTasks	FlowFilter	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [User Task].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task] LEFT JOIN [User] AS [User] ON [User Task].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [User Task].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$User Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task] LEFT JOIN [User] AS [User] ON [User Task].[$systemModifiedBy] = [User].[User Security ID]

Dynamics 365 BC Table Reference Tables Company Tables UUser Task

Leave a Reply Cancel reply