Workflow Step Table (WF100003)

Easily find this page again using the shortlink: http://gpt.azrcrv.co.uk/WF100003

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_NameWorkflow Step NameSTR50_LBAString5250
2Workflow_NameWorkflow NameSTR50_LBAString5250
3Workflow_VersionWorkflow VersionINT7Long Integer47
4WF_Step_DescriptionWorkflow Step DescriptionSTR100String102100
5Workflow_Step_SequenceWorkflow Step SequenceINT7Long Integer47
6Workflow_Step_TypeWorkflow Step TypeDDL_Workflow_Step_TypeInteger20
7Workflow_Step_OrderWorkflow Step OrderGBInteger20
8Workflow_Step_ConditionWorkflow Step ConditionGBInteger20
9Workflow_Step_ConditionsWorkflow Step ConditionsGUIDStringString3836
10WF_Step_PredecessorWorkflow Step PredecessorSTR50_LBAString5250
11Workflow_Step_Assign_ToWorkflow Step Assign ToGUIDStringString3836
12EmailMessageIDEmail Message IDSTR25_LBAUString2625
13Workflow_Step_Send_EmailWorkflow Step Send EmailCBBoolean20
14Workflow_Step_Time_LimitWorkflow Step Time LimitINT5Integer24
15WF_Step_Time_Limit_UofMWorkflow Step Time Limit UofMDDL_WorkflowTimeLimitUofMInteger20
16WF_Step_Completion_PolicWorkflow Step Completion PolicyGBInteger20
17WF_Apply_WF_CalendarWorkflow Apply Workflow CalendarCB Apply Workflow CalendarBoolean20
18NOTEINDXNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide example SQL

SELECT
       ['Workflow Step Table'].NOTEINDX AS 'Workflow Step Table-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WF100003 AS ['Workflow Step Table']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Workflow Step Table'].NOTEINDX = ['Record Notes Master'].NOTEINDX
19WFIncludeDocumentAttachWorkflow Step Include Doc AttachCB_WorkflowIncludeDocAttachBoolean20
20WFIncludeWordTemplatesWorkflow Step Include Word TemplatesCB_WorkflowIncludeWordTemplatesBoolean20
21WFConditionProcessTypeWorkflow Step Condition Process TypewfStepConditionProcessTypeInteger20
22WFStepReminderTimeLimitWorkflow Step Reminder Time LimitINT5Integer24
23WFStepRemTimeLimitUofMWorkflow Step Reminder Time Limit UofMDDL_WorkflowTimeLimitUofMInteger20
24DEX_ROW_TSdatetimedatetime33
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_IDintint1010

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.

1 thought on “Workflow Step Table (WF100003)

Leave a Reply

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