JDBC Driver for SugarCRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462