G/L Account Mapping Line

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

Table Type: Company

Table Name: G/L Account Mapping Line
Database Table Name: CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada

Table Number: 5261

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 Mapping Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]

Show/hide an example select of all columns by name

SELECT
   [G_L Account Mapping Code]
   ,[G_L Account No_]
   ,[Standard Account Type]
   ,[Standard Account Category No_]
   ,[Standard Account No_]
   ,[G_L Entries Exists]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Mapping Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Account Mapping Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Account Mapping Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1G/L Account Mapping Code Primary Key SearchG/L Account Mapping CodeNormalCode20G_L Account Mapping Codenvarchar(40)
Key to join to the G/L Account Mapping Header table.

Show/hide example query

SELECT
       [G/L Account Mapping Line].[G_L Account Mapping Code]
       ,[G/L Account Mapping Header].[Code]
FROM
       [CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account Mapping Header$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Header]
              ON
                     [G/L Account Mapping Line].[G_L Account Mapping Code] = [G/L Account Mapping Header].[Code]
2G/L Account No. Primary Key SearchG/L Account No.NormalCode20G_L Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [G/L Account Mapping Line].[G_L Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [G/L Account Mapping Line].[G_L Account No_] = [G/L Account].[No_]
3Standard Account Type SearchStandard Account TypeNormalOption4Standard Account Typeint
Available options are:
  • “None”
4Standard Account Category No. SearchStandard Account Category No.NormalCode20Standard Account Category No_nvarchar(40)
5Standard Account No. SearchStandard Account No.NormalCode20Standard Account No_nvarchar(40)
6G/L Entries Exists SearchG/L Entries ExistsNormalBoolean4G_L Entries Existstinyint
50G/L Account Name SearchG/L Account NameFlowFieldText100
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [G/L Account Mapping Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Account Mapping Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [G/L Account Mapping Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Account Mapping Line$a41b0c3e-bf1c-4c97-ad1b-b430a3933ada] AS [G/L Account Mapping Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Account Mapping Line].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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