Change Global Dim_ Header

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

Table Type: Company

Table Name: Change Global Dim_ Header
Database Table Name: CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 484

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 Change Global Dim_ Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Old Global Dimension 1 Code]
   ,[Old Global Dimension 2 Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Parallel Processing]
   ,[Change Type 1]
   ,[Change Type 2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Change Global Dim_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Change Global Dim_ Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Old Global Dimension 1 Code Searchnvarchar(40)
4Old Global Dimension 2 Code Searchnvarchar(40)
5Global Dimension 1 Code Searchnvarchar(40)
6Global Dimension 2 Code Searchnvarchar(40)
7Parallel Processing Searchtinyint
8Change Type 1 Searchint
9Change Type 2 Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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