Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1458
Table Type: Company
Table Name: RC Headlines User Data
Database Table Name: CRONUS UK Ltd_$RC Headlines User Data$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 RC Headlines User Data can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$RC Headlines User Data$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[User ID]
,[Role Center Page ID]
,[User workdate]
,[Last Computed]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$RC Headlines User Data$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in RC Headlines User Data table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | User ID  | uniqueidentifier |
| 3 | Role Center Page ID | int |
| 4 | User workdate | datetime |
| 5 | Last Computed | datetime |
| 6 | $systemId | uniqueidentifier |
| 7 | $systemCreatedAt | datetime |
| 8 | $systemCreatedBy | uniqueidentifier |
| 9 | $systemModifiedAt | datetime |
| 10 | $systemModifiedBy | uniqueidentifier |