G_L Account Where-Used

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

Table Type: Company

Table Name: G_L Account Where-Used
Database Table Name: CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 180

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 G_L Account Where-Used can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Table ID]
   ,[Table Name]
   ,[Field Name]
   ,[Line]
   ,[G_L Account No_]
   ,[G_L Account Name]
   ,[Key 1]
   ,[Key 2]
   ,[Key 3]
   ,[Key 4]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account Where-Used]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
      ON
         [G_L Account Where-Used].[G_L Account No_] = [G_L Account].[No_]

Show/hide columns in G_L Account Where-Used table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Table ID Searchint
4Table Name Searchnvarchar(300)
5Field Name Searchnvarchar(300)
6Line Searchnvarchar(500)
7G_L Account No_ Searchnvarchar(40)
Key to join to the G_L Account table.

Show/hide example query

SELECT
       [G_L Account Where-Used].[G_L Account No_]
       ,[G_L Account].[No_]
FROM
       [CRONUS UK Ltd_$G_L Account Where-Used$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account Where-Used]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G_L Account]
              ON
                     [G_L Account Where-Used].[G_L Account No_] = [G_L Account].[No_]
8G_L Account Name Searchnvarchar(200)
9Key 1 Searchnvarchar(100)
10Key 2 Searchnvarchar(100)
11Key 3 Searchnvarchar(100)
12Key 4 Searchnvarchar(100)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from G_L Account Where-Used table

Leave a Reply

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