ODBC Driver for SugarCRM

Build 24.0.9062

Tasks

The Tasks table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Cj_Activity_Completion_Date Datetime True

Cj_Activity_Start_Date Datetime True

Cj_Activity_Tpl_Name String True

Cj_Actual_Sort_Order String False

Cj_Allow_Activity_By String False

Cj_Blocked_By_Stages String False

Cj_Days_To_Complete String True

Cj_Momentum_End_Date Datetime False

Cj_Momentum_Points Int True

Cj_Momentum_Ratio Double True

Cj_Momentum_Score Int True

Cj_Momentum_Start_Date Datetime False

Cj_Parent_Activity_Id String False

Cj_Parent_Activity_Type String False

Cj_Url String False

Commentlog String True

Contact_Email String False

Contact_Id String False

Contact_Name String True

Contact_Phone String True

Created_By String True

User who created record

Created_By_Name String True

Customer_Journey_Blocked_By String False

Customer_Journey_Points String False

Customer_Journey_Progress Double True

Customer_Journey_Score Int True

Customer_Journey_Type String False

Date_Due Datetime False

Date_Due_Flag Bool False

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Date_Start Datetime False

Date_Start_Flag Bool False

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Dri_Subworkflow_Id String False

Dri_Subworkflow_Name String True

Dri_Subworkflow_Template_Id String False

Dri_Subworkflow_Template_Name String True

Dri_Workflow_Id String False

Dri_Workflow_Name String True

Dri_Workflow_Sort_Order String False

Dri_Workflow_Task_Template_Id String False

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

Is_Cj_Parent_Activity Bool False

Is_Customer_Journey_Activity Bool False

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

Parent_Id String False

Parent_Name String True

Parent_Type String True

The Sugar object to which the call is related

Priority String False

Start_Next_Journey_Id String False

Status String False

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Time_Due Datetime False

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