JDBC Driver for SugarCRM

Build 23.0.8839

KBContents

The KBContents 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

Kbdocument_Body String True

Article body

Language String False

Active_Date Date False

Exp_Date Date False

Approved Bool False

Status String False

Viewcount Int True

Revision Int True

Useful Int True

Notuseful Int True

Attachment_List String True

Kbdocument_Id String False

Kbdocument_Name String True

Active_Rev String True

Active revision flag

Is_External String True

External article flag

Kbarticle_Id String False

Kbarticle_Name String True

Related_Languages String False

Kbsapprover_Id String False

User who approved article

Kbsapprover_Name String True

Kbscase_Id String False

Related case

Kbscase_Name String True

Category_Id String False

Category ID

Category_Name String True

Usefulness_User_Vote String True

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

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

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Parent_Name String False

Kbcontents_Calls_1_Name String True

Kbcontents_Calls_1calls_Idb String False

Parent_Id String False

Parent_Type String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839