Activity Forums Salesforce® Discussions Give an example of a standard object that’s also junction object.

  • Prachi

    Member
    September 13, 2018 at 1:41 pm

    hi,

    OpportunityContactrole is the junction between Opportunity and Contact, and also Quote is the junction between Contract and Opportunity. PriceBookEntry is a junction between Product2 and Pricebook2 .

    thanks.

  • Parul

    Member
    September 13, 2018 at 1:47 pm

    Hello Avanish,

    There are many standard objects which behaves as junction object as well. Some of them are:

    • PricebookEntry behaves as junction object between Product and Pricebook.
    • Quote object behaves as junction between Contact and Opportunity.
    • Opportunity Product behaves as junction between Opportunity and Product.

    Hope this will help you.

  • Avnish Yadav

    Member
    September 13, 2018 at 1:52 pm

    Hey, Parul can you explain, how opportunity product behave as junction object because opportunity product is not directly related to product.

    Thanks.

  • shariq

    Member
    September 13, 2018 at 3:01 pm

    Hi,

    Pricebook entry is an object in the salesforce which is standard object and junction object to :

    For getting information about  Pricebook entry go  to the schema builder by typing it in quick search box in the setup:

    where you filter the objects by typing pricebookentry in search box and you will get information about junction object pricebook entry

    Hope this helps!

  • Parul

    Member
    September 13, 2018 at 3:57 pm

    Hi Avnish,

    Because opportunity product (Opportunity LineItem) is a junction object between opportunity and pricebookentry.

    For further knowledge read this :-

    Opportunity:
    Opportunity object stores data of potential sales and pending sales.
    One opportunity can only have one pricebook.
    One opportunity can contain one or many line items.

    Product:
    Product object is a catalogue of items or services for sales.
    A product may contain one or more different sets of prices (PriceBookEntry).

    OpportunityLineItem:
    List of products that link with opportunity containing data on types of products and respective prices.
    One opportunity line item can only be linked to one opportunity.
    One opportunity line item can only be linked to one price book entry.

    PricebookEntry:
    PricebookEntry object is a product entry in a pricebook.
    This object allows products to be linked to standard price book or custom price book.
    One price book entry is linked to only one product.
    One price book entry can only appear in one pricebook.
    One price book entry can be used in multiple line items. This also further creates flexibility for users to set their own prices.

     

    Hope this will help you.!

     

    Thanks

  • shariq

    Member
    September 14, 2018 at 1:08 am

    Hi Avinish,

    For more clarity, we create junction object to have multiple to multiple relationship between other two objects.

    For example :- One product can have multiple price and same price can be on multiple products.

    Hope this helps.

  • Adesh

    Member
    July 11, 2021 at 5:34 am

    Hi Parul
    Can you please explain a bit how Quote is behaving as Junction object between Opportunity and Contract?

Log In to reply.

Popular Salesforce Blogs