SSIS Components for SugarCRM

Build 24.0.9062

Documents

The Documents table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Active_Date Date False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Category_Id String False

Commentlog String True

Contract_Name String False

Contract_Status String False

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

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

Document_Name String False

Document_Revision_Id String False

Exp_Date Date False

Filename String False

The filename of the document attachment

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

Is_Shared Bool False

Is_Template Bool False

Last_Rev_Create_Date String True

Last_Rev_Created_Name String False

Last_Rev_Mime_Type String False

Latest_Revision String False

Latest_Revision_File_Ext String True

Latest_Revision_File_Mime_Type String True

Latest_Revision_File_Size String True

Latest_Revision_Id String False

Latest_Revision_Name String False

Linked_Id 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

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

Revision String False

Selected_Revision_Filename String False

Selected_Revision_Id String False

Selected_Revision_Name String False

Status String False

Document status for Meta-Data framework

Status_Id String False

Subcategory_Id 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

Template_Type String False

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