Workflow Step Buffer

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

Table Type: Company

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

Table Number: 1507

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 Workflow Step Buffer can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Order]
   ,[Indent]
   ,[Event Description]
   ,[Condition]
   ,[Response Description]
   ,[Event Step ID]
   ,[Response Step ID]
   ,[Workflow Code]
   ,[Parent Event Step ID]
   ,[Previous Workflow Step ID]
   ,[Response Description Style]
   ,[Entry Point]
   ,[Sequence No_]
   ,[Next Step Description]
   ,[Argument]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Workflow Step Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Workflow Step Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Order Primary Key Searchint
3Indent Searchint
4Event Description Searchnvarchar(500)
5Condition Searchnvarchar(200)
6Response Description Searchnvarchar(500)
7Event Step ID Searchint
8Response Step ID Searchint
9Workflow Code Searchnvarchar(40)
10Parent Event Step ID Searchint
11Previous Workflow Step ID Searchint
12Response Description Style Searchnvarchar(60)
13Entry Point Searchtinyint
14Sequence No_ Searchint
15Next Step Description Searchnvarchar(500)
16Argument Searchuniqueidentifier
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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