Credit Balance Adjustment Data Source

Last updated
Save as PDF

Use this data source to export data associated with credit balance adjustments. One row in the export represents one credit balance adjustment. Note that the Order to Revenue feature or the Billing - Revenue Integration feature does not support the Credit Balance Adjustment object.

If you have the Invoice Settlement feature enabled, this data source is deprecated and only available for backward compatibility.

Accessing the Data Source

Navigation: Reporting > Data Sources and select Credit Balance Adjustment as the Data Source.

Data Source Details

Data Source Diagram

This diagram illustrates the hierarchical association between the base Credit Balance Adjustment object and related (joined) Zuora objects.

Base Object Description

Zuora Object	Description
Credit Balance Adjustment	Represents one adjustment to the credit balance. This is the base Zuora object for the Credit Balance Adjustment data source export and includes the following fields: Account Id Accounting Code Adjustment Date Amount Comment Created By ID Created Date ID Number Reason Code ReferenceId Source Transaction ID Source Transaction Number Source Transaction Type Status Transferred To Accounting Type Updated By ID Updated Date

Zuora Object

Description

Credit Balance Adjustment

Represents one adjustment to the credit balance.

This is the base Zuora object for the Credit Balance Adjustment data source export and includes the following fields:

Account Id
Accounting Code
Adjustment Date
Amount
Comment
Created By ID
Created Date
ID
Number
Reason Code
ReferenceId
Source Transaction ID
Source Transaction Number
Source Transaction Type
Status
Transferred To Accounting
Type
Updated By ID
Updated Date

Related Zuora Objects

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora Object	Description
Account	The customer account information. Note this is the Invoice Owner account.
Accounting Period	Periods of time that represents the financial calendar of your company. Used to assist with accounting close activities and financial reporting. Contains the following fields: Created By ID Created Date End Date Fiscal Quarter Fiscal Year ID Name Notes Start Date Status Updated By ID Updated Date
Accounts Receivable Accounting Code	Accounting code for accounts receivable. Contains the following fields: Category Created By ID Created Date GL Account Name GL Account Number ID Name Notes Status Type Updated By ID Updated Date
Bank Account Accounting Code	Accounting code for your bank account. Contains the following fields: Category Created By ID Created Date GL Account Name GL Account Number ID Name Notes Status Type Updated By ID Updated Date
Cash on Account Accounting Code	Accounting code for customer cash on account. Contains the following fields: Category Created By ID Created Date GL Account Name GL Account Number ID Name Notes Status Type Updated By ID Updated Date
Credit Balance Adjustment FX Data	Contains Home Currency and Reporting Currency information. To enable this option, submit a request at Zuora Global Support.
Entity	The entity that the data relates to. Part of the Multi-entity feature. Contains the following fields: Address 1 Address 2 City Country Created By ID Created Date Display Name Email ID Name Postal Code State Updated By ID Updated Date
Invoice	The invoice to which the payment is applied.
Journal Entry	Represents a Zuora transaction recorded as a debit and credit. Includes the following fields: Created By ID Created Date Currency ID Journal Entry Date Notes Number [Segment Name]: One or more fields representing the name of each segment created. These fields become available for export on this data source only if they are used by the GL segmentation rule. Status Transaction Count Transaction Type Transfer Date Transferred By Transferred To Accounting Update By ID Updated Date This object is available on this data source only when Zuora Finance is enabled on your tenant.
Journal Run	Automated process for creating journal entries from Zuora transactions. Includes the following fields: Created By ID Created Date ID Number Process End Date Time Process Start Date Time Status Target Date Type Target End Date Target Start Date Total Journal Entry Count Updated By ID Updated Date This object is available on this data source only when Zuora Finance is enabled on your tenant.
Payment	The money sent by a customer to pay for charges related to their subscriptions. Contains the following fields: Accounting Code Amount Applied Amount (Only applicable if you have Invoice Settlement enabled) Applied Credit Balance Amount Authorized Transaction ID Bank Identification Number Cancelled On Comment Created By ID Created Date Currency Effective Date Gateway Gateway Order ID Gateway Reconciliation Status Gateway Reconciliation Reason Gateway Response Gateway Response Code Gateway State ID Marked For Submission On Payment Number Payout Id Prepayment Reference ID Referenced Payment ID Refund Amount Second Payment Reference ID Settled On Soft Descriptor Soft Descriptor Phone Source Source Name Standalone (Only applicable if support for standalone payments is enabled) Status Submitted On Transferred to Accounting Type Unapplied Amount Updated By ID Updated Date
Refund	Represents money that is returned to a customer, or a reversed transaction.