Approval Comment Line

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

Table Type: Company

Table Name: Approval Comment Line
Database Table Name: CRONUS UK Ltd_$Approval Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 455

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 Approval Comment Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Approval Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Table ID]
   ,[Document Type]
   ,[Document No_]
   ,[User ID]
   ,[Date and Time]
   ,[Comment]
   ,[Record ID to Approve]
   ,[Workflow Step Instance ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Approval Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Approval Comment Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Table ID Searchint
4Document Type Searchint
5Document No_ Searchnvarchar(40)
6User ID Searchnvarchar(100)
7Date and Time Searchdatetime
8Comment Searchnvarchar(160)
9Record ID to Approve Searchvarbinary(448)
10Workflow Step Instance ID Searchuniqueidentifier
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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