Welcome to Zuora Product Documentation

Explore our rich library of product information

Rate Plan Charge data source

Data source to export charges on subscriptions

Overview

Use this data source to export charges on subscriptions, representing individual streams of charges that the subscription will generate (for example, usage, recurring, one-time). Each subscription charge represents a row in the export, and this data can be combined with associated data such as Accounts, Subscriptions, and Product Catalog.

Objects available in the data source

rate_plan_charge_datasource.png

Base object description

Descriptions for the base Zuora object.

Zuora ObjectDescription
Rate Plan Charge

Fields on a rate plan charge. It includes the following fields. See the field description in the 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.

Before the charge is billed, the value of the Charged Through Date field is null.

  • Created By ID
  • Created Date
  • Credit Option
  • DMRC
  • DTCV
  • Description
  • Discount Level
  • 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 the Order to Revenue feature or the Billing - Revenue Integration feature. The Order to Revenue feature or the Billing - Revenue Integration feature only supports the billing-based revenue recognition for fixed-amount discounts. Booking transactions must be excluded from revenue accounting. You can exclude the booking transactions by setting the Exclude Item Booking from Revenue Accounting field.
  • 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 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
  • Number of Deliveries - dedicated to the Delivery Pricing charges
  • Original ID
  • Overage Calculation Option
  • Overage Unused Units Credit Option
  • Payment Term Snapshot
  • 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 - the value is always 1 for the Delivery Pricing charges
  • Reflect Discount In Net Amount - indicates whether reflects the net amount of the Delivery Pricing charges after a percentage discount
  • Rating Group
  • Revenue Recognition Code
  • Revenue Recognition Rule Name
  • Revenue Recognition Trigger Condition
  • Sales Price - The sales price associated with the rate plan charge expressed as a decimal. For field explanation, see Retrieve a rate plan charge of Object Query.
  • 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
  • Tax Code Name
  • Tax Mode Option
  • Taxable
  • Trigger Date
  • Trigger Event
  • Unit of Measure
  • Up To Periods
  • Up To Periods Type
  • Updated By ID
  • Updated Date - The default behavior is that 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. If you want the Updated Date field to change when Charged Through Date, Processed Through Date, or Is Processed is updated, submit a request at Zuora Global Support.
  • Version
  • Weekly Bill Cycle Day

The following fields are only available if you have the Prepaid with Drawdown feature enabled.

  • Is Prepaid
  • Prepaid Operation Type
  • Prepaid UOM
  • Prepaid Quantity
  • Prepaid Total Quantity
  • Validity Period Type
  • Credit Option
  • Drawdown UOM
  • Drawdown Rate
ObjectDescription
AccountCustomer account information
AmendmentThe amendment that is tied to the rate plan charge, if applicable
Bill To ContactThe contact of the entity/person to whom you bill for your product or service
Bill To Contact SnapshotThe snapshot of the bill to contact which stores the bill to contact when this Rate Plan Charge is created.
Entity

The entity that the data relates to. Part of the Multi-entity feature. Contains 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
Sold To ContactThe contact of the entity/person to whom your product or service is sold
Sold To Contact SnapshotThe snapshot of the sold to contact which stores the sold to contact when this Rate Plan Charge is created.
Default Payment MethodPayment method details, as a credit card, ACH or PayPal
ProductProduct information
Product Rate PlanPricing plan information from the product catalog
Product Rate Plan ChargeCharge information from the product catalog
Rate PlanPricing Plan information from the Subscription
Rate Plan ChargeCharge information based on the subscription
Subscription Status History

The status history information of a subscription. Contains the following fields:

  • Created By ID - The ID of the user who creates the subscription.
  • Created Date - The date when the subscription is created.
  • End Date - The latest date that the status ends.
  • ID - The unique identifier of the subscription.
  • Sort Order - The chronological order of the subscription statuses.
  • Start Date - The effective start date of the status history.
  • Status - The status of the subscription.
  • Subscription Number - The subscription number that uniquely identifies each subscription.
  • Updated By ID - The ID of the user who last updates the subscription.
  • Updated Date - The date when the subscription is last updated.
Accounts Receivable Accounting CodeAccounting code for accounts receivable
Recognized Revenue Accounting CodeAccounting code for recognized revenue
Deferred Revenue Accounting CodeAccounting code for deferred revenue

Next, refer to Find Subscriptions that have a Rate Plan Charge.