Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/7800
Table Type: System
Table Name: MS-Event Emitter Event Codes
Database Table Name:
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 MS-Event Emitter Event Codes 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 [MS-Event Emitter Event Codes]
LEFT JOIN
[User] AS [User]
ON
[MS-Event Emitter Event Codes].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[MS-Event Emitter Event Codes].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in MS-Event Emitter Event Codes table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Event Name  | Event Name | Normal | Text | 250 | ||
| 2 | No of Required Triggers  | No of Required Triggers | Normal | Integer | 4 | ||
| 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 querySELECT [MS-Event Emitter Event Codes].[] ,[User].[User Security ID] FROM [] AS [MS-Event Emitter Event Codes] LEFT JOIN [User] AS [User] ON [MS-Event Emitter Event Codes].[] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | ||
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | ||