Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5152
Table Type: Company
Table Name: Integration Record Archive
Database Table Name: CRONUS UK Ltd_$Integration Record 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 Integration Record Archive can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Integration Record Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Integration ID]
,[Table ID]
,[Page ID]
,[Record ID]
,[Webhook Notification]
,[Deleted On]
,[Modified On]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Integration Record Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Integration Record Archive table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Integration ID  | uniqueidentifier |
| 3 | Table ID | int |
| 4 | Page ID | int |
| 5 | Record ID | varbinary(448) |
| 6 | Webhook Notification | image |
| 7 | Deleted On | datetime |
| 8 | Modified On | datetime |
| 9 | $systemId | uniqueidentifier |
| 10 | $systemCreatedAt | datetime |
| 11 | $systemCreatedBy | uniqueidentifier |
| 12 | $systemModifiedAt | datetime |
| 13 | $systemModifiedBy | uniqueidentifier |