Skip to main content

Revenue Event Item Invoice Item Adjustment Data Source

Zuora

Revenue Event Item Invoice Item Adjustment Data Source

Overview

Use this data source to export data about revenue event items that are associated with invoice item adjustments.

Accessing the Data Source

Navigation: Reporting > Data Sources and select Revenue Event Item Invoice Item Adjustment as the data source.

Data Source Detail

Data Source Diagram

This diagram illustrates the hierarchical association between the base Revenue Event Item Invoice Item Adjustment object and related (joined) Zuora objects.

Revenue Event Item Invoice Item Adjustment Data Source Diagram

Base Object Description

Zuora Object Description

Revenue Event Item Invoice Item Adjustment

This is the base Zuora object for the Revenue Event Item Invoice Item Adjustment data source export and includes the following fields:

  • Amount
  • Created By ID
  • Created Date
  • Currency
  • ID
  • Updated By ID
  • Updated Date

Related Object Descriptions

Descriptions for related Zuora objects are listed in alphabetical order.

Object Description

Account

The customer account information. Note this is the Invoice Owner account.

Accounting Period

Periods of time that represents the financial calendar of your company. Used to assist with accounting close activities and financial reporting. Contains the following fields:

  • Created By ID
  • Created Date
  • End Date
  • Fiscal Quarter
  • Fiscal Year
  • ID
  • Name
  • Notes
  • Start Date
  • Status
  • Updated By ID
  • Updated Date

Amendment

The amendment that is tied to the rate plan charge, if applicable.

Bill To

The contact associated with the account to whom your product or service is billed.

Default Payment Method

The default payment method used to make payments.

Deferred Revenue Accounting Code

Accounting code for deferred revenue. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date
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

Invoice

The invoice to which the payment is applied.

Invoice Item

Represents one line item on the invoice.

Invoice Item Adjustment

Represents one adjustment line item on the invoice.

Journal Entry

Represents a Zuora transaction recorded as a debit and credit. Includes the following fields:

  • Created By ID
  • Created Date
  • Currency
  • ID
  • Journal Entry Date
  • Notes
  • Number
  • [Segment Name]: One or more fields representing the name of each segment created. These fields become available for export on this data source only if they are used by the GL segmentation rule.
  • Status
  • Transaction Count
  • Transaction Type
  • Transfer Date
  • Transferred By
  • Transferred To Accounting
  • Update By ID
  • Updated Date

This object is available on this data source only when Zuora Finance is enabled on your tenant.

Journal Run

Automated process for creating journal entries from Zuora transactions. Includes the following fields:

  • Created By ID
  • Created Date
  • ID
  • Number
  • Process End Date Time
  • Process Start Date Time
  • Status
  • Target Date Type
  • Target End Date
  • Target Start Date
  • Total Journal Entry Count
  • Updated By ID
  • Updated Date

This object is available on this data source only when Zuora Finance is enabled on your tenant.

Parent Account

Refers to the parent account associated with the customer account, if applicable.

Product

The product information. Contains the following fields:

  • AllowFeatureChanges
  • Category
  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ID
  • Name
  • NetSuite Integration ID
  • NetSuite Integration Status
  • NetSuite Item Type
  • NetSuite Sync Date
  • SKU
  • Updated By ID
  • Updated Date

Product Rate Plan

The rate plan coming from the product catalog. Contains the following fields:

  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ExternalldSourceSystem
  • Grade
  • ID
  • Name
  • Updated By ID
  • Updated Date

Product Rate Plan Charge

The product rate plan charge information coming from the product catalog. Contains the following fields:

  • 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
  • Default Quantity
  • Deferred Revenue Account
  • Description
  • Discount Level
  • End Date Condition
  • ID
  • Included Units
  • Legacy Revenue Reporting
  • List Price Base
  • Max Quantity
  • Min Quantity
  • Name
  • Number Of Period
  • Overage Calculation Option
  • Overage Unused Units Credit Option
  • 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
  • Weekly Bill Cycle Day

Rate Plan

Refers to the rate plan or pricing plan information associated with the subscription. Contains 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 on a third-party store.
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan
  • Name
  • Original Rate Plan ID: the original ID of the subscription rate plan, which is the ID of the subscription rate plan in the version-1 subscription
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan
  • Subscription Rate Plan Number
  • Updated By ID
  • Updated Date

Rate Plan Charge

The charge information associated with the subscription. Contains the following fields:

  • 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
  • Created By ID
  • Created Date
  • DMRC
  • DTCV
  • Description
  • Discount Level
  • Effective End Date
  • Effective Start Date
  • End Date Condition
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan charge
  • Is Last Segment
  • Is Processed
  • List Price Base
  • MRR
  • Name
  • Number of Periods
  • Original ID
  • Overage Calculation Option
  • Overage Unused Units Credit Option
  • Price Change Option
  • Price Increase Percentage
  • Processed Through Date
  • Quantity
  • Rating Group
  • Revenue Recognition Code
  • Revenue Recognition Rule Name
  • Revenue Recognition Trigger Condition
  • Segment
  • Specific Billing Period
  • Specific End Date
  • 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
  • TCV
  • Trigger Date
  • Trigger Event
  • Unit of Measure
  • Up To Periods
  • Up To Periods Type
  • Updated By ID
  • Updated Date
  • Version
  • Weekly Bill Cycle Day

Recognized Revenue Accounting Code

Accounting code for recognized revenue. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date

Revenue Charge Summary

Revenue summary for the subscription charge. Contains the following fields:

  • Created By ID
  • Created Date
  • Currency
  • ID
  • Notes
  • Revenue Summary Charge Number
  • Updated By ID
  • Updated Date

Revenue Event Invoice Item Adjustment

Revenue event that is associated with an invoice item adjustment.

Revenue Event Type

The event type that triggered a change to the revenue schedule, such as Invoice Posted or Invoice Cancelled.

Revenue Schedule Invoice Item Adjustment

Revenue schedule that is associated with an invoice item adjustment.

Sold To 

The contact associated with the account to whom your product or service is sold.

Subscription

The subscription to which the rate plan is associated. Contains the following fields:

  • Auto Renew
  • Cancelled Date
  • Contract Acceptance Date
  • Contract Effective Date
  • Cpq Bundle Json ID
  • Created By ID
  • Created Date
  • Creator Account ID
  • Creator Invoice Owner ID
  • Current Term
  • Current Term Period Type
  • ID
  • Initial Term
  • Initial Term Period Type
  • Invoice Owner ID
  • Invoice Separate
  • Name
  • Notes
  • Opportunity Close Date
  • Opportunity Name
  • Original Created Date
  • Original ID
  • Previous Subscription ID
  • Quote Business Type
  • Quote Number
  • Quote Type
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Service Activation Date
  • Status
  • Subscription End Date
  • Subscription Start Date
  • Term End Date
  • Term Start Date
  • Term Type
  • Updated By ID
  • Updated Date
  • Version