CompanySubscriptions
Represents a commercial subscription for a tenant.
View-Specific Information
SELECT
Id must be filtered using either the = or IN operator. For example:SELECT * from CompanySubscriptions WHERE Id = '4911b631-1b83-4384-9f22-9c8eb03e5c63'
SELECT * FROM CompanySubscriptions WHERE Id IN ('4911b631-1b83-4384-9f22-9c8eb03e5c63')
Columns
| Name | Type | Description |
| id [KEY] | String | The unique identifier for the company subscription. |
| commerceSubscriptionId | String | The ID of this subscription in the commerce system. |
| createdDateTime | Datetime | The date and time when the company subscription was created. |
| isTrial | Bool | Whether the subscription is a free trial or purchased. |
| nextLifecycleDateTime | Datetime | The date and time when the subscription will move to the next state if not renewed by the tenan. |
| ownerId | String | The object ID of the account admin. |
| ownerTenantId | String | The unique identifier for the Microsoft partner tenant that created the subscription on a customer tenant. |
| ownerType | String | Indicates the entity that ownerId belongs to. |
| serviceStatus | String | The provisioning status of each service included in this subscription. |
| skuId | String | The object ID of the SKU associated with this subscription. |
| skuPartNumber | String | The SKU associated with this subscription. |
| status | String | The status of this subscription. |
| totalLicenses | Int | The number of licenses included in this subscription. |