Power BI Connector for SugarCRM

Build 25.0.9454

ContractTypes

Stores contract type classification records. This table supports contract grouping, reporting segmentation, and standardized contract processing.

Columns

Name Type ReadOnly Description
Commentlog String True

A free-form text field that is used to store internal comments about the contract type. This field supports collaboration and communication among CRM users.

Created_By String True

The identifier (Id) of the user who created the contract type record. This field supports record lineage and audit tracking.

Created_By_Name String True

The display name of the user who created the contract type record.

Date_Entered Datetime True

The date and time when the contract type record was created.

Date_Modified Datetime True

The date and time when the contract type record was last modified.

Deleted Bool False

A Boolean field that returns a value of 'true' when the contract type record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and data retention policies.

Description String False

A descriptive text field that provides additional context about the contract type, such as business purpose, usage norms, or relevance within contract lifecycle workflows.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following the contract type record. It returns a value of 'false' when the user is not following the record. This field allows users to track updates and changes.

Id [KEY] String True

The unique Id of the contract type record.

List_Order Int True

The position of this contract type in dropdown lists. This field determines the display order for users who are selecting contract types.

Locked_Fields String True

A system-managed list of fields that are restricted from editing. This field is used to maintain data integrity and prevent unintended configuration changes.

Modified_By_Name String True

The display name of the user who last modified the contract type record.

Modified_User_Id String True

The Id of the user who last modified the contract type record.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the contract type record is marked as a favorite by the current user. It returns a value of 'false' when the record is not marked as a favorite. This feature helps users quickly locate frequently used values.

Name String False

The name of the contract type. This value appears in contract selection menus and reporting views.

Sync_Key String True

An internal synchronization key that is used to reconcile the contract type record across integrations or external systems.

Tag String False

Tags that are assigned to the contract type record. Tags support classification, filtering, and search within the CRM.

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