Data Archive Table

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

Table Type: Company

Table Name: Data Archive Table
Database Table Name: CRONUS UK Ltd_$Data Archive Table$7819d79d-feea-4f09-bbed-5bbaca4bf323

Table Number: 601

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 Data Archive Table can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Archive Table$7819d79d-feea-4f09-bbed-5bbaca4bf323]

Show/hide an example select of all columns by name

SELECT
   [Data Archive Entry No_]
   ,[Table No_]
   ,[Entry No_]
   ,[Table Fields (json)]
   ,[Created On]
   ,[Description]
   ,[Table Data (json)]
   ,[No_ of Records]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Archive Table$7819d79d-feea-4f09-bbed-5bbaca4bf323]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Archive Table$7819d79d-feea-4f09-bbed-5bbaca4bf323] AS [Data Archive Table]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Archive Table].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Archive Table].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Data Archive Table table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Data Archive Entry No. Primary Key SearchData Archive Entry No.NormalInteger4Data Archive Entry No_int
Key to join to the Data Archive table.

Show/hide example query

SELECT
       [Data Archive Table].[Data Archive Entry No_]
       ,[Data Archive].[Entry No_]
FROM
       [CRONUS UK Ltd_$Data Archive Table$7819d79d-feea-4f09-bbed-5bbaca4bf323] AS [Data Archive Table]
LEFT JOIN
       [CRONUS UK Ltd_$Data Archive$7819d79d-feea-4f09-bbed-5bbaca4bf323] AS [Data Archive]
              ON
                     [Data Archive Table].[Data Archive Entry No_] = [Data Archive].[Entry No_]
2Table No. Primary Key SearchTable No.NormalInteger4Table No_int
3Entry No. Primary Key SearchLine No.NormalInteger4Entry No_int
4Table Name SearchTable NameFlowFieldText80
5Table Fields (json) SearchTable Fields (json)NormalMedia16Table Fields (json)uniqueidentifier
6Created On SearchCreated OnNormalDateTime8Created Ondatetime
7Description SearchDescriptionNormalText80Descriptionnvarchar(160)
8Table Data (json) SearchTable Data (json)NormalMedia16Table Data (json)uniqueidentifier
9No. of Records SearchNo. of RecordsNormalInteger4No_ of Recordsint
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
       [Data Archive Table].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Archive Table$7819d79d-feea-4f09-bbed-5bbaca4bf323] AS [Data Archive Table]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Archive Table].[$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
       [Data Archive Table].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Data Archive Table$7819d79d-feea-4f09-bbed-5bbaca4bf323] AS [Data Archive Table]
LEFT JOIN
       [User] AS [User]
              ON
                     [Data Archive Table].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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