Returns the history of changes made to order properties for auditing purposes.

View Specific Information

SELECT

The PropertyName filter is required to retrieve data from this view. When querying OrderPropertiesHistory, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and IN.

SELECT * FROM OrderPropertiesHistory;
SELECT * FROM OrderPropertiesHistory WHERE PropertyName = 'hs_createdate';

Columns

Name	Type	References	Filterable	Description
PropertyName	String		True	Name of the order property that was changed.
Value	String		False	Previous or historical value of the property at the time of the change.
SourceType	String		False	Indicates how the property change occurred, such as via user action, workflow, or API.
SourceId	String		False	Additional metadata about the source of the change. This may be blank depending on the source type.
Timestamp	Datetime		False	Date and time when the property value was updated.
OrderId	Long		False	Unique identifier of the order associated with the property change.