CCP500 – Credit Card Transaction Listing

This batch report lists credit card transaction details by settlement number or by a user-specified date range. Details include credit card authorization code, authorization date/time, and amount; however, it does not include receipt numbers. You can use this record to manually resolve date/time discrepancies.

As of 7.4.1SP1, the Meta Query columns in the CCP_REQ_ANS table are now available in the advanced filter.

Parameters

Parameter

Description

Required?

Organization

The Organization ID for which you want to run the report.

Read-only

Organization Unit

The Organization Unit ID for which you want to run the report.

Read-only

Mode

Mode in which the report runs:

·       UNSETTLED – displays all unsettled transactions.

·       SETTLEMENT – displays all settlement transactions.

·       BYDATE – displays all transactions between given dates.

Yes

Only Summary?

Y – View only the summary report.
N – View a detailed report.

Yes

Settlement Number

Settlement number for which you want the transaction listing report.

No

Date From

All transactions after this date display in the report.
Specify date in DD-MON-YYYY HH: MI: SS format.

Yes (only if BYDATE mode selected)

Date To

All transactions before this date display in the report.
Specify date in DD-MON-YYYY HH: MI: SS format.

Yes (only if BYDATE mode selected)

Sample Report