OpportunityEditHistory
Tracks historical updates that are applied to Opportunity records. This table supports sales accountability by documenting lifecycle changes that affect forecasting, pipeline management, and revenue analysis.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Represents the unique identifier (Id) of the OpportunityEditHistory table. This value enables Bullhorn CRM to track distinct edit-history records that document changes made to Opportunity data. |
| AuditTrail | String | False |
Captures the audit trail information that is stored for the OpportunityEditHistory record. This field provides a structured history of modifications so users can review the sequence of edits that is applied to the related Opportunity. |
| DateAdded | Datetime | False |
Indicates the datetime when the OpportunityEditHistory record is created. This timestamp supports chronological analysis and ensures accountability in change tracking workflows. |
| MigrateGUID | String | False |
Stores the unique identifier for the migration object that is associated with the OpportunityEditHistory record. This value supports external system migrations and helps maintain referential continuity during data imports. |
| ModifyingPersonId | Int | False |
Specifies the Id of the person who performs the modification that results in the OpportunityEditHistory record. This association reinforces audit transparency and identifies the user responsible for each change. |
| TransactionID | String | False |
Captures the transaction Id that is linked to the OpportunityEditHistory record. This value ties the edit event to a specific operation so Bullhorn CRM can correlate related actions within the same transaction. |