CSV Report Formats

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

■

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.

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)

Data Type and Length

Category of transaction, such as purchase or refund

Description of funding event

Description of the type of funding event

Number of transactions

Original transaction amount

Funding currency code

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