Dimension Value

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

Table Type: Company

Table Name: Dimension Value
Database Table Name: CRONUS UK Ltd_$Dimension Value$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 Dimension Value can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Dimension Code]
   ,[Code]
   ,[Name]
   ,[Dimension Value Type]
   ,[Totaling]
   ,[Blocked]
   ,[Consolidation Code]
   ,[Indentation]
   ,[Global Dimension No_]
   ,[Map-to IC Dimension Code]
   ,[Map-to IC Dimension Value Code]
   ,[Dimension Value ID]
   ,[Id]
   ,[Last Modified Date Time]
   ,[Dimension Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Dimension Value$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Dimension Value table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Dimension Code Primary Key Searchnvarchar(40)
3Code Primary Key Searchnvarchar(40)
4Name Searchnvarchar(100)
5Dimension Value Type Searchint
6Totaling Searchnvarchar(500)
7Blocked Searchtinyint
8Consolidation Code Searchnvarchar(40)
9Indentation Searchint
10Global Dimension No_ Searchint
11Map-to IC Dimension Code Searchnvarchar(40)
12Map-to IC Dimension Value Code Searchnvarchar(40)
13Dimension Value ID Searchint
14Id Searchuniqueidentifier
15Last Modified Date Time Searchdatetime
16Dimension Id Searchuniqueidentifier
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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