JDBC Driver for SugarCRM

Build 23.0.8839

DRI_Workflow_Task_Templates

The DRI_Workflow_Task_Templates table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String False

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Modified_User_Id String True

User who last modified record

Modified_By_Name String True

Created_By String True

User who created record

Created_By_Name String True

Description String False

Full text of the note

Deleted Bool False

Record deletion indicator

Task_Start_Date_Type String False

Task_Due_Date_Type String False

Momentum_Start_Type String False

Start_Date_Module String False

Due_Date_Module String False

Start_Date_Field String False

Due_Date_Field String False

Due_Date_Criteria String False

Momentum_Start_Module String False

Momentum_Start_Field String False

Priority String False

Type String False

Activity_Type String False

Duration_Minutes String False

Direction String False

Points String False

Momentum_Points String False

Send_Invite_Type String False

Target_Assignee String False

Assignee_Rule String False

Populate_Fields String False

Select_To_Guests String False

Allow_Activity_By String False

Time_Of_Day String False

Sort_Order String False

Task_Start_Days Int False

Task_Due_Days Int False

Momentum_Due_Days Int False

Momentum_Due_Hours Int False

Duration_Hours Int True

Duration Int True

Is_Parent Bool True

Blocked_By String False

Blocked_By_Stages String False

Url String False

Stage_Template_Label String True

Stage_Template_Sort_Order String True

Assignee_Rule_Activity_Id String False

Assignee_Rule_Activity_Name String False

Start_Date_Activity_Id String False

Start_Date_Activity_Name String False

Due_Date_Activity_Id String False

Due_Date_Activity_Name String False

Momentum_Start_Activity_Id String False

Momentum_Start_Activity_Name String False

Parent_Id String False

Parent_Name String True

Dri_Subworkflow_Template_Id String False

Dri_Subworkflow_Template_Name String False

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String False

Start_Next_Journey_Id String False

Start_Next_Journey_Name String True

Target_Assignee_User_Id String False

Target_Assignee_User_Name String False

Target_Assignee_Team_Id String False

Target_Assignee_Team_Name String False

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Tag String False

Commentlog String True

Locked_Fields String True

Sync_Key String True

Team_Id String False

Team ID for the account

Team_Set_Id String False

Acl_Team_Set_Id String False

Team_Count String False

Team_Name String False

Acl_Team_Names String True

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839