DocumentRevisions
Stores historical revisions of documents. This table supports version history tracking, rollback, and document change auditing.
Columns
| Name | Type | ReadOnly | Description |
| Change_Log | String | False |
A descriptive summary of the changes that are introduced in this document revision. This field is often used to record user notes or revision history commentary. |
| Created_By | String | True |
The unique identifier (Id) of the user who created the document revision record. |
| Created_By_Name | String | True |
The display name of the user who created the document revision record. |
| Date_Entered | Datetime | True |
The date and time when the document revision record was created. |
| Date_Modified | Datetime | True |
The date and time when the document revision record was most recently modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the document revision record is marked for deletion. It returns a value of 'false' when the record remains active under standard soft-delete behavior. |
| Doc_Id | String | False |
The Id of the document that is stored in an external document storage provider that is integrated with Sugar. |
| Doc_Type | String | False |
The document provider type (for example, 'Google Drive', 'Microsoft OneDrive', 'Box', or 'IBM SmartCloud'. |
| Doc_Url | String | False |
The URL that references the externally stored document, enabling retrieval through the linked storage provider. |
| Document_Id | String | False |
The Id of the associated document record within Sugar's Documents module. |
| Document_Name | String | False |
The display name of the associated document in Sugar's Documents module. |
| File_Ext | String | False |
The file extension of the uploaded document revision (for example, 'PDF', 'DOCX', or 'XLSX'). |
| File_Mime_Type | String | False |
The content type that identifies the format of the document revision file for upload, preview, and download compatibility. |
| File_Size | Int | True |
The size of the document revision file, represented in bytes. |
| Filename | String | False |
The original filename of the document at the time the revision was uploaded. |
| Id [KEY] | String | True |
The Id for the document revision record. |
| Latest_Revision | String | False |
An indicator that identifies whether this revision is the most recent version of the document. |
| Latest_Revision_Id | String | False |
The Id of the most recent revision that is associated with the document, allowing direct retrieval of the current file version. |
| Related_Document_Name | String | True |
The name of the document record that is associated with this revision when displayed in lists and selection views. |
| Revision | String | False |
The revision label or sequence identifier that is assigned to this version, such as a version number or iteration code. |