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
[timestamp]
,[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 columns in Graph Integration Rec_ Archive table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Graph ID  | nvarchar(500) |
| 3 | Integration ID | uniqueidentifier |
| 4 | Last Synch_ Modified On | datetime |
| 5 | Last Synch_ Graph Modified On | datetime |
| 6 | ChangeKey | nvarchar(500) |
| 7 | Webhook Notification | image |
| 8 | $systemId | uniqueidentifier |
| 9 | $systemCreatedAt | datetime |
| 10 | $systemCreatedBy | uniqueidentifier |
| 11 | $systemModifiedAt | datetime |
| 12 | $systemModifiedBy | uniqueidentifier |