Knowledge Center

Knowledge Center > Reporting > Quick Reference > Reporting Overview > D Data Sources and Exports > C Data Source Reference > DRAFT: Transaction Data Source

DRAFT: Transaction Data Source

THIS ARTICLE IS A DRAFT AND IS NOT YET PUBLISHED. 

The Transaction data source provides the transaction details of every business 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.

The Transaction data source is an advanced data source. Advanced data sources enable you to easily create reports that would be very difficult or impossible to create using basic data sources. Advanced data sources are only available for use in reports. See TODO for more information.

In the Transaction data source, each Transaction 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.

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.

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.

Amendment

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

Bill To

The entity or person 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.

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 entity or person associated with the account to whom your product or service is sold.

Subscription

The subscription to which the rate plan is associated.

Last modified
21:04, 14 May 2017

Tags

Classifications

(not set)