Knowledge Center

Knowledge Center > Reporting > Data Sources and Exports > Data Source Reference > Credit Balance Adjustment Data Source

Credit Balance Adjustment Data Source

Use this data source to export data associated with credit balance adjustments. One row in the export represents one credit balance adjustment.

If you have the Advanced AR 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.

Credit Balance Adjustment Data Source Diagram

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:

  • AccountId
  • AccountingCode
  • AdjustmentDate
  • Amount
  • Comment
  • CreatedById
  • CreatedDate
  • Id
  • Number
  • ReasonCode
  • ReferenceId
  • SourceTransactionId
  • SourceTransactionNumber
  • SourceTransactionType
  • Status
  • TransferredToAccounting
  • Type
  • UpdatedById
  • UpdatedDate

Related Zuora Objects

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora Object Description

Account

The customer account information.

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
Entity

The entity information. This object is only used for Zuora Multi-entity.

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
  • 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 Response
  • Gateway Response Code
  • Gateway State
  • ID
  • Marked For Submission On
  • Payment Number
  • Reference ID
  • Referenced Payment ID
  • Refund Amount
  • Second Payment Reference ID
  • Settled On
  • Soft Descriptor
  • Soft Descriptor Phone
  • Source
  • Source Name
  • 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.

Last modified
19:32, 10 May 2017

Tags

Classifications

(not set)