EmbeddedFiles
Stores embedded binary file attachments that are linked to CRM entities. This table supports documentation, artifact sharing, and reference file management.
Columns
| Name | Type | ReadOnly | Description |
| Created_By | String | True |
The unique identifier (Id) of the user who created this embedded file record. This value provides traceability for audit review and data stewardship. |
| Created_By_Name | String | True |
The display name of the user who created this embedded file record. This value is used in user interfaces and reporting contexts. |
| Date_Entered | Datetime | True |
The date and time when this embedded file record was created. This timestamp supports auditing and chronological sorting. |
| Date_Modified | Datetime | True |
The date and time when this embedded file record was last updated. This timestamp helps track change history. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this embedded file record is marked as deleted within SugarCRM. It returns a value of 'false' when the record is active and available. |
| Description | String | False |
The full text description or narrative note that explains the purpose, context, or content of the embedded file. Users often use this field to provide meaning or usage notes for the file. |
| File_Mime_Type | String | False |
The content type of the embedded file. This value identifies the file format (for example, 'text/plain', 'application/pdf', 'image/png') and allows systems to determine how to process or display the file. |
| Filename | String | True |
The original name of the file at the time it was uploaded. This value is preserved to help users recognize and retrieve the file. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this embedded file record for activity updates. It returns a value of 'false' when the record is not being followed. |
| Id [KEY] | String | True |
The unique Id for this embedded file record. The system uses this Id to reference and manage the record internally. |
| Locked_Fields | String | True |
The list of fields that are locked for this embedded file record. Locked fields cannot be edited and are typically restricted to preserve data integrity. |
| Modified_By_Name | String | True |
The display name of the user who last modified this embedded file record. This value supports review and audit workflows. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this embedded file record. This field provides traceability for change control. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the current user has marked this embedded file record as a favorite for quick access. It returns a value of 'false' when the record is not marked as a favorite. |
| Name | String | False |
The display name or title that is associated with this embedded file record. This value is often used to identify or categorize the file in lists and search results. |
| Sync_Key | String | True |
The synchronization key that is used to align this embedded file record with external systems or integration processes. Synchronization keys ensure consistent record matching across data sources. |