AR Transaction data source

Last updated
Save as PDF

You can use this data source to export all the transactions that impact your Accounts Receivable that happened during a period.

The ability to query and view all transactions will give you greater visibility and transparency into your financial interactions with subscribers.
The AR Transaction object will also enable you to track all your financial transactions in one data source export/report with the required filters and cross-object joins. This will simplify the reconciliation process, making it easier to query invoices, debit and credit memos, payments and identify discrepancies.
The new data source object will also simplify the compliance and reporting process for you, making it easier to generate reports of all transactions, saving time and effort during financial audits.

This feature is in the Early Adopter phase. We are actively soliciting feedback from a small set of early adopters before releasing it to all customers. To join this early adopter program, submit a request to Zuora Global Support.

Access the AR Transaction data source

Navigate to Reporting > Data Sources and select AR Transaction from the Data Source list in the Basic Information section.

Data source detail

AR Transaction data source is classified as base objects and related objects as mentioned in the following sections.

Base object

The following table lists the fields available in the AR Transaction base object.

Zuora Object	Description
AR Transaction	Line items on AR Transaction. It includes the following fields: Created By ID Created Date Home Currency Home Currency Amount Home Currency Amount Rounding Home Currency Rate Home Currency Rate Date Id Reporting Currency Reporting Currency Amount Reporting Currency Amount Rounding Reporting Currency Rate Reporting Currency Rate Date Transaction Amount Transaction Date Transaction Detail Type Transaction Id Transaction Number Transaction Type Updated by Id Updated Date

Zuora Object

Description

AR Transaction

Line items on AR Transaction. It includes the following fields:

Created By ID
Created Date
Home Currency
Home Currency Amount
Home Currency Amount Rounding
Home Currency Rate
Home Currency Rate Date
Id
Reporting Currency
Reporting Currency Amount
Reporting Currency Amount Rounding
Reporting Currency Rate
Reporting Currency Rate Date
Transaction Amount
Transaction Date
Transaction Detail Type
Transaction Id
Transaction Number
Transaction Type
Updated by Id
Updated Date

Related objects

The following table lists the related objects of the AR Transaction object in alphabetical order.

Zuora Object	Description
Account	The account that made the payment. For more information, see Account Data Source.
Credit Accounting Code	This is the base Zuora object for the Accounting Code data source export. For more information, see Accounting Code Data Source.
Credit Memo	Credit memos that you issued to your customers to reduce invoice and account balances. For more information, see Credit Memo Data Source.
Credit Memo Item	Line items on credit memos. For more information, see Credit Memo Item Data Source.
Credit Taxation Item	Taxation records on credit memos. For more information, see Credit Taxation Item Data Source.
Debit Accounting Code	This is the base Zuora object for the Accounting Code data source export. For more information, see Accounting Code Data Source.
Debit Memo	Debit memos that you issued to your customers to increase the amount your customers owned you. For more information, see Debit Memo Data Source.
Debit Memo Item	Line items on debit memos. For more information, see Debit Memo Item Data Source.
Debit Taxation Item	Taxation records on debit memos. For more information, see Debit Taxation Item Data Source.
Default Payment Method	An object that stores information about the payment method, such as a credit card, ACH or PayPal. For more information, see Payment Method Data Source.
Invoice	Invoices that reflect the subscription rate plan charges that have not been billed. For more information, see Invoice Data Source.
Invoice Item	This is the base object for the Invoice Item Data Source Export. For more information, see Invoice Item Data Source.
Payment	The money sent by a customer to pay for charges related to their subscriptions. For more information, see Payment Data Source.
Payment Method	An object that stores information about the payment method, such as a credit card, ACH or PayPal. For more information, see Payment Method Data Source.
Product	The product is the base object for this export. For more information, see Product Data Source.
Product Rate Plan Charge	Fields on a product rate plan charge. For more information, see Product Rate Plan Charge data source.
Rate Plan	This is the base object for the Rate Plan Data Source Export. For more information, see Rate Plan Data Source.
Rate Plan Charge	Fields on a rate plan charge. For more information, see Rate Plan Charge Data Source.
Refund	Represents money that is returned to a customer or a reversed transaction. For more information, see Refund Data Source.
Taxation Item	This is the base object for the Taxation Item Data Source Export. For more information, see Taxation Item Data Source.