Contracts
The Contracts table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False |
The name of the contract |
| Date_Entered | Datetime | True |
Date record created |
| Date_Modified | Datetime | True |
Date record last modified |
| Modified_User_Id | String | True |
User who last modified record |
| Modified_By_Name | String | True | |
| Created_By | String | True |
User who created record |
| Created_By_Name | String | True | |
| Description | String | False |
Full text of the note |
| Deleted | Bool | False |
Record deletion indicator |
| Reference_Code | String | False |
The reference code used by the organization to refer to this contract |
| Opportunity_Name | String | True | |
| Opportunity_Id | String | False | |
| Account_Name | String | False | |
| Account_Id | String | False |
The account ID to which the contract is associated |
| Start_Date | Date | False |
The effective date of the contract |
| End_Date | Date | False |
The date in which the contract is no longer effective |
| Total_Contract_Value | Decimal | True |
The overall value of the contract |
| Total_Contract_Value_Usdollar | Decimal | True |
The overall contract value expressed in USD |
| Status | String | False |
The contract status |
| Customer_Signed_Date | Date | False |
Date in which the ultimate customer signed the contract |
| Company_Signed_Date | Date | False |
Date in which the company using Sugar signed the contract |
| Contract_Term | Int | True | |
| Expiration_Notice | Datetime | False |
Date to issue an expiration notice (useful for workflow rules) |
| Time_To_Expiry | Int | True | |
| Type_Name | String | True |
The contract type |
| Type | String | False |
The dropdown options for Contract types |
| Parent_Name | String | True |
parent_name of contract, added to prevent ability to add flex relate field to module because of relationship in linked_documentsMetaData.php |
| Following | Bool | False |
Is user following this record |
| My_Favorite | Bool | False |
Favorite for the user |
| Tag | String | False | |
| Commentlog | String | True | |
| Locked_Fields | String | True | |
| Sync_Key | String | True | |
| Assigned_User_Id | String | False |
User ID assigned to record |
| Assigned_User_Name | String | True | |
| Team_Id | String | False |
Team ID for the account |
| Team_Set_Id | String | False | |
| Acl_Team_Set_Id | String | False | |
| Team_Count | String | False | |
| Team_Name | String | False | |
| Acl_Team_Names | String | True | |
| Currency_Id | String | False | |
| Base_Rate | String | False | |
| Currency_Name | String | True | |
| Currency_Symbol | String | True |