Invalidated 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
   [timestamp]
   ,[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 columns in Invalidated Dim Correction table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Node Id Primary Key Searchint
3Parent Node Id Searchint
4Invalidated Entry No_ Searchint
5Invalidated By Entry No_ Searchint
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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