Order and Inventory Management Data Dictionary

Service_Order_Line__c

Label: Service Contract Line

This Object describes a Service Contract Line. A Service Contract may have multiple line items. Line items facilitate delivery of multiple nonrecurring and recurring services to customers on one Contract. They contain the required information for pricing and delivery of services and are subject to a formal process of approval. This information is used in Sales, Quality, and Finance processes

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
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


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.