JDBC Driver for SugarCRM

Build 22.0.8462

Tasks

This is a table representing the Tasks module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is the favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

The unique identifier of the record.

Name String False

The name of the task.

Date_Entered Datetime True

The date the record was created.

Date_Modified Datetime True

The date the record was last modified.

Modified_User_Id String True

The Id of the user who last modified the record.

Modified_By_Name String True

The name of the user who last modified the record.

Created_By String True

The Id of the user who created the record.

Created_By_Name String True

The name of the user who created the record.

Doc_Owner String False

The document owner.

User_Favorites String False

The favorites of the user.

Description String False

The full text of the note.

Deleted Bool False

The record deletion indicator.

Assigned_User_Id String False

The Id of the user assigned to the record.

Assigned_User_Name String False

The name of the user assigned to the record.

Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Status String False

The status of the task.

Date_Due_Flag Bool False

Whether the task has a due date.

Date_Due String False

The due date of the task.

Time_Due Datetime False

The time the task is due.

Date_Start_Flag Bool False

Whether the flag has a start date.

Date_Start String False

The start date of the task.

Parent_Type String False

The type of the Sugar item to which the call is related.

Parent_Name String False

The name of the Sugar item to which the call is related.

Parent_Id String False

The Id of the Sugar item to which the call is related.

Contact_Id String False

The Id of the associated contact.

Contact_Name String False

The name of the associated contact.

Contact_Phone String True

The phone of the associated contact.

Contact_Email String False

The email of the associated contact.

Priority String False

The priority of the task.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462