Documents
Create, update, delete, and query the Documents module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the document is a favorite for the user. |
| Following | Bool | False |
Whether the user is following this record. |
| Id [KEY] | String | False |
The unique identifier for the record. |
| Name | String | False |
The name of the document. |
| Date_Entered | Datetime | True |
The date the record was created. |
| Date_Modified | Datetime | True |
The date the record was last modified. |
| Modified_User_Id | String | True |
The Id of 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 document. |
| Description | String | False |
The full text of the note. |
| Deleted | Bool | False |
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. |
| Document_Name | String | False |
The document name. |
| Doc_Id | String | False |
The document Id from the Web service provider for the document. |
| Doc_Type | String | False |
The document type (e.g., Google, box.net, or IBM SmartCloud). |
| Doc_Url | String | False |
The document URL from the Web service provider for the document. |
| Filename | String | False |
The file name of the document attachment. |
| Active_Date | Datetime | False |
The date the document is active. |
| Exp_Date | Datetime | False |
The date the document expires. |
| Category_Id | String | False |
The Id for the category of the document. |
| Subcategory_Id | String | False |
The Id of the subcategory of the document. |
| Status_Id | String | False |
The Id of the document status. |
| Status | String | False |
The document status. |
| Document_Revision_Id | String | False |
The Id of the document revision. |
| Revision | String | False |
The revision number. |
| Last_Rev_Created_Name | String | False |
The name of the user who created the last revision. |
| Last_Rev_Mime_Type | String | False |
The MIME type of the last revision. |
| Latest_Revision | String | False |
The latest revision. |
| Last_Rev_Create_Date | String | False |
The date the last revision was created. |
| Related_Doc_Id | String | False |
The Id of the related document. |
| Related_Doc_Name | String | False |
The related document name. |
| Related_Doc_Rev_Id | String | False |
The Id of the related document revision. |
| Related_Doc_Rev_Number | String | False |
The related document version number . |
| Is_Template | Bool | False |
Whether the document is a template. |
| Template_Type | String | False |
The template type of the document. |
| Latest_Revision_Name | String | False |
The name of the latest revision. |
| Selected_Revision_Name | String | False |
The name of the selected revision. |
| Contract_Status | String | False |
The contract status. |
| Contract_Name | String | False |
The name of the contract |
| Linked_Id | String | False |
The Id of the linked record. |
| Selected_Revision_Id | String | False |
The Id of the selected revision. |
| Latest_Revision_Id | String | False |
The Id of the latest revision. |
| Selected_Revision_Filename | String | False |
The filename of the selected revision. |