Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5056
Table Type: Company
Table Name: Contact Mailing Group
Database Table Name: CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Contact Mailing Group can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Contact No_]
,[Mailing Group Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Mailing Group]
LEFT JOIN
[CRONUS UK Ltd_$Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mailing Group]
ON
[Contact Mailing Group].[Mailing Group Code] = [Mailing Group].[Code]
LEFT JOIN
[User] AS [User]
ON
[Contact Mailing Group].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Contact Mailing Group].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Contact Mailing Group table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Contact No.   | Contact No. | Normal | Code | 20 | Contact No_ | nvarchar(40) |
Key to join to the Contact table.Show/hide example querySELECT
[Contact Mailing Group].[Contact No_]
,[Contact].[No_]
FROM
[CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Mailing Group]
LEFT JOIN
[CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
ON
[Contact Mailing Group].[Contact No_] = [Contact].[No_] | |||||||
| 2 | Mailing Group Code | Mailing Group Code | Normal | Code | 10 | Mailing Group Code | nvarchar(20) |
Key to join to the Mailing Group table.Show/hide example querySELECT
[Contact Mailing Group].[Mailing Group Code]
,[Mailing Group].[Code]
FROM
[CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Mailing Group]
LEFT JOIN
[CRONUS UK Ltd_$Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mailing Group]
ON
[Contact Mailing Group].[Mailing Group Code] = [Mailing Group].[Code] | |||||||
| 3 | Contact Name | Contact Name | FlowField | Text | 100 | ||
| 4 | Contact Company Name | Contact Company Name | FlowField | Text | 100 | ||
| 5 | Mailing Group Description | Mailing Group Description | FlowField | Text | 100 | ||
| 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 querySELECT
[Contact Mailing Group].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Mailing Group]
LEFT JOIN
[User] AS [User]
ON
[Contact Mailing Group].[$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 querySELECT
[Contact Mailing Group].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Contact Mailing Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact Mailing Group]
LEFT JOIN
[User] AS [User]
ON
[Contact Mailing Group].[$systemModifiedBy] = [User].[User Security ID] | |||||||