Available_to_Promise__c |
Available |
Pre-Spring 2020 |
The field is a place holder for the field set. Any values place inside this will not be used.
|
Number(18,0) |
|
Commodity_Code_Formula__c |
Commodity Code |
Pre-Spring 2020 |
Line Item Commodity Code
Formula: if(SCMC__Item_Number__c != null, SCMC__Item_Number__r.SCMC__Commodity_Code__r.Name, '')
|
Text |
|
Condition_Formula__c |
Condition |
Pre-Spring 2020 |
Condition Name
Formula: if(SCMC__Condition_Code__c != null, SCMC__Condition_Code__r.Name, '')
|
Text |
|
Contract_Type__c |
Contract Type |
Pre-Spring 2020 |
Related information to support the reporting on sales
|
Picklist: New Product Sale Related Renewal: Competitive Take-Over Renewal: From Previous Transaction |
|
Customer_Discount__c |
Customer Discount |
Pre-Spring 2020 |
Discount equals List Price minus Customer Price
Formula: if(SCMC__List_Price__c > 0, SCMC__List_Price__c - SCMC__Customer_Price__c, 0)
|
Currency(18,2) |
|
ExpandOptions__c |
ExpandOptions |
Pre-Spring 2020 |
Used To Display Option List
|
Checkbox |
true |
Ext_Customer_Discount__c |
Term Cost |
Pre-Spring 2020 |
The Extended List Price minus the Total Customer Price
Formula: (if(SCMC__NRC_Extended_After_Discounts__c != 0, SCMC__Quantity__c, 0) * if(SCMC__Supplier_Price__c != 0, SCMC__Supplier_Price__c, 0)) + (if(SCMC__RC_Extended_After_Discounts__c !=0, if(SCMC__RC_Terms__c !=0, SCMC__RC_Terms__c, 1) * (if(SCMC__Quantity__c !=0, SCMC__Quantity__c, 0) * if(SCMC__Supplier_Price__c != 0, SCMC__Supplier_Price__c, 0)), 0))
|
Currency(18,2) |
|
Item_Type_Formula__c |
Item Type |
Pre-Spring 2020 |
Line Item Type
Formula: if(SCMC__Item_Number__c != null, Text(SCMC__Item_Number__r.SCMC__Item_Type__c), Text(SCMC__Item_Type_New__c))
|
Text |
|
Manufacturer_Formula__c |
Manufacturer |
Pre-Spring 2020 |
This is a manufacture to use on a quote printout or a report. It is the name from the reference to a known manufacturer or the new manufacturer.
Formula: IF(SCMC__Lookup_Manufacturer__c != null, SCMC__Lookup_Manufacturer__r.Name, SCMC__Manufacturer_New__c)
|
Text |
|
Parent_Customer_Quotation_Line_Item__c |
Parent Customer Quotation Line Item |
Pre-Spring 2020 |
Formula: if(SCMC__Parent_Customer_Quotation_Line__c != null, SCMC__Parent_Customer_Quotation_Line__r.SCMC__QuoteItem__c, '')
|
Text |
|
Price_By__c |
Price By |
Pre-Spring 2020 |
|
Text(100) |
|
Product_Group_Formula__c |
Product Group |
Pre-Spring 2020 |
Line Item Product Group Name
Formula: IF(NOT(ISBLANK(SCMC__Item_Number__r.SCMC__Product_Group__c)), SCMC__Item_Number__r.SCMC__Product_Group__r.Name, SCMC__Product_Group_New__r.Name)
|
Text |
|
Resolved_Supplier_MFG_Relationship__c |
Resolved Supplier MFG Relationship |
Pre-Spring 2020 |
|
Checkbox |
false |
Supplier_Formula__c |
Supplier |
Pre-Spring 2020 |
Formula: IF(SCMC__Supplier_Site__c != null, SCMC__Supplier_Site__r.Name, SCMC__New_Supplier__c )
|
Text |
|