Default Dimension

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

Table Type: Company

Table Name: Default Dimension
Database Table Name: CRONUS UK Ltd_$Default Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Default Dimension can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Default Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Table ID]
   ,[No_]
   ,[Dimension Code]
   ,[Dimension Value Code]
   ,[Value Posting]
   ,[Multi Selection Action]
   ,[Parent Type]
   ,[Allowed Values Filter]
   ,[ParentId]
   ,[DimensionId]
   ,[DimensionValueId]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Default Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Default Dimension table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Table ID Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Dimension Code Primary Key Searchnvarchar(40)
5Dimension Value Code Searchnvarchar(40)
6Value Posting Searchint
7Multi Selection Action Searchint
8Parent Type Searchint
9Allowed Values Filter Searchnvarchar(500)
10ParentId Searchuniqueidentifier
11DimensionId Searchuniqueidentifier
12DimensionValueId Searchuniqueidentifier
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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