Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/87
Table Type: Company
Table Name: Date Compr_ Register
Database Table Name: CRONUS UK Ltd_$Date Compr_ Register$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 Date Compr_ Register can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Date Compr_ Register$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[No_]
,[Creation Date]
,[Period Length]
,[Ending Date]
,[No_ of New Records]
,[No_ Records Deleted]
,[User ID]
,[Filter]
,[Starting Date]
,[Table ID]
,[Register No_]
,[Source Code]
,[Retain Field Contents]
,[Retain Totals]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Date Compr_ Register$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Date Compr_ Register table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | No_  | int |
| 3 | Creation Date | datetime |
| 4 | Period Length | int |
| 5 | Ending Date | datetime |
| 6 | No_ of New Records | int |
| 7 | No_ Records Deleted | int |
| 8 | User ID | nvarchar(100) |
| 9 | Filter | nvarchar(500) |
| 10 | Starting Date | datetime |
| 11 | Table ID | int |
| 12 | Register No_ | int |
| 13 | Source Code | nvarchar(20) |
| 14 | Retain Field Contents | nvarchar(160) |
| 15 | Retain Totals | nvarchar(160) |
| 16 | $systemId | uniqueidentifier |
| 17 | $systemCreatedAt | datetime |
| 18 | $systemCreatedBy | uniqueidentifier |
| 19 | $systemModifiedAt | datetime |
| 20 | $systemModifiedBy | uniqueidentifier |