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 |