COHUB Enviroment – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables CCOHUB Enviroment

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

Table Type: System

Table Name: COHUB Enviroment
Database Table Name:

Table Number: 1152

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 Enviroment 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 Enviroment]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [COHUB Enviroment].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [COHUB Enviroment].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Enviroment].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Enviroment].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in COHUB Enviroment table

Field No.	Field Name	Field Caption	Class	Type	Length
1	No.	No.	Normal	Code	20
2	Name	Name	Normal	Text	100
5	Privacy Blocked	Privacy Blocked	Normal	Boolean	4
6	Link	Link	Normal	Text	2048
7	Group Code	Group Code	Normal	Code	20
20	Address	Address	Normal	Text	100
21	Address 2	Address 2	Normal	Text	50
22	Country/Region Code	Country/Region Code	Normal	Code	10
23	City	City	Normal	Text	30
24	County	State	Normal	Text	30
25	Post Code	ZIP Code	Normal	Code	20
40	Contact Name	Contact Name	Normal	Text	100
41	Contact Phone No.	Phone No.	Normal	Text	30
42	Contact E-Mail	Email	Normal	Text	80
103	Home Page	Home Page	Normal	Text	80
104	Include Demo Companies	Include Demo Companies	Normal	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16