Diagrams

Table

Workflow Step Instance

DynamicsDocs.comWorkflow Step Instance«Table 1504»Workflow Step InstanceID [PK]Workflow Code [PK]Workflow Step ID [PK]DescriptionEntry PointRecord IDCreated Date-TimeCreated By User IDLast Modified Date-TimeLast Modified By User IDStatus; [Inactive,Active,Completed,Ign...Previous Workflow Step IDNext Workflow Step IDType; [Event,Response]Function NameArgumentOriginal Workflow CodeOriginal Workflow Step IDSequence No.«Table 1506»Workflow Table Relation ValueWorkflow Step Instance ID [PK]Workflow Code [PK]Workflow Step ID [PK]Table ID [PK]Field ID [PK]Related Table ID [PK]Related Field ID [PK]ValueRecord ID«Table 1524»Workflow RuleID [PK]Table IDField No.Operator; [Increased,Decreased,Changed...Workflow Code [PK]Workflow Step ID [PK]Field CaptionWorkflow Step Instance ID«Table 1502»Workflow StepID [PK]Workflow Code [PK,NN]DescriptionEntry PointPrevious Workflow Step IDNext Workflow Step IDType; [Event,Response,Sub-Workflow]Function NameArgumentSequence No.«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 1520»Workflow EventFunction Name [PK,NN]Table IDDescriptionRequest Page IDDynamic Req. Page Entity NameUsed for Record ChangeIndependent«Table 1521»Workflow ResponseFunction Name [PK,NN]Table IDDescriptionResponse Option GroupIndependent«Table 1523»Workflow Step ArgumentID [PK]Type; [Event,Response]General Journal Template NameGeneral Journal Batch NameNotification User IDNotification User License Type; [Full...Response Function NameLink Target PageCustom LinkEvent ConditionsApprover Type; [Salesperson/Purchaser,...Approver Limit Type; [Approver Chain,D...Workflow User Group CodeDue Date FormulaMessageDelegate After; [Never,1 day,2 days,5...Show Confirmation MessageTable No.Field No.Field CaptionApprover User IDResponse Type; [Not Expected,User ID]Response User IDResponse Option Group<Workflow Code><Workflow Step ID><Original Workflow Code><Original Workflow Step ID><Created By User ID><Last Modified By User ID><Function Name><Function Name><Argument><Workflow Step Instance ID><Workflow Code><Workflow Step ID><Workflow Step Instance ID><Workflow Step ID><Previous Workflow Step ID><Next Workflow Step ID><Function Name><Function Name><Argument><Type><Response Function Name>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 ID (ID) GUID
2 Workflow Code (Workflow Code) Code20
3 Workflow Step ID (Workflow Step ID) Integer
4 Description (Description) Text100
9 Entry Point (Entry Point) Boolean
11 Record ID (Record ID) RecordID
12 Created Date-Time (Created Date-Time) DateTime Editable: No
13 Created By User ID (Created By User ID) Code50 Editable: No
14 Last Modified Date-Time (Last Modified Date-Time) DateTime Editable: No
15 Last Modified By User ID (Last Modified By User ID) Code50 Editable: No
17 Status (Status) Option
18 Previous Workflow Step ID (Previous Workflow Step ID) Integer
19 Next Workflow Step ID (Next Workflow Step ID) Integer
21 Type (Type) Option
22 Function Name (Function Name) Code128
23 Argument (Argument) GUID
30 Original Workflow Code (Original Workflow Code) Code20
31 Original Workflow Step ID (Original Workflow Step ID) Integer
32 Sequence No. (Sequence No.) Integer

Keys

# Fields
0 ID,Workflow Code,Workflow Step ID (ID,Workflow Code,Workflow Step ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Last Modified By User ID (Last Modified By User ID) User User Name (User Name) 1..n
Function Name (Function Name) Workflow Event Function Name (Function Name) 1..n
Function Name (Function Name) Workflow Response Function Name (Function Name) 1..n
Original Workflow Step ID (Original Workflow Step ID) Workflow Step ID (ID) 1..n
Argument (Argument) Workflow Step Argument () 1..n

Table Relations From Other Tables

From Table From Field
Workflow Rule Workflow Step Instance ID (Workflow Step Instance ID) 1..n
Workflow Table Relation Value Workflow Step ID (Workflow Step ID) 1..n