XBRL Taxonomy Line

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

Table Type: Company

Table Name: XBRL Taxonomy Line
Database Table Name: CRONUS UK Ltd_$XBRL Taxonomy Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 395

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[XBRL Taxonomy Name]
   ,[Line No_]
   ,[Name]
   ,[Level]
   ,[Source Type]
   ,[Constant Amount]
   ,[Description]
   ,[XBRL Item Type]
   ,[Parent Line No_]
   ,[XBRL Schema Line No_]
   ,[Presentation Order]
   ,[Presentation Order No_]
   ,[Element ID]
   ,[Numeric Context Period Type]
   ,[Presentation Linkbase Line No_]
   ,[Type Description Element]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$XBRL Taxonomy Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in XBRL Taxonomy Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2XBRL Taxonomy Name Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Name Searchnvarchar(440)
5Level Searchint
6Source Type Searchint
7Constant Amount Searchdecimal(38,38)
8Description Searchnvarchar(500)
9XBRL Item Type Searchnvarchar(500)
10Parent Line No_ Searchint
11XBRL Schema Line No_ Searchint
12Presentation Order Searchnvarchar(200)
13Presentation Order No_ Searchint
14Element ID Searchnvarchar(440)
15Numeric Context Period Type Searchint
16Presentation Linkbase Line No_ Searchint
17Type Description Element Searchtinyint
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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