[CyberSource logo]


Search documentation:
  Help  Advanced
        Published 05/13/2002 Table of ContentsPreviousNextIndex

Appendix B

Sample Reports

This appendix provides sample reports in XML and CSV formats.

Sample XML Reports

Payment Batch Detail Report

The following example shows a report that contains two settlement (ics_bill) transactions and one credit (ics_credit) transaction. 

<?xml version="1.0" encoding="UTF-8"?> 
<Report Name="Payment Batch Detail" Version="1.0" 
        xmlns="http://reports.ic3.com/reports/pbdr/1.0" 
        MerchantID="CyberSource" 
        ReportStartDate="2001-08-16T00:01-07:00" 
        ReportEndDate="2001-08-16T23:59-07:00"> 
   <Batches> 
      <Batch BatchID="123456" BatchDate="2001-08-16"> 
         <Requests> 
            <Request RequestID="0004172180000167905139" 
                     MerchantReferenceNumber="45CBBDE3378A553"> 
<TransactionReferenceNumber>5652882910</TransactionReferenceNumber> 
               <PaymentMethod>Visa</PaymentMethod> 
               <CurrencyCode>USD</CurrencyCode> 
               <Amount>100.00</Amount> 
               <Application>ics_bill</Application> 
            </Request> 
            <Request RequestID="0004173790000167905139" 
                     MerchantReferenceNumber="5DADC3D2F4B7118"> 
<TransactionReferenceNumber>5629152830</TransactionReferenceNumber> 
               <PaymentMethod>Visa</PaymentMethod> 
               <CurrencyCode>USD</CurrencyCode> 
               <Amount>100.00</Amount> 
               <Application>ics_credit</Application> 
            </Request> 
            <Request RequestID="0004174690000167905139" 
                     MerchantReferenceNumber="CBBF93898A39519"> 
<TransactionReferenceNumber>5653068690</TransactionReferenceNumber> 
               <PaymentMethod>Visa</PaymentMethod> 
               <CurrencyCode>USD</CurrencyCode> 
               <Amount>100.00</Amount> 
               <Application>ics_bill</Application> 
            </Request> 
         </Requests> 
      </Batch> 
   </Batches> 
</Report>

Transaction Detail Report

The following example shows a report for a transaction that includes the ics_auth, ics_dav, ics_score, and ics_tax applications. 

