Order and Inventory Management Data Dictionary

Change_Request_Line__c

Label: Change Request Line

This Object describes a Change Request Line. A change request may have multiple line items that have change since the service contract was approval. Line items facilitate delivery of multiple non-recurring 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
Change_Request_Line_Method__c Change Method Pre-Spring 2018 Either Add, Modify or Cancel

 Picklist:
Add
Cancel
Modify
Not Modify
Change_Request_Line_Type_Formula__c Change Request Line Type Pre-Spring 2018 Change request line is either a service contract line or service contract line option

Formula:
IF( Service_Order_Line_Option__c != null || Parent_Change_Request_Line__c != null, $Label.Option, $Label.ChangeRequestLineTypeLine)
 Text
Change_Request__c Change Request Pre-Spring 2018 Looks up to: Change_Request__c
 MasterDetail
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
Customer_Quotation_Line__c 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
Delta_NRC_After_Discount__c Delta NRC After Discount Pre-Spring 2018 Difference between current nonrecurring base fees after discounts and new nonrecurring base fees after discounts

Formula:
New_NRC_After_Discount__c - NRC_After_Discount__c
 Currency(18,9)
Delta_NRC_Base__c Delta NRC Base Pre-Spring 2018 Difference between current nonrecurring base fees and new nonrecurring base fees

Formula:
New_NRC_Base__c - NRC_Base__c
 Currency(18,9)
Delta_NRC_Discounted__c Delta NRC Discounted Pre-Spring 2018 Difference between current nonrecurring discount and new nonrecurring discount

Formula:
New_NRC_Discounted_Price__c - NRC_Discounted_Price__c
 Currency(18,9)
Delta_NRC_Extended_After_Discounts__c Delta NRC Ext. After Discounts Pre-Spring 2018 Difference between current nonrecurring fees after discounts and new nonrecurring fees after discounts

Formula:
New_NRC_Extended_After_Discounts__c - NRC_Extended_After_Discounts__c
 Currency(18,2)
Delta_NRC_Extended__c Delta NRC Ext. Pre-Spring 2018 Difference between current nonrecurring extended fees before discounts and new nonrecurring extended fees before discounts

Formula:
New_NRC_Extended_Formula__c - NRC_Extended_Formula__c
 Currency(18,2)
Delta_NRC_Options_After_Discounts__c Delta NRC Options After Discounts Pre-Spring 2018 Difference between current nonrecurring options fees after discounts and new nonrecurring options fees after discounts

Formula:
New_NRC_Options_After_Discounts__c - NRC_Options_After_Discounts__c
 Currency(18,9)
Delta_NRC_Options__c Delta NRC Options Pre-Spring 2018 Difference between current nonrecurring option fees and new nonrecurring option fees

Formula:
New_NRC_Options__c - NRC_Options__c
 Currency(18,9)
Delta_NRC_With_Options_After_Discounts__c Delta NRC w/Options After Discounts Pre-Spring 2018 Difference between current nonrecurring base fees with options after discounts and new nonrecurring base fees with options after discounts

Formula:
New_NRC_With_Options_After_Discounts__c - NRC_With_Options_After_Discounts_Formula__c
 Currency(18,9)
Delta_NRC_With_Options__c Delta NRC w/Options Pre-Spring 2018 Difference between current nonrecurring base fees with options and new nonrecurring base fees with options

Formula:
New_NRC_With_Options__c - NRC_With_Options__c
 Currency(18,9)
Delta_Quantity__c Delta Quantity Pre-Spring 2018 Difference between current quantity and new quantity

Formula:
New_Quantity__c - Quantity__c
 Number(18,4)
Delta_RC_After_Discount__c Delta RC After Discount Pre-Spring 2018 Difference between current recurring base fees after discounts and new recurring base fees after discounts

Formula:
New_RC_After_Discount__c - RC_After_Discount__c
 Currency(18,9)
