Fields in the Service Plans Data Set
Important: You must enable the respective additional data set to generate this report type.
This report provides detailed information about all 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 internal ID of the service plan. |
12316 |
PLAN_APS_ID |
integer |
The APS ID of the service plan. |
0e1f8a15-c6fd-4069-a958-009b01211b60 |
PLAN_NAME |
text |
The multilingual name of the service plan (for example, "en Cloud Storage es Almacenamiento en la nube"). |
O2 DE Office 365 Small Business + Box |
PLAN_ST_ID |
integer |
The unique identifier of the service template. |
420 |
PLAN_ST_NAME |
text |
The name of the service template. |
O2 DE Office 365 Small Business + Box |
PLAN_SUBSCRIPTIONS_QTY |
integer |
The number of subscriptions to the service plan. |
2 |
PLAN_AVAILABLE_FOR_SALE |
text |
Where the service plan is available:
|
In CCP Only |
PLAN_OTF_ITEM |
boolean |
One of the following values:
|
0 |
PLAN_PERIOD_ID |
JSON |
The ID of the service plan period. |
[89316,89864,56787] |
PLAN_CATEGORY_ID |
integer |
The internal ID of the plan category. |
2 |
PLAN_CATEGORY_NAME |
text |
The name of the plan category. |
Office 365 |
PLAN_IS_PUBLISHED |
boolean |
Indicates whether the plan is published. |
true |
PLAN_IS_AUTO_RENEW |
boolean |
Indicates whether the plan is auto-renewed. |
false |
PLAN_PARENT_ID |
integer |
The internal ID of the parent plan. |
12315 |
PLAN_RESELLER_ID |
integer |
The reseller ID of the service plan owner. Example: L0 (account 10001) creates the Service Plan X and delegates it to an L1 Reseller (account 10006). If a provider executes the Service Plans report, they will see two Service Plans X, one belonging to account 10001 and the other one belonging to account 10006. It is the same service plan owned by different accounts in the hierarchy. |
10000001 |