Approval 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
   [timestamp]
   ,[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 columns in Approval Workflow Wizard table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Approver ID Searchnvarchar(100)
4Sales Invoice App_ Workflow Searchtinyint
5Sales Amount Approval Limit Searchint
6Purch Invoice App_ Workflow Searchtinyint
7Purch Amount Approval Limit Searchint
8Use Exist_ Approval User Setup Searchtinyint
9Field Searchint
10TableNo Searchint
11Custom Message Searchnvarchar(500)
12App_ Trigger Searchint
13Field Operator Searchint
14Journal Batch Name Searchnvarchar(20)
15For All Batches Searchtinyint
16Journal Template Name Searchnvarchar(20)
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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