ODBC Driver for SugarCRM

Build 23.0.8839

Calls

The Calls table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String False

Brief description of the call

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

Internal_Notes String False

Internal notes for the call

Duration_Hours Int False

Call duration, hours portion

Duration_Minutes String False

Call duration, minutes portion

Date_Start Datetime False

Date in which call is schedule to (or did) start

Date_End Datetime True

Date is which call is scheduled to (or did) end

Parent_Type String True

The Sugar object to which the call is related

Parent_Name String True

Status String False

The status of the call (Held, Not Held, etc.)

Direction String False

Indicates whether call is inbound or outbound

Parent_Id String False

The ID of the parent Sugar object identified by parent_type

Reminder_Checked Bool False

checkbox indicating whether or not the reminder value is set (Meta-data only)

Reminder_Time String False

Specifies 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

checkbox indicating whether or not the email reminder value is set (Meta-data only)

Email_Reminder_Time String False

Specifies 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 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

Set_Accept_Links String False

Contact_Name String True

Lead_Id String True

Lead_Name String True

Accept_Status_Users String False

Contact_Id String True

Repeat_Type String False

Type of recurrence

Repeat_Interval Int True

Interval of recurrence

Repeat_Dow String False

Days of week in recurrence

Repeat_Until Date False

Repeat until specified date

Repeat_Count Int True

Number of recurrence

Repeat_Selector String False

Repeat selector

Repeat_Days String False

Days of month

Repeat_Ordinal String False

Repeat ordinal value

Repeat_Unit String False

Repeat unit value

Repeat_Parent_Id String False

Id of the first element of recurring records

Recurrence_Id Datetime False

Recurrence ID of call. Original call start date

Recurring_Source String False

Source of recurring call

Send_Invites Bool False

checkbox indicating whether or not to send out invites (Meta-data only)

Invitees String True

Auto_Invite_Parent Bool False

Flag to allow for turning off auto invite of parent record - (Meta-data only)

Transcript String True

Aws_Contact_Id String True

The AWS Connect Contact ID

Call_Recording_Url String False

The URL for the call recording

Call_Recording String True

The friendly name for the call recording link

Aws_Lens_Data String False

Raw data from the aws lens service

Sentiment_Score_Agent Decimal True

The sentiment score for the agent ranging from -5 to 5

Sentiment_Score_Agent_String String True

Sentiment_Score_Customer Decimal True

The sentiment score for the customer ranging from -5 to 5

Sentiment_Score_Customer_String String True

Sentiment_Score_Agent_First_Quarter Decimal True

The sentiment score for the agent during the first quarter ranging from -5 to 5

Sentiment_Score_Agent_Second_Quarter Decimal True

The sentiment score for the agent during the second quarter ranging from -5 to 5

Sentiment_Score_Agent_Third_Quarter Decimal True

The sentiment score for the agent during the third quarter ranging from -5 to 5

Sentiment_Score_Agent_Fourth_Quarter Decimal True

The sentiment score for the agent during the fourth quarter ranging from -5 to 5

Sentiment_Score_Customer_First_Quarter Decimal True

The sentiment score for the customer during the first quarter ranging from -5 to 5

Sentiment_Score_Customer_Second_Quarter Decimal True

The sentiment score for the customer during the second quarter ranging from -5 to 5

Sentiment_Score_Customer_Third_Quarter Decimal True

The sentiment score for the customer during the third quarter ranging from -5 to 5

Sentiment_Score_Customer_Fourth_Quarter Decimal True

The sentiment score for the customer during the fourth quarter ranging from -5 to 5

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

Kbcontents_Calls_1_Name String True

Kbcontents_Calls_1kbcontents_Ida String False

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