Skip to main content

Journal Entry Detail Objects Data Source

Zuora

Journal Entry Detail Objects Data Source

Use this data source to export journal entry detail objects data.

Data Source

This data source is not available through the Zuora UI. You can view and export the objects through the Describe an object operation and the CRUD: Create an export operation.

Objects and available fields

The following Journal Entry Detail Objects are available for data query if you are using Zuora Finance. All the objects have the same fields as described below.

Object Name Fields
Journal Entry Detail Invoice Item All the objects include the same set of fields:
  • ID (Journal Entry detail ID, not the corresponding transaction ID.)
  • Transaction ID (The corresponding transaction or transaction item ID. For example, Invoice Item ID.)
  • Container Transaction ID (For example, Invoice ID.)
  • Transaction Date (For example, Invoice Date.)
  • Transaction Type (The transaction type. For example, Invoice Item.)
  • Amount
  • Currency
  • Account Id
  • Home Currency
  • Exchange Rate
  • Exchange Rate Date
  • Amount (Home Currency)
  • Rounding Amount (Home Currency)
Journal Entry Detail Taxation Item
Journal Entry Detail Invoice Item Adjustment
Journal Entry Detail Invoice Adjustment
Journal Entry Detail Invoice Payment
Journal Entry Detail Refund Invoice Payment
Journal Entry Detail Credit Balance Adjustment
Journal Entry Detail Revenue Event Item
Journal Entry Detail Payment Application
Journal Entry Detail Refund Application
Journal Entry Detail Debit Memo Item
Journal Entry Detail Debit Taxation Item
Journal Entry Detail Credit Memo Item
Journal Entry Detail Credit Taxation Item
Journal Entry Detail Credit Memo Application Item
Journal Entry Detail Payment Application Item
Journal Entry Detail Refund Application Item

Notes

  • The following objects will not have data to retrieve unless you have enabled Invoice Settlement:

    • Journal Entry Detail Payment Application
    • Journal Entry Detail Refund Application
    • Journal Entry Detail Debit Memo Item
    • Journal Entry Detail Debit Taxation Item
    • Journal Entry Detail Credit Memo Item
    • Journal Entry Detail Credit Taxation Item
  • The following objects will not have data to retrieve unless you have enabled the Item Settlement feature under Invoice Settlement:

    • Journal Entry Detail Credit Memo Application Item
    • Journal Entry Detail Payment Application Item
    • Journal Entry Detail Refund Application Item
  • The following fields are available only if you have enabled the Currency Conversion feature:

    • Home Currency
    • Exchange Rate
    • Exchange Rate Date
    • Amount (Home Currency)
    • Rounding Amount (Home Currency)

Related objects

The Journal Entry Detail objects do not join upstream transactions, instead, they only show the related transaction IDs.

The Journal Entry Detail objects join to the following objects.

  • Credit Accounting Code
  • Debit Accounting Code
  • Journal Entry
  • Journal Run