XBRL Linkbase

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

Table Type: Company

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

Table Number: 400

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[XBRL Taxonomy Name]
   ,[XBRL Schema Line No_]
   ,[Line No_]
   ,[Description]
   ,[Type]
   ,[XML]
   ,[File Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$XBRL Linkbase$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in XBRL Linkbase table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2XBRL Taxonomy Name Primary Key Searchnvarchar(40)
3XBRL Schema Line No_ Primary Key Searchint
4Line No_ Primary Key Searchint
5Description Searchnvarchar(200)
6Type Searchint
7XML Searchimage
8File Name Searchnvarchar(500)
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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