Workflows Entries Buffer

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

Table Type: Company

Table Name: Workflows Entries Buffer
Database Table Name: CRONUS UK Ltd_$Workflows Entries Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 832

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 Workflows Entries Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Workflows Entries Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Workflow Step Instance ID]
   ,[Created by Application]
   ,[Entry No_]
   ,[Record ID]
   ,[Initiated By User ID]
   ,[To Be Approved By User ID]
   ,[Date-Time Initiated]
   ,[Last Date-Time Modified]
   ,[Last Modified By User ID]
   ,[Status]
   ,[Response]
   ,[Amount]
   ,[Due Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Workflows Entries Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Workflows Entries Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Workflow Step Instance ID Primary Key Searchuniqueidentifier
3Created by Application Searchint
4Entry No_ Searchint
5Record ID Searchvarbinary(448)
6Initiated By User ID Searchnvarchar(100)
7To Be Approved By User ID Searchnvarchar(100)
8Date-Time Initiated Searchdatetime
9Last Date-Time Modified Searchdatetime
10Last Modified By User ID Searchnvarchar(100)
11Status Searchint
12Response Searchint
13Amount Searchint
14Due Date Searchdatetime
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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