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 TypeLength
1WorkflowInstanceID SearchWorkflow Instance IDGUIDStringString36
2WorkflowStepInstanceID SearchWorkflow Step Instance IDGUIDStringString36
3WorkflowTaskAssignedTo SearchWorkflow Task Assigned ToSTR85String85
4Workflow_Step_Name SearchWorkflow Step NameSTR50_LBAString50
5Workflow_Name SearchWorkflow NameSTR50_LBAString50
6Workflow_Version SearchWorkflow VersionINT7Long Integer7
7WF_Step_Description SearchWorkflow Step DescriptionSTR100String100
8Workflow_Action_Date SearchWorkflow Action DateDATE_LDate0
9Workflow_Action_Time SearchWorkflow Action TimeTM6Time6
10Workflow_Due_Date SearchWorkflow Due DateDATE_LDate0
11Workflow_Due_Time SearchWorkflow Due TimeTM6Time6
12Workflow_Step_Sequence SearchWorkflow Step SequenceINT7Long Integer7
13Workflow_Step_Type SearchWorkflow Step TypeDDL_Workflow_Step_TypeInteger0
14Workflow_Step_Order SearchWorkflow Step OrderGBInteger0
15WF_Step_Predecessor SearchWorkflow Step PredecessorSTR50_LBAString50
16WF_Step_Completion_Polic SearchWorkflow Step Completion PolicyGBInteger0
17Workflow_Task_Escalated SearchWorkflow Task EscalatedbooleanBoolean0
18WFReminderDueDate SearchWorkflow Reminder Due DateDATE_LDate0
19WFReminderDueTime SearchWorkflow Reminder Due TimeTM6Time6
20WorkflowReminderSent SearchWorkflow Reminder SentBooleanBoolean0
21DEX_ROW_TS Searchdatetimedatetime3
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 Searchintint10

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 *