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_ |
Contract Start Date |
Date |
|
|
Yes |
custrecord_ |
Contract End Date |
Date |
|
|
Yes |
custrecord_ |
Contract Type |
List/Record |
Contract Type |
|
No |
custrecord_ |
Bill To Customer |
List/Record |
Customer |
|
Yes |
custrecord_ |
End User |
List/Record |
Customer |
|
Yes |
custrecord_ |
Contract Value (Base Curr) |
Currency |
|
|
Yes |
custrecord_ |
Contract Value (Customer Primary Curr) |
Currency |
|
|
Yes |
custrecord_ |
Annual Contract Value (Gross) |
Currency |
|
|
No |
custrecord_ |
Annual Contract Value (Net) |
Currency |
|
|
No |
custrecord_ |
Contract Document |
Document |
|
|
No |
custrecord_ |
Target Renewal Date |
Date |
|
|
No |
custrecord_ |
Contract Renewed On |
Date |
|
|
Yes |
custrecord_ |
Original Contract |
List/Record |
Contract |
|
No |
custrecord_ |
Contract Value (OLR) |
Currency |
|
|
No |
custrecord_ |
Contract Value (CLR) |
Currency |
|
|
No |
custrecord_ |
Annual Contract Value - Gross (OLR) |
Currency |
|
|
No |
custrecord_ |
Annual Contract Value - Gross (CLR) |
Currency |
|
|
No |
custrecord_ |
Annual Contract Value - Net (OLR) |
Currency |
|
|
No |
custrecord_ |
Annual Contract Value - Net (CLR) |
Currency |
|
|
No |
custrecord_ |
Days Before Renewal (hidden) |
List/Record |
Contract Renewal Preferences |
|
No |
custrecord_ |
Renewals License Pricing Model (hidden) |
List/Record |
Contract Renewal Preferences |
|
No |
custrecord_ |
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_ |
Process |
Check Box |
|
Yes |
custrecord_ci_quantity |
Quantity |
Decimal Number |
|
Yes |
custrecord_ci_item |
Item |
List/Record |
Item |
Yes |
custrecord_ |
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_ |
Bill To Customer |
List/Record |
Customer |
Yes |
custrecord_ci_end_user |
End User |
List/Record |
Customer |
Yes |
custrecord_ |
Bill To Customer Discount |
Percent |
|
No |
custrecord_ |
Product Line |
List/Record |
Product Lines |
No |
custrecord_ |
Quantity Type |
List/Record |
Quantity Types |
No |
custrecord_ |
Quantity Cap (hidden) |
List/Record |
Quantity Caps (hidden) |
No |
custrecord_ |
Maximum Quantity (hidden) |
Integer Number |
|
No |
custrecord_ |
Renew With |
List/Record |
Item |
No |
custrecord_ |
Renewal Processed On |
Date |
|
No |
custrecord_ |
Historical Install Base |
Check Box |
|
No |
custrecord_ |
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_ |
Original Transaction |
List/Record |
Transaction |
No |
custrecord_ |
Original List Rate |
Decimal Number |
|
No |
custrecord_ |
Current List Rate |
Currency |
|
No |
custrecord_ |
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_ |
Maintenance/Support % |
Percent |
|
No |
custrecord_ |
Uplift Cap Basis Rate (hidden) |
Currency |
|
No |
custrecord_ci_uplift_cap |
Uplift Cap (hidden) |
Percent |
|
No |
custrecord_ |
License Status |
List/Record |
License Statuses |
No |
custrecord_ |
Tran Line Description |
Long Text |
|
No |
custrecord_ |
End of Life Date |
Date |
|
No |
custrecord_ |
End of Mtce/Support Date |
Date |
|
No |
custrecord_ |
Replaced With |
List/Record |
Item |
No |
custrecord_ |
Replaced With Renew With |
List/Record |
Item |
No |
custrecord_ci_opt_out_ms |
Opt-Out M/S |
Check Box |
|
No |
custrecord_ |
Renewals Exclusion |
Check Box |
|
No |