Skip to navigation
DataZuora ReportingData sources and exportsData source reference

Invoice Adjustment data source

View as Markdown

Data source to export data for adjustments applied to an invoice

Invoice Adjustment is deprecated on Production. Zuora recommends that you use the Invoice Item Adjustment to adjust invoices. If you have the Advanced AR Settlement feature enabled, this data source is deprecated and only available for backward compatibility.

Use this data source to export data for adjustments applied to an invoice.

Objects available in the data source

Invoice Adjustment Data Source

Base object description

Object

Description

Invoice Adjustment

Contains the following fields:

  • Accounting Code
  • Adjustment Date
  • Adjustment Number
  • Amount
  • Cancelled By ID
  • Cancelled On
  • Comments
  • Created By ID
  • Created Date
  • ID
  • Impact Amount
  • Invoice Number
  • Reason Code
  • ReferenceId
  • Status
  • Transferred to Accounting
  • Type
  • Updated By ID
  • Updated Date

Object

Description

Account

The account number to whom the invoice belongs.

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

Accounts Receivable Accounting Code

Accounting code for accounts receivable. 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

Bill To Contact

The contact of the entity/person to whom you bill for your product or service.

Default Payment Method

The default payment method of the customer account, to whom the invoice belongs.

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, the base object for this Data Source Export.

Invoice Adjustment FX Data

Contains Home Currency and Reporting Currency information.

To enable this option, submit a request at Zuora Global Support.

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.

Sold To Contact

The contact of the entity/person to whom your product or service is sold.