ODBC Driver for SugarCRM

Build 24.0.9062

KBContents

The KBContents table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Active_Date Date False

Active_Rev String True

Active revision flag

Approved Bool False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Attachment_List String True

Category_Id String False

Category ID

Category_Name String True

Commentlog String True

Created_By String True

User who created record

Created_By_Name String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Exp_Date Date False

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

Is_External String True

External article flag

Kbarticle_Id String False

Kbarticle_Name String True

Kbdocument_Body String True

Article body

Kbdocument_Id String False

Kbdocument_Name String True

Kbsapprover_Id String False

User who approved article

Kbsapprover_Name String True

Kbscase_Id String False

Related case

Kbscase_Name String True

Language String False

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

Notuseful Int True

Related_Languages String False

Revision Int True

Status String False

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Useful Int True

Usefulness_User_Vote String True

Viewcount Int True

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