Delta_RC_Base__c Delta RC Base Pre-Spring 2018 Difference between current recurring base fees and new recurring base fees

Formula:
New_RC_Base__c - RC_Base__c
 Currency(18,9)
Delta_RC_Discounted__c Delta RC Discounted Pre-Spring 2018 Difference between current recurring discounted and new recurring discounted

Formula:
New_RC_Discounted_Price__c - RC_Discounted_Price__c
 Currency(18,9)
Delta_RC_Extended_After_Discounts__c Delta RC Ext. After Discounts Pre-Spring 2018 Difference between current recurring fees after discounts and new recurring fees after discounts

Formula:
New_RC_Extended_After_Discounts__c - RC_Extended_After_Discounts__c
 Currency(18,2)
Delta_RC_Extended__c Delta RC Ext. Pre-Spring 2018 Difference between current recurring fees and new recurring fees

Formula:
New_RC_Extended_Formula__c - RC_Extended_Formula__c
 Currency(18,2)
Delta_RC_Options_After_Discounts__c Delta RC Options After Discounts Pre-Spring 2018 Difference between current recurring option fees after discounts and new recurring option fees after discounts

Formula:
New_RC_Options_After_Discounts__c - RC_Options_After_Discounts__c
 Currency(18,9)
Delta_RC_Options__c Delta RC Options Pre-Spring 2018 Difference between current recurring option fees and new recurring option fees

Formula:
New_RC_Options__c - RC_Options__c
 Currency(18,9)
Delta_RC_With_Options_After_Discounts__c Delta RC w/Options After Discounts Pre-Spring 2018 Difference between current recurring base fees with options after discounts and new recurring base fees with options after discounts

Formula:
New_RC_With_Options_After_Discounts__c - RC_With_Options_After_Discounts__c
 Currency(18,9)
Delta_RC_With_Options__c Delta RC w/Options Pre-Spring 2018 Difference between current recurring base fees with options and new recurring base fees with options

Formula:
New_RC_With_Options__c - RC_With_Options__c
 Currency(18,9)
Effective_Date__c Effective Date Pre-Spring 2018 The date on which the change is to take effect. This date is used to determine the prorated amount.

 Date