<?xml version="1.0" encoding="UTF-8"?> 
<Report Name="Transaction Detail" Version="1.0" 
        xmlns="http://reports.ic3.com/reports/tdr/1.0" 
        MerchantID="CyberSource" 
        ReportStartDate="2001-08-16T00:01-07:00" 
        ReportEndDate="2001-08-16T23:59-07:00"> 
   <Requests> 
      <Request RequestID="0004223530000167905139" 
               RequestDate="2001-08-16T07:42-07:00" 
               MerchantReferenceNumber="3C515C71D48F631"> 
         <BillTo> 
            <FirstName>John</FirstName> 
            <LastName>Doe</LastName> 
            <MiddleName>A</MiddleName> 
            <Address1>1295 Charleston Rd.</Address1> 
            <City>Mountain View</City> 
            <State>CA</State> 
            <Zip>94043</Zip> 
            <CompanyName>CyberSource</CompanyName> 
            <Email>icsinfo@cybersource.com</Email> 
            <Country>US</Country> 
            <Phone>650-965-6000</Phone> 
            <IPAddress>127.0.0.1</IPAddress> 
            <HostName>hostname.cybersource.com</HostName> 
            <UserName>jdoe</UserName> 
         </BillTo> 
         <ShipTo> 
            <FirstName>John</FirstName> 
            <LastName>Doe</LastName> 
            <MiddleName>A</MiddleName> 
            <Address1>1295 Charleston Rd.</Address1> 
            <City>Mountain View</City> 
            <State>CA</State> 
            <Zip>94043</Zip> 
            <CompanyName>CyberSource</CompanyName> 
            <Email>icsinfo@cybersource.com</Email> 
            <Country>US</Country> 
            <Phone>650-965-6000</Phone> 
         </ShipTo> 
         <PaymentMethod> 
            <Card> 
               <AccountSuffix>1111</AccountSuffix> 
               <ExpirationMonth>12</ExpirationMonth> 
               <ExpirationYear>2009</ExpirationYear> 
               <CardType>Visa</CardType> 
            </Card> 
         </PaymentMethod> 
         <LineItems> 
            <LineItem Number="0"> 
               <FulfillmentType>PH</FulfillmentType> 
               <Quantity>1</Quantity> 
               <UnitPrice>50.00</UnitPrice> 
               <TaxAmount>1.86</TaxAmount> 
               <MerchantProductSKU>PROD001</MerchantProductSKU> 
               <ProductName>Sample Product One</ProductName> 
            </LineItem> 
            <LineItem Number="1"> 
               <FulfillmentType>DI</FulfillmentType> 
               <Quantity>1</Quantity> 
               <UnitPrice>35.81</UnitPrice> 
               <TaxAmount>1.29</TaxAmount> 
               <MerchantProductSKU>PROD002</MerchantProductSKU> 
               <ProductName>Sample Product Two</ProductName> 
               <ProductCode>electronic_software</ProductCode> 
            </LineItem> 
         </LineItems> 
         <ApplicationReplies> 
            <ApplicationReply Name="ics_auth"> 
               <RCode>1</RCode> 
               <RFlag>SOK</RFlag> 
               <RMsg>ok</RMsg> 
            </ApplicationReply> 
            <ApplicationReply Name="ics_score"> 
               <RCode>1</RCode> 
               <RFlag>SOK</RFlag> 
               <RMsg>score service was successful</RMsg> 
            </ApplicationReply> 
            <ApplicationReply Name="ics_tax"> 
               <RCode>1</RCode> 
               <RFlag>SOK</RFlag> 
               <RMsg>Tax service was successful.</RMsg> 
            </ApplicationReply> 
            <ApplicationReply Name="ics_dav"> 
               <RCode>1</RCode> 
               <RFlag>SOK</RFlag> 
               <RMsg>dav service was successful</RMsg> 
            </ApplicationReply> 
         </ApplicationReplies> 
         <PaymentData> 
            <PaymentRequestID>0004899920000167905139</PaymentRequestID> 
            <PaymentProcessor>Paymentech</PaymentProcessor> 
            <Amount>88.96</Amount> 
            <CurrencyCode>USD</CurrencyCode> 
            <TotalTaxAmount>3.15</TotalTaxAmount> 
            <AVSResult>I1</AVSResult> 
            <AVSResultMapped>X</AVSResultMapped> 
            <CVResult>M</CVResult> 
            <ProcessorResponseCode>100</ProcessorResponseCode> 
         </PaymentData> 
         <RiskData> 
            <Factors>U</Factors> 
            <HostSeverity>1</HostSeverity> 
            <Score>7</Score> 
            <TimeLocal>2001-08-16T08:59-07:00</TimeLocal> 
            <ProductRisk>High</ProductRisk> 
            <AppliedThreshold>40</AppliedThreshold> 
            <AppliedTimeHedge>Normal</AppliedTimeHedge> 
            <AppliedVelocityHedge>Low</AppliedVelocityHedge> 
            <AppliedHostHedge>Normal</AppliedHostHedge> 
            <AppliedCategoryGift>N</AppliedCategoryGift> 
            <AppliedCategoryTime>Off</AppliedCategoryTime> 
            <AppliedAVS>X</AppliedAVS> 
            <AppliedCV></AppliedCV> 
         </RiskData> 
      </Request> 
   </Requests> 
</Report>

Sample CSV Reports

Payment Batch Detail Report

The following example shows a report that contains two settlement (ics_bill) transactions and one credit (ics_credit) transaction. 

