Knowledge Center

Knowledge Center > Insights > Quick Reference > Insights Analysis > Transaction

Transaction

The Transaction data source in Insights Analysis provides the transaction details of every object that has a direct financial impact on your subscription business. You can use the Transaction data source to calculate net payments, calculate net billing, or summarize accounts receivable activity for a period.

Each Transaction object corresponds to one of the following objects:

  • Invoice Item
  • Taxation Item
  • Invoice Item Adjustment
  • Invoice Adjustment
  • Invoice Payment
  • Refund Invoice Payment
  • Credit Balance Adjustment

The Transaction fields represent properties that are common to these objects, such as the amount, the change in account balance, and the date. You can use the "Transaction: Transaction Type" field to determine which object a Transaction corresponds to.

If currency conversion is enabled, the following Transaction Fields are also available in the home currency configured in your Zuora tenant:

  • Amount
  • Change in Account Balance
  • Change in Invoice Balance

The exchange rate for currency conversion is determined from the object that the Transaction corresponds to. See Insights Analysis for more information about currency conversion in Insights Analysis.

Transaction Fields

Field Description
Amount The Transaction amount. For example, the amount being charged for an Invoice Item.
Category "Billing" for Invoice Items, Taxation Items, Invoice Item Adjustments, and invoice Adjustments. "Payment" for Invoice Payments, Refund Invoice Payments, and Credit Balance Adjustments.
Change in Account Balance The change in account balance resulting from the Transaction.
Change in Invoice Balance The change in invoice balance resulting from the Transaction.
Created By ID The ID of the user who created the Transaction.
Created Date The date when the Transaction was created.
Currency The currency of the Transaction amount.
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 transaction corresponds to.
ID The unique identifier of the Transaction.
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.
Transaction Date The date of the Transaction. For example, the adjustment date of an Invoice Item Adjustment.
Transaction Type The object name of the Transaction.
Transferred to Accounting Indicates if the Transaction was transferred to an external accounting system, such as NetSuite. Possible values: "Processing", "Yes", "Error", "Ignore".
Updated By ID The ID of the user who last updated the Transaction.
Updated Date The date when the Transaction was last updated.

Change in Account Balance and Change in Invoice Balance

The "Transaction: Change in Account Balance" and "Transaction: Change in Invoice Balance" fields do not necessarily have the same value. For example, if a credit balance adjustment is applied to an invoice, the invoice balance changes but the invoice holder's account balance does not change.

Related Objects

In addition to the Transaction fields, the Transaction data source provides the following related objects. See Zuora Business Object Model for information about the relationships between these objects.

Object Description

Account

The customer account information.

AccountingPeriod

Periods of time that represents the financial calendar of your company.

Amendment

The change made to subscription, such as changes to terms and conditions, product changes, and cancelations.

Bill To

The contact associated with the account to whom your product or service is billed.

Default Payment Method

The default payment method used to make payments.

Invoice

The invoice to which the payment is applied.

Journal Entry

Represents a Zuora transaction recorded as a debit and credit.

Journal Run

Automated process for creating journal entries from Zuora transactions.

Parent Account

Refers to the parent account associated with the customer account, if applicable.

Product

The product information.

Product Rate Plan

The rate plan coming from the product catalog.

Product Rate Plan Charge

The product rate plan charge information coming from the product catalog.

Rate Plan

Refers to the rate plan or pricing plan information associated the subscription.

Rate Plan Charge

The charge information associated with the subscription.

Sold To

The contact associated with the account to whom your product or service is sold.

Subscription

The subscription to which the rate plan is associated.

Last modified
19:26, 31 Jul 2017

Tags

Classifications

(not set)