Fields in the Subscriptions Data Set

Important: You must enable the respective additional data set to generate this report type.

This report provides detailed information about all subscriptions of a user and the user's sub-accounts that were created in a chosen period.

Field Description

The table below describes fields available in this report data set.

Field name Type Description Example

SUBSCRIPTION_RESELLER_ID

integer

The reseller's unique identifier in the CloudBlue Commerce platform.

1000001

SUBSCRIPTION_RESELLER_NAME

text

The reseller's company name.

Reseller Inc

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_ ID

integer

The unique subscription identifier in the CloudBlue Commerce platform.

1000065

SUBSCRIPTION_NAME

text

The subscription name.

O2 Office 365

SUBSCRIPTION_PLAN_ID

integer

The unique identifier of a service plan in the CloudBlue Commerce platform.

18

SUBSCRIPTION_PLAN_NAME

text

The name of a service plan.

"en Cloud VPS Services"

SUBSCRIPTION_PO_NUMBER

integer

The order number of the provisioned subscription.

1000065

SUBSCRIPTION_STATUS

text

10: Ordered

15: Trial

30: Active

40: Graced

50: Expired

60: Terminated

70: Canceled

80: Administrative Hold

85: Credit Hold

89: Credit + Administrative Hold

30

SUBSCRIPTION_SERVICE_STATUS

integer

The service status.

10

SUBSCRIPTION_START_DATE_INT

integer

The subscription's start date as an integer.

1678395600

SUBSCRIPTION_START_DATE

text

The subscription's start date in a human-readable format.

2020-01-01

SUBSCRIPTION_EXP_DATE_INT

integer

The subscription expiration date as an integer.

1678395600

SUBSCRIPTION_EXP_DATE

text

The subscription expiration date in a human-readable format.

2020-01-01

SUBSCRIPTION_LAST_BILLING_DATE_INT

integer

The subscription last billing date as an integer.

1678395600

SUBSCRIPTION_LAST_BILLING_DATE

text

The subscription last billing date in a human-readable format.

2020-01-01

SUBSCRIPTION_NEXT_BILLING_DATE_INT

integer

The subscription next billing date as an integer.

1678395600

SUBSCRIPTION_NEXT_BILLING_DATE

text

The subscription next billing date in a human-readable format.

2020-01-01

SUBSCRIPTION_TERMINATION_DATE_INT

integer

The subscription cancellation date as an integer.

1678395600

SUBSCRIPTION_TERMINATION_DATE

text

The subscription cancellation date in a human-readable format.

2020-01-01

SUBSCRIPTION_PROMO_CODE

text

The promo code applied to the subscription.

promo

SUBSCRIPTION_PROMO_START_DATE_INT

integer

The start date of the promotional discount applied to the subscription as an integer.

1645532843

SUBSCRIPTION_PROMO_START_DATE

text

The start date of the promotional discount applied to the subscription in a human-readable format.

2020-01-01

SUBSCRIPTION_PROMO_END_DATE_INT

integer

The end date of the promotional discount that was applied to the subscription as an integer.

1645532843

SUBSCRIPTION_PROMO_END_DATE

text

The end date of the promotional discount that was applied to the subscription in a human-readable format.

2020-01-01

SUBSCRIPTION_SUSPENSION_CODE

integer

The subscription suspension code.

20

SUBSCRIPTION_SUSPENSION_REASON

text

The suspension reason (Comment).

Reason comment

SUBSCRIPTION_TERMINATION_CODE

integer

The subscription termination code.

10

SUBSCRIPTION_TERMINATION_REASON

text

The termination reason (Comment).

Termination comment

SUBSCRIPTION_AUTO_RENEWAL

boolean

Auto-renewal enabled or disabled.

True

SUBSCRIPTION_BILLING_PERIOD_TYPE

text

The subscription period type: month or year.

month

SUBSCRIPTION_PERIOD_DURATION

integer

Duration of a subscription period.

12

SUBSCRIPTION_PERIOD_TYPE

integer

The duration type of a subscription period.

1

SUBSCRIPTION_CURRENCY

text

The currency for the subscription.

EUR

SUBSCRIPTION_NOTES

text

All notes for the subscription are exported to one field. The following format is used: Short_Description :: Description. Notes are separated by the | symbol.

Description | Long Description

SUBSCRIPTION_ATTRIBUTES

JSON

All attributes of a subscription.

 

SUBSCRIPTION_CRTD_USER_USERIDS

integer

The date when the information about the account was updated by the user.

0000000001

ACCOUNT_CRTD_DATETIME

integer

The date when the information about the account was updated by the platform.

1646073342
CloudBlue, an Ingram Micro business, uses cookies to improve the usability of our site. By continuing to use this site and/or logging in you are accepting the use of these cookies. For more information, visit our Privacy Policy.