CData Power BI Connector for SugarCRM 2019 - Online Help
Questions / Feedback?

Contracts

CData Power BI Connector for SugarCRM 2019 - Build 19.0.7354

Create, update, delete, and query the Contracts module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is a favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

The unique identifier for the record.

Name String False

The name of the contract.

Date_Entered Datetime True

The date the record was created.

Date_Modified Datetime True

The date the record was last modified.

Modified_User_Id String True

The Id of the user who last modified the record.

Modified_By_Name String True

The name of the user who last modified the record.

Created_By String True

The Id of the user who created the record.

Created_By_Name String True

The user name of the user who created the record.

Doc_Owner String False

The document owner.

User_Favorites String False

The user favorites for the record.

Description String False

The description for the user.

Deleted Bool False

Record deletion indicator.

Assigned_User_Id String False

The Id of the user assigned to the record.

Assigned_User_Name String False

The name of the user assigned to the record.

Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Reference_Code String False

The reference code used by the organization to refer to this contract.

Opportunity_Name String False

The name of the associated opportunity.

Opportunity_Id String False

The Id of the associated opportunity.

Account_Name String False

The name of the associated account.

Account_Id String False

The Id of the associated account.

Start_Date Datetime False

The effective date of the contract.

End_Date Datetime False

The date in which the contract is no longer effective.

Currency_Id String False

The currency in use for the contract.

Base_Rate Decimal False

The base rate for the contract.

Currency_Name String False

The currency name.

Total_Contract_Value Double False

The overall value of the contract.

Total_Contract_Value_Usdollar Double True

The overall contract value expressed in USD.

Status String False

The contract status.

Customer_Signed_Date Datetime False

The date in which the ultimate customer signed the contract.

Company_Signed_Date Datetime False

The date in which the company using Sugar signed the contract.

Contract_Term Int False

The term of the contract.

Expiration_Notice String False

The date to issue an expiration notice (useful for workflow rules).

Time_To_Expiry Int False

The time to expiration of the contract.

Type_Name String False

The contract type.

Type String False

The drop-down options for contract types.

Parent_Name String False

The parent name of the contract.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0