|
|
|
|
|
|
This appendix provides sample reports in CSV format:
Payment Submission Detail Report
Transaction Exception Detail Report
This sample contains two capture transactions and one credit transaction.
Payment Batch Detail Report,1.0,2003-05-01 to 2003-05-01,,,,,,,
batch_id,merchant_id,batch_date,request_id,merchant_ref_number,trans_ref_no,payment_method,currency,amount,transaction_type
123456,CyberSource,2003-05-01,0004172180000167905139,45CBBDE3378A553,5652882910,Visa,USD,100.00,ics_bill
123456,CyberSource,2003-05-01,0004173790000167905139,5DADC3D2F4B7118,5629152830,Visa,USD,-100.00,ics_credit
123456,CyberSource,2003-05-01,0004174690000167905139,CBBF93898A39519,5653068690,Visa,USD,100.00,ics_bill
This sample contains these events:
• Three credit card events: a payment, a failed transaction, and a refund
• One bank transfer
• One check
Payment Events Report,1,2/28/2004,merchant_id,,,,
1004223530000167905139,CyberSource,4828225690-3098813497360087,credit card,Payment,2/28/2004,54415,JPY,20000,JPY,20000,,,[DC]
7004225530045163405877,CyberSource,1862337088-6423810158341592,credit card,Failed,2/28/2004,55247,JPY,20000,JPY,20000,,,[DC]
4173905000419009050013,CyberSource,1877734460-6234665442211693,credit card,Refund,2/28/2004,54920,JPY,-11208,JPY,-11208,,,
0004223530000167905139,CyberSource,1922378932-345155716486631,bank transfer,Payment,2/28/2004,59385,EUR,250.00,EUR,250.00,,,
0004223530000167904956,CyberSource,1983423981-435874045334492,check, Payment,2/28/2004,58342,USD,100.00,USD,100.00,USD,1.00,
Payment Submission Detail Report
This sample contains two capture transactions and one credit transaction.
Important The CSV version of the Payment Submission Detail Report uses quotation marks around each of the report’s values.
Payment Submission Detail Report,1.0,2003-05-01 to 2003-05-01,,,,,,,
batch_id,merchant_id,batch_date,request_id,merchant_ref_number,trans_ref_no,payment_method,currency,amount,transaction_type,payment_processor
"123456","CyberSource","2003-05-01","0004172180000167905139","45CBBDE3378A553","5652882910","Visa","USD","100.00","ics_bill","FDMS South"
"123456","CyberSource","2003-05-01","0004173790000167905139","5DADC3D2F4B7118","5629152830","Visa","USD","-100.00","ics_credit","FDMS South"
"123456","CyberSource","2003-05-01","0004174690000167905139","CBBF93898A39519","5653068690","Visa","USD","100.00","ics_bill","FDMS South"
Transaction Exception Detail Report
This sample contains two errors in which the direct debit had already been processed.
Transaction Exception Detail Report,1.0,2006-05-03 to 2006-05-03,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
row_descriptor,request_id,transaction_date,merchant_id,customer_id,merchant_ref_number,transaction_ref_number,transaction_type,payment_type,payment_method,amount,currency_code,payment_processor,original_request_id,action,reason_code,error_message,processor_message,account_suffix,customer_cc_expmo,customer_cc_expyr,bank_code,bank_account_name,customer_firstname,customer_lastname,bill_address1,bill_address2,bill_city,bill_state,bill_zip,bill_country,company_name,customer_email,customer_phone,ship_to_first_name,ship_to_last_name,ship_to_address1,ship_to_address2,ship_to_city,ship_to_state,ship_to_zip,ship_to_country
Request,1466816420000167904565,2006-05-03T11:40:44-05:00,gdtest2,,,QYEM5E8UK7Z9RX,Refund,DD,,-15,eur,cybersource,1466811700000167904565,ERROR, 313,You have already refunded 100% of the direct debit.,3201,,,12345, DIRECT_DEBIT TESTING,Rekha,KASTRUP,WILLY-MESSERSCHMITZ-STRASSE 9,,Nederlands,N/A,50126,at,,GERTRUDE@CYBERSOURCE.COM,227198940, Madeleine,Tison,143,BOULEVARD ANATOLE,SAINT-DENIS CEDEX,,93285,fr
Request,1466924940000167904565,2006-05-03T14:41:35-05:00,gdtest2,,,QYGR0YBCK6TG71,Refund,DD,,-4.25,eur,cybersource,1466922580000167904565,ERROR,313,You have already refunded 100% of the direct debit.,3 00,,,123,Direct_ Debit Testing,Lodewijk,le Grand,Postbus 125,,Wageningen,N/A,6700 AC,nl, lodewijk@cybersource.com,31348428926,Aude,Manet,143, boulevard Anatole, Saint-Denis Cedex 93285,fr
User Listing Report,Version 1.0,2007-09-14
Username,Merchant ID,First Name,Last Name,Email,Date Created,LastAccess,Status,Role, Permissions
infodev_user,infodev,Jane,Doe,,2007-03-29 07:47 GMT,2007-09-21 11:44 GMT,Enabled, Custom,Virtual Terminal Transaction|Payment Authorization
infodev_user_2,infodev,John,Doe,,2007-03-29 07:47 GMT,2007-09-21 08:00 GMT,Enabled, Report Download,Report Download
|
|
|
|
|
|