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 Online Store and CCP
  • In CCP Only
  • In Online Store Only
  • No

In CCP Only

PLAN_OTF_ITEM

boolean

One of the following values:

  • 0: no
  • 1: yes

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