Table Wf_Routes

Entity

Contains document routes, which specify which document generation procedures will be run upon document events. Entity: Wf_Routes

Owner Tables Hierarchy

Gen_Document_Types

Summary

Name	Type	Description
Activation_Date	`date`	The date from which (including) the route is active. The date is matched against the document date of the generating document.
Active	`bit`	1 if the route is active, otherwise 0.
Allow_Obsolete_Generation	`bit`	Allows the usage of unsupported generation procedures (marked as obsolete). This is a user override of the system prohibition of the usage of obsolete procedures.
Allowed_Generation_Types	`char(1)` Allowed: `A`, `B`, `M`	Determines the possible types of the generation of the destination document: A=Auto, M=Manual, B=Both (Auto and Manual)
Condition_Enterprise_Company_Id	`uniqueidentifier`	The enterprise company for which this route is activated.
Condition_Filter_XML	`nvarchar(max)`	Contains filter condition, which the document must match in order to execute the route.
Condition_States_Bit_Mask	`int`	The system states for which to execute the specified route.
Condition_User_Status_Id	`uniqueidentifier`	The user-defined status, for which the document route is activated.
Connected_Party_Condition	`char(1)` Allowed: `A`, `C`, `U`	A - any party; C - connected party: to_party is enterprise company; U - unconnected party - not enterprise company;
Deactivation_Date	`date`	The date until (including) the route is active. The date is matched against the document date of the generating document. Null means the route does not have a deactivation date.
Destination_Document_Type_Id	`uniqueidentifier`	The type of the document, that will be generated by executing the route.
Destination_Enterprise_Company_Id	`uniqueidentifier`	The enterprise company in which to generate the target document.
Destination_Enterprise_Company_Location_Id	`uniqueidentifier`	The enterprise company location in which to generate the target document.
Destination_State	`smallint` Allowed: `0`, `10`, `20`, `30`, `40`, `50`	0=New;10=Computer Planned;20=Human Planned;30=Released;40=Completed;50=Closed
Destination_User_Status_Id	`uniqueidentifier`	The user defined status to set to the generated document.
Document_Type_Id	`uniqueidentifier`	The document type from which this route originates. Documents from this type generate sub-documents using this route.
Negative_Condition_Filter_Xml	`nvarchar(max)`	The negative condition should NOT be matched by the document in order to execute the route.
Notes	`nvarchar(254)`
Parent_Document_Relationship_Type	`char(1)` Allowed: `S`, `N`, `I`	Determines the default relationship type between the generated document and the parent document.
Procedure_Name	`nvarchar(254)`	The system name of the generation procedure, which must be executed by the route.
Process_Event	`nvarchar(254)`	Event which triggers the route. Usually the event is change of state. Every document entity may define own custom events.
Read_Only	`bit`	Indicates wheather the destination document shoul be read only. 1 - the destination document is read only
Route_Id	`uniqueidentifier` `PK`
Row_Version	`timestamp`
Schema_XML	`nvarchar(max)`	Not used.

Columns

Activation_Date

The date from which (including) the route is active. The date is matched against the document date of the generating document.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	CurrentDate
Enter Stop	no
Format	d
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	date
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Activation_Date - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	no

Active

1 if the route is active, otherwise 0.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	True
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Active - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Allow_Obsolete_Generation

Allows the usage of unsupported generation procedures (marked as obsolete). This is a user override of the system prohibition of the usage of obsolete procedures.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Allowed_Generation_Types

Determines the possible types of the generation of the destination document: A=Auto, M=Manual, B=Both (Auto and Manual)

Property	Value
Allowed Values	`A`, `B`, `M`
Auto Complete	no
Data Filter	no
Default Value	B
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	char(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Allowed_Generation_Types - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Condition_Enterprise_Company_Id

The enterprise company for which this route is activated.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Enterprise_Companies
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Condition_Enterprise_Company_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Condition_Filter_XML

Contains filter condition, which the document must match in order to execute the route.

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	yes
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2147483647
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(max) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Condition_States_Bit_Mask

The system states for which to execute the specified route.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	int
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Condition_States_Bit_Mask - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Like	None	no	no

Condition_User_Status_Id

The user-defined status, for which the document route is activated.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Document_Type_User_Statuses
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Condition_User_Status_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Connected_Party_Condition

A - any party; C - connected party: to_party is enterprise company; U - unconnected party - not enterprise company;

Property	Value
Allowed Values	`A`, `C`, `U`
Auto Complete	no
Data Filter	no
Default Value	A
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	char(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Deactivation_Date

The date until (including) the route is active. The date is matched against the document date of the generating document. Null means the route does not have a deactivation date.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Format	d
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	date (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Deactivation_Date - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	yes	no

Destination_Document_Type_Id

The type of the document, that will be generated by executing the route.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Document_Types
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Destination_Document_Type_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Destination_Enterprise_Company_Id

The enterprise company in which to generate the target document.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Enterprise_Companies
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Destination_Enterprise_Company_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Destination_Enterprise_Company_Location_Id

The enterprise company location in which to generate the target document.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Cm_Company_Locations
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Destination_Enterprise_Company_Location_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Destination_State

0=New;10=Computer Planned;20=Human Planned;30=Released;40=Completed;50=Closed

Property	Value
Allowed Values	`0`, `10`, `20`, `30`, `40`, `50`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	smallint
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Destination_User_Status_Id

The user defined status to set to the generated document.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Document_Type_User_Statuses
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Destination_User_Status_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Document_Type_Id

The document type from which this route originates. Documents from this type generate sub-documents using this route.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Document_Types
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Document_Type_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Negative_Condition_Filter_Xml

The negative condition should NOT be matched by the document in order to execute the route.

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	yes
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2147483647
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(max) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Notes

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(254) (Allows NULL)
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Parent_Document_Relationship_Type

Determines the default relationship type between the generated document and the parent document.

Property	Value
Allowed Values	`S`, `N`, `I`
Auto Complete	no
Data Filter	no
Default Value	S
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	char(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Procedure_Name

The system name of the generation procedure, which must be executed by the route.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(254)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Process_Event

Event which triggers the route. Usually the event is change of state. Every document entity may define own custom events.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(254)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Process_Event - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Read_Only

Indicates wheather the destination document shoul be read only. 1 - the destination document is read only

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bit
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Route_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Route_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Schema_XML

Not used.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2147483647
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(max) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Table of Contents