Knowledge Center

Knowledge Center > Reporting > Data Sources and Exports > Data Source Reference > Invoice Item Data Source

Invoice Item Data Source

Use this data source to export invoice item data. Each row represents one line item on an invoice. Data includes information on the products and subscriptions that correspond to the line item as well as the invoice, and the account associated with the invoice.

Objects Available in the Data Source

Invoice Item Datasource Relationship Diagram

 

Object Description

Account

The 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
Amendment The amendment that is tied to the invoice item, if applicable.
Bill To Contact The 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.

Entity

The entity that the data relates to. Part of the Multi-entity feature.

Sold To Contact The 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.

Default Payment Method The default payment method for the Customer Account.
Invoice Invoice that 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.

Product The product the invoice line item belongs to.
Product Rate Plan The product rate plan the invoice item belongs to.
Product Rate Plan Charge The product rate plan charge the invoice item belongs to.
Rate Plan The rate plan the invoice item belongs to.
Rate Plan Charge The rate plan charge the invoice item belongs to.
Subscription The subscription the invoice item belongs to.
Accounts Receivable Accounting Code Accounting code for accounts receivable.
Recognized Revenue Accounting Code Accounting code for recognized revenue.
Deferred Revenue Accounting Code Accounting code for deferred revenue.

Charge Amount Field

The Charge Amount field of the Invoice Item data source is the same as the Extended Price column included in the invoice CSV export file. 

Charge Name Field

Use the Charge Name field to include more information in the data source export. The Charge Name field in the Invoice Item data source is different from the Charge Number field on the Rate Plan Charge data source. Typically, the Charge Name on Invoice Item contains additional information such as "-- Proration." For example: Monthly Fee -- Proration

Last modified
19:32, 16 Apr 2017

Tags

Classifications

(not set)