PricebookEntry

This is a table representing the PricebookEntry entities in Salesforce.

Columns

Name	Type	Description	ReadOnly
Id [KEY]	System.String	Label 'Price Book Entry ID' corresponds to this field.	True
Name	System.String	Label 'Product Name' corresponds to this field.	True
Pricebook2Id	System.String	Label 'Price Book ID' corresponds to this field.	True
Product2Id	System.String	Label 'Product ID' corresponds to this field.	True
UnitPrice	System.Double	Label 'List Price' corresponds to this field.	False
IsActive	System.Boolean	Label 'Active' corresponds to this field.	False
UseStandardPrice	System.Boolean	Label 'Use Standard Price' corresponds to this field.	False
CreatedDate	System.DateTime	Label 'Created Date' corresponds to this field.	True
CreatedById	System.String	Label 'Created By ID' corresponds to this field.	True
LastModifiedDate	System.DateTime	Label 'Last Modified Date' corresponds to this field.	True
LastModifiedById	System.String	Label 'Last Modified By ID' corresponds to this field.	True
SystemModstamp	System.DateTime	Label 'System Modstamp' corresponds to this field.	True
ProductCode	System.String	Label 'Product Code' corresponds to this field.	True
IsDeleted	System.Boolean	Label 'Deleted' corresponds to this field.	True

Pseudo-Columns

Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
SOQLWhere	String	Specifies the Where clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.
SOQLOrderBy	String	Specifies the Order By clause of the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precendence over any other input.
MaxResults	String	Sets the MaxResults to be returned by modifying the Limit clause of the SOQL query to execute against the Salesforce servers.