ODBC Driver for SugarCRM

Build 24.0.9062

Cases

The Cases table.

Columns

Name Type ReadOnly Description
Account_Id String False

The account to which the case is associated

Account_Name String False

The name of the account represented by the account_id field

Acl_Team_Names String True

Acl_Team_Set_Id String False

Action_Claim String True

Action_Close String True

Action_Unassign String True

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Attachment_List String True

Business_Center_Id String False

The business center to which the case is associated

Business_Center_Name String True

The name of the business center represented by the business_center_id field

Business_Hours_To_Resolution Decimal True

How long it took to resolve this issue, in decimal business hours

Business_Hrs_To_First_Response Decimal True

Case_Number Int False

Visual unique identifier

Commentlog String True

Created_By String True

User who created record

Created_By_Name String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

First_Response_Actual_Datetime Datetime True

First_Response_Sent Bool False

First_Response_Sla_Met String False

First_Response_Target_Datetime Datetime True

First_Response_User_Id String False

First_Response_User_Name String True

First_Response_Var_From_Target Decimal True

Follow_Up_Datetime Datetime False

Deadline for following up on an issue

Following Bool False

Is user following this record

Hours_To_First_Response Decimal True

Hours_To_Resolution Decimal True

How long it took to resolve this issue, in decimal calendar hours

Id [KEY] String True

Unique identifier

Is_Escalated Bool True

Is this escalated?

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

The short description of the bug

Pending_Processing Bool True

Perform_Sugar_Action Bool False

Portal_Viewable Bool False

Primary_Contact_Id String False

Primary_Contact_Name String True

Priority String False

The priority of the case

Request_Close Bool True

The request close status of the case

Request_Close_Date Datetime True

The date/time that the request close was initiated

Resolution String False

The resolution of the case

Resolved_Datetime Datetime False

Date when an issue is resolved

Service_Level String True

Service level of the associated account of case

Source String False

An indicator of how the case was entered (ex: via web, email, etc.)

Source_Id String False

Source_Meta String False

Source_Type String False

Status String False

The status of the case

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

Type String False

The type of issue (ex: issue, feature)

Widget_Follow_Up_Datetime String True

Widget_Status String True

Work_Log String False

Free-form text used to denote activities of interest

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