JDBC Driver for SugarCRM

Build 23.0.8839

Tasks

The Tasks 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

Status String False

Date_Due_Flag Bool False

Date_Due Datetime False

Time_Due Datetime False

Date_Start_Flag Bool False

Date_Start Datetime False

Parent_Type String True

The Sugar object to which the call is related

Parent_Name String True

Parent_Id String False

Contact_Id String False

Contact_Name String True

Contact_Phone String True

Contact_Email String False

Priority 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

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name 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

Dri_Workflow_Id String False

Dri_Workflow_Name String True

Dri_Subworkflow_Id String False

Dri_Subworkflow_Name String True

Dri_Subworkflow_Template_Id String False

Dri_Subworkflow_Template_Name String True

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Dri_Workflow_Task_Template_Id String False

Cj_Activity_Tpl_Name String True

Dri_Workflow_Sort_Order String False

Cj_Actual_Sort_Order String False

Customer_Journey_Score Int True

Cj_Momentum_Points Int True

Cj_Momentum_Score Int True

Cj_Allow_Activity_By String False

Customer_Journey_Progress Double True

Cj_Momentum_Ratio Double True

Customer_Journey_Points String False

Cj_Parent_Activity_Type String False

Customer_Journey_Blocked_By String False

Cj_Blocked_By_Stages String False

Is_Cj_Parent_Activity Bool False

Is_Customer_Journey_Activity Bool False

Cj_Momentum_Start_Date Datetime False

Cj_Momentum_End_Date Datetime False

Cj_Url String False

Cj_Parent_Activity_Id String False

Start_Next_Journey_Id String False

Customer_Journey_Type String False

Cj_Activity_Start_Date Datetime True

Cj_Activity_Completion_Date Datetime True

Cj_Days_To_Complete String True

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