1. Order Management
  2. Sales Orders and Cash Sales
  3. Software Vertical Contract Renewals
  4. Scripting Contract and Contract Item Records

Scripting Contract and Contract Item Records

The following tables list contract and contract item custom records as well as their details, which you can refer to when scripting.

Note:

These custom records are locked and are not meant for customization.

You can create new records based on some of these custom records. For example, you can create new contract records and subsequently edit them. For more information, see the help topics Creating a New Contract and Editing a Contract.

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

General Notices