Credit Card Exception Report

This report provides details of all credit card transactions that are not fully processed or that are pending to assist system administrators and income auditors fix potential issues. This report is populated from the Payment_Card_Settlement table in the it_rlt database.

Grouping Levels (3 possible)	Sorting Choices	Filters
Profit Center *	Amount	Profit Center *
Profit Center Group	Check Number	Profit Center Group
Status *	Tendered Time*	Status (Pending, Failed, and Partial options selected by default.)
Error Code		Refund
* = default setting		Offline

Field Definitions:

Field	Description
ID	Settlement Gen ID (unique identifier for a transaction and a system generated number)
Tendered Time	Date and Time when check got tendered
Check No	Check Number
Account Number	Account number for credit card transactions
Amount	Check total
Status	Status of the credit card transaction. Possible values are: Successful, Pending, Retry, Partial, Failed, and Real-Time.
Repost Count	The number of times transaction was reposted (When a transaction fails, it is possible to Repost it and try it again.)
Error Code	Error code representing some unique error message
Error Message	Description of error for a credit card transaction
Offline	Flag indicating if terminal was offline when transaction was done
Refund	Flag indicating refund or non-refund transactions
Profit Center	Profit Center Name and ID