Payment Activity Summary
The Payment Activity Summary report contains the following records and fields:
First Header Record
The first header record describes the report name, version, hierachy level, hierarcy ID, and indicates which dates are included in the report.
Example
First Header Record
Payment Activity Summary, 1, SampleMerchant (101011000241000110001), 101000000000000000000, Jul 29 2008, Jul 29 2008
The table below lists the fields in the first header record.
Table 56
Fields in the First Header Record
Position
Field Name
Decription
Data Type and Length
1 (A)
report_name
Name of the report
1 (B)
version_number
Version of the report
Numeric
1 (C)
hierarchy_level
Absolute hierarchy node value for which the report is requested
String (44)
1 (D)
report_activity_start_date
Start date of report
String (10)
1 (E)
report_activity_end_date
End date of report
String (10)
Second Header Record
The second header record contains the fields in the report.
The table below lists the fields in second header record.
Table 57
Fields in the Second Header Record
Position
Field Name
Description
Data Type and Length
1 (A)
category
Category of transaction, for example purchase or refund
String (60)
1 (B)
type
Description of funding event
String (50)
1 (C)
subtype
String (30)
1 (D)
count
Number of transactions
Numeric (10)
1 (E)
amount
Original Transaction Amount
String (10)
1 (F)
currency
Funding currency code
String (3)
1 (G)
funding_amount
Amount of the transaction face value in funding currency
Numeric (25)
1 (H)
funding_currency
Currency of the funds transferred to your bank account
String (3)
1 (I)
rate
Effective foreign exchange rate
Numeric (25)
1 (J)
reserved
Transaction Record
Each transaction record includes information about a CyberSource payment transaction.
Example
Transaction Record
Purchases, Settled, MasterCard, 5, 41, USD