XBRL G/L Map Line

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

Table Type: Company

Table Name: XBRL G/L Map Line
Database Table Name: CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 397

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 XBRL G/L Map Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [XBRL Taxonomy Name]
   ,[XBRL Taxonomy Line No_]
   ,[Line No_]
   ,[G_L Account Filter]
   ,[Business Unit Filter]
   ,[Global Dimension 1 Filter]
   ,[Global Dimension 2 Filter]
   ,[Timeframe Type]
   ,[Amount Type]
   ,[Normal Balance]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL G/L Map Line]
LEFT JOIN
   [CRONUS UK Ltd_$XBRL Taxonomy$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL Taxonomy]
      ON
         [XBRL G/L Map Line].[XBRL Taxonomy Name] = [XBRL Taxonomy].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
      ON
         [XBRL G/L Map Line].[Business Unit Filter] = [Business Unit].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [XBRL G/L Map Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [XBRL G/L Map Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in XBRL G/L Map Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1XBRL Taxonomy Name Primary Key SearchXBRL Taxonomy NameNormalCode20XBRL Taxonomy Namenvarchar(40)
Key to join to the XBRL Taxonomy table.

Show/hide example query

SELECT
       [XBRL G/L Map Line].[XBRL Taxonomy Name]
       ,[XBRL Taxonomy].[Name]
FROM
       [CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL G/L Map Line]
LEFT JOIN
       [CRONUS UK Ltd_$XBRL Taxonomy$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL Taxonomy]
              ON
                     [XBRL G/L Map Line].[XBRL Taxonomy Name] = [XBRL Taxonomy].[Name]
2XBRL Taxonomy Line No. Primary Key SearchXBRL Taxonomy Line No.NormalInteger4XBRL Taxonomy Line No_int
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4G/L Account Filter SearchG/L Account FilterNormalText250G_L Account Filternvarchar(500)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [XBRL G/L Map Line].[G_L Account Filter]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL G/L Map Line]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [XBRL G/L Map Line].[G_L Account Filter] = [G/L Account].[No_]
5Business Unit Filter SearchBusiness Unit FilterNormalText250Business Unit Filternvarchar(500)
Key to join to the Business Unit table.

Show/hide example query

SELECT
       [XBRL G/L Map Line].[Business Unit Filter]
       ,[Business Unit].[Code]
FROM
       [CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL G/L Map Line]
LEFT JOIN
       [CRONUS UK Ltd_$Business Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Business Unit]
              ON
                     [XBRL G/L Map Line].[Business Unit Filter] = [Business Unit].[Code]
6Global Dimension 1 Filter SearchGlobal Dimension 1 FilterNormalText250Global Dimension 1 Filternvarchar(500)
7Global Dimension 2 Filter SearchGlobal Dimension 2 FilterNormalText250Global Dimension 2 Filternvarchar(500)
8Timeframe Type SearchTimeframe TypeNormalOption4Timeframe Typeint
Available options are:
  • “Net Change”
  • “Beginning Balance”
  • “Ending Balance”
9Amount Type SearchAmount TypeNormalOption4Amount Typeint
Available options are:
  • “Net Amount”
  • “Debits Only”
  • “Credits Only”
10Normal Balance SearchNormal BalanceNormalOption4Normal Balanceint
Available options are:
  • “Debit (positive)”
  • “Credit (negative)”
11Label Language Filter SearchLabel Language FilterFlowFilterText10
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
       [XBRL G/L Map Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL G/L Map Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [XBRL G/L Map 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
       [XBRL G/L Map Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$XBRL G_L Map Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [XBRL G/L Map Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [XBRL G/L Map Line].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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