Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2582
Table Type: Company
Table Name: Dimension Correction
Database Table Name: CRONUS UK Ltd_$Dimension Correction$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 Dimension Correction can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Dimension Correction$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Entry No_]
,[Status]
,[Description]
,[Generated Set IDs]
,[Total Updated Ledger Entries]
,[Total Selected Ledger Entries]
,[Undo Last Ledger Entry No_]
,[Error Message]
,[Completed]
,[Last Job Queue Entry ID]
,[Generated Selected Entries]
,[Validated Selected Entries]
,[Last Updated Entry No_]
,[Last Validated Entry No_]
,[Started Correction]
,[Validation Errors Register ID]
,[Validated At]
,[Validation Message]
,[Update Analysis Views]
,[Update Analysis Views Status]
,[Update Analysis Views Error]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Dimension Correction$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide columns in Dimension Correction table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Entry No_  | int |
| 3 | Status | int |
| 4 | Description | nvarchar(500) |
| 5 | Generated Set IDs | tinyint |
| 6 | Total Updated Ledger Entries | int |
| 7 | Total Selected Ledger Entries | int |
| 8 | Undo Last Ledger Entry No_ | int |
| 9 | Error Message | nvarchar(4096) |
| 10 | Completed | tinyint |
| 11 | Last Job Queue Entry ID | uniqueidentifier |
| 12 | Generated Selected Entries | tinyint |
| 13 | Validated Selected Entries | tinyint |
| 14 | Last Updated Entry No_ | int |
| 15 | Last Validated Entry No_ | int |
| 16 | Started Correction | tinyint |
| 17 | Validation Errors Register ID | uniqueidentifier |
| 18 | Validated At | datetime |
| 19 | Validation Message | image |
| 20 | Update Analysis Views | tinyint |
| 21 | Update Analysis Views Status | int |
| 22 | Update Analysis Views Error | image |
| 23 | $systemId | uniqueidentifier |
| 24 | $systemCreatedAt | datetime |
| 25 | $systemCreatedBy | uniqueidentifier |
| 26 | $systemModifiedAt | datetime |
| 27 | $systemModifiedBy | uniqueidentifier |