Knowledge Center

Knowledge Center > Reporting > Reporting Data Sources > Data Source: Processed Usage

Data Source: Processed Usage

The Processed Usage data source is a composite data repository that gives you easy access to data from many tables.  Tables included in Processed Usage are listed in the Data Source Details section.

This data source contains processed usage records, or usage that has already been billed. These processed usage records are joined to associated Invoice Items, Invoices, Accounts, Subscriptions, Rate Plans, Rate Plan Charges, Product Rate Plan Charges, Product Rate Plans, and Products.

Data Source Diagram

This diagram illustrates the hierarchical association between the Processed Usage object and related (joined) Zuora objects.

Processed Usage data source

Base Object Description

Zuora Object Description
Processed Usage

This is the base Zuora object for the Processed Usage source export and includes the following fields:

  • BillingPeriodStartDate     
  • BillingPeriodEndDate     
  • Amount
  • CreatedById        
  • CreatedDate    
  • UpdatedById
  • UpdatedDate    

​Reporting and the Processed Usage data source enable countless custom reports with usage data that has already been billed.

Data Source Details

Processed Usage is joined with the following data sources.

Click the Zuora object names to reveal the base Zuora objects available in each table.

Drill down deeper using the link revealed at the top of the table field list to get more specific table and field detail. Field descriptions from the SOAP API Object Reference pages are not always a perfect match for the base Zuora object data you can get from Reporting but the object descriptions should help.

  • Account
    Click here for more information about the Account object fields.
    Account: AR Owner
    Account: Account Balance
    Account: Account Number
    Account: Additional Email Addresses
    Account: Allow Invoice Editing
    Account: Auto Pay
    Account: Bill Cycle Day
    Account: Bill Cycle Day Setting Option
    Account: Billing Batch
    Account: CMRR
    Account: CRM Account ID
    Account: CSR
    Account: Collections Notes
    Account: CommunicationProfile ID
    Account: Created By ID
    Account: Created Date
    Account: Credit Balance
    Account: Currency
    Account: Customer Type
    Account: ID
    Account: Invoice Delivery Preferences Email
    Account: Invoice Delivery Preferences Print
    Account: Invoice Template ID
    Account: Last Invoice Date
    Account: Name
    Account: NetSuite Class
    Account: NetSuite Customer ID
    Account: NetSuite Customer Type
    Account: NetSuite Department
    Account: NetSuite Integration ID
    Account: NetSuite Integration Status
    Account: NetSuite Location
    Account: NetSuite Subsidiary
    Account: NetSuite Sync Date
    Account: Notes
    Account: PO Number
    Account: Parent ID
    Account: Payment Gateway Name
    Account: Payment Term
    Account: Sales Rep
    Account: Status
    Account: Sync to NetSuite
    Account: T1
    Account: Tax Exempt Certificate ID
    Account: Tax Exempt Certificate Type
    Account: Tax Exempt Description
    Account: Tax Exempt Effective Date
    Account: Tax Exempt Expiration Date
    Account: Tax Exempt Issuing Jurisdiction
    Account: Tax Exempt Status
    Account: TenantId
    Account: Total Invoice Balance
    Account: Updated By ID
    Account: Updated Date
  • Amendment
    Click here for more information about the Amendment object fields.
    Amendment: Auto Renew
    Amendment: Code
    Amendment: Contract Effective Date
    Amendment: Created By ID
    Amendment: Created Date
    Amendment: Current Term
    Amendment: Current Term Period Type
    Amendment: Customer Acceptance Date
    Amendment: Description
    Amendment: Effective Date
    Amendment: ID
    Amendment: Name
    Amendment: Renewal Setting
    Amendment: Renewal Term
    Amendment: Renewal Term Period Type
    Amendment: Service Activation Date
    Amendment: Specific Update Date
    Amendment: Status
    Amendment: Subscription ID
    Amendment: Term Start Date
    Amendment: Term Type
    Amendment: Type
    Amendment: Updated By ID
    Amendment: Updated Date
  • Bill To
    Bill To: Account ID
    Bill To: Address 1
    Bill To: Address 2
    Bill To: City
    Bill To: Country
    Bill To: County
    Bill To: Created By ID
    Bill To: Created Date
    Bill To: Description
    Bill To: Fax
    Bill To: First Name
    Bill To: Home Phone
    Bill To: ID
    Bill To: Last Name
    Bill To: Mobile Phone
    Bill To: Nick Name
    Bill To: Other Phone
    Bill To: Other Phone Type
    Bill To: Personal Email
    Bill To: Postal Code
    Bill To: State/Province
    Bill To: Tax Region
    Bill To: Updated By ID
    Bill To: Updated Date
    Bill To: Work Email
    Bill To: Work Phone
  • Default Payment Method
    Click here for more information on Payment Method object fields.
    Default Payment Method: ACH ABA Code
    Default Payment Method: ACH Account Name
    Default Payment Method: ACH Account Number Mask
    Default Payment Method: ACH Account Type
    Default Payment Method: ACH Bank Name
    Default Payment Method: Account ID
    Default Payment Method: Active
    Default Payment Method: Bank Branch Code
    Default Payment Method: Bank Check Digit
    Default Payment Method: Bank City
    Default Payment Method: Bank Code
    Default Payment Method: Bank Identification Number
    Default Payment Method: Bank Name
    Default Payment Method: Bank Postal Code
    Default Payment Method: Bank Street Name
    Default Payment Method: Bank Street Number
    Default Payment Method: Bank Transfer Account Name
    Default Payment Method: Bank Transfer Account Number Mask
    Default Payment Method: Bank Transfer Account Type
    Default Payment Method: Bank Transfer Type
    Default Payment Method: Business Identification Code
    Default Payment Method: City
    Default Payment Method: Country
    Default Payment Method: Created By ID
    Default Payment Method: Created Date
    Default Payment Method: Credit Card Address 1
    Default Payment Method: Credit Card Address 2
    Default Payment Method: Credit Card City
    Default Payment Method: Credit Card Country
    Default Payment Method: Credit Card Expiration Month
    Default Payment Method: Credit Card Expiration Year
    Default Payment Method: Credit Card Holder Name
    Default Payment Method: Credit Card Mask Number
    Default Payment Method: Credit Card Postal Code
    Default Payment Method: Credit Card State
    Default Payment Method: Credit Card Type
    Default Payment Method: Device Session ID
    Default Payment Method: Email
    Default Payment Method: Existing Mandate
    Default Payment Method: First Name
    Default Payment Method: IBAN
    Default Payment Method: ID
    Default Payment Method: IP Address
    Default Payment Method: Last Failed Sale Transaction Date
    Default Payment Method: Last Name
    Default Payment Method: Last Transaction Date
    Default Payment Method: Last Transaction Status
    Default Payment Method: Mandate Creation Date
    Default Payment Method: Mandate ID
    Default Payment Method: Mandate Received
    Default Payment Method: Mandate Update Date
    Default Payment Method: Max Consecutive Payment Failures
    Default Payment Method: Name
    Default Payment Method: Number of Consecutive Failures
    Default Payment Method: Payment Method Status
    Default Payment Method: Payment Retry Window
    Default Payment Method: Paypal BAID
    Default Payment Method: Paypal Email
    Default Payment Method: Paypal Preapproval Key
    Default Payment Method: Paypal Type
    Default Payment Method: Phone
    Default Payment Method: Postal Code
    Default Payment Method: Second Token ID
    Default Payment Method: State
    Default Payment Method: Street Name
    Default Payment Method: Street Number
    Default Payment Method: Token ID
    Default Payment Method: Total Number Of Error Payments
    Default Payment Method: Total Number Of Processed Payments
    Default Payment Method: Type
    Default Payment Method: Updated By ID
    Default Payment Method: Updated Date
    Default Payment Method: Use Default Retry Rule
  • Invoice
    Click here for field descriptions from the Invoice SOAP API Object Reference.
    Invoice: Adjustment Amount
    Invoice: Amount
    Invoice: Amount Without Tax
    Invoice: Balance
    Invoice: Comments
    Invoice: Created By ID
    Invoice: Created Date
    Invoice: Credit Balance Adjustment Amount
    Invoice: Due Date
    Invoice: ID
    Invoice: Includes One Time
    Invoice: Includes Recurring
    Invoice: Includes Usage
    Invoice: Invoice Date
    Invoice: Invoice Number
    Invoice: Last Email Sent Date
    Invoice: NetSuite Integration ID
    Invoice: NetSuite Integration Status
    Invoice: NetSuite Sync Date
    Invoice: Payment Amount
    Invoice: Posted By
    Invoice: Posted Date
    Invoice: Refund Amount
    Invoice: Source
    Invoice: Source ID
    Invoice: Status
    Invoice: Target Date
    Invoice: Tax Amount
    Invoice: Tax Exempt Amount
    Invoice: Transferred to Accounting
    Invoice: Updated By ID
    Invoice: Updated Date
  • Invoice Item
    Click here for field descriptions from the Invoice Item SOAP API Object Reference.
    Invoice Item: Adjustment
    Invoice Item: Applied To Invoice Item Id
    Invoice Item: Charge Amount
    Invoice Item: Charge Date
    Invoice Item: Charge Name
    Invoice Item: Created By ID
    Invoice Item: Created Date< br /> Invoice Item: ID
    Invoice Item: NetSuite Integration ID
    Invoice Item: NetSuite Integration Status
    Invoice Item: NetSuite Sync Date
    Invoice Item: Processing Type
    Invoice Item: Quantity
    Invoice Item: Revenue Recognition Start Date
    Invoice Item: SKU
    Invoice Item: Service End Date
    Invoice Item: Service Start Date
    Invoice Item: Subscription ID
    Invoice Item: Tax Amount
    Invoice Item: Tax Code
    Invoice Item: Tax Exempt Amount
    Invoice Item: Tax Mode
    Invoice Item: UOM
    Invoice Item: Unit Price
    Invoice Item: Updated By ID
    Invoice Item: Updated Date
  • Parent Account
    Click here for more information about the Account object fields.
    Parent Account: AR Owner
    Parent Account: Account Balance
    Parent Account: Account Number
    Parent Account: Additional Email Addresses
    Parent Account: Allow Invoice Editing
    Parent Account: Auto Pay
    Parent Account: Bill Cycle Day
    Parent Account: Bill Cycle Day Setting Option
    Parent Account: Billing Batch
    Parent Account: CMRR
    Parent Account: CRM Account ID
    Parent Account: CSR
    Parent Account: Collections Notes
    Parent Account: CommunicationProfile ID
    Parent Account: Created By ID
    Parent Account: Created Date
    Parent Account: Credit Balance
    Parent Account: Currency
    Parent Account: Customer Type
    Parent Account: ID
    Parent Account: Invoice Delivery Preferences Email
    Parent Account: Invoice Delivery Preferences Print
    Parent Account: Invoice Template ID
    Parent Account: Last Invoice Date
    Parent Account: Name
    Parent Account: NetSuite Class
    Parent Account: NetSuite Customer ID
    Parent Account: NetSuite Customer Type
    Parent Account: NetSuite Department
    Parent Account: NetSuite Integration ID
    Parent Account: NetSuite Integration Status
    Parent Account: NetSuite Location
    Parent Account: NetSuite Subsidiary
    Parent Account: NetSuite Sync Date
    Parent Account: Notes
    Parent Account: PO Number
    Parent Account: Parent ID
    Parent Account: Payment Gateway Name
    Parent Account: Payment Term
    Parent Account: Sales Rep
    Parent Account: Status
    Parent Account: Sync to NetSuite
    Parent Account: T1
    Parent Account: Tax Exempt Certificate ID
    Parent Account: Tax Exempt Certificate Type
    Parent Account: Tax Exempt Description
    Parent Account: Tax Exempt Effective Date
    Parent Account: Tax Exempt Expiration Date
    Parent Account: Tax Exempt Issuing Jurisdiction
    Parent Account: Tax Exempt Status
    Parent Account: TenantId
    Parent Account: Total Invoice Balance
    Parent Account: Updated By ID
    Parent Account: Updated Date
  • Processed Usage
    Click here for a description of Processed Usage Billing Period definitions.
    Processed Usage: Amount
    Processed Usage: Billing Period End Date
    Processed Usage: Billing Period Start Date
    Processed Usage: Created By ID
    Processed Usage: Created Date
    Processed Usage: ID
    Processed Usage: Updated By ID
    Processed Usage: Updated Date
  • Product
    Click here for more detail on Product fields.
    Product: AllowFeatureChanges
    Product: Created By ID
    Product: Created Date
    Product: Description
    Product: Effective End Date
    Product: Effective Start Date
    Product: Name
    Product: NetSuite Integration ID
    Product: NetSuite Integration Status
    Product: NetSuite Item Type
    Product: NetSuite Sync Date
    Product: P1
    Product: P2
    Product: SKU
    Product: T1
    Product: Updated By ID
    Product: Updated Date
  • Product Rate Plan
    Click here for more detail on Product Rate Plan fields.
    Product Rate Plan: Created By ID
    Product Rate Plan: Created Date
    Product Rate Plan: Description
    Product Rate Plan: Effective End Date
    Product Rate Plan: Effective Start Date
    Product Rate Plan: Name
    Product Rate Plan: NetSuite Billing Period
    Product Rate Plan: NetSuite Class
    Product Rate Plan: NetSuite Department
    Product Rate Plan: NetSuite Integration ID
    Product Rate Plan: NetSuite Integration Status
    Product Rate Plan: NetSuite Item Type
    Product Rate Plan: NetSuite Location
    Product Rate Plan: NetSuite Multi Currency Price
    Product Rate Plan: NetSuite Price
    Product Rate Plan: NetSuite Subsidiary
    Product Rate Plan: NetSuite Subsidiary Include Children
    Product Rate Plan: NetSuite Sync Date
    Product Rate Plan: NetSuite Tax Code
    Product Rate Plan: PRP1
    Product Rate Plan: PRP2
    Product Rate Plan: Updated By ID
    Product Rate Plan: Updated Date
  • Product Rate Plan Charge
    Click here for more detail on Product Rate Plan Charge fields.
    Product Rate Plan Charge: Accounting Code
    Product Rate Plan Charge: Apply Discount To
    Product Rate Plan Charge: Bill Cycle Day
    Product Rate Plan Charge: Bill Cycle Type
    Product Rate Plan Charge: Billing Period
    Product Rate Plan Charge: Billing Period Alignment
    Product Rate Plan Charge: Charge Model
    Product Rate Plan Charge: Charge Type
    Product Rate Plan Charge: Created By ID
    Product Rate Plan Charge: Created Date
    Product Rate Plan Charge: Default Quantity
    Product Rate Plan Charge: Deferred Revenue Account
    Product Rate Plan Charge: Description
    Product Rate Plan Charge: Discount Level
    Product Rate Plan Charge: Included Units
    Product Rate Plan Charge: Legacy Revenue Reporting
    Product Rate Plan Charge: Max Quantity
    Product Rate Plan Charge: Min Quantity
    Product Rate Plan Charge: Name
    Product Rate Plan Charge: NetSuite Class
    Product Rate Plan Charge: NetSuite Deferred Revenue Account
    Product Rate Plan Charge: NetSuite Department
    Product Rate Plan Charge: NetSuite Integration ID
    Product Rate Plan Charge: NetSuite Integration Status
    Product Rate Plan Charge: NetSuite Item Type
    Product Rate Plan Charge: NetSuite Location
    Product Rate Plan Charge: NetSuite Recognized Revenue Account
    Product Rate Plan Charge: NetSuite Revenue Recognition End Date
    Product Rate Plan Charge: NetSuite Revenue Recognition Start Da
    Product Rate Plan Charge: NetSuite Revenue Recognition Template
    Product Rate Plan Charge: NetSuite Subsidiary
    Product Rate Plan Charge: NetSuite Subsidiary Include Children
    Product Rate Plan Charge: NetSuite Sync Date
    Product Rate Plan Charge: Number Of Period
    Product Rate Plan Charge: Overage Calculation Option
    Product Rate Plan Charge: Overage Unused Units Credit Option
    Product Rate Plan Charge: PRPC1
    Product Rate Plan Charge: PRPC2
    Product Rate Plan Charge: Price Change Option
    Product Rate Plan Charge: Price Increase Percentage
    Product Rate Plan Charge: Recognized Revenue Account
    Product Rate Plan Charge: Revenue Recognition Code
    Product Rate Plan Charge: Revenue Recognition Rule Name
    Product Rate Plan Charge: Revenue Recognition Trigger
    Product Rate Plan Charge: Smoothing Model
    Product Rate Plan Charge: Specific Billing Period
    Product Rate Plan Charge: Tax Code
    Product Rate Plan Charge: Tax Mode
    Product Rate Plan Charge: Taxable
    Product Rate Plan Charge: Trigger Event
    Product Rate Plan Charge: UOM
    Product Rate Plan Charge: Up To How Many Periods
    Product Rate Plan Charge: Updated By ID
    Product Rate Plan Charge: Updated Date
    Product Rate Plan Charge: Use Discount Specific Accounting Code
    Product Rate Plan Charge: Use Tenant Default For Price Change
  • Rate Plan
    Click here for more detail on Rate Plan fields.
    Rate Plan: Amendment Type
    Rate Plan: Created By ID
    Rate Plan: Created Date
    Rate Plan: Name
    Rate Plan: Updated By ID
    Rate Plan: Updated Date
  • Rate Plan Charge
    Click here for more detail on the Rate Plan Charge fields.
    Rate Plan Charge: Accounting Code
    Rate Plan Charge: Apply Discount To
    Rate Plan Charge: Bill Cycle Day
    Rate Plan Charge: Bill Cycle Type
    Rate Plan Charge: Billing Period
    Rate Plan Charge: Billing Period Alignment
    Rate Plan Charge: Charge Model
    Rate Plan Charge: Charge Number
    Rate Plan Charge: Charge Type
    Rate Plan Charge: Charged Through Date
    Rate Plan Charge: Created By ID
    Rate Plan Charge: Created Date
    Rate Plan Charge: DMRC
    Rate Plan Charge: DTCV
    Rate Plan Charge: Description
    Rate Plan Charge: Discount Level
    Rate Plan Charge: Effective End Date
    Rate Plan Charge: Effective Start Date
    Rate Plan Charge: Is Last Segment
    Rate Plan Charge: MRR
    Rate Plan Charge: Name
    Rate Plan Charge: Notes
    Rate Plan Charge: Number of Periods
    Rate Plan Charge: Original ID
    Rate Plan Charge: Overage Calculation Option
    Rate Plan Charge: Overage Unused Units Credit Option
    Rate Plan Charge: Processed Through Date
    Rate Plan Charge: Quantity
    Rate Plan Charge: Revenue Recognition Code
    Rate Plan Charge: Revenue Recognition Rule Name
    Rate Plan Charge: Revenue Recognition Trigger Condition
    Rate Plan Charge: Segment
    Rate Plan Charge: Specific Billing Period
    Rate Plan Charge: TCV
    Rate Plan Charge: Trigger Date
    Rate Plan Charge: Trigger Event
    Rate Plan Charge: Unit of Measure
    Rate Plan Charge: Up To Periods
    Rate Plan Charge: Updated By ID
    Rate Plan Charge: Updated Date
    Rate Plan Charge: Version
  • Sold To
    Sold To: Account ID
    Sold To: Address 1
    Sold To: Address 2
    Sold To: City
    Sold To: Country
    Sold To: County
    Sold To: Created By ID
    Sold To: Created Date
    Sold To: Description
    Sold To: Fax
    Sold To: First Name
    Sold To: Home Phone
    Sold To: ID
    Sold To: Last Name
    Sold To: Mobile Phone
    Sold To: Nick Name
    Sold To: Other Phone
    Sold To: Other Phone Type
    Sold To: Personal Email
    Sold To: Postal Code
    Sold To: State/Province
    Sold To: Tax Region
    Sold To: Updated By ID
    Sold To: Updated Date
    Sold To: Work Email
    Sold To: Work Phone
  • Subscription
    Click here for more detail on Subscription fields.
    Subscription: Auto Renew
    Subscription: Cancelled Date
    Subscription: Contract Acceptance Date
    Subscription: Contract Effective Date
    Subscription: Created By ID
    Subscription: Created Date
    Subscription: Creator Account ID
    Subscription: Creator Invoice Owner ID
    Subscription: Initial Term
    Subscription: Invoice Owner ID
    Subscription: Invoice Separate
    Subscription: Name
    Subscription: NetSuite Integration ID
    Subscription: NetSuite Integration Status
    Subscription: NetSuite Project
    Subscription: NetSuite Sales Order
    Subscription: NetSuite Sync Date
    Subscription: Notes
    Subscription: Original Created Date
    Subscription: Original ID
    Subscription: Previous Subscription ID
    Subscription: Renewal Setting
    Subscription: Renewal Term
    Subscription: SFDC Implementation Id
    Subscription: Service Activation Date
    Subscription: Status
    Subscription: Subscription End Date
    Subscription: Subscription Start Date
    Subscription: Term End Date
    Subscription: Term Start Date
    Subscription: Term Type
    Subscription: Updated By ID
    Subscription: Updated Date
    Subscription: Version
  • Usage
    Click here for more detail on Usage fields.
    Usage: Account Number
    Usage: Created By ID
    Usage: Created Date
    Usage: End Date
    Usage: ID
    Usage: Quantity
    Usage: RBE Status
    Usage: Source Type
    Usage: Start Date
    Usage: Submission Date
    Usage: Unit of Measure
    Usage: Updated By ID
    Usage: Updated Date

Getting value from the data source

Reporting offers you multiple ways to get your data from the data sources:

  • Standard Reports

Zuora Standard Reports use new data sources to get the data from frequently requested metrics and dimensions into reports that customers like you have grown to rely on. Zuora Standard Reports can be found at the bottom left below the Reports Shared with Me folder of Reporting.

  • Custom Reports

Click Create New Report. Select Processed Usage data source and choose from more than 500 fields to get the data that interests you.  Create either a Detail or a Summary report to define filters, aggregate measures by value type and sort according to reporting requirements.

Refer to the video tutorial on Create a Summary Report for more information.

  • AQuA REST API

Refer to the articles on Post Query or Post Query with time parameter or Post Query with Notification for different ways to programmatically retrieve data from this data source.

Last modified
23:09, 29 Sep 2016

Tags

This page has no custom tags.

Classifications

(not set)