Contracts
Stores contract agreement records and renewal details. This table supports contract lifecycle management, obligation tracking, and renewal planning.
Columns
| Name | Type | ReadOnly | Description |
| Account_Id | String | False |
The identifier (Id) of the account that is associated with the contract. This field establishes the primary organizational relationship for contract reporting and access. |
| Account_Name | String | False |
The display name of the account that is associated with the contract. This field corresponds to the account_id field. |
| Acl_Team_Names | String | True |
A system-managed list of team names that grant visibility to the contract record. This field supports access control enforcement. |
| Acl_Team_Set_Id | String | False |
The Id of the team set that is associated with the contract record. Team sets allow multiple teams to share access to the same record. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned ownership of the contract record. This field supports workload distribution and accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to the contract record. |
| Base_Rate | String | False |
The base exchange rate that is associated with the contract's currency at the time of record entry. |
| Commentlog | String | True |
A free-form text field for internal comments and collaboration related to the contract record. |
| Company_Signed_Date | Date | False |
The date when the company signed the contract. This value establishes one side of the agreement timeline. |
| Contract_Term | Int | True |
The contractual term length, measured in months. This value is used to calculate renewal and expiration schedules. |
| Created_By | String | True |
The Id of the user who created the contract record. |
| Created_By_Name | String | True |
The display name of the user who created the contract record. |
| Currency_Id | String | False |
The Id of the currency used to express monetary values for the contract. |
| Currency_Name | String | True |
The name of the currency that is assigned to the contract. |
| Currency_Symbol | String | True |
The symbol representing the currency that is assigned to the contract. |
| Customer_Signed_Date | Date | False |
The date when the customer signed the contract. This value confirms contract acceptance by the client party. |
| Date_Entered | Datetime | True |
The date and time when the contract record was created. |
| Date_Modified | Datetime | True |
The date and time when the contract record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the contract record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and record recovery. |
| Description | String | False |
A free-form descriptive text field that provides additional detail or context for the contract. |
| End_Date | Date | False |
The date when the contract is no longer in effect. This value defines the contract's expiration point. |
| Expiration_Notice | Datetime | False |
The scheduled date and time to issue an expiration notice for the contract. This field is often used in automated workflow and renewal processes. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the contract record. It returns a value of 'false' when the record is not being followed. |
| Id [KEY] | String | True |
The unique Id of the contract record. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from editing to preserve contract integrity. |
| Modified_By_Name | String | True |
The display name of the user who last modified the contract record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the contract record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the contract record is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The name assigned to the contract. This field identifies the contract in user interfaces and reports. |
| Opportunity_Id | String | False |
The Id of the opportunity that is associated with the contract. This field links sales pipeline progress to finalized agreements. |
| Opportunity_Name | String | True |
The display name of the opportunity that is associated with the contract. |
| Parent_Name | String | True |
The name of the parent record to which the contract is related. This field prevents attempts to create multiple flex relate fields derived from the same source relationship. |
| Reference_Code | String | False |
A reference number or internal tracking code that is used by the organization to identify or classify the contract. |
| Start_Date | Date | False |
The date when the contract becomes effective. This value represents the beginning of the contract term. |
| Status | String | False |
The current status of the contract, such as Active, Draft, Pending, or Expired. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile the contract record across systems and integrations. |
| Tag | String | False |
Tags assigned to the contract record. Tags support classification, filtering, and searching. |
| Team_Count | String | False |
The number of teams that have access to the contract record. |
| Team_Id | String | False |
The Id of the primary team that is associated with the contract record. |
| Team_Name | String | False |
The display name of the primary team that is associated with the contract record. |
| Team_Set_Id | String | False |
The Id of the team set that grants shared-access permissions for the contract record. |
| Time_To_Expiry | Int | True |
The calculated number of days remaining before the contract expires. This field supports renewal planning and workflow automation. |
| Total_Contract_Value | Decimal | True |
The total monetary value of the contract. This figure represents the full contracted amount across the term. |
| Total_Contract_Value_Usdollar | Decimal | True |
The total monetary value of the contract expressed in U.S. dollars. This field standardizes valuation for reporting. |
| Type | String | False |
The contract type classification. This value is sourced from a predefined dropdown list. |
| Type_Name | String | True |
The display name that corresponds to the contract type classification. |