Scripting Contract and Contract Item Records

Use the following tables when scripting the contract or contract item records.

Contract Record

Internal ID: customrecord_contracts

Field Internal ID	FIeld UI Label	Type	List/Record	Tab	Required
custrecord_contracts_start_date	Contract Start Date	Date			Yes
custrecord_contracts_end_date	Contract End Date	Date			Yes
custrecord_swe_contract_type	Contract Type	List/Record	Contract Type		No
custrecord_contracts_bill_to_customer	Bill To Customer	List/Record	Customer		Yes
custrecord_contracts_end user	End User	List/Record	Customer		Yes
custrecord_swe_contract_value	Contract Value (Base Curr)	Currency			Yes
custrecord_swe_contract_value_base	Contract Value (Customer Primary Curr)	Currency			Yes
custrecord_swe_annual_contract_val_gross	Annual Contract Value (Gross)	Currency			No
custrecord_swe_annual_contract_val_net	Annual Contract Value (Net)	Currency			No
custrecord_swe_contract_document	Contract Document	Document			No
custrecord_swe_target_renewal_date	Target Renewal Date	Date			No
custrecord_contract_date_renewed	Contract Renewed On	Date			Yes
custrecord_swe_original_contract	Original Contract	List/Record	Contract		No
custrecord_swe_contract_value_olr	Contract Value (OLR)	Currency			No
custrecord_swe_contract_value_clr	Contract Value (CLR)	Currency			No
custrecord_swe_annual_cv_gross_olr	Annual Contract Value - Gross (OLR)	Currency			No
custrecord_swe_annual_cv_gross_clr	Annual Contract Value - Gross (CLR)	Currency			No
custrecord_swe_annual_cv_net_olr	Annual Contract Value - Net (OLR)	Currency			No
custrecord_swe_annual_cv_net_clr	Annual Contract Value - Net (CLR)	Currency			No
custrecord_swe_days_b4_renewal	Days Before Renewal (hidden)	List/Record	Contract Renewal Preferences		No
custrecord_swe_renewals_pricing_model	Renewals License Pricing Model (hidden)	List/Record	Contract Renewal Preferences		No
custrecord_swe_contract_perp_cntrct_itms	Perpetual Contract Items	Multiple Select	Contract Items	Contract Items	No

Contract Item Record

Internal ID: customrecord_contract_item

Field Internal ID	Field UI Label	Type	List/Record	Required
custrecord_ci_contract_id	Contract ID	List/Record	Contract	Yes
custrecord_ci_process_item	Process	Check Box		Yes
custrecord_ci_quantity	Quantity	Decimal Number		Yes
custrecord_ci_item	Item	List/Record	Item	Yes
custrecord_ci_item_category	Item Category	List/Record	Item Categories	Yes
custrecord_ci_startdate	Contract Item Start Date	Date		Yes
custrecord_ci_enddate	Contract Item End Date	Date		Yes
custrecord_ci_status	Contract Item Status	Free-Form Text		Yes
custrecord_ci_state	Contract Item State	Free-Form Text		Yes
custrecord_ci_bill_to_customer	Bill To Customer	List/Record	Customer	Yes
custrecord_ci_end_user	End User	List/Record	Customer	Yes
custrecord_ci_customer_discount	Bill To Customer Discount	Percent		No
custrecord_ci_product_line	Product Line	List/Record	Product Lines	No
custrecord_ci_quantity_type	Quantity Type	List/Record	Quantity Types	No
custrecord_ci_quantity_cap	Quantity Cap (hidden)	List/Record	Quantity Caps (hidden)	No
custrecord_ci_maximum_quantity	Maximum Quantity (hidden)	Integer Number		No
custrecord_ci_renew_with	Renew With	List/Record	Item	No
custrecord_ci_renewal_processed_on	Renewal Processed On	Date		No
custrecord_ci_historical_install_base	Historical Install Base	Check Box		No
custrecord_ci_original_so_lineno	Original Line No	Integer Number		No
custrecord_ci_term	Contract Item Term	Decimal Number		No
custrecord_ci_order_type	Contract Item Order Type	List/Record	Order Types	No
custrecord_ci_original_transaction	Original Transaction	List/Record	Transaction	No
custrecord_ci_original_list_rate	Original List Rate	Decimal Number		No
custrecord_ci_current_list_rate	Current List Rate	Currency		No
custrecord_ci_original_discount	Original Discount	Percent		Yes
custrecord_ci_vendor	Vendor (hidden)	List/Record	Vendor	No
custrecord_ci_party	Party (hidden)	List/Record	Parties	No
custrecord_ci_ms_type	Maintenance/Support Type	List/Record	Maintenance/Support Types	No
custrecord_ci_ms_percentage	Maintenance/Support %	Percent		No
custrecord_ci_uplift_cap_basis_rate	Uplift Cap Basis Rate (hidden)	Currency		No
custrecord_ci_uplift_cap	Uplift Cap (hidden)	Percent		No
custrecord_ci_license_status	License Status	List/Record	License Statuses	No
custrecord_ci_tran_line_description	Tran Line Description	Long Text		No
custrecord_ci_end_of_life_date	End of Life Date	Date		No
custrecord_ci_end_of_ms_date	End of Mtce/Support Date	Date		No
custrecord_ci_replaced_with	Replaced With	List/Record	Item	No
custrecord_ci_replaced_with_renew_with	Replaced With Renew With	List/Record	Item	No
custrecord_ci_opt_out_ms	Opt-Out M/S	Check Box		No
custrecord_ci_renewals_exclusion	Renewals Exclusion	Check Box		No

Related Topics

• Software Vertical Contract Renewals
• New Forms, Fields, and Records for Contract Renewals

General Notices