Workflow Step Instance Table (WFI10003)

azurecurveProductsMicrosoft Dynamics GP (0)CompanyWorkflow Step Instance Table (WFI10003)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WFI10003

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Workflow Step Instance Table
Physical Name: WFI10003
Technical Name: Workflow_Step_Instance

Group Display Name: Workflow
Group Technical Name: Workflow

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1WorkflowStepInstanceID SearchWorkflow Step Instance IDGUIDStringString36
2Workflow_Step_Name SearchWorkflow Step NameSTR50_LBAString50
3WorkflowInstanceID SearchWorkflow Instance IDGUIDStringString36
4Workflow_Name SearchWorkflow NameSTR50_LBAString50
5Workflow_Version SearchWorkflow VersionINT7Long Integer7
6WF_Step_Description SearchWorkflow Step DescriptionSTR100String100
7Workflow_Step_Status SearchWorkflow Step StatusWorkflow Step StatusInteger0

Click to show/hide Workflow Step Statuses

1	No Action Needed
2	Pending User Action
3	Rejected
4	Completed
5	Recalled
6	Failed
8Workflow_Step_Sequence SearchWorkflow Step SequenceINT7Long Integer7
9Workflow_Step_Type SearchWorkflow Step TypeDDL_Workflow_Step_TypeInteger0
10Workflow_Step_Order SearchWorkflow Step OrderGBInteger0
11Workflow_Step_Condition SearchWorkflow Step ConditionGBInteger0
12Workflow_Step_Conditions SearchWorkflow Step ConditionsGUIDStringString36
13WF_Step_Predecessor SearchWorkflow Step PredecessorSTR50_LBAString50
14Workflow_Step_Assign_To SearchWorkflow Step Assign ToGUIDStringString36
15EmailMessageID SearchEmail Message IDSTR25_LBAUString25
16Workflow_Step_Send_Email SearchWorkflow Step Send EmailCBBoolean0
17Workflow_Step_Time_Limit SearchWorkflow Step Time LimitINT5Integer4
18WF_Step_Time_Limit_UofM SearchWorkflow Step Time Limit UofMDDL_WorkflowTimeLimitUofMInteger0
19WF_Step_Completion_Polic SearchWorkflow Step Completion PolicyGBInteger0
20WF_Apply_WF_Calendar SearchWorkflow Apply Workflow CalendarCB Apply Workflow CalendarBoolean0
21NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Workflow Step Instance Table'].NOTEINDX AS 'Workflow Step Instance Table-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       WFI10003 AS ['Workflow Step Instance Table']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Workflow Step Instance Table'].NOTEINDX = ['Record Notes Master'].NOTEINDX
22WFIncludeDocumentAttach SearchWorkflow Step Include Doc AttachCB_WorkflowIncludeDocAttachBoolean0
23WFIncludeWordTemplates SearchWorkflow Step Include Word TemplatesCB_WorkflowIncludeWordTemplatesBoolean0
24WFConditionProcessType SearchWorkflow Step Condition Process TypewfStepConditionProcessTypeInteger0
25WFStepReminderTimeLimit SearchWorkflow Step Reminder Time LimitINT5Integer4
26WFStepRemTimeLimitUofM SearchWorkflow Step Reminder Time Limit UofMDDL_WorkflowTimeLimitUofMInteger0
27DEX_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.
28DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)CompanyWorkflow Step Instance Table (WFI10003)

Leave a Reply

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