Table Gen_Document_Type_Notifications

Entity

Entity: Systems.Documents.DocumentTypeNotifications

Provides notification addresses to be notified upon occurrence of different document events. Entity: Gen_Document_Type_Notifications

Owner Tables Hierarchy

Gen_Document_Types

Summary

Name	Type	Description
Document_Event	`nvarchar(254)`	The event which will trigger the notification
Document_Type_Id	`uniqueidentifier`	The document type for which this notification is set.
Document_Type_Notification_Id	`uniqueidentifier` `PK`	.
Filter_XML	`nvarchar(max)`	Filtering condition for the document. Only documents which match the filter will trigger the event
Row_Version	`timestamp`
State_Bit_Mask	`int`	The document states that will trigger the event
Status_Change_Direction	`nvarchar(1)` Allowed: `*`, `0`, `+`, `-`	Direction of status change. Positive when the new status is greater than the previous. Applicable values: Positive '+', Negative '-', No change '0', Any change '*'
To_Email_Address_List	`nvarchar(2048)`	List of email addressess to be notified
User_Status_Id	`uniqueidentifier`	When not NULL, specifies that the event will be triggered only on this user status

Columns

Document_Event

The event which will trigger the notification

Property	Value
Auto Complete	no
Data Filter	no
Default Value	StateChanging
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
Order	2
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	no

Document_Event - Supported Filters

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

Document_Type_Id

The document type for which this notification is set.

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	1
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	Medium
User Login	no
Visible	yes

Document_Type_Id - Supported Filters

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

Document_Type_Notification_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	0
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

Document_Type_Notification_Id - Supported Filters

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

Filter_XML

Filtering condition for the document. Only documents which match the filter will trigger the event

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	6
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

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

State_Bit_Mask

The document states that will trigger the event

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	3
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

Status_Change_Direction

Direction of status change. Positive when the new status is greater than the previous. Applicable values: Positive '+', Negative '-', No change '0', Any change '*'

Property	Value
Allowed Values	`*`, `0`, `+`, `-`
Auto Complete	no
Data Filter	no
Default Value	*
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1
Order	5
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(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

To_Email_Address_List

List of email addressess to be notified

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	2048
Order	7
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(2048)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

User_Status_Id

When not NULL, specifies that the event will be triggered only on this user status

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	4
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

User_Status_Id - Supported Filters

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

Table of Contents