Dimension Correction

Dynamics 365 BC Table ReferenceTablesCompany TablesDDimension 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Status Primary Key SearchStatusNormalOption4Statusint
Available options are:
  • “Draft”
  • “In Process”
  • “Validaton in Process”
  • “Failed”
  • “Completed”
  • “Undo in Process”
  • “Undo Completed”
3Description SearchDescriptionNormalText250Descriptionnvarchar(500)
6Generated Set IDs SearchGenerated Set IDsNormalBoolean4Generated Set IDstinyint
7Total Updated Ledger Entries SearchTotal Updated Ledger EntriesNormalInteger4Total Updated Ledger Entriesint
8Invalidated SearchInvalidatedFlowFieldBoolean4
9Total Selected Ledger Entries SearchTotal Selected Ledger EntriesNormalInteger4Total Selected Ledger Entriesint
10Undo Last Ledger Entry No. SearchUndo Last Ledger Entry No.NormalInteger4Undo Last Ledger Entry No_int
11Error Message SearchError MessageNormalText2048Error Messagenvarchar(4096)
12Completed SearchRan OnceNormalBoolean4Completedtinyint
13Last Job Queue Entry ID SearchJob Queue Entry IDNormalGUID16Last Job Queue Entry IDuniqueidentifier
14Generated Selected Entries SearchGenerated Selected EntriesNormalBoolean4Generated Selected Entriestinyint
15Validated Selected Entries SearchValidated Selected EntriesNormalBoolean4Validated Selected Entriestinyint
16Last Updated Entry No. SearchLast Updated Entry No.NormalInteger4Last Updated Entry No_int
17Last Validated Entry No. SearchLast Validated Entry No.NormalInteger4Last Validated Entry No_int
18Started Correction SearchStarted CorrectionNormalBoolean4Started Correctiontinyint
19Validation Errors Register ID SearchValidation Errors Register IDNormalGUID16Validation Errors Register IDuniqueidentifier
20Validated At SearchValidated AtNormalDateTime8Validated Atdatetime
21Validation Message SearchValidation MessageNormalBLOB8Validation Messageimage
30Update Analysis Views SearchUpdate Analysis ViewsNormalBoolean4Update Analysis Viewstinyint
31Update Analysis Views Status SearchUpdate Analysis Views StatusNormalOption4Update Analysis Views Statusint
Available options are:
  • “Not Started”
  • “In Process”
  • “Failed”
  • “Completed”
32Update Analysis Views Error SearchUpdate Analysis Views ErrorNormalBLOB8Update Analysis Views Errorimage
33Analysis View Update Type SearchAnalysis View Update TypeNormalOption4Analysis View Update Typeint
Available options are:
  • “Update on posting only”
  • “All”
34Update Analysis View Job ID SearchUpdate Analysis View Job IDNormalGUID16Update Analysis View Job IDuniqueidentifier
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesDDimension Correction

Leave a Reply

Your email address will not be published. Required fields are marked *