Dimension Correction – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables DDimension Correction

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

Table Number: 2582

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

   [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]
   ,[Analysis View Update Type]
   ,[Update Analysis View Job ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Dimension Correction$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Dimension Correction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Correction]
LEFT JOIN
   [User] AS [User]
      ON
         [Dimension Correction].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Dimension Correction].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Dimension Correction table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Status	Status	Normal	Option	4	Status	int
	Available options are: “Draft” “In Process” “Validaton in Process” “Failed” “Completed” “Undo in Process” “Undo Completed”
3	Description	Description	Normal	Text	250	Description	nvarchar(500)
6	Generated Set IDs	Generated Set IDs	Normal	Boolean	4	Generated Set IDs	tinyint
7	Total Updated Ledger Entries	Total Updated Ledger Entries	Normal	Integer	4	Total Updated Ledger Entries	int
8	Invalidated	Invalidated	FlowField	Boolean	4
9	Total Selected Ledger Entries	Total Selected Ledger Entries	Normal	Integer	4	Total Selected Ledger Entries	int
10	Undo Last Ledger Entry No.	Undo Last Ledger Entry No.	Normal	Integer	4	Undo Last Ledger Entry No_	int
11	Error Message	Error Message	Normal	Text	2048	Error Message	nvarchar(4096)
12	Completed	Ran Once	Normal	Boolean	4	Completed	tinyint
13	Last Job Queue Entry ID	Job Queue Entry ID	Normal	GUID	16	Last Job Queue Entry ID	uniqueidentifier
14	Generated Selected Entries	Generated Selected Entries	Normal	Boolean	4	Generated Selected Entries	tinyint
15	Validated Selected Entries	Validated Selected Entries	Normal	Boolean	4	Validated Selected Entries	tinyint
16	Last Updated Entry No.	Last Updated Entry No.	Normal	Integer	4	Last Updated Entry No_	int
17	Last Validated Entry No.	Last Validated Entry No.	Normal	Integer	4	Last Validated Entry No_	int
18	Started Correction	Started Correction	Normal	Boolean	4	Started Correction	tinyint
19	Validation Errors Register ID	Validation Errors Register ID	Normal	GUID	16	Validation Errors Register ID	uniqueidentifier
20	Validated At	Validated At	Normal	DateTime	8	Validated At	datetime
21	Validation Message	Validation Message	Normal	BLOB	8	Validation Message	image
30	Update Analysis Views	Update Analysis Views	Normal	Boolean	4	Update Analysis Views	tinyint
31	Update Analysis Views Status	Update Analysis Views Status	Normal	Option	4	Update Analysis Views Status	int
	Available options are: “Not Started” “In Process” “Failed” “Completed”
32	Update Analysis Views Error	Update Analysis Views Error	Normal	BLOB	8	Update Analysis Views Error	image
33	Analysis View Update Type	Analysis View Update Type	Normal	Option	4	Analysis View Update Type	int
	Available options are: “Update on posting only” “All”
34	Update Analysis View Job ID	Update Analysis View Job ID	Normal	GUID	16	Update Analysis View Job ID	uniqueidentifier
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Dimension Correction].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Dimension Correction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Correction] LEFT JOIN [User] AS [User] ON [Dimension Correction].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Dimension Correction].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Dimension Correction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Correction] LEFT JOIN [User] AS [User] ON [Dimension Correction].[$systemModifiedBy] = [User].[User Security ID]