Extended_Item_Cost__c Ext. Item Cost Pre-Spring 2018 Formula:
if( Item_Cost_With_Options__c > 0, (Item_Cost_With_Options__c * Quantity__c), ( Item_Cost__c * Quantity__c))
 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__c , (Total_First_RC_Term_Cost__c + Total_Last_RC_Term_Cost__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 (Read Only To The User)

 Currency(18,2)
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_Master__c Item Master Pre-Spring 2018 Looks up to: Item__c
 Lookup
Item_Option__c Item Option Pre-Spring 2018 Looks up to: Item_Option__c
 Lookup
Item_Type_Formula__c Item Type Pre-Spring 2018 Type of product of service being sold i.e. Time, Material, Options

Formula:
IF(Item_Option__c != null, 'Option', IF(Service_Order_Line__c != null, Text(Service_Order_Line__r.Item_Number__r.Item_Type__c), Text(Item_Master__r.Item_Type__c)))
 Text
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
Monthly_Recurring_Revenue__c Monthly Recurring Revenue Pre-Spring 2018 Original Monthly Recurring Revenue for the contract line.

 Currency(18,2) 0
NRC_After_Discount__c NRC After Discount Pre-Spring 2018 Current nonrecurring base fees after discount and prior to any changes

Formula:
NRC_Base__c - NRC_Discounted_Price__c
 Currency(18,9)
NRC_Base__c NRC Base Pre-Spring 2018 Current total of recurring base fees prior to any changes

 Currency(18,9) 0
NRC_Contract_Value__c NRC Contract Value Pre-Spring 2018 Current nonrecurring contract values prior to any changes

Formula:
NRC_Extended_After_Discounts__c
 Currency(18,2)
NRC_Discounted_Percent__c NRC Discounted % Pre-Spring 2018 Current discounted percent for nonrecurring base fees prior to any changes

 Percent(18,2) 0
NRC_Discounted_Price__c NRC Discounted Pre-Spring 2018 Current discounted amount for nonrecurring base fees prior to any changes

 Currency(18,9) 0
NRC_Extended_After_Discounts__c NRC Ext. After Discounts Pre-Spring 2018 Current total on nonrecurring fees after discounts and prior to any changes

Formula:
round(NRC_With_Options_After_Discounts_Formula__c * Quantity__c, 2)
 Currency(18,2)
NRC_Extended_Formula__c NRC Ext. Pre-Spring 2018 Current total on nonrecurring fees prior to any changes

Formula:
round(NRC_With_Options__c * Quantity__c, 2)
 Currency(18,2)
NRC_Not_Invoiced__c NRC Not Invoiced Pre-Spring 2018 Current nonrecurring fees not invoiced prior to any changes

 Currency(18,2) 0
NRC_Options_After_Discounts__c NRC Options After Discounts Pre-Spring 2018 Current total on nonrecurring fees for options after discounts and prior to any changes

 Currency(18,9) 0
NRC_Options__c NRC Options Pre-Spring 2018 Current total on nonrecurring fees for options prior to any changes

 Currency(18,9) 0
NRC_Type__c NRC Type Pre-Spring 2018 Indicates whether the non recurring fees on the change request line are for time, material or an option.

 Picklist:
Material
Option
Time
NRC_With_Options_After_Discounts_Formula__c NRC w/Options After Discounts Pre-Spring 2018 Formula:
NRC_After_Discount__c + NRC_Options_After_Discounts__c
 Currency(18,9)
NRC_With_Options__c NRC w/Options Pre-Spring 2018 Current nonrecurring base fees with options fees for a single unit prior to any changes

Formula:
NRC_Base__c + NRC_Options__c
 Currency(18,9)
NewTotalFirstRCTermCostFormula__c Deprecated New Total First RC Term Cost Pre-Spring 2018 New total recurring cost with options for the last recurring term after changes (Read Only)

Formula:
if( New_Total_First_RC_Term_Cost__c =0, New_Term_Cost__c , New_Total_First_RC_Term_Cost__c )
 Currency(18,2)
NewTotalFirstTermRCContractValueFormula__c Deprecated New Total First Term RC CV Pre-Spring 2018 The total recurring fees minus discounts for the first term of service (Read Only)

Formula:
round(if(ISBLANK(New_Total_First_Term_RC_Contract_Value__c), New_RC_Contract_Value__c, New_Total_First_Term_RC_Contract_Value__c), 2)
 Currency(18,2)
NewTotalLastRCTermCostFormula__c Deprecated New Total Last RC Term Cost Pre-Spring 2018 New total recurring cost with options for the last recurring term after changes (Read Only)

Formula:
if( New_Total_Last_RC_Term_Cost__c = 0, New_Term_Cost__c, New_Total_Last_RC_Term_Cost__c )
 Currency(18,2)
NewTotalLastTermRCContractValueFormula__c Deprecated The New Total Last Term RC CV Pre-Spring 2018 The total recurring fees minus discounts for the Last term of service (Read Only)

Formula:
round(if(New_Total_Last_Term_RC_Contract_Value__c = 0, New_RC_Contract_Value__c, New_Total_Last_Term_RC_Contract_Value__c), 2)
 Currency(18,2)
New_Contract_Gross_Profit__c New Contract Gross Profit Pre-Spring 2018 Formula:
New_Total_Item_Value__c - New_Total_Contact_Cost__c
 Currency(18,2)
New_Delivery_Method__c New Delivery Method Pre-Spring 2018 Designates the new means by which the item is to be delivered.

 Picklist:
ASP Delivery
Electronic Delivery
Load and Leave
Physical Delivery
New_Extended_Item_Cost__c New Ext. Item Cost Pre-Spring 2018 Formula:
round(if(New_Item_Cost_W_Options__c > 0, (New_Item_Cost_W_Options__c * New_Quantity__c), (New_Item_Cost__c * New_Quantity__c)), If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2))
 Currency(18,9)
