Workflow Step Table (WF100003)

Easily find this page again using the shortlink:

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Workflow Step Table
Physical Name: WF100003
Technical Name: Workflow_Step

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Workflow_Step_Name SearchWorkflow Step NameSTR50_LBAString5250
2Workflow_Name SearchWorkflow NameSTR50_LBAString5250
3Workflow_Version SearchWorkflow VersionINT7Long Integer47
4WF_Step_Description SearchWorkflow Step DescriptionSTR100String102100
5Workflow_Step_Sequence SearchWorkflow Step SequenceINT7Long Integer47
6Workflow_Step_Type SearchWorkflow Step TypeDDL_Workflow_Step_TypeInteger20
7Workflow_Step_Order SearchWorkflow Step OrderGBInteger20
8Workflow_Step_Condition SearchWorkflow Step ConditionGBInteger20
9Workflow_Step_Conditions SearchWorkflow Step ConditionsGUIDStringString3836
10WF_Step_Predecessor SearchWorkflow Step PredecessorSTR50_LBAString5250
11Workflow_Step_Assign_To SearchWorkflow Step Assign ToGUIDStringString3836
12EmailMessageID SearchEmail Message IDSTR25_LBAUString2625
13Workflow_Step_Send_Email SearchWorkflow Step Send EmailCBBoolean20
14Workflow_Step_Time_Limit SearchWorkflow Step Time LimitINT5Integer24
15WF_Step_Time_Limit_UofM SearchWorkflow Step Time Limit UofMDDL_WorkflowTimeLimitUofMInteger20
16WF_Step_Completion_Polic SearchWorkflow Step Completion PolicyGBInteger20
17WF_Apply_WF_Calendar SearchWorkflow Apply Workflow CalendarCB Apply Workflow CalendarBoolean20
18NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

       ['Workflow Step Table'].NOTEINDX AS 'Workflow Step Table-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
       WF100003 AS ['Workflow Step Table']
       SY03900 AS ['Record Notes Master']
                     ['Workflow Step Table'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19WFIncludeDocumentAttach SearchWorkflow Step Include Doc AttachCB_WorkflowIncludeDocAttachBoolean20
20WFIncludeWordTemplates SearchWorkflow Step Include Word TemplatesCB_WorkflowIncludeWordTemplatesBoolean20
21WFConditionProcessType SearchWorkflow Step Condition Process TypewfStepConditionProcessTypeInteger20
22WFStepReminderTimeLimit SearchWorkflow Step Reminder Time LimitINT5Integer24
23WFStepRemTimeLimitUofM SearchWorkflow Step Reminder Time Limit UofMDDL_WorkflowTimeLimitUofMInteger20
24DEX_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.
25DEX_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 *