Order and Inventory Management Data Dictionary

Sourcing_to_Supplier_Association__c

Label: Supplier RFQ

This is an internal junction object that manages the many to many relationships between Sourcing (i.e., RFQ, RFP, RFI) activities and Suppliers. Each Sourcing request can be sent to multiple Suppliers and each Supplier can have multiple Sourcing activities active at one time.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Building_Information__c Building Information Pre-Spring 2018 Text(100)
Customer_Quotation__c Customer Quotation Pre-Spring 2018 Looks up to: Customer_Quotation__c
Lookup
Deliver__c Deliver Pre-Spring 2018 Formula:
HYPERLINK(PageReferenceDeliver__c & "?id=" & Id, $Label.Deliver, "_self")
Text
Established__c Established? Pre-Spring 2018 This is always true if this association is with an established supplier. The field is set when the association is created.

Checkbox false
ILSMart_com_ID__c DEPRECATED: ILSMart.com ID Pre-Spring 2018 This field is obsolete.

Text(20)
Mailing_City__c Mailing City Pre-Spring 2018 Text(100)
Mailing_Country__c Mailing Country Pre-Spring 2018 Text(100)
Mailing_State_Province__c Mailing State / Province Pre-Spring 2018 Text(100)
Mailing_Street_Additional_Information__c Mailing Street Additional Information Pre-Spring 2018 Text(100)
Mailing_Street__c Mailing Street Pre-Spring 2018 TextArea
Mailing_Zip_Postal_Code__c Mailing Zip / Postal Code Pre-Spring 2018 Text(15)
PageReferenceDeliver__c PageReferenceDeliver Pre-Spring 2018 This is not to be displayed to the end user. This is used only to host the page address for the deliver link.

Text(255)
PageReferencePrint__c PageReferencePrint Pre-Spring 2018 This is not to be displayed to the end user. This is used only to host the page address for the print link.

Text(255)
Potential_Supplier_Contact_Name__c Potential Supplier Contact Name Pre-Spring 2018 Text(255)
Potential_Suppliers_E_Mail_Address__c Potential Suppliers E-Mail Address Pre-Spring 2018 Email
Potential_Suppliers_FAX_Number__c Potential Suppliers FAX Number Pre-Spring 2018 Phone
Potential_Suppliers_Name__c Potential Suppliers Name Pre-Spring 2018 This is an unknown supplier that we have not done business with historically

Text(50)
Potential_Suppliers_Phone_Number__c Potential Suppliers Phone Number Pre-Spring 2018 Phone
Preferred_Communication__c Preferred Communication Pre-Spring 2018 The preferred communication vehicle for correspondence

Picklist:
E-Mail
FAX
Mail
Phone
Print__c Print Pre-Spring 2018 Deliver the sourcing request to this supplier.

Formula:
HYPERLINK(PageReferencePrint__c & "?id=" & Id, $Label.Print, "_blank")
Text
Sourcing__c Sourcing Pre-Spring 2018 Looks up to: Sourcing__c
Lookup
Status_Change_Date__c Status Change Date Pre-Spring 2018 The date and time that the status changed

DateTime
Status__c Status Pre-Spring 2018 Indicates whether an RFQ has been sent to this supplier or not.

Picklist:
RFQ Delivered
RFQ Not Delivered
Supplier_Address__c Supplier Address Pre-Spring 2018 Formula:
Supplier_Site__r.Mailing_Street__c + BR() + Supplier_Site__r.Mailing_Street_Additional_Information__c + BR() + Supplier_Site__r.Building_Information__c + BR() + Supplier_Site__r.Mailing_City__c + ", " + Supplier_Site__r.Mailing_State_Province__c + ", " + Supplier_Site__r.Mailing_Zip_Postal_Code__c + ", " + Supplier_Site__r.Mailing_Country__c
Text
Supplier_Contact__c Supplier Contact Pre-Spring 2018 A known contact at an existing supplier

Looks up to: Supplier_Contact__c
Lookup
Supplier_Office_Phone__c Supplier Office Phone Pre-Spring 2018 Formula:
Supplier_Site__r.Office_Phone__c
Text
Supplier_Phone__c Supplier Phone Pre-Spring 2018 Formula:
IF( Supplier_Site__c != '', Supplier_Site__r.Office_Phone__c , Potential_Suppliers_Phone_Number__c )
Text
Supplier_Site__c Established Supplier Pre-Spring 2018 This is a known supplier that we have done successful business with historically

Looks up to: Supplier_Site__c
Lookup
Supplier__c Supplier Pre-Spring 2018 Formula:
IF( Supplier_Site__c != '', Supplier_Site__r.Name , Potential_Suppliers_Name__c )
Text
Type__c Type Pre-Spring 2018 The type of association between sourcing requests and suppliers. It can be created either manually, from a catalogue, or based on the history from a purchase order or a quote.

Picklist:
Catalogue
Manual
PO History
Quote History


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