CData Python Connector for SugarCRM

Build 25.0.9454

ProspectLists

Stores targeted prospect list definitions that are used for marketing outreach. This table supports segmentation, campaign targeting, and audience selection.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

The list of team names that are associated with this prospect list. This value is used for access control, collaboration, and visibility filtering.

Acl_Team_Set_Id String False

The identifier (Id) of the set of teams that have access to this prospect list. This value is used to manage shared permissions across multiple teams.

Assigned_User_Id String False

The Id of the user who is assigned to manage this prospect list. This value determines responsibility for list maintenance and campaign coordination.

Assigned_User_Name String True

The display name of the user who is assigned to this prospect list. This value enhances readability in the user interface and reports.

Commentlog String True

The comment log entries that are associated with this prospect list. This field stores notes, discussion history, or collaboration context.

Created_By String True

The Id of the user who created this prospect list 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 prospect list record. This value is shown in the user interface for clarity and review.

Date_Entered Datetime True

The date and time when this prospect list record was created. This value provides context for list lifecycle management and historical review.

Date_Modified Datetime True

The date and time when this prospect list record was most recently updated. This field supports change tracking and audit visibility.

Deleted Bool False

A Boolean field that returns a value of 'true' when this prospect list 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 description of the prospect list. This field can include audience criteria, campaign usage notes, segmentation guidance, or business context.

Domain_Name String False

The domain that is associated with this prospect list, when the list is configured to group contacts or leads by email domain. This value supports segmentation and outbound targeting.

Entry_Count Int True

The total number of members that are currently included in this prospect list. This value helps measure audience size for targeting and campaign planning.

Id [KEY] String True

The unique Id for this prospect list record. This value is used to reference the list across marketing campaigns, reporting, and related modules.

List_Type String False

The classification of this prospect list, such as default, test, suppression, or marketing. This value determines how the list is used within marketing workflows.

Marketing_Id String False

The Id of the marketing campaign that is associated with this prospect list. This value establishes the link between the list and campaign execution activities.

Marketing_Name String False

The display name of the marketing campaign that is associated with this prospect list. This field supports readability and reporting.

Modified_By_Name String True

The display name of the user who most recently modified this prospect list record. This value provides transparency into list maintenance activity.

Modified_User_Id String True

The Id of the user who most recently updated this prospect list record. This field identifies the source of recent changes.

Name String False

The name of the prospect list. This value is used as the primary label throughout the system when selecting, managing, or reporting on the list.

Tag String False

The tags that are associated with this prospect list. Tags allow for flexible grouping, categorization, and search filtering across marketing and CRM modules.

Team_Count String False

The number of teams that are associated with this prospect list. This value indicates the scale of collaboration and access distribution.

Team_Id String False

The Id of the primary team responsible for this prospect list. This value establishes core ownership for permissions and visibility.

Team_Name String False

The display name of the primary team that is associated with this prospect list. This value is shown in the user interface and reports for clarity.

Team_Set_Id String False

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

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