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