Knowledge Center

Knowledge Center > Reporting > Data Sources and Exports > Data Source Reference > Credit Memo Application Item Data Source

Credit Memo Application Item Data Source

This feature is only available if you have the Advanced AR Settlement feature enabled. The Advanced AR Settlement feature is in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support

Use this data source to export credit memo application items. Each row represents a single credit memo application on one line item of the invoice or charge. 

Data Source

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

Data Source Detail

Base Object Description

Descriptions for the base Zuora object.

Zuora Object Description

Credit Memo Application Item

Credit Memo applications on invoice items and charge items. It includes the following fields:

  • Amount
  • Created By ID
  • Created Date
  • Effective Date
  • ID
  • Updated By ID
  • Updated Date

Related Object Descriptions

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora Object Description
Account The account that made the payment.
AccountingPeriod

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
Application Group

Groups of payment, refund, and credit memo applications. It includes the following fields:

  • Created By ID
  • Created Date
  • ID
  • Operation Date
  • Updated By ID
  • Updated Date
Bill To The Bill-To Contact of the Account.
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 Application

Information about when and how credit memos are applied to invoices and debit memos. It includes the following fields:

  • Amount
  • Created By ID
  • Created Date
  • Effective Date
  • ID
  • 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
Credit Taxation Item

Taxation records on credit memos. It includes the following fields:

  • Accounting Code
  • Created By ID
  • Created Date
  • ExemptAmount
  • ID
  • Jurisdiction
  • Location Code
  • Name
  • Tax Amount
  • Tax Code
  • Tax Code Description
  • Tax Date
  • Tax Mode
  • Tax Rate
  • Tax Rate Description
  • Tax Rate Type
  • Updated By ID
  • Updated Date
Debit Memo

Debit memos that you issued to your customers to increase the amount your customers owned you. It includes the following fields:

  • Amount Applied By
  • Amount Applied To
  • Balance
  • Cancelled By Id
  • Cancelled On
  • Comments
  • Created By ID
  • Created Date
  • Debit Memo Date
  • Debit Memo Number
  • Discount Amount
  • Due Date
  • 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
Debit Memo Item

Line items on debit 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
Debit Taxation Item

Taxation records on debit memos. It includes the following fields:

  • Accounting Code
  • Created By ID
  • Created Date
  • ExemptAmount
  • ID
  • Jurisdiction
  • Location Code
  • Name
  • Tax Amount
  • Tax Code
  • Tax Code Description
  • Tax Date
  • Tax Mode
  • Tax Rate
  • Tax Rate Description
  • Tax Rate Type
  • Updated By ID
  • Updated Date
Default Payment Method

The default payment method used to make payments.

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.

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
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
Parent Account

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

Sold To The Sold-To Contact of the Account.
Taxation Item Related taxation record.
Last modified
19:26, 10 May 2017

Tags

Classifications

(not set)