Workflow Step Table (WF100003)

Easily find this page again using the shortlink: https://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 TypeLength
1Workflow_Step_Name SearchWorkflow Step NameSTR50_LBAString50
2Workflow_Name SearchWorkflow NameSTR50_LBAString50
3Workflow_Version SearchWorkflow VersionINT7Long Integer7
4WF_Step_Description SearchWorkflow Step DescriptionSTR100String100
5Workflow_Step_Sequence SearchWorkflow Step SequenceINT7Long Integer7
6Workflow_Step_Type SearchWorkflow Step TypeDDL_Workflow_Step_TypeInteger0
7Workflow_Step_Order SearchWorkflow Step OrderGBInteger0
8Workflow_Step_Condition SearchWorkflow Step ConditionGBInteger0
9Workflow_Step_Conditions SearchWorkflow Step ConditionsGUIDStringString36
10WF_Step_Predecessor SearchWorkflow Step PredecessorSTR50_LBAString50
11Workflow_Step_Assign_To SearchWorkflow Step Assign ToGUIDStringString36
12EmailMessageID SearchEmail Message IDSTR25_LBAUString25
13Workflow_Step_Send_Email SearchWorkflow Step Send EmailCBBoolean0
14Workflow_Step_Time_Limit SearchWorkflow Step Time LimitINT5Integer4
15WF_Step_Time_Limit_UofM SearchWorkflow Step Time Limit UofMDDL_WorkflowTimeLimitUofMInteger0
16WF_Step_Completion_Polic SearchWorkflow Step Completion PolicyGBInteger0
17WF_Apply_WF_Calendar SearchWorkflow Apply Workflow CalendarCB Apply Workflow CalendarBoolean0
18NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

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
19WFIncludeDocumentAttach SearchWorkflow Step Include Doc AttachCB_WorkflowIncludeDocAttachBoolean0
20WFIncludeWordTemplates SearchWorkflow Step Include Word TemplatesCB_WorkflowIncludeWordTemplatesBoolean0
21WFConditionProcessType SearchWorkflow Step Condition Process TypewfStepConditionProcessTypeInteger0
22WFStepReminderTimeLimit SearchWorkflow Step Reminder Time LimitINT5Integer4
23WFStepRemTimeLimitUofM SearchWorkflow Step Reminder Time Limit UofMDDL_WorkflowTimeLimitUofMInteger0
24DEX_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.
25DEX_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 *