Supplier Account Object Reference

Overview

Product Supplier joins a product to the supplier's account. A product can have multiple suppliers so you can create multiple Product Supplier records per product.

Property Value
API Name s_c__Product_Supplier__c
Label Supplier Account
Plural Label Supplier Accounts
Type Custom Object

Fields

Field Label API Name Type Required Description
Account s_c__Account_Id__c Lookup (Account) Yes The account record for the supplier.
Landed Cost s_c__Landed_Cost__c Number(18,2) No Defines the total landed costs price (including shipping and other costs blended across all previous orders) from this supplier.
Minimum Order Quantity s_c__Minimum_Order_Quantity__c Number(18,0) No Specifies the minimum quantity of this product that can be ordered from this supplier.
Product s_c__Product_Id__c Lookup (Product2) No The product that can be supplied by the supplier
Purchase Price s_c__Purchase_Price__c Number(18,2) No Defines the unit cost price of this item from this supplier.
Supplier Phone s_c__Supplier_Phone__c Formula (Text) No Formula field that grabs the phone number from the supplier's account so it can be displayed in the related list for the product.
Units Of Measure s_c__Units_Of_Measure__c Number(18,0) No Specifies quantity multiple used for ordering. For example, if a product needs to be ordered in multiples of 50, then this field should be 50.
StoreConnect External ID s_c__sC_Id__c Text(36) No StoreConnect External ID, do not modify in Salesforce

Relationships

Field Type Related Object Relationship Name
s_c__Account_Id__c Lookup Account Product_Supplier
s_c__Product_Id__c Lookup Product2 Product_Suppliers