SubscriptionEvents
Lists all events for a specific subscription.
Table Specific Information
Select
The add-in will execute all filters to this view client-side, in memory.
Retrieve the list of all subscription events for a subscription id. The Subscription Id is required to access the view.
SELECT * from SubscriptionEvents where Id = 'fd9d6200-bb12-43c5-9973-070bfc6f5e05'
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID of the subscription event. |
| SubscriptionEventType | String | Type of the subscription event. |
| PlanVariationId | String | The ID of the subscription plan variation associated with the subscription. |
| EffectiveDate | Datetime | The YYYY-MM-DD-formatted date when the subscription event occurred. |
| InfoDetail | String | A human-readable explanation for the subscription event. |
| InfoCode | String | An info code indicating the subscription event that occurred. |
| PhasesUID | String | The id of subscription phase. |
| PhasesOrdinal | Int64 | The index of phase in total subscription plan. |
| PhasesOrderTemplateId | String | The id of order to be used in billing. |
| PhasesPlanPhaseUID | String | The uid from the plan's phase in catalog. |