Skip to main content

Invoice Item Adjustment Data Source

Zuora

Invoice Item Adjustment Data Source

  1. Last updated
  2. Save as PDF

Use this data source to export data related to invoice item adjustments. Each row represents an adjustment of one line item on an invoice.

If you have the Invoice Settlement feature enabled, this data source is deprecated and only available for backward compatibility.

Objects Available in the Data Source

Invoice Item Adjustment Data Source Diagram

Object Description

Invoice Item Adjustment

 Base object for this data source

Account

 Customer 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

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

Amendment

 Amendment tied to the invoice item, if applicable

Bill-to Contact

 Contact of the entity/person whom you bill for your product or service
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

Default Payment Method

 Default payment method for the Customer Account

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

Invoice

 Invoice the payment was applied to

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

 Parent of the customer account, if applicable

Product

 Product the invoice line item belongs to

Product Rate Plan

 Product rate plan the invoice item belongs to

Product Rate Plan Charge

 Product rate plan charge the invoice item belongs to

Rate Plan

 Rate plan the invoice item belongs to

Rate Plan Charge

 Rate plan charge the invoice item belongs to

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

Sales Tax Payable Accounting Code

Accounting code for sales tax payable. 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

Sold-to Contact

 Contact of the entity/person to whom your product or service is sold

Subscription

 Subscription the invoice item belongs to

Taxation Item

 Related taxation record
Taxable Item Snapshot

Tax information when creating taxes.

This feature is in Limited Availability. If you want to have access to the feature, submit a request at Zuora Global Support. 

Contains the following fields:

  • Company Code
  • Created by ID
  • Created Date
  • Destination Address City
  • Destination Address Country
  • Destination Address County
  • Destination Address Line 1
  • Destination Address Line 2
  • Destination Address Postal Code
  • Destination Address Region
  • Destination Address State
  • Entity/Use Code
  • ID
  • Item Type
  • Tax Code Name
  • Tax Date
  • Tax Exempt Certificate ID
  • Tax Exempt Certificate Type
  • Tax Exempt Description
  • Tax Exempt Effective Date
  • Tax Exempt Expiration Date
  • Tax Exempt Issuing Jurisdiction
  • Tax Exempt Status
  • Tax Mode
  • Taxable Item ID
  • VAT ID