Invoice Item Adjustment Data Source

Last updated
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.

Objects Available in the Data Source:

Base Object Description

Object	Description
Invoice Item Adjustment	Contains the following fields: Account ID Accounting Code Adjustment Date Adjustment Number Amount Cancelled By ID Cancelled Date Comment Created By ID Created Date Exclude Item Billing From Revenue Accounting ID Invoice ID Invoice Item Name Invoice Number Reason Code Reference ID Service End Date Service Start Date Source ID Source Type Status Transferred to Accounting Type Updated By ID (When Journal Entry ID or Journal Run ID is created, this field will not be updated) Updated Date (When Journal Entry ID or Journal Run ID is created, this field will not be updated)

Object

Description

Invoice Item Adjustment

Contains the following fields:

Account ID
Accounting Code
Adjustment Date
Adjustment Number
Amount
Cancelled By ID
Cancelled Date
Comment
Created By ID
Created Date
Exclude Item Billing From Revenue Accounting
ID
Invoice ID
Invoice Item Name
Invoice Number
Reason Code
Reference ID
Service End Date
Service Start Date
Source ID
Source Type
Status
Transferred to Accounting
Type
Updated By ID (When Journal Entry ID or Journal Run ID is created, this field will not be updated)
Updated Date (When Journal Entry ID or Journal Run ID is created, this field will not be updated)

Related Zuora Objects

Object	Description
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
Bill To Contact Snapshot	A copy of the bill to contact information used to generate invoices. This object has values only if you set the Preserve snapshot of bill-to and sold-to contacts when billing documents are posted? billing rule to Yes.
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
Sold-to Contact Snapshot	A copy of the sold to contact information used to generate invoices. This object has values only if you set the Preserve snapshot of bill-to and sold-to contacts when billing documents are posted? billing rule to Yes.
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