COHUB User Task – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables CCOHUB User Task

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

Table Type: System

Table Name: COHUB User Task
Database Table Name:

Table Number: 1154

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

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

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

SELECT
   *
FROM
   [] AS [COHUB User Task]
LEFT JOIN
   [Company] AS [Company]
      ON
         [COHUB User Task].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB User Task].[Assigned To] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB User Task].[Created By] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$User Task Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task Group]
      ON
         [COHUB User Task].[User Task Group Assigned To] = [User Task Group].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB User Task].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB User Task].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in COHUB User Task table

Field No.	Field Name	Field Caption	Class	Type	Length
1	ID	ID	Normal	Integer	4
2	Enviroment No.	Enviroment No.	Normal	Code	20
3	Company Name	Company Name	Normal	Text	50
	Key to join to the Company table. Show/hide example query SELECT [COHUB User Task].[] ,[Company].[Name] FROM [] AS [COHUB User Task] LEFT JOIN [Company] AS [Company] ON [COHUB User Task].[] = [Company].[Name]
4	Assigned To	Assigned To	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [COHUB User Task].[] ,[User].[User Security ID] FROM [] AS [COHUB User Task] LEFT JOIN [User] AS [User] ON [COHUB User Task].[] = [User].[User Security ID]
5	Created By	Created By	Normal	Code	50
	Key to join to the User table. Show/hide example query SELECT [COHUB User Task].[] ,[User].[User Name] FROM [] AS [COHUB User Task] LEFT JOIN [User] AS [User] ON [COHUB User Task].[] = [User].[User Name]
6	Created Date	Created Date	Normal	Date	4
7	Due Date	Due Date	Normal	Date	4
8	Percent Complete	% Complete	Normal	Integer	4
9	Start Date	Start Date	Normal	Date	4
10	Priority	Priority	Normal	Option	4
11	Title	Subject	Normal	Text	250
12	Last Refreshed	Last Refreshed	Normal	DateTime	8
13	Company Display Name	Company Display Name	Normal	Text	50
14	Link	Link	Normal	Text	250
15	User Task Group Assigned To	User Task Group	Normal	Code	20
	Key to join to the User Task Group table. Show/hide example query SELECT [COHUB User Task].[] ,[User Task Group].[Code] FROM [] AS [COHUB User Task] LEFT JOIN [CRONUS UK Ltd_$User Task Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Task Group] ON [COHUB User Task].[] = [User Task Group].[Code]
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [COHUB User Task].[] ,[User].[User Security ID] FROM [] AS [COHUB User Task] LEFT JOIN [User] AS [User] ON [COHUB User Task].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Dynamics 365 BC Table Reference Tables System Tables CCOHUB User Task

Leave a Reply Cancel reply