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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
LEFT JOIN
   [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
      ON
         [Workflow Step Argument Archive].[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 Archive].[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 Archive].[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 Archive].[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 Archive].[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 Archive].[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 Archive].[Response User ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Workflow Step Argument Archive].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Workflow Step Argument Archive].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Workflow Step Argument Archive table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID SearchIDNormalGUID16IDuniqueidentifier
2Type Primary Key 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 Archive].[General Journal Template Name]
	       ,[Gen. Journal Template].[Name]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
	              ON
	                     [Workflow Step Argument Archive].[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 Archive].[General Journal Batch Name]
	       ,[Gen. Journal Batch].[Journal Template Name]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Journal Batch$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Batch]
	              ON
	                     [Workflow Step Argument Archive].[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 Archive].[Notification User ID]
	       ,[User Setup].[User ID]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	              ON
	                     [Workflow Step Argument Archive].[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 Archive].[Response Function Name]
	       ,[Workflow Response].[Function Name]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [CRONUS UK Ltd_$Workflow Response$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Response]
	              ON
	                     [Workflow Step Argument Archive].[Response Function Name] = [Workflow Response].[Function Name]
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 Archive].[Workflow User Group Code]
	       ,[Workflow User Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [CRONUS UK Ltd_$Workflow User Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow User Group]
	              ON
	                     [Workflow Step Argument Archive].[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 Archive].[Approver User ID]
	       ,[User Setup].[User ID]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	              ON
	                     [Workflow Step Argument Archive].[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 Archive].[Response User ID]
	       ,[User Setup].[User ID]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	              ON
	                     [Workflow Step Argument Archive].[Response User ID] = [User Setup].[User ID]
100Response Option Group SearchResponse Option GroupFlowFieldCode20
200Original Record ID SearchOriginal Record IDNormalRecordID448Original Record IDvarbinary(448)
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 Archive].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Workflow Step Argument Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Step Argument Archive]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Workflow Step Argument Archive].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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