| SCMC__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 |
false |
|
| SCMC__Contract_Gross_Profit__c |
Contract Gross Profit |
Pre-Spring 2018 |
Formula:
SCMC__Total_Contract_Value_After_Waived_Terms__c - SCMC__Total_Contract_Cost__c
|
Currency(18,2) |
false |
|
| SCMC__Currency__c |
Currency |
Pre-Spring 2018 |
Looks up to: SCMC__Currency_Master__c
|
Lookup |
false |
|
| SCMC__Current_Change_Request_Line__c |
Current Change Request Line |
Pre-Spring 2018 |
Looks up to: SCMC__Change_Request_Line__c
|
Lookup |
false |
|
| SCMC__Current_Customer_Quotation_Line__c |
Current Customer Quotation Line |
Pre-Spring 2018 |
Looks up to: SCMC__Customer_Quotation_Line__c
|
Lookup |
false |
|
| SCMC__Delivery_Method__c |
Delivery Method |
Pre-Spring 2018 |
|
Picklist:
ASP Delivery
Electronic Delivery
Load and Leave
Physical Delivery |
|
|
| SCMC__Ext_NRC_After_Discounts__c |
Ext. NRC After Discounts |
Pre-Spring 2018 |
NRC minus discounts, multiplied by the quantity.
Formula:
SCMC__NRC_After_Discount__c * SCMC__Quantity__c
|
Currency(18,2) |
false |
|
| SCMC__Ext_NRC__c |
Ext. NRC |
Pre-Spring 2018 |
NRC base multiplied by the quantity.
Formula:
SCMC__NRC_Base__c * SCMC__Quantity__c
|
Currency(18,2) |
false |
|
| SCMC__Ext_RC_After_Discounts__c |
Ext. RC After Discounts |
Pre-Spring 2018 |
RC minus discounts multiplied by the quantity
Formula:
SCMC__RC_After_Discount__c * SCMC__Quantity__c
|
Currency(18,2) |
false |
|
| SCMC__Ext_RC__c |
Ext. RC |
Pre-Spring 2018 |
RC base multiplied by the quantity
Formula:
round(SCMC__RC_Base__c * SCMC__Quantity__c,2)
|
Currency(18,2) |
false |
|
| SCMC__Extended_Item_Cost__c |
Ext. Item Cost |
Pre-Spring 2018 |
Formula:
if( SCMC__Item_Cost_With_Options__c > 0, round(SCMC__Item_Cost_With_Options__c * SCMC__Quantity__c,2), round(SCMC__Item_Cost__c * SCMC__Quantity__c, 2))
|
Currency(18,2) |
false |
|
| SCMC__Extended_Term_Cost__c |
Ext. Term Cost |
Pre-Spring 2018 |
Formula:
CASE(SCMC__Total_Service_Terms__c, 0, SCMC__Term_Cost__c, 1, SCMC__Total_First_RC_Term_Cost_Formula__c, (SCMC__Total_First_RC_Term_Cost_Formula__c + SCMC__Total_Last_RC_Term_Cost_Formula__c + (SCMC__Term_Cost__c * (SCMC__Total_Service_Terms__c - 2))))
|
Currency(18,2) |
false |
|
| SCMC__First_Term_RC_Discount__c |
First Term RC Discount |
Pre-Spring 2018 |
The amount discounted on the first recurring service term
|
Currency(18,2) |
false |
0 |
| SCMC__Item_Cost_With_Options__c |
Item Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__Item_Cost__c |
Item Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__Item_Description_Formula__c |
Product or Service Description |
Pre-Spring 2018 |
Formula:
SCMC__Item_Number__r.SCMC__Item_Description__c
|
Text |
false |
|
| SCMC__Item_Number__c |
Product or Service |
Pre-Spring 2018 |
Product or Service being delivered
Looks up to: SCMC__Item__c
|
Lookup |
false |
|
| SCMC__Item_Type_Formula__c |
Type |
Pre-Spring 2018 |
Time or Material
Formula:
If(SCMC__Item_Number__c != null, Text( SCMC__Item_Number__r.SCMC__Item_Type__c), 'Material')
|
Text |
false |
|
| SCMC__Last_Invoice_Date__c |
Last Invoice Date |
Pre-Spring 2018 |
|
Date |
false |
|
| SCMC__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 |
false |
|
| SCMC__Last_Term_RC_Discount__c |
Last Term RC Discount |
Pre-Spring 2018 |
The amount discounted on the last recurring service term
|
Currency(18,2) |
false |
0 |
| SCMC__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) |
false |
|
| SCMC__Milestone__c |
Milestone |
Pre-Spring 2018 |
Related to Project
|
Text(255) |
false |
|
| SCMC__Monthly_Recurring_Revenue__c |
Monthly Recurring Revenue |
Pre-Spring 2018 |
Monthly revenue for the service contract line.
|
Currency(18,2) |
false |
0 |
| SCMC__NRC_After_Discount__c |
NRC After Discount |
Pre-Spring 2018 |
Current nonrecurring base fees after discount with any changes incorporated
Formula:
SCMC__NRC_Base__c - SCMC__NRC_Discounted_Price__c
|
Currency(18,9) |
false |
|
| SCMC__NRC_Base__c |
NRC Base |
Pre-Spring 2018 |
Current nonrecurring base fees with any changes incorporated
|
Currency(18,9) |
false |
0 |
| SCMC__NRC_Billed__c |
NRC Invoiced |
Pre-Spring 2018 |
Nonrecurring amount invoiced
|
Currency(18,2) |
false |
0 |
| SCMC__NRC_Contract_Value__c |
NRC Contract Value |
Pre-Spring 2018 |
Current nonrecurring contract value with any changes incorporated
Formula:
SCMC__NRC_Extended_After_Discounts__c
|
Currency(18,2) |
false |
|
| SCMC__NRC_Discounted_Percent__c |
NRC Discounted % |
Pre-Spring 2018 |
Current percent discounted on nonrecurring base fees with any changes incorporated
|
Percent(5,2) |
false |
0 |
| SCMC__NRC_Discounted_Price__c |
NRC Discounted |
Pre-Spring 2018 |
Current discounted amount on nonrecurring base fees with any changes incorporated
|
Currency(18,9) |
false |
0 |
| SCMC__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(SCMC__NRC_With_Options_After_Discounts__c * SCMC__Quantity__c, 2)
|
Currency(18,2) |
false |
|
| SCMC__NRC_Extended_Formula__c |
Ext. NRC with Options |
Pre-Spring 2018 |
NRC with Options, multiplied by the quantity.
Formula:
SCMC__NRC_With_Options__c * SCMC__Quantity__c
|
Currency(18,2) |
false |
|
| SCMC__NRC_Line_Not_Invoiced_Formula__c |
NRC Not Invoiced |
Pre-Spring 2018 |
Nonrecurring amount not invoices includes any changes incorporated
Formula:
SCMC__NRC_Extended_After_Discounts__c - SCMC__NRC_Billed__c
|
Currency(18,2) |
false |
|
| SCMC__NRC_Not_Invoiced_Formula__c |
Total NRC Not Invoiced |
Pre-Spring 2018 |
Nonrecurring amount with options not invoices includes any changes incorporated
Formula:
SCMC__NRC_Extended_After_Discounts__c - SCMC__Total_NRC_Billed_Formula__c
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
0 |
| SCMC__NRC_Options_Billed__c |
NRC Options Invoiced |
Pre-Spring 2018 |
Current nonrecurring fees invoiced to date
|
Currency(18,2) |
false |
0 |
| SCMC__NRC_Options_Fees__c |
NRC Options |
Pre-Spring 2018 |
Current nonrecurring fees for options with any changes incorporated
|
Currency(18,9) |
false |
0 |
| SCMC__NRC_Total_Option_Cost__c |
NRC Total Option Cost |
Pre-Spring 2018 |
|
Currency(18,2) |
false |
0 |
| SCMC__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 |
|
|
| SCMC__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:
SCMC__NRC_After_Discount__c + SCMC__NRC_Options_After_Discounts__c
|
Currency(18,2) |
false |
|
| SCMC__NRC_With_Options__c |
NRC w/Options |
Pre-Spring 2018 |
Current nonrecurring and options fees for a single unit with any changes incorporated
Formula:
SCMC__NRC_Base__c + SCMC__NRC_Options_Fees__c
|
Currency(18,2) |
false |
|
| SCMC__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 |
false |
|
| SCMC__Number_Options__c |
Number Options |
Pre-Spring 2018 |
Total number of options on the service order line
|
Summary |
|
|
| SCMC__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(SCMC__OrigTotalFirstRCTermCost__c = 0, SCMC__Original_Term_Cost__c, SCMC__OrigTotalFirstRCTermCost__c)
|
Currency(18,2) |
false |
|
| SCMC__OrigTotalFirstRCTermCost__c |
Original Total First RC Term Cost |
Pre-Spring 2018 |
Original total recurring cost with options for the first term
|
Currency(18,2) |
false |
0 |
| SCMC__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( SCMC__OrigTotalLastRCTermCost__c = 0, SCMC__Original_Term_Cost__c, SCMC__OrigTotalLastRCTermCost__c)
|
Currency(18,2) |
false |
|
| SCMC__OrigTotalLastRCTermCost__c |
Original Total Last RC Term Cost |
Pre-Spring 2018 |
Original total recurring cost with options for the last term
|
Currency(18,2) |
false |
0 |
| SCMC__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( SCMC__Orig_Total_First_Term_RC_Contract_Val__c = 0, SCMC__Original_RC_Contract_Value_Formula__c, SCMC__Orig_Total_First_Term_RC_Contract_Val__c)
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
0 |
| SCMC__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(SCMC__Orig_Total_Last_Term_RC_Contract_Val__c = 0, SCMC__Original_RC_Contract_Value_Formula__c, SCMC__Orig_Total_Last_Term_RC_Contract_Val__c)
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
0 |
| SCMC__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: SCMC__Change_Request_Line__c
|
Lookup |
false |
|
| SCMC__Original_Contract_Gross_Profit__c |
Original Contract Gross Profit |
Pre-Spring 2018 |
Formula:
SCMC__Original_Total_Item_Value_Formula__c - SCMC__Original_Total_Contract_Cost__c
|
Currency(18,2) |
false |
|
| SCMC__Original_Customer_Quotation_Line__c |
Original Customer Quotation Line |
Pre-Spring 2018 |
Original customer quotation line
Looks up to: SCMC__Customer_Quotation_Line__c
|
Lookup |
false |
|
| SCMC__Original_Extended_Item_Cost__c |
Original Ext. Item Cost |
Pre-Spring 2018 |
Formula:
if(SCMC__Original_Item_Cost_With_Options__c > 0, round(SCMC__Original_Item_Cost_With_Options__c * SCMC__Original_Quantity__c, 2), round(SCMC__Original_Item_Cost__c * SCMC__Original_Quantity__c, 2))
|
Currency(18,2) |
false |
|
| SCMC__Original_Extended_Term_Cost__c |
Original Ext. Term Cost |
Pre-Spring 2018 |
Formula:
CASE(SCMC__Original_Total_Service_Terms__c, 1, SCMC__OrigTotalFirstRCTermCostFm__c, (SCMC__OrigTotalFirstRCTermCostFm__c + SCMC__OrigTotalLastRCTermCostFm__c + (SCMC__Original_Term_Cost__c * (SCMC__Original_Total_Service_Terms__c - 2))))
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
|
| SCMC__Original_Item_Cost_With_Options__c |
Original Item Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__Original_Item_Cost__c |
Original Item Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__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) |
false |
|
| SCMC__Original_NRC_After_Discount__c |
Original NRC After Discount |
Pre-Spring 2018 |
Original nonrecurring fees after discounts
Formula:
SCMC__Original_NRC_Base__c - SCMC__Original_NRC_Discounted_Price__c
|
Currency(18,9) |
false |
|
| SCMC__Original_NRC_Base__c |
Original NRC Base |
Pre-Spring 2018 |
Notation of all original nonrecurring pricing before any discounts
|
Currency(18,9) |
false |
0 |
| SCMC__Original_NRC_Contract_Value__c |
Original NRC Contract Value |
Pre-Spring 2018 |
Original nonrecurring contract value
Formula:
SCMC__Original_NRC_Extended_After_Discounts__c
|
Currency(18,2) |
false |
|
| SCMC__Original_NRC_Discounted_Percent__c |
Original NRC Discounted % |
Pre-Spring 2018 |
Original discounted percent on nonrecurring base fees
|
Percent(5,2) |
false |
0 |
| SCMC__Original_NRC_Discounted_Price__c |
Original NRC Discounted |
Pre-Spring 2018 |
Original discount amount on nonrecurring base fees
|
Currency(18,9) |
false |
0 |
| SCMC__Original_NRC_Extended_After_Discounts__c |
Original NRC Ext. After Discounts |
Pre-Spring 2018 |
Original nonrecurring fees after discounts
Formula:
round(SCMC__Original_NRC_With_Options_After_Discount__c * SCMC__Original_Quantity__c, 2)
|
Currency(18,2) |
false |
|
| SCMC__Original_NRC_Extended_Formula__c |
Original NRC Ext. |
Pre-Spring 2018 |
Original nonrecurring fees
Formula:
SCMC__Original_Quantity__c * SCMC__Original_NRC_With_Options__c
|
Currency(18,2) |
false |
|
| SCMC__Original_NRC_Options_After_Discounts__c |
Original NRC Options After Discounts |
Pre-Spring 2018 |
Original nonrecurring fees for options after discounts
|
Currency(18,9) |
false |
0 |
| SCMC__Original_NRC_Options__c |
Original NRC Options |
Pre-Spring 2018 |
Original nonrecurring fees for options
|
Currency(18,9) |
false |
0 |
| SCMC__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:
SCMC__Original_NRC_After_Discount__c + SCMC__Original_NRC_Options_After_Discounts__c
|
Currency(18,9) |
false |
|
| SCMC__Original_NRC_With_Options__c |
Original NRC w/Options |
Pre-Spring 2018 |
Original nonrecurring and options fees for a single unit
Formula:
SCMC__Original_NRC_Base__c + SCMC__Original_NRC_Options__c
|
Currency(18,9) |
false |
|
| SCMC__Original_Number_Options__c |
Original Number Options |
Pre-Spring 2018 |
Original number of options on service order line
|
Number(5,0) |
false |
|
| SCMC__Original_Quantity__c |
Original Quantity |
Pre-Spring 2018 |
Original quantity
|
Number(18,4) |
false |
0 |
| SCMC__Original_RC_After_Discount__c |
Original RC After Discount |
Pre-Spring 2018 |
Original recurring base fees after discount
Formula:
SCMC__Original_RC_Base__c - SCMC__Original_RC_Discounted_Price__c
|
Currency(18,9) |
false |
|
| SCMC__Original_RC_Base__c |
Original RC Base |
Pre-Spring 2018 |
Original recurring fees
|
Currency(18,9) |
false |
0 |
| SCMC__Original_RC_Contract_Value_Formula__c |
Original Term Value |
Pre-Spring 2018 |
Formula:
If(SCMC__Service_Order__r.SCMC__Sync_Header_Terms_to_Lines__c, SCMC__Original_RC_Extended_After_Discounts__c * SCMC__Original_RC_Terms__c, SCMC__Original_RC_Extended_After_Discounts__c)
|
Currency(18,2) |
false |
|
| SCMC__Original_RC_Cost_With_Options__c |
Original RC Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__Original_RC_Cost__c |
Original RC Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__Original_RC_Discounted_Percent__c |
Original RC Discounted % |
Pre-Spring 2018 |
Original percent discounted on recurring base fees
|
Percent(5,2) |
false |
0 |
| SCMC__Original_RC_Discounted_Price__c |
Original RC Discounted |
Pre-Spring 2018 |
Original discounted amount on recurring base fees
|
Currency(18,9) |
false |
0 |
| SCMC__Original_RC_Extended_After_Discounts__c |
Original RC Ext. After Discounts |
Pre-Spring 2018 |
Original recurring fees after discounts
Formula:
round(SCMC__Original_RC_With_Options_After_Discounts__c * SCMC__Original_Quantity__c, 2)
|
Currency(18,2) |
false |
|
| SCMC__Original_RC_Extended_Formula__c |
Original RC Ext. |
Pre-Spring 2018 |
Original recurring fees
Formula:
SCMC__Original_Quantity__c * SCMC__Original_RC_With_Options__c
|
Currency(18,2) |
false |
|
| SCMC__Original_RC_Option__c |
Original RC Options |
Pre-Spring 2018 |
Original recurring fees for options
|
Currency(18,9) |
false |
0 |
| SCMC__Original_RC_Options_After_Discounts__c |
Original RC Options After Discounts |
Pre-Spring 2018 |
Original recurring fees for options after discounts
|
Currency(18,9) |
false |
0 |
| SCMC__Original_RC_Terms__c |
Original RC Terms |
Pre-Spring 2018 |
|
Number(5,0) |
false |
1 |
| SCMC__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:
SCMC__Original_RC_After_Discount__c + SCMC__Original_RC_Options_After_Discounts__c
|
Currency(18,9) |
false |
|
| SCMC__Original_RC_With_Options__c |
Original RC w/Options |
Pre-Spring 2018 |
Original recurring and options fees for a single unit
Formula:
SCMC__Original_RC_Base__c + SCMC__Original_RC_Option__c
|
Currency(18,9) |
false |
|
| SCMC__Original_Service_Term__c |
Original Service Term |
Pre-Spring 2018 |
Looks up to: SCMC__Service_Term__c
|
Lookup |
false |
|
| SCMC__Original_Term_Cost__c |
Original Term Cost |
Pre-Spring 2018 |
Formula:
round(SCMC__Original_RC_Terms__c * SCMC__Original_Quantity__c * if(SCMC__Original_RC_Cost_With_Options__c != 0, SCMC__Original_RC_Cost_With_Options__c, SCMC__Original_RC_Cost__c), 2)
|
Currency(18,2) |
false |
|
| SCMC__Original_Total_Contract_Cost__c |
Original Total Contract Cost |
Pre-Spring 2018 |
Formula:
SCMC__Original_Extended_Term_Cost__c + SCMC__Original_Extended_Item_Cost__c
|
Currency(18,2) |
false |
|
| SCMC__Original_Total_Item_Value_Formula__c |
Original Total Contract Value |
Pre-Spring 2018 |
Formula:
CASE(SCMC__Original_Total_Service_Terms__c, 0, (SCMC__Original_RC_Contract_Value_Formula__c + SCMC__Original_NRC_Contract_Value__c ), 1,(SCMC__Orig_Total_FirstTerm_RCContract_Val_Form__c + SCMC__Original_NRC_Contract_Value__c ), (SCMC__Orig_Total_FirstTerm_RCContract_Val_Form__c + SCMC__Orig_Total_Last_Term_RCContract_Val_Form__c + (SCMC__Original_RC_Contract_Value_Formula__c * (SCMC__Original_Total_Service_Terms__c - 2)) + SCMC__Original_NRC_Contract_Value__c ))
|
Currency(18,2) |
false |
|
| SCMC__Original_Total_Service_Terms__c |
Original # Terms |
Pre-Spring 2018 |
|
Number(5,0) |
false |
1 |
| SCMC__Override_Ship_to_Address__c |
Override Ship to Address |
Pre-Spring 2018 |
Looks up to: SCMC__Customer_Address__c
|
Lookup |
false |
|
| SCMC__Price_Type__c |
Price Type |
Pre-Spring 2018 |
The price type that the selected service contract line item is assigned to.
Looks up to: SCMC__Price_Type__c
|
Lookup |
false |
|
| SCMC__Project_Formula__c |
Project |
Pre-Spring 2018 |
Project number - typically used internally
Formula:
SCMC__Service_Order__r.SCMC__Project__c
|
Text |
false |
|
| SCMC__Quantity_Billed__c |
Quantity Billed |
Pre-Spring 2018 |
|
Number(18,4) |
false |
0 |
| SCMC__Quantity_Delivered__c |
Quantity Delivered |
Pre-Spring 2018 |
|
Number(18,4) |
false |
0 |
| SCMC__Quantity_Ordered__c |
Quantity Ordered |
Pre-Spring 2018 |
|
Number(18,4) |
false |
0 |
| SCMC__Quantity__c |
Quantity |
Pre-Spring 2018 |
Quantity of services contracted
|
Number(18,4) |
false |
1 |
| SCMC__Quote_Line_Group__c |
Quote Line Group |
Pre-Spring 2018 |
Looks up to: SCMC__Quote_Line_Group__c
|
Lookup |
false |
|
| SCMC__RC_After_Discount__c |
RC After Discount |
Pre-Spring 2018 |
Current recurring fees after discounts with any changes incorporated
Formula:
SCMC__RC_Base__c - SCMC__RC_Discounted_Price__c
|
Currency(18,9) |
false |
|
| SCMC__RC_Base__c |
RC Base |
Pre-Spring 2018 |
Notation of all current recurring fees incorporating any changes prior to discounts
|
Currency(18,9) |
false |
0 |
| SCMC__RC_Contract_Value__c |
Term Value |
Pre-Spring 2018 |
Current recurring term value with any changes incorporated
Formula:
SCMC__RC_Extended_After_Discount__c * SCMC__RC_Terms__c
|
Currency(18,2) |
false |
|
| SCMC__RC_Cost_With_Options__c |
RC Cost W/Options |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__RC_Cost__c |
RC Cost |
Pre-Spring 2018 |
|
Currency(18,9) |
false |
0 |
| SCMC__RC_Discounted_Percent__c |
RC Discounted % |
Pre-Spring 2018 |
Current discounted percent on recurring fees with any changes incorporated
|
Percent(5,2) |
false |
0 |
| SCMC__RC_Discounted_Price__c |
RC Discounted $ |
Pre-Spring 2018 |
Current discounted amount on recurring fees with any changes incorporated
|
Currency(18,9) |
false |
0 |
| SCMC__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(SCMC__RC_With_Options_After_Discounts__c * SCMC__Quantity__c,2)
|
Currency(18,2) |
false |
|
| SCMC__RC_Extended_Formula__c |
Ext. RC with Options |
Pre-Spring 2018 |
RC with Options multiplied by the quantity.
Formula:
round(SCMC__RC_With_Options__c * SCMC__Quantity__c, 2)
|
Currency(18,2) |
false |
|
| SCMC__RC_Option_Fees__c |
RC Option |
Pre-Spring 2018 |
Current recurring fees for options fees with any changes incorporated
|
Currency(18,9) |
false |
0 |
| SCMC__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) |
false |
0 |
| SCMC__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) |
false |
1 |
| SCMC__RC_Total_Option_Cost__c |
RC Total Option Cost |
Pre-Spring 2018 |
|
Currency(18,2) |
false |
0 |
| SCMC__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:
SCMC__RC_After_Discount__c + SCMC__RC_Options_After_Discounts__c
|
Currency(18,9) |
false |
|
| SCMC__RC_With_Options__c |
RC w/Options |
Pre-Spring 2018 |
Current recurring and options fees for a single unit with any changes incorporated
Formula:
SCMC__RC_Base__c + SCMC__RC_Option_Fees__c
|
Currency(18,9) |
false |
|
| SCMC__Remaining_Contract_Val__c |
Remaining Contract Value |
Pre-Spring 2018 |
Remaining value of the contract to be billed.
|
Currency(11,2) |
false |
0 |
| SCMC__Remaining_Contract_Value__c |
Remaining Contract Value |
Pre-Spring 2018 |
Formula:
CASE(SCMC__Remaining_Terms__c, SCMC__Total_Service_Terms__c, ((SCMC__Total_First_Term_RC_Contract_Val_Formula__c + SCMC__Total_Last_Term_RC_Contract_Val_Formula__c) + (SCMC__RC_Contract_Value__c * (if(SCMC__Service_Order__r.SCMC__Sync_Header_Terms_to_Lines__c, SCMC__Service_Order__r.SCMC__Remaining_Terms_to_be_Billed__c ,SCMC__Remaining_Terms__c) - 2)) + SCMC__NRC_Not_Invoiced_Formula__c), 2,((SCMC__RC_Contract_Value__c + SCMC__Total_Last_Term_RC_Contract_Val_Formula__c) + SCMC__NRC_Not_Invoiced_Formula__c), 1,(SCMC__Total_Last_Term_RC_Contract_Val_Formula__c + SCMC__NRC_Not_Invoiced_Formula__c), ((SCMC__RC_Contract_Value__c * (if(SCMC__Service_Order__r.SCMC__Sync_Header_Terms_to_Lines__c, SCMC__Service_Order__r.SCMC__Remaining_Terms_to_be_Billed__c ,SCMC__Remaining_Terms__c) - 1)) + SCMC__Total_Last_Term_RC_Contract_Val_Formula__c + SCMC__NRC_Not_Invoiced_Formula__c))
|
Currency(18,2) |
false |
|
| SCMC__Remaining_Terms__c |
Remaining # Terms |
Pre-Spring 2018 |
|
Number(5,0) |
false |
0 |
| SCMC__Revision__c |
Revision |
Pre-Spring 2018 |
|
Number(5,0) |
false |
0 |
| SCMC__Sales_Order_Line_Item__c |
Sales Order Line Item |
Pre-Spring 2018 |
Looks up to: SCMC__Sales_Order_Line_Item__c
|
Lookup |
false |
|
| SCMC__Service_Contract_Line_End_Date__c |
Service Contract Line End Date |
Pre-Spring 2018 |
|
Date |
false |
|
| SCMC__Service_Contract_Line_Start_Date__c |
Service Contract Line Start Date |
Pre-Spring 2018 |
|
Date |
false |
|
| SCMC__Service_Order_Line_Active_Date__c |
Service Contract Line Active Date |
Pre-Spring 2018 |
|
Date |
false |
|
| SCMC__Service_Order_Line_Approved_Date__c |
Service Contract Line Approved Date |
Pre-Spring 2018 |
|
Date |
false |
|
| SCMC__Service_Order_Line_Cancel_Date__c |
Service Contract Line Cancel Date |
Pre-Spring 2018 |
|
DateTime |
false |
|
| SCMC__Service_Order__c |
Service Contract |
Pre-Spring 2018 |
Looks up to: SCMC__Service_Order__c
|
MasterDetail |
|
|
| SCMC__Service_Term__c |
Service Term |
Pre-Spring 2018 |
Looks up to: SCMC__Service_Term__c
|
Lookup |
false |
|
| SCMC__Ship_to_City__c |
Ship-to City |
Pre-Spring 2018 |
|
Text(100) |
false |
|
| SCMC__Ship_to_Country__c |
Ship-to Country |
Pre-Spring 2018 |
|
Text(100) |
false |
|
| SCMC__Ship_to_State_Province__c |
Ship-to State / Province |
Pre-Spring 2018 |
|
Text(100) |
false |
|
| SCMC__Ship_to_Street_2__c |
Ship-to Street 2 |
Pre-Spring 2018 |
|
Text(100) |
false |
|
| SCMC__Ship_to_Street__c |
Ship-to Street |
Pre-Spring 2018 |
|
Text(100) |
false |
|
| SCMC__Ship_to_Zip_Postal_Code__c |
Ship-to Zip / Postal Code |
Pre-Spring 2018 |
|
Text(15) |
false |
|
| SCMC__Status__c |
Status |
Pre-Spring 2018 |
|
Picklist:
Active
Approved
Cancelled
Dis-Approved
Expired
New
Submitted for Approval
Suspended |
|
|
| SCMC__Supplier_Site__c |
Supplier Site |
Pre-Spring 2018 |
Looks up to: SCMC__Supplier_Site__c
|
Lookup |
false |
|
| SCMC__Term_Cost__c |
Term Cost |
Pre-Spring 2018 |
Formula:
round(if(SCMC__RC_Terms__c !=0, SCMC__RC_Terms__c, 1) * SCMC__Quantity__c * if( SCMC__RC_Cost_With_Options__c != 0, SCMC__RC_Cost_With_Options__c, SCMC__RC_Cost__c), 2)
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
0 |
| SCMC__Total_Contact_Cost__c |
Total Contract Cost |
Pre-Spring 2018 |
Formula:
SCMC__Extended_Term_Cost__c + SCMC__Extended_Item_Cost__c
|
Currency(18,2) |
false |
|
| SCMC__Total_Contract_Cost__c |
Total Contract Cost |
Pre-Spring 2018 |
Total cost of the contract line.
|
Currency(11,2) |
false |
0 |
| SCMC__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) |
false |
0 |
| SCMC__Total_Contract_Value__c |
Total Contract Value |
Pre-Spring 2018 |
Total contract value of the line with options and changes incorporated.
|
Currency(11,2) |
false |
0 |
| SCMC__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( SCMC__Total_First_RC_Term_Cost__c =0, SCMC__Term_Cost__c, SCMC__Total_First_RC_Term_Cost__c)
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
0 |
| SCMC__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(SCMC__Total_First_Term_RC_Contract_Value__c) && SCMC__Total_First_Term_RC_Contract_Value__c > 0, SCMC__Total_First_Term_RC_Contract_Value__c, SCMC__RC_Contract_Value__c)
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
|
| SCMC__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(SCMC__Total_Service_Terms__c, 0, (SCMC__RC_Contract_Value__c + SCMC__NRC_Contract_Value__c), 1,(SCMC__Total_First_Term_RC_Contract_Val_Formula__c + SCMC__NRC_Contract_Value__c), (SCMC__Total_First_Term_RC_Contract_Val_Formula__c + SCMC__Total_Last_Term_RC_Contract_Val_Formula__c + (SCMC__RC_Contract_Value__c * (if(SCMC__Service_Order__r.SCMC__Sync_Header_Terms_to_Lines__c, SCMC__Service_Order__r.SCMC__Terms_to_be_Billed__c ,SCMC__Total_Service_Terms__c) - 2)) + SCMC__NRC_Contract_Value__c))
|
Currency(18,2) |
false |
|
| SCMC__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( SCMC__Total_Last_RC_Term_Cost__c = 0, SCMC__Term_Cost__c, SCMC__Total_Last_RC_Term_Cost__c )
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
0 |
| SCMC__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( SCMC__Total_Last_Term_RC_Contract_Value__c = 0 , SCMC__RC_Contract_Value__c, SCMC__Total_Last_Term_RC_Contract_Value__c)
|
Currency(18,2) |
false |
|
| SCMC__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) |
false |
0 |
| SCMC__Total_NRC_Billed_Formula__c |
Total NRC Invoiced |
Pre-Spring 2018 |
Total nonrecurring invoiced. This include options sign to service order line.
Formula:
SCMC__NRC_Billed__c
|
Currency(18,2) |
false |
|
| SCMC__Total_Prorated_Amount_Billed__c |
Total Prorated Amount Billed To Date |
Pre-Spring 2018 |
Total Prorated Amount Billed To Date
|
Currency(18,2) |
false |
0 |
| SCMC__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:
(SCMC__Ext_RC__c * SCMC__RC_Terms__c) * SCMC__Total_Service_Terms__c
|
Currency(18,2) |
false |
|
| SCMC__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:
((SCMC__RC_Extended_Formula__c - SCMC__RC_Extended_After_Discount__c) * SCMC__RC_Terms__c) * SCMC__Total_Service_Terms__c
|
Currency(18,2) |
false |
|
| SCMC__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:
(SCMC__Total_RC_Options__c * SCMC__RC_Terms__c) * SCMC__Total_Service_Terms__c
|
Currency(18,2) |
false |
|
| SCMC__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:
SCMC__RC_Options_After_Discounts__c * SCMC__Quantity__c
|
Currency(18,2) |
false |
|
| SCMC__Total_RC_Options__c |
Total RC Options |
Pre-Spring 2018 |
RC Options multiplied by the quantity on the service contract line.
Formula:
round(SCMC__RC_Option_Fees__c * SCMC__Quantity__c, 2)
|
Currency(18,2) |
false |
|
| SCMC__Total_Service_Terms__c |
# Terms |
Pre-Spring 2018 |
Current service terms with any changes incorporated
|
Number(5,0) |
false |
1 |
| SCMC__Warehouse__c |
Warehouse |
Pre-Spring 2018 |
Looks up to: SCMC__Warehouse__c
|
Lookup |
false |
|
