Reminder Text

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

Table Type: Company

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

Table Number: 294

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Reminder Terms Code]
   ,[Reminder Level]
   ,[Position]
   ,[Line No_]
   ,[Text]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Reminder Text$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Reminder Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Text]
LEFT JOIN
   [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
      ON
         [Reminder Text].[Reminder Terms Code] = [Reminder Terms].[No_]

Show/hide columns in Reminder Text table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Reminder Terms Code Primary Key Searchnvarchar(20)
Key to join to the Reminder Terms table.

Show/hide example query

SELECT
       [Reminder Text].[Reminder Terms Code]
       ,[Reminder Terms].[No_]
FROM
       [CRONUS UK Ltd_$Reminder Text$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Text]
LEFT JOIN
       [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
              ON
                     [Reminder Text].[Reminder Terms Code] = [Reminder Terms].[No_]
3Reminder Level Primary Key Searchint
4Position Primary Key Searchint
5Line No_ Primary Key Searchint
6Text Searchnvarchar(200)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Reminder Text table

Leave a Reply

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