Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5311
Table Type: Company
Table Name: Outlook Synch. Dependency
Database Table Name: CRONUS UK Ltd_$Outlook Synch_ Dependency$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 Outlook Synch. Dependency can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Outlook Synch_ Dependency$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Synch_ Entity Code]
,[Element No_]
,[Depend_ Synch_ Entity Code]
,[Condition]
,[Table Relation]
,[Record GUID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Outlook Synch_ Dependency$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Outlook Synch_ Dependency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Outlook Synch. Dependency]
LEFT JOIN
[User] AS [User]
ON
[Outlook Synch. Dependency].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Outlook Synch. Dependency].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Outlook Synch. Dependency table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Synch. Entity Code  | Synch. Entity Code | Normal | Code | 10 | Synch_ Entity Code | nvarchar(20) |
| 2 | Element No.  | Element No. | Normal | Integer | 4 | Element No_ | int |
| 3 | Depend. Synch. Entity Code | Depend. Synch. Entity Code | Normal | Code | 10 | Depend_ Synch_ Entity Code | nvarchar(20) |
| 4 | Description | Description | FlowField | Text | 80 | ||
| 5 | Condition | Condition | Normal | Text | 250 | Condition | nvarchar(500) |
| 6 | Table Relation | Table Relation | Normal | Text | 250 | Table Relation | nvarchar(500) |
| 7 | Record GUID | Record GUID | Normal | GUID | 16 | Record GUID | uniqueidentifier |
| 8 | Depend. Synch. Entity Tab. No. | Depend. Synch. Entity Tab. No. | FlowField | Integer | 4 | ||
| 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 [Outlook Synch. Dependency].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Outlook Synch_ Dependency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Outlook Synch. Dependency] LEFT JOIN [User] AS [User] ON [Outlook Synch. Dependency].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |