Documents
The Documents table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False | |
| 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 |
| Document_Name | String | False | |
| Doc_Id | String | False |
Document ID from documents web server provider |
| Doc_Type | String | True |
Document type (ex: Google, box.net, IBM SmartCloud) |
| Doc_Url | String | False |
Document URL from documents web server provider |
| Filename | String | False |
The filename of the document attachment |
| Active_Date | Date | False | |
| Exp_Date | Date | False | |
| Category_Id | String | False | |
| Subcategory_Id | String | False | |
| Is_Shared | Bool | False | |
| Status_Id | String | False | |
| Status | String | False |
Document status for Meta-Data framework |
| Document_Revision_Id | String | False | |
| Revision | String | False | |
| Last_Rev_Created_Name | String | False | |
| Last_Rev_Mime_Type | String | False | |
| Latest_Revision | String | False | |
| Latest_Revision_File_Mime_Type | String | True | |
| Latest_Revision_File_Size | String | True | |
| Latest_Revision_File_Ext | String | True | |
| Last_Rev_Create_Date | String | True | |
| Related_Doc_Id | String | False | |
| Related_Doc_Name | String | True |
The related document name for Meta-Data framework |
| Related_Doc_Rev_Id | String | False | |
| Related_Doc_Rev_Number | String | True |
The related document version number for Meta-Data framework |
| Is_Template | Bool | False | |
| Template_Type | String | False | |
| Latest_Revision_Name | String | False | |
| Selected_Revision_Name | String | False | |
| Contract_Status | String | False | |
| Contract_Name | String | False | |
| Linked_Id | String | False | |
| Selected_Revision_Id | String | False | |
| Latest_Revision_Id | String | False | |
| Selected_Revision_Filename | String | False | |
| 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 |