Sample Reports
This appendix provides sample reports in XML and CSV formats.
■
Sample XML Reports
■
Sample CSV Reports
Sample XML Reports
Payment Activity Summary Report
 
<?xml version="1.0" ?>
   <PaymentActivitySummary>
   <PurchasesAndRefunds>
   <HierarchyLevel>SampleMerchant (1010210003010001)</HierarchyLevel>    <StartDate>Jun 01 2008</StartDate>
   <EndDate>Jun 30 2008</EndDate>
   <Type>
   <Description>Purchases</Description>
   <SubType>
      <Description>MasterCard</Description>
      <ConveyedTransactionCount />
      <ConveyedAmount>0.00</ConveyedAmount>
      <SettledTransactionCount>9</SettledTransactionCount>
      <SettledAmount>7,523.48</SettledAmount>
   </SubType>
   <SettledSubtotalCount>9</SettledSubtotalCount>
   <SettledSubtotalAmount>7,523.48</SettledSubtotalAmount>
   <ConveyedSubtotalCount>0</ConveyedSubtotalCount>
   <ConveyedSubtotalAmount>0.00</ConveyedSubtotalAmount>
   </Type>
   <Type>
      <Description>Refunds</Description>
   <SubType>
      <Description>MasterCard</Description>
      <ConveyedTransactionCount />
      <ConveyedAmount>0.00</ConveyedAmount>
      <SettledTransactionCount>2</SettledTransactionCount>
      <SettledAmount>(131.34)</SettledAmount>
   </SubType>
      <SettledSubtotalCount>2</SettledSubtotalCount>
      <SettledSubtotalAmount>(131.34)</SettledSubtotalAmount>
      <ConveyedSubtotalCount>0</ConveyedSubtotalCount>
      <ConveyedSubtotalAmount>0.00</ConveyedSubtotalAmount>
   </Type>
   <ConveyedTotalCount>0</ConveyedTotalCount>
   <ConveyedTotalAmount>0.00</ConveyedTotalAmount>
   <SettledTotalCount>11</SettledTotalCount>
   <SettledTotalAmount>7,392.14</SettledTotalAmount>
   </PurchasesAndRefunds>
   <Fees>
   <Type>
   <TotalAmount>0.00</TotalAmount>
   <Description>Interchange & Assessments</Description>
   </Type>
   <TotalAmount>0.00</TotalAmount>
   </Fees>
   <ChargebacksAndRepresentments />
   </PaymentActivitySummary>
Purchase & Refunds Report
 
Fields in red are not applicable to bundled-pricing merchants.
<?xml version="1.0" ?>
 <Report HierarchyLevel="SampleMerchant (10101001)" ReportStartDate="5/7/2008"  ReportEndDate="5/7/2008">
  <Request>
<RequestId>2101105640780167905077</RequestId>
<CYBSMID>SampleMerchantID</CYBSID>
<ProcessorMID>8610000060036</ProcessorMID>
<TransRefNo>11662390036</TransRefNo>
<MerchantRefNo>B221</MerchantRefNo>
<TransactionType>Refunds</TransactionType>
<SubmissionDate>05/06/08</SubmissionDate>
<Amount>100.00</Amount>
<TransactionAmountCurrency>USD</TransactionAmountCurrency>
< PaymentMethod >Visa</PaymentMethod>
<PaymentType>credit card</PaymentType>
<AccountSuffix>6947</ AccountSuffix >
<AuthTransRefNo>8798789798<AuthTransRefNo/>
<AuthDate>05/06/08</AuthDate>
<AuthRequestId> 2101105640780167905077</AuthRequestId>
<AuthAmount>100.00</AuthAmount>
<AuthAmountCurrency>USD</AuthAmountCurrency>
<AuthCode>1</AuthCode >
<AuthResponseCode>1</AuthResponseCode>
<CYBSBatchDateTime>05/06/08 04:49 PM</CYBSBatchDateTime>
<CYBSBatchID>18660000000005104</CYBSCBatchID>
<CardType>41</CardType>
<ChargeType>1041</CardType>
<InterchangeDescription>Sample Text</InterchangeDescription>
<InterchangePercentage>2.1</InterchangePercentage>
<InterchangePercentageAmount>2.00</InterchangePercentageAmount>
<InterchangePerItemFee>0.20</InterchangePerItemFee>
<DuesAssessmentsAmount>2.00</DuesAssessmentsAmount>
<DiscountPercentage>1.0</DiscountPercentage>
<DiscountAmount>0/10</DiscountAmount>
<DiscountPerItemFee>0.10</DiscountPerItemFee>
<TotalFee>3.00</TotalFee>
<FeeCurrency>USD</FeeCurrency>
<MerchantData1/>
<MerchantData2/>
<MerchantData3/>
<MerchantData4/>
  </Request>
</Report>
 
Chargeback & Representment Details Report
 
