COHUB Enviroment

Dynamics 365 BC Table ReferenceTablesSystem TablesCCOHUB 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20
2Name Primary Key SearchNameNormalText100
5Privacy Blocked SearchPrivacy BlockedNormalBoolean4
6Link SearchLinkNormalText2048
7Group Code SearchGroup CodeNormalCode20
20Address SearchAddressNormalText100
21Address 2 SearchAddress 2NormalText50
22Country/Region Code SearchCountry/Region CodeNormalCode10
23City SearchCityNormalText30
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [COHUB Enviroment].[]
	       ,[Post Code].[City]
	FROM
	       [] AS [COHUB Enviroment]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [COHUB Enviroment].[] = [Post Code].[City]
24County SearchStateNormalText30
25Post Code SearchZIP CodeNormalCode20
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [COHUB Enviroment].[]
	       ,[Post Code].[Code]
	FROM
	       [] AS [COHUB Enviroment]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [COHUB Enviroment].[] = [Post Code].[Code]
40Contact Name SearchContact NameNormalText100
41Contact Phone No. SearchPhone No.NormalText30
42Contact E-Mail SearchEmailNormalText80
103Home Page SearchHome PageNormalText80
104Include Demo Companies SearchInclude Demo CompaniesNormalBoolean4
2000000000$systemId SearchSystem IDNormalGUID16
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8
2000000002SystemCreatedBy SearchCreated ByNormalGUID16
Key to join to the User table.

Show/hide example query

SELECT
	       [COHUB Enviroment].[]
	       ,[User].[User Security ID]
	FROM
	       [] AS [COHUB Enviroment]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [COHUB Enviroment].[] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8
2000000004SystemModifiedBy SearchModified ByNormalGUID16

Show/hide tables related from COHUB Enviroment table

Post Code
Dynamics 365 BC Table ReferenceTablesSystem TablesCCOHUB Enviroment

Leave a Reply

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