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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Workflow Step Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Workflow Event$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Event]
      ON
         [Workflow Step Buffer].[Event Description] = [Workflow Event].[Description]
LEFT JOIN
   [CRONUS UK Ltd_$Workflow Response$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Response]
      ON
         [Workflow Step Buffer].[Response Description] = [Workflow Response].[Description]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Workflow Step Buffer].[Entry Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$VAT Reg_ No_ Srv_ Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Reg. No. Srv. Template]
      ON
         [Workflow Step Buffer].[Template] = [VAT Reg. No. Srv. Template].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Workflow Step Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Workflow Step Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Workflow Step Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Order Primary Key SearchOrderNormalInteger4Orderint
2Indent SearchIndentNormalInteger4Indentint
3Event Description SearchEvent DescriptionNormalText250Event Descriptionnvarchar(500)
Key to join to the Workflow Event table.

Show/hide example query

SELECT
       [Workflow Step Buffer].[Event Description]
       ,[Workflow Event].[Description]
FROM
       [CRONUS UK Ltd_$Workflow Step Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Workflow Event$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Event]
              ON
                     [Workflow Step Buffer].[Event Description] = [Workflow Event].[Description]
4Condition SearchConditionNormalText100Conditionnvarchar(200)
5Response Description SearchResponse DescriptionNormalText250Response Descriptionnvarchar(500)
Key to join to the Workflow Response table.

Show/hide example query

SELECT
       [Workflow Step Buffer].[Response Description]
       ,[Workflow Response].[Description]
FROM
       [CRONUS UK Ltd_$Workflow Step Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Workflow Response$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Response]
              ON
                     [Workflow Step Buffer].[Response Description] = [Workflow Response].[Description]
7Event Step ID SearchEvent Step IDNormalInteger4Event Step IDint
8Response Step ID SearchResponse Step IDNormalInteger4Response Step IDint
9Workflow Code SearchWorkflow CodeNormalCode20Workflow Codenvarchar(40)
10Parent Event Step ID SearchParent Event Step IDNormalInteger4Parent Event Step IDint
11Previous Workflow Step ID SearchPrevious Workflow Step IDNormalInteger4Previous Workflow Step IDint
12Response Description Style SearchResponse Description StyleNormalText30Response Description Stylenvarchar(60)
14Entry Point SearchEntry PointNormalBoolean4Entry Pointtinyint
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Workflow Step Buffer].[Entry Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Workflow Step Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Workflow Step Buffer].[Entry Point] = [Entry/Exit Point].[Code]
15Sequence No. SearchSequence No.NormalInteger4Sequence No_int
16Next Step Description SearchNext Step DescriptionNormalText250Next Step Descriptionnvarchar(500)
17Argument SearchArgumentNormalGUID16Argumentuniqueidentifier
18Template SearchTemplateFlowFieldBoolean4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Workflow Step Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Workflow Step Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Workflow Step Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Workflow Step Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Workflow Step Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Workflow Step Buffer].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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