Payment Batch Detail Report,1.0,2001-08-16 to 2001-08-16,,,,,,, 
batch_id,merchant_id,batch_date,request_id,merchant_ref_number,trans_ref_no,payment_method,currency,amount,application 
123456,CyberSource,2001-08-16,0004172180000167905139,45CBBDE3378A553,5652882910,Visa,USD,100.00,ics_bill 
123456,CyberSource,2001-08-16,0004173790000167905139,5DADC3D2F4B7118,5629152830,Visa,USD,-100.00,ics_credit 
123456,CyberSource,2001-08-16,0004174690000167905139,CBBF93898A39519,5653068690,Visa,USD,100.00,ics_bill

Transaction Detail Report

The following example shows a report for a transaction that includes the ics_auth, ics_dav, ics_score, and ics_tax applications. 

Transaction Detail Report,1.0,2001-08-16 to 2001-08-16,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 
row_descriptor,request_id,transaction_date,merchant_ref_number,merchant_id,ics_applications,auth_rcode,auth_rflag,auth_rmsg,auth_reversal_rcode,auth_reversal_rflag,auth_reversal_rmsg,bill_rcode,bill_rflag,bill_rmsg,credit_rcode,credit_rflag,credit_rmsg,ecp_debit_rcode,ecp_debit_rflag,ecp_debit_rmsg,ecp_credit_rcode,ecp_credit_rflag,ecp_credit_rmsg,score_rcode,score_rflag,score_rmsg,tax_rcode,tax_rflag,tax_rmsg,dav_rcode,dav_rflag,dav_rmsg,export_rcode,export_rflag,export_rmsg,elc_rcode,elc_rflag,elc_rmsg,elc_revoke_rcode,elc_revoke_rflag,elc_revoke_rmsg,download_rcode,download_rflag,download_rmsg,create_isv_rcode,create_isv_rflag,create_isv_rmsg,add_value_to_isv_rcode,add_value_to_isv_rflag,add_value_to_isv_rmsg,get_isv_history_rcode,get_isv_history_rflag,get_isv_history_rmsg,get_isv_info_rcode,get_isv_info_rflag,get_isv_info_rmsg,get_isv_profiles_rcode,get_isv_profiles_rflag,get_isv_profiles_rmsg,modify_isv_rcode,modify_isv_rflag,modify_isv_rmsg,redeem_isv_rcode,redeem_isv_rflag,redeem_isv_rmsg,customer_firstname,customer_lastname,customer_middlename,bill_address1,bill_address2,bill_city,bill_state,bill_zip,bill_country,company_name,customer_email,customer_title,customer_phone,ship_to_address1,ship_to_address2,ship_to_city,ship_to_state,ship_to_zip,ship_to_country,ship_to_phone,customer_ipaddress,account_suffix,customer_cc_expmo,customer_cc_expyr,customer_cc_startmo,customer_cc_startyr,customer_cc_issue_number,payment_method,amount,currency,auth_auth_avs,auth_auth_code,auth_cv_result,shipping_method,score_factors,score_host_severity,score_score_result,score_time_local,customer_hostname,shipping_carrier,customer_password_provided,lost_password,repeat_customer,cookies_accepted,customer_loyalty,customer_promotions,gift_wrap,returns_accepted,customer_id,product_risk,applied_score_threshold,applied_time_hedge,applied_velocity_hedge,applied_host_hedge,applied_category_gift,applied_category_time,avs,cv 
Request,0004223530000167905139,2001-08-16T07:42:03+08:00,3C515C71D48F631,CyberSource,"ics_auth,ics_dav,ics_score,ics_tax",1,SOK,ok,,,,,,,,,,,,,,,,1,SOK,score service was successful,1,SOK,Tax service was successful.,1,SOK,dav service was successful,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,John,Doe,A,1295 Charleston Rd.,,Mountain View,CA,94043,US,CyberSource,icsinfo@cybersource.com,,650-965-6000,1295 Charleston Rd.,,Mountain View,CA,94043,US,650-965-6000,127.0.0.1,1111,12,2009,,,,Visa,88.96,USD,X,123456,M,,U,1,7,2001-08-16T08:59:47+08:00,hostname.cybersource.com,,,,,,,,,,,,40,Normal,Low,Normal,N,Off,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Copyright © 2002 CyberSource Corporation.
TOC PREV NEXT INDEX