JDBC Driver for SugarCRM

Build 23.0.8839

Meetings

The Meetings table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String False

Meeting name

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

Accept_Status String False

Set_Accept_Links String False

Location String False

Meeting location

Password String False

Meeting password

Join_Url String False

Join URL

Host_Url String False

Host URL

Displayed_Url String False

Meeting URL

Creator String False

Meeting creator

External_Id String False

Meeting ID for external app API

Duration_Hours Int False

Duration (hours)

Duration_Minutes String False

Duration (minutes)

Date_Start Datetime False

Date of start of meeting

Date_End Datetime True

Date meeting ends

Parent_Type String True

Module meeting is associated with

Status String False

Meeting status (ex: Planned, Held, Not held)

Type String False

Meeting type (ex: WebEx, Other)

Direction String False

Indicates whether call is inbound or outbound

Parent_Id String False

ID of item indicated 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

Sequence Int True

Meeting update sequence for meetings as per iCalendar standards

Contact_Name String True

Parent_Name String True

Accept_Status_Users String False

Internal_Notes String False

Internal notes for the meeting

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 meeting. Original meeting start date

Recurring_Source String False

Source of recurring meeting

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)

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

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