Knowledge Center

Knowledge Center > Reporting > Data Exports > Data Source Reference > Journal Entry Item Data Source

Journal Entry Item Data Source

Use this data source to export journal entry data.

Data Source

Navigation: Reporting > Data Sources and select Journal Entry Item as the data source.

Data Source Detail

Data Source Diagram

This diagram illustrates the hierarchical association between the base Journal Entry Item object and related (joined) Zuora objects.

Journal Entry Data Source Diagram

Base Object Description

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora Object Description

Journal Entry Item

This is the base Zuora object for the Journal Entry Item data source export and includes the following fields:

  • Amount
  • Created By ID
  • Created Date
  • Currency
  • ID
  • Type
  • Updated By ID
  • Updated Date

Related Object Descriptions

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora Object Description

Accounting Code

Categorizes Zuora transactions for accounting purposes, such as Account Receivables and Account Payables. Includes the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Price
  • Status
  • Type
  • Updated By ID
  • Updated Date
  • [custom field]

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
Entity

The entity information. This object is only used for Zuora Multi-entity.

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

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
Last modified
22:38, 12 Oct 2016

Tags

Classifications

(not set)