Invalidated Dim Correction – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInvalidated Dim Correction

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2587

Table Type: Company

Table Name: Invalidated Dim Correction
Database Table Name: CRONUS UK Ltd_$Invalidated Dim Correction$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 2587

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 Invalidated Dim Correction can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Node Id]
   ,[Parent Node Id]
   ,[Invalidated Entry No_]
   ,[Invalidated By Entry No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Invalidated Dim 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_$Invalidated Dim Correction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invalidated Dim Correction]
LEFT JOIN
   [User] AS [User]
      ON
         [Invalidated Dim Correction].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Invalidated Dim Correction].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Invalidated Dim Correction table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Node Id	Node Id	Normal	Integer	4	Node Id	int
2	Parent Node Id	Parent Node Id	Normal	Integer	4	Parent Node Id	int
3	Invalidated Entry No.	Invalidated Entry No.	Normal	Integer	4	Invalidated Entry No_	int
4	Invalidated By Entry No.	Invalidated By Entry No.	Normal	Integer	4	Invalidated By Entry No_	int
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 [Invalidated Dim Correction].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Invalidated Dim Correction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invalidated Dim Correction] LEFT JOIN [User] AS [User] ON [Invalidated Dim 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 [Invalidated Dim Correction].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Invalidated Dim Correction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invalidated Dim Correction] LEFT JOIN [User] AS [User] ON [Invalidated Dim Correction].[$systemModifiedBy] = [User].[User Security ID]