Fields in the Service Plan Resource Rates Data Set
Important: You must enable the respective additional data set to generate this report type.
This report provides detailed information about all resource rates for service plans created in a chosen period.
Field Description
The table below describes fields available in this report data set.
Field name | Type | Description | Example |
---|---|---|---|
PLAN_ID |
integer |
The unique identifier of the service plan. |
17 |
PLAN_NAME |
text |
The name of the service plan. |
O2 UK Office 365 Small - Business |
PLAN_RR_ID |
integer |
The unique identifier of the resource rate. |
56 |
PLAN_RR_RESOURCE_ID |
integer |
The unique identifier of the resource. |
1000171 |
PLAN_RR_RESOURCE_NAME |
text |
The resource name. |
Office 365 Small Business |
PLAN_RR_RESOURCE_CATEGORY |
text |
The resource category. |
Collaboration Office 365 |
PLAN_RR_INCLUDED_AMOUNT |
double |
The resource amount included in the service plan. |
0 |
PLAN_RR_MAX_AMOUNT |
double |
The maximum amount of the resource available with the service plan. |
25 |
PLAN_RR_UOM |
text |
The resource unit of measure. |
unit |
PLAN_RR_UNIT_CURRENCY |
text |
The three-letter resource currency code. |
EUR |
PLAN_RR_SETUP_SKU |
integer |
The Setup SKU ID. |
1.2 |
PLAN_RR_RECURRENT_SKU |
integer |
The Recurrent SKU ID. |
1.3 |
PLAN_RR_OVERUSE_SKU |
integer |
The Overuse SKU ID. |
1.4 |
PLAN_RR_CANCELLATION_SKU |
integer |
The Cancellation SKU ID. |
1.5 |
PLAN_RR_SETUP_FEE |
numeric |
The resource setup fee. |
0 |
PLAN_RR_RECURRENT_FEE |
numeric |
The resource recurrent fee. |
0 |
PLAN_RR_OVERUSE_FEE |
numeric |
The resource overuse fee. |
0 |
PLAN_RR_CANCELLATION_DESCRIPTION |
text |
The resource cancellation description. |
Office 365 Licenses Cancellation |
PLAN_RR_MPN |
text |
The ID or MPN of the resource rate. |
6dfbeff5-88df-4f11-82c7-6f0f2e5f1372 |
PLAN_ID |
integer |
The unique identifier of the service plan. |
17 |
PLAN_NAME |
text |
The name of the service plan. |
O2 UK Office 365 Small - Business |
PLAN_CATEGORY_ID |
numeric |
The internal ID of the plan category. |
2 |
PLAN_CATEGORY_NAME |
text |
The plan category name. |
Office 365 |