ODBC Driver for SugarCRM

Build 24.0.9062

Notes

The Notes table.

Columns

Name Type ReadOnly Description
Acase_Id String False

Account_Id String False

Acl_Team_Names String True

Acl_Team_Set_Id String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Attachment_Flag Bool True

Identify this note as an attachment to another record

Attachment_List String True

Base_Rate Decimal False

Commentlog String True

Contact_Email String False

Contact_Id String False

Contact ID note is associated with

Contact_Name String True

Contact_Phone String True

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

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

Email_Id String False

Email or EmailTemplate ID to which this note is attached

Email_Type String False

The module of the record to which this note's file is attached (Emails or EmailTemplates)

Embed_Flag Bool False

Embed flag indicator determines if note embedded in email

Entry_Source String True

Determines if a record was created internal to the system or external to the system

Expense_To_Operation_C Decimal False

External_Id String False

External id of the external user

File_Ext String False

File_Mime_Type String False

Attachment MIME type

File_Size Int True

Attachment File Size

File_Source String False

The name of the module where the attachment originated

File_Url String False

Path to file (can be URL)

Filename String True

File name associated with the note (attachment)

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

Lead_Id String False

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

Name of the note

Note_Parent_Id String False

The parent Note ID

Opportunity_Id String False

Parent_Id String False

The ID of the Sugar item specified in parent_type

Parent_Name String True

Parent_Type String True

Sugar module the Note is associated with

Portal_Flag Bool False

Portal flag indicator determines if note created via portal

Product_Id String False

Quote_Id String False

Source_Id String False

Source_Meta String False

Source_Type String False

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

Upload_Id String False

File id under uploads/ dir. Set only for email attachments

User_Name String True

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