Transaction

Last updated
Save as PDF

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:

Credit Balance Adjustment
Credit Memo Item
Credit Memo Application Item
Credit Taxation Item
Debit Memo Item
Debit Taxation Item
Invoice Adjustment
Invoice Item
Invoice Item Adjustment
Invoice Payment
Payment Application
Payment Application Item
Refund Application
Refund Application Item
Refund Invoice Payment
Taxation Item

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
AccountingPeriod	Periods of time that represents the financial calendar of your company.
Amendment	The change made to subscription. Contains the following fields: Auto Renew Code Contract Effective Date Created By ID Created Date Current Term Current Term Period Type Customer Acceptance Date Description Effective Date ID Name Renewal Setting Renewal Term Renewal Term Period Type Resume Date Service Activation Date Specific Update Date Status Subscription ID Suspend Date Term Start Date Term Type Type Updated By ID Updated Date
Invoice	The invoice to which the payment is applied.
Invoice Owner Account	Information about the customer account that receives invoices for the subscription.
Invoice Owner Bill To	Bill-to contact information for the customer account that receives invoices for the subscription.
Invoice Owner Default Payment Method	The default payment method of the customer account that receives invoices for the subscription.
Invoice Owner Sold To	Sold-to contact information for the customer account that receives invoices for the subscription.
Journal Entry	Represents a Zuora transaction recorded as a debit and credit.
Journal Run	Automated process for creating journal entries from Zuora transactions.
Product	The product information. Contains the following fields: AllowFeatureChanges Category Created By ID Created Date Description Effective End Date Effective Start Date ID Name NetSuite Integration ID NetSuite Integration Status NetSuite Item Type NetSuite Sync Date SKU Updated By ID Updated Date
Product Rate Plan	The rate plan coming from the product catalog. Contains the following fields: Created By ID Created Date Description Effective End Date Effective Start Date ExternalldSourceSystem Grade ID Name Updated By ID Updated Date
Product Rate Plan Charge	The product rate plan charge information coming from the product catalog. Contains the following fields: Accounting Code Apply Discount To Bill Cycle Day Bill Cycle Type Billing Period Billing Period Alignment Billing Timing Charge Model Charge Type Created By ID Created Date Default Quantity Deferred Revenue Account Description Discount Level End Date Condition ID Included Units Legacy Revenue Reporting List Price Base Max Quantity Min Quantity Name Number Of Period Overage Calculation Option Overage Unused Units Credit Option Price Change Option Price Increase Percentage Rating Group Recognized Revenue Account Revenue Recognition Code Revenue Recognition Rule Name Revenue Recognition Trigger Smoothing Model Specific Billing Period Tax Code Tax Mode Taxable Trigger Event UOM Up To How Many Periods Up To Periods Type Updated By ID Updated Date Usage Records Rating Option Use Discount Specific Accounting Code Use Tenant Default For Price Change Weekly Bill Cycle Day
Rate Plan	Refers to the rate plan or pricing plan information associated with the subscription. Contains the following fields: Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. Created By ID Created Date Externally Managed Plan ID: a text field. This field indicates the unique identifier of a rate plan purchased on a third-party store. ID Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan Name Original Rate Plan ID: the original ID of the subscription rate plan, which is the ID of the subscription rate plan in the version-1 subscription Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan Subscription Rate Plan Number Updated By ID Updated Date
Rate Plan Charge	The charge information associated with the subscription. Contains the following fields: Accounting Code Apply Discount To Bill Cycle Day Bill Cycle Type Billing Period Billing Period Alignment Billing Timing Charge Model Charge Number Charge Type Charged Through Date Created By ID Created Date DMRC DTCV Description Discount Level Effective End Date Effective Start Date End Date Condition ID Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan charge Is Last Segment Is Processed List Price Base MRR Name Number of Periods Original ID Overage Calculation Option Overage Unused Units Credit Option Price Change Option Price Increase Percentage Processed Through Date Quantity Rating Group Revenue Recognition Code Revenue Recognition Rule Name Revenue Recognition Trigger Condition Segment Specific Billing Period Specific End Date Subscription Id: the ID of the subscription that contains the rate plan charge Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan charge TCV Trigger Date Trigger Event Unit of Measure Up To Periods Up To Periods Type Updated By ID Updated Date Version Weekly Bill Cycle Day
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. Contains the following fields: Auto Renew Cancelled Date Contract Acceptance Date Contract Effective Date Cpq Bundle Json ID Created By ID Created Date Creator Account ID Creator Invoice Owner ID Current Term Current Term Period Type ID Initial Term Initial Term Period Type Invoice Owner ID Invoice Separate Name Notes Opportunity Close Date Opportunity Name Original Created Date Original ID Previous Subscription ID Quote Business Type Quote Number Quote Type Renewal Setting Renewal Term Renewal Term Period Type Service Activation Date Status Subscription End Date Subscription Start Date Term End Date Term Start Date Term Type Updated By ID Updated Date Version
Subscription Owner Account	Information about the customer account that owns the subscription.
Subscription Owner Bill To	Bill-to contact information for the customer account that owns the subscription.
Subscription Owner Default Payment Method	The default payment method of the customer account that owns the subscription.
Subscription Owner Sold To	Sold-to contact information for the customer account that owns the subscription.