Knowledge Center

Knowledge Center > Reporting > Quick Reference > Reporting Overview > D Data Sources and Exports > C Data Source Reference > Revenue Schedule Item Credit Memo Item Data Source

Revenue Schedule Item Credit Memo Item Data Source

Use this data source to export revenue schedule item credit memo item data.

Accessing the Data Source

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

Although this data source is available if you have Zuora Revenue enabled, it is related to the Advanced AR Settlement feature.

Zuora strongly recommends that you use this data source when you have both the Zuora Revenue and Advanced AR Settlement features enabled.

Data Source Detail

Base Object Description

Descriptions for the base Zuora object.

Zuora Object Description

Revenue Schedule Item Credit Memo Item

The revenue schedule item - credit memo item. It 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.

Zuora 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 entity or person associated with the account to whom your product or service is billed.

Credit Memo

Credit memos that you issued to your customers to reduce invoice and account balances. It includes the following fields:

  • Amount Applied By
  • Amount Applied To
  • Balance
  • Cancelled By Id
  • Cancelled On
  • Comments
  • Created By ID
  • Created Date
  • Credit Memo Date
  • Credit Memo Number
  • Discount Amount
  • ID
  • Posted By ID
  • Posted On
  • Reason Code
  • Source
  • Status
  • Target Date
  • Tax Amount
  • Total Amount
  • Total Amount Without Tax
  • Total Tax Exempt Amount
  • Transferred To Accounting
  • Updated By ID
  • Updated Date
Credit Memo Item

Line items on credit memos. It includes the following fields:

  • Amount Without Tax
  • Applied To Others Amount
  • Be Applied By Others Amount
  • Charge Date
  • Created By ID
  • Created Date
  • Description
  • ID
  • Processing Type
  • Quantity
  • SKU
  • Service End Date
  • Service Start Date
  • Tax Amount
  • Tax Code Name
  • Tax Exempt Amount
  • Tax Mode
  • Unit Of Measure
  • Unit Price
  • Updated By ID
  • Updated Date
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 information. This object is only used for Zuora Multi-entity.

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
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 Credit Memo Item

Revenue schedule that is associated with a credit memo item. It includes the following fields: 

  • Amount
  • Created By ID
  • Created Date
  • Currency
  • Exchange Rate Date (only available if you have the Currency Conversion feature enabled)
  • 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 entity or person associated with the account to whom your product or service is sold.

Subscription

The subscription to which the rate plan is associated.

 

Last modified
21:04, 14 May 2017

Tags

Classifications

(not set)