New_Extended_Term_Cost__c New Ext. Term Cost Pre-Spring 2018 Formula:
CASE(New_Total_Service_Terms__c, 0, New_Term_Cost__c, 1, New_Total_First_RC_Term_Cost__c , (New_Total_First_RC_Term_Cost__c + New_Total_Last_RC_Term_Cost__c + (New_Term_Cost__c * (New_Total_Service_Terms__c- 2))))
 Currency(18,2)
New_First_term_RC_Discount__c New First term RC Discount Pre-Spring 2018 The amount discounted on the first recurring service term (Read Only To The User)

 Currency(18,2) 0
New_Item_Cost_W_Options__c New Item Cost W/Options Pre-Spring 2018 Currency(18,9) 0
New_Item_Cost__c New Item Cost Pre-Spring 2018 Currency(18,9) 0
New_Last_Term_RC_Discount__c New Last Term RC Discount Pre-Spring 2018 The amount discounted on the last recurring service term (Read Only To The User)

 Currency(18,2) 0
New_Monthly_Recurring_Revenue__c New Monthly Recurring Revenue Pre-Spring 2018 Monthly Recurring Revenue for the service contract line after the changes are applied.

 Currency(18,2) 0
New_NRC_After_Discount__c New NRC After Discount Pre-Spring 2018 New nonrecurring base fees after discount

Formula:
New_NRC_Base__c - New_NRC_Discounted_Price__c
 Currency(18,9)
New_NRC_Base__c New NRC Base Pre-Spring 2018 New nonrecurring base fees

 Currency(18,9) 0
New_NRC_Contract_Value__c New NRC Contract Value Pre-Spring 2018 New nonrecurring contract value

Formula:
New_NRC_Extended_After_Discounts__c
 Currency(18,2)
New_NRC_Discounted_Percent__c New NRC Discounted % Pre-Spring 2018 New discounted percent for nonrecurring fees

 Percent(5,2) 0
New_NRC_Discounted_Price__c New NRC Discounted Pre-Spring 2018 New discounted amount for nonrecurring fees

 Currency(18,9) 0
New_NRC_Extended_After_Discounts__c New NRC Ext. After Discounts Pre-Spring 2018 New nonrecurring fees after discounts

Formula:
round(New_NRC_With_Options_After_Discounts__c * New_Quantity__c, If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2))
 Currency(18,9)
New_NRC_Extended_Formula__c New NRC Ext. Pre-Spring 2018 New nonrecurring fees

Formula:
round(New_NRC_With_Options__c * New_Quantity__c, If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2))
 Currency(18,9)
New_NRC_Not_Invoiced__c New NRC Not Invoiced Pre-Spring 2018 New nonrecurring fees not invoiced

 Currency(18,2)
New_NRC_Options_After_Discounts__c New NRC Options After Discounts Pre-Spring 2018 New nonrecurring fees for options after discounts

 Currency(18,9) 0
New_NRC_Options__c New NRC Options Pre-Spring 2018 New nonrecurring fees for options

 Currency(18,9) 0
New_NRC_With_Options_After_Discounts__c New NRC w/Options After Discounts Pre-Spring 2018 New nonrecurring base with options fees for a single unit and after discounts

Formula:
New_NRC_After_Discount__c + New_NRC_Options_After_Discounts__c
 Currency(18,9)
New_NRC_With_Options__c New NRC w/Options Pre-Spring 2018 New nonrecurring base with options fees for a single unit

Formula:
New_NRC_Base__c + New_NRC_Options__c
 Currency(18,9)
New_Number_Options_Line__c Number of New Options Lines Pre-Spring 2018 Number of new options lines on the service order line

 Number(10,0)
New_Price_Type__c New Price Type Pre-Spring 2018 The new price type that the change request line item is assigned to.

