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
   [timestamp]
   ,[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 columns in Data Archive Table table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Data Archive Entry No_ Primary Key Searchint
3Table No_ Primary Key Searchint
4Entry No_ Primary Key Searchint
5Table Fields (json) Searchuniqueidentifier
6Created On Searchdatetime
7Description Searchnvarchar(160)
8Table Data (json) Searchuniqueidentifier
9No_ of Records Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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