Workflow Step Argument

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Workflow Step Argument$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]
   ,[Notify Sender]
   ,[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]
   ,[Notification Entry Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Workflow Step Argument 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)
8Notify Sender Searchtinyint
9Link Target Page Searchint
10Custom Link Searchnvarchar(500)
11Event Conditions Searchimage
12Approver Type Searchint
13Approver Limit Type Searchint
14Workflow User Group Code Searchnvarchar(40)
15Due Date Formula Searchvarchar(32)
16Message Searchnvarchar(500)
17Delegate After Searchint
18Show Confirmation Message Searchtinyint
19Table No_ Searchint
20Field No_ Searchint
21Approver User ID Searchnvarchar(100)
22Response Type Searchint
23Response User ID Searchnvarchar(100)
24Notification Entry Type Searchint
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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