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