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