Looks up to: Price_Type__c
 Lookup
New_Quantity__c New Quantity Pre-Spring 2018 New quantity after change

 Number(18,4)
New_RC_After_Discount__c New RC After Discount Pre-Spring 2018 New recurring base fees after discount

Formula:
New_RC_Base__c - New_RC_Discounted_Price__c
 Currency(18,9)
New_RC_Base__c New RC Base Pre-Spring 2018 New recurring base fees

 Currency(18,9)
New_RC_Contract_Value__c New RC Term Value Pre-Spring 2018 New recurring contract value

Formula:
New_RC_Extended_After_Discounts__c * New_RC_Terms__c
 Currency(18,9)
New_RC_Cost_With_Options__c New RC Cost W/Options Pre-Spring 2018 Currency(18,9) 0
New_RC_Cost__c New RC Cost Pre-Spring 2018 Currency(18,9) 0
New_RC_Discounted_Percent__c New RC Discounted % Pre-Spring 2018 New discounted percent for recurring fees

 Percent(18,2) 0
New_RC_Discounted_Price__c New RC Discounted Pre-Spring 2018 New discounted amount for recurring fees

 Currency(18,9) 0
New_RC_Extended_After_Discounts__c New RC Ext. After Discounts Pre-Spring 2018 New recurring fees after discounts

Formula:
round(New_RC_With_Options_After_Discounts__c * New_Quantity__c, 2)
 Currency(18,9)
New_RC_Extended_Formula__c New RC Ext. Pre-Spring 2018 New recurring fees

Formula:
round(New_RC_With_Options__c * New_Quantity__c,If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2))
 Currency(18,9)
New_RC_Options_After_Discounts__c New RC Options After Discounts Pre-Spring 2018 New recurring fees for options after discounts

 Currency(18,9) 0
New_RC_Options__c New RC Options Pre-Spring 2018 New recurring fees for options

 Currency(18,9) 0
New_RC_Terms__c New RC Terms Pre-Spring 2018 New recurring terms

 Number(5,0) 1
New_RC_With_Options_After_Discounts__c New RC w/Options After Discounts Pre-Spring 2018 New recurring base with options fees for a single unit and after discounts

Formula:
New_RC_After_Discount__c + New_RC_Options_After_Discounts__c
 Currency(18,9)
New_RC_With_Options__c New RC w/Options Pre-Spring 2018 New recurring base with options fees for a single unit

Formula:
round(New_RC_Base__c + New_RC_Options__c, If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2))
 Currency(18,9)
New_Service_Contract_Line_End_Date__c New Service Contract Line End Date Pre-Spring 2018 Date
New_Service_Contract_Line_Start_Date__c New Service Contract Line Start Date Pre-Spring 2018 Date
New_Service_Term__c New Service Term Pre-Spring 2018 Looks up to: Service_Term__c
 Lookup
New_Supplier_Site__c New Supplier Site Pre-Spring 2018 Looks up to: Supplier_Site__c
 Lookup
New_Term_Cost__c New Term Cost Pre-Spring 2018 Formula:
if(New_RC_Terms__c !=0, New_RC_Terms__c, 1) * (if(New_Quantity__c !=0, New_Quantity__c, 0) * if(New_RC_Cost_With_Options__c != 0, New_RC_Cost_With_Options__c, if(New_RC_Cost__c != 0, New_RC_Cost__c, 0)))
 Currency(18,2)
New_Total_Contact_Cost__c New Total Contract Cost Pre-Spring 2018 Formula:
Total_Contact_Cost__c + Total_Delta_Contract_Line_Cost__c
 Currency(18,2)
New_Total_First_RC_Term_Cost__c New Total First RC Term Cost Pre-Spring 2018 New total recurring cost with options for the last recurring term after changes

 Currency(18,2) 0
New_Total_First_Term_RC_Contract_Value__c New Total First Term RC Contract Value Pre-Spring 2018 The total recurring fees minus discounts for the first term of service

 Currency(18,2)
