| Contract_Gross_Profit__c |
Contract Gross Profit |
Pre-Spring 2018 |
Formula:
Total_Item_Value__c - Total_Contact_Cost__c
|
Currency(18,2) |
|
| Currency__c |
Currency |
Pre-Spring 2018 |
Looks up to: Currency_Master__c
|
Lookup |
|
| Current_Change_Request_Line__c |
Current Change Request Line |
Pre-Spring 2018 |
Looks up to: Change_Request_Line__c
|
Lookup |
|
| Current_Customer_Quotation_Line__c |
Current Customer Quotation Line |
Pre-Spring 2018 |
Looks up to: Customer_Quotation_Line__c
|
Lookup |
|
| Extended_Item_Cost__c |
Ext. Item Cost |
Pre-Spring 2018 |
Formula:
round(Quantity__c * if(!ISBLANK(Item_Cost__c), Item_Cost__c, 0), 2)
|
Currency(18,2) |
|
| Extended_Term_Cost__c |
Ext. Term Cost |
Pre-Spring 2018 |
Formula:
Term_Cost__c * if(Total_Service_Terms__c !=0, Total_Service_Terms__c, 1)
|
Currency(18,2) |
|
| Item_Cost__c |
Item Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Item_Option__c |
Item Option |
Pre-Spring 2018 |
Looks up to: Item_Option__c
|
Lookup |
|
| Line_Number__c |
Line Number |
Pre-Spring 2018 |
|
Number(6,2) |
0 |
| NRC_After_Discount__c |
NRC After Discount |
Pre-Spring 2018 |
Nonrecurring base fees after discount
Formula:
NRC__c - NRC_Discounted_Price__c
|
Currency(18,9) |
|
| NRC_Billed__c |
NRC Invoiced |
Pre-Spring 2018 |
Nonrecurring amount invoiced
|
Currency(18,2) |
0 |
| NRC_Contract_Value__c |
NRC Contract Value |
Pre-Spring 2018 |
Nonrecurring contract value for the option
Formula:
NRC_Extended_After_Discounts__c
|
Currency(18,2) |
|
| NRC_Discounted_Percent__c |
NRC Discounted % |
Pre-Spring 2018 |
Percent discounted for nonrecurring base fees
|
Percent(5,2) |
0 |
| NRC_Discounted_Price__c |
NRC Discounted |
Pre-Spring 2018 |
Discounted amount for nonrecurring base fees
|
Currency(18,9) |
0 |
| NRC_Extended_After_Discounts__c |
NRC Ext. After Discounts |
Pre-Spring 2018 |
Total nonrecurring fees after discounts
Formula:
round(NRC_After_Discount__c * Quantity__c, 2)
|
Currency(18,2) |
|
| NRC_Extended_Formula__c |
NRC Ext. |
Pre-Spring 2018 |
Total nonrecurring fees
Formula:
Quantity__c * NRC__c
|
Currency(18,2) |
|
| NRC_Not_Invoiced_Formula__c |
NRC Not Invoiced |
Pre-Spring 2018 |
Nonrecurring amount not invoiced
Formula:
NRC_Extended_After_Discounts__c - NRC_Billed__c
|
Currency(18,2) |
|
| NRC__c |
NRC Base |
Pre-Spring 2018 |
Nonrecurring base fees
|
Currency(18,9) |
0 |
| Option_Description_Formula__c |
Option Description |
Pre-Spring 2018 |
Pre-Populated from the option selected during proposal process
Formula:
If(Item_Option__c != null, Item_Option__r.Option_Description_Formula__c, Option_Description__c)
|
Text |
|
| Option_Description__c |
Option Description |
Pre-Spring 2018 |
Pre-Populated from the option selected during proposal process
|
Text(255) |
|
| Option_Formula__c |
Option |
Pre-Spring 2018 |
Pre-Populated from the option selected during proposal process
Formula:
if(Item_Option__c != null, Item_Option__r.Option_Name_Formula__c, Option__c)
|
Text |
|
| Option_Type_Formula__c |
Option Type |
Pre-Spring 2018 |
Pre-Populated grouping selected the during proposal process
Formula:
If(Item_Option__c != null, Item_Option__r.Option_Type_Formula__c, Option_Type__c)
|
Text |
|
| Option_Type__c |
Option Type |
Pre-Spring 2018 |
Pre-Populated grouping selected the during proposal process
|
Text(255) |
|
| Option__c |
Option |
Pre-Spring 2018 |
Pre-Populated from the Option selected during proposal process
|
Text(150) |
|
| Original_Change_Request_Line__c |
Original Change Request Line |
Pre-Spring 2018 |
Original change request line the option was added
Looks up to: Change_Request_Line__c
|
Lookup |
|
| Original_Customer_Quotation_Line__c |
Original Customer Quotation Line |
Pre-Spring 2018 |
Looks up to: Customer_Quotation_Line__c
|
Lookup |
|
| Price_Type__c |
Price Type |
Pre-Spring 2018 |
The price type that the selected Service Contract Line Option is assigned to.
Looks up to: Price_Type__c
|
Lookup |
|
| Quantity_Billed__c |
Quantity Billed |
Pre-Spring 2018 |
|
Number(18,4) |
0 |
| Quantity_Delivered__c |
Quantity Delivered |
Pre-Spring 2018 |
|
Number(18,4) |
0 |
| Quantity__c |
Quantity |
Pre-Spring 2018 |
Quantity of the option as it relates to the parent item
|
Number(18,4) |
1 |
| RC_After_Discount__c |
RC After Discount |
Pre-Spring 2018 |
Recurring base fees after discounts
Formula:
RC__c - RC_Discounted__c
|
Currency(18,9) |
|
| RC_Contract_Value__c |
Term Value |
Pre-Spring 2018 |
Recurring contract value for option
Formula:
RC_Extended_After_Discounts__c * RC_Terms__c
|
Currency(18,2) |
|
| RC_Cost__c |
RC Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| RC_Discounted_Percent__c |
RC Discounted % |
Pre-Spring 2018 |
Percent discounted off of recurring base fees
|
Percent(5,2) |
0 |
| RC_Discounted__c |
RC Discounted |
Pre-Spring 2018 |
Amount discounted for recurring base fees
|
Currency(18,9) |
0 |
| RC_Extended_After_Discounts__c |
RC Ext. After Discounts |
Pre-Spring 2018 |
Total recurring fees after discounts
Formula:
RC_After_Discount__c * Quantity__c
|
Currency(18,9) |
|
| RC_Extended_Formula__c |
RC Ext. |
Pre-Spring 2018 |
Total recurring fees
Formula:
Quantity__c * RC__c
|
Currency(18,9) |
|
| RC_Terms__c |
RC Terms |
Pre-Spring 2018 |
Number of days or months that make up the a single contract term. For instance, if the Service Term is Annual, the value of this field is 12. This indicates that a single contract term is 12 months.
|
Number(5,0) |
1 |
| RC__c |
RC Base |
Pre-Spring 2018 |
Recurring base fees
|
Currency(18,9) |
0 |
| Revision__c |
Revision |
Pre-Spring 2018 |
|
Number(5,0) |
0 |
| Service_Contract_Option_End_Date__c |
Service Contract Option End Date |
Pre-Spring 2018 |
|
Date |
|
| Service_Contract_Option_Start_Date__c |
Service Contract Option Start Date |
Pre-Spring 2018 |
|
Date |
|
| Service_Order_Line__c |
Service Contract Line |
Pre-Spring 2018 |
Looks up to: Service_Order_Line__c
|
MasterDetail |
|
| Service_Term__c |
Service Term |
Pre-Spring 2018 |
Looks up to: Service_Term__c
|
Lookup |
|
| Status__c |
Status |
Pre-Spring 2018 |
|
Picklist:
Active
Approved
Cancelled
Dis-Approved
New
Submitted for Approval
Suspended |
|
| Term_Cost__c |
Term Cost |
Pre-Spring 2018 |
Formula:
round(if( RC_Terms__c !=0, RC_Terms__c, 1) * Quantity__c * RC_Cost__c, 2)
|
Currency(18,2) |
|
| Total_Contact_Cost__c |
Total Contract Cost |
Pre-Spring 2018 |
Formula:
Extended_Item_Cost__c + Extended_Term_Cost__c
|
Currency(18,2) |
|
| Total_Item_Value__c |
Total Contract Value |
Pre-Spring 2018 |
The total contract value for the option
Formula:
NRC_Contract_Value__c + (RC_Contract_Value__c * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Total_Service_Terms__c |
Number Of Terms |
Pre-Spring 2018 |
Numeric value of service terms in duration Example: Service Term is Annual, Numeric Value 3 Years
|
Currency(5,0) |
1 |
