Workflow Master (WF100002)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WF100002

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Workflow Master
Physical Name: WF100002
Technical Name: Workflow_Master

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Workflow_Name SearchWorkflow NameSTR50_LBAString5250
2Workflow_Version SearchWorkflow VersionINT7Long Integer47
3Workflow_Description SearchWorkflow DescriptionSTR100String102100
4Workflow_Type_Name SearchWorkflow Type NameSTR50_LBAString5250
5ACTIVE SearchActiveCB_ActiveBoolean20
6WF_SendNotificatications SearchWorkflow Send Notifications for Completed ActionsCB_SendNotificationForCompletedActionsBoolean20
7Workflow_Manually_Delega SearchWorkflow Manually DelegateCB_Manually_DelegateBoolean20
8WF_AllowOrigApprover SearchWorkflow Allow Originator to be an ApproverCB_AllowOriginatorToBeAnApproverBoolean20
9Workflow_Require_One_App SearchWorkflow Require One ApproverCB_Always_Require_One_ApproverBoolean20
10WF_Use_Alt_Final_Approv SearchWorkflow Use Alternate Final ApproverCB Use Alternate Final ApproverBoolean20
11WF_Alt_FinalApprover SearchWorkflow Alternate Final ApproverGUIDStringString3836
12WF_Overdue_Task_Action SearchWorkflow Overdue Task ActionGBInteger20
13Workflow_Delegate_To SearchWorkflow Delegate ToGUIDStringString3836
14NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Workflow Master'].NOTEINDX AS 'Workflow Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WF100002 AS ['Workflow Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Workflow Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
15DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
16DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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