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$ext

Table Number: 1523

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$ext]

Show/hide an example select of all columns by name

SELECT
   [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$ext]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
      ON
         [Workflow Step Argument].[General Journal Template Name] = [Gen. Journal Template].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
      ON
         [Workflow Step Argument].[General Journal Batch Name] = [Gen. Journal Batch].[Journal Template Name]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Workflow Step Argument].[Notification User ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$Workflow Response$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Response]
      ON
         [Workflow Step Argument].[Response Function Name] = [Workflow Response].[Function Name]
LEFT JOIN
   [CRONUS UK Ltd_$Workflow User Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow User Group]
      ON
         [Workflow Step Argument].[Workflow User Group Code] = [Workflow User Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Workflow Step Argument].[Approver User ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Workflow Step Argument].[Response User ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Workflow Step Argument].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Workflow Step Argument].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Workflow Step Argument table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID Primary Key SearchIDNormalGUID16IDuniqueidentifier
2Type SearchTypeNormalOption4Typeint
Available options are:
  • “Event”
  • “Response”
3General Journal Template Name SearchGeneral Journal Template NameNormalCode10General Journal Template Namenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
       [Workflow Step Argument].[General Journal Template Name]
       ,[Gen. Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
              ON
                     [Workflow Step Argument].[General Journal Template Name] = [Gen. Journal Template].[Name]
4General Journal Batch Name SearchGeneral Journal Batch NameNormalCode10General Journal Batch Namenvarchar(20)
Key to join to the Gen. Journal Batch table.

Show/hide example query

SELECT
       [Workflow Step Argument].[General Journal Batch Name]
       ,[Gen. Journal Batch].[Journal Template Name]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
              ON
                     [Workflow Step Argument].[General Journal Batch Name] = [Gen. Journal Batch].[Journal Template Name]
5Notification User ID SearchNotification User IDNormalCode50Notification User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Workflow Step Argument].[Notification User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Workflow Step Argument].[Notification User ID] = [User Setup].[User ID]
6Notification User License Type SearchNotification User License TypeFlowFieldOption4
7Response Function Name SearchResponse Function NameNormalCode128Response Function Namenvarchar(256)
Key to join to the Workflow Response table.

Show/hide example query

SELECT
       [Workflow Step Argument].[Response Function Name]
       ,[Workflow Response].[Function Name]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [CRONUS UK Ltd_$Workflow Response$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Response]
              ON
                     [Workflow Step Argument].[Response Function Name] = [Workflow Response].[Function Name]
8Notify Sender SearchNotify SenderNormalBoolean4Notify Sendertinyint
9Link Target Page SearchLink Target PageNormalInteger4Link Target Pageint
10Custom Link SearchCustom LinkNormalText250Custom Linknvarchar(500)
11Event Conditions SearchEvent ConditionsNormalBLOB8Event Conditionsimage
12Approver Type SearchApprover TypeNormalOption4Approver Typeint
Available options are:
  • “Salesperson/Purchaser”
  • “Approver”
  • “Workflow User Group”
13Approver Limit Type SearchApprover Limit TypeNormalOption4Approver Limit Typeint
Available options are:
  • “Approver Chain”
  • “Direct Approver”
  • “First Qualified Approver”
  • “Specific Approver”
14Workflow User Group Code SearchWorkflow User Group CodeNormalCode20Workflow User Group Codenvarchar(40)
Key to join to the Workflow User Group table.

Show/hide example query

SELECT
       [Workflow Step Argument].[Workflow User Group Code]
       ,[Workflow User Group].[Code]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [CRONUS UK Ltd_$Workflow User Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow User Group]
              ON
                     [Workflow Step Argument].[Workflow User Group Code] = [Workflow User Group].[Code]
15Due Date Formula SearchDue Date FormulaNormalDateFormula32Due Date Formulavarchar(32)
16Message SearchMessageNormalText250Messagenvarchar(500)
17Delegate After SearchDelegate AfterNormalOption4Delegate Afterint
Available options are:
  • “Never”
  • “1 day”
  • “2 days”
  • “5 days”
18Show Confirmation Message SearchShow Confirmation MessageNormalBoolean4Show Confirmation Messagetinyint
19Table No. SearchTable No.NormalInteger4Table No_int
20Field No. SearchField No.NormalInteger4Field No_int
21Field Caption SearchField CaptionFlowFieldText80
22Approver User ID SearchApprover User IDNormalCode50Approver User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Workflow Step Argument].[Approver User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Workflow Step Argument].[Approver User ID] = [User Setup].[User ID]
23Response Type SearchResponse TypeNormalOption4Response Typeint
Available options are:
  • “Not Expected”
  • “User ID”
24Response User ID SearchResponse User IDNormalCode50Response User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Workflow Step Argument].[Response User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Workflow Step Argument].[Response User ID] = [User Setup].[User ID]
25Notification Entry Type SearchNotification Entry TypeNormalOption4Notification Entry Typeint
Available options are:
  • “New Record”
  • “Approval”
  • “Overdue”
100Response Option Group SearchResponse Option GroupFlowFieldCode20
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 Argument].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [User] AS [User]
              ON
                     [Workflow Step Argument].[$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 Argument].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Workflow Step Argument$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Workflow Step Argument]
LEFT JOIN
       [User] AS [User]
              ON
                     [Workflow Step Argument].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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