Supply Chain Management Advanced Quoting Data Dictionary

SCMC__Customer_Quotation_Line__c

Label: SCMC__Customer_Quotation_Line__c

Adding fields to an object in a different managed package

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


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