Zuora: Line Item History

Description

• Each record is an invoice item meant to provide all details on all transactions at the most granular level, with details being brought in from subscriptions, amendments, rate plan charges, products, subscriptions, amendments and more.

Supported Data Sources

• Zuora

Columns

Type	Name	Description
STRING	invoice_item_id	The unique identifier of the invoice item table.
STRING	account_id	Identifier of the account associated with this invoice item.
DATE	account_creation_day	Day the account associated with the line item was created.
STRING	account_status	Status of the account associated with the line item.
STRING	amendment_id	Amendment identifier associated with the invoice item.
DECIMAL	balance	Balance of the invoice item.
DECIMAL	charge_amount	Amount charged for the invoice item.
DECIMAL	charge_amount_home_currency	Amount charged for the invoice item in the home currency.
DATETIME	charge_date	Date on which the charge for the invoice item was made.
DATE	charge_day	Day on which the charge for the invoice item was made.
DATE	charge_week	Week on which the charge for the invoice item was made.
DATE	charge_month	Month on which the charge for the invoice item was made.
STRING	charge_name	Name on which the charge for the invoice item was made.
DECIMAL	discount_amount	Discount amount applied for the invoice item.
DECIMAL	discount_amount_home_currency	Discount amount applied for the invoice item in the home currency.
DATE	first_charge_day	First charge day for the account associated with the invoice item.
STRING	home_currency	Home currency the customer is billed in.
STRING	invoice_id	The identifier for the invoice associated with the invoice item.
STRING	product_id	The identifier for the product associated with the invoice item.
STRING	product_rate_plan_id	The identifier for the product rate plan associated with the invoice item.
STRING	product_rate_plan_charge_id	The identifier for the product rate plan charge associated with the invoice item.
STRING	rate_plan_charge_id	The identifier for the rate plan charge associated with the invoice item.
DATE	service_start_day	Start date of the service associated with the invoice item.
DATE	service_start_week	Start week of the service associated with the invoice item.
DATE	service_start_month	Start month of the service associated with the invoice item.
DATE	service_end_date	End date of the service associated with the invoice item.
STRING	subscription_id	The id of the subscription associated with the invoice item.
STRING	sku	SKU of the invoice item.
DECIMAL	tax_amount	The tax amount for the invoice item.
INTEGER	tax_amount_home_currency	The tax amount for the invoice item in the home currency.
STRING	transaction_currency	Transaction currency the customer is billed in.
DECIMAL	unit_price	The unit price for the invoice item.
STRING	uom	The unit of measure for the invoice item.
STRING	invoice_number	The unique identification number for the invoice.
DATE	invoice_date	Specifies the date on which to generate the invoice.
DATE	invoice_due_date	The due date of the invoice.
BOOLEAN	subscription_auto_renew	Indicates whether the subscription is set to automatically renew at the end of the term.
INTEGER	subscription_cancel_reason	The reason for cancelling the subscription, if applicable.
DATETIME	subscription_cancel_date	The date on which the subscription was cancelled, if applicable.
DATETIME	subscription_service_activation_date	The date the subscription was activated.
STRING	subscription_status	The status of the subscription associated with the invoice item.
DATETIME	subscription_start_date	The start date of the subscription associated with the invoice item.
DATETIME	subscription_end_date	The end date of the subscription associated with the invoice item.
DATETIME	subscription_term_start_date	The start date of the subscription term associated with the invoice item.
DATETIME	subscription_term_end_date	The end date of the subscription term associated with the invoice item.
STRING	subscription_term_type	The type of subscription term associated with the invoice item.
INTEGER	subscription_version	The version number of the subscription for the invoice item.
STRING	rate_plan_charge_name	The name of the rate plan charge associated with the invoice item.
STRING	charge_billing_period	The billing period for the charge associated with the invoice item.
STRING	charge_billing_timing	The timing of the charge for the invoice item.
STRING	charge_model	The model used to calculate the charge for the invoice item.
STRING	charge_type	The type of charge for the invoice item.
DATE	charge_effective_start_date	The date on which the rate plan charge goes into effect for the invoice item.
DATE	charge_effective_end_date	The date on which the rate plan charge is no longer in effect for the invoice item.
INTEGER	charge_segment	The segment associated with the rate plan charge for the invoice item.
DECIMAL	charge_mrr	The monthly recurring revenue of the rate plan charge for the invoice item.
DECIMAL	charge_mrr_home_currency	The monthly recurring revenue of the rate plan charge in the home currency for the invoice item.
STRING	amendment_name	The name of the amendment associated with the invoice item..
STRING	amendment_type	The type of the amendment associated with the invoice item..
STRING	amendment_status	The status of the amendment associated with the invoice item.
STRING	product_name	The name of the product associated with the invoice item.
STRING	product_category	The category of the product associated with the invoice item.
STRING	product_description	The description of the product associated with the invoice item.
DATE	product_start_date	The date when the product becomes available for purchase.
DATE	product_end_date	The date when the product is no longer available for purchase.
STRING	product_rate_plan_name	The name of the product rate plan.
STRING	product_rate_plan_description	A brief description of the product rate plan.
DECIMAL	gross_revenue	The charge amount for the invoice item, accumulated as revenue.
DECIMAL	discount_revenue	The discount amount applied to the invoice item, accumulated as revenue.
DECIMAL	net_revenue	The difference between the gross and the discount revenue.