G_L Register

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

Table Type: Company

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[From Entry No_]
   ,[To Entry No_]
   ,[Creation Date]
   ,[Source Code]
   ,[User ID]
   ,[Journal Batch Name]
   ,[From VAT Entry No_]
   ,[To VAT Entry No_]
   ,[Reversed]
   ,[Creation Time]
   ,[Journal Templ_ Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in G_L Register table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3From Entry No_ Searchint
4To Entry No_ Searchint
5Creation Date Searchdatetime
6Source Code Searchnvarchar(20)
7User ID Searchnvarchar(100)
8Journal Batch Name Searchnvarchar(20)
9From VAT Entry No_ Searchint
10To VAT Entry No_ Searchint
11Reversed Searchtinyint
12Creation Time Searchdatetime
13Journal Templ_ Name Searchnvarchar(20)
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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