JDBC Driver for SugarCRM

Build 22.0.8462

KBDocuments

Create, update, delete, and query the KBDocuments module in SugarCRM.

Columns

Name Type ReadOnly Description
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.

Id [KEY] String False

The unique identifier of the KB document.

Kbdocument_Name String False

The name of the KB document.

Name String False

The name of the KB document.

Body String False

The body of the KB document.

Active_Date Datetime False

The active date the KB document.

Exp_Date Datetime False

The expiration date of the KB document.

Status_Id String False

The Id of the status of the KB document.

Date_Entered Datetime False

The date the KB document was entered.

Date_Modified Datetime False

The date the KB document was last modified.

Deleted Bool False

Whether the KB document is deleted.

Is_External_Article Bool False

Whether the KB document is an external article.

Description String False

The description of the KB document.

Modified_User_Id String False

The Id of the user who last modified the KB document.

Created_By String False

The Id of the user who created the KB document.

Kbdocument_Revision_Id String False

The revision Id of the KB document.

Kbdocument_Revision_Number String False

The revision number of the KB document.

Latest_Revision String False

The latest revision of the KB document.

Last_Rev_Create_Date Datetime False

The date the latest revision was created.

Mail_Merge_Document Bool False

Whether the KB document is a Mail Merge document.

Related_Doc_Id String False

The Id of the related document.

Related_Doc_Rev_Id String False

The revision Id of the related document.

Is_Template Bool False

Whether the KB document is a template.

Template_Type String False

The template type of the KB document.

Latest_Revision_Name String False

The name of the latest revision of the KB document.

Selected_Revision_Name String False

The selected revision name of the KB document.

Contract_Status String False

The status of the contract associated with the KB document.

Contract_Name String False

The name of the contract associated with the KB document.

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.

Keywords String False

The keywords for the KB document.

Kbdoc_Approver_Id String False

The Id of the user who approved the KB document.

Kbdoc_Approver_Name String False

The name of the approver for the KB document.

Assigned_User_Id String False

The Id of the user assigned to the record.

Assigned_User_Name String False

The username of the user assigned to the record.

Views_Number String False

The number of views for the KB document.

Attachment_List String False

The attachment List for the KB document.

Parent_Id String False

The Id of the parent record for the KB document.

Parent_Type String False

The type of the parent record for the KB document.

Case_Id String False

The Id for the case associated with the KB document.

Case_Name String False

The name of the case associated with the KB document.

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