CData Python Connector for SugarCRM

Build 25.0.9454

Reports

Stores report definitions and display parameters. This table supports operational reporting, metrics visualization, and data analysis.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

The list of team names that are associated with this report. This value supports collaboration, access control, and visibility filtering.

Acl_Team_Set_Id String False

The Id of the set of teams that have access to this report. This value is used to manage shared permission assignments.

Assigned_User_Id String False

The unique identifier (Id) of the user who is responsible for this report. This assignment determines ownership and workflow accountability.

Assigned_User_Name String True

The display name of the user who is assigned to this report. This value is shown in the user interface for clarity and reporting.

Chart_Type String False

The chart style or visualization format that is associated with the report, such as bar, pie, or trend. This value influences how report results are displayed.

Content String True

The stored definition of the report, including filters, fields, display settings, and data logic. This value represents the underlying report configuration.

Created_By String True

The Id of the user who created this report record. This value identifies the report author for auditing and ownership tracking.

Created_By_Name String True

The display name of the user who created this report record. This value is shown in the user interface for readability.

Date_Entered Datetime True

The date and time when this report record was created. This value supports historical tracking and timeline analysis.

Date_Modified Datetime True

The date and time when this report record was most recently updated. This field supports change tracking and review visibility.

Deleted Bool False

A Boolean field that returns a value of 'true' when this report record is marked as deleted. It returns a value of 'false' when the record remains active and available for use.

Description String False

A detailed explanation of the report's purpose, content, or usage context. This field can contain notes, rationale, or documentation.

Favorite Bool False

A Boolean field that returns a value of 'true' when the record is marked as a favorite. It returns a value of 'false' when it is not marked as a favorite.

Id [KEY] String True

The Id for this report record. This value is used to reference and manage the report across the system.

Is_Published Bool False

A Boolean field that returns a value of 'true' when the report is visible to other users or is shared within the organization. It returns a value of 'false' when the report is private or unpublished.

Last_Run_Date Datetime False

The date and time when this report was most recently executed. This value supports performance monitoring and scheduling analysis.

Modified_By_Name String True

The display name of the user who most recently modified this report record. This value provides visibility into recent updates.

Modified_User_Id String True

The Id of the user who most recently updated this report record. This field identifies the source of the latest modification.

Module String False

The module that the report is based on. This value determines which dataset the report queries.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the record is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite.

Name String False

The name of the report. This value is used as the primary label throughout the system.

Report_Cache_Id String False

The Id of the cached version of the report results, if caching is enabled. This value is used to improve performance for repeated report execution.

Report_Type String False

The classification of the report (for example, 'summary', 'matrix', or 'detailed'). This value determines how data is grouped and presented.

Schedule_Type String False

The scheduling configuration that determines how and when the report runs automatically. This value supports recurring report delivery.

Sync_Key String True

The synchronization key that is used to match this report record with external systems. This value ensures data consistency across integrations.

Tag String False

The tags that are associated with this report. Tags support flexible grouping, organization, and filtering across records.

Team_Count String False

The number of teams that are associated with this report. This value indicates collaboration scope and access distribution.

Team_Id String False

The Id of the primary team that is responsible for this report. This value establishes ownership for permissions and visibility.

Team_Name String False

The display name of the primary team that is associated with this report. This value is shown in the interface and reporting outputs.

Team_Set_Id String False

The Id of the set of teams that share access to this report. This value supports multi-team collaboration and permission configuration.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454