Column Layout

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

Table Type: Company

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

Table Number: 334

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 Column Layout can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Column Layout Name]
   ,[Line No_]
   ,[Column No_]
   ,[Column Header]
   ,[Column Type]
   ,[Ledger Entry Type]
   ,[Amount Type]
   ,[Formula]
   ,[Comparison Date Formula]
   ,[Show Opposite Sign]
   ,[Show]
   ,[Rounding Factor]
   ,[Show Indented Lines]
   ,[Comparison Period Formula]
   ,[Business Unit Totaling]
   ,[Dimension 1 Totaling]
   ,[Dimension 2 Totaling]
   ,[Dimension 3 Totaling]
   ,[Dimension 4 Totaling]
   ,[Cost Center Totaling]
   ,[Cost Object Totaling]
   ,[Comparison Period Formula LCID]
   ,[Budget Name]
   ,[Hide Currency Symbol]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Column Layout$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Column Layout$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Column Layout]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
      ON
         [Column Layout].[Budget Name] = [G_L Budget Name].[Budget Name]

Show/hide columns in Column Layout table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Column Layout Name Primary Key Searchnvarchar(20)
3Line No_ Primary Key Searchint
4Column No_ Searchnvarchar(20)
5Column Header Searchnvarchar(60)
6Column Type Searchint
7Ledger Entry Type Searchint
8Amount Type Searchint
9Formula Searchnvarchar(160)
10Comparison Date Formula Searchvarchar(32)
11Show Opposite Sign Searchtinyint
12Show Searchint
13Rounding Factor Searchint
14Show Indented Lines Searchint
15Comparison Period Formula Searchnvarchar(40)
16Business Unit Totaling Searchnvarchar(160)
17Dimension 1 Totaling Searchnvarchar(160)
18Dimension 2 Totaling Searchnvarchar(160)
19Dimension 3 Totaling Searchnvarchar(160)
20Dimension 4 Totaling Searchnvarchar(160)
21Cost Center Totaling Searchnvarchar(160)
22Cost Object Totaling Searchnvarchar(160)
23Comparison Period Formula LCID Searchint
24Budget Name Searchnvarchar(20)
Key to join to the G_L Budget Name table.

Show/hide example query

SELECT
       [Column Layout].[Budget Name]
       ,[G_L Budget Name].[Budget Name]
FROM
       [CRONUS UK Ltd_$Column Layout$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Column Layout]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Budget Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Budget Name]
              ON
                     [Column Layout].[Budget Name] = [G_L Budget Name].[Budget Name]
25Hide Currency Symbol Searchtinyint
26$systemId Searchuniqueidentifier
27$systemCreatedAt Searchdatetime
28$systemCreatedBy Searchuniqueidentifier
29$systemModifiedAt Searchdatetime
30$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Column Layout table

Leave a Reply

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