New_Total_Item_Value__c New Total Contract Value Pre-Spring 2018 New total contract value

Formula:
Total_Item_Value__c + Total_Delta_Contract_Line_Value__c
 Currency(18,2)
New_Total_Last_RC_Term_Cost__c New Total Last RC Term Cost Pre-Spring 2018 New total recurring cost with options for the last recurring term after changes

 Currency(18,2) 0
New_Total_Last_Term_RC_Contract_Value__c New 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
New_Total_Service_Terms__c New # Terms Pre-Spring 2018 New total service terms

 Number(5,0) 1
Number_Options_Lines__c Number Options Lines Pre-Spring 2018 Number of option lines on service contract line associated to the line before any changes

 Number(10,0)
Option_Name__c Option Name Pre-Spring 2018 Text(255)
Parent_Change_Request_Item__c Parent Change Request Item Pre-Spring 2018 Formula:
if(Parent_Change_Request_Line__c != null, Parent_Change_Request_Line__r.Service_Item_Formula__c, '')
 Text
Parent_Change_Request_Line__c Parent Change Request Line Pre-Spring 2018 Parent change request line for option

Looks up to: Change_Request_Line__c
 Lookup
Parent_Customer_Quotation_Line__c Parent Customer Quotation Line Pre-Spring 2018 Looks up to: Customer_Quotation_Line__c
 Lookup
Parent_Quantity_Formula__c Parent Quantity Pre-Spring 2018 Formula:
If(Parent_Change_Request_Line__c !=null, Parent_Change_Request_Line__r.New_Quantity__c, New_Quantity__c)
 Number(18,4)
Price_Type__c Price Type Pre-Spring 2018 The price type that the change request line item is assigned to.

Looks up to: Price_Type__c
 Lookup
Prorated_Billing_Amount__c Prorated Billing Amount Pre-Spring 2018 Prorated amount to be added to the invoice or additional charge as a result of the changes on the contract line. The amount is based on the changes to the contract line and the difference between the Effective Date and the Billed Through date.

 Currency(11,2) 0
Quantity__c Quantity Pre-Spring 2018 Quantity before any changes

 Number(18,4)
RC_After_Discount__c RC After Discount Pre-Spring 2018 Current recurring base fees after discount and prior to any changes

Formula:
RC_Base__c - RC_Discounted_Price__c
 Currency(18,9)
RC_Base__c RC Base Fees Pre-Spring 2018 Current recurring base fees prior to any changes

 Currency(18,9) 0
RC_Contract_Value__c RC Term Value Pre-Spring 2018 Current recurring contract values prior to any changes

Formula:
RC_Extended_After_Discounts__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 for nonrecurring fees prior to any changes

 Percent(18,2) 0
RC_Discounted_Price__c RC Discounted Pre-Spring 2018 Current discounted amount for recurring fees prior to any changes

 Currency(18,9) 0
RC_Extended_After_Discounts__c RC Extended After Discounts Pre-Spring 2018 Current total on recurring fees after discounts and prior to any changes

Formula:
round(RC_With_Options_After_Discounts__c * Quantity__c, 2)
 Currency(18,2)
RC_Extended_Formula__c RC Ext. Pre-Spring 2018 Current total on recurring fees prior to any changes

Formula:
round(RC_With_Options__c * Quantity__c, 2)
 Currency(18,2)
RC_Options_After_Discounts__c RC Options After Discounts Pre-Spring 2018 Current recurring fees for options after discounts and prior to any changes

 Currency(18,9) 0
RC_Options__c RC Options Pre-Spring 2018 Current recurring fees for options prior to any changes

 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_With_Options_After_Discounts__c RC w/Options After Discounts Pre-Spring 2018 Current recurring base with options fees for a single unit after discounts and prior to any changes

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 base with options fees for a single unit prior to any changes

