| Billed_Through__c |
Billed Through |
Pre-Spring 2018 |
Date up to which the customer has been billed for the contract line. The date is determined by the date of the last invoice after the billing engine runs.
|
Date |
|
| Contract_Gross_Profit__c |
Contract Gross Profit |
Pre-Spring 2018 |
Formula:
Total_Contract_Value_After_Waived_Terms__c - Total_Contract_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 |
|
| Delivery_Method__c |
Delivery Method |
Pre-Spring 2018 |
|
Picklist:
ASP Delivery
Electronic Delivery
Load and Leave
Physical Delivery |
|
| Ext_NRC_After_Discounts__c |
Ext. NRC After Discounts |
Pre-Spring 2018 |
NRC minus discounts, multiplied by the quantity.
Formula:
NRC_After_Discount__c * Quantity__c
|
Currency(18,2) |
|
| Ext_NRC__c |
Ext. NRC |
Pre-Spring 2018 |
NRC base multiplied by the quantity.
Formula:
NRC_Base__c * Quantity__c
|
Currency(18,2) |
|
| Ext_RC_After_Discounts__c |
Ext. RC After Discounts |
Pre-Spring 2018 |
RC minus discounts multiplied by the quantity
Formula:
RC_After_Discount__c * Quantity__c
|
Currency(18,2) |
|
| Ext_RC__c |
Ext. RC |
Pre-Spring 2018 |
RC base multiplied by the quantity
Formula:
round(RC_Base__c * Quantity__c,2)
|
Currency(18,2) |
|
| Extended_Item_Cost__c |
Ext. Item Cost |
Pre-Spring 2018 |
Formula:
if( Item_Cost_With_Options__c > 0, round(Item_Cost_With_Options__c * Quantity__c,2), round(Item_Cost__c * Quantity__c, 2))
|
Currency(18,2) |
|
| Extended_Term_Cost__c |
Ext. Term Cost |
Pre-Spring 2018 |
Formula:
CASE(Total_Service_Terms__c, 0, Term_Cost__c, 1, Total_First_RC_Term_Cost_Formula__c, (Total_First_RC_Term_Cost_Formula__c + Total_Last_RC_Term_Cost_Formula__c + (Term_Cost__c * (Total_Service_Terms__c - 2))))
|
Currency(18,2) |
|
| First_Term_RC_Discount__c |
First Term RC Discount |
Pre-Spring 2018 |
The amount discounted on the first recurring service term
|
Currency(18,2) |
0 |
| Item_Cost_With_Options__c |
Item Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Item_Cost__c |
Item Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Item_Description_Formula__c |
Product or Service Description |
Pre-Spring 2018 |
Formula:
Item_Number__r.Item_Description__c
|
Text |
|
| Item_Number__c |
Product or Service |
Pre-Spring 2018 |
Product or Service being delivered
Looks up to: Item__c
|
Lookup |
|
| Item_Type_Formula__c |
Type |
Pre-Spring 2018 |
Time or Material
Formula:
If(Item_Number__c != null, Text( Item_Number__r.Item_Type__c), 'Material')
|
Text |
|
| Last_Invoice_Date__c |
Last Invoice Date |
Pre-Spring 2018 |
|
Date |
|
| Last_Invoice_Generation__c |
Last Invoice Generation |
Pre-Spring 2018 |
Last date on which the billing engine ran and created an invoice for the contract line.
|
Date |
|
| Last_Term_RC_Discount__c |
Last Term RC Discount |
Pre-Spring 2018 |
The amount discounted on the last recurring service term
|
Currency(18,2) |
0 |
| Line_Number__c |
Line Number |
Pre-Spring 2018 |
Line number is order the lines are display on the service order detail layout.
|
Number(7,3) |
|
| Milestone__c |
Milestone |
Pre-Spring 2018 |
Related to Project
|
Text(255) |
|
| Monthly_Recurring_Revenue__c |
Monthly Recurring Revenue |
Pre-Spring 2018 |
Monthly revenue for the service contract line.
|
Currency(18,2) |
0 |
| NRC_After_Discount__c |
NRC After Discount |
Pre-Spring 2018 |
Current nonrecurring base fees after discount with any changes incorporated
Formula:
NRC_Base__c - NRC_Discounted_Price__c
|
Currency(18,9) |
|
| NRC_Base__c |
NRC Base |
Pre-Spring 2018 |
Current nonrecurring base fees with any changes incorporated
|
Currency(18,9) |
0 |
| 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 |
Current nonrecurring contract value with any changes incorporated
Formula:
NRC_Extended_After_Discounts__c
|
Currency(18,2) |
|
| NRC_Discounted_Percent__c |
NRC Discounted % |
Pre-Spring 2018 |
Current percent discounted on nonrecurring base fees with any changes incorporated
|
Percent(5,2) |
0 |
| NRC_Discounted_Price__c |
NRC Discounted |
Pre-Spring 2018 |
Current discounted amount on nonrecurring base fees with any changes incorporated
|
Currency(18,9) |
0 |
| NRC_Extended_After_Discounts__c |
Ext. NRC with Options After Discounts |
Pre-Spring 2018 |
NRC with options minus discounts, multiplied by the quantity.
Formula:
round(NRC_With_Options_After_Discounts__c * Quantity__c, 2)
|
Currency(18,2) |
|
| NRC_Extended_Formula__c |
Ext. NRC with Options |
Pre-Spring 2018 |
NRC with Options, multiplied by the quantity.
Formula:
NRC_With_Options__c * Quantity__c
|
Currency(18,2) |
|
| NRC_Line_Not_Invoiced_Formula__c |
NRC Not Invoiced |
Pre-Spring 2018 |
Nonrecurring amount not invoices includes any changes incorporated
Formula:
NRC_Extended_After_Discounts__c - NRC_Billed__c
|
Currency(18,2) |
|
| NRC_Not_Invoiced_Formula__c |
Total NRC Not Invoiced |
Pre-Spring 2018 |
Nonrecurring amount with options not invoices includes any changes incorporated
Formula:
NRC_Extended_After_Discounts__c - Total_NRC_Billed_Formula__c
|
Currency(18,2) |
|
| NRC_Options_After_Discounts__c |
NRC Options After Discounts |
Pre-Spring 2018 |
Current nonrecurring fees for options after discounts and with any changes incorporated
|
Currency(18,9) |
0 |
| NRC_Options_Billed__c |
NRC Options Invoiced |
Pre-Spring 2018 |
Current nonrecurring fees invoiced to date
|
Currency(18,2) |
0 |
| NRC_Options_Fees__c |
NRC Options |
Pre-Spring 2018 |
Current nonrecurring fees for options with any changes incorporated
|
Currency(18,9) |
0 |
| NRC_Total_Option_Cost__c |
NRC Total Option Cost |
Pre-Spring 2018 |
|
Currency(18,2) |
0 |
| NRC_Type__c |
NRC Type |
Pre-Spring 2018 |
Indicates whether the non recurring fees on the service contract line are for time or material.
|
Picklist:
Material
Time |
|
| NRC_With_Options_After_Discounts__c |
NRC w/Options After Discounts |
Pre-Spring 2018 |
Current nonrecurring and options fees for a single unit after discount and with any changes incorporated
Formula:
NRC_After_Discount__c + NRC_Options_After_Discounts__c
|
Currency(18,2) |
|
| NRC_With_Options__c |
NRC w/Options |
Pre-Spring 2018 |
Current nonrecurring and options fees for a single unit with any changes incorporated
Formula:
NRC_Base__c + NRC_Options_Fees__c
|
Currency(18,2) |
|
| Next_Invoice_Date__c |
Next Invoice Generation |
Pre-Spring 2018 |
Next date on which the billing engine is to run and create an invoice for the contract line.
|
Date |
|
| Number_Options__c |
Number Options |
Pre-Spring 2018 |
Total number of options on the service order line
|
Summary |
|
| OrigTotalFirstRCTermCostFm__c |
Original Total First RC Term Cost |
Pre-Spring 2018 |
The total recurring cost with options for the first term (Read Only)
Formula:
if(OrigTotalFirstRCTermCost__c = 0, Original_Term_Cost__c, OrigTotalFirstRCTermCost__c)
|
Currency(18,2) |
|
| OrigTotalFirstRCTermCost__c |
Original Total First RC Term Cost |
Pre-Spring 2018 |
Original total recurring cost with options for the first term
|
Currency(18,2) |
0 |
| OrigTotalLastRCTermCostFm__c |
Original Total Last RC Term Cost |
Pre-Spring 2018 |
The total recurring cost with options for the last term (Read Only)
Formula:
if( OrigTotalLastRCTermCost__c = 0, Original_Term_Cost__c, OrigTotalLastRCTermCost__c)
|
Currency(18,2) |
|
| OrigTotalLastRCTermCost__c |
Original Total Last RC Term Cost |
Pre-Spring 2018 |
Original total recurring cost with options for the last term
|
Currency(18,2) |
0 |
| Orig_Total_FirstTerm_RCContract_Val_Form__c |
Orig Total First Term RC Contract Val |
Pre-Spring 2018 |
The original total recurring fees minus discounts for the first term of service (Read Only)
Formula:
If( Orig_Total_First_Term_RC_Contract_Val__c = 0, Original_RC_Contract_Value_Formula__c, Orig_Total_First_Term_RC_Contract_Val__c)
|
Currency(18,2) |
|
| Orig_Total_First_Term_RC_Contract_Val__c |
Orig Total First Term RC Contract Val |
Pre-Spring 2018 |
The original total recurring fees minus discounts for the first term of service
|
Currency(18,2) |
0 |
| Orig_Total_Last_Term_RCContract_Val_Form__c |
Orig Total Last Term RC Contract Val |
Pre-Spring 2018 |
The original total recurring fees minus discounts for the Last term of service (Read Only)
Formula:
if(Orig_Total_Last_Term_RC_Contract_Val__c = 0, Original_RC_Contract_Value_Formula__c, Orig_Total_Last_Term_RC_Contract_Val__c)
|
Currency(18,2) |
|
| Orig_Total_Last_Term_RC_Contract_Val__c |
Orig Total Last Term RC Contract Val |
Pre-Spring 2018 |
The original total recurring fees minus discounts for the Last term of service
|
Currency(18,2) |
0 |
| Original_Change_Request_Line__c |
Original Change Request Line |
Pre-Spring 2018 |
The original change request line to which the service order was added
Looks up to: Change_Request_Line__c
|
Lookup |
|
| Original_Contract_Gross_Profit__c |
Original Contract Gross Profit |
Pre-Spring 2018 |
Formula:
Original_Total_Item_Value_Formula__c - Original_Total_Contract_Cost__c
|
Currency(18,2) |
|
| Original_Customer_Quotation_Line__c |
Original Customer Quotation Line |
Pre-Spring 2018 |
Original customer quotation line
Looks up to: Customer_Quotation_Line__c
|
Lookup |
|
| Original_Extended_Item_Cost__c |
Original Ext. Item Cost |
Pre-Spring 2018 |
Formula:
if(Original_Item_Cost_With_Options__c > 0, round(Original_Item_Cost_With_Options__c * Original_Quantity__c, 2), round(Original_Item_Cost__c * Original_Quantity__c, 2))
|
Currency(18,2) |
|
| Original_Extended_Term_Cost__c |
Original Ext. Term Cost |
Pre-Spring 2018 |
Formula:
CASE(Original_Total_Service_Terms__c, 1, OrigTotalFirstRCTermCostFm__c, (OrigTotalFirstRCTermCostFm__c + OrigTotalLastRCTermCostFm__c + (Original_Term_Cost__c * (Original_Total_Service_Terms__c - 2))))
|
Currency(18,2) |
|
| Original_First_Term_RC_Discount__c |
Original First Term RC Discount |
Pre-Spring 2018 |
The original amount discounted on the first recurring service term
|
Currency(18,2) |
|
| Original_Item_Cost_With_Options__c |
Original Item Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Original_Item_Cost__c |
Original Item Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Original_Last_term_RC_Discount__c |
Original Last term RC Discount |
Pre-Spring 2018 |
The original amount discounted on the last recurring service term
|
Currency(18,2) |
|
| Original_NRC_After_Discount__c |
Original NRC After Discount |
Pre-Spring 2018 |
Original nonrecurring fees after discounts
Formula:
Original_NRC_Base__c - Original_NRC_Discounted_Price__c
|
Currency(18,9) |
|
| Original_NRC_Base__c |
Original NRC Base |
Pre-Spring 2018 |
Notation of all original nonrecurring pricing before any discounts
|
Currency(18,9) |
0 |
| Original_NRC_Contract_Value__c |
Original NRC Contract Value |
Pre-Spring 2018 |
Original nonrecurring contract value
Formula:
Original_NRC_Extended_After_Discounts__c
|
Currency(18,2) |
|
| Original_NRC_Discounted_Percent__c |
Original NRC Discounted % |
Pre-Spring 2018 |
Original discounted percent on nonrecurring base fees
|
Percent(5,2) |
0 |
| Original_NRC_Discounted_Price__c |
Original NRC Discounted |
Pre-Spring 2018 |
Original discount amount on nonrecurring base fees
|
Currency(18,9) |
0 |
| Original_NRC_Extended_After_Discounts__c |
Original NRC Ext. After Discounts |
Pre-Spring 2018 |
Original nonrecurring fees after discounts
Formula:
round(Original_NRC_With_Options_After_Discount__c * Original_Quantity__c, 2)
|
Currency(18,2) |
|
| Original_NRC_Extended_Formula__c |
Original NRC Ext. |
Pre-Spring 2018 |
Original nonrecurring fees
Formula:
Original_Quantity__c * Original_NRC_With_Options__c
|
Currency(18,2) |
|
| Original_NRC_Options_After_Discounts__c |
Original NRC Options After Discounts |
Pre-Spring 2018 |
Original nonrecurring fees for options after discounts
|
Currency(18,9) |
0 |
| Original_NRC_Options__c |
Original NRC Options |
Pre-Spring 2018 |
Original nonrecurring fees for options
|
Currency(18,9) |
0 |
| Original_NRC_With_Options_After_Discount__c |
Original NRC w/Options After Discounts |
Pre-Spring 2018 |
Original nonrecurring and options fees for a single unit after discounts
Formula:
Original_NRC_After_Discount__c + Original_NRC_Options_After_Discounts__c
|
Currency(18,9) |
|
| Original_NRC_With_Options__c |
Original NRC w/Options |
Pre-Spring 2018 |
Original nonrecurring and options fees for a single unit
Formula:
Original_NRC_Base__c + Original_NRC_Options__c
|
Currency(18,9) |
|
| Original_Number_Options__c |
Original Number Options |
Pre-Spring 2018 |
Original number of options on service order line
|
Number(5,0) |
|
| Original_Quantity__c |
Original Quantity |
Pre-Spring 2018 |
Original quantity
|
Number(18,4) |
0 |
| Original_RC_After_Discount__c |
Original RC After Discount |
Pre-Spring 2018 |
Original recurring base fees after discount
Formula:
Original_RC_Base__c - Original_RC_Discounted_Price__c
|
Currency(18,9) |
|
| Original_RC_Base__c |
Original RC Base |
Pre-Spring 2018 |
Original recurring fees
|
Currency(18,9) |
0 |
| Original_RC_Contract_Value_Formula__c |
Original Term Value |
Pre-Spring 2018 |
Formula:
If(Service_Order__r.Sync_Header_Terms_to_Lines__c, Original_RC_Extended_After_Discounts__c * Original_RC_Terms__c, Original_RC_Extended_After_Discounts__c)
|
Currency(18,2) |
|
| Original_RC_Cost_With_Options__c |
Original RC Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Original_RC_Cost__c |
Original RC Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Original_RC_Discounted_Percent__c |
Original RC Discounted % |
Pre-Spring 2018 |
Original percent discounted on recurring base fees
|
Percent(5,2) |
0 |
| Original_RC_Discounted_Price__c |
Original RC Discounted |
Pre-Spring 2018 |
Original discounted amount on recurring base fees
|
Currency(18,9) |
0 |
| Original_RC_Extended_After_Discounts__c |
Original RC Ext. After Discounts |
Pre-Spring 2018 |
Original recurring fees after discounts
Formula:
round(Original_RC_With_Options_After_Discounts__c * Original_Quantity__c, 2)
|
Currency(18,2) |
|
| Original_RC_Extended_Formula__c |
Original RC Ext. |
Pre-Spring 2018 |
Original recurring fees
Formula:
Original_Quantity__c * Original_RC_With_Options__c
|
Currency(18,2) |
|
| Original_RC_Option__c |
Original RC Options |
Pre-Spring 2018 |
Original recurring fees for options
|
Currency(18,9) |
0 |
| Original_RC_Options_After_Discounts__c |
Original RC Options After Discounts |
Pre-Spring 2018 |
Original recurring fees for options after discounts
|
Currency(18,9) |
0 |
| Original_RC_Terms__c |
Original RC Terms |
Pre-Spring 2018 |
|
Number(5,0) |
1 |
| Original_RC_With_Options_After_Discounts__c |
Original RC w/Options After Discounts |
Pre-Spring 2018 |
Original recurring and options fees for a single unit after discounts
Formula:
Original_RC_After_Discount__c + Original_RC_Options_After_Discounts__c
|
Currency(18,9) |
|
| Original_RC_With_Options__c |
Original RC w/Options |
Pre-Spring 2018 |
Original recurring and options fees for a single unit
Formula:
Original_RC_Base__c + Original_RC_Option__c
|
Currency(18,9) |
|
| Original_Service_Term__c |
Original Service Term |
Pre-Spring 2018 |
Looks up to: Service_Term__c
|
Lookup |
|
| Original_Term_Cost__c |
Original Term Cost |
Pre-Spring 2018 |
Formula:
round(Original_RC_Terms__c * Original_Quantity__c * if(Original_RC_Cost_With_Options__c != 0, Original_RC_Cost_With_Options__c, Original_RC_Cost__c), 2)
|
Currency(18,2) |
|
| Original_Total_Contract_Cost__c |
Original Total Contract Cost |
Pre-Spring 2018 |
Formula:
Original_Extended_Term_Cost__c + Original_Extended_Item_Cost__c
|
Currency(18,2) |
|
| Original_Total_Item_Value_Formula__c |
Original Total Contract Value |
Pre-Spring 2018 |
Formula:
CASE(Original_Total_Service_Terms__c, 0, (Original_RC_Contract_Value_Formula__c + Original_NRC_Contract_Value__c ), 1,(Orig_Total_FirstTerm_RCContract_Val_Form__c + Original_NRC_Contract_Value__c ), (Orig_Total_FirstTerm_RCContract_Val_Form__c + Orig_Total_Last_Term_RCContract_Val_Form__c + (Original_RC_Contract_Value_Formula__c * (Original_Total_Service_Terms__c - 2)) + Original_NRC_Contract_Value__c ))
|
Currency(18,2) |
|
| Original_Total_Service_Terms__c |
Original # Terms |
Pre-Spring 2018 |
|
Number(5,0) |
1 |
| Override_Ship_to_Address__c |
Override Ship to Address |
Pre-Spring 2018 |
Looks up to: Customer_Address__c
|
Lookup |
|
| Price_Type__c |
Price Type |
Pre-Spring 2018 |
The price type that the selected service contract line item is assigned to.
Looks up to: Price_Type__c
|
Lookup |
|
| Project_Formula__c |
Project |
Pre-Spring 2018 |
Project number - typically used internally
Formula:
Service_Order__r.Project__c
|
Text |
|
| 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_Ordered__c |
Quantity Ordered |
Pre-Spring 2018 |
|
Number(18,4) |
0 |
| Quantity__c |
Quantity |
Pre-Spring 2018 |
Quantity of services contracted
|
Number(18,4) |
1 |
| Quote_Line_Group__c |
Quote Line Group |
Pre-Spring 2018 |
Looks up to: Quote_Line_Group__c
|
Lookup |
|
| RC_After_Discount__c |
RC After Discount |
Pre-Spring 2018 |
Current recurring fees after discounts with any changes incorporated
Formula:
RC_Base__c - RC_Discounted_Price__c
|
Currency(18,9) |
|
| RC_Base__c |
RC Base |
Pre-Spring 2018 |
Notation of all current recurring fees incorporating any changes prior to discounts
|
Currency(18,9) |
0 |
| RC_Contract_Value__c |
Term Value |
Pre-Spring 2018 |
Current recurring term value with any changes incorporated
Formula:
RC_Extended_After_Discount__c * RC_Terms__c
|
Currency(18,2) |
|
| RC_Cost_With_Options__c |
RC Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| RC_Cost__c |
RC Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| RC_Discounted_Percent__c |
RC Discounted % |
Pre-Spring 2018 |
Current discounted percent on recurring fees with any changes incorporated
|
Percent(5,2) |
0 |
| RC_Discounted_Price__c |
RC Discounted $ |
Pre-Spring 2018 |
Current discounted amount on recurring fees with any changes incorporated
|
Currency(18,9) |
0 |
| RC_Extended_After_Discount__c |
Ext. RC with Options After Discounts |
Pre-Spring 2018 |
RC with options minus discounts, multiplied by the quantity
Formula:
round(RC_With_Options_After_Discounts__c * Quantity__c,2)
|
Currency(18,2) |
|
| RC_Extended_Formula__c |
Ext. RC with Options |
Pre-Spring 2018 |
RC with Options multiplied by the quantity.
Formula:
round(RC_With_Options__c * Quantity__c, 2)
|
Currency(18,2) |
|
| RC_Option_Fees__c |
RC Option |
Pre-Spring 2018 |
Current recurring fees for options fees with any changes incorporated
|
Currency(18,9) |
0 |
| RC_Options_After_Discounts__c |
RC Options After Discounts |
Pre-Spring 2018 |
Current recurring fees for options fees after discounts and with any changes incorporated
|
Currency(18,9) |
0 |
| 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_Total_Option_Cost__c |
RC Total Option Cost |
Pre-Spring 2018 |
|
Currency(18,2) |
0 |
| RC_With_Options_After_Discounts__c |
RC w/Options After Discounts |
Pre-Spring 2018 |
Current recurring and options fees for a single unit after discounts and with any changes incorporated
Formula:
RC_After_Discount__c + RC_Options_After_Discounts__c
|
Currency(18,9) |
|
| RC_With_Options__c |
RC w/Options |
Pre-Spring 2018 |
Current recurring and options fees for a single unit with any changes incorporated
Formula:
RC_Base__c + RC_Option_Fees__c
|
Currency(18,9) |
|
| Remaining_Contract_Val__c |
Remaining Contract Value |
Pre-Spring 2018 |
Remaining value of the contract to be billed.
|
Currency(11,2) |
0 |
| Remaining_Contract_Value__c |
Remaining Contract Value |
Pre-Spring 2018 |
Formula:
CASE(Remaining_Terms__c, Total_Service_Terms__c, ((Total_First_Term_RC_Contract_Val_Formula__c + Total_Last_Term_RC_Contract_Val_Formula__c) + (RC_Contract_Value__c * (if(Service_Order__r.Sync_Header_Terms_to_Lines__c, Service_Order__r.Remaining_Terms_to_be_Billed__c ,Remaining_Terms__c) - 2)) + NRC_Not_Invoiced_Formula__c), 2,((RC_Contract_Value__c + Total_Last_Term_RC_Contract_Val_Formula__c) + NRC_Not_Invoiced_Formula__c), 1,(Total_Last_Term_RC_Contract_Val_Formula__c + NRC_Not_Invoiced_Formula__c), ((RC_Contract_Value__c * (if(Service_Order__r.Sync_Header_Terms_to_Lines__c, Service_Order__r.Remaining_Terms_to_be_Billed__c ,Remaining_Terms__c) - 1)) + Total_Last_Term_RC_Contract_Val_Formula__c + NRC_Not_Invoiced_Formula__c))
|
Currency(18,2) |
|
| Remaining_Terms__c |
Remaining # Terms |
Pre-Spring 2018 |
|
Number(5,0) |
0 |
| Revision__c |
Revision |
Pre-Spring 2018 |
|
Number(5,0) |
0 |
| Sales_Order_Line_Item__c |
Sales Order Line Item |
Pre-Spring 2018 |
Looks up to: Sales_Order_Line_Item__c
|
Lookup |
|
| Service_Contract_Line_End_Date__c |
Service Contract Line End Date |
Pre-Spring 2018 |
|
Date |
|
| Service_Contract_Line_Start_Date__c |
Service Contract Line Start Date |
Pre-Spring 2018 |
|
Date |
|
| Service_Order_Line_Active_Date__c |
Service Contract Line Active Date |
Pre-Spring 2018 |
|
Date |
|
| Service_Order_Line_Approved_Date__c |
Service Contract Line Approved Date |
Pre-Spring 2018 |
|
Date |
|
| Service_Order_Line_Cancel_Date__c |
Service Contract Line Cancel Date |
Pre-Spring 2018 |
|
DateTime |
|
| Service_Order__c |
Service Contract |
Pre-Spring 2018 |
Looks up to: Service_Order__c
|
MasterDetail |
|
| Service_Term__c |
Service Term |
Pre-Spring 2018 |
Looks up to: Service_Term__c
|
Lookup |
|
| Ship_to_City__c |
Ship-to City |
Pre-Spring 2018 |
|
Text(100) |
|
| Ship_to_Country__c |
Ship-to Country |
Pre-Spring 2018 |
|
Text(100) |
|
| Ship_to_State_Province__c |
Ship-to State / Province |
Pre-Spring 2018 |
|
Text(100) |
|
| Ship_to_Street_2__c |
Ship-to Street 2 |
Pre-Spring 2018 |
|
Text(100) |
|
| Ship_to_Street__c |
Ship-to Street |
Pre-Spring 2018 |
|
Text(100) |
|
| Ship_to_Zip_Postal_Code__c |
Ship-to Zip / Postal Code |
Pre-Spring 2018 |
|
Text(15) |
|
| Status__c |
Status |
Pre-Spring 2018 |
|
Picklist:
Active
Approved
Cancelled
Dis-Approved
Expired
New
Submitted for Approval
Suspended |
|
| Supplier_Site__c |
Supplier Site |
Pre-Spring 2018 |
Looks up to: Supplier_Site__c
|
Lookup |
|
| Term_Cost__c |
Term Cost |
Pre-Spring 2018 |
Formula:
round(if(RC_Terms__c !=0, RC_Terms__c, 1) * Quantity__c * if( RC_Cost_With_Options__c != 0, RC_Cost_With_Options__c, RC_Cost__c), 2)
|
Currency(18,2) |
|
| Total_Additional_Charges__c |
Total Additional Charges |
Pre-Spring 2018 |
The total additional charges applied to this line. Total First Term RC Contract Value (The total Recurring fees minus discounts for the first term of service)
|
Currency(18,2) |
0 |
| Total_Contact_Cost__c |
Total Contract Cost |
Pre-Spring 2018 |
Formula:
Extended_Term_Cost__c + Extended_Item_Cost__c
|
Currency(18,2) |
|
| Total_Contract_Cost__c |
Total Contract Cost |
Pre-Spring 2018 |
Total cost of the contract line.
|
Currency(11,2) |
0 |
| Total_Contract_Value_After_Waived_Terms__c |
Total Contract Value After Waived Terms |
Pre-Spring 2018 |
Total Contract Value minus Waived Term Fees.
|
Currency(11,2) |
0 |
| Total_Contract_Value__c |
Total Contract Value |
Pre-Spring 2018 |
Total contract value of the line with options and changes incorporated.
|
Currency(11,2) |
0 |
| Total_First_RC_Term_Cost_Formula__c |
Total First RC Term Cost |
Pre-Spring 2018 |
The total recurring cost with options for the first term (Read Only)
Formula:
if( Total_First_RC_Term_Cost__c =0, Term_Cost__c, Total_First_RC_Term_Cost__c)
|
Currency(18,2) |
|
| Total_First_RC_Term_Cost__c |
Total First RC Term Cost |
Pre-Spring 2018 |
The total recurring cost with options for the first term
|
Currency(18,2) |
0 |
| Total_First_Term_RC_Contract_Val_Formula__c |
Total First Term RC Contract Value |
Pre-Spring 2018 |
The total recurring fees minus discounts for the first term of service (Read Only)
Formula:
if(!ISBLANK(Total_First_Term_RC_Contract_Value__c) && Total_First_Term_RC_Contract_Value__c > 0, Total_First_Term_RC_Contract_Value__c, RC_Contract_Value__c)
|
Currency(18,2) |
|
| Total_First_Term_RC_Contract_Value__c |
Total First Term RC Contract Value |
Pre-Spring 2018 |
The total recurring fees minus discounts for the first term of service
|
Currency(18,2) |
|
| Total_Item_Value__c |
Total Contract Value |
Pre-Spring 2018 |
Current total contract value of the line including options with any changes incorporated
Formula:
CASE(Total_Service_Terms__c, 0, (RC_Contract_Value__c + NRC_Contract_Value__c), 1,(Total_First_Term_RC_Contract_Val_Formula__c + NRC_Contract_Value__c), (Total_First_Term_RC_Contract_Val_Formula__c + Total_Last_Term_RC_Contract_Val_Formula__c + (RC_Contract_Value__c * (if(Service_Order__r.Sync_Header_Terms_to_Lines__c, Service_Order__r.Terms_to_be_Billed__c ,Total_Service_Terms__c) - 2)) + NRC_Contract_Value__c))
|
Currency(18,2) |
|
| Total_Last_RC_Term_Cost_Formula__c |
Total Last RC Term Cost |
Pre-Spring 2018 |
The total recurring cost with options for the last term (Read Only)
Formula:
if( Total_Last_RC_Term_Cost__c = 0, Term_Cost__c, Total_Last_RC_Term_Cost__c )
|
Currency(18,2) |
|
| Total_Last_RC_Term_Cost__c |
Total Last RC Term Cost |
Pre-Spring 2018 |
The total recurring cost with options for the last term
|
Currency(18,2) |
0 |
| Total_Last_Term_RC_Contract_Val_Formula__c |
Total Last Term RC Contract Value |
Pre-Spring 2018 |
The total recurring fees minus discounts for the last term of service (Read Only)
Formula:
if( Total_Last_Term_RC_Contract_Value__c = 0 , RC_Contract_Value__c, Total_Last_Term_RC_Contract_Value__c)
|
Currency(18,2) |
|
| Total_Last_Term_RC_Contract_Value__c |
Total Last Term RC Contract Value |
Pre-Spring 2018 |
The total recurring fees minus discounts for the Last term of service
|
Currency(18,2) |
0 |
| Total_NRC_Billed_Formula__c |
Total NRC Invoiced |
Pre-Spring 2018 |
Total nonrecurring invoiced. This include options sign to service order line.
Formula:
NRC_Billed__c
|
Currency(18,2) |
|
| Total_Prorated_Amount_Billed__c |
Total Prorated Amount Billed To Date |
Pre-Spring 2018 |
Total Prorated Amount Billed To Date
|
Currency(18,2) |
0 |
| Total_RC_Base_Fees_x_Terms__c |
Total RC Base Fees x Terms |
Pre-Spring 2018 |
This field is used in service contract calculations. The formula for this field is: (RC Ext. * RC Terms) * Terms
Formula:
(Ext_RC__c * RC_Terms__c) * Total_Service_Terms__c
|
Currency(18,2) |
|
| Total_RC_Discount_Fees_x_Terms__c |
Total RC Discount Fees x Terms |
Pre-Spring 2018 |
This field is used in service contract calculations. The formula for this field is: ((Ext. RC with Options - Ext. RC with Options After Discounts) * RC Terms) * Terms
Formula:
((RC_Extended_Formula__c - RC_Extended_After_Discount__c) * RC_Terms__c) * Total_Service_Terms__c
|
Currency(18,2) |
|
| Total_RC_Option_Fees_x_Terms__c |
Total RC Option Fees x Terms |
Pre-Spring 2018 |
This field is used in service contract calculations. The formula for this field is: (RC Total Option * RC Terms) * Terms
Formula:
(Total_RC_Options__c * RC_Terms__c) * Total_Service_Terms__c
|
Currency(18,2) |
|
| Total_RC_Options_After_Discounts__c |
Total RC Options After Discounts |
Pre-Spring 2018 |
RC Options after discounts, multiplied by the quantity on the service contract line.
Formula:
RC_Options_After_Discounts__c * Quantity__c
|
Currency(18,2) |
|
| Total_RC_Options__c |
Total RC Options |
Pre-Spring 2018 |
RC Options multiplied by the quantity on the service contract line.
Formula:
round(RC_Option_Fees__c * Quantity__c, 2)
|
Currency(18,2) |
|
| Total_Service_Terms__c |
# Terms |
Pre-Spring 2018 |
Current service terms with any changes incorporated
|
Number(5,0) |
1 |
| Warehouse__c |
Warehouse |
Pre-Spring 2018 |
Looks up to: Warehouse__c
|
Lookup |
|
