tbl_WorkflowItem [Workflow Items]

Terrasoft CRM 3.0 SDK > Basic Configuration > Tables > System > tbl_WorkflowItem [Workflow Items]

Contents

Index

tbl_WorkflowItem [Workflow Items]

Property	Value
Name	tbl_WorkflowItem
Caption	Workflow Items
Module	System
USI	System\Workflow\tbl_WorkflowItem
Table Group	No
Is administrated by field	No
Is administrated by record	No
Record change is logged	No

#	Name	Type	Name
1.	ID	Identifier	Workflow Item
2.	CreatedOn	Date/Time	Created On
3.	CreatedByID	Unique identifier GUID	Created By
4.	ModifiedOn	Date/Time	Modified On
5.	ModifiedByID	Unique identifier GUID	Modified By
6.	WorkflowID	Unique identifier GUID	Workflow
7.	DiagramItemName	Unicode string [250]	Diagram Item
8.	DiagramItemType	Integer	Diagram Item Type
9.	OwnerID	Unique identifier GUID	Owner
10.	StateID	Unique identifier GUID	Status
11.	ExecuteDate	Date/Time	Execution Date
12.	ActualExecuteDate	Date/Time	Actual Execute Date
13.	Name	Unicode string [250]	Name
14.	Parameters	Large binary object	Parameters

#	Relation name	Field	Table	Cascade relation
1.	FWorkflowItem_WorkflowID	WorkflowID	tbl_Workflow	Yes
2.	FWorkflowItem_OwnerID	OwnerID	tbl_Contact	No

#	Name	Unique	Structure
1.	IWorkflowItem	No	OwnerID
2.	IWorkflowItem1	No	WorkflowID

Copyright (с) Terrasoft 2002-2007.