Dimension 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
   [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 IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Status Searchint
4Description Searchnvarchar(500)
5Generated Set IDs Searchtinyint
6Total Updated Ledger Entries Searchint
7Total Selected Ledger Entries Searchint
8Undo Last Ledger Entry No_ Searchint
9Error Message Searchnvarchar(4096)
10Completed Searchtinyint
11Last Job Queue Entry ID Searchuniqueidentifier
12Generated Selected Entries Searchtinyint
13Validated Selected Entries Searchtinyint
14Last Updated Entry No_ Searchint
15Last Validated Entry No_ Searchint
16Started Correction Searchtinyint
17Validation Errors Register ID Searchuniqueidentifier
18Validated At Searchdatetime
19Validation Message Searchimage
20Update Analysis Views Searchtinyint
21Update Analysis Views Status Searchint
22Update Analysis Views Error Searchimage
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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