Welcome to Zuora Product Documentation

Explore our rich library of product information

Transaction object in Analytics

The Transaction object in Analytics records every account receivable transaction affecting the account balance in your Zuora tenant, and can be used with Net Billing and Net Payments metrics.

The Transaction object in Analytics provides a detailed record of every account receivable transaction that has an impact on the account balance in your Zuora tenant. You can use the data fields of the Transaction object with the Net Billing and Net Payments metrics.

The Transaction object consists of the following data fields.

Data fields

Description

Category

Indicates if the transaction corresponds to billing or payment activity in Zuora.

Values:

  • Payment

  • Billing

Document Number

The number of the document that the Transaction corresponds to. For example, the number of the Invoice that contains an Invoice Item.

Document Type

The type of document that the Document Number field corresponds to.

Status

The status of the transaction or the Transaction's document. For example, "Processed" for an Invoice Payment where the corresponding Payment has been processed.

ID

The unique identifier of the Transaction.

Transaction Type

The object name of the Transaction.

Values for Transaction Category = “Billing” include:

  • Credit Memo Item

  • Credit Taxation Item

  • Debit Memo Item

  • Debit Taxation Item

  • Invoice Item

  • Invoice Item Adjustment

  • Invoice Adjustment

  • Taxation Item

Values for Transaction Category = “Payment” include:

  • Invoice Payment

  • Payment Application

  • Refund Invoice Payment

  • Refund Application

  • Credit Balance Adjustment

Transaction Subtype

Provides additional categorical information about the transaction. The Transaction Subtype field is populated in the following manner depending on transaction types.

Values for each transaction type in the ‘Billing’ transaction category:

  • Invoice Items: This field is null

  • Invoice Item Adjustment: This field is populated from the Invoice Item Adjustment Type field. Possible values include:

    • Credit

    • Charge

  • Invoice Adjustment: This field is populated from the Invoice Adjustment Type field. Possible values include:

    • Credit

    • Charge

  • Credit Memo Item: This field is null

  • Credit Taxation Item: This field is null

  • Debit Memo Item: This field is null

  • Debit Taxation Item: This field is null

  • Taxation Item: This field is null

For payment transaction:

  • Payment. Type for Invoice Payment and Payment Application

  • Refund. Type for Refund Invoice Payment and Refund Application

Values for each transaction type in the ‘Payment’ transaction category:

  • Invoice Payment: Possible values include:

    • External

    • Electronic

  • Payment Application: Possible values include:

    • External

    • Electronic

  • Refund Invoice Payment: Possible values include:

    • External

    • Electronic

  • Refund Application: Possible values include:

    • External

    • Electronic

  • Credit Balance Adjustment: Possible values include:

    • Credit Balance Transfer to Invoice

    • Credit Balance Application to Invoice

    • Credit Balance Refund

    • Credit Balance Increase from Overpayment

Transferred To Accounting

Indicates if the Transaction was transferred to an external accounting system, such as NetSuite.

Possible values include:

  • Processing

  • Yes

  • Error

  • Ignore