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
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | WorkflowInstanceID ![]() | Workflow Instance ID | GUIDString | String | 36 | |
2 | Workflow_Name ![]() | Workflow Name | STR50_LBA | String | 50 | |
3 | WfBusObjKey ![]() | Workflow Business Object Key | STR200 | String | 200 | |
4 | Workflow_Version ![]() | Workflow Version | INT7 | Long Integer | 7 | |
5 | Workflow_Description ![]() | Workflow Description | STR100 | String | 100 | |
6 | Workflow_Type_Name ![]() | Workflow Type Name | STR50_LBA | String | 50 | |
7 | FormID ![]() | FormID | INT5_RU0 | Integer | 5 | |
8 | DICTID ![]() | DictID | ID_INT | Integer | 4 | |
9 | Workflow_Status ![]() | Workflow Status | Workflow Status | Integer | 0 | |
Click to show/hide Workflow Statuses1 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) | ||||||
10 | WF_SendNotificatications ![]() | Workflow Send Notifications for Completed Actions | CB_SendNotificationForCompletedActions | Boolean | 0 | |
11 | Workflow_Manually_Delega ![]() | Workflow Manually Delegate | CB_Manually_Delegate | Boolean | 0 | |
12 | Workflow_Originator ![]() | Workflow Originator | STR238_OddStorageLength | String | 238 | |
13 | WF_AllowOrigApprover ![]() | Workflow Allow Originator to be an Approver | CB_AllowOriginatorToBeAnApprover | Boolean | 0 | |
14 | Workflow_Require_One_App ![]() | Workflow Require One Approver | CB_Always_Require_One_Approver | Boolean | 0 | |
15 | WF_Use_Alt_Final_Approv ![]() | Workflow Use Alternate Final Approver | CB Use Alternate Final Approver | Boolean | 0 | |
16 | WF_Alt_FinalApprover ![]() | Workflow Alternate Final Approver | GUIDString | String | 36 | |
17 | WF_Overdue_Task_Action ![]() | Workflow Overdue Task Action | GB | Integer | 0 | |
18 | Workflow_Delegate_To ![]() | Workflow Delegate To | GUIDString | String | 36 | |
19 | TBLPHYSNM ![]() | Table Physical Name | STR50 | String | 50 | |
20 | Document_Drill_Down ![]() | Document Drill Down | STR255 | String | 255 | |
21 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['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 | ||||||
22 | BusObjKey ![]() | BusObjKey | STR200 | String | 200 | |
23 | Workflow_Where_Clause ![]() | Workflow Where Clause | TXT4000 | Text | 4000 | |
24 | DEX_ROW_TS ![]() | datetime | datetime | 3 | ||
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. | ||||||
25 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |