CSV Report Formats
This chapter describes the comma-separated values (CSV) format of the following CyberSource Merchant Account CSV reports:
■
Payment Activity Summary
■
Chargeback Analysis
■
Purchase & Refund Details
■
Authorization Analysis
■
Chargeback & Representment Details
■
Transfer Log
CyberSource CSV Conventions
First Header Record
The first header record describes the name and version of the report and indicates which dates are included in the report.
Example
First Header Record
Payment Activity Summary Report,1.0,2008-08-15 to 2008-08-15,,,,,,,
Second Header Record
The Payment Activity Summary is the only report with a second header record. This record indicates the name of each field in the report.
Data Records
These conventions apply to the data:
■
The CSV version of each report uses quotation marks around each of the report’s values (for example: "request_id", "06/09/08", "100.00").
■
If the value of a field contains a comma, the contents of the field are surrounded by additional double quotes ("). For example, the value A,B,C is represented as: ""A,B,C"".
■
If the value of a field contains a double quote ("), the contents of the field are surrounded by double quotes, and the double quote is represented as two double quotes. For example, the value Sample "value" is represented as: "Sample ""value""".
■
Records are separated with a carriage return followed by a line feed.
This chapter uses the following terms to refer to the data type of each field:
■
Alphanumeric: String containing letters, numbers, and special characters (for example, @, #, and %). All text uses UTF-8 character encoding.
■
Boolean: Single character; T for true or F for false.
■
Amount: An amount, including a decimal point if necessary.
■
Date: DD-MM-YYYY, where:
●
DD is the two-digit day
●
MM is the two-digit month
●
YYYY is the four-digit year
■
DateTime: DD-MM-YYYY-THH:MM:SS[+ | -]HH:MM, where:
●
DD is the two-digit day.
●
MM is the two-digit month.
●
YYYY is the four-digit year.
●
THH:MM:SS is the time, with HH representing hours, MM representing minutes, and SS representing seconds.
●
[+ | -]HH:MM is the time zone’s offset from Greenwich Mean Time (GMT), with HH representing hours and MM representing minutes. The number is prefixed by either a plus (+) or minus (-) to indicate whether the offset adds to or subtracts from GMT. For example, the offset for Pacific Daylight Time (PDT) is -07:00.
For example,”2008-07-31T16:31:18-07:00” represents July 31, 2008 at 4:31:18 PM PDT.
■
Numeric: String containing numbers.
The data lengths indicate the maximum length of each field. If a field is shorter than the maximum length, it is not padded in any way.
Exported Search Results
This section describes the exported search results.
First Line of the Report
The first line of the report describes the column headings with the name of each field. The data type and length of each field is alphanumeric.
Example
First Line of the Report
report_name, version_number, hierarchy_level, report_activity_start_date, report_activity_end_date
Transaction Record
Each transaction record includes information about a CyberSource payment transaction. For information about possible values for each field, see the implementation guide for the services that you use.
Example
Transaction Record
Purchases, Settled, MasterCard, 5, 41, USD"
Each line of the report is described in the table below.
Table 55
Fields in the Transaction Record
Position
(Column)
Field Name
Description
Data Type and Length
3 (A)
category
Category of transaction, such as purchase or refund
String (60)
3 (B)
type
Description of funding event
String (50)
3 (C)
subtype
Description of the type of funding event
String (30)
3 (D)
count
Number of transactions
Numeric (10)
3 (E)
amount
Original transaction amount
Amount (25)
3 (F)
currency
Funding currency code
String (3)
Sample Record
Each record includes information about an order.
Purchases, Settled, MasterCard, 5, 41, USD
Refunds, Settled, MasterCard, 3, -21, USD
Purchases, Settled, Subtotal, 5, 41, USD
Purchases, Conveyed, Subtotal, 00, USD
Refunds, Settled, Subtotal, 3, -21, USD
Refunds, Conveyed, Subtotal, l00, USD
Net_Purchase_Refund, Settled, Subtotal, 8, 20, USD
Net_Purchase_Refund, Conveyed, Subtotal, 00, USD
Fees, Settled, Subtotal, USD
Chargebacks_Representments, Settled, MasterCard, 1, -10, USD
Chargebacks_Representments, Settled, Subtotal, 1, -10, USD
Net_Total, Settled, Total, 10, USD