Welcome to Zuora Product Documentation

Explore our rich library of product information

Fields in the Accounts Receivable detail report

The fields that are included in the Accounts Receivable detail report

The following table describes the fields that are included in the Accounts Receivable detail report.

Field

Description

Customer Account Number

Customer account number associated with the transaction.

Customer Account Name

Customer account name associated with the transaction.

Customer Account Currency

Currency of the customer account. Each customer account has only one currency.

<Customer Account Segments>

If you have configured any segments related to customer accounts, the segment names appear here as column headings. The segments are arranged in alphabetical order.

See Fields supported by segments for information about which customer account fields are supported on segments.

Home Currency

Home currency used.

Exchange Rate Date

The date of the exchange rate used.

Exchange Rate

The exchange rate used.

Transaction Date

Date when the transaction occurred.

Transaction Type

Type of transaction, such as an invoice item or invoice item adjustment.

Transaction Subtype

Subtype of the transaction. See Transaction subtypes for more information.

Transaction Number

Transaction number, such as INV-00000001 for an invoice item.

Transaction ID

Unique system ID for the transaction.

Transaction Amount

Amount of the transaction.

Transaction Amount (Home Currency)

Transaction amount in your home currency.

Transaction Amount Currency Rounding

The discrepancy caused by rounding the transaction amount during currency conversion. Accurate to nine decimal places.

Debit Accounting Code

Accounting code that was debited.

Debit Amount

Amount that was debited.

Debit Amount (Home Currency)

Debit amount in your home currency.

Debit Amount Currency Rounding

The discrepancy caused by rounding the debit amount during currency conversion. Accurate to nine decimal places.

Credit Accounting Code

Accounting code that was credited.

Credit Amount

Amount that was credited.

Credit Amount (Home Currency)

Credit amount in your home currency.

Credit Amount Currency Rounding

The discrepancy caused by rounding the credit amount during currency conversion. Accurate to nine decimal places.

Accounts Receivable Accounting Code

Accounting code for Accounts Receivable.

Accounts Receivable Accounting Code Balance Impact

Impact on the balance of your Accounts Receivable accounting code.

Accounts Receivable Accounting Code Balance Impact (Home Currency)

Accounts Receivable Accounting Code Balance Impact in your home currency.

Accounts Receivable Accounting Code Balance Impact Currency Rounding

The discrepancy caused by rounding the Accounts Receivable Accounting Code Balance Impact amount during currency conversion. Accurate to nine decimal places.

Credit Balance Accounting Code

Accounting code for Credit Balance.

Credit Balance Accounting Code Balance Impact

Impact on the balance of your Credit Balance accounting code.

Credit Balance Accounting Code Balance Impact (Home Currency)

Credit Balance Accounting Code Balance Impact in your home currency.

Credit Balance Accounting Code Balance Impact Currency Rounding

The discrepancy caused by rounding the Credit Balance Accounting Code Balance Impact amount during currency conversion. Accurate to nine decimal places.

Account Balance Impact

Impact on the balance of the customer account.

Account Balance Impact in your home currency.

Account Balance Impact (Home Currency)

Account Balance Impact Currency Rounding

The discrepancy caused by rounding the Account Balance Impact amount during currency conversion. Accurate to nine decimal places.

Transaction Service Period Start

The Transaction Service Period Start and End dates are based on the transaction type. For example, for an invoice item, the dates are based on the service start and end dates of that invoice item.

Transaction Service Period End

Associated Transaction Type

Type of the associated transaction. See Associated transaction types and Associated transaction types: Invoice Settlement for more information.

Associated Transaction Subtype

Subtype of the associated transaction. See Transaction subtypes for more information.

Associated Transaction ID

ID of the associated transaction.

Associated Transaction Number

Number of the associated transaction.

<Transaction Segments>

If you have configured any segments related to transactions, the segment names appear here as column headings. The segments are arranged in alphabetical order.

See Fields supported by segments for information about which fields are supported on segments.

Container Transaction Type

Type of the container transaction.

See Transaction types for more information.

Container Transaction Subtype

Subtype of the container transaction.

See Transaction types for more information.

Container Transaction ID

ID of the container transaction.

Container Transaction Number

Number of the container transaction.

Product

Name of the product.

Product Rate Plan

Name of the product rate plan.

Product Rate Plan Charge

Name of the product rate plan charge.

<Product Segments>

If you have configured any segments related to products, the segment names appear here as column headings. The segments are arranged in alphabetical order.

See Fields supported by segments for information about which product fields are supported on segments.

Subscription Name

Name of the subscription.

Subscription Rate Plan Charge ID

ID of the subscription rate plan charge.

<Subscription Segments>

If you have configured any segments related to subscriptions, the segment names appear here as column headings. The segments are arranged in alphabetical order.

See Fields supported by segments for information about which subscription fields are supported on segments.