Table of Contents

Table Cm_Activity_Templates

Entity

Entity: General.Activities.ActivityTemplates

Templates for automatical generation of activity from any document. Entity: Cm_Activity_Templates

Summary

Name Type Description
Activity_Subject_Mask nvarchar(max) A mask that uses fields from the header table of the source document in the specified route and is used to fill the Subject of the generated activity.
Activity_Template_Id uniqueidentifier PK
Additional_Days int The number of days that will be added to the date in the Header_Date_Field. The result value is set to Start_Time of the activity.
Reminder_Time time The time of the day for the reminder
Responsible_Party_Id uniqueidentifier If Null the user that starts the generation route is responsible party of the activity.
Route_Id uniqueidentifier The route that uses this template
Row_Version timestamp
Source_Date_Field nvarchar(64) A name of a field from the header or the document table of the source document in the specified route, that will be used along with Additional_Days to set the Start_Time of the generated activity.
Start_Time time The time of the day when the activity starts

Columns

Activity_Subject_Mask

A mask that uses fields from the header table of the source document in the specified route and is used to fill the Subject of the generated activity.

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

Activity_Template_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

Activity_Template_Id - Supported Filters

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

Additional_Days

The number of days that will be added to the date in the Header_Date_Field. The result value is set to Start_Time of the activity.

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

Reminder_Time

The time of the day for the reminder

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

Reminder_Time - Supported Filters

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

Responsible_Party_Id

If Null the user that starts the generation route is responsible party of the activity.

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

Responsible_Party_Id - Supported Filters

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

Route_Id

The route that uses this template

Property Value
Auto Complete no
Data Filter no
Default Value None
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
Referenced Table Wf_Routes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width 100
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

Source_Date_Field

A name of a field from the header or the document table of the source document in the specified route, that will be used along with Additional_Days to set the Start_Time of the generated activity.

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

Start_Time

The time of the day when the activity starts

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 time
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Start_Time - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no
Suggest improvement to this page