Daily Consumption Summary data source

Last updated
Save as PDF

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

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