Contracts
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. |