Workflow Step Argument Archive

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

Table Type: Company

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

Table Number: 1531

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Type]
   ,[General Journal Template Name]
   ,[General Journal Batch Name]
   ,[Notification User ID]
   ,[Response Function Name]
   ,[Link Target Page]
   ,[Custom Link]
   ,[Event Conditions]
   ,[Approver Type]
   ,[Approver Limit Type]
   ,[Workflow User Group Code]
   ,[Due Date Formula]
   ,[Message]
   ,[Delegate After]
   ,[Show Confirmation Message]
   ,[Table No_]
   ,[Field No_]
   ,[Approver User ID]
   ,[Response Type]
   ,[Response User ID]
   ,[Original Record ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Workflow Step Argument Archive table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Type Searchint
4General Journal Template Name Searchnvarchar(20)
5General Journal Batch Name Searchnvarchar(20)
6Notification User ID Searchnvarchar(100)
7Response Function Name Searchnvarchar(256)
8Link Target Page Searchint
9Custom Link Searchnvarchar(500)
10Event Conditions Searchimage
11Approver Type Searchint
12Approver Limit Type Searchint
13Workflow User Group Code Searchnvarchar(40)
14Due Date Formula Searchvarchar(32)
15Message Searchnvarchar(500)
16Delegate After Searchint
17Show Confirmation Message Searchtinyint
18Table No_ Searchint
19Field No_ Searchint
20Approver User ID Searchnvarchar(100)
21Response Type Searchint
22Response User ID Searchnvarchar(100)
23Original Record ID Searchvarbinary(448)
24$systemId Searchuniqueidentifier
25$systemCreatedAt Searchdatetime
26$systemCreatedBy Searchuniqueidentifier
27$systemModifiedAt Searchdatetime
28$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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