| Advance_Core_Receipt__c |
Advance Core Receipt? |
Pre-Spring 2018 |
The core must be received before the new part is shipped out.
|
Checkbox |
false |
| Applied_Rebate_Amount__c |
Applied Rebate Amount |
Pre-Spring 2018 |
Total amount of qualifying rebate for the customer quotation line.
|
Currency(18,2) |
0 |
| CQL_Type__c |
CQL Type |
Pre-Spring 2018 |
|
Picklist:
Item
Service |
|
| Change_Request_Line__c |
Change Request Line |
Pre-Spring 2018 |
Looks up to: Change_Request_Line__c
|
Lookup |
|
| Comments__c |
Comments |
Pre-Spring 2018 |
Enter text that will appear on outgoing Quotations
|
LongTextArea(32000) |
|
| Condition_Code__c |
Condition |
Pre-Spring 2018 |
The Condition Code of the part being quoted.
Looks up to: Condition_Code__c
|
Lookup |
|
| Contract_Gross_Profit__c |
Contract Gross Profit |
Pre-Spring 2018 |
Formula:
Total_Item_Value__c - Total_Contact_Cost__c
|
Currency(18,2) |
|
| Core_Item_Number__c |
Core Item Number |
Pre-Spring 2018 |
This is the expected part number to be returned by customer
|
Text(32) |
|
| Core_Valuation__c |
Core Valuation |
Pre-Spring 2018 |
The value of the core. The customer would be invoiced this amount if the core was not received.
|
Currency(18,9) |
|
| Current_Contract_Cost__c |
Current Contract Cost |
Pre-Spring 2018 |
The current contract cost for this line.
|
Currency(18,2) |
|
| Current_Contract_Value__c |
Current Contract Value |
Pre-Spring 2018 |
The total contract value for this line.
|
Currency(18,2) |
|
| Customer_Price_With_Options__c |
Customer Price w/Options |
Pre-Spring 2018 |
The customer price plus the total options customer price
Formula:
Customer_Price__c + Options_Customer_Price__c
|
Currency(18,9) |
|
| Customer_Price__c |
Customer Price |
Pre-Spring 2018 |
The price that is displayed on the quote that goes to the customer. The price is the actual deal price but the sales rep may elect to display a different price on the quote.
|
Currency(18,9) |
|
| Customer_Quotation__c |
Customer Quotation |
Pre-Spring 2018 |
This is a link to the Customer Quotation for this Quotation Line Item.
Looks up to: Customer_Quotation__c
|
MasterDetail |
|
| Customer_Rebate_Discount__c |
Customer Rebate Discount |
Pre-Spring 2018 |
Applied Rebate Amount deducted from the Customer Price
|
Currency(18,2) |
0 |
| Customer_Total_Price__c |
Customer Total Price |
Pre-Spring 2018 |
Total customer price rolled up to the customer quotation
Formula:
Extended_Customer_Price_With_Options__c
|
Currency(18,9) |
|
| Delivery_Days__c |
Delivery ARO |
Pre-Spring 2018 |
Number of days to deliver after receipt of order (ARO)
|
Number(3,0) |
10 |
| Delivery_Method__c |
Delivery Method |
Pre-Spring 2018 |
|
Picklist:
ASP Delivery
Electronic Delivery
Load and Leave
Physical Delivery |
|
| Discount_Amount__c |
Discount Amount |
Pre-Spring 2018 |
Formula:
if(No_Bid__c, 0, round((List_Price__c - Price__c) * 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) |
|
| Distributor_Price__c |
Distributor Price |
Pre-Spring 2018 |
|
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 |
|
| Ext_Customer_Discount__c |
Ext Customer Discount |
Pre-Spring 2018 |
The Extended List Price minus the Total Customer Price
Formula:
Extended_List_Price_With_Options__c - Customer_Total_Price__c
|
Currency(18,2) |
|
| Ext_Customer_Price_With_Rebate_Discount__c |
Ext. Customer Price With Rebate Discount |
Pre-Spring 2018 |
Total price the customer pays after rebates.
Formula:
Extended_Customer_Price_With_Options__c - Customer_Rebate_Discount__c
|
Currency(18,2) |
|
| Ext_Internal_Sell_Price_With_Options__c |
Ext. Internal Sell Price W/Options |
Pre-Spring 2018 |
The quantity of units multiplied by the internal price w/options
Formula:
if(Total_Service_Terms__c = 0, round(Quantity__c * Internal_Sell_Price_With_Options_Formula__c, 2), round((Quantity__c * Internal_Sell_Price_With_Options_Formula__c) * RC_Terms__c, 2) * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Ext_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) |
|
| Extend_Description__c |
Ext. Description |
Pre-Spring 2018 |
|
Html(32000) |
|
| Extended_Cost__c |
Ext. Item Cost |
Pre-Spring 2018 |
The quantity multiplied by the item cost per unit
Formula:
if(Total_Service_Terms__c = 0 || CONTAINS(Text(CQL_Type__c),'Service'), Supplier_Price__c * Quantity__c, ((Supplier_Price__c * Quantity__c) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,9) |
|
| Extended_Customer_Price_Options__c |
Ext. Customer Price Options |
Pre-Spring 2018 |
Formula:
if(Total_Service_Terms__c = 0, (Quantity__c * Options_Customer_Price__c), ((Quantity__c * Options_Customer_Price__c) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Extended_Customer_Price_With_Options__c |
Ext. Customer Price w/Options |
Pre-Spring 2018 |
The quantity of units multiplied by the customer price w/options
Formula:
if(Total_Service_Terms__c = 0, round(Quantity__c * Customer_Price_With_Options__c, 2), (round(Quantity__c * Customer_Price_With_Options__c, 2) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,9) |
|
| Extended_Customer_Price__c |
Ext. Customer Price |
Pre-Spring 2018 |
The quantity multiplied by the customer price per unit
Formula:
round(Quantity__c * Customer_Price__c, If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2)) * if(Total_Service_Terms__c = 0, 1, RC_Terms__c * Total_Service_Terms__c)
|
Currency(18,9) |
|
| Extended_Internal_Sell_Price_Options__c |
Ext. Internal Sell Price Options |
Pre-Spring 2018 |
The Quantity of Units multiplied by options internal sell Price
Formula:
if(Total_Service_Terms__c = 0, (Quantity__c * Options_Internal_Sell_Price__c),((Quantity__c * Options_Internal_Sell_Price__c) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Extended_Internal_Sell_Price__c |
Ext. Internal Sell Price |
Pre-Spring 2018 |
The quantity multiplied by the internal sell price per unit
Formula:
round(Quantity__c * Price__c, If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2)) * if(Total_Service_Terms__c = 0, 1, RC_Terms__c * Total_Service_Terms__c)
|
Currency(18,9) |
|
| Extended_Item_Cost_Options__c |
Ext. Item Cost Options |
Pre-Spring 2018 |
The Quantity of Units multiplied by option cost per unit
Formula:
if(Total_Service_Terms__c = 0 || CONTAINS(Text(CQL_Type__c),'Service'), (Quantity__c * Options_Item_Cost__c),((Quantity__c * Options_Item_Cost__c) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Extended_Item_Cost_With_Options__c |
Ext. Item Cost w/Options |
Pre-Spring 2018 |
The quantity of units multiplied by the item cost w/ options
Formula:
if(Total_Service_Terms__c = 0 || CONTAINS(Text(CQL_Type__c),'Service'), round(Quantity__c * Item_Cost_With_Options_Formula__c, 2), (round(Quantity__c * Item_Cost_With_Options_Formula__c, 2) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Extended_List_Price_Options__c |
Ext. List Price Options |
Pre-Spring 2018 |
The Quantity of Units multiplied by options list price
Formula:
if(Total_Service_Terms__c = 0, (Quantity__c * Options_List_Price__c), ((Quantity__c * Options_List_Price__c) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Extended_List_Price_With_Options__c |
Ext. List Price w/Options |
Pre-Spring 2018 |
The quantity of units multiplied by the list price w/options
Formula:
if(Total_Service_Terms__c = 0, (Quantity__c * List_Price_With_Options_Formula__c), ((Quantity__c * List_Price_With_Options_Formula__c) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,2) |
|
| Extended_List_Price__c |
Ext. List Price |
Pre-Spring 2018 |
The quantity multiplied by the list price per unit
Formula:
if(Total_Service_Terms__c = 0, round((List_Price__c * Quantity__c), If(!ISBLANK($Setup.Organization_Settings__c.Number_of_Decimal_Digits__c), $Setup.Organization_Settings__c.Number_of_Decimal_Digits__c, 2)), ((List_Price__c * Quantity__c) * RC_Terms__c) * Total_Service_Terms__c)
|
Currency(18,9) |
|
| First_Term_RC_Discount__c |
First term RC Discount |
Pre-Spring 2018 |
First Term RC Discount (Read Only To The User). The amount discounted on the first recurring service term
|
Currency(18,2) |
0 |
| Gross_Annual_Contract_Value__c |
Gross Annual Contract Value |
Pre-Spring 2018 |
Total gross annual contract value for the customer quotation line excluding percentage based pricing.
|
Currency(11,2) |
0 |
| Gross_Percent_with_Rebate_Discounts__c |
Gross Percent with Rebate Discount |
Pre-Spring 2018 |
Percentage of gross profit from rebates
Formula:
IF(Ext_Internal_Sell_Price_With_Options__c = 0, -1, Gross_Profit_with_Rebate_Discounts__c/(Ext_Internal_Sell_Price_With_Options__c - Customer_Rebate_Discount__c ))
|
Percent(18,2) |
|
| Gross_Profit_Percent_With_Options__c |
Gross Profit Percent w/Options |
Pre-Spring 2018 |
Formula:
IF(Ext_Internal_Sell_Price_With_Options__c = 0, -1, Gross_Profit_With_Options__c / Ext_Internal_Sell_Price_With_Options__c)
|
Percent(18,2) |
|
| Gross_Profit_With_Options__c |
Gross Profit w/Options |
Pre-Spring 2018 |
Formula:
round(Ext_Internal_Sell_Price_With_Options__c - Extended_Item_Cost_With_Options__c,2)
|
Currency(18,2) |
|
| Gross_Profit__c |
Gross Profit Percent |
Pre-Spring 2018 |
Formula:
IF(Extended_Internal_Sell_Price__c = 0, -1, Over_All_Revenue_Price__c / Extended_Internal_Sell_Price__c)
|
Percent(18,1) |
|
| Gross_Profit_with_Rebate_Discounts__c |
Gross Profit with Rebate Discounts |
Pre-Spring 2018 |
Total gross profit including rebates
Formula:
round(Ext_Internal_Sell_Price_With_Options__c - Customer_Rebate_Discount__c, 2) - Extended_Item_Cost_With_Options__c
|
Currency(18,2) |
|
| GroupIndex__c |
GroupIndex |
Pre-Spring 2018 |
|
Number(6,2) |
|
| Internal_Option_Price__c |
Internal Option Price |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Internal_Sell_Price_With_Options_Formula__c |
Internal Sell Price W/Options |
Pre-Spring 2018 |
The internal sell price plus the options internal sell price
Formula:
Price__c + Options_Internal_Sell_Price__c
|
Currency(18,9) |
|
| Internal_Sell_Price_With_Options__c |
Deprecated Internal Sell Price W/Options |
Fall 2020 |
|
Currency(18,2) |
0 |
| IsAnItemOption__c |
IsAnItemOption |
Pre-Spring 2018 |
|
Checkbox |
false |
| IsChildRecord__c |
IsChildRecord |
Pre-Spring 2018 |
Is the line a child record of another customer quotation line.
|
Checkbox |
false |
| ItemIndex__c |
Line |
Pre-Spring 2018 |
|
Number(7,3) |
|
| Item_Cost_With_Options_Formula__c |
Item Cost w/Options |
Pre-Spring 2018 |
The item cost plus the options item cost
Formula:
Supplier_Price__c + Options_Item_Cost__c
|
Currency(18,9) |
|
| Item_Cost_With_Options__c |
Deprecated Item Cost W/Options |
Fall 2020 |
|
Currency(18,2) |
0 |
| Item_Description_New__c |
Item Description New |
Pre-Spring 2018 |
|
Text(255) |
|
| Item_Description__c |
Item Description |
Pre-Spring 2018 |
Formula:
IF( Item_Number__c != null, Item_Number__r.Item_Description__c , Item_Description_New__c )
|
Text |
|
| Item_Exists_in_Item_Master__c |
Item Exists in Item Master |
Pre-Spring 2018 |
This field is automatically checked if the item specified in the item number exists in the Item Master
|
Checkbox |
false |
| Item_Number_New__c |
Item Number - New |
Pre-Spring 2018 |
Use this Item Number field for Items not currently in the system
|
Text(80) |
|
| Item_Number__c |
Item Number |
Pre-Spring 2018 |
For parts that are currently in the Item Master, this field is used instead of the Item Master - New field. This is the part being quoted.
Looks up to: Item__c
|
Lookup |
|
| Item_Option__c |
Item Option |
Pre-Spring 2018 |
Looks up to: Item_Option__c
|
Lookup |
|
| Item_Quote_Description__c |
Item Quote Description |
Pre-Spring 2018 |
This is used to describe the product being quoted - It is pre-populated with basic Item Master description information and can be added to as desired. Note only effective for current line item on a specific quote and does not change standard description
|
LongTextArea(32000) |
|
| Item_Type_New__c |
Item Type New |
Pre-Spring 2018 |
Item Type establishes warnings within the system based on capabilities
|
Picklist:
Capital Equipment
Consumable
Repairable
Rotable
Tool |
|
| 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_Type__c |
Line Type |
Pre-Spring 2018 |
Formula:
$RecordType.DeveloperName
|
Text |
|
| List_Price_With_Options_Formula__c |
List Price w/Options |
Pre-Spring 2018 |
The list price plus the options list price
Formula:
List_Price__c + Options_List_Price__c
|
Currency(18,9) |
|
| List_Price_With_Options__c |
Deprecated List Price W/Options |
Fall 2020 |
|
Currency(18,2) |
0 |
| List_Price__c |
List Price |
Pre-Spring 2018 |
The list price per one unit in the unit of measure specified
|
Currency(18,9) |
0 |
| Lookup_Manufacturer__c |
Known Manufacturer |
Pre-Spring 2018 |
Looks up to: Manufacturer__c
|
Lookup |
|
| MandatoryItem__c |
MandatoryItem |
Pre-Spring 2018 |
Check to see if line is mandatory, so the use can not remove it from list.
|
Checkbox |
false |
| Manufacturer_New__c |
Manufacturer - New |
Pre-Spring 2018 |
|
Text(150) |
|
| Manufacturer__c |
Manufacturer |
Pre-Spring 2018 |
|
Text(255) |
|
| Margin_Percent__c |
Percent |
Pre-Spring 2018 |
|
Percent(5,2) |
0 |
| Margin__c |
Margin |
Pre-Spring 2018 |
Set margin per line.
|
Number(18,0) |
|
| Maximum_List_Price__c |
Maximum List Price |
Pre-Spring 2018 |
This is a read only field that is populated during the quoting process.
|
Currency(18,9) |
|
| Minimum_List_Price__c |
Minimum List Price |
Pre-Spring 2018 |
This is a read only field and is populated during the quoting process from the selected price entry
|
Currency(18,9) |
|
| Minimum_Order_Quantity__c |
Minimum Order Quantity |
Pre-Spring 2018 |
|
Number(18,4) |
|
| Monthly_Recurring_Revenue__c |
Monthly Recurring Revenue |
Pre-Spring 2018 |
Monthly revenue for the customer quotation line. This is calculated by subtracting the Annual Contract Value from the Total Contract Value and dividing the result by 12.
|
Currency(18,2) |
0 |
| NRC_After_Discount__c |
NRC After Discount |
Pre-Spring 2018 |
Nonrecurring base fees after discount
Formula:
NRC_Base_Fees__c - NRC_Discounted_Price__c
|
Currency(18,9) |
|
| NRC_Base_Fees__c |
NRC Base |
Pre-Spring 2018 |
Nonrecurring base fees
|
Currency(18,9) |
0 |
| NRC_Contract_Value__c |
NRC Contract Value |
Pre-Spring 2018 |
Total nonrecurring value for line
Formula:
NRC_Extended_After_Discounts__c
|
Currency(18,2) |
|
| NRC_Discounted_Percent__c |
NRC Discounted % |
Pre-Spring 2018 |
Percent discounted for nonrecurring base fees
|
Percent(5,2) |
0 |
| NRC_Discounted_Price__c |
NRC Discounted |
Pre-Spring 2018 |
Discounted amount for nonrecurring base fees
|
Currency(18,9) |
0 |
| NRC_Extended_After_Discounts__c |
NRC Ext. After Discounts |
Pre-Spring 2018 |
Total nonrecurring fees after discounts
Formula:
round(NRC_With_Options_After_Discounts__c * 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) |
|
| NRC_Extended__c |
NRC Ext. |
Pre-Spring 2018 |
Total nonrecurring fees
|
Currency(18,9) |
0 |
| NRC_Invoiced__c |
NRC Invoiced |
Pre-Spring 2018 |
Nonrecurring amount invoiced
|
Currency(18,2) |
0 |
| NRC_Not_Invoiced__c |
NRC Not Invoiced |
Pre-Spring 2018 |
Nonrecurring amount not invoiced
Formula:
(Quantity__c * NRC_With_Options_After_Discounts__c) - NRC_Invoiced__c
|
Currency(18,2) |
|
| NRC_Type__c |
NRC Type |
Pre-Spring 2018 |
Indicates whether the non recurring fees on the customer quotation line are for time, material or an option.
|
Picklist:
Material
Option
Time |
|
| NRC_With_Options_After_Discounts__c |
NRC w/Options After Discounts |
Pre-Spring 2018 |
Nonrecurring and options fees for a single unit after discounts
|
Currency(18,9) |
0 |
| NRC_With_Options__c |
NRC w/Options |
Pre-Spring 2018 |
Nonrecurring and options fees for a single unit
|
Currency(18,9) |
0 |
| Net_Annual_Contract_Value__c |
Net Annual Contract Value |
Pre-Spring 2018 |
Net annual contract value for the customer quotation line excluding percentage based pricing.
|
Currency(11,2) |
0 |
| New_Supplier__c |
New Supplier |
Pre-Spring 2018 |
|
Text(255) |
|
| No_Bid__c |
No Bid? |
Pre-Spring 2018 |
|
Checkbox |
false |
| Option_NRC__c |
Option NRC |
Pre-Spring 2018 |
Total NRC options for the parent customer quotation line.
|
Currency(18,9) |
0 |
| Option_RC__c |
Option RC |
Pre-Spring 2018 |
Total RC options for the parent customer quotation line.
|
Currency(18,9) |
0 |
| Options_Customer_Price__c |
Options Customer Price |
Pre-Spring 2018 |
|
Currency(18,9) |
0 |
| Options_Internal_Sell_Price__c |
Options Internal Sell Price |
Pre-Spring 2018 |
The internal price for all options per one unit
|
Currency(18,9) |
0 |
| Options_Item_Cost__c |
Options Item Cost |
Pre-Spring 2018 |
The cost for all options per one unit
|
Currency(18,9) |
0 |
| Options_List_Price__c |
Options List Price |
Pre-Spring 2018 |
The list price for all options per one unit
|
Currency(18,9) |
0 |
| Original_Internal_Sell_Price__c |
Original Internal Sell Price |
Pre-Spring 2018 |
Original internal sell price before any bottom line discount.
|
Currency(18,9) |
|
| Over_All_Revenue_Price__c |
Gross Profit |
Pre-Spring 2018 |
Formula:
If(No_Bid__c, 0, (Extended_Internal_Sell_Price__c - Extended_Cost__c))
|
Currency(18,9) |
|
| Parent_Customer_Quotation_Line__c |
Parent Customer Quotation Line |
Pre-Spring 2018 |
Looks up to: Customer_Quotation_Line__c
|
Lookup |
|
| Percentage_Based_Pricing__c |
Percentage Based Pricing |
Pre-Spring 2018 |
This checkbox is set by the system depending on the chosen pricing method.
|
Checkbox |
false |
| PriceList__c |
PriceList |
Pre-Spring 2018 |
The field is populated by a background process. It references a price from the price list that applies to this quote line.
Looks up to: Price__c
|
Lookup |
|
| Price_List_Overridden__c |
Price List Overridden |
Pre-Spring 2018 |
List price was overridden by user
|
Checkbox |
false |
| Price_Type__c |
Price Type |
Pre-Spring 2018 |
The price type that the selected quote line item is assigned to.
Looks up to: Price_Type__c
|
Lookup |
|
| Price__c |
Internal Sell Price |
Pre-Spring 2018 |
The price for the item being quoted. The price is for the unit of measure - for example, if the unit of measure is "each" and the price is 2.00, then an order of 4 is 8.00.
|
Currency(18,9) |
0 |
| Pricing_Action__c |
Pricing Action |
Pre-Spring 2018 |
What method was used in pricing the line.
|
Text(25) |
|
| Product_Group_New__c |
Product Group New |
Pre-Spring 2018 |
Defines the logical group this items belongs to (e.g., computing equipment, printing supplies).
Looks up to: Product_Group__c
|
Lookup |
|
| Prorated_Billing_Amount__c |
Prorated Billing Amount |
Pre-Spring 2018 |
Prorated amount from the change request 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 |
The quantity of the specific item requested
|
Number(18,4) |
|
| QuoteItem_Description__c |
Quote Item Description |
Pre-Spring 2018 |
Displayable description of item
Formula:
IF( Item_Number__c != null, Item_Number__r.Item_Description__c , Item_Description_New__c )
|
Text |
|
| QuoteItem__c |
Item to Quote |
Pre-Spring 2018 |
Displayable item for quote line
Formula:
IF( Item_Number__c != null, Item_Number__r.Name , Item_Number_New__c )
|
Text |
|
| 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 |
Recurring base fees after discount
Formula:
RC_Base_Fees__c - RC_Discounted_Price__c
|
Currency(18,9) |
|
| RC_Base_Fees__c |
RC Base |
Pre-Spring 2018 |
Recurring base fees
|
Currency(18,9) |
0 |
| RC_Contract_Val__c |
RC Contract Value |
Pre-Spring 2018 |
Total recurring fees for the customer quotation line.
|
Currency(11,2) |
0 |
| RC_Contract_Value__c |
Term Value |
Pre-Spring 2018 |
Recurring term value for the line
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 |
Percent discounted for recurring base fees
|
Percent(5,2) |
0 |
| RC_Discounted_Price__c |
RC Discounted |
Pre-Spring 2018 |
Discounted amount for recurring base fees
|
Currency(18,9) |
0 |
| RC_Extended_After_Discounts__c |
RC Ext. After Discounts |
Pre-Spring 2018 |
Total recurring fees after discount
Formula:
round(RC_With_Options_After_Discounts__c * 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) |
|
| RC_Extended__c |
RC Ext. |
Pre-Spring 2018 |
Total recurring fees
|
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.
|
Currency(5,0) |
1 |
| RC_With_Options_After_Discounts__c |
RC w/Options After Discounts |
Pre-Spring 2018 |
Recurring and options fees for a single unit after discounts
|
Currency(18,9) |
0 |
| RC_With_Options__c |
RC w/Options |
Pre-Spring 2018 |
Recurring and options fees for a single unit
|
Currency(18,9) |
0 |
| Received_RFQ_Item__c |
Received RFQ Item |
Pre-Spring 2018 |
Reference to the received RFQ line item. Set by the conversion from RRFQ to Customer Quotation
Looks up to: Received_RFQ_Item__c
|
Lookup |
|
| Remaining_Terms__c |
Remaining # Terms |
Pre-Spring 2018 |
The number of terms remaining to bill on this line. The is populated from the service contract line.
|
Number(5,0) |
|
| Requested_Delivery_Date__c |
Requested Delivery Date |
Pre-Spring 2018 |
Enter the date the Customer/Prospect has requested delivery
|
Date |
|
| Service_Being_Quoted__c |
Service Being Quoted |
Pre-Spring 2018 |
A description of the service that is being quoted.
|
LongTextArea(32000) |
|
| Service_Contract_Line_Option__c |
Service Contract Line Option |
Pre-Spring 2018 |
Looks up to: Service_Order_Line_Option__c
|
Lookup |
|
| Service_Contract_Line_Status__c |
Service Contract Line Status |
Pre-Spring 2018 |
|
Picklist:
Cancelled
Locked
Modify
Not Editable |
|
| Service_Contract_Line__c |
Service Contract Line |
Pre-Spring 2018 |
Looks up to: Service_Order_Line__c
|
Lookup |
|
| Service_Term_End_Date__c |
Service Term End Date |
Pre-Spring 2018 |
This is the End date for a service being rendered - such as a support contract
|
Date |
|
| Service_Term_Start_Date__c |
Service Term Start Date |
Pre-Spring 2018 |
This is the beginning date for a service being rendered - such as a support contract
|
Date |
|
| 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) |
|
| Sourcing_Response__c |
Selected Response |
Pre-Spring 2018 |
Looks up to: Sourcing_Response__c
|
Lookup |
|
| Status__c |
Status |
Pre-Spring 2018 |
The price field contains a valid price if the status is Bid otherwise the price is not a valid price. This is used to indicate the user does not wish to supply a quote for the particular item.
|
Picklist:
Bid
New
No Bid |
|
| Supplier_Catalog_Overridden__c |
Supplier Catalog Overridden |
Pre-Spring 2018 |
Supplier Catalog Price was overridden by user
|
Checkbox |
false |
| Supplier_Catalogue_Item__c |
Supplier Catalogue Item |
Pre-Spring 2018 |
Looks up to: Supplier_Catalogue_Item__c
|
Lookup |
|
| Supplier_Catalogue_Price_Break__c |
Supplier Catalogue Price Break |
Pre-Spring 2018 |
Supplier Catalogue Price Break used to calculate the price for this line.
Looks up to: Supplier_Catalogue_Price_Break__c
|
Lookup |
|
| Supplier_Price__c |
Item Cost |
Pre-Spring 2018 |
The quoted price for a single unit from a supplier
|
Currency(18,9) |
0 |
| Supplier_Quote_Number__c |
Supplier Quote Number |
Pre-Spring 2018 |
|
Text(100) |
|
| Supplier_Site__c |
Supplier Site |
Pre-Spring 2018 |
Looks up to: Supplier_Site__c
|
Lookup |
|
| Supplier__c |
Supplier |
Pre-Spring 2018 |
Supplier for line item.
|
Text(100) |
|
| Tag_Information__c |
Tag Information |
Pre-Spring 2018 |
|
Date |
|
| Term_Cost__c |
Term Cost |
Pre-Spring 2018 |
Formula:
if(RC_Terms__c !=0, RC_Terms__c, 1) * round(Quantity__c * if( RC_Cost_With_Options__c != 0, RC_Cost_With_Options__c, if(RC_Cost__c != 0, RC_Cost__c, 0)),2)
|
Currency(18,2) |
|
| Total_Contact_Cost__c |
Total Contract Cost |
Pre-Spring 2018 |
Formula:
round(if(!ISBLANK(Total_RC_Cost__c) && Total_RC_Cost__c > 0, Total_RC_Cost__c, Ext_Term_Cost__c) + Extended_Item_Cost_With_Options__c, 2)
|
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_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), RC_Contract_Value__c, Total_First_Term_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 |
The total contract value of the line including options.
Formula:
round(if(!ISBLANK(RC_Contract_Val__c) && RC_Contract_Val__c > 0, RC_Contract_Val__c + NRC_Extended_After_Discounts__c, CASE(Total_Service_Terms__c, 0, RC_Contract_Value__c + NRC_Extended_After_Discounts__c, 1, Total_First_Term_RC_Contract_Value__c + NRC_Extended_After_Discounts__c, (Total_First_Term_RC_Contract_Value__c + Total_Last_Term_RC_Contract_Value__c+ (RC_Contract_Value__c * (Total_Service_Terms__c - 2)) + NRC_Extended_After_Discounts__c))),2)
|
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_Price__c |
Total Internal Sell Price |
Pre-Spring 2018 |
Total price is the price multiplied by the quantity.
Formula:
Ext_Internal_Sell_Price_With_Options__c
|
Currency(18,2) |
|
| Total_RC_Cost__c |
Total RC Cost |
Pre-Spring 2018 |
The total recurring cost for this line.
|
Currency(18,2) |
|
| Total_Service_Terms__c |
# of Terms |
Pre-Spring 2018 |
Numeric value of service terms in duration Example: Service Term is Annual, Numeric Value 3 Years
|
Number(5,0) |
0 |
| Traceability_Code__c |
Traceability Code |
Pre-Spring 2018 |
|
Picklist:
0078
121
129
135
145
8130
COFC
EASA
OEM
OTH
TCFO |
|
| UOM__c |
UOM |
Pre-Spring 2018 |
Formula:
Item_Number__r.Stocking_UOM__r.Name
|
Text |
|
| Unit_of_Measure__c |
Unit of Measure for New Item |
Pre-Spring 2018 |
The unit of measure for the item being quoted.
Looks up to: Unit_of_Measure__c
|
Lookup |
|
| Up_Sell_Cross_Sell__c |
Up Sell Cross Sell |
Pre-Spring 2018 |
Looks up to: Up_Sell_Cross_Sell__c
|
Lookup |
|
| Used_Price__c |
Used Price |
Pre-Spring 2018 |
Price List price used to calculate the price for this line.
Looks up to: Price__c
|
Lookup |
|
| mandatory__c |
mandatory |
Pre-Spring 2018 |
For all children Items
|
Checkbox |
false |
