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.

1645532843

SUBSCRIPTION_STATUS

text

  • Purchased

  • Provisioning

  • Installed

  • Failed

  • Ordered

  • Not included

  • Removing

  • Disabled

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:

  • 10: Standard

  • 20: Switch a plan

  • 30: Additional

  • 40: Sync with a plan

  • 50: Upgrade or downgrade

30

SUBSCRIPTION_RESOURCE_IS_MEASURABLE

integer

This indicates whether the resource is measurable:

  • 0: No

  • 1: Yes

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