SubscriptionEvents
Lists all events for a specific subscription.
Table Specific Information
Select
The 本製品 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. |