Skip to navigation

Gateway Reconciliation Event data source

View as Markdown

Data source to export Gateway Reconciliation Event data

Use this data source to export Gateway Reconciliation Event data. This data source will include all events processed by the reconciliation job, regardless if the event matched a Zuora transaction or not.

Accessing the data source

​Navigation: Reporting > Data Sources and select Gateway Reconciliation Event as the data source.

Objects available in the data source

gateway reconciliation event datasource

Gateway Reconciliation Event

Object

Description

Amount

The event amount returned by the gateway.

Created Date

Time when the job was created.

Event Date

Event execution date.

Event Type

The event types are as follows:

  • Transaction Settled
  • Transaction Rejected
  • Transaction Reversed

Gateway Raw Record

The gateway response string

Gateway Reason Code

The error code returned by the gateway.

Gateway Reason Message

The reason message corresponding to the Gateway Reason Code.

ID

The gateway reconciliation event ID.

Related Gateway Reference ID

This is used in relation to the payment gateway transaction.

Related Gateway Second Reference ID

This is used in relation to the payment gateway transaction.

Gateway Reconciliation Job

Object

Description

Created Date

Time the job was created.

Gateway

The name of the gateway from which the source information will be retrieved.

ID

The job ID.

Job Number

The number assigned to the job for a particular reconciliation period.

Period End

This is the latest date for which reconciliation events are expected for this job.

Period Start

This is the earliest date for which reconciliation events are expected for this job.

Status

The status of the reconciliation job.

  • Processing — The job is processing.
  • Completed — The job has completed and the report was successfully processed.
  • Error — The job failed due to an error. The job details page provides additional information.

Entity

Zuora object

Description

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