Purchase & Refund Details
The Purchase & Refund Details report contains the following records and fields:
First Header Record
The first header record contains the fields in the report.
Example
First Header Record
request_id, cybs_mid, processor_mid, hierarchy_level, trans_ref_no,
merchant_ref_no, transaction_type, submission_date,,,,,,
The table below lists the fields in the first header record.
Table 58
Fields in the First Header Record
Position
Field Names
Description
Data Type and Length
1 (A)
request_id
Request ID of the original transaction
Numeric
1 (B)
cybs_mid
CyberSource merchant ID
String (30)
1 (C)
processor_mid
Gateway Merchant ID
Numeric (20)
1 (D)
hierarchy_level
Hierarchy level of the purchase or refund transaction
String (20)
1 (E)
trans
_
ref
_
no
The transaction reference number assigned by CyberSource
Numeric (12)
1 (F)
merchant
_
ref
_
no
Reference number assigned to the purchase transaction by the merchant
String (30)
1 (G)
transaction_type
Value defining the transaction type (purchase or refund)
String (30)
1 (H)
submission_date
Date of the purchase or refund transaction
Date (28)
1 (I)
amount
Original Transaction Amount
Amount (25)
1 (J)
transaction_amount_currency
Original transaction currency code
String (3)
1 (K)
payment_method
Method of payment used in the original transaction – Mastercard, Visa, Discover, American Express
String (20)
1 (L)
payment_type
Mode of payment, such as credit card
String (20)
1 (M)
account_suffix
Last 4 digits of the credit card
String (4)
1 (N)
auth
_
trans
_
ref
_
no
The transaction reference number of the original auth transaction
Numeric (12)
1 (O)
auth_date
The transaction date of the original auth transaction
Date (28)
1 (P)
auth
_
request
_
id
Request ID of the original auth transaction
Numeric (26)
1 (Q)
auth_amount
Original auth Transaction Amount
Amount (25)
1 (R)
auth
_
currency_code
Original auth transaction currency code
String (3)
1 (S)
auth_code
Authorization Code
String (10)
1 (T)
auth
_
rcode
Response code of the original auth transaction
Integer (1)
1 (U)
cybs_batch_date_time
The date and time the transaction was batched at CyberSource
Date and time (28)
1 (V)
cybs_batch_id
The batch ID in which this transaction was included
Numeric (38)
1 (W)
card_type
Card type used in the original transaction
Numeric (2)
1 (X)
charge_type
Charge type associated with the original transaction
Numeric (4)
1 (Y)
interchange_description *
Text description of the interchange category
String (60)
1 (Z)
interchange_percentage *
Interchange percentage charged for this transaction
Numeric (38)
1(AA)
interchange_percentage_amount *
Interchange amount charged for this transaction
Numeric (38)
1(AB)
interchange_per_item_fee *
Per-item fee that was charged for this transaction
Numeric (38)
1(AC)
debit_network
Indicates the Debit Network used for this transaction
String (20)
1(AD)
discount_percentage
Discount rate added
Numeric (38)
1(AE)
discount_amount
Discount amount added
Numeric (38)
1(AF)
dicsount_per_item_fee
Fee amount assessed for each transaction in addition to the discount percentage.
Numeric (38)
1(AG)
total_fee
Total of fees collected for the transaction being reported. Amount in parenthesis ( ) denotes a negative number.
Numeric (38)
1(AH)
fee_currency
Currency in which the fees were collected, which is always the same as the funding currency.
String (3)
1(AI)
merchant_defined_data2
Reserved for future use
1(AJ)
merchant_defined_data2
Reserved for future use
1(AK)
merchant_defined_data3
Reserved for future use
1(AL)
merchant_defined_data4
Reserved for future use
1(AM)
funding_amount
Amount of the transaction face value in funding currency. Amount in parenthesis ( ) denotes a negative number
Numeric (25)
1(AN)
funding_currency
Funding currency code
String (3)
1 (AO)
bucket_merchant
Indicates whether customer is a small business merchant
String (1)
1(AP)
first_name
Customer’s first name
String (60)
1(AQ)
last_name
Customer’s last name
String (60)
1(AR)
reserved6
Reserved for future use
1(AS)
reserved7
Reserved for future use
1(AT)
reserved8
Reserved for future use
1(AU)
reserved9
Reserved for future use
1(AV)
reserved10
Reserved for future use
* N/A to Bundled-pricing merchants
Transaction Record
Each transaction record includes information about a CyberSource payment transaction.
Example
Transaction Record
2173546600000167904567, SampleMerchant, 8610000000000, 101011000000000000000,
20846410061, 33557799, Purchases, 7/28/2008, 10, USD, MasterCard, credit card,,,,,,,,,,,