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

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in Workflow Step Instance Archive table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID SearchIDNormalGUID16IDuniqueidentifier
2Workflow Code Primary Key SearchWorkflow CodeNormalCode20Workflow Codenvarchar(40)
3Workflow Step ID Primary Key SearchWorkflow Step IDNormalInteger4Workflow Step IDint
4Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
9Entry Point SearchEntry PointNormalBoolean4Entry Pointtinyint
Key to join to the Entry/Exit Point table.

Show/hide example query

11Record ID SearchRecord IDNormalRecordID448Record IDvarbinary(448)
12Created Date-Time SearchCreated Date-TimeNormalDateTime8Created Date-Timedatetime
13Created By User ID SearchCreated By User IDNormalCode50Created By User IDnvarchar(100)
14Last Modified Date-Time SearchLast Modified Date-TimeNormalDateTime8Last Modified Date-Timedatetime
15Last Modified By User ID SearchLast Modified By User IDNormalCode50Last Modified By User IDnvarchar(100)
17Status SearchStatusNormalOption4Statusint
Available options are:
  • “Inactive”
  • “Active”
  • “Completed”
  • “Ignored”
  • “Processing”
18Previous Workflow Step ID SearchPrevious Workflow Step IDNormalInteger4Previous Workflow Step IDint
19Next Workflow Step ID SearchNext Workflow Step IDNormalInteger4Next Workflow Step IDint
21Type SearchTypeNormalOption4Typeint
Available options are:
  • “Event”
  • “Response”
22Function Name SearchFunction NameNormalCode128Function Namenvarchar(256)
23Argument SearchArgumentNormalGUID16Argumentuniqueidentifier
30Original Workflow Code SearchOriginal Workflow CodeNormalCode20Original Workflow Codenvarchar(40)
Key to join to the Workflow Step table.

Show/hide example query

31Original Workflow Step ID SearchOriginal Workflow Step IDNormalInteger4Original Workflow Step IDint
32Sequence No. SearchSequence No.NormalInteger4Sequence No_int
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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