JDBC Driver for SugarCRM

Build 22.0.8462

Notes

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

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the note is a favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

Unique identifier of the record.

Name String False

Name of the note.

Date_Entered Datetime True

Date the record was created.

Date_Modified Datetime True

The date the record was last modified.

Modified_User_Id String True

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

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

File_Mime_Type String False

Attachment MIME type.

File_Url String False

Path to file (can be a URL).

Filename String False

File name associated with the note (attachment).

Parent_Type String False

Sugar module the Note is associated with.

Parent_Id String False

The Id of the parent Sugar item.

Contact_Id String False

The Id of the contact the note is associated with.

Portal_Flag Bool False

Portal flag indicator, which determines if the note is created via portal.

Embed_Flag Bool False

Embed flag indicator, which determines if the note is embedded in an email.

Parent_Name String False

The name of the parent object associated with the note.

Contact_Name String False

The name of the contact associated with the note.

Contact_Phone String False

The phone number of the contact associated with the note.

Contact_Email String False

The email of the contact associated with the note.

Account_Id String False

The Id of the account associated with the note.

Opportunity_Id String False

The Id of the opportunity associated with the note.

Acase_Id String False

The Id of the case associated with the note.

Lead_Id String False

The Id of the lead associated with the note.

Product_Id String False

The Id of the product associated with the note.

Quote_Id String False

The Id of the quote associated with the note.

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