Zuora: Subscription Overview

Description

• Each record is a subscription, enhanced with additional details from rate plan charges and amendments.

Supported Data Sources

• Zuora

Columns

Type	Name	Description
STRING	subscription_key	The unique subscription key, defined by subscription id and rate plan charge id.
STRING	subscription_id	The unique identifier for the subscription.
STRING	account_id	The unique identifier for the account associated with the subscription.
STRING	account_name	The account name associated with the subscription.
BOOLEAN	auto_renew	Indicates whether the subscription is set to automatically renew at the end of the term.
INTEGER	cancel_reason	The reason for cancelling the subscription, if applicable.
DATETIME	cancelled_date	The date on which the subscription was cancelled, if applicable.
INTEGER	current_term	The length of the current subscription term.
STRING	current_term_period_type	The unit of time for the current subscription term (e.g. "Month", "Year").
INTEGER	initial_term	The length of the initial subscription term.
STRING	initial_term_period_type	The unit of time for the initial subscription term (e.g. "Month", "Year").
BOOLEAN	is_latest_version	Indicates whether the subscription is the latest version of the subscription on the account.
STRING	previous_subscription_id	The unique identifier for the previous subscription associated with the subscription.
INTEGER	renewal_term	The length of the renewal subscription term.
STRING	renewal_term_period_type	The type of the renewal term for the subscription.
DATETIME	service_activation_date	The date the subscription was activated.
STRING	status	The status of the subscription.
DATETIME	subscription_start_date	The start date of the subscription.
DATETIME	subscription_end_date	The end date of the subscription.
DATETIME	term_start_date	The start date of the subscription term.
DATETIME	term_end_date	The end date of the subscription term.
STRING	term_type	The type of subscription term.
INTEGER	version	The version number of the subscription.
STRING	rate_plan_charge_id	The identifier for the rate plan charge associated with the subscription.
STRING	rate_plan_charge_name	The name of the rate plan charge associated with the subscription.
STRING	charge_billing_period	The billing period for the charge associated with the subscription.
STRING	charge_billing_timing	The billing timing for the charge associated with the subscription.
STRING	charge_model	The model used to calculate the charge associated with the subscription.
STRING	charge_type	TThe type of charge associated with the subscription.
DATE	charged_through_date	The date through which the charge has been charged on the subscription.
DATE	charge_effective_start_date	The date on which the rate plan charge goes into effect on the subscription.
DATE	charge_effective_end_date	The date on which the rate plan charge is no longer in effect on the subscription.
DECIMAL	charge_mrr	The monthly recurring revenue of the rate plan charge associated with the subscription.
DECIMAL	charge_mrr_home_currency	The monthly recurring revenue of the rate plan charge in the home currency associated with the subscription.
STRING	amendment_id	The id of the amendment associated with the subscription.
STRING	amendment_name	The name of the amendment associated with the subscription.
DATE	amendment_booking_date	The date when the amendment is signed.
DATETIME	amendment_creation_date	Creation date for the amendment.
STRING	amendment_type	The type of amendment associated with the subscription.
STRING	amendment_status	The status of the amendment associated with the subscription.
DATE	amendment_contract_date	The date when the amendment's changes become effective for billing purposes.
DATE	amendment_activation_date	The date when service is activated for the amendment.
INTEGER	current_term_days	The length of the current term of the subscription in days.
INTEGER	initial_term_days	The length of the initial term of the subscription in days.
INTEGER	renewal_term_days	The length of the renewal term of the subscription in days.
INTEGER	subscription_days	The length of the subscription in days.
INTEGER	term_days	The length of the subscription term in days.