Dim_ Value per Account

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

Table Type: Company

Table Name: Dim_ Value per Account
Database Table Name: CRONUS UK Ltd_$Dim_ Value per Account$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 356

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 Dim_ Value per Account can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Dim_ Value per Account$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]
   ,[Allowed]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Dim_ Value per Account$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Dim_ Value per Account 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 Primary Key Searchnvarchar(40)
6Allowed Searchtinyint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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