<?xml version="1.0" ?>
<Report HierarchyLevel="SampleMerchant (10101100015)" ReportStartDate="5/11/2008" ReportEndDate="5/11/2008">
<Request>
<CYBSMID>SampleID</CYBSMID>
<CaptureRequestId>2096628984170167905103</CaptureRequestId>
<ProcessorMID>8600000060034</ProcessorMID>
<CYBSExceptionID>1234</CYBSExceptionID>
<ProcessorCaseID>1234</ProcessorCaseID>
<CBAmountCurrency>USD</CBAmountCurrency>
<CBReasonCode>1</CBReasonCode>
<CBReasonDescription>ABC</CBReasonDescription>
<CBIndicator>01</CBIndicator>
<OriginalCaptureTransRefNumber>2237835840</
<?xml version="1.0" ?>
<Report HierarchyLevel="SampleMerchant (10101100015)" ReportStartDate="5/11/2008" ReportEndDate="5/11/2008">
<Request>
<CYBSMID>SampleID</CYBSMID>
<CaptureRequestId>2096628984170167905103</CaptureRequestId>
<ProcessorMID>8600000060034</ProcessorMID>
<CYBSExceptionID>1234</CYBSExceptionID>
<ProcessorCaseID>1234</ProcessorCaseID>
<CBAmountCurrency>USD</CBAmountCurrency>
<CBReasonCode>1</CBReasonCode>
<CBReasonDescription>ABC</CBReasonDescription>
<CBIndicator>01</CBIndicator>
<OriginalCaptureTransRefNumber>2237835840</
<CBType>1</CBType>
<TransactionType>Purchase</TransactionType>
<CBInitiatedDate>05/01/08</CBInitiatedDate>
<ResponseDate>05/01/08</ResponseDate>
<RepresentmentAmount>10.00</RepresentmentAmount>
<RepresentmentCurrency>USD</RepresentmentCurrency>
<CBStatus>1</CBStatus>
<ARN>123456</ARN>
<OriginalCaptureAmount>30.00</OriginalCaptureAmount>
<OriginalCaptureCurrency>USD</OriginalCaptureCurrency>
<PaymentMethod>Visa</PaymentMethod>
<AccountSuffix>7977</AccountSuffix>
<OriginalCaptureSubmissionDate>05/01/08</OriginalCaptureSubmissionDate>
<CBAmount>30.00</CBAmount>
<FinancialStatus>Y</FinancialStatus>
<OriginalMerchantRefNumber>007</OriginalMerchantRefNumber>
<OriginalAuthTransRefNumber>2237835840</
OriginalCaptureTransRefNumber>
OriginalAuthTransRefNumber>
<OriginalAuthDate>05/01/08</OriginalAuthDate>
<CBExceptionFeeAmount />
<CBExceptionFeeCurrency />
<IssuerMessageText>aaa</IssuerMessageText>
</Request>
</Report>
Transfer Log Report
 
<?xml version="1.0" ?>
<Report HierarchyLevel="SampleMerchant (10102100030)" StartDate="Jun 01 2008" EndDate="Jun 21 2008">
<Request>
<TransferReferenceNumber>103657377000000001</TransferReferenceNumber>
<OriginationDate>6/2/2008</OriginationDate>
<ProcessorMID>8610000060036</ProcessorMID>
<CYBSMID>SampleMerchantID</CYBSMID>
<EffectiveDate>6/3/2008</EffectiveDate>
<Amount>410.65</Amount>
<CurrencyCode>USD</CurrencyCode>
<TypeDescription>Purchase/Refund</TypeDescription>
<HierarchyID>101021000301000210001</HierarchyID>
<MaskedDDA>xxxxxxxx 7717</MaskedDDA>
<RoutingNumber>026012881</RoutingNumber>
<TransferMethod>ACH</TransferMethod>
<Acquirer>CyberSource</Acquirer>
</Request>
</Report>
Chargeback Analysis Report
 
<ChargebackAnalysisReport HierarchyLevel="SampleMerchant (101011000031000110003)" StartDate="Jul 30 2008" EndDate="Jul 30 2008">
<Currency CurrencyCode="USD">
<CardType Description="MasterCard">
<CBReason Code="4387">
<ReasonDescription>this is a test reason code desc</ReasonDescription>
<TransactionCount>2</TransactionCount>
<TransactionVolume>22.00</TransactionVolume>
<PercentageOfTotal>100%</PercentageOfTotal>
</CBReason>
<Totals>
<TotalTransactionCount>2</TotalTransactionCount>
<TotalTransactionVolume>22.00</TotalTransactionVolume>
</Totals>
  </CardType>
  </Currency>
</ChargebackAnalysisReport>
Authorization Analysis Report
 
<AuthorizationAnalysisReport HierarchyLevel="SampleMerchant (1010110000310008)" StartDate="Oct 01 2008" EndDate="Oct 30 2008">
  <Currency CurrencyCode="BRL">
<CardType Description="American Express">
<Reason AuthReasonCode="234">
    <ReasonDescription>Error in CyberSource merchant configuration
    </ReasonDescription>
    <Count>1</Count>
    <Amount>1.00</Amount>
    <PercentageOfTotalCount>100</PercentageOfTotalCount>
    <PercentageOfDeclines>100</PercentageOfDeclines>
</Reason>
<Totals>
<TotalCount>1</TotalCount>
<TotalAmount>1.00</TotalAmount>
</Totals>
</CardType>
  <AllPaymentTypes>
<Reason AuthReasonCode="234">
<ReasonDescription>Error in CyberSource merchant configuration
</ReasonDescription>
<Count>1</Count>
<Amount>1.00</Amount>
<PercentageOfTotalCount>100</PercentageOfTotalCount>
<PercentageOfDeclines>100</PercentageOfDeclines>
</Reason>
  <Totals>
<TotalCount>1</TotalCount>
<TotalAmount>1.00</TotalAmount>
  </Totals>
  </AllPaymentTypes>
  </Currency>
</AuthorizationAnalysisReport>