Zuora: Billing History

Description

• Each record is an invoice to evaluate the history of charges billed, enhanced with additional details from payments, refunds, adjustments, discounts, and taxes.

Supported Data Sources

• Zuora

Columns

Type	Name	Description
STRING	invoice_id	The unique identifier of the invoice table.
STRING	account_id	The account associated with the invoice.
DATETIME	created_at	The time at which the invoice was created.
STRING	invoice_number	The unique identification number for the invoice.
DATE	invoice_date	Specifies the date on which to generate the invoice.
DECIMAL	invoice_amount	The sum of all charges and taxes associated with the invoice.
DECIMAL	invoice_amount_home_currency	The sum of all charges and taxes associated with the invoice in its home currency.
DECIMAL	invoice_amount_paid	The amount of the invoice currently paid for.
DECIMAL	invoice_amount_unpaid	The amount of the invoice yet to be paid for.
DECIMAL	tax_amount	The total amount of the taxes applied to the invoice.
INTEGER	refund_amount	The amount of refunds applied to the invoice.
DECIMAL	credit_balance_adjustment_amount	The amount of the credit balance adjustment applied to the invoice.
INTEGER	tax_amount_home_currency	The amount of tax in home currency for the invoice.
STRING	transaction_currency	Transaction currency the customer is billed in.
STRING	home_currency	Home currency the customer is billed in.
DATE	exchange_rate_date	The date of the exchange rate used for the invoice.
DATE	due_date	The due date of the invoice.
STRING	status	The status of the invoice in the system. This status is not the status of the payment of the invoice just the status of the invoice itself.
STRING	purchase_type	The type of the invoice source.
INTEGER	invoice_items	The amount of invoice items in the invoice.
INTEGER	products	The number of products billed in the invoice.
INTEGER	subscriptions	The number of subscriptions in the invoice.
DECIMAL	discount_charges	The discount charges applied to the invoice.
DECIMAL	discount_charges_home_currency	The discount charges home currency applied to the invoice.
DECIMAL	units	The units in the invoice.
DATETIME	first_charge_date	The first charge date for the invoice.
DATETIME	most_recent_charge_date	The most recent charge date for the invoice.
DATE	invoice_service_start_date	Earliest invoice item service start date for the invoice.
DATE	invoice_service_end_date	Earliest invoice item service end date for the invoice.
INTEGER	payments	The number of payments applied to the invoice.
DECIMAL	invoice_amount_paid_home_currency	The amount of the invoice amount paid in the home currency on the invoice.
DECIMAL	invoice_amount_unpaid_home_currency	The amount of the invoice amount unpaid in the home currency on the invoice.
DATE	first_payment_date	The first date when a payment is applied to the invoice.
DATE	most_recent_payment_date	The most recent date when a payment is applied to the invoice.
INTEGER	payment_methods	The number of payment methods associated with the invoice.
INTEGER	credit_balance_adjustments	The number of the credit balance adjustments applied on the invoice.
DECIMAL	credit_balance_adjustment_amount_home_currency	The amount for the credit balance adjustment in home currency on the invoice.
DATE	first_credit_balance_adjustment_date	The first date when a credit balance adjustment is applied to the invoice.
DATE	most_recent_credit_balance_adjustment_date	The most recent date when a credit balance adjustment is applied to the invoice.