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 TypeSQL DB LengthKeyable Length
1WorkflowStepInstanceID SearchWorkflow Step Instance IDGUIDStringString3836
2Workflow_Step_Name SearchWorkflow Step NameSTR50_LBAString5250
3WorkflowInstanceID SearchWorkflow Instance IDGUIDStringString3836
4Workflow_Name SearchWorkflow NameSTR50_LBAString5250
5Workflow_Version SearchWorkflow VersionINT7Long Integer47
6WF_Step_Description SearchWorkflow Step DescriptionSTR100String102100
7Workflow_Step_Status SearchWorkflow Step StatusWorkflow Step StatusInteger20
8Workflow_Step_Sequence SearchWorkflow Step SequenceINT7Long Integer47
9Workflow_Step_Type SearchWorkflow Step TypeDDL_Workflow_Step_TypeInteger20
10Workflow_Step_Order SearchWorkflow Step OrderGBInteger20
11Workflow_Step_Condition SearchWorkflow Step ConditionGBInteger20
12Workflow_Step_Conditions SearchWorkflow Step ConditionsGUIDStringString3836
13WF_Step_Predecessor SearchWorkflow Step PredecessorSTR50_LBAString5250
14Workflow_Step_Assign_To SearchWorkflow Step Assign ToGUIDStringString3836
15EmailMessageID SearchEmail Message IDSTR25_LBAUString2625
16Workflow_Step_Send_Email SearchWorkflow Step Send EmailCBBoolean20
17Workflow_Step_Time_Limit SearchWorkflow Step Time LimitINT5Integer24
18WF_Step_Time_Limit_UofM SearchWorkflow Step Time Limit UofMDDL_WorkflowTimeLimitUofMInteger20
19WF_Step_Completion_Polic SearchWorkflow Step Completion PolicyGBInteger20
20WF_Apply_WF_Calendar SearchWorkflow Apply Workflow CalendarCB Apply Workflow CalendarBoolean20
21NOTEINDX SearchNote IndexDLR14Currency1014
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_WorkflowIncludeDocAttachBoolean20
23WFIncludeWordTemplates SearchWorkflow Step Include Word TemplatesCB_WorkflowIncludeWordTemplatesBoolean20
24WFConditionProcessType SearchWorkflow Step Condition Process TypewfStepConditionProcessTypeInteger20
25WFStepReminderTimeLimit SearchWorkflow Step Reminder Time LimitINT5Integer24
26WFStepRemTimeLimitUofM SearchWorkflow Step Reminder Time Limit UofMDDL_WorkflowTimeLimitUofMInteger20
27DEX_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.
28DEX_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.

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

Leave a Reply

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