Skip to main content

Daily Consumption Summary data source

Zuora

Daily Consumption Summary data source

Use this data source to retrieve the prepaid charge consumption summary each day.​

Navigate to Reporting > Data Sources and select Daily Consumption Summary from the Data Source list in the Basic Information section.

Base object

The following table lists the fields available in the Daily Consumption Summary base object.

Zuora Object Description
Daily Consumption Summary

The prepaid charge consumption summary in each day. It includes the following fields:

  • Charge Segment Number
  • Created By ID
  • Created Date
  • Daily Consumption Amount
  • Daily Total Qty
  • Drawdown Adjustment Rev GL Account Number
  • Drawdown Charge Segment Number
  • Drawdown Original Charge Id
  • Drawdown Recognized Rev GL Account Number
  • Usage Charge Name
  • Usage Charge Number
  • ID
  • Transaction Date
  • Updated By ID
  • Updated Date

Related objects

The following table lists the related objects of the Daily Consumption Summary object in alphabetical order.

Zuora Object Description
Entity

The entity that the data relates to. Part of the Multi-entity feature. It includes the following fields:

  • Address 1
  • Address 2
  • City
  • Country
  • Created By ID
  • Created Date
  • Display Name
  • Email
  • ID
  • Name
  • Postal Code
  • State
  • Updated By ID
  • Updated Date
Prepaid Balance Fund

The fund on the prepaid balance contained in the consumption summary. It includes the following fields:

  • Account Id
  • Balance
  • Charge Segment Number
  • Consumption Amount
  • Created by ID
  • Created Date
  • End Date
  • Funded Balance
  • Funding Price
  • ID
  • Priority
  • Start Date
  • Updated By ID
  • Updated Date
Product

The product information associated with the fund. It includes the following fields:

  • AllowFeatureChanges
  • Category
  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ID
  • Name
  • SKU
  • Updated By ID
  • Updated Date
Product Rate Plan

The product rate plan associated with the fund. It includes the following fields:

  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ID
  • Name
  • Updated By ID
  • Updated Date
Product Rate Plan Charge

The product rate plan charge associated with the fund. It includes the following fields. For the field descriptions, see the Product Rate Plan Charge object reference.

  • Accounting Code
  • Apply Discount To
  • Bill Cycle Day
  • Bill Cycle Type
  • Billing Period
  • Billing Period Alignment
  • Billing Timing
  • Charge Model
  • Charge Type
  • Created By ID
  • Created Date
  • Credit Option - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Default Quantity
  • Deferred Revenue Account
  • Description
  • Discount Class ID
  • Discount Level
  • Drawdown Rate - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Drawdown UOM - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • End Date Condition
  • Exclude Item Booking from Revenue - Specifies whether to exclude non-revenue related rate plan charges and order line items from syncing to Zuora Revenue. This field is only available if you have enabled Zuora Billing - Revenue Integration.
  • Exclude Item Billing from Revenue - Specifies whether to exclude non-revenue related invoice items, invoice item adjustments, credit memo items, and debit memo items from syncing to Zuora Revenue. This field is only available if you have enabled Zuora Billing - Revenue Integration.
  • ID
  • Included Units
  • Is Prepaid - This field is only available if you have the Prepaid with Drawdown feature enabled. 
  • Legacy Revenue Reporting
  • List Price Base
  • Max Quantity
  • Min Quantity
  • Name
  • Number of Period
  • Overage Calculation Option
  • Overage Unused Units Credit Option
  • Prepaid Operation Type - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Prepaid Quantity - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Prepaid Total Quantity - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Prepaid UOM - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Price Change Option
  • Price Increase Percentage
  • Rating Group
  • Recognized Revenue Account
  • Revenue Recognition Code
  • Revenue Recognition Rule Name
  • Revenue Recognition Trigger
  • Smoothing Model
  • Specific Billing Period
  • Tax Code
  • Tax Mode
  • Taxable
  • Trigger Event
  • UOM
  • Up To How Many Periods
  • Up To Periods Type
  • Updated By ID
  • Updated Date
  • Usage Records Rating Option
  • Use Discount Specific Accounting Code
  • Use Tenant Default For Price Change
  • Validity Period Type - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Weekly Bill Cycle Day
Rate Plan

The rate plan associated with the fund. It includes the following fields:

  • Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. 
  • Created By ID
  • Created Date
  • Externally Managed Plan ID - A text field. This field indicates the unique identifier of a rate plan purchased from a third-party store.
  • ID
  • Invoice Owner ID - The invoice owner ID of the subscription that contains the rate plan.
  • Name
  • Subscription Owner ID - The subscription owner ID of the subscription that contains the rate plan.
  • Updated By ID
  • Updated Date
Rate Plan Charge

The rate plan charge associated with the fund. It includes the following fields. For the field descriptions, see Rate Plan Charge object reference.

  • Accounting Code
  • Apply Discount To
  • Bill Cycle Day
  • Bill Cycle Type
  • Billing Period
  • Billing Period Alignment
  • Billing Timing
  • Charge Model
  • Charge Number
  • Charge Type
  • Charged Through Date - The date through which a customer has been billed for the charge.
  • Created By ID
  • Created Date
  • Credit Option - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • DMRC
  • DTCV
  • Description
  • Discount Level
  • Drawdown Rate - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Drawdown UOM - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Effective End Date
  • Effective Start Date
  • End Date Condition
  • Exclude Item Booking from Revenue - Specifies whether to exclude non-revenue related rate plan charges and order line items from syncing to Zuora Revenue. This field is only available if you have enabled Zuora Billing - Revenue Integration.
  • Exclude Item Billing from Revenue - Specifies whether to exclude non-revenue related invoice items, invoice item adjustments, credit memo items, and debit memo items from syncing to Zuora Revenue. This field is only available if you have enabled Zuora Billing - Revenue Integration.
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan charge
  • Is Last Segment
  • Is Prepaid - This field is only available if you have the Prepaid with Drawdown feature enabled. 
  • Is Processed - It indicates whether a charge segment has been completely billed for all its relevant billing periods. This is determined by whether the End Date of the charge is earlier than or equal to the Target Date when generating invoices.
  • List Price Base
  • MRR
  • Name
  • Number of Periods
  • Original ID
  • Overage Calculation Option
  • Overage Unused Units Credit Option
  • Payment Term Snapshot
  • Prepaid Operation Type - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Prepaid Quantity - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Prepaid Total Quantity - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Prepaid UOM - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Price Change Option
  • Price Increase Percentage
  • Processed Through Date - The date until when charges have been processed. When billing in arrears, such as usage, this field value is the same as the ChargedThroughDate value. This date is the earliest date when a charge can be amended.
  • Quantity
  • Rating Group
  • Revenue Recognition Code
  • Revenue Recognition Rule Name
  • Revenue Recognition Trigger Condition
  • Segment
  • Subscription ID: the ID of the subscription that contains the rate plan charge
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan charge
  • Specific Billing Period
  • Specific End Date
  • TCV
  • Trigger Date
  • Trigger Event
  • Unit of Measure
  • Up To Periods
  • Up To Periods Type
  • Updated By ID
  • Updated Date - When Charged Through Date, Processed Through Date, or Is Processed is updated, the value of Updated Date for the Rate Plan Charge does not change.
  • Validity Period Type - This field is only available if you have the Prepaid with Drawdown feature enabled.
  • Version
  • Weekly Bill Cycle Day