Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5452
Table Type: Company
Table Name: Graph Integration Rec. Archive
Database Table Name: CRONUS UK Ltd_$Graph Integration Rec_ Archive$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 Graph Integration Rec. Archive can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Graph Integration Rec_ Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Graph ID]
,[Integration ID]
,[Last Synch_ Modified On]
,[Last Synch_ Graph Modified On]
,[ChangeKey]
,[Webhook Notification]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Graph Integration Rec_ Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Graph Integration Rec_ Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Graph Integration Rec. Archive]
LEFT JOIN
[CRONUS UK Ltd_$Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Record]
ON
[Graph Integration Rec. Archive].[Integration ID] = [Integration Record].[Integration ID]
LEFT JOIN
[CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
ON
[Graph Integration Rec. Archive].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
[User] AS [User]
ON
[Graph Integration Rec. Archive].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Graph Integration Rec. Archive].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Graph Integration Rec. Archive table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 2 | Graph ID   | Graph ID | Normal | Text | 250 | Graph ID | nvarchar(500) |
| 3 | Integration ID | Integration ID | Normal | GUID | 16 | Integration ID | uniqueidentifier |
Key to join to the Integration Record table.Show/hide example querySELECT
[Graph Integration Rec. Archive].[Integration ID]
,[Integration Record].[Integration ID]
FROM
[CRONUS UK Ltd_$Graph Integration Rec_ Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Graph Integration Rec. Archive]
LEFT JOIN
[CRONUS UK Ltd_$Integration Record$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Integration Record]
ON
[Graph Integration Rec. Archive].[Integration ID] = [Integration Record].[Integration ID] | |||||||
| 4 | Last Synch. Modified On | Last Synch. Modified On | Normal | DateTime | 8 | Last Synch_ Modified On | datetime |
| 5 | Last Synch. Graph Modified On | Last Synch. Graph Modified On | Normal | DateTime | 8 | Last Synch_ Graph Modified On | datetime |
| 6 | Table ID | Table ID | FlowField | Integer | 4 | ||
| 7 | ChangeKey | ChangeKey | Normal | Text | 250 | ChangeKey | nvarchar(500) |
| 194 | Webhook Notification | Webhook Notification | Normal | BLOB | 8 | Webhook Notification | image |
| 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
[Graph Integration Rec. Archive].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Graph Integration Rec_ Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Graph Integration Rec. Archive]
LEFT JOIN
[User] AS [User]
ON
[Graph Integration Rec. Archive].[$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
[Graph Integration Rec. Archive].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Graph Integration Rec_ Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Graph Integration Rec. Archive]
LEFT JOIN
[User] AS [User]
ON
[Graph Integration Rec. Archive].[$systemModifiedBy] = [User].[User Security ID] | |||||||