Fields in the Subscription Resources Data Set
Important: You must enable the respective additional data set to generate this report type.
This report provides detailed information about the resources of subscriptions belonging to the user and the user's sub-accounts.
Field Description
The table below describes fields available in this report data set.
Field name | Type | Description | Example |
---|---|---|---|
SUBSCRIPTION_ID |
integer |
The unique subscription identifier. |
1000023 |
SUBSCRIPTION_NAME |
text |
The subscription name. |
O2 DE Office 365 Lync |
SUBSCRIPTION_ACCOUNT_ID |
integer |
The unique identifier of the account in the CloudBlue Commerce platform. |
1000006 |
SUBSCRIPTION_ACCOUNT_NAME |
text |
The account company name. |
Company Inc |
SUBSCRIPTION_RESELLER_ID |
integer |
The unique identifier of the reseller in the CloudBlue Commerce platform. |
1000001 |
SUBSCRIPTION_RESELLER_NAME |
text |
The reseller company name. |
Reseller Inc |
SUBSCRIPTION_START_DATE |
integer |
The subscription start date. |
2023-05-06 |
SUBSCRIPTION_STATUS |
text |
|
Installed |
SUBSCRIPTION_PERIOD |
integer |
The subscription period duration. |
1 |
SUBSCRIPTION_PERIOD_TYPE |
integer |
The subscription period duration type. |
10 |
SUBSCRIPTION_RESOURCE_ID |
integer |
The unique resource identifier. |
1000234 |
SUBSCRIPTION_RESOURCE_RATE_ID |
integer |
The ID of a resource rate. |
1000234 |
SUBSCRIPTION_RESOURCE_NAME |
text |
The resource name. |
Office 365 Medium Business |
SUBSCRIPTION_RESOURCE_CATEGORY |
text |
The resource category. |
Collaboration Office 365 |
SUBSCRIPTION_RESOURCE_INCL_AMOUNT |
integer |
The included amount of a resource. |
10 |
SUBSCRIPTION_RESOURCE_ADDITIONAL_AMOUNT |
integer |
The additional amount of a resource. |
5 |
SUBSCRIPTION_RESOURCE_ORDERED_AMOUNT |
double |
The ordered amount of resources. |
10 |
SUBSCRIPTION _RESOURCE_UNIT |
text |
The unit of measure for a resource. |
unit |
SUBSCRIPTION_RESOURCE_MIN_UNITS |
integer |
The minimum number of units. |
10 |
SUBSCRIPTION_RESOURCE_MAX_UNITS |
integer |
The maximum number of units |
15 |
SUBSCRIPTION_RESOURCE_RELATIVE_STATUS |
integer |
The relative status of a subscription resource, which indicates an order type related to a subscription resource:
|
30 |
SUBSCRIPTION_RESOURCE_IS_MEASURABLE |
integer |
This indicates whether the resource is measurable:
|
0 |
SUBSCRIPTION_RESOURCE_UNIT_PRICE |
numeric |
The subscription resource price per unit. This price is used to sell goods. |
129.50 |
SUBSCRIPTION_RESOURCE_UNIT_CURRENCY_CODE | text | The currency code (three symbols) of the currency in which the reseller sells goods. | RUB |
SUBSCRIPTION_RESOURCE_UNIT_RESELLER_PRICE |
numeric | The subscription resource price per unit. This price is used to buy goods. | 6.5 |
SUBSCRIPTION_RESOURCE_RESELLER_UNIT_CURRENCY_CODE | text | The currency code (three symbols) of the currency in which the reseller buys goods to resell. | EUR |
SUBSCRIPTION_RESOURCE_AMOUNT | numeric | The total number of sold subscription resources (included and additional). | 10 |
SUBSCRIPTION_RESOURCE_RESELLER_PRICE_TOTAL | numeric | The total (extended) price for bought goods without taxes. | 18.5 |
SUBSCRIPTION_RESOURCE_PRICE_TOTAL | numeric | The total (extended) price for sold goods without taxes. | 17.5 |
SUBSCRIPTION_RESOURCE_SETUP_FEE |
numeric |
The subscription setup fee. |
1.5 |
SUBSCRIPTION_RESOURCE_RECURRING_FEE |
numeric |
The subscription recurring fee. |
2.5 |
SUBSCRIPTION_RESOURCE_OVERUSE_FEE |
numeric |
The subscription overuse fee. |
3.2 |
SUBSCRIPTION_RESOURCE_VENDOR_SUBSCRIPTION_NUMBER |
text | The ID of a vendor subscription. | 123e4567-e89b-12d3-a456-426614174000 |
SUBSCRIPTION_RESOURCE_VENDOR_SKU |
text |
The SKU of a subscription resource. |
MSFT000E112 |
SUBSCRIPTION__RESOURCE_VENDOR_MPN |
text |
The MPN of a subscription resource. |
6dfbeff5-88df-4f11-82c7-6f0f2e5f1372 |
SUBSCRIPTION_EXP_DATE | integer | The subscription expiration date. | 2024-05-06 |
SUBSCRIPTION_BILLING_TYPE | text | The subscription billing type. | Charge Before Billing Period |
SUBSCRIPTION_BILLING_PERIOD | integer | The subscription billing period. | 1 |
SUBSCRIPTION_BILLING_PERIOD_TYPE | text | The subscription billing period type. | MONTHS |