Skip to main content

Journal Entry Detail Objects Data Source

Zuora

Journal Entry Detail Objects Data Source

  1. Last updated
  2. Save as PDF

Use this data source to export journal entry detail objects data. You cannot export data for canceled journal entries.

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 Aggregate Query API (AQuA) operation.

Objects and available fields

The following Journal Entry Detail Objects are available for data source 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) 
  • Created by ID 
  • Created Date 
  • Updated by ID
  • Updated Date
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

Fields of specific objects

The following Journal Entry Detail Objects are available for data source if you are using Zuora Finance. The below-mentioned objects have their specific fields as described below.

Object Name Fields

Journal Entry Detail Invoice Item
  • Charge
  • Discount
  • Prepayment

Journal Entry Detail Invoice Item Adjustment
  • Credit
  • Charge

Journal Entry Detail Invoice Adjustment
  • Credit
  • Charge

Journal Entry Detail Debit Memo Item
  • Charge
  • Discount
  • Prepayment

Journal Entry Detail Credit Memo Item
  • Charge
  • Discount
  • Prepayment

Journal Entry Detail Credit Memo Application Item
  • On-Account to Invoice Item 
  • On-Account to Invoice Taxation Item
  • On-Account to Debit Memo Item
  • On-Account to Debit Memo Taxation Item
  • Invoice Item Reversal
  • Invoice Taxation Item Reversal
  • Debit Memo Item Reversal
  • Debit Memo Taxation Item Reversal

Journal Entry Detail Payment Application
  • Unapplied
  • Transferred From
  • Transferred To
  • Unapplied to Invoice
  • Unapplied to Debit Memo
  • Invoice
  • Debit Memo
  • Invoice Reversal
  • Debit Memo Reversal

Journal Entry Detail Payment Application Item
  • Unapplied
  • Transferred From
  • Transferred To
  • Unapplied to Invoice Item
  • Unapplied to Invoice Taxation Item
  • Unapplied to Debit Memo Item
  • Unapplied to Debit Memo Taxation Item
  • Invoice Item
  • Invoice Taxation Item
  • Debit Memo Item
  • Debit Memo Taxation Item
  • Invoice Item Reversal
  • Invoice Taxation Item Reversal
  • Debit Memo Item Reversal
  • Debit Memo Taxation Item Reversal

Journal Entry Detail Refund Application
  • Unapplied Payment
  • On-Account Credit Memo

Journal Entry Detail Refund Application Item
  • Unapplied Payment
  • On-Account Credit Memo Item
  • On-Account Credit Memo Taxation Item

Journal Entry Detail Realized FX Gain Loss

Realized FX Gain/Loss

Journal Entry Detail Unrealized FX Gain Loss
  • Creation
  • Reversal

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 Invoice 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