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. | ||||||