OpportunityHistory

Tracks stage changes and progress updates for opportunity records.

Columns


Name	Type	References	Description
Id [KEY]	String		Unique identifier of the opportunity history record.
OpportunityId	String	Opportunity.Id	Reference to the opportunity associated with this history entry.
CreatedById	String	User.Id	ID of the user who made the update recorded in this history.
StageName	String		Opportunity stage at the time of the historical record.
Amount	Decimal		Opportunity amount value at the time of the historical record.
ExpectedRevenue	Decimal		Expected revenue value at the time of the historical record.
CloseDate	Date		Expected close date at the time of the historical record.
Probability	Double		Probability percentage at the time of the historical record.
ForecastCategory	String		Forecast category associated with the opportunity during this historical entry.
CurrencyIsoCode	String		ISO code for the currency in which the revenue amount is expressed.
IsDeleted	Bool		Indicates whether the opportunity history record has been deleted.
PrevAmount	Decimal		Field containing PrevAmount information.
PrevCloseDate	Date		Date associated with PrevClose.
SOQL	String		Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.
ExternalIdColumn	String		Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.
FilterScope	String		Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.
SystemModstamp	Datetime		System timestamp used for record tracking and replication.
CreatedDate	Datetime		Date and time when the opportunity update was recorded.

CData Python Connector for Salesforce

OpportunityHistory

Columns