COHUB 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

Show/hide an example select of all columns by name

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

Show/hide columns in COHUB User Task table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID SearchIDNormalInteger4
2Enviroment No. Primary Key SearchEnviroment No.NormalCode20
3Company Name Primary Key SearchCompany NameNormalText50
Key to join to the Company table.

Show/hide example query

4Assigned To Primary Key SearchAssigned ToNormalGUID16
Key to join to the User table.

Show/hide example query

5Created By SearchCreated ByNormalCode50
Key to join to the User table.

Show/hide example query

6Created Date SearchCreated DateNormalDate4
7Due Date SearchDue DateNormalDate4
8Percent Complete Search% CompleteNormalInteger4
9Start Date SearchStart DateNormalDate4
10Priority SearchPriorityNormalOption4
11Title SearchSubjectNormalText250
12Last Refreshed SearchLast RefreshedNormalDateTime8
13Company Display Name SearchCompany Display NameNormalText50
14Link SearchLinkNormalText250
15User Task Group Assigned To SearchUser Task GroupNormalCode20
Key to join to the User Task Group table.

Show/hide example query

2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16

Leave a Reply

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