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:
- 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:
|
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:
|
Product Rate Plan |
The rate plan coming from the product catalog. Contains the following fields:
|
Product Rate Plan Charge |
The product rate plan charge information coming from the product catalog. Contains the following fields:
|
Rate Plan |
Refers to the rate plan or pricing plan information associated with the subscription. Contains the following fields:
|
Rate Plan Charge |
The charge information associated with the subscription. Contains the following fields:
|
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:
|
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. |