Contract
Manages contract records, supporting operational and financial tracking for agreements in Sage Intacct.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | True |
Unique record number for the contract. |
| Parentkey | Long | False |
Reference to the parent contract's unique key. |
| Parentid | String | True |
Identifier for the original or parent contract. |
| Description | String | False |
Detailed description of the contract. |
| Contractid | String | False |
Unique identifier for the contract. |
| State | String | True |
Current state or status of the contract. |
| Begindate | Date | False |
Date the contract becomes effective. |
| Enddate | Date | False |
Date the contract is set to expire. |
| Canceldate | Date | True |
Date the contract was canceled, if applicable. |
| Name | String | False |
Name of the contract. |
| Customerkey | Long | False |
Unique key referencing the associated customer. |
| Customerid | String | False |
Unique identifier for the associated customer. |
| Customername | String | False |
Name of the associated customer. |
| Displaycontact_email1 | String | False |
Primary email address for the contact. |
| Displaycontact_email2 | String | False |
Secondary email address for the contact. |
| Billtokey | Long | False |
Unique key referencing the bill-to contact. |
| Billtocontactname | String | False |
Name of the bill-to contact. |
| Billto_email1 | String | False |
Primary email address for the bill-to contact. |
| Billto_email2 | String | False |
Secondary email address for the bill-to contact. |
| Shiptokey | Long | False |
Unique key referencing the ship-to contact. |
| Shiptocontactname | String | False |
Name of the ship-to contact. |
| Shipto_email1 | String | False |
Primary email address for the ship-to contact. |
| Shipto_email2 | String | False |
Secondary email address for the ship-to contact. |
| Billingfrequency | String | False |
Frequency of billing for the contract. |
| Termkey | Long | False |
Key referencing the term associated with the contract. |
| Termname | String | False |
Name of the term associated with the contract. |
| Renewal | Bool | False |
Indicates if the contract is eligible for renewal. |
| Renewalmacrokey | Long | False |
Key referencing the renewal template. |
| Renewedcontractkey | Long | False |
Key referencing the renewed contract. |
| Renewedcontractid | String | True |
Identifier for the source of the renewal. |
| Renewalmacro | String | False |
Renewal template associated with the contract. |
| Renewcontract_schopkey | Long | False |
Key for the scheduled operation of the contract renewal. |
| Renewemailalert_schopkey | Long | False |
Key for the scheduled operation of the renewal alert. |
| Nonrenewcontract_schopkey | Long | False |
Key for the scheduled operation to cancel non-renewed contracts. |
| Renewcustomeralert_schopkey | Long | False |
Key for the scheduled operation of customer renewal alerts. |
| Renewtermlength | Long | False |
Length of the renewal term. |
| Renewtermperiod | String | False |
Period of the renewal term. |
| Prclstkey | Long | False |
Key for the price list associated with billing. |
| Prclist | String | False |
Price list used for billing. |
| Meaprclist | String | False |
Fair value price list. |
| Meaprclstkey | Long | False |
Key for the fair value price list. |
| Billinghold | Bool | False |
Indicates if billing is on hold. |
| Revenuehold | Bool | False |
Indicates if revenue is on hold. |
| Crhold | Bool | False |
Indicates if cash receipt processing is on hold. |
| Expensehold | Bool | False |
Indicates if expense processing is on hold. |
| Basecurr | String | True |
Base currency used for the contract. |
| Currency | String | False |
Transaction currency used for the contract. |
| Exchratetype | String | False |
Type of exchange rate used for the contract. |
| Exch_rate_type_id | Long | False |
Identifier for the exchange rate type. |
| Locationkey | String | False |
Key referencing the contract's location. |
| Locationid | String | False |
Identifier for the location of the contract. |
| Locationname | String | False |
Name of the location associated with the contract. |
| Deptkey | String | False |
Key referencing the department associated with the contract. |
| Departmentid | String | False |
Identifier for the department associated with the contract. |
| Departmentname | String | False |
Name of the department associated with the contract. |
| Advbillby | Long | False |
Specifies the advance billing setup. |
| Advbillbytype | String | False |
Type of advance billing setup. |
| Renewaladvbillby | Long | False |
Advance billing setup for renewals. |
| Renewaladvbillbytype | String | False |
Type of advance billing setup for renewals. |
| Whencreated | Datetime | True |
Timestamp of when the contract was created. |
| Whenmodified | Datetime | True |
Timestamp of the last modification to the contract. |
| Createdby | Long | True |
Identifier for the user who created the contract. |
| Modifiedby | Long | True |
Identifier for the user who last modified the contract. |
| Supdocid | String | False |
Attachment ID associated with the contract. |
| Status | String | False |
Indicates whether the contract is active or inactive. |
| Contracttypekey | Long | False |
Key referencing the type of contract. |
| Contracttype | String | False |
Type of contract. |
| Timesheetaggregation | String | False |
Method for deferring time-based revenue. |
| Postmemo | String | True |
Post-memo information associated with the contract. |
| Megaentitykey | Long | True |
Key referencing the entity where the contract was created. |
| Megaentityid | String | True |
Identifier for the entity where the contract was created. |
| Megaentityname | String | True |
Name of the entity where the contract was created. |
| Test_specialcharacters | String | False |
Test field containing special characters. |
| Test_specialcharacters2 | String | False |
Field used for testing special characters. |
| Projectdimkey | Long | False |
Key referencing the associated project dimension. |
| Projectid | String | False |
Identifier for the associated project. |
| Projectname | String | False |
Name of the associated project. |
| Vendordimkey | Long | False |
Key referencing the associated vendor dimension. |
| Vendorid | String | False |
Identifier for the associated vendor. |
| Vendorname | String | False |
Name of the associated vendor. |
| Employeedimkey | Long | False |
Key referencing the associated employee dimension. |
| Employeeid | String | False |
Identifier for the associated employee. |
| Employeename | String | False |
Name of the associated employee. |
| Classdimkey | Long | False |
Key referencing the associated class dimension. |
| Classid | String | False |
Identifier for the associated class. |
| Classname | String | False |
Name of the associated class. |
| Warehousedimkey | Long | False |
Key referencing the associated warehouse dimension. |
| Warehouseid | String | False |
Identifier for the associated warehouse. |
| Warehousename | String | False |
Name of the associated warehouse. |
| Record_url | String | True |
Portable, user-independent URL for viewing this record. |
| Gldimtestegi1 | String | False |
Test field for GL dimension. |