Approval Workflow Wizard – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AApproval Workflow Wizard

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

Table Type: Company

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

Table Number: 1804

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Approval Workflow Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Primary Key]
   ,[Approver ID]
   ,[Sales Invoice App_ Workflow]
   ,[Sales Amount Approval Limit]
   ,[Purch Invoice App_ Workflow]
   ,[Purch Amount Approval Limit]
   ,[Use Exist_ Approval User Setup]
   ,[Field]
   ,[TableNo]
   ,[Custom Message]
   ,[App_ Trigger]
   ,[Field Operator]
   ,[Journal Batch Name]
   ,[For All Batches]
   ,[Journal Template Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Approval Workflow Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Approval Workflow Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Workflow Wizard]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Approval Workflow Wizard].[Approver ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Approval Workflow Wizard].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Approval Workflow Wizard].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Approval Workflow Wizard table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
2	Approver ID	Approver ID	Normal	Code	50	Approver ID	nvarchar(100)
	Key to join to the User Setup table. Show/hide example query SELECT [Approval Workflow Wizard].[Approver ID] ,[User Setup].[User ID] FROM [CRONUS UK Ltd_$Approval Workflow Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Workflow Wizard] LEFT JOIN [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup] ON [Approval Workflow Wizard].[Approver ID] = [User Setup].[User ID]
3	Sales Invoice App. Workflow	Sales Invoice App. Workflow	Normal	Boolean	4	Sales Invoice App_ Workflow	tinyint
4	Sales Amount Approval Limit	Sales Amount Approval Limit	Normal	Integer	4	Sales Amount Approval Limit	int
5	Purch Invoice App. Workflow	Purch Invoice App. Workflow	Normal	Boolean	4	Purch Invoice App_ Workflow	tinyint
6	Purch Amount Approval Limit	Purch Amount Approval Limit	Normal	Integer	4	Purch Amount Approval Limit	int
7	Use Exist. Approval User Setup	Use Exist. Approval User Setup	Normal	Boolean	4	Use Exist_ Approval User Setup	tinyint
10	Field	Field	Normal	Integer	4	Field	int
11	TableNo	TableNo	Normal	Integer	4	TableNo	int
12	Field Caption	Field Caption	FlowField	Text	250
13	Custom Message	Custom Message	Normal	Text	250	Custom Message	nvarchar(500)
14	App. Trigger	App. Trigger	Normal	Option	4	App_ Trigger	int
	Available options are: “The user sends an approval requests manually” “The user changes a specific field”
15	Field Operator	Field Operator	Normal	Option	4	Field Operator	int
	Available options are: “Increased” “Decreased” “Changed”
38	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
39	For All Batches	For All Batches	Normal	Boolean	4	For All Batches	tinyint
40	Journal Template Name	Journal Template Name	Normal	Code	10	Journal Template Name	nvarchar(20)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Approval Workflow Wizard].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Approval Workflow Wizard$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Approval Workflow Wizard] LEFT JOIN [User] AS [User] ON [Approval Workflow Wizard].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier