Knowledge Center

Knowledge Center > Reporting > Data Sources and Exports > Data Source Reference > Revenue Schedule Item Invoice Item Data Source

Revenue Schedule Item Invoice Item Data Source

Overview

Use this data source to export revenue schedule item – invoice item data.

Accessing the Data Source

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

Revenue Schedule Item Invoice Item

Data Source Detail

Data Source Diagram

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

Revenue Schedule Item Invoice Item Data Source Diagram

Base Object Description

Zuora Object Description

Revenue Schedule Item Invoice Item

The revenue item - invoice item.

This is the base Zuora object for the Revenue Schedule Item Invoice Item 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.

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.

Invoice

The invoice to which the payment is applied.

Invoice Item

Represents one line item on the invoice.

Parent Account

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

Product

The product information.

Product Rate Plan

The rate plan coming from the product catalog.

Product Rate Plan Charge

The product rate plan charge information coming from the product catalog.

Rate Plan

Refers to the rate plan or pricing plan information associated the subscription.

Rate Plan Charge

The charge information associated with the subscription.

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 Schedule Invoice Item

Revenue schedule for invoice items.

This object contains the following fields:

  • Amount
  • Created By ID
  • Created Date
  • Currency
  • Exchange Rate Date (only available if you have the Currency Conversion feature enabled)
  • FieldLabel
  • ID
  • Linked Transaction Date
  • Linked Transaction Number
  • Linked Transaction Type
  • Notes
  • Recognition Rule Name
  • Reference Id
  • Revenue Schedule Date
  • Revenue Schedule Number
  • Revenue Schedule Recognition End
  • Revenue Schedule Recognition Start
  • Undistributed Unrecognized Revenue
  • Updated By ID
  • Updated Date

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.

Last modified
00:24, 8 May 2017

Tags

Classifications

(not set)