Notes
The Notes table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False |
Name of the note |
| 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 |
| File_Mime_Type | String | False |
Attachment MIME type |
| File_Ext | String | False | |
| File_Source | String | False |
The name of the module where the attachment originated |
| File_Size | Int | True |
Attachment File Size |
| File_Url | String | False |
Path to file (can be URL) |
| Filename | String | True |
File name associated with the note (attachment) |
| Upload_Id | String | False |
File id under uploads/ dir. Set only for email attachments |
| Email_Type | String | False |
The module of the record to which this note's file is attached (Emails or EmailTemplates) |
| Email_Id | String | False |
Email or EmailTemplate ID to which this note is attached |
| Note_Parent_Id | String | False |
The parent Note ID |
| Parent_Type | String | True |
Sugar module the Note is associated with |
| Parent_Id | String | False |
The ID of the Sugar item specified in parent_type |
| Contact_Id | String | False |
Contact ID note is associated with |
| Portal_Flag | Bool | False |
Portal flag indicator determines if note created via portal |
| Embed_Flag | Bool | False |
Embed flag indicator determines if note embedded in email |
| Parent_Name | String | True | |
| Contact_Name | String | True | |
| Contact_Phone | String | True | |
| Contact_Email | String | False | |
| Account_Id | String | False | |
| Opportunity_Id | String | False | |
| Acase_Id | String | False | |
| Lead_Id | String | False | |
| Product_Id | String | False | |
| Quote_Id | String | False | |
| User_Name | String | True | |
| External_Id | String | False |
External id of the external user |
| Entry_Source | String | True |
Determines if a record was created internal to the system or external to the system |
| Attachment_Flag | Bool | True |
Identify this note as an attachment to another record |
| Attachment_List | String | True | |
| 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 | |
| Source_Id | String | False | |
| Source_Type | String | False | |
| Source_Meta | String | False |