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 TypeSQL DB LengthKeyable Length
1WorkflowInstanceID SearchWorkflow Instance IDGUIDStringString3836
2Workflow_Name SearchWorkflow NameSTR50_LBAString5250
3WfBusObjKey SearchWorkflow Business Object KeySTR200String202200
4Workflow_Version SearchWorkflow VersionINT7Long Integer47
5Workflow_Description SearchWorkflow DescriptionSTR100String102100
6Workflow_Type_Name SearchWorkflow Type NameSTR50_LBAString5250
7FormID SearchFormIDINT5_RU0Integer25
8DICTID SearchDictIDID_INTInteger24
9Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
10WF_SendNotificatications SearchWorkflow Send Notifications for Completed ActionsCB_SendNotificationForCompletedActionsBoolean20
11Workflow_Manually_Delega SearchWorkflow Manually DelegateCB_Manually_DelegateBoolean20
12Workflow_Originator SearchWorkflow OriginatorSTR238_OddStorageLengthString239238
13WF_AllowOrigApprover SearchWorkflow Allow Originator to be an ApproverCB_AllowOriginatorToBeAnApproverBoolean20
14Workflow_Require_One_App SearchWorkflow Require One ApproverCB_Always_Require_One_ApproverBoolean20
15WF_Use_Alt_Final_Approv SearchWorkflow Use Alternate Final ApproverCB Use Alternate Final ApproverBoolean20
16WF_Alt_FinalApprover SearchWorkflow Alternate Final ApproverGUIDStringString3836
17WF_Overdue_Task_Action SearchWorkflow Overdue Task ActionGBInteger20
18Workflow_Delegate_To SearchWorkflow Delegate ToGUIDStringString3836
19TBLPHYSNM SearchTable Physical NameSTR50String5250
20Document_Drill_Down SearchDocument Drill DownSTR255String256255
21NOTEINDX SearchNote IndexDLR14Currency1014
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 SearchBusObjKeySTR200String202200
23Workflow_Where_Clause SearchWorkflow Where ClauseTXT4000Text24000
24DEX_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.
25DEX_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.

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

Leave a Reply

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