Date Compr_ Register

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

Table Type: Company

Table Name: Date Compr_ Register
Database Table Name: CRONUS UK Ltd_$Date Compr_ Register$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 87

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 Date Compr_ Register can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Date Compr_ Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Creation Date]
   ,[Period Length]
   ,[Ending Date]
   ,[No_ of New Records]
   ,[No_ Records Deleted]
   ,[User ID]
   ,[Filter]
   ,[Starting Date]
   ,[Table ID]
   ,[Register No_]
   ,[Source Code]
   ,[Retain Field Contents]
   ,[Retain Totals]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Date Compr_ Register$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Date Compr_ Register table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Creation Date Searchdatetime
4Period Length Searchint
5Ending Date Searchdatetime
6No_ of New Records Searchint
7No_ Records Deleted Searchint
8User ID Searchnvarchar(100)
9Filter Searchnvarchar(500)
10Starting Date Searchdatetime
11Table ID Searchint
12Register No_ Searchint
13Source Code Searchnvarchar(20)
14Retain Field Contents Searchnvarchar(160)
15Retain Totals Searchnvarchar(160)
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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