Welcome to Zuora Product Documentation

Explore our rich library of product information

Gateway Reconciliation Log data source

Data source to export Gateway Reconciliation Log data

Note:

This feature is in the Early Adopter phase. If you want to have access to the feature, submit a request at Zuora Global Support.

Use this data source to export Gateway Reconciliation Log data. This data source only includes the events, by job, that matched a Zuora transaction. Use this data to identify which transactions have been actually reconciled.

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_log_datasource.png

Gateway reconciliation log

ObjectDescription
Created DateTime the job was created.
Created Object IDThe result of the event processing.
Created Object TypeThe type of result of the even processing. Currently, the only result type is Refund.
Error CodeThe code assigned to a specific gateway error.
Error MessageThe message associated with a specific gateway error code.
IDThe reconciliation ID.
Related Object IDThe object influenced by the event.
Related Object Type

Related object types are:

  • Payment
  • Refund
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.

Gateway reconciliation event

ObjectDescription
AmountThe event amount returned by the gateway.
Created DateTime the job was created.
Event DateEvent execution date.
Event Type

The event types are as follows:

  • Transaction Settled
  • Transaction Rejected
  • Transaction Reversed
Gateway Raw RecordThe gateway response string.
Gateway Reason CodeThe error code returned by the gateway.
Gateway Reason MessageThe reason message corresponding to the Gateway Reason Code.
IDThe gateway reconciliation event ID.
Related Gateway Reference IDThis is used in relation to the payment gateway transaction.
Related Gateway Second Reference IDThis is used in relation to the payment gateway transaction.

Gateway reconciliation job

ObjectDescription
Created DateTime when the job was created.
GatewayThe name of the gateway from which the source information will be retrieved.
IDThe job ID.
Job NumberThe number assigned to the job for a particular reconciliation period.
Period EndThis is the latest date for which reconciliation events are expected for this job.
Period StartThis 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 objectDescription
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