JDBC Driver for SugarCRM

Build 22.0.8462

Calls

Create, update, delete, and query the Calls module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is a favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

The unique identifier of the call.

Name String False

A brief description of the call.

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 user 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 user name of the user who created the record.

Doc_Owner String False

The document owner.

User_Favorites String False

The user favorites for the record.

Description String False

The full text of the note.

Deleted Bool False

Record deletion indicator.

Assigned_User_Id String False

The Id of the user assigned to the record.

Assigned_User_Name String False

The user 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.

Duration_Hours Int False

The hours portion of the call duration.

Duration_Minutes Int False

The minutes portion of the call duration.

Date_Start String False

The date when the call starts.

Date_End String False

The date when the call ends.

Parent_Type String False

The type of the parent Sugar object related to the call.

Parent_Name String False

The name of the parent Sugar object related to the call.

Status String False

The status of the call (e.g., Held or Not Held).

Direction String False

Indicates whether call is inbound or outbound.

Parent_Id String False

The Id of the parent Sugar object identified by .

Reminder_Checked Bool False

The checkbox indicating whether or not the reminder value is set.

Reminder_Time String False

When a reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.

Email_Reminder_Checked Bool False

The checkbox indicating whether or not the email reminder value is set.

Email_Reminder_Time String False

When a email reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.

Email_Reminder_Sent Bool False

Whether the email reminder is already sent.

Outlook_Id String False

When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id.

Accept_Status String False

The accept status of the call.

Set_Accept_Links String False

The accept links set for the call.

Contact_Name String False

The contact name for the call.

Accept_Status_Users String False

The accept status of the user.

Contact_Id String False

The Id of the contact for the call.

Repeat_Type String False

The type of recurrence.

Repeat_Interval Int False

The interval of recurrence.

Repeat_Dow String False

The days of week in recurrence.

Repeat_Until Datetime False

Repeat until the specified date.

Repeat_Count Int False

Number of recurrences.

Repeat_Parent_Id String False

The Id of the first element of recurring records.

Recurring_Source String False

The source of the recurring call.

Send_Invites Bool False

The checkbox indicating whether or not to send out invites.

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