Power BI Connector for SugarCRM

Build 25.0.9454

Subscriptions

Stores subscription and feed-follow relationships. This table supports record tracking, content syndication, and notification preference management.

Columns

Name Type ReadOnly Description
Created_By String True

The unique identifier (Id) of the user who created this subscription record. This value identifies the record author for auditing and ownership tracking.

Created_By_Name String True

The display name of the user who created this subscription record. This value is shown in the user interface for clarity and reporting.

Date_Entered Datetime True

The date and time when this subscription record was created. This value supports lifecycle tracking and audit review.

Date_Modified Datetime True

The date and time when this subscription record was most recently updated. This field supports version history and change transparency.

Deleted Bool False

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

Description String False

A detailed description of the subscription. This field can include purpose notes, context, or usage details.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following this subscription to receive activity updates. It returns a value of 'false' when the user is not following the record.

Id [KEY] String True

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

Locked_Fields String True

The list of fields that are restricted from editing for this subscription record. This prevents modification of system-governed or protected values.

Modified_By_Name String True

The display name of the user who most recently modified this subscription record. This value provides visibility into the update history.

Modified_User_Id String True

The Id of the user who most recently updated this subscription record. This value identifies the source of the latest change.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the subscription 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 subscription. This value is used as the primary label throughout the system.

Parent_Id String False

The Id of the parent record that this subscription is linked to. This value establishes the relationship between the subscription and its related record.

Parent_Type String False

The module type of the parent record that is associated with this subscription (for example, 'Accounts', 'Contacts', or 'Opportunities').

Sync_Key String True

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

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