Formula:
RC_Base__c + RC_Options__c
 Currency(18,9)
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_Item_Description__c Service Item Description Pre-Spring 2018 Formula:
if(Item_Option__c != null, Item_Option__r.Option_Description_Formula__c, Item_Master__r.Item_Description__c)
 Text
Service_Item_Formula__c Service Item Pre-Spring 2018 Product or Optional product being sold

Formula:
if(Option_Name__c != null, Option_Name__c, Item_Master__r.Name)
 Text
Service_Order_Line_Option__c Service Contract Line Option Pre-Spring 2018 Reference information when service contract line option is applicable

Looks up to: Service_Order_Line_Option__c
 Lookup
Service_Order_Line_Quantity_Formula__c Service Order Line Quantity Pre-Spring 2018 Formula:
If(Service_Order_Line__c != null, Service_Order_Line__r.Quantity__c, New_Quantity__c)
 Number(18,4)
Service_Order_Line__c Service Contract Line Pre-Spring 2018 Reference information when service contract line is applicable

Looks up to: Service_Order_Line__c
 Lookup
Service_Term__c Service Term Pre-Spring 2018 Looks up to: Service_Term__c
 Lookup
Status__c Status Pre-Spring 2018 Picklist:
Approved
Cancelled
Dis-Approved
Incorporated
New
Open
Submitted for Approval
Supplier_Site__c Supplier Site Pre-Spring 2018 Supplier site associated with the related service contract line. This field is editable.

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)
TotalFirstRCTermCostFormula__c Deprecated Total First RC Term Cost Pre-Spring 2018 The total recurring cost with options for the first recurring term (Read Only)

Formula:
if( Total_First_RC_Term_Cost__c = 0, Term_Cost__c, Total_First_RC_Term_Cost__c)
 Currency(18,2)
TotalFirstTermRCContractValueFormula__c Deprecated Total First Term RC CV Pre-Spring 2018 The total recurring fees minus discounts for the first term of service (Read Only)

Formula:
if(Total_First_Term_RC_Contract_Value__c = 0, RC_Contract_Value__c, Total_First_Term_RC_Contract_Value__c)
 Currency(18,2)
TotalLastRCTermCostFormula__c Deprecated Total Last RC Term Cost Pre-Spring 2018 The total recurring cost with options for the last recurring term (Read Only)

Formula:
If( Total_Last_RC_Term_Cost__c = 0, Term_Cost__c, Total_Last_RC_Term_Cost__c )
 Currency(18,2)
TotalLastTermRCContractValueFormula__c Deprecated Total Last Term RC CV 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_Contact_Cost__c Total Contract Cost Pre-Spring 2018 Formula:
if(!ISBLANK(Service_Order_Line_Option__c), Service_Order_Line_Option__r.Total_Contact_Cost__c, if(!ISBLANK( Service_Order_Line__c), Service_Order_Line__r.Total_Contract_Cost__c, 0))
 Currency(18,2)
Total_Delta_Contract_Line_Cost__c Total Delta Contract Line Cost Pre-Spring 2018 Change to the Total Cost of the contract line when the change request line is applied.

 Currency(11,2) 0
Total_Delta_Contract_Line_Value__c Total Delta Contract Line Value Pre-Spring 2018 Change to the Total Contract Value of the contract line after the change request line is applied.

 Currency(11,2) 0
Total_First_RC_Term_Cost__c Total First RC Term Cost Pre-Spring 2018 The total recurring cost with options for the first recurring term

 Currency(18,2) 0
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) 0
Total_Item_Value__c Total Contract Value Pre-Spring 2018 Formula:
IF(!ISBLANK(Service_Order_Line_Option__c), Service_Order_Line_Option__r.Total_Item_Value__c,IF(!ISBLANK( Service_Order_Line__c),Service_Order_Line__r.Total_Contract_Value__c, 0))
 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 recurring term

 Currency(18,2) 0
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_Service_Terms__c # Terms Pre-Spring 2018 Number(5,0) 1


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