Workflow Tasks Table (WFI10004)

Easily find this page again using the shortlink:

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Workflow Tasks Table
Physical Name: WFI10004
Technical Name: Workflow_Tasks

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1WorkflowInstanceID SearchWorkflow Instance IDGUIDStringString3836
2WorkflowStepInstanceID SearchWorkflow Step Instance IDGUIDStringString3836
3WorkflowTaskAssignedTo SearchWorkflow Task Assigned ToSTR85String8685
4Workflow_Step_Name SearchWorkflow Step NameSTR50_LBAString5250
5Workflow_Name SearchWorkflow NameSTR50_LBAString5250
6Workflow_Version SearchWorkflow VersionINT7Long Integer47
7WF_Step_Description SearchWorkflow Step DescriptionSTR100String102100
8Workflow_Action_Date SearchWorkflow Action DateDATE_LDate40
9Workflow_Action_Time SearchWorkflow Action TimeTM6Time46
10Workflow_Due_Date SearchWorkflow Due DateDATE_LDate40
11Workflow_Due_Time SearchWorkflow Due TimeTM6Time46
12Workflow_Step_Sequence SearchWorkflow Step SequenceINT7Long Integer47
13Workflow_Step_Type SearchWorkflow Step TypeDDL_Workflow_Step_TypeInteger20
14Workflow_Step_Order SearchWorkflow Step OrderGBInteger20
15WF_Step_Predecessor SearchWorkflow Step PredecessorSTR50_LBAString5250
16WF_Step_Completion_Polic SearchWorkflow Step Completion PolicyGBInteger20
17Workflow_Task_Escalated SearchWorkflow Task EscalatedbooleanBoolean20
18WFReminderDueDate SearchWorkflow Reminder Due DateDATE_LDate40
19WFReminderDueTime SearchWorkflow Reminder Due TimeTM6Time46
20WorkflowReminderSent SearchWorkflow Reminder SentBooleanBoolean20
21DEX_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.
22DEX_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.

Leave a Reply

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