Workflow Step Instance Archive

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

Table Type: Company

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

Table Number: 1530

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 Instance Archive can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Workflow Code]
   ,[Workflow Step ID]
   ,[Description]
   ,[Entry Point]
   ,[Record ID]
   ,[Created Date-Time]
   ,[Created By User ID]
   ,[Last Modified Date-Time]
   ,[Last Modified By User ID]
   ,[Status]
   ,[Previous Workflow Step ID]
   ,[Next Workflow Step ID]
   ,[Type]
   ,[Function Name]
   ,[Argument]
   ,[Original Workflow Code]
   ,[Original Workflow Step ID]
   ,[Sequence No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Workflow Step Instance Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Workflow Step Instance Archive table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Workflow Code Primary Key Searchnvarchar(40)
4Workflow Step ID Primary Key Searchint
5Description Searchnvarchar(200)
6Entry Point Searchtinyint
7Record ID Searchvarbinary(448)
8Created Date-Time Searchdatetime
9Created By User ID Searchnvarchar(100)
10Last Modified Date-Time Searchdatetime
11Last Modified By User ID Searchnvarchar(100)
12Status Searchint
13Previous Workflow Step ID Searchint
14Next Workflow Step ID Searchint
15Type Searchint
16Function Name Searchnvarchar(256)
17Argument Searchuniqueidentifier
18Original Workflow Code Searchnvarchar(40)
19Original Workflow Step ID Searchint
20Sequence No_ Searchint
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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