Workflow Instance Master (WFI10002)

azurecurveProductsMicrosoft Dynamics GP (0)CompanyWorkflow Instance Master (WFI10002)

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

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Workflow Instance Master
Physical Name: WFI10002
Technical Name: Workflow_Instance

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1WorkflowInstanceID SearchWorkflow Instance IDGUIDStringString36
2Workflow_Name SearchWorkflow NameSTR50_LBAString50
3WfBusObjKey SearchWorkflow Business Object KeySTR200String200
4Workflow_Version SearchWorkflow VersionINT7Long Integer7
5Workflow_Description SearchWorkflow DescriptionSTR100String100
6Workflow_Type_Name SearchWorkflow Type NameSTR50_LBAString50
7FormID SearchFormIDINT5_RU0Integer5
8DICTID SearchDictIDID_INTInteger4
9Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0

Click to show/hide Workflow Statuses

1	Not Submitted
2	Submitted (Deprecated)
3	No Action Needed
4	Pending User Action
5	Recalled
6	Completed
7	Rejected
8	Workflow Ended (Depricated)
9	Not Activated
10	Deactivated (Depricated)
10WF_SendNotificatications SearchWorkflow Send Notifications for Completed ActionsCB_SendNotificationForCompletedActionsBoolean0
11Workflow_Manually_Delega SearchWorkflow Manually DelegateCB_Manually_DelegateBoolean0
12Workflow_Originator SearchWorkflow OriginatorSTR238_OddStorageLengthString238
13WF_AllowOrigApprover SearchWorkflow Allow Originator to be an ApproverCB_AllowOriginatorToBeAnApproverBoolean0
14Workflow_Require_One_App SearchWorkflow Require One ApproverCB_Always_Require_One_ApproverBoolean0
15WF_Use_Alt_Final_Approv SearchWorkflow Use Alternate Final ApproverCB Use Alternate Final ApproverBoolean0
16WF_Alt_FinalApprover SearchWorkflow Alternate Final ApproverGUIDStringString36
17WF_Overdue_Task_Action SearchWorkflow Overdue Task ActionGBInteger0
18Workflow_Delegate_To SearchWorkflow Delegate ToGUIDStringString36
19TBLPHYSNM SearchTable Physical NameSTR50String50
20Document_Drill_Down SearchDocument Drill DownSTR255String255
21NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Workflow Instance Master'].NOTEINDX AS 'Workflow Instance Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WFI10002 AS ['Workflow Instance Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Workflow Instance Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
22BusObjKey SearchBusObjKeySTR200String200
23Workflow_Where_Clause SearchWorkflow Where ClauseTXT4000Text4000
24DEX_ROW_TS Searchdatetimedatetime3
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.
25DEX_ROW_ID Searchintint10

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.

azurecurveProductsMicrosoft Dynamics GP (0)CompanyWorkflow Instance Master (WFI10002)

Leave a Reply

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