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 | String | GUIDString | 36 | |
| 2 | Workflow_Name | Workflow Name | String | STR50_LBA | 50 | |
| 3 | WfBusObjKey | Workflow Business Object Key | String | STR200 | 200 | |
| 4 | Workflow_Version | Workflow Version | Long Integer | INT7 | 7 | |
| 5 | Workflow_Description | Workflow Description | String | STR100 | 100 | |
| 6 | Workflow_Type_Name | Workflow Type Name | String | STR50_LBA | 50 | |
| 7 | FormID | FormID | Integer | INT5_RU0 | 5 | |
| 8 | DICTID | DictID | Integer | ID_INT | 4 | |
| 9 | Workflow_Status | Workflow Status | Integer | Workflow Status | 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 | Boolean | CB_SendNotificationForCompletedActions | 0 | |
| 11 | Workflow_Manually_Delega | Workflow Manually Delegate | Boolean | CB_Manually_Delegate | 0 | |
| 12 | Workflow_Originator | Workflow Originator | String | STR238_OddStorageLength | 238 | |
| 13 | WF_AllowOrigApprover | Workflow Allow Originator to be an Approver | Boolean | CB_AllowOriginatorToBeAnApprover | 0 | |
| 14 | Workflow_Require_One_App | Workflow Require One Approver | Boolean | CB_Always_Require_One_Approver | 0 | |
| 15 | WF_Use_Alt_Final_Approv | Workflow Use Alternate Final Approver | Boolean | CB Use Alternate Final Approver | 0 | |
| 16 | WF_Alt_FinalApprover | Workflow Alternate Final Approver | String | GUIDString | 36 | |
| 17 | WF_Overdue_Task_Action | Workflow Overdue Task Action | Integer | GB | 0 | |
| 18 | Workflow_Delegate_To | Workflow Delegate To | String | GUIDString | 36 | |
| 19 | TBLPHYSNM | Table Physical Name | String | STR50 | 50 | |
| 20 | Document_Drill_Down | Document Drill Down | String | STR255 | 255 | |
| 21 | NOTEINDX | Note Index | Currency | DLR14 | 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 | String | STR200 | 200 | |
| 23 | WF_PostAfterFinalApprova | Workflow Post After Final Approval | Boolean | CB_Post_After_Final_Approval | 0 | |
| 24 | Workflow_Where_Clause | Workflow Where Clause | Text | TXT4000 | 4000 | |