3

i am following this link http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_erd_products.htm .In this ER diagram there is Pricebook2Id field on Opportunity Object but i can't see any field in Opportunity Object in my dev org which is related to Pricebook.In this there is an object mentioned PricebookEntry object but there is Pricebook Object but no PricebookEntry object.Where are these fields and objects .can u please clarify ??

screen shot of Opportunity Fields enter image description here

here is no Pricebook2Id field.

Improve this question
4
  • 1
    Where are you checking this field and object for ?I would recommend you to check backend in schema explorer rather than front end .
    – Mohith Shrivastava
    Commented Mar 26, 2014 at 13:49
  • i saw all the fields of Opportunity.giving screen shot of that in question.there is no field name as Pricebook2Id.but its mentioned in ER diagram.
    – mathlearner
    Commented Mar 26, 2014 at 14:02
  • sorry on a network where these images are blocked ..hold on i will see my mobile and get back
    – Mohith Shrivastava
    Commented Mar 26, 2014 at 14:05
  • Yes saw the screenshot .These objects will be visible in your database .Not from SFDC UI.So you wont find them .Hope that helps .As below ProcebookEntry is junction between Pricebook2 and Product2
    – Mohith Shrivastava
    Commented Mar 26, 2014 at 14:12

3 Answers 3

Reset to default
3

To add to Artur's explanation ..

A PricebookEntry (PBE) is a junction record between a Product2 and a Pricebook2. It represents a price for a given currency. 

Example: Three currencies USD, AUD, GBP

Standard pricebook - PBE USD 10.00 - Product2 SKU AAA
Standard pricebook - PBE AUD 11.00 - Product2 SKU AAA
Standard pricebook - PBE GBP 7.00 - Product2 SKU AAA

Custom pricebook1  - PBE USD 10.00 - Product2 SKU AAA
Custom pricebook1 - PBE AUD 11.00 - Product2 SKU AAA
Custom pricebook1 - PBE GBP 7.00 - Product2 SKU AAA

Custom pricebook2  - PBE USD 5.00 - Product2 SKU AAA
Custom pricebook2 - PBE AUD 5.50 - Product2 SKU AAA
Custom pricebook2 - PBE GBP 3.50 - Product2 SKU AAA

where custom pricebook1 is your commercial pricebook where custom pricebook2 is your non-profit/government pricebook

Improve this answer
2

PriceBookEntry:

Represents a product entry (an association between a Pricebook2 and Product2) in a price book.

You create PricebookEntry for example when you create standard price on product. And thats why you can find PriceBookEntryId field on opportunity product

https://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_pricebookentry.htm

Improve this answer
0

Price Books are list of products and their associated prices. Each product and its price is called a price book entry. So, if you want to speak in relationship terms, a Product may be on multiple Pricebooks; this is managed with a junction record called PricebookEntry.enter image description here See this for more

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .