Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/9170
Table Type: Company
Table Name: Profile Resource Import_Export
Database Table Name: CRONUS UK Ltd_$Profile Resource Import_Export$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 Profile Resource Import_Export can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Profile Resource Import_Export$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Profile ID]
,[Page ID]
,[Personalization ID]
,[Control GUID]
,[Abbreviated Language Name]
,[Value]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Profile Resource Import_Export$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Profile Resource Import_Export table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Profile ID  | nvarchar(60) |
| 3 | Page ID | int |
| 4 | Personalization ID | nvarchar(80) |
| 5 | Control GUID | nvarchar(80) |
| 6 | Abbreviated Language Name | nvarchar(6) |
| 7 | Value | nvarchar(500) |
| 8 | $systemId | uniqueidentifier |
| 9 | $systemCreatedAt | datetime |
| 10 | $systemCreatedBy | uniqueidentifier |
| 11 | $systemModifiedAt | datetime |
| 12 | $systemModifiedBy | uniqueidentifier |